Police found five people dead from gunshots, including three children and the alleged shooter, in a case described as “an unspeakable tragedy.”