Skip to content

NTSB investigations: Cessna 172, AZ

37 cases on aircraft the registry lists as Cessna 172. 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 ('2072402')) 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 ('2072402'))
  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 ('2072402'))
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 WPR21LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Carefree, AZThe pilot’s exceedance of the airplane’s critical angle of attack while landing, which resulted in an aerodynamic stall.Oct 24, 2020 · N7029T · Substantial damage NTSB WPR12CA337Accident · Minor injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot’s improper flare and inadequate recovery from a bounced landing.Jul 28, 2012 · N8100B · Substantial damage NTSB WPR11LA211Accident · No injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe student pilot's inadequate directional control during the landing roll.Apr 27, 2011 · N4072F · Substantial damage NTSB LAX05LA286Accident · 1 fatalLimited investigationFinal reportCessna 172 · Yuma, AZthe pilot's failure to maintain an adequate airspeed on short final, which resulted in an inadvertent stall.Sep 2, 2005 · N5070A · Destroyed NTSB LAX01LA295Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Skull Valley, AZthe loss of engine power during takeoff for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing emergency landing.Sep 22, 2001 · N5792A · Substantial damage NTSB LAX98LA214Accident · No injuriesLimited investigationFinal reportCessna 172 · Flagstaff, AZOil system contamination with an unidentified metal substance that traveled through the oil system and blocked the number 4 main bearing and number 6 connecting rod bearing oil ports, resulting in oil starvation and failure of the engine. The source of the…Jun 27, 1998 · N7188A · Substantial damage NTSB LAX96LA209Accident · No injuriesLimited investigationFinal reportCessna 172 · Marana, AZthe pilot's improper flare and improper recovery from a bounced landing.May 4, 1996 · N8811B · Substantial damage NTSB LAX93FA190Accident · No injuriesField investigationFinal reportCessna 172 · Bullhead City, AZa fatigue failure of the crankshaft due to improper assembly of the engine during the major overhaul.Apr 26, 1993 · N6698A · Substantial damage NTSB LAX93LA150Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Gila Bend, AZThe failure of maintenance personnel to perform mandatory service bulletins during the annual inspection 20 flying hours prior to the accident which resulted in the carburetor's primary venturi becoming loose.Mar 14, 1993 · N4070F · Substantial damage NTSB LAX92LA268Accident · No injuriesLimited investigationFinal reportCessna 172 · Lake Havasu, AZThe failure of the pilot to adequately compensate for the existing wind conditions and to maintain directional control of the aircraft.Jun 30, 1992 · N6496E · Substantial damage NTSB LAX91LA268Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Payson, AZA premature liftoff, stall, and subsequent in flight collision with terrain. A factor related to the accident was the high density altitude.Jun 24, 1991 · N8382B · Substantial damage NTSB LAX90LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Show Low, AZThe pilot improperly used the flight controls and failed to maintain directional control.Jun 15, 1990 · N8512B · Substantial damage NTSB LAX90FA025Accident · 2 fatalField investigationFinal reportCessna 172 · Safford, AZThe pilot failed to maintain an airspeed above the aircraft's stall speed as he turned away from ascending terrain. The aircraft's inadequate performance resulting from improper grade of fuel and high density altitude and the pilot's lack of experience in…Nov 6, 1989 · N5624A · Substantial damage NTSB LAX89LA292Accident · No injuriesLimited investigationFinal reportCessna 172 · Bullhead City, AZFailure of the pilot to adequately perform inflight fuel consumption calculations to ensure the adequacy of the fuel supply for the flight's completion. Contributing to the accident was the failure of the pilot to consider the impact of the stronger than…Aug 31, 1989 · N6270E · Substantial damage NTSB LAX88LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Goodyear, AZDuring a cross country flt while cruising at 7500 ft MSL, the acft began to vibrate severely. The plt shut the engine down and landed without further incident. Inspection of the acft revealed that a section of one of the propeller blades had separated. The…Dec 28, 1987 · N4297F · Substantial damage NTSB LAX81DUJ47Accident · No injuriesClosedCessna 172 · Payson, AZMar 26, 1981 · N8870B · Substantial damage NTSB LAX81FUJ80Accident · Minor injuriesClosedCessna 172N · Green Valley, AZJul 5, 1980 · N4819D · Substantial damage NTSB LAX79DUJ97Accident · Serious injuriesClosedCessna 172 · Tortilla Flats, AZJul 28, 1979 · N5770A · Destroyed NTSB LAX77FUJ56Accident · Minor injuriesClosedCessna 172 · Yuma, AZJun 7, 1977 · N8798B · Substantial damage NTSB LAX77FA031Accident · 4 fatalClosedCessna 172 · Payson, AZMar 25, 1977 · N4181F · Destroyed NTSB LAX76AL075Accident · 1 fatalClosedCessna 172E · Kingman, AZMay 15, 1976 · N3658R · Destroyed NTSB LAX76AL053Accident · 4 fatalClosedCessna 172 · Prescott, AZFeb 13, 1976 · N84011 · Destroyed NTSB LAX76DUJ40Accident · No injuriesClosedCessna 172 · Ft.Grant, AZSep 13, 1975 · N9154B · Substantial damage NTSB LAX7LFUJ11Accident · Serious injuriesClosedCessna 172 · Payson, AZAug 16, 1975 · N921CR · Substantial damage NTSB LAX73AL064Accident · 3 fatalClosedCessna 172 · Cottonwood, AZJun 29, 1973 · N8291B · Destroyed NTSB LAX73FUJ66Accident · Serious injuriesClosedCessna 172E · Peoria, AZApr 3, 1973 · N3658R · Substantial damage NTSB LAX73DUJ27Accident · No injuriesClosedCessna 172 · Kingman, AZOct 6, 1972 · N7921B · Substantial damage NTSB LAX72FUJ29Accident · 1 fatalClosedCessna 172 · Stanfield, AZAug 22, 1971 · N8249B · Substantial damage NTSB LAX69D0219Accident · No injuriesClosedCessna 172 · Casa Grande, AZDec 1, 1968 · N8249B · Substantial damage NTSB LAX68D0398Accident · No injuriesClosedCessna 172 · Payson, AZApr 27, 1968 · N8627B · Substantial damage NTSB LAX68D0096Accident · No injuriesClosedCessna 172 · Holbrook, AZJul 15, 1967 · N6323E · Destroyed NTSB DEN67D0013Accident · No injuriesClosedCessna 172 · Sierra Vista, AZMay 11, 1966 · N9180Z · Substantial damage NTSB DEN66D0322Accident · No injuriesClosedCessna 172 · Elroy, AZApr 24, 1966 · N4170F · Substantial damage NTSB DEN66D0313Accident · No injuriesClosedCessna 172 · San Simon, AZFeb 8, 1966 · N5942A · Substantial damage NTSB UNK65X0282Accident · No injuriesClosedCessna 172 · Grand Canyon, AZOct 15, 1964 · N8118B · Substantial damage NTSB UNK64X2168Accident · No injuriesClosedCessna 172 · Page, AZJun 7, 1964 · N6221E · Substantial damage NTSB UNK64X1248Accident · No injuriesClosedCessna 172 · Parker, AZApr 10, 1964 · N3932F · Substantial damage