# NTSB investigations: Piper PA-28-160, 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 CHI81DEE23](https://openairdocs.org/ntsb/CHI81DEE23.md): Piper PA-28 · Lansing, IL · Accident · No injuries · Closed · Mar 22, 1981 · N5788W · Substantial damage
- [NTSB CHI80DCA02](https://openairdocs.org/ntsb/CHI80DCA02.md): Piper PA-28 · Columbia, IL · Accident · No injuries · Closed · Aug 24, 1980 · N5135W · Substantial damage
- [NTSB CHI80FEV25](https://openairdocs.org/ntsb/CHI80FEV25.md): Piper PA-28 · Lacon, IL · Accident · No injuries · Closed · Jul 7, 1980 · N5796W · Substantial damage
- [NTSB CHI75AC067](https://openairdocs.org/ntsb/CHI75AC067.md): Piper PA-28 · Plainfield, IL · Accident · 1 fatal · Closed · Mar 17, 1975 · N5116W · Destroyed
- [NTSB CHI75AC006](https://openairdocs.org/ntsb/CHI75AC006.md): Piper PA-28 · Columbia, IL · Accident · 1 fatal · Closed · Jul 10, 1974 · N5291W · Destroyed
- [NTSB CHI73DEE20](https://openairdocs.org/ntsb/CHI73DEE20.md): Piper PA-28 · Park Forest, IL · Accident · Minor injuries · Closed · Aug 20, 1972 · N5858W · Substantial damage
- [NTSB CHI73FEE16](https://openairdocs.org/ntsb/CHI73FEE16.md): Piper PA-28 · Lake Zurich, IL · Accident · No injuries · Closed · Aug 12, 1972 · N5086W · Substantial damage
- [NTSB CHI69F0306](https://openairdocs.org/ntsb/CHI69F0306.md): Piper PA-28 · Lombard, IL · Accident · No injuries · Closed · Oct 12, 1968 · N5491W · Destroyed
- [NTSB CHI68F0245](https://openairdocs.org/ntsb/CHI68F0245.md): Piper PA-28 · Monee, IL · Accident · No injuries · Closed · Aug 28, 1967 · N5788W · Substantial damage
- [NTSB CHI66D0641](https://openairdocs.org/ntsb/CHI66D0641.md): Piper PA-28 · Rockford, IL · Accident · No injuries · Closed · Feb 5, 1966 · N5135W · Substantial damage
- [NTSB CHI66D0091](https://openairdocs.org/ntsb/CHI66D0091.md): Piper PA-28 · Pontiac, IL · Accident · No injuries · Closed · Jun 5, 1965 · N5491W · Substantial damage
- [NTSB UNK64X3972](https://openairdocs.org/ntsb/UNK64X3972.md): Piper PA28 · Roselle, IL · Accident · No injuries · Closed · Sep 13, 1964 · N5085W · Substantial damage
- [NTSB UNK64X2689](https://openairdocs.org/ntsb/UNK64X2689.md): Piper PA28 · Kansas, IL · Accident · No injuries · Closed · Jul 6, 1964 · N5639W · 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 ('7102806'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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