NTSB investigations: Cessna 172M, WI
43 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
| 1972 | 1 |
|---|---|
| 1973 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 3 |
| 1979 | 5 |
| 1980 | 1 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 3 |
| 1989 | 2 |
| 1990 | 1 |
| 1997 | 2 |
| 2000 | 2 |
| 2001 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2025 | 1 |
| 2026 | 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\" = 'WI' 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" = 'WI' 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 CEN26LA138Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Solon Springs, WIThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB CEN26LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Grantsburg, WIThe collision with a white-tail deer during the landing in dark night visual conditions.NTSB GAA18CA490Accident · Serious injuriesData collectionFinal reportCessna 172 · DePere, WIThe pilot’s failure to maintain lateral control and his subsequent failure to maintain the runway heading during an attempted go-around, which resulted in impact with trees.NTSB GAA18CA005Accident · No injuriesData collectionFinal reportCessna 172 · Black River Falls, WIThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB GAA15CA290Accident · No injuriesData collectionFinal reportCessna 172M · Shiocton, WIThe pilot's decision to continue to land at an unlighted airstrip, at night, after the landing light failed on approach, which resulted in a bounced landing, runway excursion, and collision with terrain.NTSB CEN14CA496Accident · No injuriesData collectionFinal reportCessna 172M · Oxford, WIThe pilot did not compensate for the decrease in the crosswind when he descended below the tree line during the landing.NTSB CEN12LA508Accident · Serious injuriesLimited investigationFinal reportCessna 172M · South Wayne, WIInternal engine component failures, which resulted from oil starvation due to debris in the oil system.NTSB CEN10CA158Accident · No injuriesData collectionFinal reportCessna 172M · Waupaca, WIThe student pilot's failure to maintain directional control while taking off in gusting winds.NTSB CHI07LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Rio Creek, WIThe pilot's improper aircraft weight and balance, and his failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb.NTSB CHI05CA123Accident · No injuriesData collectionFinal reportCessna C-172M · Madison, WIThe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control. Factors were the gusty winds and the soft ground.NTSB CHI04LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · New Munster, WIVisual lookout not maintained by the pilots of both airplanes.NTSB CHI01LA265Accident · No injuriesLimited investigationFinal reportCessna 172M · Milton, WIThe unsuitable terrain for landing encountered by the pilot. Factors were the high vegetation and the loss of engine power for undetermined reasons.NTSB CHI01LA159Accident · No injuriesLimited investigationFinal reportCessna 172M · Middleton, WIThe pilot attempted a touch and go on unsuitable terrain. A factor associated with the accident was the tall wet grass airstrip on which the touch and go was attempted.NTSB CHI01LA004Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sparta, WIthe pilot's inaccurate fuel consumption calculations, improper fuel management, inadequate in-flight planning/decision, flight to destination alternate not performed, and the discontinued planned approach to the initially selected runway. Contributing factors…NTSB CHI00FA129Accident · 3 fatalField investigationFinal reportCessna 172M · Cornell, WIthe pilot not maintaining aircraft control and the stall/spin he encountered. A factor was the extended flaps.NTSB CHI97LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Portage, WIthe pilot's inadequate preflight preparation, and subsequent fuel exhaustion. Factors relating to this accident were: the guard rail, the highway, and the ditch.NTSB CHI97TA070Accident · No injuriesFinal reportCessna 172 · Oconto, WIthe failure of the pilot to maintain proper runway alignment and thus clearance with the snow drifts during takeoff. A factor was the distance the snow drifts extended past the runway edge.NTSB CHI90FAMS3Accident · 2 fatalMissing aircraftFinal reportCessna 172M · Kewaunee, WIUndetermined.NTSB CHI90LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Cedarburg, WIDelay of the flight instructor (CFI) in making a go-around and his failure to attain sufficient airspeed to climb after taking off again. The transmission wire (power line) and high vegetation were contributing factors.NTSB CHI89DEP02Accident · No injuriesFinal reportCessna 172M · West Bend, WIPartial failure of the throttle cable. Unsuitable (soft) terrain and transmission wires in the landing area were considered to be factors.NTSB CHI87LA052Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Middleton, WIAt the completion of a period of instrument training and while returning to the airport of origin the CFI asked the private rated dual student to demonstrate a simulated forced landing to the runway. In an attempt to lose altitude on the final approach the…NTSB CHI86LA097Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Milwaukee, WIThe aircraft was approximately 180 lbs over max recommended takeoff gross weight and used almost all of a 3560 foot runway to take off. The pilot stated that after liftoff the aircraft would not turn left and began to turn right on its own. He climbed to…NTSB CHI86LA075Accident · No injuriesLimited investigationFinal reportCessna 172 · Baraboo, WIThe plt attempted a x-wind landing that was beyond his capabilities. He stated that if the x-wind was excessive he intended to divert to another arpt with a more favorable runway. At touchdown the aircraft drifted right into a two foot high snow bank off the…NTSB CHI85LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Mosinee, WIThe plt stated that he failed to flare properly following a 'fast and flat' final approach. The acft landed on its nosewheel resulting in substantial damage to the acft.NTSB CHI84LA284Accident · No injuriesLimited investigationFinal reportCessna 172M · Lake Geneva, WIAccording to the plt, he was on a short final apch to land when the acft encountered sudden turbulence. At that time, the passenger in the right front seat lurched against the control wheel, causing the nose to pitch down & the acft to bank left.…NTSB CHI83LA216Accident · No injuriesLimited investigationFinal reportCessna 150 · Janesville, WIN13364 had stopped short of the runway for a run-up check prior to takeoff. The pilot of N8576J continued his taxi while he was checking the field elevation and setting his altimeter he taxied into the empennage of N13364.NTSB CHI82FA145Accident · 1 fatalField investigationFinal reportCessna 172M · Pardeeville, WIAccording to witnesses the aircraft made a routine takeoff followed by an immediate left climbing turn. The aircraft was observed to lose airspeed and descend into the ground. Witnesses stated that the engine was running until ground impact.NTSB CHI81DEP32Accident · No injuriesClosedCessna 172M · Prt Washington, WINTSB CHI81DEP31Accident · No injuriesClosedCessna 172A · Franklin, WINTSB CHI81DEP17Accident · Minor injuriesClosedCessna 172 · Green Bay, WINTSB CHI80DEP30Accident · Minor injuriesClosedCessna 172M · Ixonia, WINTSB CHI80FEP06Accident · No injuriesClosedCessna 172 · Portage, WINTSB CHI80FA006Accident · 2 fatalClosedCessna 172 · Fall Creek, WINTSB CHI79FEP66Accident · Serious injuriesClosedCessna 172M · Rockwood, WINTSB CHI79DEP62Accident · No injuriesClosedCessna 172 · Coleman, WINTSB CHI79DEP50Accident · Minor injuriesClosedCessna 172H · Boulder Jct, WINTSB CHI78FEP56Accident · No injuriesClosedCessna 172M · Oshkosh, WINTSB CHI78DEP43Accident · Minor injuriesClosedCessna 172 · Arbor Vitae, WINTSB CHI78DEP31Accident · No injuriesClosedCessna 172 · Middleton, WINTSB CHI77DEP56Accident · No injuriesClosedCessna 172M · Dodgeville, WINTSB CHI76DEP46Accident · Serious injuriesClosedCessna 172 · Dodgeville, WINTSB CHI74FEP01Accident · Serious injuriesClosedCessna 172M · Mantowish Wta, WINTSB CHI73DEP21Accident · No injuriesClosedCessna 172 · Lake Geneva, WI