OpenAirDocs.org

NTSB investigations, 2007, KY

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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

Where

Open the map

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\") = 2007
    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 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.Dec 8, 2007 · N5431C · Substantial damageNTSB NYC08FA046Accident · 1 fatalField investigationFinal reportCessna 310R · Owensboro, KYA loss of control during approach for undetermined reasons.Nov 26, 2007 · N3364G · Substantial damageNTSB NYC08LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sacramento, KYA total loss of engine power during initial climb for undetermined reasons.Nov 10, 2007 · N41535 · Substantial damageNTSB NYC08CA011Accident · No injuriesData collectionFinal reportSlagle Thorp T-18 · Franklin, KYThe pilot's failure to maintain control of the airplane during the landing.Oct 11, 2007 · N515HS · Substantial damageNTSB 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.Oct 2, 2007 · N444PD · Minor damageNTSB 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.Sep 22, 2007 · N26442 · Substantial damageNTSB 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.Sep 3, 2007 · N5462 · DestroyedNTSB NYC07LA177Accident · 1 fatalLimited investigationFinal reportBeech BE-23 · Science Hill, KYA loss of engine power for an undetermined reason.Jul 26, 2007 · N2354J · Substantial damageNTSB 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.Jul 8, 2007 · N9180V · Substantial damageNTSB ATL07LA088Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Taylorsville, KYThe pilot's improper prefight inspection of the helicopter.Jun 11, 2007 · N93GP · Substantial damageNTSB NYC07LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Russellville, KYA loss of engine power for undetermined reasons, during the initial climb after an aborted landing.Apr 21, 2007 · N299AA · Substantial damage