Here's a story at the AP, about an officer who was apparently intoxicated when he crashed into cars and shot a man in the head on June 6, 2024. From the Associated Press story by Karen Mathews, on October 2, 2024:
According to the lawsuit, Tran’s alcoholism and mental health problems were known to his police superiors and should have disqualified him from serving as an armed officer, but he was nonetheless carrying a department-issued 9mm pistol that he used to shoot Patel.