I don't know about the stories of failures, but you can view the list of yc companies at http://yclist.com/ it shows the status of some companies as Dead.
Shows that if you are on the YC rocketship, you either go big and get acquired or die out trying.