Cessna 172M
NTSB investigations · 1,699
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('2072418')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2072418')
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 NYC07CA019Accident · No injuriesData collectionFinal reportCessna 172M · Wakefield, VAThe student pilot's failure to maintain control during the landing. A factor to the accident was the wind gusts.NTSB SEA07FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Escalante, UTThe pilot's failure to maintain aircraft control. Contributing factors were the pilot's lack of experience of flying on instruments on a dark night and in rainy weather.NTSB SEA06CA181Accident · No injuriesData collectionFinal reportCessna 172M · Moab, UTThe pilot's failure to obtain current NOTAMS which resulted in an on-ground collision with a construction berm while landing.NTSB ANC06CA127Accident · No injuriesData collectionFinal reportCessna 172 · Healy, AKThe pilot's failure to maintain adequate altitude/clearance while maneuvering, which resulted in an in-flight collision with terrain. Factors associated with the accident were rising terrain, and the pilot's low altitude flight.NTSB LAX06CA253Accident · Serious injuriesData collectionFinal reportCessna 172M · Gasquet, CAthe pilot's selection of a runway favoring tailwind conditions, his delayed decision to go around, and his failure to attain and maintain an adequate airspeed during the aborted landing. Contributing factors were the tailwind and wind shear conditions…NTSB LAX06CA252Accident · No injuriesData collectionFinal reportCessna 172M · San Andreas, CAthe student pilot's improper soft-field takeoff technique and failure to obtain and maintain an adequate airspeed, which resulted in a stall mush. The certificated flight instructor's inadequate supervision of the maneuver was also causal.NTSB ATL06CA116Accident · No injuriesData collectionFinal reportCessna 172M · Augusta, GAThe pilot's improper flare on landing with excessive altitude resulting in a hard landing.NTSB CHI06CA227Accident · No injuriesData collectionFinal reportCessna 172M · Cahokia, ILThe pilot's inadequate flare. A factor was the night light conditions.NTSB SEA06CA103Accident · No injuriesData collectionFinal reportCessna 172M · Hamilton, MTThe pilot's inadequate compensation for the wind conditions during the landing roll which resulted in his failure to maintain directional control. Factors included variable winds and gusty crosswinds.NTSB ANC06LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Tuluksak, AKThe pilot's inadvertent stall/mush during takeoff-initial climb, which resulted in an in-flight collision with trees and terrain. Factors associated with the accident were the pilot's excessive loading of the airplane, his inadequate preflight planning, and a…NTSB ATL06CA065Accident · No injuriesData collectionFinal reportCessna 172 M · Griffin, GAThe pilot's failure to achieve the proper touchdown point, which resulted in an overrun of the runway, collision with an embankment, and subsequent nose over.NTSB MIA06CA083Accident · No injuriesData collectionFinal reportCessna 172M · Vero Beach, FLThe pilot's failure to maintain directional control while executing a go-around in gusty conditions which resulted in the airplane veering off the runway, colliding with a ditch and nosing over.NTSB ATL06CA057Accident · No injuriesData collectionFinal reportCessna 172M · Newnan, GAThe student pilot's failure to maintain directional control on the landing roll out, resulting in the airplane veering off the right side of the runway and colliding with an airport runway sign.NTSB SEA06CA082Accident · No injuriesData collectionFinal reportCessna 172 · Aurora, ORThe student pilot's misjudgment of the landing flare resulting in a hard landing. A related factor was the crosswind.NTSB LAX06CA117Accident · No injuriesData collectionFinal reportCessna 172M · Prescott, AZthe pilot's inadequate compensation for the crosswind conditions and his failure to maintain directional control.NTSB LAX06CA115Accident · No injuriesData collectionFinal reportCessna 172M · Murrieta, CAa partial loss of engine power resulting from the student pilot's mismanagement of the mixture control.NTSB DEN06CA033Accident · No injuriesData collectionFinal reportCessna 172M · Denver, COthe pilot's failure to align the airplane's nose into the direction of the wind while performing the pre-takeoff checklist. A contributing factor was the gusty wind conditions.NTSB CHI06CA004Accident · Minor injuriesData collectionFinal reportCessna 172M · Lake Elmo, MNThe pilot's inadequate recovery from a bounced landing, which resulted in an overload failure of the nose landing gear. Contributing to the accident was a loss of engine power due to fuel exhaustion as a result of inadequate preflight planning by the pilot.NTSB ANC05CA147Accident · No injuriesData collectionFinal reportCessna 172 · Anchorage, AKThe pilot's misjudgment of distance/speed during landing, which resulted in an overrun, a loss of directional control, and a nose over during the landing roll.NTSB DFW05CA237Accident · Minor injuriesData collectionFinal reportCessna 172M · Amarillo, TXThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall. Contributing factors were the reported loss of engine power for undetermined reasons and the high density altitude.NTSB MIA05LA155Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Ocean Springs, MSThe pilot's mismanagement of available fuel and continued operation with the fuel selector set to the left tank position, which resulted in fuel starvation and subsequent loss of engine power.NTSB SEA05CA159Accident · No injuriesData collectionFinal reportCessna 172M · Hoquiam, WAThe pilot's failure to maintain clearance from a fence. The fence was a factor.NTSB DFW05CA203Accident · No injuriesData collectionFinal reportCessna 172M · El Dorado, ARThe student pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB IAD05LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Marysville, OHThe pilot's failure to maintain directional control during landing.NTSB SEA05FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Yamhill, ORThe flight instructor's excessive climb and failure to maintain adequate airspeed during an attempted go-around, which resulted in an inadvertent stall and subsequent collision with the ground. Contributing factors were the flight instructor's improper…NTSB CHI05CA152Accident · No injuriesData collectionFinal reportCessna 172M · Rochester, MNThe pilot flared improperly and failed to recover from a bounced landing.NTSB LAX05LA199Accident · No injuriesLimited investigationFinal reportCessna 172M · Carlsbad, CAthe other pilot's inadequate visual lookout and failure to maintain separation while taxiing.NTSB CHI05CA123Accident · No injuriesData collectionFinal reportCessna C-172M · Madison, WIThe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control. Factors were the gusty winds and the soft ground.NTSB LAX05LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Tucson, AZThe student pilot's improper flare that induced a porpoise, which resulted in the overload failure of the nose wheel assembly.NTSB IAD05LA060Accident · No injuriesLimited investigationFinal reportCessna 172 · Pikeville, KYThe pilot's improper flare, which resulted in a hard landing.NTSB DFW05CA093Accident · Minor injuriesData collectionFinal reportCessna 172M · Spring, TXThe pilot's inadequate use of carburetor heat, which resulted in carburetor ice and the loss of engine power. A contributing factor was conditions conducive to carburetor icing.NTSB LAX05LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · Desert Center, CAThe instructor's improper decision to land on the dry lakebed without knowing the condition of the landing surface. A factor in the accident was the soft sand surface of the lake bed.NTSB MIA05LA046Accident · 1 fatalLimited investigationFinal reportCessna 172M · Orlando, FLThe failure of the CFI to initiate a precautionary landing after noticing zero oil pressure with corresponding oil temperature increase, resulting in total loss of engine power due to oil exhaustion. A contributing factor in the accident was the failure of…NTSB NYC05LA002Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Harrison, OHThe Cessna 152 pilot's improper traffic pattern procedure and improper radio communication, which resulted in a mid-air collision with a Cessna 172. A factor in the accident was both pilots' failure to maintain an adequate visual lookout.NTSB NYC05CA003Accident · No injuriesData collectionFinal reportCessna 172M · Eliot, METhe pilot's inadequate in-flight planning decision, which resulted a loss of engine power due to fuel exhaustion.NTSB DEN04LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Provo, UTthe pilot's premature liftoff which resulted in failure to attain airspeed which resulted in a stall.NTSB CHI04LA283Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Houstonia, MOThe fatigue failure of the piston end of the connecting rod and the pilot's failure to maintain aircraft control during the forced landing.NTSB NYC04LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Medina, OHThe partial loss of engine power due to inadequate maintenance and by failure to comply with service instruction for low engine compression.NTSB IAD04LA036Accident · 1 fatalLimited investigationFinal reportCessna 172M · Brownville Junc, METhe pilot's continued visual flight into instrument meteorological conditions, which resulted in the airplane's controlled flight into rising terrain. Factors included the instrument meteorological conditions and the rising terrain.NTSB CHI04CA209Accident · Minor injuriesData collectionFinal reportCessna 172M · Sublette, KSThe student pilot's inadequate compensation for the crosswind condition, and her failure to maintain aircraft control during landing. Factors contributing to the accident included the student pilot's unsuccessful recovery from the bounced landings and the…NTSB NYC04FA171Accident · 1 fatalField investigationFinal reportCessna 172M · Brookville, OHThe student pilot's control interference while the flight instructor was maneuvering to avoid a tree, which resulted in a failure to maintain airspeed and a stall/mush.NTSB ANC04IA078Incident · No injuriesIncident investigationFinal reportCessna 172M · Aniak, AKThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB ATL04LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Winston Salem, NCThe pilot's failure to maintain clearance from the fence post, while taxing which resulted in a collision.NTSB FTW04LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Levelland, TXThe student pilot's failure to maintain directional control and his inadequate compensation for the winds.NTSB SEA04LA096Accident · No injuriesLimited investigationFinal reportCessna 172M · Vernonia, ORThe instructor pilot's misjudgment of speed and distance and his failure to execute a go-around resulting in an overrun of the runway.NTSB CHI04LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · New Munster, WIVisual lookout not maintained by the pilots of both airplanes.NTSB SEA04LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Eltopia, WARemedial action delayed during the takeoff roll. Factors include rough/uneven terrain.NTSB NYC04CA072Accident · No injuriesData collectionFinal reportCessna 172 · West Dover, VTThe pilot's failure to maintain aircraft control, and his failure to perform a go-around. Factors were wind gusts and the pilot's lack of flight experience.NTSB NYC04CA064Accident · No injuriesData collectionFinal reportCessna 172M · Cumberland, MDThe pilot's inadequate compensation for the crosswind while landing. A factor was the crosswind.NTSB CHI04LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Jeffersonville, INThe pilot selecting a closed runway for landing and the collapse of the nose landing gear. Factors were the pilot's failure to obtain NOTAM information and the snowbank across the closed runway.
Back to Cessna 172M