Skip to content

NTSB investigations: Cessna 170B, AZ

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

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."eventStateOrRegion" = 'AZ' 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

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\" = 'AZ' 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" = 'AZ' 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

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 WPR23LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Queen Creek, AZThe airplane’s encounter with a dust devil after landing, which resulted in a loss of directional control.Apr 29, 2023 · N2207D · Substantial damage NTSB GAA19CA445Accident · No injuriesData collectionFinal reportCessna 170 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the right wing striking the ground.Jul 19, 2019 · N3276A · Substantial damage NTSB GAA18CA339Accident · No injuriesData collectionFinal reportCessna 170 · Benson, AZThe pilot’s failure to maintain directional control during landing.Jun 10, 2018 · N170W · Substantial damage NTSB WPR10LA312Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Parker, AZThe pilot's failure to maintain directional control while landing with a crosswind.Jun 23, 2010 · N432PB · Substantial damage NTSB LAX05CA233Accident · Minor injuriesData collectionFinal reportCessna 170B · Prescott, AZthe pilot's misjudged flare, and excessive use of the elevator control, which resulted in a failure to maintain adequate airspeed and a stall/mush.Jul 14, 2005 · N2958D · Substantial damage NTSB LAX03LA042Accident · No injuriesLimited investigationFinal reportCessna 170B · Mobile, AZthe pilot's improper compensation for the crosswind conditions at touchdown and failure to maintain proper alignment of the tail wheel equipped airplane during landing, which resulted in a ground loop. The crosswind was a contributory factor.Nov 28, 2002 · N4465B · Substantial damage NTSB LAX02LA245Accident · No injuriesLimited investigationFinal reportCessna 170B · St. Johns, AZthe pilot's selection of the wrong runway for the existing crosswind condition and his subsequent inadequate compensation for the winds, which led to a failure to maintain directional control and a ground loop.Aug 1, 2002 · N2233D · Substantial damage NTSB LAX02LA168Accident · No injuriesLimited investigationFinal reportCessna 170B · Show Low, AZThe pilot's improper recovery from a bounced landing resulted in a loss of aircraft control. A factor was a sudden wind shift on final approach.May 19, 2002 · N4338B · Substantial damage NTSB LAX01LA209Accident · No injuriesLimited investigationFinal reportCessna 170B · Payson, AZThe pilot's failure to maintain directional control and improper corrective action while landing in a quartering tailwind condition. A contributing factor was his lack of experience in the type of operation.Jun 15, 2001 · N4338B · Substantial damage NTSB LAX94LA031Accident · No injuriesLimited investigationFinal reportCessna 170B · Prescott, AZThe pilot's loss of directional control due to his improper bounced landing recovery technique and the improper use of the rudder controls. A factor in the accident was the pilot's lack of total experience in conventional landing gear aircraft.Oct 30, 1993 · N2451D · Substantial damage NTSB LAX93LA001Accident · No injuriesLimited investigationFinal reportCessna 170B · Prescott, AZFailure of the pilot to maintain directional control and improper use of the flight controls and brakes.Oct 2, 1992 · N2515D · Substantial damage NTSB LAX92LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Lake Havasu, AZThe pilot's; 1) inadequate preflight preparation, 2) failure to obtain current NOTAM information, and 3) failure to obtain a current altimeter setting. Factors in the accident were the dark night condition and the pilot election not to use the landing light.Nov 12, 1991 · N8172A · Substantial damage NTSB LAX89FA120Accident · 4 fatalField investigationFinal reportCessna 170B · Casa Grande, AZThe pilot in command's performance of aerobatic maneuvers, while flying in formation, and his failure to maintain proper clearance.Mar 5, 1989 · N2766C · 2 aircraft · Destroyed NTSB LAX81DUJ65Accident · Minor injuriesClosedCessna 170B · Shivwits, AZMay 15, 1981 · N8334A · Substantial damage NTSB LAX79DUK14Accident · No injuriesClosedCessna 170B · Phoenix, AZAug 16, 1979 · N4664C · Substantial damage NTSB LAX79FUJ28Accident · No injuriesClosedCessna 170B · Grnd Cyn Cvrns, AZDec 13, 1978 · N1956C · Substantial damage NTSB LAX77DUJ40Accident · No injuriesClosedCessna 170 · Steamboat Cyn, AZMar 28, 1977 · N8334A · Substantial damage NTSB LAX76DUJ82Accident · No injuriesClosedCessna 170 · Carefree, AZJun 6, 1976 · N3482D · Substantial damage NTSB LAX75DUJ89Accident · Minor injuriesClosedCessna 170B · St.Johns, AZJun 3, 1975 · N2593D · Destroyed NTSB LAX75FUJ40Accident · No injuriesClosedCessna 170B · Casa Grande, AZOct 16, 1974 · N4509C · Substantial damage NTSB LAX73FUJ46Accident · No injuriesClosedCessna 170B · Willcox, AZJan 17, 1973 · N1775D · Substantial damage NTSB LAX71AL056Accident · 2 fatalClosedCessna 170B · Sprngervlle, AZFeb 15, 1971 · N8229A · Destroyed NTSB LAX70DUJ10Accident · No injuriesClosedCessna 170B · Phoenix, AZFeb 17, 1970 · N3065A · Substantial damage NTSB LAX67A0117Accident · 1 fatalClosedCessna 170 · Roosevelt, AZJun 19, 1966 · N9724A · Destroyed NTSB DEN66D0338Accident · No injuriesClosedCessna 170B · Phoenix, AZMay 8, 1966 · N8194A · Substantial damage NTSB DEN66D0193Accident · No injuriesClosedCessna 170B · Carefree, AZDec 31, 1965 · N4500C · Substantial damage NTSB DEN66D0134Accident · No injuriesClosedCessna 170B · Phoenix, AZSep 21, 1965 · N2917D · Substantial damage NTSB DEN65D0093Accident · Minor injuriesClosedCessna 170B · Wickenburg, AZMay 8, 1965 · N1932C · Substantial damage NTSB UNK65X1304Accident · No injuriesClosedCessna 170B · Gila Bend, AZJan 17, 1965 · N2255D · Substantial damage NTSB UNK64X1187Accident · No injuriesClosedCessna 170 · Carefree, AZApr 5, 1964 · N1956C · Substantial damage NTSB UNK64X0406Accident · No injuriesClosedCessna 170B · Flagstaff, AZJan 30, 1964 · N3514C · Substantial damage