# NTSB investigations: Piper PA-31-310, 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 MIA88LA040](https://openairdocs.org/ntsb/MIA88LA040.md): Piper PA-31-310 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Nov 11, 1987 · N112AG · Substantial damage
  > The plt stated that while enroute to West Palm Beach, she encountered severe turbulence. The aft cabin door popped open but remained attached and the flt was continued and lndd w/o further incident. As the plt attempted to restart the engs for the return trip…
- [NTSB NYC88LA013](https://openairdocs.org/ntsb/NYC88LA013.md): Piper PA-31-310 · Beverly, MA · Accident · No injuries · Limited investigation · Final report · Oct 21, 1987 · N9249Y · Substantial damage
  > The plt rprtd that drg an NDB apch, the acft 'broke out slightly above minimums' & that he maneuvered to land from a close-in, base leg. He stated that drg a left turn to final apch, the left eng began losing power. Rprtdly, there was a lack of response to…
- [NTSB SEA87FA098](https://openairdocs.org/ntsb/SEA87FA098.md): Piper PA-31-350 · North Las Vegas, NV · Accident · 1 fatal · Field investigation · Final report · May 20, 1987 · N22LV · Destroyed
  > A mechanic, who was not rated as a plt, took the acft without permission & elected to takeoff at ngt. A witness saw the acft dep at about 0250 PDT. Subsequently, it crashed aprx 3 mi ene of the arpt in an open undeveloped area. The time of the acdnt was not…
- [NTSB DEN87IA056](https://openairdocs.org/ntsb/DEN87IA056.md): Piper PA-31 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Feb 14, 1987 · N7559L · No damage
  > While taxiing from a cargo ramp for takeoff on an IFR flt, the acft taxied off the ramp into the infield on the arpt and came to rest with the engines running. Ramp personnel boarded the acft, shut the engines down and summoned medical help for the plt who…

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

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