Six people were killed in a series of shootings believed to have been carried out by a relative who then took his own life when confronted by police.