There hasn’t been a shortage of off-duty cops who get belligerent in local bars and pull their service weapon on the bouncer who’s throwing them out. (What really sucks is that said bouncers find themselves being prosecuted after putting a one-punch TKO on the cop and disarming his drunk ass.)
This also has a tendency to happen at house parties where the homeowner decides that the drunk cop has had enough and needs to take it on down the road.