The man had been reported missing and a public appeal was shared by Northumbria Police to help locate him