NTSB investigations: Cessna 172P, MI
24 cases on aircraft the registry lists as Cessna 172P. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 3 |
| 1987 | 1 |
| 1988 | 4 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2013 | 1 |
| 2018 | 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\" = '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 ('2072436'))
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 ('2072436'))
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 GAA18CA391Accident · No injuriesData collectionFinal reportCessna 172 · Troy, MIThe student pilot’s failure to maintain a proper landing flare, which resulted in a hard, porpoised landing during an aborted go-around.NTSB CEN13CA333Accident · No injuriesData collectionFinal reportCessna 172P · Pontiac, MIThe student pilot's failure to maintain aircraft control during the takeoff and his interference with the flight instructor's ability to provide remedial action.NTSB CHI05CA095Accident · No injuriesData collectionFinal reportCessna 172P · Ann Arbor, MIThe failure of the carburetor nozzle resulting in loss of engine power and the unsuitable terrain encountered during the forced landing. A factor was the low altitude.NTSB CHI02LA078Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dowagiac, MIThe pilot's inadequate compensation for the wind conditions that resulted in directional control not being maintained during the landing roll. Factors to the accident were the pilot's inadequate in-flight decision to attempt the landing with a gusting 20 knot…NTSB CHI99LA058Accident · No injuriesLimited investigationFinal reportCessna 172P · Lambertville, MIthe pilot-in-command's loss of directional control during landing roll. Factors to the accident were the icy terrain condition, crosswind, and the snow bank.NTSB CHI97LA189Accident · No injuriesLimited investigationFinal reportCessna 172P · Fowlerville, MIfailure of the pilot to either attain proper touchdown point for landing or go around while he had sufficient airspeed and runway remaining.NTSB CHI95LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Alma, MIthe flight instructor's inadequate remedial action during the approach to landing/landing roll. Related factors are the flight instructor's inadequate supervision, the dual student's wrong runway selection, the tailwind, and the dual student's failure to…NTSB CHI92LA278Accident · No injuriesLimited investigationFinal reportCessna 172P · Yipslanti, MIThe pilot's premature flare during landing and not performing a recovery from a bounced landing.NTSB CHI92LA274Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Charles, MIThe jamming of the oil pressure pump caused by the failure of the oil pressure pump driven impeller. The lack of a suitable landing area was a factor.NTSB CHI92LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Marquette, MIFlight into known adverse weather conditions by the pilot, which resulted in airframe (wing) icing and the inability to maintain altitude. The adverse weather conditions and darkness were related factors.NTSB CHI91LA139Accident · No injuriesLimited investigationFinal reportCessna 172 · Detroit, MIThe proper touchdown point was not attained and the pilot failed to perform a go around. A factor related to the accident was the tailwind condition in which the pilot was attempting to land.NTSB CHI90LA119Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lambertville, MIThe pilot's failure to maintain aircraft control during the aborted landing.NTSB CHI89LA025Accident · No injuriesLimited investigationFinal reportCessna 172P · Samaria, MINTSB CHI88FA231Accident · 1 fatalField investigationFinal reportCessna 172P · Boyne City, MIThe pilot and his passenger were flying low over a sailboat regatta to photograph sailboats. As the pilot maneuvered for a photograph, he throttled back and banked the aircraft in a steep bank. Subsequently, the aircraft stalled and there was insufficient…NTSB CHI88LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Sebewaing, MIThe plt rprtd that when he landed, the acft bounced twice & went straight forward for about 200 ft. when he applied brakes, the acft veered to the left. Subsequently, the acft went off the runway & into a ditch where the nose gear collapsed. The plt believed…NTSB CHI88LA047Accident · No injuriesLimited investigationFinal reportCessna 172P · Jenison, MIThe low total time pilot took off in crosswind conditions for a proficiency flight and during a go around lost directional control and struck a snow bank along the downwind side of the runay.NTSB CHI87LA184Accident · No injuriesLimited investigationFinal reportCessna 172Q · Belleville, MIAlthough the plt saw a dark wx area apch the arpt he elected to shoot a touch and go before terminating the flt. After touchdown and during taxi twr advised wind was 270 degrees at 40 KTS. The pilot continued taxi to the south and the wind nosed the acft down.NTSB CHI85LA371Accident · No injuriesLimited investigationFinal reportCessna 172P · Ann Arbor, MIThe right main tire blew and the left main landing gear was damaged during a hard landing. Aprx 1 foot of the lower half of the firewall was wrinkled.NTSB CHI85LA375Accident · No injuriesLimited investigationFinal reportCessna 172P II · Detroit, MIThe pilot was on a VFR VASI approach to the ATC controlled arpt 5091 ft runway. During ld round out the pilot said it feld like the acft was 'pushed' down onthe runway. The acft bounced and then ld on the nose wheel. The pilot said a helicopter was in a hover…NTSB CHI85LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Pontiac, MIThe acft nosed over after a loss of control during landing roll portion of a touch & go lndg. The low flt time student plt was practicing endings solo when control was lost and the acft left the rwy. The plt reported that he was resetting the carb heat &…NTSB CHI84FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 172P · St. Joseph, MIPieces of wreckage and the body of the plt were recovered from lake Michigan aprx 4 mi sw of st Joseph. Wx at the dep arpt was VFR but deteriorated along the route of flt over the lake due to fog becoming IMC. A caution statement printed on the chicago…NTSB CHI84LA108Accident · No injuriesLimited investigationFinal reportCessna 172P · Lansing, MIThe acft veered off the rwy during landing. The plt tried to straighten the acft with rudder pressure but the acft continued off the rwy into a gully of snow.NTSB CHI83LA181Accident · No injuriesLimited investigationFinal reportCessna 172P · Mt. Pleasant, MIWhile on a local sight-seeing flt, the plt elected to land at mt Pleasant, MI for lunch. A low pass was made over rwy 09. The plt reported that while he was on a second approach to land, the acft encountered wind gusts and a loss of altitude. The plane's…NTSB DEN83FTI02Accident · 2 fatalFinal reportCessna 172P · Dillon, MIThe pilot and three passengers departed Dillon, mt at about 0740 MDT to scout for elk in preparation for hunting the next day. According to a passenger, they flew directly to a mountain area about 30 miles away where they spotted some elk. He said that while…