Skip to content

NTSB investigations: Cessna 172M, KS

27 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19742026

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" = 'KS' 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

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\" = 'KS' 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" = 'KS' 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

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 CEN25LA230Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Wichita, KSThe student pilot’s failure to maintain directional control during the takeoff that resulted in a runway excursion.Jun 28, 2025 · N1591V · Substantial damage NTSB CEN22LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Manhattan, KSThe pilot’s failure to use carburetor heat during the approach and his unsuitable flight profile for an upsloping runway, which resulted in a partial loss of engine power and an impact with terrain during an attempted go-around.Apr 21, 2022 · N9263H · Substantial damage NTSB CEN11CA018Accident · Minor injuriesData collectionFinal reportCessna 172M · Newton, KSThe pilot’s inadequate flare, which resulted in a hard landing.Aug 1, 2010 · N13013 · Substantial damage NTSB CEN10CA212Accident · No injuriesData collectionFinal reportCessna 172M · Coldwater, KSThe pilot's failure to compensate for gusting crosswinds resultuing in the loss of directional control while landing.Apr 17, 2010 · N81772 · Substantial damage NTSB CHI04CA209Accident · Minor injuriesData collectionFinal reportCessna 172M · Sublette, KSThe student pilot's inadequate compensation for the crosswind condition, and her failure to maintain aircraft control during landing. Factors contributing to the accident included the student pilot's unsuccessful recovery from the bounced landings and the…Jul 30, 2004 · N105PD · Substantial damage NTSB CHI00LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Liberal, KSthe pilot not maintaining proper glidepath on the ILS approach, the pilot's improper decision to continue the approach below the glidepath, and the pilot's failure to perform a missed approach. Factors relating to the accident were the low ceiling and…Jan 17, 2000 · N12654 · Substantial damage NTSB CHI92LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Manhattan, KSThe pilot's failure to refuel the airplane. A factor related to the accident was the rough terrain on which the landing was made.Feb 28, 1992 · N20044 · Substantial damage NTSB MKC90LA031Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Osage City, KSThe pilot misjudged distance and altitude to the runway while on final approach to land. Factors related to the accident were: dark night and static wires.Nov 18, 1989 · N20428 · Substantial damage NTSB MKC88LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Topeka, KSWhile taxiing in from a personal solo training flight, the student pilot taxied into a chain link fence while attempting to park the acft. The right wing spar sustained substantial damage.Jul 9, 1988 · N80208 · Substantial damage NTSB MKC86LA194Accident · No injuriesLimited investigationFinal reportCessna 172M · Arkansas City, KSThe plt was landing on his private sod strip which had tall grass along the edges. During the landing roll, he attempted to pick up some papers that had fallen on the cockpit floor. When he looked back up, the acft had drifted to the left. The left wing…Sep 20, 1986 · N80282 · Substantial damage NTSB MKC85LA216Accident · No injuriesLimited investigationFinal reportCessna 172M · Emporia, KSTwo plts were on board. The lt seat plt was making the landing when a gust of wind caused the acft to become misaligned with the rwy. The rt seat plt took control of the acft and attempted a go-around. The rt seat plt said he aimed for a clear spot btw trees…Sep 15, 1985 · N61624 · Substantial damage NTSB MKC81DCQ31Accident · No injuriesClosedCessna 172 · Manhattan, KSApr 26, 1981 · N20317 · Destroyed NTSB MKC81FA019Accident · 1 fatalClosedCessna 172 · Lawrence, KSFeb 13, 1981 · N1982V · Destroyed NTSB MKC80FA058Accident · 1 fatalClosedCessna 172M · Cassoday, KSSep 23, 1980 · N1841V · Destroyed NTSB MKC80DCQ18Accident · No injuriesClosedCessna 172 · Quinter, KSMay 31, 1980 · N73069 · Substantial damage NTSB MKC79DCQ18Accident · Minor injuriesClosedCessna 172 · Belleville, KSApr 18, 1979 · N1455U · Substantial damage NTSB MKC79DCQ08Accident · No injuriesClosedCessna 172 · Beaumont, KSJan 4, 1979 · N13093 · Substantial damage NTSB MKC77FCQ30Accident · Minor injuriesClosedCessna 172M · Iola, KSApr 21, 1977 · N80506 · Substantial damage NTSB MKC77DCQ22Accident · No injuriesClosedCessna 172 · Coats, KSMar 10, 1977 · N5461Q · Substantial damage NTSB MKC76FCQ43Accident · No injuriesClosedCessna 172 · Meade, KSApr 16, 1976 · N13013 · Substantial damage NTSB MKC76DCQ42Accident · No injuriesClosedCessna 172 · Dodge City, KSMar 26, 1976 · N9407H · Substantial damage NTSB MKC76DCQ25Accident · Minor injuriesClosedCessna 172 · Caldwell, KSDec 16, 1975 · N61548 · Substantial damage NTSB MKC75DCQ46Accident · No injuriesClosedCessna 172 · Wamego, KSMay 7, 1975 · N9876V · Substantial damage NTSB MKC75DCQ36Accident · No injuriesClosedCessna 172 · Wichita, KSMar 5, 1975 · N5098R · Substantial damage NTSB MKC75DCQ30Accident · No injuriesClosedCessna 172 · Norton, KSJan 25, 1975 · N13517 · Substantial damage NTSB MKC75DCG11Accident · No injuriesClosedCessna 172 · Gardner, KSAug 13, 1974 · N13230 · Substantial damage NTSB MKC74DCG35Accident · No injuriesClosedCessna 172 · Leawood, KSMay 4, 1974 · N20014 · Substantial damage