NTSB investigations, TN

9 cases where NTSB found Aircraft capability.

Cases per year

20092026
NTSB investigations, TN per year, 2009–2026: 9 cases
20091
20121
20143
20152
20161
20191

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\", '010610'))
  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 GAA19CA456Accident · No injuriesData collectionFinal reportPiper PA46 · Sparta, TNThe pilot's failure to maintain the runway heading during an aborted takeoff, which resulted in a runway excursion and collision with a sign and terrain. Contributing to the need to abort the takeoff was the pilot's improper decision to take off with the…Jul 27, 2019 · N12KW · Substantial damageNTSB GAA17CA105Accident · No injuriesData collectionFinal reportPiper PA 46 · Nashville, TNThe pilot’s loss of directional control during the aborted landing in gusting crosswind conditions, which resulted in a runway excursion.Dec 29, 2016 · N301BK · Substantial damageNTSB ERA15LA190Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Winchester, TNThe pilot's inadequate weight and balance and performance planning, including his decision to take off with more passengers than permitted, and his exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an…Apr 18, 2015 · N9680M · Substantial damageNTSB GAA15CA034Accident · Minor injuriesData collectionFinal reportCessna 182F · Portland, TNThe pilot's failure to perform a go-around in time to prevent a runway overrun and collision with terrain.Apr 7, 2015 · N3586Y · Substantial damageNTSB ERA15CA083Accident · No injuriesData collectionFinal reportCessna 182P · Nashville, TNThe pilot's inadequate control of the airplane during the landing roll, which resulted in a runway excursion.Dec 26, 2014 · N6063F · Substantial damageNTSB ERA15CA007Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Maryville, TNThe pilot/owner's failure to maintain a stabilized approach during the final leg of the traffic pattern. Contributing to the accident was both pilot's lack of aeronautical decision making.Oct 4, 2014 · N85707 · Substantial damageNTSB ERA14FA461Accident · 1 fatalField investigationFinal reportEagle R&D Helicycle · Gallatin, TNThe pilot's decision to fly the improperly balanced helicopter at high speed and low altitude, which resulted in a loss of control and collision with terrain. Contributing to the accident were the pilot's depression and resulting degradation of executive…Sep 28, 2014 · N7062U · Substantial damageNTSB ERA13CA027Accident · No injuriesData collectionFinal reportCessna 182P · Maryville, TNThe pilot’s inadequate recovery from a bounced landing and his subsequent delayed decision to perform a go-around, which resulted in the airplane’s failure to clear obstacles.Oct 16, 2012 · N1264S · Substantial damageNTSB ERA09LA450Accident · 2 fatalLimited investigationFinal reportStump Bradley Kolb · Calhoun, TNThe pilot’s decision to perform aerobatics at a low altitude and his failure to maintain control of the airplane while performing aerobatics.Aug 8, 2009 · N2456 · Substantial damage