It was reported that American 191 in ORD had it, and it was on when the plane crashed just after take off. The camera was over the Capts shoulder and the image projected on the movie screen.
It's never been confirmed whether it was on or not. The NTSB report makes no mention of it that I recall, and it's their job to give the full status of an airplane at the time of an accident. The pilots made no mention of it on the CVR tape. As there were no survivors, there's nobody to say first-hand whether it was on. All anybody can do is assume it might have been, although as with United's Channel 9, I believe its use was always up to pilot's discretion.
As for today, I know both ANA and JAL use nosewheel cams on all taxis, takeoffs and landings. Personally, I really dislike it - especially as long as some of those transpacific takeoff rolls are. It can really look like you're headed for the trees! There's no way to get away from it either, short of just closing your eyes - it's on the big screens as well as all the PTV screens throughout the cabin.
I'm tired of being a wanna-be league bowler. I wanna be a league bowler!