NTSB investigations, TN

4 cases where NTSB found Management.

Cases per year

20122026
NTSB investigations, TN per year, 2012–2026: 4 cases
20121
20142
20181

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\", '0402'))
  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 ERA18LA199Accident · 1 fatalLimited investigationFinal reportCessna 182 · Cleveland, TNThe undetected wear of the ignition switch and key, which allowed removal of the key from an intermediate position and subsequently led to an unintended engine start-up. Contributing to the undetected wear of the 42-year-old ignition switch was the lack of…Jul 26, 2018 · N1311S · No damageNTSB DCA14FA058Accident · No injuriesClass 3 · FieldFinal reportEmbraer EMB145 - EP · Memphis, TNthe failure of the flight crew to adequately monitor the system for proper operation and manually activate the system during the flight in icing conditions. Contributing to the accident was the crew's limited training on the manual operation of the anti-ice…Feb 5, 2014 · N802HK · Substantial damageNTSB ERA14LA108Accident · No injuriesLimited investigationFinal reportEnstrom F 28A · Memphis, TNA skid tube clamp weld failure due to high residual stress, which resulted in a skid collapse during landing. Contributing to the accident was the airplane manufacturer’s lack of adequate guidance for periodically inspecting the skid tube clamp.Jan 29, 2014 · N24RB · Substantial damageNTSB ERA13LA042Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Sevierville, TNThe air traffic controller’s failure to comply with the required vectoring and safety alert procedures, which resulted in the airplane’s flight into rising terrain. Contributing to the accident was the Federal Aviation Administration’s continued practice of…Oct 28, 2012 · N4478F · Substantial damage