NTSB investigations: Cessna 170, AK
25 cases on aircraft the registry lists as Cessna 170. 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 |
|---|---|
| 1970 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1976 | 3 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2007 | 2 |
| 2008 | 1 |
| 2018 | 1 |
| 2023 | 1 |
| 2024 | 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\" = 'AK' 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 ('2072302'))
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" = 'AK' 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 ('2072302'))
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 ANC24LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · McKinley Village, AKThe pilot’s late decision to go-around, failure to maintain proper airspeed, and his exceedance of the airplane’s critical angle of attack which resulted in an aerodynamic stall at too low of an altitude to recover.NTSB ANC23LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Wasilla, AKThe pilot’s failure to maintained directional control and the instructor pilot's inadequate supervision, which resulted in a loss of control during takeoff.NTSB GAA18CA214Accident · No injuriesData collectionFinal reportCessna 170 · Big Lake, AKThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ANC08CA121Accident · No injuriesData collectionFinal reportCessna 170 · Ruby, AKThe pilot's failure to use carburetor heat, while operating at a reduced engine power while maneuvering in carburetor icing conditions.NTSB ANC07CA043Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot's failure to maintain clearance from trees while landing, and his selection of an unsuitable landing site, which resulted in an in-flight collision with a tree and an on-ground encounter with brush.NTSB ANC07FA037Accident · 1 fatalField investigationFinal reportCessna 170 · Wasilla, AKA total loss of engine power during takeoff initial climb due to fuel contamination, and the pilot's inadequate preflight inspection.NTSB ANC98LA163Accident · No injuriesLimited investigationFinal reportCessna 170B · Igiugig, AKThe pilot's failure to maintain directional control of the aircraft. Contributing factors were the crosswind condition, the pilot's lack of total experience in make/model of the aircraft, and the pilot not achieving a climb on takeoff.NTSB ANC97LA059Accident · No injuriesLimited investigationFinal reportCessna 170 · Delta Junction, AKfailure of the pilot to maintain directional control of the airplane.NTSB ANC96LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Northway, AKThe pilot's failure to maintain directional control of the airplane during landing.NTSB ANC95FA129Accident · 2 fatalField investigationFinal reportCessna 170 · Coldfoot, AKThe pilot's failure to maintain adequate distance and/or altitude from terrain. Rising mountainous terrain and downdrafts associated with unfavorable wind conditions were factors in the accident.NTSB ANC92LA063Accident · No injuriesLimited investigationFinal reportCessna 170 · Kenai, AKThe pilot's failure to maintain directional control. Factors to the accident were: an inadequate recovery from a bounced landing, and the pilot's lack of familiarity with the modified aircraft.NTSB ANC92LA014Accident · No injuriesLimited investigationFinal reportCessna 170 · Whiskey Gulch, AKThe pilot's failure to maintain an airspeed above stalling during maneuvering flight. A factor relating to the accident was operating at an altitude inadequate in which to effect recovery.NTSB ANC91FA014Accident · 1 fatalField investigationFinal reportCessna 170 · 40 W Of Clear, AKThe non-instrument rated pilot-in-command's loss of control while attempting to operate under visual flight rule while in instrument meteorological conditions. Contributing to the accident was the whiteout condition created by the vast expanse of white lake…NTSB ANC87LA121Accident · No injuriesLimited investigationFinal reportCessna 170 · Mi.70 Glenn Hwy, AKThe pilot stated the weather was deteriorating with visibility less than one mile and rainshowers. The pilot elected to make a precautionary landing on a state highway. During the landing roll the aircraft struck a road sign with the right wing of the…NTSB ANC82DA086Accident · No injuriesFinal reportCessna 170 · Near Anchorage, AKPilot tried stop landing on sandbar he had done touch and go landings on. Sand was soft and flying speed not attained before curve in sandbar during takeoff attempt. Pilot could not negotiate turn and continued into river.NTSB ANC82DAG12Accident · No injuriesClosedCessna 170 · Anchorage, AKNTSB ANC80DAA28Accident · No injuriesClosedCessna 170 · Arctic Village, AKNTSB ANC79DAG38Accident · No injuriesClosedCessna 170 · Birchwood, AKNTSB ANC76DAA62Accident · No injuriesClosedCessna 170 · Tok, AKNTSB ANC76FAA37Accident · No injuriesClosedCessna 170 · Ft.Wainwright, AKNTSB ANC76DAA30Accident · No injuriesClosedCessna 170 · North Pole, AKNTSB ANC75FAA34Accident · No injuriesClosedCessna 170 · Fairbanks, AKNTSB ANC72DAH21Accident · No injuriesClosedCessna 170 · Kenai, AKNTSB ANC71DAD03Accident · No injuriesClosedCessna 170 · Haines, AKNTSB ANC69F0009Accident · Minor injuriesClosedCessna 170 · Skwentna, AK