NTSB investigations, IA
9 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2010 | 1 |
|---|---|
| 2012 | 1 |
| 2013 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2020 | 1 |
| 2024 | 1 |
| 2026 | 1 |
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 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\" = '900' 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 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" = '900' 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 CEN26LA260Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Emerson, IAThe failure of the pilot to verify the loading hose had been disconnected before taking off and the failure of the loader to disconnect the fuel hose from the helicopter.NTSB CEN24LA355Accident · Minor injuriesClass 4 · LimitedFinal reportJust SuperStol · Mount Vernon, IAThe pilot’s failure to maintain airplane control during a go-around which resulted in an aerodynamic stall and collision with terrain.NTSB CEN20LA261Accident · Minor injuriesClass 3 · LimitedFinal reportEnstrom 280 · Des Moines, IAThe partial loss of rotor and engine speed during approach for landing, which resulted in an autorotation and impact with terrain. The reason for the partial loss of rotor and engine speed could not be determined based on the available evidence. Contributing…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 CEN16LA320Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Des Moines, IAThe two separations in the induction system due to improper installation and/or maintenance, which resulted in a partial loss of engine power during initial climb.NTSB CEN13LA500Accident · 1 fatalLimited investigationFinal reportCessna 206 · Brooklyn, IAThe improper routing of the seatbelt, which resulted in the inadvertent deployment of the reserve parachute, and the open jump door, which allowed the passenger to be pulled from the airplane.NTSB CEN13CA238Accident · No injuriesData collectionFinal reportEnstrom F-28C · Lanesboro, IAThe pilot’s failure to maintain control of the helicopter while making an off-airport landing with a gusty tailwind.NTSB CEN12CA607Accident · No injuriesData collectionFinal reportNorth American AT-6F · Council Bluffs, IAAn unlocking of the excessively worn tailwheel lock mechanism, which resulted in a loss of directional control during landing.NTSB CEN10CA349Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Webster, IAThe pilot misjudged his speed and distance during landing, which resulted in an overrun.