# NTSB investigations: Cessna 172R, 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 CHI06CA189](https://openairdocs.org/ntsb/CHI06CA189.md): Cessna 172R · Waterford, MI · Accident · No injuries · Data collection · Final report · Jul 13, 2006 · N918TA · Substantial damage
  > The directional control not obtained/maintained, the inadequate compensation for wind conditions, and the go-around not performed during landing by the pilot. An additional cause was the lack of experience by the pilot. A contributing factor was the crosswind.
- [NTSB CHI05CA090](https://openairdocs.org/ntsb/CHI05CA090.md): Cessna 172R · Kalamazoo, MI · Accident · No injuries · Data collection · Final report · Apr 7, 2005 · N985BT · Substantial damage
  > The pilot's failure to maintain directional control and the excessive taxispeed.
- [NTSB CHI04LA097](https://openairdocs.org/ntsb/CHI04LA097.md): Cessna 172R · Kalamazoo, MI · Accident · No injuries · Limited investigation · Final report · Apr 2, 2004 · N986AV · Substantial damage
  > The air traffic control procedures/directives not followed by tower air traffic controller, the inadequate compensation for wind conditions by the student pilot during landing, the lack of total experience by the student pilot, and the recommended crosswind…
- [NTSB CHI01LA092](https://openairdocs.org/ntsb/CHI01LA092.md): Cessna 172R · Battle Creek, MI · Accident · No injuries · Limited investigation · Final report · Feb 13, 2001 · N975BC · Substantial damage
  > Aircraft control not maintained by the student pilot during the takeoff roll. Factors to the accident were the student pilot's lack of experience and the snowbank.
- [NTSB CHI00LA182](https://openairdocs.org/ntsb/CHI00LA182.md): Cessna 172R · Athens, MI · Accident · No injuries · Limited investigation · Final report · Jul 5, 2000 · N996WW · Substantial damage
  > the failure of the student pilot to maintain control of the aircraft, the inadequate supervision by the flight instructor, and the delayed remedial action performed by the flight instructor. A factor to the accident was the runway edge light that was struck…
- [NTSB CHI00LA115](https://openairdocs.org/ntsb/CHI00LA115.md): Cessna 172R · Battle Creek, MI · Accident · No injuries · Limited investigation · Final report · Apr 18, 2000 · N975BC · Substantial damage
  > the student pilot's failure to maintain directional control of the airplane during the landing. Factors associated with the accident were the misjudged landing flare, the student's lack of total experience, the runway lights, and the runway signs.
- [NTSB CHI00LA081](https://openairdocs.org/ntsb/CHI00LA081.md): Cessna 172R · Waterford, MI · Accident · No injuries · Limited investigation · Final report · Feb 21, 2000 · N922TA · Substantial damage
  > the directional control not obtained/maintained by the dual student and the remedial action not performed by the certified flight instructor. Contributing factors were the crosswind and the snow bank.
- [NTSB CHI99LA103](https://openairdocs.org/ntsb/CHI99LA103.md): Cessna 172R · Battle Creek, MI · Accident · No injuries · Limited investigation · Final report · Mar 10, 1999 · N983AV · Substantial damage
  > The pilot's improper flare and failure to maintain directional control. Related factors were the snowbank and lack of total experience.
- [NTSB CHI99LA091](https://openairdocs.org/ntsb/CHI99LA091.md): Cessna 172R · Battle Creek, MI · Accident · No injuries · Limited investigation · Final report · Mar 10, 1999 · N989AV · Substantial damage
  > the loss of directional control by the pilot. Factors to the accident were the lack of total experience of the pilot, the snow covered runway condition, the snowbank, and the flight instructor not verifying the runway snow removal with the Duty Instructor…

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

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