A retired NYPD detective fatally shot his wife, then turned the gun on himself in an apparent murder-suicide while their three kids were in their Westchester County home, police said Wednesday.