The Oscar-winning actor, best known for The French Connection and The Conversation, was found dead alongside his wife