Skip to content

Fatal NTSB investigations: Cessna 170A

48 cases on aircraft the registry lists as Cessna 170A. 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

19652026

Fatal NTSB investigations: Cessna 170A per year, 1965–2026: 48 cases
1965	1
1966	2
1967	6
1968	1
1969	2
1970	1
1971	1
1972	4
1973	3
1974	3
1975	1
1977	1
1978	2
1979	2
1980	1
1981	1
1982	1
1985	3
1987	1
1988	1
1989	1
1991	1
1992	1
1996	1
1998	2
1999	1
2002	1
2005	1
2021	1

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 ('2072304')) 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 ('2072304'))
  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 ('2072304'))
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 WPR21LA097Accident · 1 fatalClass 3 · LimitedFinal reportCessna 170A · Port Angeles, WAThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate in-flight fuel planning.Jan 27, 2021 · N9114A · Substantial damage NTSB SEA05LA198Accident · 1 fatalLimited investigationFinal reportCessna 170A · Ione, WAThe pilot's failure during low-level maneuvering flight, to maintain clearance from a pair of unmarked power lines. Factors include the pilot's intentional low altitude flight/maneuver and wires.Sep 21, 2005 · N9527A · Substantial damage NTSB DEN02FA043Accident · 1 fatalField investigationFinal reportCessna 170A · Casper, WYthe pilot's inadvertent flight into adverse weather conditions and his subsequent failure to maintain aircraft control. A factor contributing to this accident was the fog.May 17, 2002 · N1211D · Destroyed NTSB NYC99FA060Accident · 1 fatalField investigationFinal reportCessna 170A · Leominster, MAThe pilot's failure to maintain the proper altitude during the approach.Feb 11, 1999 · N1460D · Substantial damage NTSB NYC98FA185Accident · 1 fatalField investigationFinal reportCessna 170A · Lagrangeville, NYThe pilot's failure to maintain airspeed during the takeoff, which resulted in an inadvertent stall/spin.Sep 12, 1998 · N4709Q · Substantial damage NTSB MIA98FA064Accident · 1 fatalField investigationFinal reportCessna 170A · Miami, FLfailure of the pilot to maintain adequate airspeed during a banner pickup, which resulted in an inadvertent stall and collision with the terrain. The lack of altitude for a stall recovery was a related factor.Jan 31, 1998 · N1200D · Substantial damage NTSB FTW96FA130Accident · 4 fatalField investigationFinal reportCessna 182R · Proctor, ARfailure of the pilots in both airplanes to see-and-avoid conflicting traffic (inadequate visual lookout).Feb 24, 1996 · N9303E · 2 aircraft · Destroyed NTSB SEA92FA197Accident · 4 fatalField investigationFinal reportCessna 170A · Lopez, WAThe pilot's inadvertent stall/spin. Factors include gusty, unfavorable, high velocity winds, and turbulence.Sep 13, 1992 · N9577A · Destroyed NTSB FTW91FA142Accident · 2 fatalField investigationFinal reportCessna 170A · Heath, TXThe inadvertent stall following an abrupt pull up while maneuvering at low altitude, and the pilot's impairment due to to alcohol and drug consumption.Aug 7, 1991 · N9582A · Destroyed NTSB MIA90FA031Accident · 2 fatalField investigationFinal reportCessna 170A · Rogersville, TNContinued flight into instrument meteorological conditions by a non-instrument rated pilot resulting in spatial disorientation and a loss of aircraft control. Factors contributing to the accident were: the pilot's overconfidence in his ability to fly in…Nov 26, 1989 · N9192A · Destroyed NTSB FTW88FA160Accident · 4 fatalField investigationFinal reportCessna 170A · El Paso, TXPilot's impairment due to the influence of alcohol.Sep 3, 1988 · N9101A · Destroyed NTSB NYC88LA059Accident · 1 fatalLimited investigationFinal reportCessna 170A · Sandwich, MAThe Cessna 170A was on an aerial photography flt. Witnesses rprtd the acft was flying slow at about 200 ft AGL when it began to settle. The witnesses then heard an increase in eng power & saw the acft pitch up. Subsequently, it 'fell off on a wing,' crashed…Dec 22, 1987 · N5571C · Destroyed NTSB CHI86FA013Accident · 1 fatalField investigationFinal reportCessna 170A · Murphysboro, ILThe plt took off in marginal VMC in an acft placarded for 'day VFR only'. Aprx 32 minutes after takeoff the acft collided with trees and descended to ground impact. A hunter in the local area at the time of the accident reported hearing the acft eng sound…Oct 19, 1985 · N9271A · Destroyed NTSB CHI85FA292Accident · 1 fatalField investigationFinal reportCessna 170A · Olney, ILThe aircraft departed new baden and began flying erratically down an interstate highway. It caused one automobile accident by flying low head-on passes at cars. It flew underan overpass, damaging a wingtip in the process. It flew intoan electrical cable and…Jul 16, 1985 · N1223D · Substantial damage NTSB SEA85FA049Accident · 3 fatalField investigationFinal reportCessna 170A · Lopez, WAShortly after departure N3845V joined up with another acft and was flying aprx 200-300 ft AGL in formation. The plt of N3845V then pulled up into what witnesses described as a wing over maneuver after which the acft descended to ground impact. One witness,…Jan 27, 1985 · N3845V · Destroyed NTSB ATL82FA263Accident · 3 fatalField investigationFinal reportCessna 170A · Brunswick, GAThe non-instrument rated pilot was on a flight from ironton, oh to daytona beach, FL with an en route stop at columbia, SC. He obtained a weather briefing prior to departing ironton, but did not update it after landing at columbia. The aircraft crashed on the…Sep 4, 1982 · N9263A · Destroyed NTSB LAX81FA094Accident · 1 fatalClosedCessna 170A · Homeland, CAMay 30, 1981 · N1305D · Destroyed NTSB SEA80FA037Accident · 2 fatalClosedCessna 170A · Clinton, WAJul 17, 1980 · N1713D · 2 aircraft · Destroyed NTSB DEN79FA035Accident · 2 fatalClosedCessna 170A · Larkspur, COMar 31, 1979 · N5759C · Substantial damage NTSB LAX81FA078Accident · 3 fatalClosedCessna 170A · Morgan Hill, CAMar 20, 1979 · N9117A · Destroyed NTSB SEA78DA042Accident · 1 fatalClosedCessna 170A · Billings, MTJul 9, 1978 · N1780D · Destroyed NTSB ANC78FA016Accident · 3 fatalClosedCessna 170-A · Anchorage, AKJan 28, 1978 · N5476C · Substantial damage NTSB ANC77FA066Accident · 5 fatalClosedCessna 170-A · Portage Pass, AKJul 30, 1977 · N9543A · Destroyed NTSB MKC76AK015Accident · 3 fatalClosedCessna 170 · Mahtowa, MNAug 29, 1975 · N69TT · Destroyed NTSB DEN75AD005Accident · 2 fatalClosedCessna 170A · Bernardo, NMAug 25, 1974 · N5423C · Destroyed NTSB DEN74AD058Accident · 2 fatalClosedCessna 170A · Dubois, WYJun 18, 1974 · N5787C · Destroyed NTSB IAD74AI058Accident · 2 fatalClosedCessna 170A · Newport News, VAMay 3, 1974 · N9503A · Destroyed NTSB ANC74AA045Accident · 3 fatalClosedCessna 170 · Anchorage, AKNov 17, 1973 · N9058A · Destroyed NTSB MKC74AK018Accident · 3 fatalClosedCessna 170A · Beaverton, MIOct 21, 1973 · N5580C · Destroyed NTSB CHI74AC002Accident · 1 fatalClosedCessna 170A · Superior, WIJul 2, 1973 · N9745A · Destroyed NTSB NYC73AN089Accident · 2 fatalClosedCessna 170A · Turner, MEDec 27, 1972 · N1452D · Destroyed NTSB ANC73AA014Accident · 3 fatalClosedCessna 170A · Willow, AKAug 15, 1972 · N9000A · Destroyed NTSB OAK72AP042Accident · 1 fatalClosedCessna 170A · Biggs, CAMay 24, 1972 · N9941A · Destroyed NTSB SEA72AS044Accident · 1 fatalClosedCessna 170A · Medford, ORApr 4, 1972 · N1474D · Destroyed NTSB CHI72AC007Accident · 2 fatalClosedCessna 170A · Pittsfield, ILJul 16, 1971 · N1499D · Destroyed NTSB MKC71AK004Accident · 1 fatalClosedCessna 170A · Elmo, MOJul 23, 1970 · N1340D · Destroyed NTSB OAK70A0017Accident · 4 fatalClosedCessna 170A · Los Banos, CASep 6, 1969 · N9966A · Destroyed NTSB FTW69A0076Accident · 1 fatalClosedCessna 170A · N.Little Rock, ARApr 24, 1969 · N1417D · Destroyed NTSB SEA69A0004Accident · 1 fatalClosedCessna 170A · Hermiston, ORJul 15, 1968 · N9747A · Destroyed NTSB FTW68A0054Accident · 4 fatalClosedCessna 170A · Van Horn, WANov 26, 1967 · N81K · Destroyed NTSB FTW68A0006Accident · 1 fatalClosedCessna 170A · Burrton, KSJul 17, 1967 · N5535C · Destroyed NTSB CHI67A0120Accident · 1 fatalClosedCessna 170 · Walbridge, OHApr 23, 1967 · N9096A · Destroyed NTSB FTW67A0081Accident · 1 fatalClosedCessna 170 · Cedar Hill, TXFeb 5, 1967 · N1399D · Destroyed NTSB NYC67A0105Accident · 3 fatalClosedCessna 170A · Mcclellandtown, PAJan 22, 1967 · N9753A · Destroyed NTSB CHI67A0089Accident · 3 fatalClosedCessna 170Jan 14, 1967 · N9201A · Destroyed NTSB MIA67A0037Accident · 4 fatalClosedCessna 170A · N.Wilkesboro, NCSep 25, 1966 · N5744C · Destroyed NTSB LAX67A0008Accident · 1 fatalClosedCessna 170A · Santa Maria, CAJul 19, 1966 · N1488D · Destroyed NTSB CHI66A0018Accident · 1 fatalClosedCessna 170A · Metropolis, ILAug 19, 1965 · N9501A · Destroyed