Sounds like the ending of Cop Land...
http://www.cnn.com/2009/CRIME/07/16/nj.cops.shot/index.html
Great movie, though I still don't know why Stallone didn't just take the kid over to Manhattan the moment he found him versus waiting until the morning.