Five people have died after a single-engine plane crashed as it attempted to make an emergency landing in Nashville, police said.