NTSB investigations: Cessna 175, WA
16 cases on aircraft the registry lists as Cessna 175. 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
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1971 | 2 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1988 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 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 ('2072502'))
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 ('2072502'))
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 SEA99LA030Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Moses Lake, WAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB SEA98LA041Accident · No injuriesLimited investigationFinal reportCessna 175 · Port Townsend, WAThe pilot's misjudged distance and speed during landing. A factor was the wet grass runway.NTSB SEA97LA192Accident · No injuriesLimited investigationFinal reportCessna 175 · Lynnwood, WAThe pilot's inadequate preflight planning and preparation, which led to fuel exhaustion and subsequent loss of engine power.NTSB SEA88LA105Accident · No injuriesLimited investigationFinal reportCessna 175 · Olympia, WAAfter reducing power in order to land onto the runway a total loss of power occurred. The aircraft was landed short of the ruwnay and during landing roll a ditch was struck collapsing the right main and nose gear. Aircraft inspection revealed 2 2/3 gallons of…NTSB SEA88LA047Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Stevens Pass, WAPlanned flt was VFR transit of cascade mountains in daylight. Plt filed VFR flt plan; wx brief indicated VFR. Unforeseen delays resulted in arrival at planned mountain Pass over one hour late and wx no longer VMC. Plt could see alternate Pass to north…NTSB SEA83LA183Accident · No injuriesLimited investigationFinal reportCessna 175 · Chelan, WAThe acft stalled into an apple orchard during an attempted go-around. The plt said he was being pushed by a crosswind and during the initial flare was unable to correct so he decided to go-around. During go-around the acft was to the leftof the rwy. The plt…NTSB SEA81FA027Accident · Serious injuriesClosedCessna 175 · Burton, WANTSB SEA80FYE25Accident · No injuriesClosedCessna 175 · Bellevue, WANTSB SEA76DYE58Accident · No injuriesClosedCessna 175 · Oak Harbor, WANTSB SEA76DYG11Accident · No injuriesClosedCessna 175 · Nason Creek, WANTSB SEA74AS003Accident · 2 fatalClosedCessna 175 · Neah Bay, WANTSB SEA71FYE37Accident · Minor injuriesClosedCessna 175 · Kenmore, WANTSB SEA71DWG43Accident · No injuriesClosedCessna 175 · Pasco, WANTSB SEA67D0151Accident · No injuriesClosedCessna 175 · Bellevue, WANTSB SEA66F0140Accident · No injuriesClosedCessna 175 · Kent, WANTSB SEA65F0035Accident · Minor injuriesClosedCessna 175 · Omak, WA