# NTSB investigations: Piper PA-28-150, 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 LAX87LA038](https://openairdocs.org/ntsb/LAX87LA038.md): Piper PA-28-150 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1986 · N5153W · Substantial damage
  > The acft went through a fence and collided with trees after a 'hand-propped' start. The student plt had exhausted the acft battery power during previous starting attempts. He then tied the acft down at both wings and the tail. He primed the eng with the…
- [NTSB MKC86LA180](https://openairdocs.org/ntsb/MKC86LA180.md): Piper PA-28-150C · Junction City, KS · Accident · No injuries · Limited investigation · Final report · Aug 27, 1986 · N5969W · Substantial damage
  > The c.f.I. Stated that this flight was to be an aircraft checkout of another instructor. After some air work they proceeded to a nearby airport to practice takeoffs and landings. While on final approach for a practice short field landing the aircraft…

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

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