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 NYC00LA024Accident · No injuriesLimited investigationFinal reportCessna 177 · Frankfort, KYA total loss of engine power for undetermined reasonsNTSB NYC99FA236Accident · 2 fatalField investigationFinal reportPiper PA 22-150 · Goshen, KYA loss of engine power for undetermined reasons which resulted in a forced landing and subsequent collision with terrain. A factor in this accident was the down-sloping terrain.NTSB NYC99IA231Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYDeteriorated wire insulation and shorting at a short radius bend to the electrical wiring in the right side alternate static port heater, which resulted in electrical arcing and a fire sustained by overlaying thermal acoustic insulation.NTSB NYC99LA224Accident · 1 fatalLimited investigationFinal reportNorth American T6-G · Falmouth, KYThe pilot's misjudgment of altitude/clearance on approach which resulted in an in-flight collision with trees.NTSB NYC99LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Falmouth, KYA stuck intake-valve on the number one cylinder which resulted in a loss of engine power.NTSB NYC99FA140Accident · 4 fatalField investigationFinal reportSikorsky S-76A · Jackson, KYthe failure of the PIC to adequately supervise the SIC, and maintain a positive climb. Factors were the fog and dark night.NTSB NYC99FA136Accident · 1 fatalField investigationFinal reportAmerican Eurocopter AS-350B · Ashcamp, KYThe pilot's inadequate visual look out which resulted in an in-flight collision with wires.NTSB NYC99LA119Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Covington, KYThe pilot's failure to maintain directional control during the takeoff/initial climb. A factor in the accident was the crosswind condition.NTSB NYC99LA093Accident · 1 fatalLimited investigationFinal reportMooney M20E · Brooksville, KYContaminated fuel which resulted in the forced landing, and a heart attack from an adrenaline rush that interacted with preexisting coronary disease which resulted in the pilot's death.NTSB NYC99FA085Accident · 2 fatalField investigationFinal reportCessna 310N · Cecilia, KYThe flight instructor's failure to maintain control of the airplane. A factor was the flight instructor's inexperience instructing in the accident airplane.NTSB NYC99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sublett, KYThe pilot's improper decision to continue the flight with a perceived excessive fuel consumption, and delaying his decision to execute a precautionary until night, which resulted in the airplane impacting wires. Factors in the accident were the pilot's lack…NTSB NYC99LA064Accident · No injuriesLimited investigationFinal reportBoeing 757 · Covington, KYA flock birds were ingested into both engines, resulting in substantial damage to the engines.NTSB NYC99IA056Incident · No injuriesIncident investigationFinal reportPiper PA42-1000 · Lexington, KYImproper assembly of the engine gearcase by the manufacturer, which resulted in an uncontained failure of the 1st bull gear.NTSB NYC99LA027Accident · 1 fatalLimited investigationFinal reportBeech C35 · London, KYThe pilot's inadequate start procedure in which he fail to secure the aircraft from movement during an attempt to handprop the engine.NTSB IAD99LA015Accident · Minor injuriesLimited investigationFinal reportBell 206-B · Louisville, KYA loose 'B' nut on the aircraft's PC Air line which resulted in fuel starvation, and the pilot's abrupt application of aft cyclic to prevent a nose over. Contributing factors were soft terrain and dark night conditions.NTSB NYC99LA022Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYThe driver's failure to maintain control of the belt loader. A factor in the accident was the precipitation which may have contributed to the driver's foot slipping off the brake and onto the accelerator, as he approached the airplane.NTSB NYC99LA023Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYThe tug driver's failure to maintain a proper visual lookout.NTSB NYC98LA195Accident · No injuriesLimited investigationFinal reportCessna 172D · Louisville, KYThe student pilot's failure to perform a preflight inspection of the airplane before his first solo flight, and inadequate supervision by the certified flight instructor, which resulted in fuel exhaustion.NTSB NYC98LA181Accident · No injuriesLimited investigationFinal reportCessna 305A · Louisville, KYThe pilot's improper inflight decision, and his failure to maintain adequate airspeed which resulted in a stall.NTSB NYC98LA172Accident · No injuriesLimited investigationFinal reportEkstrom-Farrington Twinstar · Paducah, KYFailure of a through-bolt that attached the lateral control arms to the yoke assembly, due to unanticipated rotor brake forces through the flight control system.NTSB NYC98LA174Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Middlesboro, KYThe pilot's misjudgment of distance and speed, which resulted in runway overrun into a grass area where the gear collapsed. The tailwind was a contributing factor.NTSB NYC98LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · West Liberty, KYThe pilot's inadequate planning for a downslope landing. A factor was the pilot's lack of training for downslope landing situations.NTSB IAD98LA076Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Somerset, KYthe pilot's failure to follow procedures to hand-prop the airplane.NTSB NYC98LA101Accident · Serious injuriesLimited investigationFinal reportBeech D95A · Mount Sterling, KYWas the failure of the flight instructor to feather the engine in a timely manner. Factors were improper placement of the fuel selector valve by the student and failure of the flight instructor to adequately supervise its placement.NTSB IAD98LA036Accident · Minor injuriesLimited investigationFinal reportCanadair CL600-2B19 · Covington, KYThe driver's operation of a ground vehicle at night with an inoperative windshield wiper and an obscured windscreen against company regulations which resulted in a collision with a parked aircraft.NTSB NYC98LA038Accident · No injuriesLimited investigationFinal reportCessna TR182 · Owenton, KYThe pilot's inadequate preflight/inflight decision and VFR flight in instrument meteorological conditions. Contributing was a low ceiling.NTSB IAD98LA002Accident · No injuriesLimited investigationFinal reportHughes 269A · Campbellsville, KYThe pilot refueled the helicopter with jet fuel instead of avgas, which resulted in a loss of engine power. A related factor was the unsuitable terrain.NTSB NYC97FA178Accident · 2 fatalField investigationFinal reportCessna U206B · Gilbertsville, KYThe improper repair of a float by maintenance personnel which resulted in the total failure of the float.NTSB NYC97LA165Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Lexington, KYThe pilot misjudged distance and altitude to the runway after transition from an instrument approach to a visual approach. Factors related to the accident were the rain, and uphill runway conditions at a dark night.NTSB IAD97LA109Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Louisville, KYInadequate compensation for wind conditions by the pilot.NTSB NYC97LA138Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Paducah, KYThe failure of maintenance personnel to identify and correct the worn holes on the lower fuselage fairing and the failure of the flight instructor to maintain main rotor RPM during the autorotative landing. A contributing factor was the flight instructor's…NTSB NYC97LA141Accident · No injuriesLimited investigationFinal reportCessna 182 · Springfield, KYthe pilot's misjudgment of distance and speed, and his delay in aborting the landing. Factors relating to the accident were: the pilot's failure to attain a proper touchdown point for landing, and proximity of the fence to the runway.NTSB NYC97LA129Accident · Serious injuriesLimited investigationFinal reportLockheed L-1011-385-1 · Covington, KYthe failure of the primary and secondary elevator driveshafts, and the failure of maintenance personnel to detect the failure of the primary shaft during scheduled inspections.NTSB NYC97LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Manchester, KYThe pilot's delay in aborting the takeoff. A factor in the accident was the high, wet grassy runway.NTSB IAD97LA078Accident · No injuriesLimited investigationFinal reportMooney M20M · Madisonville, KYFailure of the pilot to maintain adequate airspeed, and inadequate supervision of the CFI, which resulted in a stall and subsequent hard landing.NTSB CHI97LA119Accident · No injuriesLimited investigationFinal reportBeech D35 · Lexington, KYflutter for an undetermined reason, which resulted in structural damage to the aft fuselage.NTSB NYC97LA054Accident · No injuriesLimited investigationFinal reportCessna 208B · Covington, KYThe pilot's failure to maintain the airplane on the ILS glide slope, which resulted in a descent below the glide path, and the inadvertent in-flight collision with a utility pole. Contributing factors were sleet/snow, dark night conditions, and the pole.NTSB NYC97LA035Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Lexington, KYfailure of #5 exhaust valve and/or #5 exhaust valve guide, which resulted in a progressive engine failure (debris puncturing the #5 piston crown, exhaust gasses entering the crankcase, loss of oil through the breather system, oil exhaustion, and subsequent…NTSB IAD97LA028Accident · No injuriesLimited investigationFinal reportHughes 269C · Mayfield, KYdisengagement of the main transmission aft pinion nut, allowing the tail rotor splined drive sleeve to disengage from the pinion, which resulted in loss of directional control and an emergency (autorotative) landing.NTSB CHI97IA031Incident · No injuriesIncident investigationFinal reportATR 42 · Covington, KYimproper use of procedures by maintenance personnel at an overhaul facility during overhaul of the landing gear, allowing corrosion to occur on the barrel lugs of the landing gear, which subsequently led to fatigue cracking of the lugs and eventual collapse…NTSB CHI97IA029Incident · No injuriesIncident investigationFinal reportBeech 1900D · Hopkensville, KYthe materials used in the new windshield, to meet new EPA requirements, were inadequate for the design.NTSB IAD97LA010Accident · Minor injuriesLimited investigationFinal reportBellanca BL28 · Ledbetter, KYthe pilot's delay in executing a go-around, and his failure to obtain/maintain adequate airspeed, which resulted in a stall and collision with the ground.NTSB IAD97LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Germantown, KYimproper maintenance with the installation of an improper oil ring on the number four piston, which led to failure of both the ring and pistion, oil starvation, and subsequent loss of engine power.NTSB IAD97LA007Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Harlan, KYthe pilot's misjudged distance and speed, and his faiure to attain the proper touchdown point during the landing, which resulted in overrun of the runway and an encounter with terrain.NTSB IAD97LA005Accident · No injuriesLimited investigationFinal reportCessna T210M · Mentor, KYthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. Factors relating to the accident were: the inaccurate fuel quantity gage, and the light condition at dusk.NTSB IAD96LA151Accident · 1 fatalLimited investigationFinal reportCessna 150C · Liberty, KYthe pilot's failure to maintain adequate altitude, while maneuvering at a low altitude, which resulted in in-flight collision with trees.NTSB IAD96LA148Accident · Minor injuriesLimited investigationFinal reportBellanca BL-26 · Bowling Green, KYthe pilot's improper fuel consumption calculations and fuel exhaustion, which resulted in loss of engine power and a forced landing. The lack of suitable terrain for a forced landing was a related factor.NTSB IAD96LA102Accident · Serious injuriesLimited investigationFinal reportBeech 65 · Campbellsville, KYthe pilot's inadequate preflight preparation, his failure to remove the control lock, and his failure to abort the takeoff.NTSB IAD96LA096Accident · Minor injuriesLimited investigationFinal reportLittle Scamp · Worthington, KYwas the loss of engine power for undetermined reasons shortly after liftoff. A related factor was the unsuitable terrain encountered during the forced landing.NTSB IAD96LA075Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Providence, KYthe pilot's failure to maintain directional control of the airplane during the landing roll. Related factors are the crosswind weather condition, the pilot's inadequate compensation for wind conditions, and the intermittent binding of the left brake.