Isn't it time airport bars and restaurants stopped selling alcohol, or at least limited sales, to avoid these incidents.
There would be massive protests and some people would stop flying, but they are the type of people the airlines can do without. I feel sorry for flight crews, and for the normal passengers who can have a drink or two and remain correctly behaved, but it is not fair that this behaviour not only blights the experience but more importantly, endangers all on board.