# Fatal NTSB investigations: Piper PA-28-140, 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 CEN26FA141](https://openairdocs.org/ntsb/CEN26FA141.md): Piper PA-28-140 · Rock Falls, IL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 20, 2026 · N9913W · Destroyed
  > On March 20, 2026, about 1503 central daylight time, a Piper PA-28-140 airplane, N9913W, was destroyed when it was involved in an accident near Rock Falls, Illinois. The student pilot sustained fatal injuries. The airplane was being operated as a Title 14…
- [NTSB CHI81FA086](https://openairdocs.org/ntsb/CHI81FA086.md): Piper PA-28 · Altamont, IL · Accident · 3 fatal · Closed · Aug 12, 1981 · N4565X · Destroyed
- [NTSB CHI77FEE32](https://openairdocs.org/ntsb/CHI77FEE32.md): Piper PA-28 · Wadsworth, IL · Accident · 2 fatal · Closed · Jul 18, 1977 · N6899J · Destroyed
- [NTSB CHI77FA034](https://openairdocs.org/ntsb/CHI77FA034.md): Piper PA-28 · Chicago, IL · Accident · 1 fatal · Closed · Mar 6, 1977 · N40922 · Destroyed
- [NTSB CHI76AC022](https://openairdocs.org/ntsb/CHI76AC022.md): Piper PA-28 · Orland Park, IL · Accident · 2 fatal · Closed · Sep 6, 1975 · N5968U · 2 aircraft · Destroyed
- [NTSB CHI75AC078](https://openairdocs.org/ntsb/CHI75AC078.md): Piper PA-28 · Trimble, IL · Accident · 2 fatal · Closed · Apr 14, 1975 · N95243 · Destroyed
- [NTSB CHI75AC068](https://openairdocs.org/ntsb/CHI75AC068.md): Piper PA-28 · Concord, IL · Accident · 2 fatal · Closed · Mar 19, 1975 · N15004 · Destroyed
- [NTSB CHI72FEE09](https://openairdocs.org/ntsb/CHI72FEE09.md): Piper PA-28 · Western Spgs, IL · Accident · 1 fatal · Closed · Jul 28, 1971 · N98008 · Destroyed
- [NTSB CHI71FBD65](https://openairdocs.org/ntsb/CHI71FBD65.md): Piper PA-28 · Kewanee, IL · Accident · 1 fatal · Closed · Apr 19, 1971 · N6418R · Substantial damage
- [NTSB CHI71AC042](https://openairdocs.org/ntsb/CHI71AC042.md): Piper PA-28 · Effingham, IL · Accident · 3 fatal · Closed · Dec 17, 1970 · N4253J · Destroyed
- [NTSB CHI71AC016](https://openairdocs.org/ntsb/CHI71AC016.md): Piper PA-28 · Manteno, IL · Accident · 4 fatal · Closed · Aug 22, 1970 · N5684U · Destroyed
- [NTSB CHI70F0111](https://openairdocs.org/ntsb/CHI70F0111.md): Piper PA-28 · Grayslake, IL · Accident · 1 fatal · Closed · Jun 17, 1969 · N6788W · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=7102802&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
