NTSB investigations, IA
6 cases where NTSB found Engine fuel and control.
Cases per year
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2018 | 1 |
| 2022 | 2 |
| 2023 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010573'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010573')) 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 ENG23LA030Incident · No injuriesClass 3 · LimitedFinal reportGulfstream Aerospace G-IV · Sioux City, IAA No. 2 (right) engine failure due to a spinner fairing separation and subsequent impact with the fan blades that resulted in a midspan fracture of one fan blade. The spinner fairing separated as a result of a fatigue crack that originated from the heat…NTSB CEN22LA351Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron 206B · Arcadia, IAMaintenance personnel’s failure to properly torque a fuel control unit B-nut, which resulted in a loss of engine power at low altitude and an impact with terrain.NTSB CEN22LA146Accident · Minor injuriesClass 3 · LimitedFinal reportHughes 369 · Adair, IAThe mechanic’s failure to properly torque a fuel control unit B-nut, which resulted in a partial loss of engine power, an attempted autorotation, and an impact with terrain.NTSB CEN18LA278Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Vinton, IALoss of throttle control input due to a failure in the throttle control system. Contributing to the accident was the inadequate inspection and reinstallation of worn parts by maintenance personnel.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 CEN09LA403Accident · Serious injuriesLimited investigationFinal reportAyres S2R-G6 · Ainsworth, IAA component failure of the fuel control unit, which resulted in a loss of engine power.