A new study claims that the risk of killer asteroids hitting Earth is unlikely in the next 1,000 years, but small ones still pose a threat.