NTSB investigations: Cessna 172N, MI
42 cases on aircraft the registry lists as Cessna 172N. 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
| 1977 | 1 |
|---|---|
| 1978 | 2 |
| 1980 | 6 |
| 1981 | 3 |
| 1982 | 4 |
| 1984 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 3 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 2 |
| 2010 | 2 |
| 2014 | 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 ('2072434'))
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 ('2072434'))
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 CEN14CA186Accident · No injuriesData collectionFinal reportCessna 172N · Marine City, MIThe pilot's improper recovery from a bounced landing.NTSB CEN10CA190Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe pilot’s failure to maintain directional control during the landing rollout with gusting winds.NTSB CEN10FA101Accident · 2 fatalField investigationFinal reportCessna 172 · Holland, MIThe pilot's decision to take off in known instrument meteorological conditions without instrument currency or recent instrument experience, which led to spatial disorientation resulting in an inadvertent spin. Contributing to the accident was the pilot's lack…NTSB CHI07CA245Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe student pilot's improper flare, which resulted in a hard landing. An additional cause was the pilot's inadequate recovery from a bounced landing. Factors in the accident include the pilot's failure to maintain directional control during the landing roll…NTSB CHI07CA076Accident · No injuriesData collectionFinal reportCessna 172N · Holland, MIThe student pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the takeoff, which caused the airplane to impact the snow bank and nose over. Contributing factors were the crosswind and the snow…NTSB CHI06CA083Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe solo student pilot's failure to properly compensate for the crosswind, resulting in his failure to maintain directional control during landing. Factors were the crosswind and the snow bank.NTSB CHI03LA290Accident · No injuriesLimited investigationFinal reportCessna 172N · Romeo, MIThe pilot not maintaining directional control during landing. A factor to the accident was the parked airplane.NTSB CHI03LA035Accident · No injuriesLimited investigationFinal reportCessna 172N · Holland, MIThe student pilot failed to maintain directional control during landing roll. Additional factors include the student pilot's lack of total flight experience, the CFI's inadequate supervision, and the ice and snow on the runway.NTSB CHI02LA004Accident · No injuriesLimited investigationFinal reportCessna 172N · Beaver Island, MIThe pilot not maintaining directional control of the airplane during landing. The gusty crosswind and the berm were factors.NTSB CHI00LA172Accident · No injuriesLimited investigationFinal reportCessna 172N · Canton, MIthe CFI delayed initiating a go-around during the landing. Factors associated with the accident were the student pilot's inadequate handling of the airplane, the crosswind condition, and the soft terrain on which the airplane touched down.NTSB CHI00LA146Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Plainwell, MIthe pilot exceeded the proper touchdown point during the landing. Factors associated with the accident were the fence and the ditch which the airplane contacted.NTSB CHI99LA245Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, MIthe student pilot's inadequate use of the rudder which resulted in a loss of directional control during an aborted landing. A factor associated with the accident was the student's lack of total experience and the segmented circle which the airplane contacted.NTSB CHI98LA340Accident · No injuriesLimited investigationFinal reportCessna 172N · Traverse City, MIthe inadvertent stall/mush. Factors contributing to this accident were the pilot's improper compensation for the wind conditions, and his excessively high flare.NTSB CHI96LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Niles, MIfuel exhaustion as a result of the pilot's improper fuel consumption calculations. Factors related to the accident were: the pilot's lack of familiarity with the aircraft and operating with a known malfunctioning fuel gauge.NTSB CHI95LA297Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Clarkston, MIthe pilot's failure to refuel.NTSB CHI95LA132Accident · No injuriesLimited investigationFinal reportCessna 172N · Detroit, MIthe student pilot's failure to maintain directional control during the takeoff ground run. A factor associated with the accident was the soft terrain.NTSB CHI94LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lambertville, MIthe pilot-in-command's not maintaining airspeed. A factor was the pilot-in-command's misjudging the flare.NTSB CHI94LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lambertville, MIThe inadequate maintenance of the airplane resulting in a foreign object in the induction system.NTSB CHI94LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Mackinac Island, MIExcessive airspeed and a failure to attain the proper touchdown point on the runway. Factors related to the accident were the wet runway and the fence which was contacted.NTSB CHI93LA196Accident · No injuriesLimited investigationFinal reportCessna 172N · St. James, MIThe pilot landed too long on a wet runway.NTSB CHI92FA254Accident · 1 fatalField investigationFinal reportCessna 172N · Marquette, MIThe pilot's failure to maintain proper altitude during the approach.NTSB CHI92FAMS2Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Lake Michigan, MIUndetermined.NTSB CHI87LA174Accident · No injuriesLimited investigationFinal reportCessna 172N · Troy, MIThe plt lndd at ngt & taxied the acft to a hangar area for a passenger stop. After the passenger deplaned, the plt proceeded to make a u-turn around a t-hangar & onto an automobile service road that wasn't normally used for acft. Whilethe plt was attempting…NTSB CHI86LA178Accident · No injuriesLimited investigationFinal reportCessna 172N · West Branch, MIThe student pilot's CFI had advised him to refuel at an en route arpt on the x-county solo flt because there was no fuel avail at departure arpt. The student did not dip thetanks but stated 'based on my calculations of fuel burn there should have been enough…NTSB CHI85LA094Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Holland, MIThe plt stated that a slight rudder pedal misalignment caused the acft to run off the rwy & into a ditch during the takeoff roll. He stated that during the first part of the takeoff roll the rudder 'did not respond normally or as expected.' A later…NTSB CHI84LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Holland, MIThe plt landed left of the rwy centerline with the acft 5 degrees left of the rwy heading. He did not correct to the right and the acft collided with a snowbank and nosed over.NTSB CHI83LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Port Hope, MIThe pilot estimated that the wind was from 210 to 220 deg at 15 KTS. He reported that the grass runway was soft and wet. For takeoff on runway 18, he used 10 deg of flaps and about 1/2 of the available aileron while using a soft field takeoff procedure. The…NTSB CHI82FA186Accident · 2 fatalField investigationFinal reportCessna 172N · Milford, MIEarlier in the evening during a return flt from london, ontario to pontiac, MI the plt became disoriented & was radar vectored to detroit city arpt, the only arpt reporting VMC. The plt landed at about 2208. After landing the plt received two wx briefings at…NTSB CHI82DA049Accident · No injuriesFinal reportCessna 172N · Lambertville, MIThe pilot and 3 passengers returned to the airport after a flight in the local area. A normal approach was made with 20 degrees of flaps for a crosswind landing. The pilot reported that his approach speed was a little fast. During landing, the aircraft…NTSB CHI82DA041Accident · No injuriesFinal reportCessna 172 · Benton Harbor, MIThe pilot received a weather briefing at 1030 EST for a cross-country flight. The cross-country originated at Benton Harbor at 1100 EST using runway 27. At that time, the runway was bare and dry. The flight proceeded to battle creek and kalamazoo, and then…NTSB CHI81FA093Accident · 4 fatalClosedCessna 172N · Adrian, MINTSB CHI81FEC32Accident · No injuriesClosedCessna 172N · Lambertville, MINTSB CHI81DEC13Accident · No injuriesClosedCessna 172N · New Hudson, MINTSB CHI81FA004Accident · 3 fatalClosedCessna 152 · Linden, MINTSB CHI81DEC31Accident · No injuriesClosedCessna 172 · Pontiac, MINTSB CHI80FA063Accident · 2 fatalClosedCessna 172 · Bois Blanc Is, MINTSB CHI80DEC28Accident · Minor injuriesClosedCessna 172N · Ubly, MINTSB CHI80DEC20Accident · No injuriesClosedCessna 172N · Troy, MINTSB CHI80DEC14Accident · No injuriesClosedCessna 172 · Pontiac, MINTSB CHI78DEC39Accident · No injuriesClosedCessna 172N · Salem, MINTSB CHI78FEM26Accident · No injuriesClosedCessna 172N · Battle Creek, MINTSB CHI77FA068Accident · 1 fatalClosedCessna 172N · Salem, MI