# NTSB investigations: Cessna 172C, 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 CHI93LA226](https://openairdocs.org/ntsb/CHI93LA226.md): Cessna 172C · West Chicago, IL · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 1993 · N1441Y · Substantial damage
  > the pilot's improper use of carburetor heat. Conditions conducive to the formation of carburetor ice was a factor.
- [NTSB CHI92LA052](https://openairdocs.org/ntsb/CHI92LA052.md): Cessna 172 · Carlyle, IL · Accident · Serious injuries · Limited investigation · Final report · Dec 11, 1991 · N8316X · Substantial damage
  > Fuel contamination and blockage of the carburetor, which restuled in fuel starvation. The high obstructions (trees) were a related factor.
- [NTSB CHI86LA217](https://openairdocs.org/ntsb/CHI86LA217.md): Cessna 172C · Bement, IL · Accident · No injuries · Limited investigation · Final report · Aug 30, 1986 · N8404X · Substantial damage
  > On touchdown the aircraft was not properly aligned with the rwy. While rolling out the left wing caught the full grown corn on the left edge of the rwy and pulled the aircraft into the corn.
- [NTSB CHI85LA248](https://openairdocs.org/ntsb/CHI85LA248.md): Cessna 172 · East Alton, IL · Accident · No injuries · Limited investigation · Final report · Jun 23, 1985 · N8486X · Substantial damage
  > The acft was blown inverted by wind gusts shortly after landing. The plt stated the wx was fine until after touchdown when the wind began gusting to 35 KTS. The plt turned the acft left off the rwy, contacted ground control and initiated a right turn onto the…
- [NTSB CHI69F0019](https://openairdocs.org/ntsb/CHI69F0019.md): Cessna 172 · Paris, IL · Accident · No injuries · Closed · Jun 4, 1968 · N8392X · 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 ('2072408'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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