NTSB investigations, KY
103 cases where NTSB found Aircraft oper/perf/capability.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 6 |
| 2010 | 8 |
| 2011 | 5 |
| 2012 | 6 |
| 2013 | 5 |
| 2014 | 4 |
| 2015 | 3 |
| 2016 | 7 |
| 2017 | 7 |
| 2018 | 3 |
| 2019 | 7 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 10 |
| 2023 | 5 |
| 2024 | 6 |
| 2025 | 6 |
| 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\", '0106'))
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", '0106')) 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 ERA26LA259Accident · Serious injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Hickman, KYThe pilot’s failure to maintain a proper glide path, which resulted in a runway undershoot.NTSB ERA26LA042Accident · No injuriesClass 4 · LimitedFinal reportArion Lightning LS-1 · Bowling Green, KYThe pilot's loss of directional control while landing in a strong quartering headwind, which resulted in a runway excursion and collision with an airport sign.NTSB ERA25LA359Accident · No injuriesClass 4 · LimitedFinal reportEdwin Miller Calidus · Hopkinsville, KYThe pilot’s failure to maintain control of the gyroplane, which resulted in dynamic rollover and impact with terrain.NTSB ERA25LA271Accident · No injuriesClass 4 · LimitedFinal reportRohrer Douglas D Vans RV-14A · Bowling Green, KYThe pilot’s failure to attain an appropriate touchdown point during landing, which resulted in a runway overrun and collision with a fence.NTSB ERA25LA257Accident · No injuriesClass 4 · LimitedFinal reportYates Tom W Kitfox III · Greenville, KYThe pilot’s loss of control during takeoff.NTSB ERA25LA255Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer 269C · Madisonville, KYThe pilot’s failure to take the appropriate corrective action for ground resonance, which resulted in a loss of helicopter control.NTSB ERA25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Mayfield, KYThe student pilot’s improper landing flare, which resulted in a hard landing and nose landing gear collapse.NTSB ERA25LA038Accident · No injuriesClass 4 · LimitedFinal reportDeneal Daniel W Vans RV6A · Taylorsville, KYA nose landing gear collapse following a bounced landing.NTSB DCA25LA015Accident · No injuriesClass 4 · LimitedFinal reportAirbus A300 F4-622R · Louisville, KYThe pilot’s incorrect pitch attitude during a bounced landing which resulted in a tailstrike.NTSB ERA25LA023Accident · 2 fatalClass 3 · LimitedFinal reportBuckeye Dream Machine · Nicholasville, KYThe pilot’s loss of control in flight, which resulted in a collision with terrain.NTSB ERA25LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Louisville, KYThe pilot’s improper landing flare and control inputs, which resulted in a hard landing. Contributing was the flight instructor’s delayed remedial action.NTSB ERA24LA352Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Danville, KYThe pilot’s failure to maintain control of the airplane while landing and his inadequate communication to the pilot-rated passenger of her role during the flight.NTSB ERA24LA236Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Gilbertsville, KYThe pilot's failure to maintain control of the helicopter while attempting to take off from sloping terrain.NTSB ERA24LA039Accident · No injuriesClass 4 · LimitedFinal reportGaulden William D Vans RV-4 · London, KYThe pilot’s inadvertent application of nose down pitch trim during the attempted aborted landing, which resulted in abnormal contact with the runway.NTSB ERA24LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Tompkinsville, KYThe pilot's failure to maintain adequate airspeed during the approach, which resulted in a hard landing.NTSB ERA24LA004Accident · No injuriesClass 4 · LimitedFinal reportMichael J Wright SA300 · Georgetown, KYThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting a gusting crosswind, resulting in a runway excursion and nose over.NTSB ERA23LA199Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Somerset, KYThe pilot’s failure to maintain control of the airplane during the takeoff, which resulted in a runway excursion and collision with an airport navigation antenna.NTSB ERA23LA105Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Paris, KYThe pilot’s loss of control after encountering changing wind conditions during the initial climb, which resulted in descent and collision with terrain.NTSB ERA22LA436Accident · No injuriesClass 4 · LimitedFinal reportPiper PA60 · Richmond, KYThe pilot’s failure to extend the landing gear prior to landing.NTSB ERA22FA397Accident · 1 fatalClass 3 · FieldFinal reportRotorway Jetexec · Arthur, KYThe pilot’s decision to attempt the cross-country flight in thunderstorm conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s failure to obtain a weather briefing.NTSB ERA22FA354Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Cynthiana, KYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while maneuvering to land with approaching convective activity.NTSB ERA22LA294Accident · Serious injuriesClass 3 · LimitedFinal reportBucker BU-133 · Hartford, KYThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall during an attempted return to the runway.NTSB ERA22LA280Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Owensboro, KYThe student pilot's improper flare, which resulted in a loss of control during landing.NTSB ERA22LA225Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Owensboro, KYThe pilot's failure to maintain directional control during takeoff.NTSB ERA22LA221Accident · No injuriesClass 4 · LimitedFinal reportKyle M Sward / Larry W Sward CH 750 Cruzer · Lexington, KYThe pilot's failure to maintain directional control during landing.NTSB ERA22LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna T182T · Hazard, KYThe pilot's loss of directional control while landing, which resulted in a runway excursion.NTSB ERA22LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Louisville, KYThe pilot’s failure to maintain directional control during landing in cross wind conditions.NTSB ERA22LA129Accident · No injuriesClass 4 · LimitedFinal reportLindstrand Balloons 60X · Louisville, KYThe pilot applicant’s delayed reaction to the balloon's increased rate of descent, which resulted in impact with a light pole.NTSB ERA22LA042Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Flemingsburg, KYThe pilot’s failure to obtain the proper touchdown point or go-around, which resulted in a runway excursion.NTSB ERA21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Louisville, KYA loss of directional on takeoff for reasons that could not be determined.NTSB ERA21LA292Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Princeton, KYThe pilot’s inadequate preflight planning in that he failed to accurately determine the takeoff weight of the helicopter, which resulted in exceeding the helicopter’s maximum weight capability.NTSB ERA21LA205Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Columbia, KYThe pilot’s failure to obtain a proper touchdown point on the runway, which resulted in a runway excursion.NTSB ERA21LA185Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Flemingsburg, KYThe pilot’s improper recovery from a bounced landing, which resulted in a subsequent hard landing.NTSB ERA21FA135Accident · 1 fatalClass 3 · FieldFinal reportVans RV7 · Mayfield, KYThe pilot's exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall, loss of airplane control, and subsequent impact with terrain.NTSB ERA21LA050Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cynthiana, KYThe pilot’s failure to maintain proper glide path during a visual approach that was conducted at night, resulting in a collision with trees and terrain.NTSB ERA20CA283Accident · No injuriesClass 4 · Data collectionFinal reportBeech 36 · Murray, KYThe pilot’s failure to maintain control of the airplane during the simulated power off landing, and the flight instructor's delayed remedial action, which resulted in a loss of control and the airplane’s left wing striking the ground.NTSB ERA20CA240Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28R · Bardstown, KYThe commercial pilot's exceedance of the airplane's critical angle of attack and subsequent loss of lateral bank control during a soft field takeoff.NTSB ERA20CA168Accident · No injuriesClass 4 · Data collectionFinal reportDayton-Wright DH-4 · Bowling Green, KYA primary control (aileron) system anomaly that progressively worsened during a test flight that resulted in a loss of control. The reason for the anomaly was not determined due to impact damage.NTSB ERA20LA053Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Louisville, KYThe pilot’s improper flare to land, which resulted in a hard landing and the nose landing gear collapsing.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 ERA19TA213Accident · Minor injuriesClass 3Final reportContinental Copters Tomcat MK6C · Franklin, KYThe pilot’s failure to maintain main rotor rpm after takeoff, which resulted in a collision with terrain.NTSB GAA19CA367Accident · Minor injuriesData collectionFinal reportCessna 172 · Lebanon, KYThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion, impact with a ditch, and subsequent nose-over.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 ERA19TA105Accident · Minor injuriesFinal reportBeech 76 · Frankfort, KYThe pilot's failure to maintain airplane control during a simulated single-engine go-around, which resulted in a collision with terrain.NTSB GAA18CA532Accident · No injuriesData collectionFinal reportCessna 206 · London, KYThe pilot’s failure to maintain directional control during takeoff with a tailwind.NTSB ERA18LA158Accident · No injuriesClass 3 · LimitedFinal reportBellanca 7ECA · Warsaw, KYThe pilot’s inadequate preflight performance planning, and his delayed decision to abort the takeoff, which resulted in a ground loop.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 ERA18FA022Accident · 4 fatalField investigationFinal reportPiper PA32 · Fountain Run, KYThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete…NTSB ERA18FA005Accident · 1 fatalField investigationFinal reportBryant C Crosby BC Ultra PUP · Bardstown, KYThe pilot's improper decision to initiate a flight in an airplane he had never flown and with no currency in any airplane nor a medical certificate, which resulted in his loss of airplane control. Contributing to the accident was the pilot's psychiatric…