# Fatal NTSB investigations, TN: Part(s) separation from AC

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ERA26FA241](https://openairdocs.org/ntsb/ERA26FA241.md): Cessna 177RG · Morrison, TN · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 17, 2026 · N7637V · Substantial damage
  > On June 17, 2026, about 1215 central daylight time, a Cessna 177RG, N7637V, was substantially damaged when it was involved in an accident near Morrison, Tennessee. The pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title…
- [NTSB ERA24FA274](https://openairdocs.org/ntsb/ERA24FA274.md): Air Tractor AT502 · Martin, TN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 25, 2024 · N325RA · Substantial damage
  > On June 25, 2024, about 0820 central daylight time, an Air Tractor, Inc. AT-502A, N325RA, was substantially damaged when it was involved in an accident near Martin, Tennessee. The commercial pilot was fatally injured. The airplane was operated as a Title…
- [NTSB ERA23FA219](https://openairdocs.org/ntsb/ERA23FA219.md): Cessna 182 · Reliance, TN · Accident · 1 fatal · Class 3 · Field · Final report · May 7, 2023 · N725AS · Substantial damage
  > The pilot’s decision to continue an instrument flight into an area of forecast weather with severe to extreme turbulence associated with a line of thunderstorms, which resulted in an in-flight breakup. Contributing was the pilot’s operation of the airplane in…
- [NTSB ERA18FA240](https://openairdocs.org/ntsb/ERA18FA240.md): Lance M Hooley Jetez · Covington, TN · Accident · 1 fatal · Field investigation · Final report · Sep 1, 2018 · N815EY · Destroyed
  > The improper manufacture of the left wing, which resulted in a left wing flutter event and failure at low altitude and high speed.
- [NTSB ERA14FA421](https://openairdocs.org/ntsb/ERA14FA421.md): Klaas Development Lancair IV P · Ooltewah, TN · Accident · 1 fatal · Field investigation · Final report · Sep 3, 2014 · N541EM · Substantial damage
  > The inadequate torque of the propeller mounting bolts and inspection of the propeller, which resulted in the fatigue fracture of the bolts and a subsequent in-flight separation of the propeller assembly.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '338' 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
```

This list as a web page: https://openairdocs.org/ntsb-events/338/sequence?fatal=1&state=TN

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
