The Oscar-winning actor, best known for ‘The French Connection’ and ‘The Conversation’, was found dead along with his wife Betsy Arakawa and a pet dog