NTSB investigations, KY
33 cases where NTSB found Physical environment.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 3 |
| 2020 | 2 |
| 2023 | 1 |
| 2025 | 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\", '0302'))
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", '0302')) 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 ERA25LA240Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Hawesville, KYThe pilot’s failure to maintain clearance from power lines during low-level agricultural spray operations.NTSB CEN23LA387Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Henderson, KYAn in-flight collision with a bird shortly after takeoff.NTSB WPR20CA160Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7ECA · Vine Grove, KYAircraft control was not maintained during initial climb with gusting wind that resulted in a collision with power lines and the terrain.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 GAA20CA023Accident · No injuriesData collectionFinal reportCessna 172 · Louisville, KYThe student pilot's improper landing flare, which resulted in a porpoised landing, a subsequent hard landing on grass left of the runway, and a nose-over. Contributing to the accident was the student’s self-imposed pressure to land the airplaneNTSB GAA19CA472Accident · No injuriesData collectionFinal reportCessna 172 · Mt. Sterling, KYThe pilot's loss of directional control during the takeoff roll due to distraction by the passenger window being unsecured, which resulted in a runway excursion and impact with a runway distance marker. Contributing to the accident was pilot’s failure to…NTSB CEN19LA184Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Vine Grove, KYThe pilot’s failure to maintain a proper visual lookout during the approach, which resulted in inadequate clearance from a tree.NTSB GAA18CA532Accident · No injuriesData collectionFinal reportCessna 206 · London, KYThe pilot’s failure to maintain directional control during takeoff with a tailwind.NTSB GAA18CA307Accident · No injuriesData collectionFinal reportPiper PA28 · Butler, KYThe pilot’s improper fuel management, which resulted in fuel starvation.NTSB GAA18CA139Accident · No injuriesData collectionFinal reportCessna 402 · Mount Sterling, KYThe pilot’s failure to maintain directional control during the landing roll on a wet surface.NTSB GAA17CA488Accident · Minor injuriesData collectionFinal reportCharles D Walker Walker Curtiss JN4D · Bowling Green, KYThe pilot’s exceedance of the biplane’s critical angle of attack during initial climb, which resulted in an aerodynamic stall and collision with trees.NTSB ERA17LA268Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Mount Sterling, KYA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA17CA393Accident · No injuriesData collectionFinal reportBell 206 · Dixon, KYThe pilot’s failure to see and avoid power lines while maneuvering at a low altitude. Contributing to the accident was the pilot’s failure to adequately identify hazards to flight during agricultural application operation planning.NTSB GAA17CA402Accident · No injuriesData collectionFinal reportBell 206 · Uniontown, KYThe pilot's failure to maintain adequate separation from power lines, which resulted in a loss of helicopter control.NTSB ERA16CA290Accident · Serious injuriesData collectionFinal reportKessinger Roger L Rans Coyote · London, KYThe student pilot's improper recovery from a bounced landing and his subsequent failure to maintain clearance from trees during an attempted go-around.NTSB GAA16CA373Accident · No injuriesData collectionFinal reportCanadian Car & Foundry Harvard · Somerset, KYThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with an airport sign.NTSB ERA16LA254Accident · Serious injuriesLimited investigationFinal reportBuckeye Dream Machine · Hartford, KYA partial loss of engine power for reasons that could not be determined and the pilot’s failure to maintain directional control during the aborted takeoff.NTSB GAA16CA220Accident · No injuriesData collectionFinal reportCessna 172 · Richmond, KYThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with tree(s).NTSB GAA15CA229Accident · No injuriesData collectionFinal reportMckinney Charles R Searey · Augusta, KYThe amphibious airplane's impact with a submerged object during a water landing, which resulted in a nose over.NTSB ERA15LA304Accident · No injuriesLimited investigationFinal reportBoard James A Zenith 601 HD · Danville, KYThe pilot's improper adjustment of the propeller blade angle, which resulted in inadequate engine thrust, and his decision to continue the takeoff despite the excessively long takeoff roll.NTSB ERA15LA134Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lexington, KYMaintenance personnel's failure to properly inspect and clean the engine ignition harness spark plug terminals, which resulted in a partial loss of engine power during an attempted takeoff.NTSB ERA14CA407Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Taylorsville, KYThe pilot's decision to land on a wet runway and delayed go-around attempt, which resulted in a collision with terrain.NTSB ERA13TA341Accident · Serious injuriesFinal reportMcdonnell Douglas Helicopter 369E · Jackson, KYThe helicopter pilot's inadvertent collision with an unmarked and uncharted utility wire of which he was unaware.NTSB ERA13LA279Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Louisville, KYThe pilot's failure to set the correct flap position before takeoff and his inadequate preflight planning, which resulted in the operation of the airplane over the maximum allowable gross weight, both of which led to an aerodynamic stall at too low an…NTSB ERA13LA236Accident · No injuriesLimited investigationFinal reportBell 206B · Hartford, KYThe pilot’s failure to avoid a powerline that crossed a field that he was spraying. Contributing to the collision was the company’s failure to specifically mention that flight hazards be identified during a pre-work conference.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 ERA12CA462Accident · Serious injuriesData collectionFinal reportInfinity Infinity 2003 · Wilmore, KYA loss of lift on initial climb for unreported reasons, which resulted in a collision with trees and the ground.NTSB ERA11FA218Accident · 2 fatalField investigationFinal reportCessna 310R · Pikeville, KYThe pilot's flight below the published minimum descent altitude in instrument meteorological conditions, which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's use of nighttime cold medication at doses above…NTSB ERA11CA007Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Taylorsville, KYThe pilot’s failure to maintain clearance from an unmarked power line during the final approach to land.NTSB ERA10LA348Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 · Marion, KYThe pilot's failure to maintain clearance from power lines during an aerial application flight.NTSB ERA09LA372Accident · No injuriesLimited investigationFinal reportCessna 172D · Shepherdsville, KYThe mechanic's improper inspection of the mixture control cable.NTSB ERA09LA114Accident · No injuriesLimited investigationFinal reportJohnson Barron T Lancair 360 · Owensboro, KYThe loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector valve cotter pin and the inoperative main (center) fuel tank gauge.NTSB MIA08CA145Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Greensburg, KYThe pilot's failure to maintain clearance from trees while maneuvering. Contributing to the accident was the low altitude maneuvers.