NTSB investigations: Cessna 172M, MO
42 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 |
| 1974 | 1 |
| 1975 | 3 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 5 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 4 |
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2001 | 1 |
| 2004 | 1 |
| 2007 | 2 |
| 2010 | 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\" = 'MO' 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" = 'MO' 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 CEN10CA562Accident · Minor injuriesData collectionFinal reportCessna 172M · Point Lookout, MOThe pilot receiving instruction's failure to attain the proper touchdown point and execute a go-around and the CFI’s delayed remedial action, which resulted in a runway overrun.NTSB CHI07CA296Accident · Minor injuriesData collectionFinal reportCessna 172 Skyhawk · Stockton, MOThe pilot's improper recovery from a bounced landing, her subsequent loss of control of the airplane, and the inadvertent stall.NTSB CHI07LA288Accident · 1 fatalLimited investigationFinal reportCessna 172M · Union Star, MOThe student pilot's failure to maintain adequate airspeed and the subsequent inadvertent stall while buzzing residences. Contributing to the accident was the pilot performing buzzing maneuvers.NTSB CHI04LA283Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Houstonia, MOThe fatigue failure of the piston end of the connecting rod and the pilot's failure to maintain aircraft control during the forced landing.NTSB CHI02LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Vandalia, MOThe student pilot's inadequate directional control on the previous landing resulting in the overload failure of the nose landing gear fork. Factors were the overload of the nose landing gear fork, and the student pilot's lack of total experience.NTSB CHI00LA036Accident · No injuriesLimited investigationFinal reportCessna 172M · Ava, MOthe improper in-flight decision made by the pilot. Factors to the accident were the charts/other manuals depicting the incorrect frequency, the dirt bank, and the rocks.NTSB CHI99LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Mayview, MOthe pilot's selection of unsuitable terrain for the attempted precautionary landing. Factors to the accident were the overcast weather condition, inadequate preflight planning by the pilot, the inadvertent flight into instrument meteorological conditions, and…NTSB CHI98LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · Chesterfield, MOthe pilot's not obtaining and maintaining directional control. A factor was wet terrain (grass).NTSB CHI96LA062Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Excelsior Sprg, MOthe pilot's selection of the wrong runway for landing and the delayed aborted landing. Factors associated with the accident were the tailwind condition and the pilot's inadequate level-off.NTSB CHI95LA298Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Independence, MOthe pilot's failure to perform the pre-takeoff checklist and set the elevator trim tab to the takeoff position.NTSB CHI93LA098Accident · No injuriesLimited investigationFinal reportCessna 172M · Grain Valley, MOThe student pilot's improper recovery from a bounced landing and failure to maintain directional control.NTSB CHI92LA151Accident · No injuriesLimited investigationFinal reportCessna 172M · Climax Springs, MODelay in aborting the landing by the pilot in command.NTSB CHI92LA121Accident · No injuriesLimited investigationFinal reportCessna 172M · Osage Beach, MOThe pilot-in-command's failure to use all th eavailable runway and his misjudgment of the proper touchdown point during landing.NTSB CHI90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Farmington, MORemedial action was not attained by the CFI. Contributing to the accident was inadequate airspeed and porpoise encountered by the dual student pilot.NTSB MKC88LA138Accident · No injuriesLimited investigationFinal reportCessna 172 · Lamar, MOThe plt of the aerial applicator acft said he was pulling out for an intersection departure on rwy 21, when the Cessna on a landing roll, struck him from the rear. The pilot said that possibly the background, haze, and airframe components made the incoming…NTSB MKC87LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Festus, MOThe CFI was giving inst to a pvt plt who was undergoing a biennial flt review. The pvt plt cmpltd the maneuvers and ret to the arpt. The lndg was aborted and a go-around was made. The CFI took control and executed another appch. The pvt plt was to monitor an…NTSB MKC87LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Kansas City, MOAfter lndg, the PIC was clrd to taxi to the g/a ramp. He was not aware of the new g/a ramp & proceeded toward the old ramp. He saw a large acft coming from the opposite drctn on the same twy, so he modified his route by selecting another way. Mistakenly, he…NTSB MKC86LA078Accident · No injuriesLimited investigationFinal reportCessna 172 · Ava, MOThe plt reports that the eng began to run rough and lose RPM while the acft was cruising at 2500 ft. he said he attempted emerg proc but the loss of RPM continued and he decided on an off-arpt landing. During the apch to the landing area the eng RPM dropped…NTSB MKC85LA196Accident · No injuriesLimited investigationFinal reportCessna 172 M · Gravois Mills, MOThe plt reports that he began his takeoff on rwy 07 which is 2550 ft long, has an asphalt surface and a downhill slope. Plt said the rwy is rough. He said the acft did not achieve the speed desired and he reduced power to abort. He then decided to attempt the…NTSB MKC84LA201Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cuba, MOThe acft nosed over during a forced landing immediately after takeoff. The acft had been parked outdoors and not flown for six months and according to witnesses the plt did nothing except add 10 gallons of fuel to the acft tanks. The acft engine quit when the…NTSB MKC84LA007Accident · No injuriesLimited investigationFinal reportCessna 172M · Blairstown, MOThe plt reported that after he started to takeoff, the acft had rolled aprx 1500 ft when he felt the airspeed was not sufficient, so he aborted. He was unable to stop on the remaining rwy. Before stopping, the acft went thru a shallow ravine. Subsequently,…NTSB MKC83LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Kansas City, MOWhile taxiing off temporary rwy 22 the plt prematurely taxied into the taxiway leading to the air cargo ramp. In an effort to reach the general aviation ramp he turned onto a vehicle access road & the left wing struck a vehicular traffic warning sign.NTSB MKC83LA181Accident · No injuriesLimited investigationFinal reportCessna 172 · Camdenton, MOThe plt reported that during the landing, the acft veered to the left, went off the rwy into grass, then the nose gear collapsed & the acft nosed oer. Marks on the rwy indicated that the acft was landed long, bounced & then touched down with the nose pointed…NTSB MKC83LA029Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Warrenburg, MOPilot had to taxi 4000 feet on runway. Aircraft became airborne, hit ground, and nosed over during this time. One witness said aircraft looked like it was taking off & stalled. Pilot said he was only going 20 mph.NTSB MKC82DA165Accident · No injuriesFinal reportCessna 172M · Warrensburg, MOThe pilot was on a flight from tulsa, ok to gravois mills, MO. At gravois mills, he made two approaches to the wulff harbor airport, but it was dark and he was not familiar with the airfield. So he diverted to Kansas city, MO. While en route to Kansas city,…NTSB MKC82DA118Accident · No injuriesFinal reportCessna 172 · Point Lookout, MOThe aircraft bounced several times during landing and the nose wheel tire blewout. There was substantial damage to the nose strut, firewall and propeller.NTSB MKC82DA025Accident · No injuriesFinal reportCessna 172N · Lee'S Summit, MOPower was added to initiate taxiing. When the aircraft did not turn enough to the left additional power was applied and the aircraft struck a snowbank.NTSB MKC81DCG30Accident · No injuriesClosedCessna 172M · Higbee, MONTSB MKC80FA042Accident · 1 fatalClosedCessna 172M · Cardwell, MONTSB MKC78FCG69Accident · Serious injuriesClosedCessna 172 · Gravois Mills, MONTSB MKC78FCG59Accident · No injuriesClosedCessna 172M · Kansas City, MONTSB MKC78FCG26Accident · Serious injuriesClosedCessna 172M · Protem, MONTSB MKC78FCA22Accident · Serious injuriesClosedCessna 172 · Palmyra, MONTSB MKC78FCG05Accident · Minor injuriesClosedCessna 172M · Osage Beach, MONTSB MKC77DCG13Accident · No injuriesClosedCessna 172M · Moberly, MONTSB MKC76FCA42Accident · Minor injuriesClosedCessna 172M · Centerville, MONTSB MKC76FCG04Accident · Minor injuriesClosedCessna 172 · Butler, MONTSB MKC76AK002Accident · 2 fatalClosedCessna 172M · Portageville, MONTSB MKC75DCG36Accident · No injuriesClosedCessna 172 · Springfield, MONTSB MKC74DCG20Accident · No injuriesClosedCessna 172M · Carrollton, MONTSB MKC74FCA14Accident · No injuriesClosedCessna 172M · Shelbyville, MONTSB MKC73AK033Accident · No injuriesClosedCessna 172 · Chesterfield, MO