NTSB investigations: Cessna 172N, AZ
86 cases on aircraft the registry lists as Cessna 172N. 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.
Cases per year
| 1978 | 4 |
|---|---|
| 1979 | 4 |
| 1980 | 5 |
| 1981 | 6 |
| 1982 | 7 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1989 | 5 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 4 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 3 |
| 2007 | 2 |
| 2008 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('2072434'))
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 ('2072434'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR22LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Tuscon, AZThe loss of directional control during the landing roll, due to missing hardware which resulted in the separation of the nose landing gear torque links.NTSB WPR20LA115Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Sedona, AZThe pilot’s loss of pitch control while landing in crosswind conditions, which resulted in a collapsed nose gear and departure of the airplane from the runway.NTSB GAA19CA312Accident · No injuriesData collectionFinal reportCessna 172 · Nogalas, AZThe student pilot's failure to maintain adequate clearance from a parked fuel truck. Contributing to the accident were the student’s failure to follow company policy and the flight instructor’s delayed remedial action.NTSB WPR18LA262Accident · Serious injuriesLimited investigationFinal reportCessna 172 · St. Johns, AZThe pilot's inadequate preflight planning before takeoff in the high density altitude conditions, which resulted in the airplane being unable to maintain sufficient airspeed to continue to climb.NTSB WPR14LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Page, AZThe pilot’s improper landing flare in gusting wind conditions, his inadequate recovery from the subsequent bounced landing, and his decision to perform a go-around with insufficient airspeed to climb.NTSB WPR14CA116Accident · No injuriesData collectionFinal reportCessna 172 - N · Glendale, AZThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion and subsequent impact with a taxiway sign.NTSB WPR13CA152Accident · Minor injuriesData collectionFinal reportCessna 172N · Gila Bend, AZThe student pilot's failure to maintain airplane control during an attempted go-around.NTSB WPR12CA425Accident · No injuriesData collectionFinal reportCessna 172N · Eloy, AZThe pilot's improper flare, and his inadequate recovery from a bounced landing.NTSB LAX08CA155Accident · No injuriesData collectionFinal reportCessna 172N · Sells, AZThe pilot's inadequate recovery from a bounced landing and failure to maintain proper runway alignment.NTSB LAX07FA123Accident · 2 fatalField investigationFinal reportCessna 172N · Page, AZThe pilot's failure to maintain an adequate terrain clearance altitude, and, his failure to maintain an adequate airspeed while maneuvering to reverse course in a box canyon. Contributing to the accident were the rising terrain and the box canyon.NTSB SEA07CA074Accident · Minor injuriesData collectionFinal reportCessna 172N · Phoenix, AZThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and uncontrolled descent into terrain during landing. A contributing factor was the pilot's distracted attention due to the inaccurate flap indicator.NTSB LAX04LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Nogales, AZThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control.NTSB LAX04CA059Accident · No injuriesData collectionFinal reportCessna 172N · Winslow, AZthe pilot's misjudged landing flare, which resulted in a pilot induced porpoise oscillation and hard landing.NTSB LAX03LA152Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Payson, AZthe pilot's inadequate recovery from a bounced landing, failure to retract the flaps during an aborted landing attempt, failure to maintain an adequate airspeed, and failure to maintain directional control. A factor in the accident was the high density…NTSB LAX02FA259Accident · No injuriesField investigationFinal reportCessna 172N · Mesa, AZAn electrical fire of unknown origin centered near the circuit breaker/throttle area of the instrument panel.NTSB LAX02LA084Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot of the landing airplane failed to maintain directional control resulting in the on-ground collission.NTSB LAX01LA115Accident · No injuriesLimited investigationFinal reportCessna 172N · Show Low, AZThe pilot's failure to maintain directional control resulting in an encounter with terrain and a nose over.NTSB LAX01LA048Accident · No injuriesLimited investigationFinal reportCessna 172N · Marana, AZThe student pilot's improper flare and improper recovery from a bounced landing. A factor in the accident was the morning sun, which momentarily restricted the pilot's vision.NTSB LAX00LA305Accident · No injuriesLimited investigationFinal reportCessna 172 · Flagstaff, AZThe pilot's improper go-around procedure and his failure to maintain directional control on landing.NTSB LAX00LA021Accident · No injuriesLimited investigationFinal reportCessna 172N · Deer Valley, AZFuel exhaustion due to the pilot's inadequate preflight verification of the fuel quantity, and, once he became aware of the critical fuel state, his decision to over-fly two alternate airports in order to continue to his destination.NTSB LAX99LA258Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZthe student pilot's premature retraction of the flaps during an aborted landing and his failure to obtain/maintain adequate flying airspeed, which resulted in a stall/mush condition and the airplane settling back onto the ground. The student pilot's failure…NTSB LAX99LA131Accident · No injuriesLimited investigationFinal reportCessna 172N · Scottsdale, AZFailure of the student pilot to maintain directional control of the aircraft while retracting the flaps during a touch-and-go.NTSB LAX99LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe failure of the flight instructor to provide adequate supervision of the student pilot during a simulated emergency landing.NTSB LAX98LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZFuel exhaustion due to the pilot's inadequate preflight planning and in-flight monitoring of the aircraft's fuel consumption.NTSB LAX98LA028Accident · No injuriesLimited investigationFinal reportCessna 172N · Payson, AZThe pilot's selection of a downwind direction to land and his failure to compensate for the quartering tailwind condition.NTSB LAX97LA295Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe pilot's inadequate recovery from a bounced landing.NTSB LAX97LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZthe pilot's encounter with crosswind gusts beyond the performance capability of the aircraft. A lack of crosswind limit information published in the Cessna 172N Pilot's Operating Handbook for landing and taxiing operations is a factor in the accident.NTSB LAX97LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZthe student pilot's inadequate compensation for the crosswind condition, and his failure to maintain proper runway alignment.NTSB LAX96LA227Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe failure of the pilot to adequately compensate for gusty crosswind conditions, which resulted in loss of aircraft control.NTSB LAX96LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Winslow, AZthe student pilot's use of an excessive airspeed during the landing approach, which resulted in a hard landing, a porpoise, and a collapse of the nose landing gear.NTSB LAX96LA006Accident · No injuriesLimited investigationFinal reportCessna 172N · Tucson, AZthe pilot's inadequate compensation for the existing tailwind conditions, improper flare, and failure to maintain directional control.NTSB LAX95LA155Accident · No injuriesLimited investigationFinal reportCessna 172N · Phoenix, AZThe use of excessive break-away thrust by the Boeing 737 crew. A factor related to the accident was: improper planning/decision by the Cessna 172 pilot by accepting a clearance to taxi behind the Boeing 737 without assurance that the Boeing 737 crew would not…NTSB LAX95LA124Accident · No injuriesLimited investigationFinal reportCessna 172 · Prescott, AZfailure of the pilot to maintain directional control.NTSB LAX94LA334Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe student pilot's failure to maintain directional control by his improper use of the flight controls. Factors related to this accident were the pilot's lack of total experience and the crosswind.NTSB LAX94LA231Accident · 1 fatalLimited investigationFinal reportCessna 172N · Roosevelt, AZthe pilot's selection of an inadequate terrain clearance altitude while maneuvering over a lake. A factor in the accident was the calm glassy water conditions which may have affected the pilot's perception of his actual height above the water.NTSB FTW94LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Page, AZThe total loss of engine power for undetermined reason. A factor was the lack of suitable terrain at the pilot's disposal.NTSB LAX94LA215Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe cfi's improper level off during landing. The tailwind was a factor.NTSB LAX94LA154Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe student pilot's delayed flare and failure to maintain directional control of the aircraft, and the flight instructor's inadequate supervision of the flight.NTSB LAX94FA007Accident · 1 fatalField investigationFinal reportCessna 172N · Sedona, AZthe pilot's decision to continue VFR at an improper altitude into mountainous terrain at night and the inadvertent encounter with clouds along the route. Self-induced pressure due to a low fuel state contributed to the accident.NTSB LAX93LA225Accident · 1 fatalLimited investigationFinal reportCessna 172N · Page, AZthe pilot's selection of an inadequate cruise altitude. A factor in the accident was the high winds and turbulence in the vicinity of the cliffs.NTSB LAX93LA176Accident · No injuriesLimited investigationFinal reportCessna 172N · Flagstaff, AZThe pilot's poor aircraft handling techniques, his failure to correctly configure the carburetor heat control during the go around, and, his failure to maintain an adequate airspeed which resulted in an inadvertent stall mush condition. Factors in the…NTSB LAX93LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe pilots inadequate compensation for the existing wind conditions and his delay in executing a go around. A factor in the accident was the pilot's lack of total experience.NTSB LAX92LA380Accident · No injuriesLimited investigationFinal reportCessna 172N · Stanfield, AZThe cfi's poor in-flight decision to demonstrate the simulated engine out emergency landing at too low an altitude and misjudging the altitude during the circling maneuver.NTSB LAX92LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Prescott, AZThe other airplane's flight instructor's poor supervision of the flight; the other airplane's flight instructor's and dual student's misidentification of the airplane the student pilot was following and the other airplane's flight instructor's and dual…NTSB LAX92LA089Accident · No injuriesLimited investigationFinal reportCessna 172N · Show Low, AZThe failure of the carburetor heat box attach straps which allowed the carburetor heat box to separate from the exhaust system heat muff and rendered the carburetor heat system inoperative. The engine then lost power due to carburetor ice.NTSB LAX92LA071Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZThe failure of the pilot to maintain an adequate visual lookout while taxiing the aircraft.NTSB LAX91LA404Accident · No injuriesLimited investigationFinal reportCessna 172 · Cottonwood, AZThe pilot-in-command's delay in raising the flaps and the subsequent inadvertent stall/mush.NTSB LAX91LA336Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe pilot's misjudged landing flare and his failure to maintain a proper go-around course over the runway.NTSB LAX91LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Tucson, AZBoth pilots used poor visual lookout procedures.NTSB LAX90LA176Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe failure of the student pilot to maintain an appropriate airspeed during the attempted go-around.