# NTSB investigations: Piper PA-28R-201, 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 LAX87FA071](https://openairdocs.org/ntsb/LAX87FA071.md): Piper PA-28R-201 · Gorman, CA · Accident · 1 fatal · Field investigation · Final report · Dec 27, 1986 · N50U · Destroyed
  > The aircraft descended into mountainous terrain during a night cross-country flight. The surviving pilot stated that he was attending to paperwork and when he looked up he turned on the landing light in time to see trees just prior to impact. He further…
- [NTSB CHI86LA175](https://openairdocs.org/ntsb/CHI86LA175.md): Piper PA-28R-201 · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Jul 14, 1986 · N31588 · Substantial damage
  > The pilot was unable to get a down and locked indication for the left main gear and upon touchdown the left gear collapsed. Inspection revealed an internal failure of the left main actuator. The fluid had leaked past the o-rings and prevented the gear from…
- [NTSB NYC86LA170](https://openairdocs.org/ntsb/NYC86LA170.md): Piper PA-28R-201 · West Dover, VT · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1986 · N43792 · Substantial damage
  > Shortly after liftoff, the aircraft encountered a tailwind and downdraft forcing the aircraft downward and subsequently impacted trees and collided with the ground.
- [NTSB MIA86FA110](https://openairdocs.org/ntsb/MIA86FA110.md): Piper PA-28R-201 · Ocklawaha, FL · Accident · 1 fatal · Field investigation · Final report · Apr 4, 1986 · N742JM · Destroyed
  > The pvt plt refueled his acft the night before the flt and was observed to drain only the firewall strainer. The morning of the flt he did not drain any drains. About half way to his destination an eng pwr loss was experienced, he declared an emergency and…
- [NTSB MIA86LA061](https://openairdocs.org/ntsb/MIA86LA061.md): Piper PA-38-112 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Jan 20, 1986 · N2361D · 2 aircraft · Substantial damage
  > The plt stated that he was completing his run-up prior to takeoff, looked up & was only able to pull the power off before he was struck by N2361D.

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

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