# NTSB investigations: Lycoming 0-320 series, IL: In flight collision with terrain/water

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 CHI04CA067](https://openairdocs.org/ntsb/CHI04CA067.md): Cessna 172N · Cahokia, IL · Accident · No injuries · Data collection · Final report · Feb 7, 2004 · N738EJ · Substantial damage
  > The inadequate supervision by the certified flight instructor which lead to the student pilot's failure to maintain clearance from the snowbank during the landing. The snowbank was a factor.
- [NTSB CHI01LA202](https://openairdocs.org/ntsb/CHI01LA202.md): Cessna 172N · West Chicago, IL · Accident · No injuries · Limited investigation · Final report · Jul 10, 2001 · N5285E · Substantial damage
  > The instructor pilot's inadequate recovery from the bounced landing and inadequate supervision of the dual students alignment with the runway. A factor was the student pilot not maintaining proper alignment with the runway during landing.
- [NTSB CHI95FA012](https://openairdocs.org/ntsb/CHI95FA012.md): Piper PA-28-161 · Winfield, IL · Accident · 1 fatal · Field investigation · Final report · Oct 16, 1994 · N9089U · Destroyed
  > Collision with the ground for an undetermined reason. The pilot's psychological condition was a probable factor.
- [NTSB CHI94LA230](https://openairdocs.org/ntsb/CHI94LA230.md): Piper PA-28-140 · Kankakee, IL · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1994 · N7079R · Substantial damage
  > The pilot's poor preflight planning preparation by the improper loading of the airplane.
- [NTSB CHI90DEV02](https://openairdocs.org/ntsb/CHI90DEV02.md): Piper PA-25-150 · Sullivan, IL · Accident · Serious injuries · Final report · Mar 17, 1990 · N6340Z · Destroyed
  > The pilot-in-command's failure to maintain adequate terrain clearance during a turn at low altitude, resulting in ground collision. Contributing to the severity of the pilot's injury was his failure to use the installed shoulder harness.
- [NTSB CHI89LA068](https://openairdocs.org/ntsb/CHI89LA068.md): Piper PA-22-150 · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Apr 4, 1989 · N2944P · Substantial damage
  > The pilot's failure to compensate for the crosswind condition which existed during the landing. Contributing to the accident was the gusty, crosswind which existed and the failure of the aircraft manufacturer to provide crosswind performance data for the…
- [NTSB CHI86FEV03](https://openairdocs.org/ntsb/CHI86FEV03.md): Woodrow Starduster SA-100 · New Baden, IL · Accident · 1 fatal · Final report · Jul 26, 1986 · N64HW · Destroyed
  > The owner of the single seat, home built, acft offered to allow a navy F-14 plt to fly the plane. The owner made a shortflt, then proceeded to give the F-14 plt a cockpit check. The check-out explaination included such things as the flt characteristics,…
- [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…

## 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.engine_model_code IN ('41508')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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