Generally there are no pilots who drink before a flight. All airline carry out spot tests, and pilots who fail will at the very least be suspended. Many airline have a zero tolerance policy, and will kick a pilot out if they test positive. Too high a risk for most pilots