Skip to content

NTSB investigations: Cessna 172K, MI

23 cases on aircraft the registry lists as Cessna 172K. 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

19702026

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 ('2072430')) 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 ('2072430'))
  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 ('2072430'))
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 CEN20LA431Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Big Rapids, MIThe airplane’s impact with a deer during takeoff.Sep 29, 2020 · N79300 · Substantial damage NTSB CEN15CA105Accident · No injuriesData collectionFinal reportCessna 172K · Holland, MIThe pilot's loss of control while landing in gusty wind conditions.Jan 17, 2015 · N7061G · Substantial damage NTSB CEN10CA405Accident · No injuriesData collectionFinal reportCessna 172K · Boyne City, MIThe pilot's failure to attain the proper touchdown point and delayed go-around.Jul 10, 2010 · N79097 · Substantial damage NTSB CHI01LA107Accident · No injuriesLimited investigationFinal reportCessna 172K · Holland, MIThe pilot failed to maintain directional control of the airplane. Factors included the soft ground and the runway lights.Mar 20, 2001 · N79301 · Substantial damage NTSB CHI95LA088Accident · No injuriesLimited investigationFinal reportCessna 172 · Holland, MIdelayed remedial action by the flight instructor. Factors in the accident were the student pilot not maintaining directional control once airborne.Feb 18, 1995 · N79569 · Substantial damage NTSB CHI94LA251Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Rockford, MIthe student pilot's failure to refuel the airplane prior to fuel exhaustion.Jul 30, 1994 · N84514 · Substantial damage NTSB CHI93LA096Accident · No injuriesLimited investigationFinal reportCessna 172K · Jackson, MIThe pilot's failure to maintain directional control.Feb 25, 1993 · N46460 · Substantial damage NTSB CHI91LA109Accident · No injuriesLimited investigationFinal reportCessna 172K · Bridgman, MIThe pilot's failure to correct a descent. A factor in the accident was the pilot's maneuvering at an improper altitude.Mar 16, 1991 · N78195 · Substantial damage NTSB CHI82FEM04Accident · Serious injuriesClosedCessna 172 · Kinross, MINov 16, 1981 · N79225 · Substantial damage NTSB CHI81DEM34Accident · No injuriesClosedCessna 172K · Mackinac Is, MIJul 24, 1981 · N78424 · Substantial damage NTSB CHI80FEM01Accident · Minor injuriesClosedCessna 172K · Byron Center, MIOct 1, 1979 · N84660 · Substantial damage NTSB CHI78FA065Accident · 3 fatalClosedCessna 172K · Mackinaw City, MISep 10, 1978 · N84380 · Destroyed NTSB CHI77FEM33Accident · Serious injuriesClosedCessna 172 · Stambaugh, MIJul 10, 1977 · N303EE · Substantial damage NTSB CHI77FEM35Accident · No injuriesClosedCessna 172K · Beaverton, MIJul 2, 1977 · N78157 · Substantial damage NTSB CHI76FEM25Accident · No injuriesClosedCessna 172 · South Haven, MIJan 15, 1976 · N46579 · Substantial damage NTSB CHI76FEM18Accident · No injuriesClosedCessna 172 · Kalamazoo, MIOct 26, 1975 · N79527 · 2 aircraft · Substantial damage NTSB CHI74DEC29Accident · No injuriesClosedCessna 172 · Romeo, MIJan 30, 1974 · N46369 · Substantial damage NTSB CHI73DEM74Accident · No injuriesClosedCessna 172K · St.Ignace, MIJun 27, 1973 · N78130 · Substantial damage NTSB CHI73DEC27Accident · No injuriesClosedCessna 172K · Onsted, MIMar 27, 1973 · N78157 · Substantial damage NTSB CHI73FEC11Accident · Minor injuriesClosedCessna 172 · Clinton, MISep 29, 1972 · N46567 · Substantial damage NTSB CHI72FEM16Accident · Minor injuriesClosedCessna 172K · St Ignace, MIAug 15, 1971 · N78130 · Substantial damage NTSB CHI71FBJ57Accident · No injuriesClosedCessna 172K · Montague, MIFeb 21, 1971 · N79421 · Substantial damage NTSB CHI71DBJ25Accident · No injuriesClosedCessna 172K · Montague, MIAug 25, 1970 · N111TK · Substantial damage