CCTV footage the night before he went missing