But, alcohol abuse is estimated to be twice as prevalent in law enforcement (in the U.S. at least) than in the general population.
Alcohol Dementia is caused by long-term or excessive drinking (I don't believe it's long-term drinking, instead long-term unmoderated (excessive) drinking) that causes serious cognitive problems--in fact, 10% of all dementia patients reportedly have a history of prolonged alcohol abuse.
And if you know about dementia / alcohol dementia, that is just as scary a thought, and a much more imminent and likely danger compared to someone "relapsing" from prior LSD use.
Just food for thought.
And, mind you, a person can have a "flash-back" regardless of drug use if it was traumatic--e.g. post-war.