NTSB investigations, 2017, IA
11 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 9 |
| 2010 | 13 |
| 2011 | 14 |
| 2012 | 7 |
| 2013 | 4 |
| 2014 | 3 |
| 2015 | 10 |
| 2016 | 9 |
| 2017 | 11 |
| 2018 | 4 |
| 2019 | 5 |
| 2020 | 5 |
| 2021 | 4 |
| 2022 | 5 |
| 2023 | 3 |
| 2025 | 1 |
| 2026 | 3 |
Where
Open the mapLatest 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\") = 2017
AND c.\"eventStateOrRegion\" = 'IA' 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") = 2017 AND c."eventStateOrRegion" = 'IA' 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 CEN18FA060Accident · 1 fatalField investigationFinal reportX-Air XA85 · Oskaloosa, IAThe pilot's low altitude flight into a power line due to his impairment from an acute physiologic event during the flight. Contributing to the pilot's impairment was his use of two sedating medications.NTSB CEN18LA051Accident · No injuriesLimited investigationFinal reportCessna 172C · Algona, IAThe No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power.NTSB GAA17CA433Accident · No injuriesData collectionFinal reportStinson SR9 · Bode, IAThe pilot’s decision to take off from an unimproved bean field with insufficient length for the airplane to clear adjacent corn stalks.NTSB CEN17CA346Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Logan, IAThe pilot’s failure to maintain clearance from a wire during an agricultural application flight.NTSB CEN17LA263Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Corydon, IAA total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.NTSB GAA17CA578Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC41 · Eagle Grove, IAThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB CEN17FA249Accident · 1 fatalField investigationFinal reportFlight Design Ctsw · Monticello, IAThe pilot's decision to fly with his large dog in the two-seat, light sport airplane, and the dog's likely contact with the flight controls during landing, which resulted in the pilot's loss of airplane control and a subsequent aerodynamic stall when the…NTSB GAA17CA338Accident · No injuriesData collectionFinal reportPiper PA 28 · Estherville, IAThe student pilot's failure to maintain crosswind correction during a go-around in gusting wind conditions.NTSB GAA17CA317Accident · No injuriesData collectionFinal reportCessna 177 · Guttenberg, IAThe pilot’s failure to maintain an adequate approach path, which resulted in the left wing impacting a street sign.NTSB CEN17LA156Accident · No injuriesLimited investigationFinal reportLoomis Xenon 4 · Knoxville, IAA partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.NTSB CEN17FA147Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Oxford, IAThe failure of the pilot receiving instruction to recover from the practice stall before the airplane entered a spin and the flight instructor's inadequate monitoring of the pilot receiving instruction and delayed remedial action to recover the airplane.