NTSB investigations: Cessna 170B, WA
35 cases on aircraft the registry lists as Cessna 170B. 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
| 1964 | 2 |
|---|---|
| 1965 | 3 |
| 1966 | 2 |
| 1967 | 2 |
| 1969 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 3 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2012 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 1 |
Where
Latest 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 ('2072306', '2072307'))
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 ('2072306', '2072307'))
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 WPR24LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tacoma, WAThe pilot’s failure to maintain directional control during landing.NTSB WPR22LA166Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · Ravensdale, WAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB WPR21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Palouse, WAThe student pilot’s improper landing flare and loss of directional control and the flight instructor’s delayed remedial action resulted in a runway excursion and nose over.NTSB GAA17CA426Accident · No injuriesData collectionFinal reportCessna 170 · Friday Harbor, WAThe pilot’s loss of directional control during landing.NTSB GAA16CA138Accident · No injuriesData collectionFinal reportCessna 170 · Enumclaw, WAThe pilot's incorrect brake application during taxi, which resulted in a nose over.NTSB WPR15LA153Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Centralia, WAMaintenance personnel’s incorrect installation of the fuel selector valvehandle, which resulted in fuel starvation, a loss of engine power, and a forced hard landing. Contributing to the accident was the pilot's failure to follow the manufacturer's checklist.NTSB WPR12CA269Accident · No injuriesData collectionFinal reportCessna 170B · Pullman, WAThe pilot’s failure to maintain directional control of the airplane while landing in gusting crosswind conditions and the flight instructor’s delayed remedial action.NTSB SEA06CA078Accident · No injuriesData collectionFinal reportCessna 170B · Shelton, WAThe main landing gear wheel failure during the takeoff ground roll. A related factor was directional control of the aircraft was not possible after the wheel failure.NTSB SEA04FA083Accident · 1 fatalField investigationFinal reportCessna 170B · Tenino, WAThe pilot's failure to maintain an adequate visual lookout during cruise flight, which resulted in a midair collision between the two airplanes.NTSB SEA02LA054Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Rainier, WAThe pilot's failure to maintain the proper decent rate on approach. A factor was the trees in close proximity to the airport.NTSB SEA00LA058Accident · No injuriesLimited investigationFinal reportCessna 170B · Lopez Island, WAThe pilot's failure to maintain aircraft control during landing. Contributing factors were the crosswind condition, gusts, and the pilot's overall lack of total (flight and tail wheel) experience.NTSB SEA99LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Auburn, WALoss of directional control due to deficient brakes and tailwheel. Factors include leaking brake cylinder, loose tailwheel casting, and obstructions (VASI lights) in the path of the airplane as it left the runway.NTSB SEA97LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Toledo, WAThe pilot's excessive application of the brakes on a tailwheel equipped aircraft. Factors include the pilot's inadequate compensation for wind conditions, and a crosswind blowing at the time of the landing.NTSB SEA96LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Arlington, WAthe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground swerve. The crosswind and wet runway were related factors.NTSB SEA81FYM34Accident · Minor injuriesClosedCessna 170B · Vancouver, WANTSB SEA80DYE01Accident · No injuriesClosedCessna 170B · Copalis Beach, WANTSB SEA78FYP41Accident · No injuriesClosedCessna 170B · Spokane, WANTSB SEA77DYP42Accident · No injuriesClosedCessna 170B · Connell, WANTSB SEA75AS042Accident · 3 fatalClosedCessna 170B · Issaquah, WANTSB SEA75DYE35Accident · No injuriesClosedCessna 170B · Issaquah, WANTSB SEA75DYE29Accident · No injuriesClosedCessna 170B · Lynden, WANTSB SEA75DYE25Accident · No injuriesClosedCessna 170B · Sinclair Isl, WANTSB SEA74DYG37Accident · No injuriesClosedCessna 170B · Garfield, WANTSB SEA73DYE36Accident · No injuriesClosedCessna 170B · Auburn, WANTSB SEA73AS003Accident · 5 fatalClosedCessna 170B · Issaquah, WANTSB SEA70D0098Accident · No injuriesClosedCessna 170B · Monroe, WANTSB SEA68D0158Accident · No injuriesClosedBoeing B75 · Yakima, WANTSB SEA67D0302Accident · No injuriesClosedCessna 170B · Puyallup, WANTSB SEA67D0003Accident · No injuriesClosedCessna 170B · Aldrwood Mnr, WANTSB SEA66D0219Accident · No injuriesClosedCessna 170B · Center Islnd, WANTSB SEA66F0152Accident · No injuriesClosedCessna 170B · Silverdale, WANTSB SEA65D0064Accident · No injuriesClosedCessna 170B · Pasco, WANTSB SEA65F0049Accident · No injuriesClosedCessna 170B · Mesa, WANTSB UNK65X0398Accident · No injuriesClosedCessna 170B · Mesa, WANTSB UNK64X1288Accident · No injuriesClosedCessna 170B · Seattle, WA