NTSB investigations, KY
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 ERA09CA439Accident · No injuriesData collectionFinal reportMooney M20S · Mayfield, KYThe pilot prematurely retracting the landing gear and flaps during the aborted landing.NTSB ERA09CA426Accident · No injuriesData collectionFinal reportCessna 150M · Lexington, KYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel manangement.NTSB ERA09LA372Accident · No injuriesLimited investigationFinal reportCessna 172D · Shepherdsville, KYThe mechanic's improper inspection of the mixture control cable.NTSB ERA09CA276Accident · Serious injuriesData collectionFinal reportArbc Inc DBA Lindstrand 60X · Louisville, KYThe passenger's inadequate bracing during landing.NTSB ERA09LA250Accident · 1 fatalLimited investigationFinal reportGladstone Kitfox · Dubre, KYThe pilot's failure to maintain airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall.NTSB ERA09FA215Accident · 1 fatalField investigationFinal reportCessna 182Q · Lexington, KYThe pilot's failure to maintain control of the airplane for undetermined reasons.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 ERA09LA132Accident · 1 fatalLimited investigationFinal reportCessna 172 · Hardin, KYThe pilot's failure to maintain aircraft control and his impairment from illegal drug use.NTSB ERA09LA114Accident · No injuriesLimited investigationFinal reportJohnson Barron T Lancair 360 · Owensboro, KYThe loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector valve cotter pin and the inoperative main (center) fuel tank gauge.NTSB ERA09FA093Accident · 1 fatalField investigationFinal reportBeech 36 · Louisville, KYThe pilot’s continued operation of the aircraft with known deficiencies. Contributing to this accident was the improper sealing of the engine case during overhaul.NTSB ERA09CA003Accident · No injuriesData collectionFinal reportBuckeye Dream Machine · Lexington, KYThe student pilot's improper decision to continue the takeoff.NTSB MIA08LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Falmouth, KYA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB NYC08LA317Accident · Serious injuriesLimited investigationFinal reportSorrell Skybolt · Williamstown, KYA loss of engine power due to oil starvation as a result of improper servicing (removal of preserving fluid) of the engine after it had been returned from storage.NTSB MIA08LA180Accident · No injuriesLimited investigationFinal reportCessna 182A · Elizabethtown, KYA loss of engine power due to fuel exhaustion. Contributing to the accident was pressure from the company for the pilot to fly the second load of skydivers without refueling.NTSB NYC08LA263Accident · 1 fatalLimited investigationFinal reportOsborne Challenger II · Fairdealing, KYThe pilot's failure to maintain adequate airspeed while climbing into rising terrain at low altitude, which resulted in an aerodynamic stall and uncontrolled descent.NTSB MIA08CA145Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Greensburg, KYThe pilot's failure to maintain clearance from trees while maneuvering. Contributing to the accident was the low altitude maneuvers.NTSB NYC08LA251Accident · No injuriesLimited investigationFinal reportHolmes Arthur Orman Kitfox IV · Burkesville, KYThe total loss of engine power due to the installation of an engine oil filter that did not meet the engine manufacture's specifications.NTSB CHI08LA195Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Frankfort, KYThe student pilot's improper landing flare and the flight instructor's delayed remedial action.NTSB NYC08CA288Accident · Minor injuriesData collectionFinal reportGrumman American AA-5A · Carrollton, KYThe pilot's improper fuel tank selection, which resulted in fuel starvation and subsequent loss of engine power.NTSB MIA08FA122Accident · 1 fatalField investigationFinal reportYates Lancair IV-P · Springfield, KYA total loss of engine power due to a loss of engine oil as a result of the installation of the wrong oil adapter O-ring seal.NTSB MIA08LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Louisville, KYA total fatigue failure of the No. 5 piston during climb.NTSB NYC08LA152Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Louisville, KYThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall/spin.NTSB NYC08LA137Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Middlesboro, KYThe mechanic's improper maintenance installation of the No. 1 cylinder rocker arms which led to oil starvation and a loss of engine power.NTSB MIA08CA065Accident · Serious injuriesData collectionFinal reportEmbraer EMB-145LR · Covington, KYThe flight attendant's inadvertent slip on the galley's contaminated floor and falling during climb to cruise.NTSB MIA08FA027Accident · 2 fatalField investigationFinal reportCessna T210N · Bloomfield, KYthe pilot exceeded the design stress limits of the airplane, which resulted in the in-flight break up. Contributing to the accident was the pilot's loss of control in-flight due to spatial disorientation.NTSB NYC08FA046Accident · 1 fatalField investigationFinal reportCessna 310R · Owensboro, KYA loss of control during approach for undetermined reasons.NTSB NYC08LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sacramento, KYA total loss of engine power during initial climb for undetermined reasons.NTSB NYC08CA011Accident · No injuriesData collectionFinal reportSlagle Thorp T-18 · Franklin, KYThe pilot's failure to maintain control of the airplane during the landing.NTSB DEN08CA001Accident · Serious injuriesData collectionFinal reportDegelia Rotor Flight Dynamic · Ashland, KYthe pilot's failure to maintain aircraft control during the landing flare resulting in a hard landing. Contributing factors were the crosswind and the pilot's failure to recover from a bounced landing.NTSB MIA07LA155Accident · 1 fatalLimited investigationFinal reportGrumman AA-5A · Worthington, KYThe separation of the engine's No. 4 piston from the crankshaft for unidentified reasons and the pilot's continued operation with known equipment deficiencies.NTSB NYC07LA212Accident · 2 fatalLimited investigationFinal reportSchrack Starduster Too · Verona, KYThe pilot's failure to maintain airspeed during initial climb. Contributing to the accident was the inadvertent stall.NTSB NYC07LA177Accident · 1 fatalLimited investigationFinal reportBeech BE-23 · Science Hill, KYA loss of engine power for an undetermined reason.NTSB NYC07FA159Accident · 2 fatalField investigationFinal reportMooney M20F · Brooks, KYThe pilot's failure to maintain aircraft control during the aborted landing. Contributing to the accident was the exceedance of the airplane's maximum gross weight, and the pilot's inadequate preflight planning.NTSB ATL07LA088Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Taylorsville, KYThe pilot's improper prefight inspection of the helicopter.NTSB NYC07LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Russellville, KYA loss of engine power for undetermined reasons, during the initial climb after an aborted landing.NTSB NYC07LA033Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Bardstown, KYThe loss of engine power for undetermined reasons.NTSB NYC07CA034Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Benton, KYThe pilot's improper decision to fly between the trees during his approach to the runway.NTSB NYC06LA231Accident · No injuriesLimited investigationFinal reportMooney M-18L · Lexington, KYThe failure of both magnetos which resulted in a loss of engine power during cruise flight.NTSB NYC06LA214Accident · 1 fatalLimited investigationFinal reportCessna 150K · Shelby Gap, KYThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in an impact with mountainous terrain. A factor was the low ceiling.NTSB NYC06FA209Accident · 7 fatalField investigationFinal reportCessna 401A · Whick, KYThe non-instrument-rated pilot's continued flight into instrument meteorological conditions, and his subsequent failure to maintain airspeed which resulted in an inadvertent stall. Contributing was the instrument meteorological conditions.NTSB DCA06MA064Accident · 49 fatalClass 1 · MajorFinal reportBombardier CRJ-100 · Lexington, KYthe flight crewmembers's failure to use available cues and aids to identify the airplane's location on the airport surface during taxi and their failure to cross-check and verify that the airplane was on the correct runway before takeoff. Contributing to the…NTSB NYC06TA190Accident · Minor injuriesFinal reportMD Helicopter 500N · Louisville, KYThe pilot's failure to maintain control of the helicopter and the flight instructor's inadequate supervision, which resulted in a hard landing and subsequent rollover.NTSB NYC06CA188Accident · No injuriesData collectionFinal reportCessna 120 · Ashland, KYThe pilot's improper fuel tank selection, which resulted in fuel starvation and a subsequent loss of engine power. A factor in the accident was the trees.NTSB NYC06LA171Accident · 1 fatalLimited investigationFinal reportBuckeye Dream Machine · Monticello, KYThe misplaced parachute suspension line, which resulted in an in-flight loss of control. A factor was the pilot's inadequate preflight inspection.NTSB NYC06LA165Accident · 1 fatalLimited investigationFinal reportNorth American Navion · Sturgis, KYA total loss of engine power due to a leaking fuel pump gasket.NTSB NYC06CA149Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Louisville, KYThe pilot's failure to maintain directional control during landing. A factor in the accident was the wet grassy runway.NTSB NYC06LA147Accident · No injuriesLimited investigationFinal reportCessna 150D · Bloomfield, KYThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB CHI06FA141Accident · 1 fatalField investigationFinal reportCessna 210N · Ft. Thomas, KYThe pilot failed to maintain altitude/clearance with trees while attempting to return to the airport.NTSB NYC06CA116Accident · No injuriesData collectionFinal reportCessna 172S · Louisville, KYThe student pilot's failure to maintain directional control during the takeoff roll.NTSB NYC06LA062Accident · Serious injuriesLimited investigationFinal reportBell 206B · Big Creek, KYThe pilot's inadvertent settling with power during a descent. Contributing to the accident was mechanical turbulence in the lee of an obstruction in windy conditions.