# NTSB investigations: Cessna 175, 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 CHI94LA236](https://openairdocs.org/ntsb/CHI94LA236.md): Cessna 175 · Cottage Hill, IL · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 1994 · N7101M · Substantial damage
  > the pilot inadequate preflight planning/preparation and his inaccurate fuel consumption calculations.
- [NTSB CHI94LA160](https://openairdocs.org/ntsb/CHI94LA160.md): Cessna 175 · Plainfield, IL · Accident · No injuries · Limited investigation · Final report · May 14, 1994 · N7678M · Substantial damage
  > fuel contamination (water), and inadequate aircraft preflight inspection.
- [NTSB CHI82DA103](https://openairdocs.org/ntsb/CHI82DA103.md): Cessna 175 · Tuscola, IL · Accident · Minor injuries · Final report · Mar 27, 1982 · N7452M · Destroyed
  > A landing was made on runway 27 just prior to sunset. The pilot reported that he realized he was not slowing fast enough, but due to the low altitude of the setting sun, he misjudged the length of the runway. He initiated a go-around, but did not obtain…
- [NTSB CHI81FA096](https://openairdocs.org/ntsb/CHI81FA096.md): Cessna 175 · Fenton, IL · Accident · 1 fatal · Closed · Sep 6, 1981 · N7234M · Destroyed
- [NTSB CHI76DEE03](https://openairdocs.org/ntsb/CHI76DEE03.md): Cessna 175 · Stockton, IL · Accident · No injuries · Closed · Jul 1, 1975 · N9490B · Substantial damage
- [NTSB CHI75DEV35](https://openairdocs.org/ntsb/CHI75DEV35.md): Cessna 175 · Loraine, IL · Accident · Minor injuries · Closed · Jun 1, 1975 · N9368B · Substantial damage
- [NTSB CHI75FEV14](https://openairdocs.org/ntsb/CHI75FEV14.md): Cessna 175 · Danville, IL · Accident · No injuries · Closed · Nov 28, 1974 · N7603M · Destroyed
- [NTSB CHI73FEY22](https://openairdocs.org/ntsb/CHI73FEY22.md): Cessna 175 · Geff, IL · Accident · Minor injuries · Closed · Feb 28, 1973 · N9293B · Substantial damage
- [NTSB CHI70DBD12](https://openairdocs.org/ntsb/CHI70DBD12.md): Cessna 175 · Ringwood, IL · Accident · No injuries · Closed · Jan 13, 1970 · N7148M · Substantial damage
- [NTSB CHI68D0297](https://openairdocs.org/ntsb/CHI68D0297.md): Cessna 175 · Casey, IL · Accident · No injuries · Closed · Aug 9, 1967 · N9425B · Substantial damage
- [NTSB CHI67F0402](https://openairdocs.org/ntsb/CHI67F0402.md): Cessna 175 · St.Charles, IL · Accident · No injuries · Closed · Dec 12, 1966 · N7005M · Substantial damage
- [NTSB CHI66F0011](https://openairdocs.org/ntsb/CHI66F0011.md): Cessna 175 · Bloomington, IL · Accident · No injuries · Closed · Apr 23, 1965 · N6502E · Substantial damage
- [NTSB UNK64X0444](https://openairdocs.org/ntsb/UNK64X0444.md): Cessna 175 · Decatur, IL · Accident · No injuries · Closed · Feb 2, 1964 · N7300M · 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 ('2072502'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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