# NTSB investigations: Piper PA-32RT-300, 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 ERA10LA082](https://openairdocs.org/ntsb/ERA10LA082.md): Piper PA-32RT-300 · Memphis, TN · Accident · 1 fatal · Limited investigation · Final report · Nov 29, 2009 · N9243C · Substantial damage
  > The pilot's failure to execute a timely missed approach and subsequent failure to maintain aircraft control, after he was unable to establish the airplane on the instrument approach. Contributing to the accident was the pilot's possible impairment due to his…
- [NTSB ATL96LA045](https://openairdocs.org/ntsb/ATL96LA045.md): Piper PA-32-RT-300 · Blountville, TN · Accident · No injuries · Limited investigation · Final report · Feb 7, 1996 · N2200J · Substantial damage
  > Inadequate maintenance, and subsequent in-flight separation of the cowling, due to worn cowling components.
- [NTSB ATL94FA075](https://openairdocs.org/ntsb/ATL94FA075.md): Piper PA-32RT-300 · Smithville, TN · Accident · 1 fatal · Field investigation · Final report · Apr 7, 1994 · N9710C · Destroyed
  > The pilot's failure to obtain recent weather information to avoid flight into icing conditions. Factors in the accident were: management-induced pressure and the icing conditions.
- [NTSB ATL87LA073](https://openairdocs.org/ntsb/ATL87LA073.md): Piper PA-32RT-300 · Nashville, TN · Accident · No injuries · Limited investigation · Final report · Feb 19, 1987 · N31590 · Destroyed
  > The plt reported that he conducted an ILS appch behind mixed jet and turboprop traffic; the acft encountered an 'extreme downdraft' while on appch and the acft vertical speed went from about 500 fpm to about 1200 fpm. He attempted to recover by adding full…

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

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