Fatal NTSB investigations, ID
7 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 2001 | 1 |
| 2007 | 1 |
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 c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353)
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" = 'ID' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353) 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 SEA07FA061Accident · 1 fatalField investigationFinal reportCessna T210R · Rexburg, IDThe loss of engine power due to the contamination of the fuel manifold valve, and the pilot's continued operation of the airplane with known maintenance discrepancies.NTSB SEA02FA007Accident · 2 fatalField investigationFinal reportCessna TR182 · Dixie, IDThe pilot's failure to refuel en route resulting in fuel exhaustion, and his inadvertent entry into a stall condition during the emergency descent. Contributing factors were dark night conditions and mountainous/hilly terrain.NTSB SEA94FA062Accident · 1 fatalField investigationFinal reportCessna T210N II · Emmett, IDAn inadvertent stall. Factors contributing to the accident were fuel exhaustion and the tailwind.NTSB SEA91FA175Accident · 1 fatalField investigationFinal reportCessna TU206G · Mccall, IDProcedures/directives were not followed. Factors to the accident were: improper fuel boost pump selector position, leaded spark plugs and sunglare.NTSB SEA85FA225Accident · 3 fatalField investigationFinal reportCessna 177BII · Lolo Pass, IDThe plt failed to visually check the fuel tanks during preflt and departed with 3.4 hours flown on the pre-existing fuel supply. Fuel exhaustion occurred 1.2 hours into the flt. The plt overflew a suitable forced landing site and attempted a last minute turn…NTSB SEA84FA020Accident · 1 fatalField investigationFinal reportJodel-Bernier Jodel F-11 · Inkom, IDThe acft crashed during a forced landing attempt after the engine quit. The pilot reported the engine stopped while in cruise flt. It started and stopped and started a 2nd time but would not maintain flt. The pilot turned toward a hayfieldfor landing. The…NTSB SEA82FA122Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · 10 Nm E. Of Ken, IDThe plt declared an emergency & reported out of fuel. While approaching a field the plt observed a power/telephone line in his flt path & instinctively pulled the nose up. On-scene examination revealed no evidence of fuel.