NTSB investigations, KY
13 cases where the sequence of events included Fuel exhaustion.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2012 | 2 |
| 2013 | 1 |
| 2015 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2025 | 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 c.\"eventStateOrRegion\" = 'KY' 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" = 'KY' 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 ERA26LA018Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177 · Cynthiana, KYThe pilot's inadequate fuel planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a forced landing. Contributing to the accident was the impact with powerlines during final approach.NTSB ERA25LA299Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Fordsville, KYThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a subsequent forced landing.NTSB ERA21LA228Accident · Minor injuriesClass 4 · LimitedFinal reportRobert Trembly JA20 Highlander · Central City, KYThe pilot’s failure to properly secure the left wing fuel cap before flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA20LA245Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Falmouth, KYThe pilot’s failure to ensure that an adequate supply of fuel was available for the flight, which resulted in total loss of engine power due to fuel exhaustion.NTSB ERA19FA155Accident · 2 fatalClass 2 · FieldFinal reportBellanca 1730 · Henderson, KYThe student pilot's failure to maintain proper airspeed, which resulted in the exceedance of the airplane's critical angle of attack at a low altitude, in the airport traffic pattern, following a total loss of engine power due to fuel exhaustion. Contributing…NTSB ERA15CA272Accident · Minor injuriesData collectionFinal reportSmith Steen Skybolt · Junction City, KYThe pilot's inaccurate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA13CA107Accident · No injuriesData collectionFinal reportBrewer James M KR2 · Bear Branch, KYThe pilot’s improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot’s lack of knowledge about the airplane’s total fuel capacity and fuel quantity instrumentation.NTSB ERA12LA294Accident · No injuriesLimited investigationFinal reportCessna 172R · Richmond, KYA total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight instructor’s failure to supervise the student’s preflight inspection, his inadequate fuel management and preflight and in-flight fuel planning, and the operator’s…NTSB ERA12LA224Accident · Serious injuriesLimited investigationFinal reportCessna T210J · Rabbit Hash, KYThe pilot's inadequate preflight and in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA11CA013Accident · Minor injuriesData collectionFinal reportPiper PA28 · Louisville, KYThe pilot's inadequate preflight fuel planning, which resulted in fuel exhaustion and loss of engine power.NTSB ERA10CA214Accident · Serious injuriesData collectionFinal reportPiper PA28 · Louisville, KYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB ERA09CA426Accident · No injuriesData collectionFinal reportCessna 150M · Lexington, KYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel manangement.NTSB MIA08LA180Accident · No injuriesLimited investigationFinal reportCessna 182A · Elizabethtown, KYA loss of engine power due to fuel exhaustion. Contributing to the accident was pressure from the company for the pilot to fly the second load of skydivers without refueling.