NTSB investigations, KY
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 IAD96LA047Accident · No injuriesLimited investigationFinal reportBeech F35 · Mt. Sterling, KYa loss of engine power due to the failure of the number one piston. Related factors were the unsuitable terrain available for the forced landing, and the strong tailwind encountered during the forced landing.NTSB IAD96LA046Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Hazard, KYfailure of the engine crankshaft, which resulted in loss of engine power, a forced landing, and subsequent damage to the airplane. A factor relating to the accident was: lack of suitable terrain for a forced landing.NTSB IAD96LA042Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Cynthiana, KYThe pilot's failure to obtain proper assistance to secure the airplane.NTSB BFO96LA041Accident · No injuriesLimited investigationFinal reportCessna 172D · Rineyville, KYthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB BFO96LA036Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Louisville, KYthe pilot's misjudgment of the fuel supply, which resulted in a loss of engine power due to fuel exhaustion during final approach to the destination airport. Factors relating to the accident were: terrain conditions and vehicles in the emergency landing area.NTSB BFO96FA034Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Louisville, KYfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall, loss of altitude, and subsequent collision with obstructions (utility pole and supporting cable).NTSB BFO96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Stanton, KYwas the student pilot's failure to maintain directional control of the aircraft. The student pilot's lack of experience was a related factor.NTSB BFO95LA079Accident · 1 fatalLimited investigationFinal reportHughlett Challenger II · Madisonville, KYan intermittent short of the ignition system, due to improper maintenance/modification of the engine, which resulted in partial loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision…NTSB NYC95LA134Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Morehead, KYThe pilot's failure to assure that an inadequate oil supply was available fot the flight.NTSB NYC95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Louisville, KYThe pilot's inadequate planning which resulted in his failure to attain adequate airspeed for takeoff.NTSB NYC95IA106Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71 · Louisville, KYpreexisting crack(s) on the inside surface of the right main landing gear cylinder, and the subsequent fracture of the cylinder, which resulted in a collapse of the right main landing gear.NTSB BFO95LA049Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Mount Sterling, KYthe pilot's failure to maintain aircraft control during landing. The gusty, crosswind condition and the pilot's inadequate compensation for the wind condition were factors.NTSB NYC95LA078Accident · Serious injuriesLimited investigationFinal reportBeech 1900C · Covington, KYa lack of procedures by the tug operator to prevent inadvertent movement of an unoccupied tug, which resulted in an airplane being struck by an unoccupied tug which moved on its own.NTSB MIA95FA070Accident · 2 fatalField investigationFinal reportCessna 172N · Mintonville, KYThe flightcrew's intentional VFR flight into known instrument meteorological conditions. A factor was the inadequate altitude to prevent an inadvertent collision with an obstruction.NTSB BFO95LA012Accident · No injuriesLimited investigationFinal reportBeech A23 · Campbellsville, KYthe mechanic's improper maintenance adjustment, which involved the misalignment of the fuel selector handle with the fuel selector valve. Related factors are the pilot's inadequate fuel management, and the rough/uneven terrain.NTSB NYC95LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Dawson Springs, KYThe pilot's failure to maintain adequate obstacle clearance. Other related factors are night conditions and the pilot's improper inflight planning/decision.NTSB BFO95LA009Accident · No injuriesLimited investigationFinal reportCessna 150D · Paducah, KYThe student pilot's failure to maintain proper alignment and the certified flight instructor's inadequate supervision of the flight.NTSB BFO94LA162Accident · No injuriesLimited investigationFinal reportChampion 7FC · Sacramento, KYThe pilot's failure to maintain adequate obstacle clearance.NTSB NYC94LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Vine Grove, KYThe pilot's (1) inadequate compensation for wind conditions and (2) failure to align with the runway during landing touch down.NTSB BFO94LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Hopkinsville, KYThe pilot's failure to maintain proper alignment and adequate obstacle clearance.NTSB BFO94LA136Accident · No injuriesLimited investigationFinal reportCessna 172 · Fisherville, KYThe pilot's failure to maintain airspeed, which resulted in a stall and inflight loss of control.NTSB BFO94LA105Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Elizabethtown, KYThe pilot's failure to maintain directional control. A factor related to the accident was: the helicopter was outside the height-velocity envelope (for a successful autorotation), when loss of directional control occurred.NTSB NYC94LA094Accident · 1 fatalLimited investigationFinal reportBradford Seahawk · Richmond, KYwas the loss of engine power for undetermined reasons, and the collision with an object during the subsequent forced landing.NTSB BFO94LA078Accident · Minor injuriesLimited investigationFinal reportCameron ET-90 · Louisville, KYThe pilot-in-command's failure to maintain clearance from wires during the landing approach. A factor related to the accident is a downdraft that exceeded the balloon's available climb capability.NTSB BFO94LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Berea, KYThe pilot-in-command's failure to maintain adequate airspeed during the takeoff. A factor related to the accident is the gusty wind conditions.NTSB NYC94LA062Accident · Serious injuriesLimited investigationFinal reportDouglas DC-8-61 · Covington, KYThe captain's improper decision to conduct flight at high altitude in an unpressurized airplane, which resulted in his incapacition from depressurization sickness. A factor related to the accident was: maintenance personnel failed to properly secure the…NTSB NYC94LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Mt. Sterling, KYInadequate maintenance which resulted in the disconnection of the throttle cable from the carburetor and the subsequent loss of engine power. Factors were the annual inspection not performed, and complacency.NTSB NYC94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Falls Of Rough, KYThe pilot's inadequate tiedown and starting procedure which resulted in a runaway aircraft, which subsequently collided with a building.NTSB BFO94LA027Accident · Serious injuriesLimited investigationFinal reportCessna 425 · London, KYLoss of engine power due to fuel contamination.NTSB NYC94FA038Accident · 2 fatalField investigationFinal reportBeech B36TC · Lost Creek, KYThe loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the lack of suitable terrain for a forced landing.NTSB NYC94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Hopkinsville, KYthe pilot's improper IFR procedure by conducting flight below minimum descent altitude (MDA) without visual referece which resulted in an inflight collision with wires. A factor was the wire.NTSB NYC94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-602P · Falls Of Rough, KYThe pilot's inadequate visual lookout prior to entering the runway, resulting in a taxi off the runway to avoid conflict, onto soft terrain, and the subsequent collapse of the landing gear.NTSB NYC94LA013Accident · Serious injuriesLimited investigationFinal reportCessna C-150 · Cynthiana, KYThe pilot's abrupt control of the airplane on short final to the runway, with the flaps retracted, which resulted in an inadvertent stall and the subsequent collision with the trees. A factor in this accident was the poor judgement of the student pilot to go…NTSB NYC94LA002Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Madisonville, KYthe pilot's inadequate preflight preparation and his inadequate visual lookout in flight which resulted in the collision with wires.NTSB BFO93LA168Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Gilbertsville, KYThe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control. The crosswind was a related factor.NTSB BFO93LA157Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Oak Grove, KYThe pilot's innacurate preflight fuel consuption calculations and inadequate in-flight planning/decisions, which resulted in fuel exhaustion and subsequent loss of engine power. A factor related to the accident was: high obstructions in the emergency landing…NTSB BFO93LA155Accident · Serious injuriesLimited investigationFinal reportDouglas MD-88 · Lexington, KYThe cabin attendant did not follow published procedures.NTSB NYC93FA138Accident · 2 fatalField investigationFinal reportRobinson R22 · Warsaw, KYThe pilot's inadequate visual lookout and his failure to maintain adequate clearance with ground obstacles, which resulted in an inflight collision with a power line.NTSB BFO93FA131Accident · 1 fatalField investigationFinal reportBeech C33A · Paintsville, KY1) Fatigue failure of the engine crankshaft at the number 2 main journal due to undetermined reason (s) which resulted in the total loss of engine power, and 2) the pilot not maintaining an adequate airspeed which resulted in an inadvertent stall/spin. A…NTSB BFO93LA117Accident · Serious injuriesLimited investigationFinal reportHolmes Special · Chavies, KYFuel starvation due to the pilot's improper decision to take off with a low fuel level. Factors related to the accident were the low fuel level, the pilot's lack of familiarity with the characteristics of the fuel system, and the uneven terrain in the…NTSB NYC93LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Louisville, KYA partial power loss of undetermined origin while operating over unsuitable terrain.NTSB NYC93FA115Accident · 1 fatalField investigationFinal reportEnstrom F28C · Gordon, KYThe pilot's failure to see and avoid the wire.NTSB BFO93LA101Accident · No injuriesLimited investigationFinal reportCessna 150 · Brandenburg, KYThe pilot's failure to attain adequate airspeed prior to liftoff, leading to an inadvertent stall and loss of aircraft control. Factors related to the accident include the pilot's improper use of flaps and his failure to follow the published procedures for a…NTSB BFO93LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Canton, KYThe pilot's inadequate preflight planning when determining his fuel load, which led to an exhaustion of the airplane's fuel supply.NTSB BFO93LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Paintsville, KYFailure of the pilot to maintain adequate altitude or clearance from the terrain. Factors related to the accident were the unfavorable wind condition and the proximity of the hill to the runway.NTSB BFO93LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Falmouth, KYThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent swerve, and his delayed remedial action.NTSB NYC93LA096Accident · No injuriesLimited investigationFinal reportAir & Space 18-A · Paducah, KYThe inadequate supervision by the flight instructor resulting in a loss of directional control while conducting a simulated emergency, and the subsequent collision with the terrain during a roll over.NTSB BFO93LA039Accident · No injuriesLimited investigationFinal reportCessna 335 · Owensboro, KYFailure of airport personnel to report the runway condition by NOTAM when airport snow removal personnel left snow piled on the edges of the runway. Factors related to the accident were: dark night, fog, and the snowbank.NTSB NYC93LA052Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Bowling Green, KYThe pilot's inadequate inflight planning and decision which resulted in fuel exhaustion and the loss of engine power.NTSB BFO93LA013Accident · No injuriesLimited investigationFinal reportCessna 152 · Danville, KYThe student pilot's inadequate flare. A factor was the gusty wind.