# NTSB investigations: Cessna 172G, 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 CHI99LA288](https://openairdocs.org/ntsb/CHI99LA288.md): Cessna 172G · Glenarm, IL · Accident · No injuries · Limited investigation · Final report · Aug 13, 1999 · N4425L · Substantial damage
  > the pilot's selection of the wrong runway for the prevailing winds. Factors were the pilot's misunderstanding of the wind information and the tailwind.
- [NTSB CHI97LA298](https://openairdocs.org/ntsb/CHI97LA298.md): Cessna 172G · Chicago, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 1997 · N4375L · Substantial damage
  > the pilot's selection of the wrong taxi route (service road) and not maintaining clearance between his airplane's wing and a bus.
- [NTSB CHI90LA037](https://openairdocs.org/ntsb/CHI90LA037.md): Cessna 172G · Savoy, IL · Accident · No injuries · Limited investigation · Final report · Dec 2, 1989 · N3783L · Substantial damage
  > Improper planning/decision by the pilot, which resulted in his inability to maintain control of the aircraft. A factor related to the accident was: the adverse wind condition.
- [NTSB CHI82DA118](https://openairdocs.org/ntsb/CHI82DA118.md): Cessna 172 · Marion, IL · Accident · No injuries · Final report · Apr 12, 1982 · N4178L · Substantial damage
  > The pilot reported that the wind was from 200 degrees at 22 gusting 30 knots. While taxiing eastbound from the runway, a gust of wind lifted the right wing and tail, and the aircraft nosed over.
- [NTSB CHI79FA078](https://openairdocs.org/ntsb/CHI79FA078.md): Cessna 172G · Brownstown, IL · Accident · 2 fatal · Closed · Sep 18, 1979 · N3623L · Destroyed
- [NTSB CHI76FEV01](https://openairdocs.org/ntsb/CHI76FEV01.md): Cessna 172G · Bloomington, IL · Accident · No injuries · Closed · Jul 7, 1975 · N5726R · Substantial damage
- [NTSB CHI72AC071](https://openairdocs.org/ntsb/CHI72AC071.md): Cessna 172G · Orion, IL · Accident · 3 fatal · Closed · Mar 12, 1972 · N4246L · Destroyed
- [NTSB CHI71FBQ21](https://openairdocs.org/ntsb/CHI71FBQ21.md): Cessna 172 · Manito, IL · Accident · No injuries · Closed · Oct 18, 1970 · N3981L · Substantial damage
- [NTSB CHI69D0649](https://openairdocs.org/ntsb/CHI69D0649.md): Cessna 172 · East St.Louis, IL · Accident · No injuries · Closed · May 3, 1969 · N4450L · Substantial damage
- [NTSB CHI69D0523](https://openairdocs.org/ntsb/CHI69D0523.md): Cessna 172 · Lisle, IL · Accident · No injuries · Closed · Feb 2, 1969 · N170AT · Substantial damage
- [NTSB CHI68D0733](https://openairdocs.org/ntsb/CHI68D0733.md): Cessna 172 · Ottawa, IL · Accident · No injuries · Closed · Apr 29, 1968 · N4289L · Substantial damage
- [NTSB CHI68F0681](https://openairdocs.org/ntsb/CHI68F0681.md): Cessna 172 · Peoria, IL · Accident · No injuries · Closed · Apr 11, 1968 · N6088R · Substantial damage
- [NTSB CHI68F0185](https://openairdocs.org/ntsb/CHI68F0185.md): Cessna 172G · Greenwood, IL · Accident · Minor injuries · Closed · Aug 3, 1967 · N4492L · Substantial damage
- [NTSB CHI68F0219](https://openairdocs.org/ntsb/CHI68F0219.md): Cessna 172 · Lexington, IL · Accident · Minor injuries · Closed · Jul 24, 1967 · N3605L · Substantial damage
- [NTSB CHI68D0060](https://openairdocs.org/ntsb/CHI68D0060.md): Cessna 172 · Northbrook, IL · Accident · No injuries · Closed · Jun 25, 1967 · N5738R · Substantial damage
- [NTSB CHI68F0127](https://openairdocs.org/ntsb/CHI68F0127.md): Cessna 172G · Polo, IL · Accident · Minor injuries · Closed · Jun 11, 1967 · N3696L · Substantial damage
- [NTSB CHI67F0609](https://openairdocs.org/ntsb/CHI67F0609.md): Cessna 172 · Ottawa, IL · Accident · No injuries · Closed · Mar 24, 1967 · N6059R · Substantial damage
- [NTSB CHI67D0584](https://openairdocs.org/ntsb/CHI67D0584.md): Cessna 172G · Cahokia, IL · Accident · No injuries · Closed · Mar 10, 1967 · N4699L · Substantial damage
- [NTSB CHI67D0412](https://openairdocs.org/ntsb/CHI67D0412.md): Cessna 172G · Mt.Carroll, IL · Accident · No injuries · Closed · Dec 6, 1966 · N6088R · Substantial damage
- [NTSB CHI67D0636](https://openairdocs.org/ntsb/CHI67D0636.md): Cessna 172 · Pittsfield, IL · Accident · No injuries · Closed · Oct 20, 1966 · N3891L · Substantial damage
- [NTSB CHI67F0056](https://openairdocs.org/ntsb/CHI67F0056.md): Cessna 172G · Columbia, IL · Accident · No injuries · Closed · Jun 14, 1966 · N3969L · Substantial damage
- [NTSB CHI66F0511](https://openairdocs.org/ntsb/CHI66F0511.md): Cessna 172G · Streator, IL · Accident · No injuries · Closed · Dec 26, 1965 · N3605L · 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 ('2072420'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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