i don't have a carnage story for you, but i had that setup on my commuter for a while witha front brake, well, i used a lighter formula of locktite due to availability and started slowing down as i approached a three-way intersection, the lockring and cog decided to unscrew, the cog wedged itself inbetween the hub and frame, the chain locked up, i got a nice scratch on my crank from the chain jumping and my rear tire locked up. luckily i was going pretty slow and the roads were wet and semi-iced.
so i just slid on my rear tire for a few feet.
got it fixed up again and went on my way,