Skip to content

NTSB investigations: Cessna 172P, AZ

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

19822026

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 ('2072436')) 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 ('2072436'))
  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 ('2072436'))
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 WPR24LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Goodyear, AZBearing degradation that increased clearances between the bearing and crankshaft journal surfaces, resulting in fatigue cracks and the subsequent failure of the No. 3 connecting rod and a total loss of engine power. Contributing to the accident was the…Feb 10, 2024 · N52436 · Substantial damage NTSB WPR21LA186Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Tucson, AZThe student pilot’s improper pitch control and landing flare, which resulted in a hard bounce and subsequent porpoised landing.May 8, 2021 · N54140 · Substantial damage NTSB WPR20LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Tucson, AZThe pilot improper fuel management, which resulted in running the left fuel tank empty and a subsequent total loss of engine power due to fuel starvation.May 14, 2020 · N63931 · Substantial damage NTSB GAA18CA253Accident · No injuriesData collectionFinal reportCessna 172 · Glendale, AZThe student pilot’s failure to maintain runway alignment during takeoff, which resulted in an aborted takeoff and runway excursion.May 4, 2018 · N99141 · Substantial damage NTSB WPR13LA038Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Maricopa, AZThe pilot’s failure to maintain proper pitch control during the initial climb, which resulted in a stall, loss of airplane control, and collision with terrain.Nov 11, 2012 · N65835 · Substantial damage NTSB WPR09CA053Accident · No injuriesData collectionFinal reportCessna 172 · Sedona, AZThe pilot's improper flare and inadequate recovery from a bounced landing.Nov 29, 2008 · N98774 · Substantial damage NTSB LAX07CA007Accident · No injuriesData collectionFinal reportCessna 172P · Glendale, AZthe student's inadequate compensation for the gusting crosswind and inadequate flare that resulted in a hard landing. The certified flight instructor's inadequate supervision of the flight is also causal.Oct 6, 2006 · N97811 · Substantial damage NTSB LAX06CA122Accident · No injuriesData collectionFinal reportCessna 172P · Sedona, AZThe pilot's failure to maintain an adequate clearance from obstructions and diverted attention while taxiing.Feb 25, 2006 · N64423 · Substantial damage NTSB LAX04LA053Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fountain Hills, AZThe flight instructor's delayed remedial action and inadequate altitude during a go-around following a simulated forced landing, which resulted in an in-flight collision with terrain.Nov 24, 2003 · N97056 · Substantial damage NTSB LAX02LA241Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesa, AZthe pilot of the other airplane'ss use of an excessive taxi speed and too close of a spacing interval to the Cessna 152, which resulted in an on-ground collision when the Cessna 152 abruptly stopped.Jul 25, 2002 · N97056 · 2 aircraft · Minor damage NTSB LAX00LA031Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZThe pilot's misjudged landing flare and failure to maintain an adequate airspeed margin, which resulted in a stall/mush and hard landing.Nov 2, 1999 · N98909 · Substantial damage NTSB LAX99LA204Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesa, AZThe failure of the tower (local) air traffic controller to issue a landing sequence to the climbing, high wing Cessna 172 aircraft, and, the controller's failure to maintain visual separation between the two aircraft on downwind leg.May 30, 1999 · N66018 · 2 aircraft · Substantial damage NTSB LAX99FA036Accident · 2 fatalField investigationFinal reportCessna 172P · Scottsdale, AZthe failure of the solo student pilot in the other aircraft to acquire and maintain separation from this aircraft, which was departing the airport traffic pattern and had been issued as traffic by the local controller. Also causal was the failure of the pilot…Nov 21, 1998 · N99064 · 2 aircraft · Destroyed NTSB LAX96LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Sedona, AZthe pilot misjudged the flare.Apr 6, 1996 · N62038 · Substantial damage NTSB LAX94LA321Accident · No injuriesLimited investigationFinal reportCessna 172P · Scottsdale, AZthe pilot's misjudging the flare altitude and failing to maintain adequate airspeed resulting in an inadvertent stall and hard landing. The pilot's lack of total time in the airplane is a factor in this accident.Aug 14, 1994 · N98909 · Substantial damage NTSB LAX93LA368Accident · No injuriesLimited investigationFinal reportCessna 172P · Phoenix, AZThe pilot's misjudging the landing flare. A physical problem may have contributed.Sep 24, 1993 · N98909 · Substantial damage NTSB LAX92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Williams, AZThe pilot's failure to maintain visual lookout.Nov 4, 1991 · N5337K · Destroyed NTSB LAX91LA083Accident · No injuriesLimited investigationFinal reportCessna 172P · Sedona, AZThe failure of the pilot to maintain directional control of the aircraft.Jan 27, 1991 · N54863 · Substantial damage NTSB LAX88FA307Accident · 4 fatalField investigationFinal reportCessna 172 · Grand Canyon, AZThe pilot failed to maintain control of the aircraft during nigh visual meteorological conditions. Contributing to this accident was the pilot's lack of recent experience at nigh and the lack of outside visual references due to darkness.Sep 4, 1988 · N54814 · Destroyed NTSB LAX85LA292Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Glendale, AZWhen the plt realized he was low during final apch to a landing, he erroneously decided not to use full flaps instead of adding power, vref was high and the landing was 3/4 of the way down the 2400 ft rwy. Believing he had sufficient room to takeoff again,…Jun 22, 1985 · N52789 · Substantial damage NTSB LAX85LA166Accident · No injuriesLimited investigationFinal reportCessna 172 · Tucson, AZThe plt was commencing his 1st solo x-country flt. At lift-off, the acft entered a left bank of about 45 degs. The student plt reduced power & the acft touched down hard on the dirt beside the rwy & was damaged. The plt believed that he may have encountered…Mar 1, 1985 · N62344 · Substantial damage NTSB LAX83LA457Accident · No injuriesLimited investigationFinal reportCessna 172P · Glendale, AZReportedly, the plt landed long. He then applied braking action & 1 wheel locked. At that point, the acft was still going too fast to stop on the remaining rwy & there was insufficient rwy to go around. The plt steered the acft off the end of the rwy & it…Sep 25, 1983 · N55264 · Substantial damage NTSB LAX83LA418Accident · No injuriesLimited investigationFinal reportCessna 172P · Glendale, AZThe student & his instructor plt had made 2 takeoffs & landings, then the instructor deplaned & the student prepared to takeoff on a solo flt. According to the student, he made the pretakeoff checks, which included setting the trim. As the acft accelerated…Aug 28, 1983 · N62038 · Substantial damage NTSB LAX83LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · Dateland, AZDuring takeoff, the pilot was using the right side of a private strip to avoid an area of mud. At lift-off speed, the right wing tip struck a power pole near the right side of the runway and veered toward an irrigation ditch. The pilot was able to clear over…Dec 6, 1982 · N55299 · Substantial damage