# NTSB investigations: Piper PA-32R-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 GAA15CA051](https://openairdocs.org/ntsb/GAA15CA051.md): Piper PA 32R-300 · Gatlinburg, TN · Accident · No injuries · Data collection · Final report · Apr 26, 2015 · N2269M · Substantial damage
  > The pilot's encounter with extreme turbulence during descent over mountainous terrain, which resulted in a loss of control, and structural damage in flight.
- [NTSB ERA13LA042](https://openairdocs.org/ntsb/ERA13LA042.md): Piper PA-32R-300 · Sevierville, TN · Accident · Minor injuries · Limited investigation · Final report · Oct 28, 2012 · N4478F · Substantial damage
  > The air traffic controller’s failure to comply with the required vectoring and safety alert procedures, which resulted in the airplane’s flight into rising terrain. Contributing to the accident was the Federal Aviation Administration’s continued practice of…
- [NTSB ATL03LA053](https://openairdocs.org/ntsb/ATL03LA053.md): Piper PA-32R-300 · Rogersville, TN · Accident · No injuries · Limited investigation · Final report · Mar 4, 2003 · N4135Q · Substantial damage
  > The pilot's improper landing flare which resulted in a hard landing.
- [NTSB MIA96LA066](https://openairdocs.org/ntsb/MIA96LA066.md): Piper PA-32R-300 · Smithville, TN · Accident · Minor injuries · Limited investigation · Final report · Jan 19, 1996 · N4457X · Substantial damage
  > The pilot's improper in-flight planning/decision, which resulted in a heavy load of airframe ice, an inability to maintain altitude, and a subsequent emergency landing. Factors relating to the accident were: the adverse weather (icing) condition, which was…
- [NTSB ATL87FA007](https://openairdocs.org/ntsb/ATL87FA007.md): Piper PA-32R-300 · Nashville, TN · Accident · 1 fatal · Field investigation · Final report · Oct 20, 1986 · N5260F · Destroyed
  > The flight was cleared for the localizer approach to rwy 31. The pilot reported the airport in sight. The flight descended into the cloud layer and crashed about 1000 feet short of the middle marker. The pilot did not report any aircraft problem. The approach…
- [NTSB IAD78IA071](https://openairdocs.org/ntsb/IAD78IA071.md): Piper PA-32R · Chattanooga, TN · Incident · No injuries · Closed · Jun 4, 1978 · N8929C · Minor damage

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

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