One sport that I find terrifying is rock climbing. I feel that I need to learn it though as it can take you to some stunning places, as Pete Rhodes explains here.