Flying with a dog in cabin vs cargo
Avoid Cargo.
Cargo is stressful and dangerous (temp fluctuations). If dog is small enough for cabin (under seat), it's safe. Otherwise, drive if possible.
Sedation
Most airlines forbid sedating dogs as it affects breathing at altitude.