NTSB investigations: Cessna 177B, MI

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

19702026

NTSB investigations: Cessna 177B, MI per year, 1970–2026: 11 cases
1970	1
1973	2
1983	1
1985	1
1990	2
1991	1
1992	1
1997	1
2025	1

Where

Open the map

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" = '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 ('2073708')) 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\" = '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 ('2073708'))
  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 ('2073708'))
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 CEN25LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Iron River, MIThe airplane’s collision with runway lights during takeoff due to reduced airplane climb performance. Contributing to the accident was the shifting winds during takeoff which likely developed into a tailwind.Feb 24, 2025 · N34284 · Substantial damage NTSB CHI97FA283Accident · 1 fatalField investigationFinal reportCessna 177B · Crump, MIContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC) and her failure to maintain control of the airplane, due to spatial disorientation. Related factors were the low ceiling, and the pilot's lack of instrument…Sep 7, 1997 · N34142 · Destroyed NTSB CHI92FA161Accident · 2 fatalField investigationFinal reportCessna 177B · Almont, MIThe pilot's failure to maintain control of the airplane during takeoff while physically impaired by alcohol.Jun 2, 1992 · N13860 · Destroyed NTSB CHI91LA162Accident · No injuriesLimited investigationFinal reportCessna 177 · New Lothrop, MIFuel exhaustion and misjudged fuel calculations by the pilot. A factor was the lack of suitable terrain available for an emergency landing.May 22, 1991 · N548EC · Substantial damage NTSB CHI90LA173Accident · No injuriesLimited investigationFinal reportCessna C177B · Northport, MIPilot's delayed decision to abort the landing, and the aircraft's resultant inadequate clearance/altitude and impact with trees.Jul 10, 1990 · N20126 · Destroyed NTSB CHI90LA071Accident · No injuriesLimited investigationFinal reportCessna 177B · Acme, MIThe student pilot misjudged distance and altitude to the runway, and the instructor pilot (CFI) failed to attain remedial action, which resulted in their failure to attain the proper touchdown point. Factors related to the accident were: the cfi's lack of…Jan 20, 1990 · N34860 · Substantial damage NTSB CHI86MA052Accident · 6 fatalMajor investigationFinal reportCessna 177B · Brooklyn, MIThe pilot took off with five passengers approximately 170 pounds over maximum allowable gross weight into known moderate icing conditions. His aircraft was not equipped to fly in these conditions. Radio and radar contact were lost at approximately 3500 feet…Dec 22, 1985 · N34046 · Destroyed NTSB CHI83LA236Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Jackson, MIThe plt stated the eng quit at about 100-200 ft AGL after takeoff. He executed a descending right turn to remain within the arpt boundary & the acft struck the ground. The upper portion of the magneto mount flange was broken & the magneto was hanging by the…Jun 2, 1983 · N20082 · Substantial damage NTSB CHI74FEC21Accident · Minor injuriesClosedCessna 177 · Lapeer, MIDec 6, 1973 · N34150 · Substantial damage NTSB CHI74DEC16Accident · No injuriesClosedCessna 177 · Birmingham, MIOct 5, 1973 · N34089 · Substantial damage NTSB CHI71DBJ40Accident · No injuriesClosedCessna 177B · Barryton, MIOct 30, 1970 · N30832 · Substantial damage