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.