A member of the Mexico City mounted police shot dead his wife and three children before trying to kill himself with a shot to the head.