Skip to content

NTSB investigations: Cessna 177, IL

33 cases on aircraft the registry lists as Cessna 177. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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 ('2073704')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2073704'))
  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 ('2073704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CHI01FA234Accident · 3 fatalField investigationFinal reportCessna 177 · Benton, ILThe pilot's failure to maintain adequate airspeed, resulting in a stall.Jul 22, 2001 · N235LA · Destroyed NTSB CHI97LA111Accident · No injuriesLimited investigationFinal reportCessna 177 · Rantoul, ILthe student pilot's improper flare and improper recovery from a bounced landing.Apr 19, 1997 · N3489T · Substantial damage NTSB CHI97LA104Accident · No injuriesLimited investigationFinal reportCessna 177 · Harrisburg, ILthe loss of engine power followed by an engine fire for reason or reasons undetermined.Apr 15, 1997 · N3322T · Destroyed NTSB CHI93LA083Accident · No injuriesLimited investigationFinal reportCessna 177 · Barrington, ILLoss of engine power due to fuel contamination.Jan 30, 1993 · N29515 · Substantial damage NTSB CHI92FA279Accident · 4 fatalField investigationFinal reportCessna 177 · Manlius, ILThe pilot-in-command's failure to maintain control of the airplane during a forced landing, and his inadequate preflight which resulted in fuel exhaustion and power loss.Sep 17, 1992 · N30076 · Destroyed NTSB CHI92LA192Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Erie, ILThe pilot's failure to maintain a proper glidepath.Jun 28, 1992 · N3195T · Substantial damage NTSB CHI90LA241Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Schaumburg, ILThe pilot's failure to attain a proper climb rate after takeoff. Factors related to the accident are misjudgement of the aircraft takeoff weight, and overconfidence in the ability of the aircraft.Aug 25, 1990 · N29463 · Destroyed NTSB CHI89FA135Accident · 3 fatalField investigationFinal reportCessna 177 · Lockport, ILThe pilot's inadequate preflight planning/preparation, and his failure to attain adequate airspeed, which resulted in a stall or mush. A factor related to the accident was: the aircraft's excessive gross weight.Jul 14, 1989 · N3146T · Destroyed NTSB CHI87FA212Accident · No injuriesField investigationFinal reportCessna 177 · Genoa, ILThe plt made a straight-in apch to land at dusk on an unlighted sod rwy. He stated he lowered 10 deg of flaps aprx 2 mi fm the rwy. While on final apch, with the power set at aprx 1800 RPM, the acft began to settle. The plt said he applied full power, but it…Sep 3, 1987 · N2295Y · Substantial damage NTSB CHI86FEV01Accident · Minor injuriesFinal reportCessna 177 · Canton, ILThe acft sheared the nose gear in a forced landing off arpt in a partially cultivated field. The acft had lost power at about 100 ft AGL during takeoff. The plt said that he checked the mixture, throttle, fuel selector and turned on the electric fuel pump.…Apr 26, 1986 · N2285Y · Substantial damage NTSB CHI86LA112Accident · No injuriesLimited investigationFinal reportCessna 177 · Lacon, ILThe pilot stated he was maintaining a steep approach angle to clear trees at the approach end of the 2200 ft. runway. He flared late, landing hard and damaging the firewall.Mar 27, 1986 · N3187T · Substantial damage NTSB CHI82FEE09Accident · No injuriesClosedCessna 177 · Paw Paw, ILDec 25, 1981 · N3485T · Substantial damage NTSB CHI78FEV18Accident · No injuriesClosedCessna 177 · Matoon, ILFeb 26, 1978 · N30105 · Substantial damage NTSB CHI77FEE36Accident · Serious injuriesClosedCessna 177 · Newark, ILJul 23, 1977 · N2203Y · Substantial damage NTSB CHI76DEV57Accident · No injuriesClosedCessna 177 · Salem, ILAug 6, 1976 · N2849X · Substantial damage NTSB CHI76FEE11Accident · No injuriesClosedCessna 177 · Sugar Grove, ILAug 4, 1975 · N2945X · Substantial damage NTSB CHI75FEE44Accident · No injuriesClosedCessna 177 · Marseilles, ILFeb 2, 1975 · N3111T · Substantial damage NTSB CHI75AC021Accident · 3 fatalClosedCessna 177 · New Lenox, ILAug 24, 1974 · N2802X · Substantial damage NTSB CHI74FEV15Accident · No injuriesClosedCessna 177 · Pittsfield, ILAug 25, 1973 · N3485T · Substantial damage NTSB CHI72FEE64Accident · No injuriesClosedCessna 177 · Richton Park, ILMar 9, 1972 · N3259T · Destroyed NTSB CHI72AC029Accident · 4 fatalClosedCessna 177 · Hanna City, ILSep 27, 1971 · N3417T · Substantial damage NTSB CHI71DBQ37Accident · No injuriesClosedCessna 177 · Savoy, ILApr 23, 1971 · N30195 · Substantial damage NTSB CHI71DEE70Accident · No injuriesClosedCessna 177 · Buda, ILApr 19, 1971 · N3137T · Substantial damage NTSB CHI71FBQ03Accident · No injuriesClosedCessna 177 · Springfield, ILJul 21, 1970 · N2283Y · Substantial damage NTSB CHI70FBD48Accident · Minor injuriesClosedCessna 177 · W.Chicago, ILJun 13, 1970 · N3441T · Substantial damage NTSB CHI70FBQ16Accident · No injuriesClosedCessna 177 · Peoria, ILMay 10, 1970 · N2905X · Substantial damage NTSB CHI70D0355Accident · No injuriesClosedCessna 177 · Ashton, ILNov 9, 1969 · N2905X · Substantial damage NTSB CHI70F0238Accident · No injuriesClosedCessna 177 · Antioch, ILSep 7, 1969 · N29306 · Substantial damage NTSB CHI69F0199Accident · Serious injuriesClosedCessna 177 · E.St.Louis, ILAug 14, 1968 · N3389T · Destroyed NTSB CHI69D0094Accident · No injuriesClosedCessna 177 · Utica, ILJun 30, 1968 · N2254Y · Substantial damage NTSB CHI68F0686Accident · No injuriesClosedCessna 177 · Wheeling, ILMar 17, 1968 · N2205Y · Destroyed NTSB CHI68D0418Accident · No injuriesClosedCessna 177 · Chicago, ILOct 19, 1967 · N2210Y · Substantial damage NTSB CHI66A0050Accident · No injuriesClosedCessna 310D · Peoria, ILNov 19, 1965 · N6777T · Substantial damage