NTSB investigations: Cessna 177B, CO
7 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.
Cases per year
| 1971 | 1 |
|---|---|
| 1977 | 1 |
| 1979 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 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\" = 'CO' 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" = 'CO' 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" 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 DEN89LA126Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Fort Collins, COLoss of engine power for an undetermined reason. The dark night and terrain condition were considered to be contributing factors.NTSB DEN87LA240Accident · No injuriesLimited investigationFinal reportCessna 177B · Fort Collins, CODuring the approach to Fort Collins downtown airport, the pilot reported encountering moderate turbulence. At touchdown on runway 11, a crosswind gust pushed the aircraft off the left side of the runway into the grass. The aircraft bounced and came to a stop…NTSB DEN86LA233Accident · No injuriesLimited investigationFinal reportCessna 177B · Broomfield, COThe plt said that he was on a high final approach for landing and just prior to touchdown, the acft was hit by a strong gust of wind. After touchdown, the plt lost control of the acft and it went off the left side of the rwy. The acft sustained substantial…NTSB DEN79FTE26Accident · No injuriesClosedCessna 177 · Englewood, CONTSB DEN79DTE25Accident · No injuriesClosedCessna 177B · Ft Morgan, CONTSB DEN77FTE20Accident · No injuriesClosedCessna 177B · Boulder, CONTSB DEN71FTE67Accident · Serious injuriesClosedCessna 177B · Colorado Cty, CO