The drummer was last seen in a video he sent his mother on that Saturday morning, October 7