NTSB investigations: Cessna 177RG, MI
8 cases on aircraft the registry lists as Cessna 177RG. 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
| 1971 | 1 |
|---|---|
| 1976 | 2 |
| 1980 | 1 |
| 1983 | 1 |
| 1994 | 1 |
| 2012 | 1 |
| 2014 | 1 |
Where
Open the mapLatest 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\" = '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 ('2073709', '2073710'))
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 ('2073709', '2073710'))
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 CEN14LA406Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Manistee, MIThe pilot receiving instruction's inability to respond to or compensate for the sudden change in wind direction and speed that the airplane encountered shortly after liftoff, which resulted in a tailwind condition, a corresponding decrease in airspeed, and a…NTSB CEN13LA076Accident · No injuriesLimited investigationFinal reportCessna 177RG · Lansing, MIA loss of engine power due to the loss of fuel flow through the airplane's fuel tank selector valve.NTSB CHI94LA124Accident · No injuriesLimited investigationFinal reportCessna 177RG · Charlotte, MIthe deer which ran onto the runway. Factors related to the accident were the night conditions and the runway lights which were contacted.NTSB CHI83LA247Accident · No injuriesLimited investigationFinal reportCessna 177RG · Lansing, MIThe acft made a forced landing when the engine quit during the turn to final approach. Just prior to engine failure the pilot stated that he changed the fuel selector to what he believed to be the both tanks position but he actually turned it to the off…NTSB CHI80FEM23Accident · Minor injuriesClosedCessna 177RG · Dorr, MINTSB CHI76FEM54Accident · No injuriesClosedCessna 177RG · Marquette, MINTSB CHI76FEC32Accident · Minor injuriesClosedCessna 177RG · Owosso, MINTSB CHI72FEC10Accident · No injuriesClosedCessna 177 RG · Horton, MI