Whats the longest time a person can go without sleep, im NOT talking about the world record, but like a teenager trying to stay up, how long before you just collapse?

Also is it true you go insane if you go to long without sleep or you just die from other stuff without sleep?