NTSB investigations, KY

97 cases where the sequence of events included Collision with terr/obj (non-CFIT).

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'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA15LA134Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lexington, KYMaintenance personnel's failure to properly inspect and clean the engine ignition harness spark plug terminals, which resulted in a partial loss of engine power during an attempted takeoff.Feb 19, 2015 · N358CD · Substantial damageNTSB ERA15CA100Accident · Minor injuriesData collectionFinal reportShannon William RV6A · Pikeville, KYThe pilot's failure to maintain airspeed during landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure to obtain a preflight weather briefing, and his subsequent flight into icing conditions, which resulted in…Jan 14, 2015 · N32SN · Substantial damageNTSB ERA15FA088Accident · 4 fatalField investigationFinal reportPiper PA34 · Kuttawa, KYThe pilot's failure to properly set the left engine fuel selector before takeoff and to recognize the incorrect setting during the flight, which resulted in fuel starvation and a loss of engine power on both engines.Jan 2, 2015 · N81291 · Substantial damageNTSB ERA14CA291Accident · No injuriesData collectionFinal reportCessna 172B · Frankfort, KYThe pilot's failure to maintain directional control during landing in crosswind conditions, resulting in a loss of control and runway excursion.Jun 13, 2014 · N7540X · Substantial damageNTSB ERA14LA253Accident · Serious injuriesLimited investigationFinal reportPiper J3C - 65 · Hopkinsville, KYThe failure of the pilot to identify poor engine performance during the engine run-up before takeoff. Also causal to the accident was the mistimed right magneto and the poor condition of the spark plugs in the No. 4 cylinder.May 22, 2014 · N46777 · Substantial damageNTSB ERA14LA222Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Bardwell, KYThe failure of the pilot to maintain airspeed while maneuvering shortly after takeoff, resulting in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, uncontrolled descent, and impact with the ground.May 4, 2014 · N9588S · Substantial damageNTSB ERA14LA218Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Middlesboro, KYThe pilot's failure to maintain airplane control during the landing approach due to his diverted attention to the partially opened main cabin door and the unsecured dog. Contributing to the accident was the pilot's failure to securely latch the main cabin…May 2, 2014 · N702JS · Substantial damageNTSB ERA13CA413Accident · No injuriesData collectionFinal reportLake LA-4 · Monticello, KYAn encounter with a large wave during water taxi, which resulted in the airplane nosing over.Sep 6, 2013 · N1136L · Substantial damageNTSB ERA13TA341Accident · Serious injuriesFinal reportMcdonnell Douglas Helicopter 369E · Jackson, KYThe helicopter pilot's inadvertent collision with an unmarked and uncharted utility wire of which he was unaware.Jul 29, 2013 · N1608D · DestroyedNTSB ERA13CA317Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Bronston, KYThe pilot’s failure to maintain airspeed during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s reduced climb performance due to density altitude, as well as the pilot’s decision to initiate the takeoff from…Jul 8, 2013 · N44293 · Substantial damageNTSB ERA13LA279Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Louisville, KYThe pilot's failure to set the correct flap position before takeoff and his inadequate preflight planning, which resulted in the operation of the airplane over the maximum allowable gross weight, both of which led to an aerodynamic stall at too low an…Jun 12, 2013 · N118JD · Substantial damageNTSB ERA13FA273Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L-1 · Manchester, KYThe pilot’s loss of helicopter control due to spatial disorientation when he inadvertently encountered night, instrument meteorological conditions, which resulted in the in-flight separation of the main rotor and tailboom.Jun 7, 2013 · N114AE · DestroyedNTSB ERA13LA236Accident · No injuriesLimited investigationFinal reportBell 206B · Hartford, KYThe pilot’s failure to avoid a powerline that crossed a field that he was spraying. Contributing to the collision was the company’s failure to specifically mention that flight hazards be identified during a pre-work conference.May 10, 2013 · N94PH · Substantial damageNTSB ERA13CA107Accident · No injuriesData collectionFinal reportBrewer James M KR2 · Bear Branch, KYThe pilot’s improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot’s lack of knowledge about the airplane’s total fuel capacity and fuel quantity instrumentation.Jan 7, 2013 · N216CB · 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 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 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 damageNTSB ERA11FA512Accident · 1 fatalField investigationFinal reportHeronimus Kevin A Glasair III · Falls of Rough, KYThe failure of the propeller power speed reduction unit, which resulted in a loss of engine power at low altitude.Sep 30, 2011 · N43KH · Substantial damageNTSB ERA11LA454Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Hodgenville, KYThe pilot's inadequate takeoff performance planning, which resulted in collision with an obstacle during takeoff from a turf runway that was not long enough for the given conditions.Aug 15, 2011 · N316MA · Substantial damageNTSB ERA11CA453Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · West Liberty, KYThe pilot's failure to obtain the proper touchdown point during landing, which resulted in a runway excursion.Aug 13, 2011 · N5080M · Substantial damageNTSB ERA11LA444Accident · Minor injuriesLimited investigationFinal reportHodges Samuel J RV-7A · Paducah, KYA partial loss of engine power during the initial climb for undetermined reasons.Aug 7, 2011 · N462WP · Substantial damageNTSB ERA11LA418Accident · No injuriesLimited investigationFinal reportFloyd Joseph B RV6 · Hartford, KYA loss of engine power due to fuel contamination as a result of the pilot/owner's inadequate maintenance of the airplane's fuel system, which resulted in blockage of the fuel lines and filters.Jul 24, 2011 · N164BF · Substantial damageNTSB ERA11LA411Accident · No injuriesLimited investigationFinal reportCessna 150M · Elizabethtown, KYA total loss of engine power for undetermined reasons.Jul 20, 2011 · N8576U · Substantial damageNTSB ERA11LA386Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Louisville, KYThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a landing gear collapse.Jul 2, 2011 · N8319N · Substantial damageNTSB ERA10LA449Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7HC · Louisville, KYA loss of engine power due to fuel system contamination resulting in damage to the carburetor float.Aug 27, 2010 · N8919R · Substantial damageNTSB ERA10CA353Accident · No injuriesData collectionFinal reportLawwill Ted Zodiac 601XL · Waddy, KYA loss of engine power due to fuel starvation for undetermined reasons.Jun 29, 2010 · N601LP · Substantial damageNTSB ERA10CA310Accident · Serious injuriesData collectionFinal reportCessna 170 · Campbellsville, KYThe pilot’s failure to maintain directional control during an aborted landing.Jun 13, 2010 · N4273V · Substantial damageNTSB ERA10FA246Accident · 2 fatalField investigationFinal reportBeech 58 · Bear Branch, KYThe pilot's improper in-flight planning/decision, his continued flight into adverse weather (icing conditions), and failure to maintain an adequate airspeed during the emergency descent.Apr 27, 2010 · N1856S · Substantial damageNTSB ERA10CA214Accident · Serious injuriesData collectionFinal reportPiper PA28 · Louisville, KYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.Apr 7, 2010 · N4247T · Substantial damageNTSB ERA10LA204Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-26A · Princeton, KYThe pilot's failure to maintain directional control during landing roll for undetermined reasons, resulting in a runway excursion.Apr 3, 2010 · N29WD · Substantial damageNTSB ERA10FA148Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Springfield, KYThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…Feb 23, 2010 · N7778W · Substantial damageNTSB ERA10LA102Accident · 1 fatalLimited investigationFinal reportDavis Michael J Longez · Dexter, KYThe loss of engine power due to the chaffing and grounding of the single magneto's ignition lead.Dec 25, 2009 · N499CM · DestroyedNTSB 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.Jul 28, 2009 · N6433K · Substantial damageNTSB ERA09FA215Accident · 1 fatalField investigationFinal reportCessna 182Q · Lexington, KYThe pilot's failure to maintain control of the airplane for undetermined reasons.Mar 26, 2009 · N4871N · Substantial damageNTSB ERA09LA132Accident · 1 fatalLimited investigationFinal reportCessna 172 · Hardin, KYThe pilot's failure to maintain aircraft control and his impairment from illegal drug use.Jan 9, 2009 · N28RP · Substantial damageNTSB 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.Dec 18, 2008 · N7472N · Substantial damageNTSB 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.Sep 28, 2008 · N4477U · Substantial damageNTSB 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.Sep 21, 2008 · N3EG · Substantial damageNTSB 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.Aug 3, 2008 · N69ER · Substantial damageNTSB 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.Jun 18, 2008 · N441L · Substantial damageNTSB MIA08LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Louisville, KYA total fatigue failure of the No. 5 piston during climb.May 7, 2008 · N42116 · Substantial damageNTSB NYC08LA152Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Louisville, KYThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall/spin.Apr 6, 2008 · N734JV · Substantial damage