# NTSB investigations: Piper PA-36-375, 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 FTW86LQG16](https://openairdocs.org/ntsb/FTW86LQG16.md): Piper PA-36-375 · Plainview, TX · Accident · No injuries · Final report · Aug 11, 1986 · N2370X · Substantial damage
  > The pilot stated that he ran out of fuel as he was returning from an agricultural application flight. While landing in cotton rows, the gear collapsed and the aircraft was substantially damaged.
- [NTSB DEN86LA166](https://openairdocs.org/ntsb/DEN86LA166.md): Piper PA-36 · Onida, SD · Accident · No injuries · Limited investigation · Final report · Jun 19, 1986 · N3856E · Destroyed
  > The plt reported a partial loss of pwr occurred momentarily before liftoff. The takeoff was continued and once airborne the pwr loss reoccurred. The load was dumped, however, the acft impacted trees aprx 1 mile from the arpt as sufficient alt could not be…
- [NTSB CHI86LA153](https://openairdocs.org/ntsb/CHI86LA153.md): Piper PA-36-375 · Breckenridge, MN · Accident · No injuries · Limited investigation · Final report · Jun 13, 1986 · N6184A · Substantial damage
  > Aircraft collided with a truck while engaged in aerial application work. Pilot was unable to maintain control and the aircraft collided with terrain after an uncontrolled descent. Investigation revealed that the aileron had separated due to the collision.

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

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