NTSB investigations, 2015, TN

5 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2015, TN per year, 2008–2026: 76 cases
20083
20095
20102
20114
20125
20133
20146
20155
20167
20174
20183
20191
20205
20216
20225
20236
20242
20253
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\") = 2015
    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\" = '440' 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 ERA16LA019Accident · No injuriesLimited investigationFinal reportBeech 23 · Humboldt, TNA partial loss of engine power due to low No. 2 cylinder compression and an inoperative right magneto.Oct 18, 2015 · N2339J · Substantial damageNTSB ERA15LA333Accident · No injuriesLimited investigationFinal reportBeech E 90 · Fayetteville, TNA total loss of electrical power for reasons that could not be determined and the pilot's subsequent failure to properly follow the manual landing gear extension procedures, which resulted in the landing gear not extending.Aug 28, 2015 · N891PC · Substantial damageNTSB ERA15LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Corryton, TNThe failure of the No. 4 engine cylinder due to fatigue, resulting in a catastrophic failure of the engine.May 19, 2015 · N597JG · 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 ERA15LA183Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Spring City, TNThe pilot's failure to properly apply carburetor heat in conditions conducive to carburetor icing, which resulted the accumulation of carburetor ice and the subsequent total loss of engine power.Apr 11, 2015 · N82658 · Substantial damage