# NTSB investigations: Piper PA-36-300, 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 SEA86LA146](https://openairdocs.org/ntsb/SEA86LA146.md): Piper PA-36-300 · Moore, ID · Accident · No injuries · Limited investigation · Final report · Jun 13, 1986 · N3742E · Destroyed
  > During an aerial application turn a rapid rate of descent developed. The pilot released the chemical load at about 100 feet AGL and the aircraft continued to descend to the ground even though the pilot leveled the wings and initially lowered the nose. The…
- [NTSB FTW86LQG12](https://openairdocs.org/ntsb/FTW86LQG12.md): Piper PA-36-300 · Muleshoe, TX · Accident · No injuries · Final report · Feb 28, 1986 · N57878 · Substantial damage
  > The ag acft was climbing after a pass to clear power lines at the north end of the field. The main lndg gear contacted the top wire as the acft started leveling off. The wire did not break and the acft descended to ground impact. The lndg gear snapped off and…

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

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