Pilots being drunk in the cockpit is not “quite common” at least among major carriers. Pilots are randomly tested throughout the year against a stricter standard than what’s used for driving under the influence in the US. A positive test can be career ending.

And then there's the stereotype that they're on stimulants a la Denzel Washington in "Flight"