# NTSB investigations: AiResearch TPE331 series, TN

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 ERA21LA124](https://openairdocs.org/ntsb/ERA21LA124.md): Cessna 441 · Belvidere, TN · Accident · 2 fatal · Class 3 · Limited · Final report · Feb 7, 2021 · N44776 · Destroyed
  > The pilot’s failure to follow the published instrument approach procedure by prematurely descending the airplane below the final approach fix altitude to fly under the low ceiling conditions, which resulted in controlled flight into terrain.
- [NTSB ERA14FA112](https://openairdocs.org/ntsb/ERA14FA112.md): Gulfstream AM Corp Comm Div 690 · Bellevue, TN · Accident · 4 fatal · Field investigation · Final report · Feb 3, 2014 · N840V · Destroyed
  > The pilot's failure to maintain airspeed with one engine inoperative, which resulted in a loss of control while on approach. Contributing to the accident were airframe ice accumulation due to conditions conducive to icing and the loss of engine power on one…
- [NTSB ERA09FA083](https://openairdocs.org/ntsb/ERA09FA083.md): Mitsubishi MU-2B-60 · Millington, TN · Accident · Minor injuries · Field investigation · Final report · Dec 9, 2008 · N452MA · Substantial damage
  > The pilot’s improper configuration of the airplane following an engine shutdown, which resulted in a low-altitude, unstabilized approach. Contributing to the accident was a loss of engine power for undetermined reasons.
- [NTSB FTW03IA073](https://openairdocs.org/ntsb/FTW03IA073.md): Mitsubishi MU-2B-60 · Memphis, TN · Incident · No injuries · Incident investigation · Final report · Aug 20, 2002 · N610CA · No damage
  > the loss of right engine power as a result of a fatigue failure of the propeller shaft coupling.
- [NTSB ATL99LA054](https://openairdocs.org/ntsb/ATL99LA054.md): Mitsubishi MU-2B-20 · Knoxville, TN · Accident · No injuries · Limited investigation · Final report · Mar 12, 1999 · N176BJ · Substantial damage
  > A loss of engine power for undetermined reasons. Contributing to the accident was the failure of the landing gear to extend for undetermined reasons.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01514', '01517'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=01514&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.