Sounds like the Tunisair ATR that crashed in the med a few years back (2005?).

I remember hearing the black box tapes and for the last 5 minutes straight they were running checks and/or trying to restart, for the last minute occasionally one of them would say something like "god help me", so I don't see where they would have been "praying" and "panicking".