For Saint Patrick's day when I was in first grade (I'm now in college), our teacher decided to show us this movie in class. I still remember certain scenes vividly because I had awful nightmares for years after watching it. The nastier mythical creatures that come with the leprechauns from Ireland absolutely terrified me. Over the years, I described the movie to friends in an attempt to locate it, but they all met me with blank stares. I finally found it today when I did a google search. I haven't seen this movie since first grade, so I can't comment all that much on it's overall quality or scariness from a more adult perspective. However, I would strongly recommend against showing this movie to children who might be more easily frightened.
Review of Leapin' Leprechauns!
