# NTSB investigations: Pratt & Whitney Canada PT6A-60A, 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 ERA17LA326](https://openairdocs.org/ntsb/ERA17LA326.md): Air Tractor AT 502 · Union City, TN · Accident · No injuries · Limited investigation · Final report · Sep 15, 2017 · N4531K · Substantial damage
  > The catastrophic failure of the compressor turbine blades, which resulted in a total loss of engine power. Contributing to the accident was the installation of undocumented, time-limited engine components of indeterminate age.
- [NTSB MIA01FA152](https://openairdocs.org/ntsb/MIA01FA152.md): Piper PA-31-T2 · Jackson, TN · Accident · 5 fatal · Field investigation · Final report · Jun 3, 2001 · N31XL · Destroyed
  > The pilot's shutting down the left engine following loss of control of the left propeller resulting in an in-flight loss of control of the airplane due to the windmilling propeller. Factors in the accident were the failure of the propeller control bracket…
- [NTSB ATL89FA142](https://openairdocs.org/ntsb/ATL89FA142.md): Embraer EMB-110-P1 · Mt. Pleasant, TN · Accident · 1 fatal · Field investigation · Final report · May 6, 1989 · N95PB · Destroyed
  > Pilot attempted to make a VFR landing in instrument conditions that were below minimums for the published instrument approach and collided with trees and the ground after allowing the airplane to descend below the proper altitude.
- [NTSB IAD79FA017](https://openairdocs.org/ntsb/IAD79FA017.md): Swearingen SA26-T · Memphis, TN · Accident · 1 fatal · Closed · Nov 22, 1978 · N2301N · Destroyed

## 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 ('52043', '51999'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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