NTSB investigations, ID
10 cases where the sequence of events included Fuel exhaustion.
Cases per year
| 2009 | 4 |
|---|---|
| 2013 | 1 |
| 2015 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 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\" = 'ID' 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\" = '192' 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" = 'ID' 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" = '192' 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 WPR23LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Lewiston, IDThe flight instructor’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR21LA293Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28A · Mountain Home, IDThe pilot's improper fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent hard landing on uneven terrain.NTSB WPR20FA015Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · American Falls, IDThe pilot’s failure to ensure adequate fuel onboard and his subsequent failure to maintain airspeed while maneuvering which resulted in an aerodynamic stall following a total loss of engine power due to fuel exhaustion. Contributing to the accident was the…NTSB WPR15LA237Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · American Falls, IDThe low flight time pilot's inadequate in-flight fuel planning, which resulted in fuel exhaustion, a loss of engine power, and an off-airport landing in rough terrain.NTSB GAA15CA164Accident · Minor injuriesData collectionFinal reportPiper PA 18-135 · Twin Falls, IDThe pilot's inadequate fuel inspection during his preflight fuel performance planning task, resulting in fuel exhaustion en route, and an emergency landing and collision with terrain.NTSB WPR13LA416Accident · Serious injuriesLimited investigationFinal reportBeech C90 - A · Idaho Falls, IDThe pilot's inadequate preflight fuel planning, which resulted in departure with insufficient fuel to complete the flight, and consequent inflight power loss due to fuel exhaustion.NTSB WPR09LA396Accident · Minor injuriesLimited investigationFinal reportBeech A60 · Minidoka, IDA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB WPR09CA315Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Preston, IDA loss of engine power due to fuel exhaustion that resulted from the pilot's inadequate fuel planning.NTSB WPR09CA305Accident · Minor injuriesData collectionFinal reportCessna 172M · McCall, IDA total loss of engine power during descent due to fuel exhaustion as a result of the pilot's failure to determine the fuel quantity prior to departure.NTSB WPR09CA181Accident · No injuriesData collectionFinal reportMax A Boesiger Jr Pulsar · Riddle, IDA loss of engine power due to fuel exhaustion as a result of the pilot's becoming lost and disoriented. Contributing to the accident was fatigue, as reported by the pilot.