A man believed to have shot dead his wife, her sister and three of her children, killed himself after police forced their way into the home where he had fled.