# NTSB investigations: Cessna 172L, 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 CHI87IA110](https://openairdocs.org/ntsb/CHI87IA110.md): Cessna 172L · Plainfield, IL · Incident · 1 fatal · Incident investigation · Final report · Mar 29, 1987 · N4211Q · No damage
  > The pilot decided the weather was not good enough to fly, but he would run the engine and turn the tires. He was discovered in the plane by other pilots and later pronounced dead, from carbon monoxide asphyxiation. The muffler had a 12 inch crack which a…
- [NTSB CHI85LA132](https://openairdocs.org/ntsb/CHI85LA132.md): Cessna 172 · Champaign, IL · Accident · No injuries · Limited investigation · Final report · Mar 8, 1985 · N4332Q · Substantial damage
  > During a practice asr apch using a vision restricting device the plt in command exceeded the mda and crashed in a field aprx 1 mile from the airport. Recommended altitudes were being issued by ATC. The safety plt issued a warning concerning the low alt as the…
- [NTSB CHI76FEE36](https://openairdocs.org/ntsb/CHI76FEE36.md): Cessna 172L · Chicago, IL · Accident · No injuries · Closed · Jan 7, 1976 · N7946G · Substantial damage
- [NTSB CHI76FEE22](https://openairdocs.org/ntsb/CHI76FEE22.md): Cessna 172L · Rockfort, IL · Accident · No injuries · Closed · Oct 14, 1975 · N4383Q · Substantial damage
- [NTSB CHI75FEV34](https://openairdocs.org/ntsb/CHI75FEV34.md): Cessna 172L · Mt Sterling, IL · Accident · No injuries · Closed · Jun 3, 1975 · N4229Q · Substantial damage
- [NTSB CHI75FEE15](https://openairdocs.org/ntsb/CHI75FEE15.md): Cessna 172 · Ottawa, IL · Accident · No injuries · Closed · Jul 30, 1974 · N7284Q · Substantial damage
- [NTSB CHI74FEV35](https://openairdocs.org/ntsb/CHI74FEV35.md): Cessna 172L · Quincy, IL · Accident · No injuries · Closed · Jan 14, 1974 · N9883G · Substantial damage
- [NTSB CHI74DEE01](https://openairdocs.org/ntsb/CHI74DEE01.md): Cessna 172L · Chicago, IL · Accident · No injuries · Closed · Jul 7, 1973 · N4382Q · Substantial damage
- [NTSB CHI72DEE52](https://openairdocs.org/ntsb/CHI72DEE52.md): Cessna 172L · Lockport, IL · Accident · No injuries · Closed · Jan 8, 1972 · N7885G · 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 ('2072432'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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