NTSB investigations, KY
29 cases where NTSB found Fluids/misc hardware.
Cases per year
| 2008 | 3 |
|---|---|
| 2010 | 3 |
| 2012 | 4 |
| 2013 | 1 |
| 2015 | 3 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 4 |
| 2020 | 2 |
| 2021 | 2 |
| 2024 | 1 |
| 2025 | 3 |
| 2026 | 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\" = 'KY' 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\", '0107'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0107')) 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 ERA26LA181Accident · No injuriesClass 4 · LimitedFinal reportAeroprakt Mfg SP Z O O A32 · Lexington, KYThe flight instructor’s improper in-flight fuel management, which resulted in fuel starvation, a total loss of engine power, and a forced landing to rough terrain.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 ERA25LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna TP206C · Versailles, KYThe pilot’s mismanagement of the airplane’s available fuel supply, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB ERA24LA109Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Louisville, KYThe failure of maintenance personnel to thoroughly inspect and repair the worn-out panel fasteners and fastener holes.NTSB ERA21LA338Accident · No injuriesClass 3 · LimitedFinal reportSchmitt Just Acft Highlander · Crittenden, KYThe pilot’s inadequate fuel planning, which resulted in fuel starvation and a total loss of engine power.NTSB ERA21FA229Accident · 1 fatalClass 3 · FieldFinal reportMunson Roger J RV-8 · Van Cleve, KYA loss of engine power due to loss of engine oil pressure.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 ERA20LA069Accident · Serious injuriesClass 3 · LimitedFinal reportGlassair I · Mount Sterling, KYThe pilot’s mismanagement of the fuel selector, which resulted in fuel starvation and a total loss of engine power.NTSB ERA20LA039Accident · No injuriesClass 3 · LimitedFinal reportRans Rans S7 Courier · West Liberty, KYThe pilot's failure to verify that the engine oil tank contained adequate oil for the cross-country flight, which resulted in a total loss of engine power as a result of lack of lubrication. Contributing to the accident was the incorrect oil consumption…NTSB ERA20FA026Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Paducah, KYThe pilot’s failure to fully seat the fuel selector in the proper tank position during the descent for landing, which resulted in fuel starvation and a total loss of engine power.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 ERA19LA083Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Lexington, KYThe pilot's improper slip maneuver on final approach, which resulted in a total loss of engine power.NTSB GAA18CA307Accident · No injuriesData collectionFinal reportPiper PA28 · Butler, KYThe pilot’s improper fuel management, which resulted in fuel starvation.NTSB ERA16FA248Accident · 1 fatalField investigationFinal reportBell Helicopter Textron Canada 407 · Hickory, KYCompany maintenance personnel's inappropriate removal without replacement of the safety wires on the collective lever pin screws during a recent maintenance inspection, which resulted in the screws backing out and led to a loss of collective control in flight.NTSB ERA16LA062Accident · No injuriesLimited investigationFinal reportBeech D35 · Vine Grove, KYThe pilot’s failure to ensure that the fuel selector was properly positioned before takeoff, which resulted in the subsequent total loss of engine power due to fuel starvation.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 ERA15FA088Accident · 4 fatalField investigationFinal reportPiper PA34 · Kuttawa, KYThe pilot's failure to properly set the left engine fuel selector before takeoff and to recognize the incorrect setting during the flight, which resulted in fuel starvation and a loss of engine power on both engines.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 ERA13LA058Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lexington, KYThe rupture of the landing gear’s hydraulic pressure hose, which resulted in the depletion of all of the hydraulic fluid, and the inability of the landing gear to raise or lower. Contributing to the accident was the installation of an unapproved hydraulic…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 ERA12FA280Accident · 1 fatalField investigationFinal reportManzitto Michael A Mwlancair 235 · Hudson, KYThe pilot's decision to operate the airplane with known electrical system problems, which resulted in the in-flight failure of the electrical wiring interconnect system, loss of electrical power, and subsequent fuel starvation and loss of engine power.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 ERA10CA353Accident · No injuriesData collectionFinal reportLawwill Ted Zodiac 601XL · Waddy, KYA loss of engine power due to fuel starvation for undetermined reasons.NTSB ERA10FA148Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Springfield, KYThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…NTSB NYC08LA317Accident · Serious injuriesLimited investigationFinal reportSorrell Skybolt · Williamstown, KYA loss of engine power due to oil starvation as a result of improper servicing (removal of preserving fluid) of the engine after it had been returned from storage.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.NTSB MIA08FA122Accident · 1 fatalField investigationFinal reportYates Lancair IV-P · Springfield, KYA total loss of engine power due to a loss of engine oil as a result of the installation of the wrong oil adapter O-ring seal.