NTSB investigations, KY
33 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 5 |
| 2012 | 3 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 3 |
| 2019 | 3 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 3 |
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\" = '230' 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" = '230' 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 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 ERA25LA257Accident · No injuriesClass 4 · LimitedFinal reportYates Tom W Kitfox III · Greenville, KYThe pilot’s loss of control during takeoff.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 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 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 ERA22LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Louisville, KYThe pilot’s failure to maintain directional control during landing in cross wind conditions.NTSB ERA21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Louisville, KYA loss of directional on takeoff for reasons that could not be determined.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 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 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 GAA17CA263Accident · No injuriesData collectionFinal reportPiper PA28R · Frankfort, KYThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing roll in gusting crosswind conditions.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 ERA14CA291Accident · No injuriesData collectionFinal reportCessna 172B · Frankfort, KYThe pilot's failure to maintain directional control during landing in crosswind conditions, resulting in a loss of control and runway excursion.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 ERA12CA547Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Tail Dragger · Elizabethtown, KYThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a takeoff in gusty crosswind conditions. Contributing to the accident was the pilot's decision to take off in gusty wind conditions associated with approaching…NTSB ERA12CA277Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Georgetown, KYThe pilot's failure to maintain control of the airplane after engine start.NTSB ERA10CA310Accident · Serious injuriesData collectionFinal reportCessna 170 · Campbellsville, KYThe pilot’s failure to maintain directional control during an aborted landing.NTSB ERA10CA270Accident · Serious injuriesData collectionFinal reportHealy RAF 2000 · Hopkinsville, KYThe pilot’s overcompensation for gusting wind conditions during the takeoff roll, which resulted in a loss of control.NTSB ERA10LA204Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-26A · Princeton, KYThe pilot's failure to maintain directional control during landing roll for undetermined reasons, resulting in a runway excursion.NTSB ERA10CA173Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Mount Sterling, KYThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB ERA10LA103Accident · No injuriesLimited investigationFinal reportFairchild SA227 · Somerset, KYDamaged wiring in the nosewheel steering harness, which resulted in a loss of control during landing. Contributing to the accident was the pilots' improper touchdown point.NTSB ERA09CA156Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lexington, KYThe pilot's failure to maintain control of the helicopter during takeoff. Contributing to this accident was the interference of the flight controls by the heavy coat and boots the pilot was wearing.NTSB CHI08LA195Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Frankfort, KYThe student pilot's improper landing flare and the flight instructor's delayed remedial action.