NTSB investigations, 2012, KY

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 per year

19642026
NTSB investigations, 2012, KY per year, 1964–2026: 1,465 cases
196446
196551
196632
196736
196854
196946
197039
197150
197251
197343
197440
197535
197642
197735
197851
197939
198043
198130
198239
198331
198422
198531
198620
198728
198822
19899
199017
199111
199224
199319
199415
19959
199618
199712
199812
199914
200015
200114
200214
200321
200419
200515
200616
200711
200816
200914
201020
20119
201214
201311
20145
201513
201611
201711
20185
201913
20207
202111
202215
202313
202413
202515
20268

Latest 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 year(c.\"eventDate\") = 2012
    AND 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.

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…Nov 15, 2012 · N9985B · Substantial damageNTSB ERA12CA579Accident · No injuriesData collectionFinal reportCessna 172P · Richmond, KYThe student pilot's improper flare, which resulted in a hard landing, and the flight instructor's inadequate supervision of the student.Sep 25, 2012 · N53720 · Substantial damageNTSB ERA12LA575Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Fort Thomas, KYThe pilot’s failure to periodically add engine power during an extended descent in carburetor icing conditions, which resulted in insufficient carburetor heat, the gradual build-up of carburetor ice, and the subsequent loss of engine power.Sep 23, 2012 · N735FJ · Substantial damageNTSB 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…Sep 5, 2012 · N237TA · Substantial damageNTSB ERA12CA546Accident · No injuriesData collectionFinal reportCessna 172M · Bardstown, KYThe flight instructor's decision to turn the fuel selector to the off position and his delayed remedial actions to restart the engine, which resulted in fuel starvation and a subsequent forced landing.Aug 30, 2012 · N21214 · Substantial damageNTSB ERA12CA516Accident · Serious injuriesData collectionFinal reportBeech A23-19 · West Liberty, KYThe pilot's delayed decision to abort a takeoff, which resulted in a runway excursion.Aug 19, 2012 · N4746J · Substantial damageNTSB ERA12CA462Accident · Serious injuriesData collectionFinal reportInfinity Infinity 2003 · Wilmore, KYA loss of lift on initial climb for unreported reasons, which resulted in a collision with trees and the ground.Jul 16, 2012 · N5627G · Substantial damageNTSB ERA12CA392Accident · Minor injuriesData collectionFinal reportBowles Chris Kitfox 5 · Owenton, KYThe pilot's failure to attain the proper airspeed during takeoff, and the flight instructor's delayed remedial action, which resulted in a loss of airplane control. Contributing to the accident was the flight instructor's lack of previous experience in the…Jun 12, 2012 · N903XC · Substantial damageNTSB ERA12CA323Accident · No injuriesData collectionFinal reportBeech A36 · Paducah, KYThe pilot’s failure to properly secure the airplane before turning the propeller by hand.May 8, 2012 · N1819L · Substantial damageNTSB ERA12LA294Accident · No injuriesLimited investigationFinal reportCessna 172R · Richmond, KYA total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight instructor’s failure to supervise the student’s preflight inspection, his inadequate fuel management and preflight and in-flight fuel planning, and the operator’s…Apr 19, 2012 · N28BC · Substantial damageNTSB ERA12FA280Accident · 1 fatalField investigationFinal reportManzitto Michael A Mwlancair 235 · Hudson, KYThe pilot's decision to operate the airplane with known electrical system problems, which resulted in the in-flight failure of the electrical wiring interconnect system, loss of electrical power, and subsequent fuel starvation and loss of engine power.Apr 14, 2012 · N235MW · Substantial damageNTSB ERA12CA277Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Georgetown, KYThe pilot's failure to maintain control of the airplane after engine start.Apr 10, 2012 · N9518J · Substantial damageNTSB ERA12FA262Accident · 1 fatalField investigationFinal reportBeech 58 · Calhoun, KYThe failure of the pilot to maintain airplane control after experiencing a loss of power from the left engine due to water contamination of the fuel system. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane and…Apr 1, 2012 · N9448Q · Substantial damageNTSB ERA12LA224Accident · Serious injuriesLimited investigationFinal reportCessna T210J · Rabbit Hash, KYThe pilot's inadequate preflight and in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Mar 14, 2012 · N2275R · Substantial damage