NTSB investigations, KY
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 NYC03LA126Accident · No injuriesLimited investigationFinal reportAmerican Champion 7EC · Louisville, KYThe pilots inadequate compensation for the crosswind conditions, and his failure to maintain directional control. A factor related to the accident was the crosswind.NTSB NYC03LA090Accident · 1 fatalLimited investigationFinal reportStarnes Quickie Q-200 · Henderson, KYThe pilot's improper recovery from a bounced landing and his failure to maintain directional control, after experiencing an in-flight loss of control for undetermined reasons.NTSB IAD03LA042Accident · No injuriesLimited investigationFinal reportBell BHT-47-G3B2A · Lexington, KYThe pilot's failure to maintain directional control while maneuvering to land after a loss of engine power. A factor was the loss of engine power.NTSB IAD03FA032Accident · 3 fatalField investigationFinal reportCessna 421 · Ferguson, KYThe pilot's failure to follow the instrument approach procedure, which resulted in an early descent into trees and terrain. Factors included the low ceiling and the night lighting conditions.NTSB NYC03LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Taylor Mill, KYThe pilot's inaccurate in-flight planning and fuel consumption calculations, and his improper decision not to land and refuel.NTSB IAD03LA031Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Russellville, KYThe total loss of engine power due to carburetor ice.NTSB NYC03LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Prestonsburg, KYThe loss of oil pressure for undetermined reasons, which resulted in a failure of connecting rod end bolts, due to an over temperature condition.NTSB IAD03LA015Accident · No injuriesLimited investigationFinal reportBell 206L1 · Albany, KYThe pilot's inadequate in-flight planning, which resulted in an angle of approach in relative wind conditions conducive to a loss of helicopter tail rotor effectiveness. A factor was the obstacles surrounding the landing field.NTSB IAD03LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Middlesboro, KYThe pilot's operation of the airplane with a known deficiency. Factors related to the accident were the loss of engine power of the left engine due to a failure of the left engine-driven and electric fuel pumps, and inadequate maintenance.NTSB IAD03FA005Accident · 2 fatalField investigationFinal reportCessna 172N · Mount Sterling, KYThe failure of the pilot to follow the published instrument approach procedure, which resulted in an early descent into an antenna tower. A factor was the low ceiling.NTSB NYC02LA186Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Jamestown, KYThe pilot's failure to maintain the proper descent rate, which resulted in low rotor rpm and a collision with water.NTSB NYC02LA183Accident · 1 fatalLimited investigationFinal reportRoyse Glasair · Flemingsburg, KYThe pilot's improper recovery from a bounced landing, which resulted in a loss of control on the ground. A factor was the pilot's lack of experience in the type of aircraft.NTSB NYC02FA177Accident · 1 fatalField investigationFinal reportGates Learjet 25C · Lexington, KYThe captain's addition of forward thrust during the landing rollout, which resulted in a lack of braking effectiveness and a subsequent runway overrun. A factor was the captain's inability to deploy the thrust reversers for undetermined reasons.NTSB NYC02LA140Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Bardstown, KYThe pilot's inadequate preflight inspection, which resulted in fuel contamination and subsequent loss of engine power. A factor in this accident was that the wing tank fuel drains were wire closed and could not be used.NTSB NYC02TA123Accident · No injuriesFinal reportHughes 369D · Jeffersontown, KYThe flight instructor's loss of lateral control when his foot slipped off the rudder pedal during a power-off, running landing.NTSB NYC02IA097Incident · No injuriesIncident investigationFinal reportBombardier CL600-2B19 · Covington, KYThe manufacturer's failure to provide inspection criteria for the BPSU compartment aileron control pulleys, which resulted in eventual pulley corrosion, and subsequent control stiffness when seized pulleys and water-soaked aileron cables froze together at…NTSB IAD02LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Louisville, KYThe pilot's inadvertent selection of an empty fuel tank, which resulted in fuel starvation of the engine.NTSB NYC02LA071Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR-20 · Lexington, KYThe pilot's failure to maintain aircraft control. Factors in this accident were the undetermined failure of the turn coordinator, as reported by the pilot, and the instrument meteorological conditions.NTSB NYC02LA049Accident · 1 fatalLimited investigationFinal reportStiles Choctaw · Danville, KYFailure of a connecting rod bearing, which resulted in a loss of engine power during climb.NTSB NYC02LA047Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-227-AT · Covington, KYthe tug driver's inadequate visual lookout which resulted in his failure to see the airplane in time to prevent the collision.NTSB NYC02LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Falmouth, KYThe pilot's continued flight into known adverse weather. A factor was the snow.NTSB NYC02TA026Accident · Serious injuriesFinal reportBell 407 · Whitley City, KYThe pilots decision to operate the helicopter at an airspeed in excess of the maximum demonstrated stable airspeed for the water bucket. A factor in the accident was the pilot did not follow the published emergency procedure.NTSB NYC01LA231Accident · No injuriesLimited investigationFinal reportLet 33 · Bardstown, KYThe pilot's improper flare, which resulted in a nose-first, hard touchdown.NTSB NYC01LA216Accident · No injuriesLimited investigationFinal reportCessna 182R · Elizabethtown, KYThe pilot's improper decision to fly the airplane with a known deficiency, and his inflight decision to land with a quartering tailwind. A factor was the wing maintenance officer's concurrence to fly the airplane with the known deficiency.NTSB NYC01FA145Accident · 2 fatalField investigationFinal reportAeronca 7DC · Fulton, KYThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/spin to the ground. A factor was the pilot's decision to fly from the rear seat, which reduced his visibility of critical flight instruments, including the…NTSB IAD01LA063Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Louisville, KYThe flight instructor's failure to maintain directional control after landing.NTSB NYC01LA131Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Fairfield, KYThe pilot's inadequate visual lookout during takeoff, and his inadequate reconnoiter of the area prior to takeoff.NTSB NYC01LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Elizabethtown, KYThe pilot's failure to maintain directional control during the takeoff roll.NTSB NYC01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Paintsville, KYThe pilot's inadequate preflight inspection of the aircraft, which resulted in fuel exhaustion during cruise flight.NTSB NYC01LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hodgenville, KYThe pilot's failure to maintain runway alignment during landing. A factor in the accident was the pilot's lack of experience in conducting soft field landings.NTSB IAD01TA051Accident · Minor injuriesFinal reportHughes 369D · Taylorsville, KYthe flight instructor's inadequate aircraft control during a practice autorotation which resulted in a hard landing.NTSB NYC01FA102Accident · 1 fatalField investigationFinal reportCessna 152 · La Grange, KYThe student pilot's failure to maintain adequate airspeed while maneuvering the airplane at low altitude. A factor was the pilot's overconfidence in his abilities.NTSB NYC01FA089Accident · 1 fatalField investigationFinal reportCessna 182Q · Dixon, KYThe pilot's failure to maintain adequate clearance while maneuvering, which resulted in an in-flight collision with trees.NTSB NYC01IA072Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Covington, KYMissing exhaust nozzle bolts for undetermined reasons. A factor was inadequate maintenance inspection of the affected area.NTSB MIA01IA051Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Hebron, KYThe inadequate design of the flight compartment windshield by the windshield manufacturer resulting in cracking of the center ply.NTSB NYC01LA055Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Mount Sterling, KYThe student pilot's inadequate recovery from a bounced landing.NTSB NYC01FA053Accident · 3 fatalField investigationFinal reportRobinson R-44A · Sandgap, KYthe pilot's improper weather evaluation, and his failure to maintain terrain clearance while operating over unlighted terrain at night. Factors were the isolated areas of fog, and night conditions.NTSB NYC01IA046Incident · Minor injuriesIncident investigationFinal reportMooney M20C · Hazard, KYThe incorrect routing of the cabin air scat tubing by an unknown person, which resulted in a carbon monoxide leak into the cabin, and subsequent pilot incapacitation.NTSB NYC01IA024Incident · No injuriesIncident investigationFinal reportBombardier CL-600 · Falmouth, KYThe wake turbulence of another heavy airplane.NTSB NYC01LA022Accident · Serious injuriesLimited investigationFinal reportHoward Weedhopper · Fordsville, KYAn engine failure for undetermined reasons and the pilot's low altitude flight.NTSB IAD00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Owingsville, KYA loss of engine power due to water contamination of the fuel. Also causal in the accident was the pilot/owner's failure to repair the inoperative fuel cap.NTSB NYC00FA229Accident · 2 fatalField investigationFinal reportCessna 182RG · Princeton, KYThe pilot's failure to clear trees, for undetermined reasons.NTSB NYC00LA164Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Louisville, KYThe pilot's improper operation of the fuel selector.NTSB NYC00IA159Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3201 · Lexington, KYA misalignment between the bull gear and high speed pinion gearshaft, which resulted in fatigue and a subsequent failure of the bull gear.NTSB NYC00LA128Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Elizabethtown, KYThe pilot's loss of control due to his improper application of power and rudder, in order to arrest a swerve during the landing roll.NTSB NYC00IA116Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1125 · Pine Knot, KYThe partial failure of an inverter and the inadequate design of the electrical circuit breaker system.NTSB NYC00FA079Accident · 4 fatalField investigationFinal reportBeech 58 · Cynthiana, KYThe pilot's failure to maintain airspeed during a climb, which resulted in a loss of aircraft control.NTSB NYC00FA068Accident · 1 fatalField investigationFinal reportCessna 195 · Willard, KYThe pilot's continued VFR flight into IMC conditions. Factors were the pilot's inadequate preflight planning and snow showers.NTSB NYC00FA067Accident · 4 fatalField investigationFinal reportBeech C-90 · Somerset, KYthe failure of the pilot to follow his approach clearance, and subsequent descent into unprotected airspace which resulted in a collision with the guy wire. Factors were the failure of the air traffic controller to verify the approach he cleared the pilot to…NTSB NYC00LA027Accident · No injuriesLimited investigationFinal reportKolb Firestar · London, KYThe student pilot's inability to maintain control of the airplane after inadvertently allowing it to become airborne. A factor in the accident was his lack of total aviation experience.