NTSB investigations, TN

8 cases where NTSB found Runway/land/takeoff/taxi surface.

Cases per year

20082026
NTSB investigations, TN per year, 2008–2026: 8 cases
20082
20091
20101
20141
20202
20241

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 c.\"eventStateOrRegion\" = 'TN' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030230'))
  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 ERA24LA131Accident · No injuriesClass 4 · LimitedFinal reportFairchild SA227-AT · Smyrna, TNThe airplane encountered a sink hole while taxiing.Mar 4, 2024 · N563TR · Substantial damageNTSB ERA20LA288Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 170 · Ardmore, TNThe pilot’s inadequate preflight planning and his decision to depart from a constrained, grass-covered field in elevated-density altitude conditions, which resulted in reduced takeoff and climb performance and a subsequent forced landing.Aug 13, 2020 · N3962V · Substantial damageNTSB ERA20CA228Accident · Minor injuriesClass 4 · Data collectionFinal reportThorp Thorp T 18 · Madisonville, TNThe pilot's failure to maintain directional control during the landing roll on a soft turf runway, which resulted in a nose-over.May 29, 2020 · N70BZ · Substantial damageNTSB ERA14LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Pinson, TNThe noninstrument-rated pilot’s decision to continue flight into deteriorating weather conditions at night and his failure to divert in a timely manner, which resulted in an off-airport precautionary landing and subsequent substantial damage to the airplane.Feb 14, 2014 · N194EX · Substantial damageNTSB ERA10CA126Accident · No injuriesData collectionFinal reportMaule M-4-220C · Westmoreland, TNThe pilot's failure to maintain clearance from a snow drift.Jan 30, 2010 · N40668 · Substantial damageNTSB ERA10FA020Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Oliver Springs, TNThe pilot's loss of directional control while landing on a wet turf runway, which resulted in a runway excursion and collision with a tree.Oct 18, 2009 · N7906W · Substantial damageNTSB NYC08CA120Accident · No injuriesData collectionFinal reportCessna 140 · Dayton, TNThe pilot's improper flare, which resulted in a hard landing.Mar 2, 2008 · N3536V · 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