NTSB investigations: Cessna 177RG

8 cases on aircraft the registry lists as Cessna 177RG, where the first occurrence was “Loss of control - in flight”. 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

19822026

NTSB investigations: Cessna 177RG per year, 1982–2026: 8 cases
1982	1
1983	1
1989	1
1993	1
1994	1
1998	1
2000	2

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073709', '2073710') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073709', '2073710')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073709', '2073710')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 NYC00LA253Accident · No injuriesLimited investigationFinal reportCessna 177RG · Elmer, NJThe instructor's failure to take remedial action.Sep 7, 2000 · N2156Q · Substantial damage NTSB CHI00FA123Accident · 1 fatalField investigationFinal reportCessna 177RG · Watertown, SDthe pilot failed to maintain aircraft control due to spatial disorientation. Factors relating to the accident were the dark night, clouds, and rain.Apr 27, 2000 · N1978Q · Destroyed NTSB CHI98LA179Accident · No injuriesLimited investigationFinal reportCessna 177RG · Tocsin, INthe pilot's failure to obtain adequate airspeed during the takeoff climb and the resulting inadvertant stall. A factor in the accident was the pilot's premature raising of the flaps.May 28, 1998 · N1849Q · Substantial damage NTSB FTW94LA088Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Longmont, COAn inadvertent stall due to improper preflight and the pilot's failure to adequately remove ice from the aircraft. A factor was airframe icing.Mar 1, 1994 · N2181Q · Substantial damage NTSB ATL93LA074Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Concord City, NCThe failure of the pilot to maintain control of the aircraft and his delayed decision to execute a go around. A factor in the accident was the strong gusty wind condition.Apr 16, 1993 · N44BG · Substantial damage NTSB MIA89FA219Accident · 2 fatalField investigationFinal reportCessna 177RG · Janice, MSThe in flight loss of control by the non instrument rated pilot after encountering instrument meteorological conditions resulting in the airplane spiraling into a wooded area.Aug 14, 1989 · N1976Q · Destroyed NTSB LAX83LA417Accident · No injuriesLimited investigationFinal reportCessna C-177RG · Sedona, AZThe plt stated that instead of using the customary 80 kt approach speed he used 110 KTS with 30 deg of flaps. On short final he was still high but decided to land anyway. He forced the acft onto the rwy & the acft began to porpoise. Unableto recover from the…Aug 30, 1983 · N1845Q · Substantial damage NTSB DEN82DA035Accident · No injuriesFinal reportCessna 177RG · 7 Miles N. Of S, COIn order to slow the aircraft down during flight the pilot lowered 15 degrees of flaps. As the flaps were transitioning down the pilot stated he heard a "pop sound" which was not normal. He then decided to make a precautionary landing on a dirt road. During…Feb 18, 1982 · N33NF · Substantial damage