NTSB investigations, 2015, KY

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

Cases per year

20082026
NTSB investigations, 2015, KY per year, 2008–2026: 97 cases
20087
20094
20107
20117
20128
20137
20144
20159
20169
20179
20181
20197
20202
20215
20222
20231
20244
20252
20262

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\") = 2015
    AND 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 ERA15LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28RT-201T · Dawson Springs, KYThe fatigue failure of a crankshaft counterweight, which resulted in a total loss of engine power during cruise flight.Sep 29, 2015 · N2175K · Substantial damageNTSB GAA15CA229Accident · No injuriesData collectionFinal reportMckinney Charles R Searey · Augusta, KYThe amphibious airplane's impact with a submerged object during a water landing, which resulted in a nose over.Aug 15, 2015 · N831CM · Substantial damageNTSB ERA15LA304Accident · No injuriesLimited investigationFinal reportBoard James A Zenith 601 HD · Danville, KYThe pilot's improper adjustment of the propeller blade angle, which resulted in inadequate engine thrust, and his decision to continue the takeoff despite the excessively long takeoff roll.Aug 7, 2015 · N740JB · Substantial damageNTSB ERA15LA293Accident · Serious injuriesLimited investigationFinal reportBeech C90B · Georgetown, KYUndetermined based on the available evidence.Aug 2, 2015 · N257CQ · Substantial damageNTSB ERA15CA272Accident · Minor injuriesData collectionFinal reportSmith Steen Skybolt · Junction City, KYThe pilot's inaccurate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jul 18, 2015 · N31CS · Substantial damageNTSB ERA15FA220Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Rowdy, KYThe noninstrument-rated pilot’s decision to continue visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.May 21, 2015 · N26886 · DestroyedNTSB 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 damage