# NTSB investigations: Piper PA-16, 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 CHI86LA202](https://openairdocs.org/ntsb/CHI86LA202.md): Piper PA-16 · Effingham, IL · Accident · No injuries · Limited investigation · Final report · Jul 9, 1986 · N5214H · Substantial damage
  > Acft ground looped during landing roll. Plt reported the right seat left brake did not stop wheel from turning. Inspection of right seat brakes revealed corroded aluminum shuttle valve between the co-pilot and pilot brake lines which prevented transfer of…
- [NTSB CHI86LA155](https://openairdocs.org/ntsb/CHI86LA155.md): Piper PA-16 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Jun 15, 1986 · N5370H · Substantial damage
  > The plt with one hr PIC time in the tail wheel acft began to veer to the left during t.o. roll. He applied left brake instead of rt rudder ran off the rwy and struck a ditch.

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

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