"Music is the one incorporeal entrance into the higher world of knowledge which comprehends mankind but which mankind cannot comprehend." -Ludwig van Beethoven
So, not directly related to fairy tales, but a beautiful quote about the power of music and the supernatural. In general Beethoven was not a fairy taleish guy, so the closest music of his I could find that had anything to do with fairy tales was what we now call his Moonlight Sonata, but what he originally called, "Quasi una fantasia," or "Almost a fantasy."
You'd pretty much have to have lived in a cave not to have heard the famous first movement, above, but the other movements are wonderful too. Below is the much flashier third movement.