# Fatal NTSB investigations: Piper PA-39

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 CEN13WA301](https://openairdocs.org/ntsb/CEN13WA301.md): Piper PA-39 · Wolfsbehringen, Germany · Accident · 1 fatal · Foreign investigation · May 27, 2013 · N8977Y · Substantial damage
- [NTSB DEN07WA147](https://openairdocs.org/ntsb/DEN07WA147.md): Piper PA-39 · Vannes, France · Accident · 2 fatal · Foreign investigation · Aug 25, 2007 · N13PF · Destroyed
- [NTSB CHI94DCA01](https://openairdocs.org/ntsb/CHI94DCA01.md): Piper PA-39 · Viburnum, MO · Accident · 1 fatal · Final report · Feb 18, 1994 · N8913Y · Destroyed
  > The pilot's failure to maintain adequate airspeed during the turn to final. The gusty tailwind during the turn was a contributing factor.
- [NTSB NYC88FA248](https://openairdocs.org/ntsb/NYC88FA248.md): Piper PA-39-30 · Margaretville, NY · Accident · 2 fatal · Field investigation · Final report · Jul 31, 1988 · N2875A · Destroyed
  > The acft departed block island, RI en route to stewart international airport, newburgh, new york, the aircraft never arrived and was reported missing August 2, 1988. The aircraft was missing until November 21, 1988 when it was found near Margaretville, NY by…
- [NTSB CHI79FA072](https://openairdocs.org/ntsb/CHI79FA072.md): Piper PA-24 · Bloomfield Twp, WI · Accident · 2 fatal · Closed · Sep 2, 1979 · N6051P · 2 aircraft · Substantial damage
- [NTSB IAD76AI053](https://openairdocs.org/ntsb/IAD76AI053.md): Piper PA-39 · Clover Lick, WV · Accident · 3 fatal · Closed · Jan 21, 1976 · N8868Y · 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103902'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=7103902

---
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.