# NTSB investigations: Piper PA-28-236, 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 DEN86FA181](https://openairdocs.org/ntsb/DEN86FA181.md): Piper PA-28-236 · Townsend, MT · Accident · 1 fatal · Field investigation · Final report · Jun 29, 1986 · N100WX · Destroyed
  > On 6/26/86, the plt & his wife had flown from helena, MT. To powell, WY, to visit family & relatives. On the day of the acdnt, he had consumed alcoholic beverages. Despite pleas fm his wife not to return to helena that evening, he elected to fly back. While…
- [NTSB LAX86FA233](https://openairdocs.org/ntsb/LAX86FA233.md): Piper PA 28-236 · Chino, CA · Accident · 4 fatal · Field investigation · Final report · May 27, 1986 · N43504 · Substantial damage
  > The private non-instrument rated pilot, overflew his home airport by 23 nautical miles upon returning from a night cross country flight and descended into a hill. Instrument meteorological conditions were reported in the area due to reduced visibility. The…
- [NTSB CHI86LA064](https://openairdocs.org/ntsb/CHI86LA064.md): Piper PA-28-236 · Schaumburg, IL · Accident · No injuries · Limited investigation · Final report · Jan 11, 1986 · N8470H · Substantial damage
  > According to the pilot, the aircraft had been refueled the day before in buffalo new york. The aircraft was then flown to chicago,IL. The duration of the flight was four hours and thirty minutes. The following day, without refueling, the aircraft was flown to…

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

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