# NTSB investigations: Piper PA-25, 1987

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 ATL87LA245](https://openairdocs.org/ntsb/ATL87LA245.md): Piper PA-25 · Myrtle Beach, SC · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1987 · N6094Z · Substantial damage
  > After about 45 mntes into the flight, the pilot noticed a drop in engine oil pressure when he decided to return to the airport. The cabin filled with smoke, and the engine continued to lose power. The pilot had no choice but to ditch. The wreckage…
- [NTSB FTW87DQG02](https://openairdocs.org/ntsb/FTW87DQG02.md): Piper PA-25 · Lubbock, TX · Accident · No injuries · Final report · Aug 5, 1987 · N6400Z · Substantial damage
  > The toe of the pilots left boot was rubbing on the dispensing hopper which restricted application of rudder and brake. This resulted in a loss of control when exiting the runway and the resultant collision with a sign. The fiberglass hopper had deep abrasions…
- [NTSB DEN87LA191](https://openairdocs.org/ntsb/DEN87LA191.md): Piper PA-25 · Portales, NM · Accident · No injuries · Limited investigation · Final report · Jul 20, 1987 · N6419Z · Substantial damage
  > The plt was practicing aerial application maneuvers without chemicals onboard. During a turn, the plt reported that the engine lost power. The plt leveled the wings and lowered the nose to gain airspeed. The plt selected a landing site and after touchdown,…
- [NTSB FTW87LA094](https://openairdocs.org/ntsb/FTW87LA094.md): Piper PA-25 · Jackson, LA · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 1987 · N6166Z · Substantial damage
  > Engine failed due to fuel exhaustion. Aircraft collided with trees short of rwy 33.
- [NTSB CHI87DER05](https://openairdocs.org/ntsb/CHI87DER05.md): Piper PA-25 · Henning, MN · Accident · Minor injuries · Final report · Apr 10, 1987 · N6384Z · Substantial damage
  > After experiencing a rough running engine the pilot initiated an emergency landing. During the off airport landing, the aircraft received substantial damage and the pilot reported minor injuries. This was this pilot's first experience in this type of…

## 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") = 1987
  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=1987

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