NTSB investigations, 2011, IA
4 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2011 | 4 |
| 2013 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2022 | 3 |
| 2023 | 2 |
| 2026 | 2 |
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\") = 2011
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\" = '342' 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" = '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" = '342' 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 CEN11CA532Accident · No injuriesData collectionFinal reportAlon A-2A · Rolfe, IAThe pilot's decision to execute a precautionary landing to unsuitable terrain.NTSB CEN11LA539Accident · Serious injuriesLimited investigationFinal reportHurley Richard A Cavalier SA102.5 · Salem, IAThe partial loss of engine power due to the formation of carburetor ice.NTSB CEN11FA436Accident · 1 fatalField investigationFinal reportRay Aerial Spraying 773 Racer · Ottumwa, IAThe loss of engine power for reasons that could not be determined because postaccident examination of the airplane’s engine and ignition system did not reveal any anomalies that would have precluded normal operation, and extensive postaccident fire damage…NTSB CEN11LA367Accident · Minor injuriesLimited investigationFinal reportJones Cozy Mark IV · Sioux City, IAThe pilot's improper installation of the gascolator gasket during the airplane's last condition inspection, which resulted in a partial loss of engine power while maneuvering.