That's hard because what one person might find terrifying, someone else might find it to be complete rubbish.
I haven't found a film that has truly terrified me and i've seen ALOT of horror movies.
My favourite though is 'The Descent'...it tackles claustrophobia, being trapped, the dark and the fear of something lurking in a cave that wants to kill you.