# NTSB investigations: Cessna 172E, MI

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 CHI07CA090](https://openairdocs.org/ntsb/CHI07CA090.md): Cessna 172E · Big Rapids, MI · Accident · No injuries · Data collection · Final report · Mar 14, 2007 · N3622S · Substantial damage
  > The student pilot's failure to maintain directional control of the airplane during takeoff which led to the impact with the snow banks adjacent to the runway. The snow banks were contributing factors in the accident.
- [NTSB CHI96LA213](https://openairdocs.org/ntsb/CHI96LA213.md): Cessna 172 · Conway, MI · Accident · No injuries · Limited investigation · Final report · Jun 23, 1996 · N3823S · Substantial damage
  > A crack in the intake manifold which led to oil exhaustion and subsequent piston failure. A factor was the soft field.
- [NTSB CHI91LA269](https://openairdocs.org/ntsb/CHI91LA269.md): Cessna 172E · Harbor Springs, MI · Accident · No injuries · Limited investigation · Final report · Aug 22, 1991 · N3891S · Substantial damage
  > The pilot's failure to adequately compensate for wind conditions. A factor associated with the accident was his delay in initiating the go-around.
- [NTSB CHI78FEC22](https://openairdocs.org/ntsb/CHI78FEC22.md): Cessna 172E · Almont, MI · Accident · No injuries · Closed · Mar 4, 1978 · N3063U · Substantial damage
- [NTSB CHI72FEC23](https://openairdocs.org/ntsb/CHI72FEC23.md): Cessna 172E · Lake Orion, MI · Accident · No injuries · Closed · Jan 5, 1972 · N5611T · Substantial damage
- [NTSB CHI72FEM10](https://openairdocs.org/ntsb/CHI72FEM10.md): Cessna 172E · Bay City, MI · Accident · No injuries · Closed · Aug 16, 1971 · N3601S · Destroyed
- [NTSB CHI71FDW10](https://openairdocs.org/ntsb/CHI71FDW10.md): Cessna 172E · Pontiac, MI · Accident · Serious injuries · Closed · Aug 16, 1970 · N5581T · Destroyed
- [NTSB CHI68F0238](https://openairdocs.org/ntsb/CHI68F0238.md): Cessna 172 · Detroit, MI · Accident · No injuries · Closed · Sep 5, 1967 · N3051U · Substantial damage
- [NTSB CHI68F0312](https://openairdocs.org/ntsb/CHI68F0312.md): Cessna 172 · Fennville, MI · Accident · No injuries · Closed · Aug 24, 1967 · N5581T · Substantial damage
- [NTSB CHI67D0146](https://openairdocs.org/ntsb/CHI67D0146-201158.md): Cessna 172 · Reed City, MI · Accident · No injuries · Closed · Jul 31, 1966 · N5407T · Substantial damage
- [NTSB CHI66A0045](https://openairdocs.org/ntsb/CHI66A0045.md): Cessna 172E · St.Joseph, MI · Accident · 1 fatal · Closed · Nov 7, 1965 · N3573S · Destroyed
- [NTSB UNK64X3900](https://openairdocs.org/ntsb/UNK64X3900.md): Cessna 172 · Detroit, MI · Accident · No injuries · Closed · Sep 10, 1964 · N3661S · Substantial damage
- [NTSB UNK64X3239](https://openairdocs.org/ntsb/UNK64X3239.md): Cessna 172 · Ypsilanti, MI · Accident · No injuries · Closed · Aug 6, 1964 · N5418T · Destroyed
- [NTSB UNK64X3207](https://openairdocs.org/ntsb/UNK64X3207.md): Cessna 172 · Three Oaks, MI · Accident · No injuries · Closed · Aug 4, 1964 · N5519T · Substantial damage
- [NTSB UNK64X2426](https://openairdocs.org/ntsb/UNK64X2426.md): Cessna 172 · Three Oaks, MI · Accident · No injuries · Closed · Jun 21, 1964 · N5508T · 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" = 'MI' 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 ('2072412'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072412&state=MI

---
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.