NTSB investigations: Cessna 172N, IL
56 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
| 1978 | 1 |
|---|---|
| 1979 | 5 |
| 1980 | 5 |
| 1981 | 5 |
| 1982 | 2 |
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 3 |
| 2003 | 1 |
| 2004 | 1 |
| 2007 | 2 |
| 2011 | 2 |
| 2012 | 2 |
| 2014 | 1 |
| 2016 | 1 |
| 2022 | 2 |
Where
Latest 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\" = 'IL' 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" = 'IL' 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 CEN22LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Jacksonville, ILThe pilot’s failure to attain proper flare during landing, resulting in a bounced landing.NTSB CEN22LA120Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Murphysboro, ILThe pilot’s failure to maintain clearance from power lines during approach for landing.NTSB GAA16CA245Accident · No injuriesData collectionFinal reportCessna 172 · Carbondale, ILThe student pilot's inadequate flare which resulted in a hard landing, loss of directional control, and a runway excursion.NTSB CEN14CA457Accident · No injuriesData collectionFinal reportCessna 172N · Murphysboro, ILA hard landing by person(s) unknown.NTSB CEN13CA074Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe pilot’s failure to maintain directional control of the airplane while landing.NTSB CEN13CA098Accident · No injuriesData collectionFinal reportCessna 172N · Moline, ILThe student pilot's misjudgment of the landing flare, which resulted in a bounced landing.NTSB CEN11LA413Accident · No injuriesLimited investigationFinal reportCessna 172N · Bedford Park, ILA loss of engine power due to a fractured push rod precipitated by a stuck exhaust valve.NTSB CEN11CA184Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe student pilot's failure to maintain directional control of the airplane during the takeoff.NTSB CHI07CA202Accident · No injuriesData collectionFinal reportCessna 172N · Yorkville, ILThe inadequate fuel consumption calculations by the pilot, the fuel exhaustion during cruise flight, and the unsuitable landing area encountered by the pilot. Contributing factors were the night light conditions and trees.NTSB CHI07CA082Accident · No injuriesData collectionFinal reportCessna 172N · Pinckneyville, ILPresence of a deer on the runway resulting in an inadvertent collision during the landing roll.NTSB CHI04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Cahokia, ILThe inadequate supervision by the certified flight instructor which lead to the student pilot's failure to maintain clearance from the snowbank during the landing. The snowbank was a factor.NTSB CHI03LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Carbondale, ILThe pilot failed to properly recover from a bounced landing which resulted in the airplane porpoising.NTSB CHI01LA202Accident · No injuriesLimited investigationFinal reportCessna 172N · West Chicago, ILThe instructor pilot's inadequate recovery from the bounced landing and inadequate supervision of the dual students alignment with the runway. A factor was the student pilot not maintaining proper alignment with the runway during landing.NTSB CHI01FA093Accident · 2 fatalField investigationFinal reportCessna 172H · Centralia, ILThe student pilot allowed the airspeed to get too low and inadvertently stalled the airplane, and the CFI delayed in taking remedial action.NTSB CHI01LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln, ILThe pilot's failure to maintain directional control on the runway. Factors relating to this accident were the aborted takeoff attempt, the pilot's improper in-flight planning/decision, and the snowbank.NTSB CHI00LA169Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, ILthe student pilot failed to properly flare the airplane while landing. A factor associated with the accident was the student pilot's lack of total experience.NTSB CHI99LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Addison, ILThe pilot's improper fuel selector positioning resulting in fuel starvation during cruise.NTSB CHI98LA335Accident · No injuriesLimited investigationFinal reportCessna 172 · Harrisburg, ILthe loss of engine power for undetermined reasons.NTSB CHI98LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · New Lenox, ILLoss of engine power for undetermined reasons.NTSB CHI98LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Sandwich, ILthe pilot's inability to maintain flying airspeed resulting in an inadvertent stall/mush. A factor contributing to this accident was the wind gust.NTSB CHI96LA302Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenwood, ILthe pilot's failure to obtain a proper touchdown point.NTSB CHI96LA156Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Crystal Lake, ILthe pilot not flying a proper glidepath for the displaced runway threshold.NTSB CHI96LA140Accident · No injuriesLimited investigationFinal reportCessna 172 · Dekalb, ILThe flight instructor's inadequate supervision, and his delay in taking remedial action to regain directional control of the airplane. Factors relating to the accident were: the student's improper flare for landing, improper recovery from a bounced landing,…NTSB CHI93FA272Accident · Serious injuriesField investigationFinal reportCessna 172N · Long Grove, ILThe pilot-in-command's failure to refuel the airplane prior to fuel exhaustion. Related factors to the accident were: inadequate certification/approval of the STC by the FAA, inadequate performance data, and unavailable fuel consumption information.NTSB CHI92LA277Accident · No injuriesLimited investigationFinal reportCessna 172N · Geneseo, ILThe pilot's attempted operation of the airplane with a known defficiency in the equipment.NTSB CHI91LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chicago, ILThe pilot in command (student)'s improper judgement of the proper touchdown point. A factor contributing was the pilot in command's delaying an aborted landing.NTSB CHI91LA081Accident · No injuriesLimited investigationFinal reportCessna 172N · Lansing, ILInadequate compensation for wind conditions and failure to maintain directional control. A factor related to the accident is the snow covered runway.NTSB CHI90FA263Accident · 2 fatalField investigationFinal reportCessna 172N · Paris, ILThe pilot's continuation of VFR flight into instrument meteorological conditions. Factors contributing to the accident were the fog and the dark night.NTSB CHI87LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Frankfort, ILThe student plt was on a flt with 2 pax aboard. He rprtd that drg a ngt lndg, the acft bounced & ballooned. He added pwr to fly the acft back down to the rwy, but it bounced & ballooned again. By this time, the acft was about halfway down the rwy.…NTSB CHI87LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bethalto, ILThe pilot attempted an ILS approach into an airfield (runway 29) that was reporting a zero foot obscured ceiling with 1/16 mile visibiltiy and fog. He stated that he became confused during the last portion of the approach and was beginning a missed approach…NTSB CHI86FA029Accident · 2 fatalField investigationFinal reportCessna 172N · Mt Carmel, ILAccording to the survivor, the plt & 2 pax all had a beer, then went to the arpt. After taking off at night, the plt flew over Mt Carmel, then flew toward his home. He elected to make a low pass over his house. During the pass, the acft struck a tree & some…NTSB CHI85LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Crystal Lake, ILThe plt reported that as he lowered the nosewheel to the rwy during the landing roll, the acft veered to the right. As the right main gear went off the side of the rwy, it entered soft terrain which pulled the acft further to the right. Subsequently, the nose…NTSB CHI85FA014Accident · 1 fatalField investigationFinal reportCessna 172N · Hoopeston, ILThe plt landed short of destination & reported to fss that he did so because of thunderstorms in the area. After receiving a wx briefing the non-inst plt cancelled his VFR flt plan. One hour later the plt called fss & was re-briefed on the wx. The wx at his…NTSB CHI84LA277Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lansing, ILThe acft ran off the end of the rwy into a ditch during landing. The plt said that his landing speed was 'well above normal touchdown speed.' He had made one approach before the accident and went around because he was 'landing long.' There were no reported…NTSB CHI84LA261Accident · No injuriesLimited investigationFinal reportCessna 172N · Kilbourne, ILThe student pilot stated that the nose wheel cocked in sand while taxing and the acft nosed over.NTSB CHI83LA432Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Carthage, ILThe acft collided with a ditch during landing. The acft bounced and floated during landing. The pilot said he thought hewas too FAR down the rwy for a go-around so he applied the brakes. The acft skidded off the rwy end into a ditch. The pilot thought a gust…NTSB CHI83LA427Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbondale, ILThe instructor plt (CFI) was providing a dual check-out for a private plt in the Cessna 172. After flying in the local area, they returned to the arpt to practice touch-and-go landings on rwy 18. The winds were reported from 190 deg at 20, gusting 25 KTS. On…NTSB CHI83LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Galesburg, ILThe plt stated that during cruise, the engine started to run rough. He applied carburetor heat & initiated emergency procedure, and then engine power was restored. However, a short time later, power was lost again. During a forced landing in an open field,…NTSB CHI83LA003Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Seneca, ILWhile landing on a 2300 ft runway, the plane touched down about 1000 to 1200 ft beyond the approach end. The pilot felt that there was insufficient room to stop safely, so she initiated a go-around. The pilot was unable to attain enough altitude to clear…NTSB CHI82DA362Accident · No injuriesFinal reportCessna 172 · Park Forest, ILThe pilot stated there was a partial loss of power during the takeoff roll. He reported that there was insufficient runway remaining to stop when the power loss occurred. The available airspeed was used to "hop" over a 3-foot embankment, but the nose gear,…NTSB CHI82FEE07Accident · No injuriesClosedCessna 172N · Kankakee, ILNTSB CHI82FEE05Accident · No injuriesClosedCessna 172N · Grayslake, ILNTSB CHI81FEE44Accident · Minor injuriesClosedCessna 172N · Deerfield, ILNTSB CHI81FA045Accident · 3 fatalClosedCessna 172N · Atlas, ILNTSB CHI81DEE28Accident · No injuriesClosedCessna 172 · Aurora, ILNTSB CHI81DEV06Accident · No injuriesClosedCessna 172 · Urbana, ILNTSB CHI80DEE56Accident · No injuriesClosedCessna 172 · Lansing, ILNTSB CHI80DEE43Accident · No injuriesClosedCessna 172N · Rockford, ILNTSB CHI80DEE33Accident · No injuriesClosedCessna 172 · Kankakee, ILNTSB CHI80DEE29Accident · No injuriesClosedCessna 172N · Belvidere, IL