Skip to content

NTSB investigations: Cessna 177, WI

21 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

19682026

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" = 'WI' 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\" = 'WI' 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" = 'WI' 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 CEN13CA175Accident · Minor injuriesData collectionFinal reportCessna 177 · Elcho, WIThe pilot's inadequate preflight and in-flight fuel management, which led to a total loss of engine power due to fuel exhaustion.Feb 17, 2013 · N30227 · Substantial damage NTSB CHI08CA188Accident · No injuriesData collectionFinal reportCessna 177A · Rhinelander, WIThe loss of engine power for an undetermined reason. A factor was the berm encountered during the forced landing.Jul 1, 2008 · N2295Y · Substantial damage NTSB CHI07LA249Accident · No injuriesLimited investigationFinal reportCessna C-177 · Webster, WIThe loss of engine power for an undetermined reason, and the pilot's misjudged flare during the subsequent forced landing.Jul 8, 2007 · N2292Y · Substantial damage NTSB CHI98LA256Accident · No injuriesLimited investigationFinal reportCessna 177 · Cassville, WIan undetermined event which resulted in engine failure on landing roll out during attempted restart fuel ignited and an undetermined event in the airplane's fuel system which resulted in a fire.Jul 16, 1998 · N3461T · Destroyed NTSB CHI95LA324Accident · No injuriesLimited investigationFinal reportCessna 177 · Camp Lake, WIthe pilot's inadequate compensation for wind conditions, and failure to maintain altitude/clearance from the power line, while on short final approach. The downdraft was a related factor.Sep 16, 1995 · N3497T · Substantial damage NTSB CHI88LA002Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Verona, WIDuring a VFR landing abort full power was applied and flaps selected to the full up position. The aircraft began to settle and a turn to the left was initiated. The left wing dropped abruptly, the nose pitched down and a left hand rotation began. This…Oct 5, 1987 · N3226T · Destroyed NTSB CHI87LA008Accident · No injuriesLimited investigationFinal reportCessna 177 · Waukesha, WIAccording to the plt, it was a normal flight and approach to rwy 18. On touchdown, the acft nose dropped and the acft bounced three of four times. The plt stated that he immediately added pwr and became airborne, but a vibration caused him to cut pwr and land…Oct 22, 1986 · N3436T · Substantial damage NTSB CHI80DEP22Accident · No injuriesClosedCessna 177 · Oshkosh, WIApr 15, 1980 · N30231 · Substantial damage NTSB CHI79FEP69Accident · No injuriesClosedCessna 177 · Oshkosh, WIJul 30, 1979 · N30231 · Substantial damage NTSB CHI74DEP14Accident · Minor injuriesClosedCessna 177 · Shawano, WIAug 15, 1973 · N2957X · Substantial damage NTSB CHI73DEP56Accident · Minor injuriesClosedCessna 177 · Rhinelander, WIApr 30, 1973 · N3174T · Destroyed NTSB CHI73DER06Accident · Serious injuriesClosedCessna 177 · Baldwin, WIMar 25, 1973 · N2352Y · Destroyed NTSB CHI73FEP29Accident · No injuriesClosedCessna 177 · Sullivan, WISep 3, 1972 · N3281T · Destroyed NTSB CHI72DEP33Accident · No injuriesClosedCessna 177 · Racine, WIMar 11, 1972 · N3134T · Substantial damage NTSB CHI72FEP08Accident · No injuriesClosedCessna 177 · Delavan, WIAug 8, 1971 · N3269T · Substantial damage NTSB CHI71AC003Accident · 4 fatalClosedCessna 177 · Wild Rose, WIJul 12, 1970 · N2277Y · Destroyed NTSB CHI70DDM06Accident · No injuriesClosedCessna 177 · Superior, WIJun 4, 1970 · N3134T · Substantial damage NTSB CHI70D0086Accident · No injuriesClosedCessna 177 · Lodi, WIJul 17, 1969 · N3415T · Substantial damage NTSB CHI70D0072Accident · No injuriesClosedCessna 177 · West Bend, WIMay 31, 1969 · N3431T · Substantial damage NTSB CHI68F0612Accident · Minor injuriesClosedCessna 177 · Walworth, WIFeb 4, 1968 · N3361T · Substantial damage NTSB CHI68F0583Accident · No injuriesClosedCessna 177 · Middleton, WIFeb 3, 1968 · N2893X · Substantial damage