We would not call this ride scary, but it is a roller coaster and can feel intense for little ones. Try other roller coasters first, like Casey Jr, to see how they react. If they have already enjoyed rides like The Barnstormer, you can bring them here and they will not be scared.
