NTSB investigations: Cessna 177A, MI
7 cases on aircraft the registry lists as Cessna 177A. 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 |
|---|---|
| 1974 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 2017 | 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 ('2073706'))
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 ('2073706'))
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 CEN17CA218Accident · Minor injuriesData collectionFinal reportCessna 177 · Plainwell, MIThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overrun.NTSB CHI90LA258Accident · No injuriesLimited investigationFinal reportCessna 177A · Perry, MIThe loss of engine power due to the pilot's inaccurate fuel consumption calculations.NTSB CHI90LA001Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Manistique, MIA delayed by the pilot in going around and his failure to obtain adequate airspeed before fully retracting the flaps, which allowed the aircraft to mush. The contributing factors were: the pilot's failure to attain the proper touchdown point during the…NTSB CHI82FEC01Accident · No injuriesClosedCessna 177A · Gibralter, MINTSB CHI78FEM06Accident · No injuriesClosedCessna 177 · Birch Run, MINTSB CHI75DEM08Accident · Minor injuriesClosedCessna 177A · South Branch, MINTSB CHI71DEC51Accident · No injuriesClosedCessna 177 · Owosso, MI