NTSB investigations: Cessna 172M, IA
13 cases on aircraft the registry lists as Cessna 172M. 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.
Cases per year
| 1973 | 1 |
|---|---|
| 1977 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1984 | 2 |
| 1985 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 2012 | 1 |
| 2022 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'IA' 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 ('2072418'))
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" = 'IA' 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 ('2072418'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN22LA445Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Monticello, IAThe pilot’s failure to maintain a proper approach airspeed and glidepath which resulted in a long landing and his inability to stop the airplane on available runway and the subsequent runway excursion.NTSB CEN12LA408Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Griswold, IAThe pilot’s failure to maintain adequate airspeed during an attempted go-around, resulting in an aerodynamic stall.NTSB CHI97LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · Keokuk, IAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise, failure (collapse) of the nose gear, and a subsequent nose over.NTSB CHI91FA254Accident · 2 fatalField investigationFinal reportCessna 172M · Ottumwa, IAImproper IFR procedure by the pilot by not maintaining the proper minimum descent altitude (mda) until established on the ILS localizer and glidepath.NTSB MKC90LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Winfield, IAThe pilot's decision to go-around was delayed and clearance of the power lines was not attained.NTSB MKC85FCD02Accident · Serious injuriesFinal reportCessna 172 M · Emmetsburg, IAThe acft crashed in a turkey farm field after losing alt during takeoff. A witness said the acft settled as though the plt was raising the flaps after takeoff. The acft lost alt in a rt turn, and landed 1 mile south of the arpt post acc investigation showed…NTSB MKC85LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Fort Madison, IAThe plt stated that an inflight encounter with a gust of wind during landing resulted in a sharp loss of altitude and a bounced landing. Consequently a second gust on rollout followed by the plts loss of directional control resulted in the acft departing the…NTSB MKC84LA129Accident · Minor injuriesLimited investigationFinal reportCessna 172M · 5n 0lin, IAWhile cruising at 3,000 ft MSL the eng ran rough. The flt noticed zero oil pressure. As he turned toward a bean field the eng failed. The acft collided with a ditch & nosed over. The eng was disassembled & an estimated 3-4 qts of oil were in the eng case. The…NTSB MKC84LA059Accident · No injuriesLimited investigationFinal reportCessna 172M · Elkader, IAThe acft nosed over during landing on a snow-covered rwy after striking a snow drift. The plt said he did not see any tracks in the snow covered rwy but since there was no NOTAM closing the arpt he went ahead with a soft field landing. He said the snow…NTSB MKC81DCD30Accident · No injuriesClosedCessna 172M · Oxford, IANTSB MKC79DCD02Accident · No injuriesClosedCessna 172 · Williams, IANTSB MKC78FCD08Accident · Serious injuriesClosedCessna 172M · Lamoni, IANTSB MKC73FCD62Accident · No injuriesClosedCessna 172 · Mason City, IA