Skip to content

Fatal NTSB investigations: Cessna 170

28 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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."highestInjuryLevel" = 'Fatal' 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

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.\"highestInjuryLevel\" = 'Fatal'
    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."highestInjuryLevel" = 'Fatal'
  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

Run 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 ERA17FA155Accident · 4 fatalField investigationFinal reportCessna 170 · Williston, FLThe pilot's failure to maintain adequate airspeed during initial climb in gusty wind conditions, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall/spin.Apr 15, 2017 · N4244V · Destroyed 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.May 4, 2007 · N4217V · Substantial damage NTSB SEA04LA050Accident · 2 fatalLimited investigationFinal reportCessna 170 · Herron, WAThe failure of the left muffler while maneuvering, resulting in a carbon monoxide leak into the cabin rendering the pilot incapacitated, and the subsequent uncontrolled descent and impact with water.Mar 1, 2004 · N2534V · Destroyed 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.Aug 5, 1995 · N2566V · Destroyed NTSB SEA92FA195Accident · 3 fatalField investigationFinal reportSnodgrass Starduster TOO · Lacey, WAThe failure of both pilots to see and avoid each other.Sep 7, 1992 · N4316 · 2 aircraft · Destroyed NTSB SEA91LA237Accident · 1 fatalLimited investigationFinal reportCessna 170B · Curtis, WAA misjudged maneuver due to physical impairment by alcohol. Contributing to the accident was overconfidence in personal ability.Sep 16, 1991 · N4693C · Destroyed 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…Nov 25, 1990 · N4030V · Substantial damage NTSB DEN90FA120Accident · 1 fatalField investigationFinal reportCessna 170A · Dillon, COImproper planning/decision by the pilot, and his failure to maintain airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the high density altitude and terrain conditions.Jun 3, 1990 · N3944V · Substantial damage NTSB SEA90FA057Accident · 2 fatalField investigationFinal reportCessna 170 · Republic, WAImproper inspection and airworthiness certification of the aircraft on the last annual inspection by an FAA authorized repair station, the inadequate engine performance and low cylinder compression, and the pilots attempt to takeoff with known aircraft…Mar 25, 1990 · N4130V · Destroyed NTSB SEA83FA056Accident · 2 fatalClosedCessna 170 · Azalea, ORJun 6, 1981 · N3973V · Destroyed NTSB LAX78FA057Accident · 3 fatalClosedCessna 170 · Grand Canyon, AZJun 28, 1978 · N4219V · Destroyed NTSB CHI77FA069Accident · 4 fatalClosedCessna 170 · Florence, WIAug 23, 1977 · N4052V · Destroyed NTSB FTW76AF083Accident · 4 fatalClosedCessna 170 · College Sta, TXApr 4, 1976 · N5532C · Destroyed NTSB CHI76AC019Accident · 1 fatalClosedCessna 170 · Bronson, MISep 1, 1975 · N4161V · Substantial damage NTSB NYC75AN093Accident · 1 fatalClosedCessna 170 · Byrdstown, TNMar 16, 1975 · N4082V · Destroyed NTSB UNK72X0112Accident · 3 fatalClosedCessna 170 · Iron Crk, CanadaJul 27, 1972 · N4059V · Destroyed NTSB NYC72AN081Accident · 3 fatalClosedCessna 170 · Woodstock, CTDec 12, 1971 · N4016V · Substantial damage NTSB FTW70AF074Accident · 5 fatalClosedCessna 170 · Nashville, ARMay 16, 1970 · N4119V · Destroyed NTSB MIA70AM082Accident · 2 fatalClosedCessna 170A · Rockledge, FLApr 9, 1970 · N2468X · Destroyed NTSB CHI69A0077Accident · 2 fatalClosedCessna 170 · Troy, MIMar 3, 1969 · N4056V · Destroyed NTSB LAX69O0156Accident · 3 fatalClosedCessna 170 · Mexicali, MexicoSep 8, 1968 · N4248V · Destroyed NTSB MKC69A0009Accident · 2 fatalClosedCessna 170 · Howard Lake, MNAug 7, 1968 · N3901V · Destroyed NTSB DEN67A0080Accident · 1 fatalClosedCessna 170 · Blanding, UTJun 17, 1967 · N4120V · Destroyed NTSB NYC65A0156Accident · 1 fatalClosedCessna 170 · Neffsville, PAJun 27, 1965 · N4080V · 2 aircraft · Minor damage NTSB DEN65A0060Accident · 4 fatalClosedCessna 170 · Ephraim, UTMar 20, 1965 · N3974V · Destroyed NTSB UNK64X1758Accident · 1 fatalClosedCessna 170B · Lakeville, INMay 13, 1964 · N1806C · Destroyed NTSB UNK64X1211Accident · 4 fatalClosedCessna 170A · Dinosaur Cvr, AZApr 7, 1964 · N2544V · Destroyed NTSB UNK64X1149Accident · 3 fatalClosedCessna 170 · Trenton, MIApr 3, 1964 · N4175V · Destroyed