NTSB investigations: Cessna 177, WA
16 cases on aircraft the registry lists as Cessna 177. 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
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1980 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2021 | 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\" = 'WA' 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 ('2073704'))
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" = 'WA' 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 ('2073704'))
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 WPR22LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · White Swan, WAA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB SEA03CA112Accident · No injuriesData collectionFinal reportCessna 177 · Woodland, WAThe pilot's premature liftoff and his failure to maintain/obtain airspeed and directional control during takeoff.NTSB SEA02LA113Accident · No injuriesLimited investigationFinal reportCessna 177 · Mt. Vernon, WAThe pilot's failure to accurately determine the amount of fuel onboard. Factors included trees, and a portable restroom.NTSB SEA00LA041Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Snohomish, WAThe pilot's improper decision to attempt a go-around, then attempt to stop on the wet grass. Factors include variable winds, the pilot's inadequate compensation for the winds conditions, his inadequate recovery from a bounced landing, wet grass along the side…NTSB SEA99LA025Accident · No injuriesLimited investigationFinal reportCessna 177 · Bellingham, WAInadequate preflight planning/preparation, and the pilot's failure to maintain altitude. VFR flight into IMC conditions and cloudy weather conditions were factors.NTSB SEA95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Auburn, WACarburetor obstruction due to ingestion of part of the induction air ducting. A factor was the lack of suitable terrain for the forced landing.NTSB SEA93LA079Accident · No injuriesLimited investigationFinal reportCessna 177 · Buena, WAThe pilot in command's failure to maintain directional control. Factors contributing to the accident were crosswinds and the fence.NTSB SEA91LA249Accident · No injuriesLimited investigationFinal reportCessna 177 · Snohomish, WAThe separation of the mixture control cable (core) resulting from separation of the adel clamp assembly and improper adjustment by maintenance personnel.NTSB SEA89LA145Accident · No injuriesLimited investigationFinal reportCessna 177 · Fall City, WAThe pilot misjudged his landing flare and then did not properly recover from the resulting bounce.NTSB SEA80FA033Accident · 3 fatalClosedCessna 177 · Mineral, WANTSB SEA80DYE26Accident · No injuriesClosedCessna 177 · Lester, WANTSB SEA76DYE54Accident · Minor injuriesClosedCessna 177 · Eliza Island, WANTSB SEA74FYC46Accident · Serious injuriesClosedCessna 177 · Battle Grnd, WANTSB SEA71FWD23Accident · Serious injuriesClosedCessna 177 · Eatonville, WANTSB SEA69A0056Accident · 4 fatalClosedCessna 177 · Wenatchee, WANTSB SEA68A0069Accident · 4 fatalClosedCessna 177 · Lester, WA