The show looks into the thrills and spills that attract millions of visitors each year, but also reveals how things can sometimes go terribly wrong