# NTSB investigations: Piper PA-18, 1987

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 ANC87LA148](https://openairdocs.org/ntsb/ANC87LA148.md): Piper PA-18 · Gold King, AK · Accident · No injuries · Limited investigation · Final report · Sep 7, 1987 · N1265A · Substantial damage
  > The pilot stated that during the take off roll he lost directional control of the aircraft causing the aircraft to exit the strip into a row of trees.
- [NTSB ANC87LA134](https://openairdocs.org/ntsb/ANC87LA134.md): Piper PA-18 · Kwethluk, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 1987 · N7233K · Substantial damage
  > The pilot stated that he was flying a search and rescue mission for a missing aircraft when he noticed that his airspeed indicator was not working. He landed on a lake in gusty wind conditions to correct the problem. During the ensuing takeoff attempt, a gust…
- [NTSB ANC87FA112](https://openairdocs.org/ntsb/ANC87FA112.md): Piper PA-18 · Anchorage, AK · Accident · Serious injuries · Field investigation · Final report · Jul 31, 1987 · N5416H · Substantial damage
  > Two certificated flight instructors intended to practice landings in a tail wheel airplane. Shortly after the first take off, the PIC stated that there was an abrupt loss of power. The airplane was unable to return to the airport and crashed on a residential…
- [NTSB MKC87FA051](https://openairdocs.org/ntsb/MKC87FA051.md): Piper PA-18 · Venango, NE · Accident · 1 fatal · Field investigation · Final report · Feb 22, 1987 · N9498D · Destroyed
  > A witness saw the airplane fly over his property from the north to the south and he waved to the pilots. The airplane then came back toward the north at a low altitude and when the witness heard the power being applied, the left wing dropped and almost…

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

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

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