The reveal - explaining of how the events occurred - is often the most rewarding part of a locked room mystery or impossible crimes story. The key to an edifying ending is ensuring the method is both ingenious and feasible. While there have been a huge variety of solutions proposed by the multitude of authors operating within the genre, very few have been replicated in reality.
As with any fiction, the methodologies don't have to have happened to be creditable. The audience just have to believe that they
could happen. Maintaining realism is key to keeping the reader engaged with the story - if the world of the story operates within the same laws as our world we have a fair chance of figuring out the solution prior to the reveal.
Perhaps it is the somewhat contrived nature of the genre that means crimes are rarely attempted outside of fiction. Stories tend to overcomplicate what could more easily be accomplished in an attempt to provide the reader with a fulfilling story.
That being said, there are a few impossible crime stories that have striking similarities to real life events.
"Truth is always strange; stranger than fiction." - Lord Byron
(Spoilers below)
The Duel of Shadows by Vincent Cornier
The Duel of Shadows is a short story, originally published in Pearson's Magazine in 1934. Written by Vincent Cornier, it covers the inexplicable shooting of Henry Leonard Westmacott who was seemingly attacked by an invisible assailant while dozing in an armchair.