# NTSB investigations: Cessna 172B, 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 CHI97LA085](https://openairdocs.org/ntsb/CHI97LA085.md): Cessna 172 · Marquette, MI · Accident · Minor injuries · Limited investigation · Final report · Mar 11, 1997 · N171AS · Substantial damage
  > multiple oil leaks in the engine lubrication system. Factors were the disconnected wet vacuum pump line and the oil exhaustion.
- [NTSB CHI95LA055](https://openairdocs.org/ntsb/CHI95LA055.md): Cessna 172 · Allegan, MI · Accident · No injuries · Limited investigation · Final report · Dec 21, 1994 · N7656X · Substantial damage
  > the student pilot's failure to maintain directional control which resulted in the inability to obtain proper runway alignment. Related factors are the student pilot's lack of total flight experience and the snowbank.
- [NTSB CHI73DEM36](https://openairdocs.org/ntsb/CHI73DEM36.md): Cessna 172B · Gwinn, MI · Accident · Minor injuries · Closed · Jan 21, 1973 · N7802X · Substantial damage
- [NTSB CHI66F0305](https://openairdocs.org/ntsb/CHI66F0305.md): Cessna 172B · Cheboygan, MI · Accident · No injuries · Closed · Sep 4, 1965 · N8056X · Substantial damage
- [NTSB UNK64X1514](https://openairdocs.org/ntsb/UNK64X1514.md): Cessna 172 · Muskegon, MI · Accident · 2 fatal · Closed · Apr 29, 1964 · N7989X · Destroyed

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

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