Everybody can make a bad judgement call, so I would impose a fine/temporary ban on first airborne offence as long as it didn't put the aircraft in danger.
Second offence. Complete worldwide ban on flying for life.
I don't drink, but it would be unfair to spoil peoples pleasure by banning...