Skip to content

NTSB investigations: Cessna 172, MI

38 cases on aircraft the registry lists as Cessna 172. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with 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 ('2072402')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 ('2072402'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN26LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Naubinway, MIThe pilot’s improper engine power application during the landing flare, which resulted in a hard, bounced landing and nose over.May 27, 2026 · N3984F · Substantial damage NTSB CEN21LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Iron Mountain, MIThe mechanics’ failure to follow procedures for high-thrust operations at the nontowered airport, which resulted in jet blast damage to an airplane taxiing nearby.Aug 3, 2021 · N6778A · Substantial damage NTSB CEN18LA298Accident · Minor injuriesLimited investigationFinal reportExtra EA300 · North Fox Island, MIThe Extra pilot’s failure to see and avoid the Cessna, which resulted in an in-flight collision. Contributing to the accident was the failure of the Extra pilot to tune his radio to the correct frequency, which resulted in no common traffic advisories being…Jul 29, 2018 · N32WR · 2 aircraft · Substantial damage NTSB CHI06LA070Accident · 1 fatalLimited investigationFinal reportCessna 172 · Harrison, MIThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor associated with the accident was the pilot's impairment due to drugs.Jan 22, 2006 · N8540B · Substantial damage NTSB CHI05CA155Accident · No injuriesData collectionFinal reportCessna 172 · Willis, MIThe pilot's inability to maintain directional control of the airplane due to undetermined reasons. A factor associated with the accident were the trees that the airplane contacted during the aborted takeoff.Jun 23, 2005 · N6324E · Substantial damage NTSB CHI96LA329Accident · No injuriesLimited investigationFinal reportCessna 172 · Wellston, MIThe pilot failed to maintain control of the aircraft. Factors were the rough road, the tree, and the tire.Sep 8, 1996 · N7016T · Substantial damage NTSB CHI95LA248Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Niles, MIThe pilot's failure to ensure an adequate supply of fuel was aboard the aircraft during preflight planning and his failure to lean the engine mixture during cruise flight.Jul 29, 1995 · N7295A · Substantial damage NTSB CHI93LA176Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Plainwell, MIThe pilot-in-command's initiating hand starting of the airplane unattended by a qualified person.May 16, 1993 · N8657B · Substantial damage NTSB CHI87LA084Accident · No injuriesLimited investigationFinal reportCessna 172 · Charlevoix, MIUpon landing the nose wheel buckled after striking a snowbank and the aircraft flipped over. Pilot reported there was a problem with the nose wheel although inspection of the nose wheel after the accident did not reveal any malfunction.Feb 14, 1987 · N8896B · Substantial damage NTSB CHI85FA356Accident · 1 fatalField investigationFinal reportCessna 172 · Rose Township, MIJust prior to the accident, several witnesses observed the acft flying at a very low alt in the vicinity of the crash site. The crash site was located across the road from the home of the plt's brother. According to witnesses, the acfts eng was operating…Aug 19, 1985 · N5146A · Destroyed NTSB CHI81FEM29Accident · No injuriesClosedCessna 172 · Mackinac Is, MIJul 9, 1981 · N7920B · Substantial damage NTSB CHI78FEM16Accident · Serious injuriesClosedCessna 172B · Fruitport, MIMay 1, 1978 · N7819X · Substantial damage NTSB CHI78FEM13Accident · No injuriesClosedCessna 172 · Plainwell, MIMar 10, 1978 · N7052T · Substantial damage NTSB CHI76FEC21Accident · No injuriesClosedCessna 172 · Pinckney, MIJan 18, 1976 · N4154F · Substantial damage NTSB CHI75FEM11Accident · Serious injuriesClosedCessna 172 · Harrison, MISep 19, 1974 · N4155F · Destroyed NTSB CHI73DEC33Accident · No injuriesClosedCessna 172 · Utica, MIMay 10, 1973 · N8511B · Substantial damage NTSB CHI72FET23Accident · No injuriesClosedCessna 120 · Watervliet, MIApr 19, 1972 · N277N · Substantial damage NTSB CHI72AC079Accident · 1 fatalClosedCessna 172 · Lowell, MIApr 8, 1972 · N5936A · Destroyed NTSB CHI71FEM73Accident · Minor injuriesClosedCessna 172 · Hillman, MIApr 26, 1971 · N6810A · Destroyed NTSB CHI71FEC44Accident · No injuriesClosedCessna 172 · Westland, MIApr 20, 1971 · N119DH · Substantial damage NTSB CHI71FBJ66Accident · No injuriesClosedCessna 172 · Kewadin, MIMar 21, 1971 · N5165A · Substantial damage NTSB CHI71FBJ36Accident · Minor injuriesClosedCessna 172 · Charlotte, MIOct 30, 1970 · N6849A · Substantial damage NTSB CHI71FDW15Accident · Minor injuriesClosedCessna 172 · Oxford, MISep 5, 1970 · N5195A · Substantial damage NTSB CHI70DBJ09Accident · No injuriesClosedCessna 172 · Marshall, MIFeb 1, 1970 · N6432B · 2 aircraft · Substantial damage NTSB CHI70F0234Accident · No injuriesClosedCessna 172 · Marlette, MISep 16, 1969 · N7097T · Substantial damage NTSB CHI70F0224Accident · No injuriesClosedCessna 172 · Dundee, MIAug 30, 1969 · N8966B · Substantial damage NTSB CHI69A0042Accident · 4 fatalClosedCessna 172 · Brighton, MIOct 18, 1968 · N8656B · Destroyed NTSB CHI69F0008Accident · Serious injuriesClosedCessna 172D · Tecumseh, MIJun 1, 1968 · N2652U · Destroyed NTSB CHI68F0464Accident · No injuriesClosedCessna 172 · S.Rockwood, MINov 29, 1967 · N6998A · Substantial damage NTSB CHI68F0169Accident · No injuriesClosedCessna 172 · Sparta, MIJul 16, 1967 · N8698B · Substantial damage NTSB CHI67F0582Accident · No injuriesClosedCessna 172 · Cedar Lake, MIApr 8, 1967 · N4152F · Substantial damage NTSB CHI67A0035Accident · 1 fatalClosedCessna 172 · Detroit, MISep 3, 1966 · N6725A · Destroyed NTSB CHI66F0720Accident · No injuriesClosedCessna 172 · Dimondale, MIMay 7, 1966 · N6428B · Substantial damage NTSB CHI66D0722Accident · No injuriesClosedCessna 172 · Leonidas, MIMay 2, 1966 · N8363B · Substantial damage NTSB CHI66F0513Accident · Minor injuriesClosedCessna 172 · Greenville, MIJan 16, 1966 · N7053A · Substantial damage NTSB CHI65F0108Accident · No injuriesClosedCessna 172 · South Haven, MIMar 31, 1965 · N8934B · Destroyed NTSB UNK65X0762Accident · No injuriesClosedCessna 172 · Cedar Lake, MINov 20, 1964 · N5769A · Destroyed NTSB UNK64X2238Accident · No injuriesClosedDehavilland DH-104 · Detroit, MIJun 11, 1964 · N1300H · 2 aircraft · Substantial damage