Renowned Australian photographer, John Grainger, has been found dead after going missing on Tuesday afternoon in Sydney's Northern Beaches.