# NTSB investigations: Piper PA-18-125, 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 DEN88FA001](https://openairdocs.org/ntsb/DEN88FA001.md): Piper PA-18-125 · Miles City, MT · Accident · 1 fatal · Field investigation · Final report · Oct 1, 1987 · N1377A · Substantial damage
  > A cattle rancher was flying his aircraft looking for stray cattle and checking the condition of the ranch. He was at approximately 300 feet AGL when he spotted cattle that had strayed off the ranch. The pilot turned to get a better view of the cattle and flew…
- [NTSB MIA87LA128](https://openairdocs.org/ntsb/MIA87LA128.md): Piper PA-18-125 · Ft.Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Apr 5, 1987 · N9663H · Substantial damage
  > The plt reported that while towing a banner aprx 200-300 yards offshore at an alt of aprx 500 ft the eng sputtered, then quit. Attempts to restart it were unsuccessful. The banner was then released & the acft was ditched in the ocean. Post crash examination…

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

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