# NTSB investigations: Cessna 170A, 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 CEN24LA251](https://openairdocs.org/ntsb/CEN24LA251.md): Cessna 170 · Dowagiac, MI · Accident · No injuries · Class 4 · Limited · Final report · Jul 4, 2024 · N9793A · Substantial damage
  > The pilot and flight instructor’s failure to maintain directional control during the landing roll, which resulted in a ground loop with the left main landing gear axle failing, a runway excursion, and impact with the ground.
- [NTSB CEN24LA201](https://openairdocs.org/ntsb/CEN24LA201.md): Cessna 170A · Oscoda, MI · Accident · No injuries · Class 4 · Limited · Final report · May 28, 2024 · N9206A · Substantial damage
  > The pilot’s failure to maintain directional control during landing rollout with a gusting crosswind that resulted in the airplane nosing over and impacting on the runway.
- [NTSB GAA16CA275](https://openairdocs.org/ntsb/GAA16CA275.md): Cessna 170 · Saginaw, MI · Accident · No injuries · Data collection · Final report · May 30, 2016 · N1441D · Substantial damage
  > The pilot's exceedance of the critical angle of attack during the landing flare, which resulted in an aerodynamic stall, hard landing, right main landing gear collapse, runway excursion, and nose over.
- [NTSB CHI81FEM15](https://openairdocs.org/ntsb/CHI81FEM15.md): Cessna 170 · Charlotte, MI · Accident · No injuries · Closed · May 1, 1981 · N9194A · Substantial damage
- [NTSB CHI81FEM01](https://openairdocs.org/ntsb/CHI81FEM01.md): Cessna 170A · Lowell, MI · Accident · No injuries · Closed · Oct 1, 1980 · N1724D · Substantial damage
- [NTSB CHI77FEM38](https://openairdocs.org/ntsb/CHI77FEM38.md): Cessna 170A · Cedar Springs, MI · Accident · No injuries · Closed · Aug 29, 1977 · N5137B · Substantial damage
- [NTSB CHI75FEC61](https://openairdocs.org/ntsb/CHI75FEC61.md): Cessna 170 · Jackson, MI · Accident · No injuries · Closed · Jun 30, 1975 · N5737C · Substantial damage
- [NTSB MKC74AK018](https://openairdocs.org/ntsb/MKC74AK018.md): Cessna 170A · Beaverton, MI · Accident · 3 fatal · Closed · Oct 21, 1973 · N5580C · Destroyed
- [NTSB CHI70F0213](https://openairdocs.org/ntsb/CHI70F0213.md): Cessna 170A · Union Lake, MI · Accident · No injuries · Closed · Aug 18, 1969 · N1717D · Destroyed
- [NTSB CHI70F0066](https://openairdocs.org/ntsb/CHI70F0066.md): Cessna 170 · Monroe, MI · Accident · No injuries · Closed · Jun 25, 1969 · N9160A · Substantial damage
- [NTSB CHI68F0642](https://openairdocs.org/ntsb/CHI68F0642.md): Cessna 170A · Coldwater, MI · Accident · No injuries · Closed · Mar 24, 1968 · N9762A · Substantial damage
- [NTSB CHI67F0454](https://openairdocs.org/ntsb/CHI67F0454.md): Cessna 170A · So.Holland, MI · Accident · No injuries · Closed · Jan 21, 1967 · N5580C · Substantial damage
- [NTSB CHI66F0510](https://openairdocs.org/ntsb/CHI66F0510.md): Cessna 170A · Grayling, MI · Accident · Minor injuries · Closed · Jan 14, 1966 · N1203D · Substantial damage
- [NTSB UNK64X1584](https://openairdocs.org/ntsb/UNK64X1584.md): Cessna 170A · Wixon, MI · Accident · No injuries · Closed · May 3, 1964 · N148N · Destroyed
- [NTSB UNK64X0471](https://openairdocs.org/ntsb/UNK64X0471.md): Cessna 170A · Albion, MI · Accident · No injuries · Closed · Feb 5, 1964 · N9260A · 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 ('2072304'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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