He was believed to have been intending to go rock climbing before he was reported missing on Wednesday, August 5