if i remember correctly....
Spoiler:It plays during the scene where david is remembering his time with his dead wife at the lake. I think it also plays during the credits or near the end of the game.
and yeah, the soundtrack is just so good. Im going to have to buy it at some point.