# NTSB investigations: Piper PA-28, 1985

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 FTW86LA013](https://openairdocs.org/ntsb/FTW86LA013.md): Piper PA-28 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Oct 11, 1985 · N5341W · Substantial damage
  > The passengers stated that the pilot was unable to obtain higher power settings on a go-around from a low approach to an airport, and elected to land on a rural street. An examination of the engine revealed insect nests in the intake manifold and water in the…
- [NTSB MKC85LA159](https://openairdocs.org/ntsb/MKC85LA159.md): Piper PA-28 · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Jul 15, 1985 · N5424W · Substantial damage
  > During a wx briefing, the plt was advised of possible thunderstorms at his destination. While en route, he was told that thunderstorm activity at his destination was confirmed by radar. During the last 40 min of the flt, the plt flew past aprx 15 arpts where…
- [NTSB LAX85LA242](https://openairdocs.org/ntsb/LAX85LA242.md): Piper PA-28-160 · Springville, CA · Accident · No injuries · Limited investigation · Final report · May 5, 1985 · N5166W · Substantial damage
  > After overflying the uncharted, private airstrip & evaluating its size, the PIC attempted to land on the narrow rwy. Only about 900 ft of the rwy was usable. After touching down, the plt realized the acft could not be stopped on the remaining available strip,…

## 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") = 1985
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102801'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102801&year=1985

---
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.