# NTSB investigations: Cessna 172S, 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 CEN20FA110](https://openairdocs.org/ntsb/CEN20FA110.md): Cessna 172 · Lincoln, IL · Accident · 3 fatal · Class 3 · Field · Final report · Mar 3, 2020 · N157SF · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack during an aerial survey, which resulted in an aerodynamic stall at an altitude too low to recover.
- [NTSB GAA15CA161](https://openairdocs.org/ntsb/GAA15CA161.md): Cessna 172S · Galesburg, IL · Accident · No injuries · Data collection · Final report · Jun 10, 2015 · N740SP · Substantial damage
  > Firewall damage reported by maintenance personnel that occurred during an unknown phase of flight, because the accident flight and pilot could not be determined.
- [NTSB CHI07CA054](https://openairdocs.org/ntsb/CHI07CA054.md): Cessna 172S · Alton, IL · Accident · No injuries · Data collection · Final report · Jan 3, 2007 · N364MA · Substantial damage
  > The student pilot's inadequate recovery from a bounced landing, which resulted in the airplane impacting a runway sign. A factor in the accident was the student pilot's misjudged landing flare.
- [NTSB CHI03LA102](https://openairdocs.org/ntsb/CHI03LA102.md): Cessna 172S · Grayslake, IL · Accident · No injuries · Limited investigation · Final report · Apr 11, 2003 · N389SP · Substantial damage
  > The flight instuctor's improper in-flight decision to land with a tailwind and failure to maintain directional control of the airplane during landing. Factors contributing to the accident were the tailwind, the student pilot's inadequate flare, and the muddy…
- [NTSB CHI01LA205](https://openairdocs.org/ntsb/CHI01LA205.md): Cessna 172S · Lake in the Hil, IL · Accident · No injuries · Limited investigation · Final report · Jul 11, 2001 · N795SP · Substantial damage
  > The student pilot misjudging the flare during that landing. Factors were the wrong runway selected by the student pilot, the tailwinds encountered during that landing and the flight instructor's inadequate supervision during that landing.
- [NTSB CHI99LA092](https://openairdocs.org/ntsb/CHI99LA092.md): Cessna 172RG · Lawrenceville, IL · Accident · No injuries · Limited investigation · Final report · Feb 15, 1999 · N9506D · Substantial damage
  > the fatigue fracture of the landing gear actuator.

## 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 ('2072439', '2072442'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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