Out of many thousands of pilots, you are going back a long way to dredge up those few incidents. It doesn't happen anymore- there have been examples set and rules introduced, and a cold wind of righteousness now blows. People will not fly with other pilots inebriated.