NTSB investigations: Cessna 172K, AZ

13 cases on aircraft the registry lists as Cessna 172K. 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

19682026

NTSB investigations: Cessna 172K, AZ per year, 1968–2026: 13 cases
1968	1
1970	1
1971	1
1973	1
1974	1
1977	1
1981	1
1982	1
1991	1
1994	1
2006	1
2014	1
2023	1

Where

Open the map

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 ('2072430')) 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 ('2072430'))
  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 ('2072430'))
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 WPR23LA241Accident · No injuriesClass 3 · LimitedFinal reportCessna 172K · Marana, AZA total loss of engine power due to fuel exhaustion.Jun 23, 2023 · N84385 · Substantial damage NTSB WPR14FA302Accident · 2 fatalField investigationFinal reportCessna 172K · Littlefield, AZThe pilot's failure to maintain airplane control when the airplane encountered high gusting wind while conducting low altitude flight in a narrow canyon, which resulted in an inflight collision with terrain.Jul 21, 2014 · N84754 · Destroyed NTSB LAX06CA136Accident · No injuriesData collectionFinal reportCessna 172 · Wickenburg, AZthe pilot's failure to maintain directional control.Apr 6, 2006 · N84034 · Substantial damage NTSB LAX95FA037Accident · 3 fatalField investigationFinal reportCessna 172K · Springerville, AZthe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall/spin. The pilot's diverted attention and overconfidence in the aircraft's ability to fly slow were factors in this accident.Nov 15, 1994 · N7178G · Destroyed NTSB LAX91FA386Accident · Serious injuriesField investigationFinal reportCessna 172K · Bullhead City, AZ1) A short circuit, 2) electrical overload which ignited the cabin interior, 3) inadequate electrical circuit protection, and 4) insufficient electrical system design standards.Sep 8, 1991 · N7031G · Destroyed NTSB LAX82FA167Accident · 2 fatalField investigationFinal reportCessna 172 · Morman Lake, AZThe acft departed winslow, AZ on a flt to long beach, CA with an en route stop scheduled for prescot, AZ. Before departing winslow, the plt was warned by another plt that he had encountered extreme turbulence in the vicinity of mormon mtn. The plt and pax's…May 10, 1982 · N78810 · Destroyed NTSB LAX81DUJ53Accident · No injuriesClosedCessna 172 · Phoenix, AZApr 21, 1981 · N7296G · Substantial damage NTSB LAX77DUJ58Accident · No injuriesClosedCessna 172 · Lukachukai, AZMay 28, 1977 · N7165G · Substantial damage NTSB LAX75DUJ39Accident · Minor injuriesClosedCessna 172K · Snowflake, AZOct 31, 1974 · N78469 · Destroyed NTSB LAX73DUJ73Accident · No injuriesClosedCessna 172 · Scottsdale, AZApr 24, 1973 · N79149 · Substantial damage NTSB LAX71FUJ88Accident · No injuriesClosedCessna 172 · Carefree, AZMay 3, 1971 · N84518 · Substantial damage NTSB LAX70AL055Accident · 1 fatalClosedCessna 172 · Douglas, AZMar 6, 1970 · N79400 · Destroyed NTSB LAX69D0230Accident · No injuriesClosedCessna 172 · Peoria, AZDec 11, 1968 · N46448 · Substantial damage