NTSB investigations, 2008, TN

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

Cases per year

20082026
NTSB investigations, 2008, TN per year, 2008–2026: 190 cases
200812
20099
201010
201113
201219
20139
201413
201516
201615
20177
20188
201913
20209
20216
20228
20235
202411
20256
20261

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\") = 2008
    AND c.\"eventStateOrRegion\" = 'TN' 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 ERA09FA068Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T4 · Whites Creek, TNThe pilot's failure to feather the left propeller and secure the left engine following the total loss of left engine power, and his subsequent failure to maintain airspeed, lateral, and directional control of the airplane. Contributing to the accident was the…Nov 24, 2008 · N412ES · DestroyedNTSB ERA09CA054Accident · No injuriesData collectionFinal reportSnow 600 · Nashville, TNThe failure of the propeller shaft seal in flight. Contributing to the accident was the lack of suitable terrain for a forced landing.Nov 14, 2008 · N1691S · Substantial damageNTSB ERA09FA036Accident · 1 fatalField investigationFinal reportRobinson R-44 · Gallatin, TNThe pilot's inadvertent descent into water as a result of the dark night and limited outside visual references.Nov 3, 2008 · N300FX · Substantial damageNTSB ERA09FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Selmer, TNThe pilot's failure to avoid terrain during night instrument meteorological conditions.Oct 24, 2008 · N7510Y · Substantial damageNTSB ERA09LA013Accident · 1 fatalLimited investigationFinal reportSabre Tukan · Mohawk, TNThe pilot's loss of control in flight due to a lack of flight experience or instruction. Contributing to the accident was the pilot's impairment due to the recent use of marijuana and a prescription painkiller.Oct 12, 2008 · N75604 · Substantial damageNTSB NYC08FA298Accident · 1 fatalField investigationFinal reportMooney M20C · Lawrenceburg, TNA loss of engine power due to fuel exhaustion.Aug 30, 2008 · N6480U · Substantial damageNTSB NYC08CA278Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Dresden, TNThe pilot's failure to maintain the proper altitude/clearance while on final approach.Aug 9, 2008 · N9365W · Substantial damageNTSB MIA08CA154Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Mc Kinnon, TNThe pilot's inadequate fuel consumption calculations which led to fuel exhaustion and subsequent loss of engine power.Aug 2, 2008 · N4377J · Substantial damageNTSB NYC08CA191Accident · Minor injuriesData collectionFinal reportCessna 172M · Chuckey, TNThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was his failure to abort the takeoff.May 22, 2008 · N74WC · Substantial damageNTSB NYC08LA165Accident · 1 fatalLimited investigationFinal reportDragon Fly GT-500 · Paris, TNA fuel system configuration that was not in accordance with the engine manufacturer's published guidance, which resulted in a complete loss of engine power due to fuel starvation.Apr 21, 2008 · N101GP · Substantial damageNTSB NYC08CA125Accident · No injuriesData collectionFinal reportCessna 140 · Halls, TNThe flight instructor's inadequate remedial action. Contributing to the accident was the student pilot's failure to maintain directional control during the landing roll.Feb 19, 2008 · N2086V · Substantial damageNTSB MIA08CA064Accident · No injuriesData collectionFinal reportClutton Eric Fred S1 · Tullahoma, TNThe pilot's failure to maintain control of the airplane during takeoff.Feb 16, 2008 · N4499Y · Substantial damage