# NTSB investigations: Piper PA-25, 1986

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 ATL86LA254](https://openairdocs.org/ntsb/ATL86LA254.md): Piper PA-25 · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Aug 27, 1986 · N9101D · Destroyed
  > The acft was about 1/2 hrs into a planned 2.0 hr banner tow flt. On the last pass along the Beach, at about 500 ft AGL, the eng popped and lost pwr. The plt turned the acft out to sea and landed in the ocean. The plt swam to shore and the acft sank.
- [NTSB DEN86FTK03](https://openairdocs.org/ntsb/DEN86FTK03.md): Piper PA-25 · Badger, SD · Accident · 1 fatal · Final report · Jun 17, 1986 · N6120Z · Substantial damage
  > The acft nosed over during a forced landing after takeoff. The acft was landed straight ahead and rolled out into a standing pool of water 8-10 inches deep where it flipped over crushing the canopy and trapping the plts body. During post acc invest sediment…
- [NTSB ATL86LA119](https://openairdocs.org/ntsb/ATL86LA119.md): Piper PA-25-150 · Braselton, GA · Accident · No injuries · Limited investigation · Final report · Apr 27, 1986 · N6242Z · Substantial damage
  > The pilot reported that the engine RPM decreased while conducting a banner tow flight and that the engine subsequently quit. The airplane was landed in a field of an auto race track where a telephone pole was struck during the landing roll. Temperature was 92…

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

This list as a web page: https://openairdocs.org/ntsb?model=7102502&year=1986

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