Warning: Does not actually mention how to tell when a startup has failed.
I was imagining a combination of metrics (and a heavy use of the Crunchbase API) that would allow you to guess their burn rate and cash remaining. Could be pretty cool. Maybe someone wants to build it?
I didn't read the article, though.