NTSB investigations, 2011, CO
22 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 28 |
|---|---|
| 2009 | 13 |
| 2010 | 9 |
| 2011 | 22 |
| 2012 | 18 |
| 2013 | 16 |
| 2014 | 22 |
| 2015 | 15 |
| 2016 | 12 |
| 2017 | 15 |
| 2018 | 17 |
| 2019 | 14 |
| 2020 | 15 |
| 2021 | 10 |
| 2022 | 9 |
| 2023 | 5 |
| 2024 | 10 |
| 2025 | 9 |
| 2026 | 7 |
Where
Latest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 2011
AND c.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 2011 AND c."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN12FA058Accident · 1 fatalField investigationFinal reportCessna 337G · Alamosa, COThe loss of power to the rear engine due to fuel starvation during takeoff, which resulted from the fuel selector valve being inadvertently moved to the “off” position, and resulted in the airplane’s inability to climb.NTSB CEN12CA011Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Englewood, COThe student pilot's improper flare, which resulted in a bounced landing from which he was unable to recover.NTSB CEN12CA005Accident · No injuriesData collectionFinal reportCampbell John Mustang II · Brush, COThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.NTSB CEN11CA662Accident · No injuriesData collectionFinal reportPiper PA-30 · Saguache, COThe pilot's failure to maintain airplane control during the aborted takeoff.NTSB CEN11CA620Accident · No injuriesData collectionFinal reportCessna T210M · Kremmling, COThe pilot's failure to maintain aircraft control during the landing.NTSB CEN11FA572Accident · Serious injuriesField investigationFinal reportFerguson Fergy 1 · Falcon, COA loss of control for undetermined reasons.NTSB CEN11CA511Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Broomfield, COA loss of control due to the pilot's diverted attention as a result of an open door.NTSB CEN11CA485Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Greeley, COThe pilot's loss of directional control during landing, resulting in a runway excursion.NTSB CEN11FA479Accident · 2 fatalField investigationFinal reportCessna 150L · Silverton, COThe pilot's failure to maintain control of the airplane while operating it at low levels above mountainous terrain and in excess of its maximum allowable gross weight, which resulted in an aerodynamic stall. The pilot's failure to maintain control resulted…NTSB CEN11LA490Accident · No injuriesLimited investigationFinal reportDarrow Stephen AL-6 · Peyton, COThe loss of engine power during the descent for reasons that could not be determined because a thorough examination of the engine could not be completed due to the remote accident site.NTSB CEN11FA444Accident · 1 fatalField investigationFinal reportBoeing B75N1 · Wetmore, COThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.NTSB CEN11FA346Accident · 1 fatalField investigationFinal reportHansen IB C Cassutt III M · Erie, COThe pilot's incapacitation due to a cardiac event.NTSB CEN11CA325Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Golden, COThe pilot’s decision to operate the helicopter at a high density altitude near terrain, which resulted in a settling with power condition.NTSB CEN11FA304Accident · 2 fatalField investigationFinal reportCubcrafters CC11-160 · Parker, COThe pilot’s excessive and unsafe maneuvering during gusty wind conditions, which resulted in an inadvertent stall-spin.NTSB CEN11CA284Accident · No injuriesData collectionFinal reportPiper PA38 · Peyton, COThe pilot's loss of directional control during landing.NTSB CEN11CA289Accident · Minor injuriesData collectionFinal reportRans S12 · Fort Collins, COThe pilot's inadvertent application of full right rudder during landing, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN11LA266Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wellington, COThe certified flight instructor's failure to maintain directional control during the go-around.NTSB CEN11FA259Accident · 1 fatalField investigationFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Boulder, COThe pilot's incapacitation for undetermined reasons, which resulted in a loss of control.NTSB CEN11LA239Accident · 1 fatalLimited investigationFinal reportGlasflugel Standard Libelle · Wellington, COThe pilot's loss of glider control due to impairment or incapacitation caused by an episode of ventricular tachycardia.NTSB CEN11LA164Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Bennett, COThe pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.NTSB CEN11CA170Accident · No injuriesData collectionFinal reportCessna 182 · Meeker, COThe pilot’s loss of directional control while taxiing due to his improper seat position.NTSB CEN11FA150Accident · 2 fatalField investigationFinal reportPiper PA 46-350P · Westcliffe, COThe pilot's loss of control following an encounter with moderate to severe weather.