# NTSB investigations: Cessna 172S, 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 CEN22LA194](https://openairdocs.org/ntsb/CEN22LA194.md): Cessna 172S · Traverse City, MI · Accident · No injuries · Class 3 · Limited · Final report · May 10, 2022 · N184NW · Substantial damage
  > The failure of maintenance personnel to properly torque a fuel line “B” nut, which resulted in a total loss of engine power.
- [NTSB GAA15CA140](https://openairdocs.org/ntsb/GAA15CA140.md): Cessna 172 - S · Traverse City, MI · Accident · No injuries · Data collection · Final report · Jun 25, 2015 · N195NW · Substantial damage
  > The student pilot's failure to maintain pitch control during the landing, resulting in a hard landing.
- [NTSB CEN13CA335](https://openairdocs.org/ntsb/CEN13CA335.md): Cessna 172S · Ann Arbor, MI · Accident · No injuries · Data collection · Final report · Jun 9, 2013 · N857SP · Substantial damage
  > The pilot’s failure to make a go-around in a timely manner and his loss of control during landing.
- [NTSB CEN10CA325](https://openairdocs.org/ntsb/CEN10CA325.md): Cessna 172 · Traverse City, MI · Accident · No injuries · Data collection · Final report · Jun 15, 2010 · N52519 · Substantial damage
  > Damage to the firewall for undetermined reasons.
- [NTSB CHI05CA124](https://openairdocs.org/ntsb/CHI05CA124.md): Cessna 172S · Port Huron, MI · Accident · No injuries · Data collection · Final report · May 21, 2005 · N860SA · Substantial damage
  > The pilot not performing a go-around and misjudging the flare leading to a hard landing.
- [NTSB CHI03FA149](https://openairdocs.org/ntsb/CHI03FA149.md): Cessna 172S · Sidnaw, MI · Accident · 1 fatal · Field investigation · Final report · Jun 6, 2003 · N975SP · Destroyed
  > The improper short/soft field landing procedure by the pilot and his lack of recent experience in type of operation. Contributing factors were the short/soft field runway, the trees and his delay in aborting the takeoff.
- [NTSB CHI03LA073](https://openairdocs.org/ntsb/CHI03LA073.md): Cessna 172 · Clare, MI · Accident · No injuries · Limited investigation · Final report · Feb 14, 2003 · N693SA · Substantial damage
  > The student pilot failed to maintain directional control of the airplane during takeoff roll. A factor was the snow bank.
- [NTSB CHI02LA291](https://openairdocs.org/ntsb/CHI02LA291.md): Cessna 172S · Boyne Falls, MI · Accident · No injuries · Limited investigation · Final report · Sep 21, 2002 · N784SA · Substantial damage
  > The pilot's improper flare during landing.
- [NTSB CHI00LA113](https://openairdocs.org/ntsb/CHI00LA113.md): Cessna 172S · Near Muskegon, MI · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 2000 · N560SP · Substantial damage
  > the pilot failed to maintain altitude after inadvertently flying to instrument meteorological conditions. Factors associated with the accident were the low ceilings and visibility, the pilot became disoriented after inadvertently flying into IMC, and 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" = '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 ('2072439', '2072442'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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