NTSB investigations, 2013, KS
10 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 15 |
|---|---|
| 2009 | 1 |
| 2010 | 5 |
| 2011 | 5 |
| 2012 | 9 |
| 2013 | 10 |
| 2014 | 8 |
| 2015 | 13 |
| 2016 | 12 |
| 2017 | 12 |
| 2018 | 7 |
| 2019 | 14 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 6 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 3 |
| 2026 | 3 |
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\") = 2013
AND c.\"eventStateOrRegion\" = 'KS' 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") = 2013 AND c."eventStateOrRegion" = 'KS' 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 CEN14CA096Accident · Minor injuriesData collectionFinal reportCessna 172K · Concordia, KSThe pilot's failure to maintain a proper glidepath during approach which resulted in the airplane landing long, and his decision to turn off of the runway during the landing roll which resulted in a collision with an earth berm.NTSB CEN14FA009Accident · 2 fatalField investigationFinal reportCessna 500 · Derby, KSThe airplane's encounter with severe icing conditions, which resulted in structural icing, and the pilot's increased workload and subsequent disorientation while maneuvering in instrument flight rules (IFR) conditions with malfunctioning flight instruments,…NTSB CEN13LA514Accident · Minor injuriesLimited investigationFinal reportChallenger II · Emporia, KSThe right wing’s folding up in flight for reasons that could not be determined because an examination did not reveal any abnormalities with the airframe that would have precluded normal operation.NTSB CEN13LA439Accident · 1 fatalLimited investigationFinal reportWoods Rufus III Vans RV-8A · Lucas, KSThe noninstrument-rated pilot's inadvertent entry into instrument meteorological conditions, which resulted in his spatial disorientation and a subsequent loss of airplane control.NTSB CEN13LA346Accident · No injuriesLimited investigationFinal reportRogers T-51 Mustang KIT · St Francis, KSForeign debris in the propeller governor, which led to excessive wear in the governor and its subsequent in-flight failure.NTSB CEN13LA280Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Galena, KSThe loss of engine power due to improper maintenance by an unknown individual that led to the degradation and deterioration of the No. 2 piston, which was undetected because of overdue maintenance.NTSB CEN13CA278Accident · No injuriesData collectionFinal reportBalloon Works Firefly 8B-15 · Anthony, KSThe pilot’s failure to monitor the balloon's altitude, which resulted in the balloon impacting an airport rotating beacon tower.NTSB CEN13LA260Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Lyons, KSThe partial loss of engine power due to fuel contamination, which resulted in impact with terrain. Contributing to the accident was the pilot's inadequate preflight inspection, during which he failed to detect the fuel contamination.NTSB CEN13LA263Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Udall, KSThe pilot's inadequate flight planning, which resulted in a wire strike.NTSB CEN13LA254Accident · Serious injuriesLimited investigationFinal reportMason Robert Kolb Mark 3X · Lawrence, KSThe noncertificated pilot’s improper decision to depart with a tailwind.