His disappearance sparked a major search involving 100 police officers