# NTSB investigations: Piper PA-16, IL

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 CHI78FCA02](https://openairdocs.org/ntsb/CHI78FCA02.md): Piper PA-16 · Columbia, IL · Accident · Serious injuries · Closed · Jun 18, 1978 · N5907H · Substantial damage
- [NTSB CHI72DEV18](https://openairdocs.org/ntsb/CHI72DEV18.md): Piper PA-16 · Lawrenceville, IL · Accident · No injuries · Closed · Nov 20, 1971 · N5899H · Substantial damage
- [NTSB CHI71FBD26](https://openairdocs.org/ntsb/CHI71FBD26.md): Piper PA-16 · West Chicago, IL · Accident · No injuries · Closed · Sep 11, 1970 · N5735H · Substantial damage
- [NTSB CHI69D0353](https://openairdocs.org/ntsb/CHI69D0353.md): Piper PA-16 · Crescent City, IL · Accident · No injuries · Closed · Sep 1, 1968 · N6806K · Substantial damage
- [NTSB CHI68F0732](https://openairdocs.org/ntsb/CHI68F0732.md): Piper PA-16 · Grayslake, IL · Accident · No injuries · Closed · Apr 21, 1968 · N6850K · Substantial damage
- [NTSB CHI67D0001](https://openairdocs.org/ntsb/CHI67D0001.md): Piper PA-16 · Chicago, IL · Accident · No injuries · Closed · May 26, 1966 · N5631H · Substantial damage

## 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 c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA'
  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&state=IL

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