Skip to content

NTSB investigations: Cessna 172G, MI

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

19662026

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 ('2072420')) 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 ('2072420'))
  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 ('2072420'))
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 CEN13LA232Accident · No injuriesLimited investigationFinal reportCessna 172G · Reading, MIThe partial loss of engine power due to the improper securing of the throttle linkage by maintenance personnel.Apr 20, 2013 · N3682L · Substantial damage NTSB CHI08CA049Accident · No injuriesData collectionFinal reportCessna 172 · Hastings, MIThe student pilot failed to maintain directional control during landing. Factors were the ditch and the icy runway.Dec 8, 2007 · N173DA · Substantial damage NTSB CHI03LA303Accident · No injuriesLimited investigationFinal reportCessna 172G · Greenville, MIThe pilot's inadequate takeoff procedure with the use of 20 degrees of flaps. Contributing factors were the interrelated effects of high aircraft weight, the density altitude, and the relative humidity. An additional factor was the trees.Sep 7, 2003 · N3811L · Substantial damage NTSB CHI96LA193Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lowell, MIwas inadequate initial training of the pilot and inadequate flight test procedures by the FAA Designated Pilot Examiner when he reportedly had the pilot demonstrate 12 pilot operations from the FAA's practical flight test standards in 35 minutes during the…Jun 11, 1996 · N1106F · Substantial damage NTSB CHI94LA301Accident · No injuriesLimited investigationFinal reportCessna 172 · Whitehall, MIThe pilot in command's inadequate preflight planning. Factors related to the accident were the fuel exhaustion and the soft crop field.Aug 27, 1994 · N1106F · Substantial damage NTSB CHI88LA227Accident · No injuriesLimited investigationFinal reportCessna 172G · Sparta, MIDuring a takeoff attempt from his private strip the pilot elected to abort the takeoff. There was a slight quartering tailwind for the takeoff attempt. Due to the 'dense', damp grass, which was about 4 inches tall according to the pilot, braking effectiveness…Aug 30, 1988 · N6049R · Substantial damage NTSB CHI87DEC02Accident · Minor injuriesFinal reportCessna 172G · Linden, MIThe student pilot was attempting to land when he decided he was too high, and aborted the landing attempt. The engine failed to develop power despite throttle and mixture adjustments, and the pilot made a forced landing in a cornfield. Examination of the…Mar 20, 1987 · N3630L · Substantial damage NTSB CHI79FEM15Accident · No injuriesClosedCessna 172G · Grand Rapids, MIMar 14, 1979 · N4432L · Substantial damage NTSB CHI78FEM23Accident · Minor injuriesClosedCessna 172 · Lowell, MIJul 5, 1978 · N1108F · Substantial damage NTSB CHI75FEM35Accident · No injuriesClosedCessna 172 · Byron Center, MIApr 7, 1975 · N4432L · Substantial damage NTSB CHI73FEC24Accident · No injuriesClosedCessna 172G · Romulus, MIMar 15, 1973 · N3793L · Substantial damage NTSB CHI72FEM53Accident · Minor injuriesClosedCessna 172 · Boyne Mtn, MIFeb 27, 1972 · N4369L · Substantial damage NTSB CHI72FEC20Accident · No injuriesClosedCessna 172G · Corunna, MIDec 22, 1971 · N4142L · Substantial damage NTSB CHI72DEM22Accident · No injuriesClosedCessna 172G · Hart, MISep 6, 1971 · N4485L · Substantial damage NTSB CHI69D0005Accident · No injuriesClosedCessna 172G · Pierson, MIMay 31, 1968 · N1108F · Substantial damage NTSB CHI67F0119Accident · Minor injuriesClosedCessna 172 · Dowagiac, MIJun 1, 1967 · N1388F · Substantial damage NTSB CHI67F0403Accident · No injuriesClosedCessna 172 · Boyne Falls, MIDec 2, 1966 · N6041R · Substantial damage