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 LAX91LA296Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Minden, NVThe flight instructor's inadequate supervision of the student pilot during a simulated emergency.NTSB NYC91LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Millville, OHThe pilot's improper in-flight planning/decision after becoming lost, resulting in engine fuel exhaustion. Factors related to the accident were: the pilot's lack of familiarity with the geographic area, and his lack of experience in this type of operation.NTSB BFO91LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Beckley, WVThe pilot's failure to attain adequate flying speed.NTSB DEN91LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Keenesburg, COThe pilot's misjudging the approach, and disregard of wind conditions. Factors were: a tailwind condition and the pilot's anxiety.NTSB SEA91LA141Accident · No injuriesLimited investigationFinal reportCessna 172-M · Salem, ORThe pilot's poor in-flight decision and his failure to select a proper touchdown point. Factors include a wet runway, soft terrain and high vegetation.NTSB SEA91LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Vancouver, WAA hard landing by the pilot due to improper bounced landing recovery.NTSB ATL91LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Knighdale, NCFailure of the pilot to attain the proper touch down point on the runway and/or perform a go-around.NTSB LAX91LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Crescent City, CAThe failure of the pilot to employ proper flight control positioning to maintain control of the airplane during taxi.NTSB LAX91LA244Accident · No injuriesLimited investigationFinal reportCessna 172M · Willits, CAThat the pilot misjudged the flare and failed to properly recover from a bounced landing. Contributing to this accident was entering into an inadvertent porpoise.NTSB CHI91LA169Accident · No injuriesLimited investigationFinal reportCessna 172M · Cadillac, MIThe pilot-in-command's maintaining excessive airspeed through the landing touchdown which resulted in overrunning the runway.NTSB MIA91LA149Accident · 1 fatalLimited investigationFinal reportCessna 172M · Missing (Atlantic Ocean)The lose of engine power for undetermined reasons which resulted in a forced landing and ditching in the atlantic ocean.NTSB DEN91FA071Accident · 1 fatalField investigationFinal reportCessna 172M · Wray, COThe pilot intentionally buzzing and failure to maintain proper altitude.NTSB LAX91LA208Accident · No injuriesLimited investigationFinal reportCessna C172M · Coalinga, CAThe pilot's encounter with a dust devil which resulted in his loss of control during landing rollout.NTSB NYC91LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Bloomvale, NYThe pilot's delay in aborting the takeoff.NTSB FTW91FA060Accident · 2 fatalField investigationFinal reportCessna 172M · Flippin, ARThe pilot's attempted VFR flight in instrument meteorological conditions and his failure to maintain altitude.NTSB SEA91LA082Accident · No injuriesLimited investigationFinal reportCessna 172M · Ogden, UTThe pilot's poorly planned approached for landing. Factors to the accident were: an excessive airspeed, and the inadequacy of the pilot's recovery from a bounced landing.NTSB CHI91LA117Accident · No injuriesLimited investigationFinal reportCessna 172 · Yankton, SDFailure of the pilot to maintain directional control of the aircraft during landing. The adverse wind condition and the pilot's lack of total experience were related factors.NTSB NYC91LA091Accident · No injuriesLimited investigationFinal reportCessna 172M · Leroy, NYThe hard landing made by the pilot. Factors relating to the accident were the decision of the pilot to land on the runway despite the runway lighting system being partially inoperative, and the lack of experience of the pilot at night.NTSB NYC91LA074Accident · No injuriesLimited investigationFinal reportCessna 172M · Easton, PAThe pilot's improperly executed approach, resulting in a landing with excessive airspeed.NTSB NYC91LA070Accident · No injuriesLimited investigationFinal reportCessna 172M · Nashua, NHFuel system contamination by other personnel which resulted in an inflight engine failure and a subsequent forced landing in unsuitable terrain.NTSB CHI91LA057Accident · No injuriesLimited investigationFinal reportCessna 172M · Austin, MNThe pilot-in-command (student)'s failure to properly evaluate and compensate for gusty wind condiitons and to maintain directional of the aircraft during initial climb. Contributing was the student pilot's lack of total experience and wind gusts.NTSB LAX91LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed during takeoff and his incorrect use of full flaps. Factors related to the high density altitude condition and to the pilot's abrupt airplane handling techniques.NTSB NYC91FA034Accident · 2 fatalField investigationFinal reportCessna 172M · Perham, METhe pilot initiating flight into known icing conditions which resulted in an accumulation of airframe ice and a failure to maintain airspeed. The contributing factor was the existing icing conditions.NTSB MIA91FA029Accident · 1 fatalField investigationFinal reportCessna 172M · Homestead, FLThe failure of the pilot to insure adequate fuel was present in the aircraft for the flight resulting in loss of engine power due to fuel exhaustion.NTSB LAX91LA019Accident · No injuriesLimited investigationFinal reportCessna 172M · Torrance, CAThe student pilot failed to properly flare the airplane, made an improper recovery from the subsequent bounced landing. Contributing to this accident was the student pilot's total lack of experience and his improper use of the rudder.NTSB LAX91FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Goleta, CAThe pilot's failure to maintain proper glidepath while on final approach. A contributing factor was sunglare.NTSB LAX91LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · San Carlos, CAThe pilot's visual lookout was inadequate.NTSB ANC90LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Anchorage, AKThe pilot's poor judgement due to consumption of alcohol, and his improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB ATL90LA186Accident · No injuriesLimited investigationFinal reportCessna 172N · Stokesdale, NCThe failure of the engine driven oil pump which resulted in oil starvation to the engine. Factors were: the faa's failure to provide sufficient standards for airworthiness directive compliance, and the rough terrain.NTSB LAX90LA334Accident · No injuriesLimited investigationFinal reportCessna 172M · Orovada, NVThe pilot's failure to initiate a go-around. His lack of recent experience in type of operation, (landings), and the inadvertent ground loop were factors in the accident.NTSB CHI90FA265Accident · 2 fatalField investigationFinal reportCessna 172M · Aberdeen, SDFailure to maintain a safe airspeed resulting in an inadvertent stall/spin.NTSB DEN90LA185Accident · No injuriesLimited investigationFinal reportCessna 172M · Parker, COThe dual student pilot's improper use of the aircraft power plant controls, resulted in a complete loss of engine power.NTSB SEA90LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Lewiston, IDThe failure of a nose landing gear fork, which resulted in the pilot's loss of directional control, and a nose-over after an excursion from the runway.NTSB ANC90FA167Accident · 2 fatalField investigationFinal reportCessna 172M · Mckinley Park, AKFailure of both pilots to maintain adequate visual lookout to see-and-avoid other aircraft.NTSB MIA90LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Plymouth, FLThe failure of the pilot to arrest the high rate of descent prior to touchdown.NTSB CHI90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Farmington, MORemedial action was not attained by the CFI. Contributing to the accident was inadequate airspeed and porpoise encountered by the dual student pilot.NTSB FTW90LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Broken Arrow, OKThe pilot in command's failure to maintain directional control during the takeoff.NTSB LAX90LA289Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Goleta, CAThe loss of engine oil pressure for undetermined reasons.NTSB CHI90FAMS3Accident · 2 fatalMissing aircraftFinal reportCessna 172M · Kewaunee, WIUndetermined.NTSB FTW90FA151Accident · Minor injuriesField investigationFinal reportCessna 172M · Elmendorf, TXInadequate visual lookout by both pilots in the T-38 and by the instructor pilot (CFI) in the Cessna 172.NTSB LAX90LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · El Cajon, CAThe pilot-in-command's failure to abort the landing after touchdown past the touchdown zone.NTSB MKC90LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Winfield, IAThe pilot's decision to go-around was delayed and clearance of the power lines was not attained.NTSB LAX90LA188Accident · No injuriesLimited investigationFinal reportCessna 172 · Lakeport, CAThe pilot's inadequate compensation for crosswind conditions. The crosswind was a factor in the accident.NTSB NYC90LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Granville, NYThe improper recovery from a bounced landing which resulted in loss of control and collision with a ditch.NTSB LAX90LA166Accident · Serious injuriesLimited investigationFinal reportCessna 172M · San Jose, CAThe pilot's improper preflight, improper raising of the flaps after becoming airborne, and failure to maintain adequate flying speed, which resulted in an inadvertent stall.NTSB ATL90FA105Accident · 1 fatalField investigationFinal reportCessna 172M · Jonesboro, GAPilot-in-command's inadequate preflight and inflight planning, and his delayed climb after execution of a go-around. Contributing factors were his misreading of airfield wind information, his improper utilization of the flaps during climbout, his failure to…NTSB SEA90FA065Accident · Serious injuriesField investigationFinal reportCessna 172M · Incline Village, NVImproper in-flight planning/decision by the instructor pilot (CFI), and his failure to maintain adequate altitude and clearance from obstructions. Factors related to the accident were: mountainous terrain, high density altitude, and the trees (obstructions).NTSB LAX90LA131Accident · No injuriesLimited investigationFinal reportCessna 172M · Groveland, CAThe pilot improperly used the flight controls during the landing roll-out.NTSB DEN90LA079Accident · No injuriesLimited investigationFinal reportCessna 172M · Colorado Spring, COThe pilot's decision to initiate flight into known adverse weather, and his in-flight planning/decison. Factors related to the accident were: the adverse weather conditions, and the accumulation of airframe ice.NTSB DEN90LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Three Forks, MTPilot's misjudged landing flare.
Back to Cessna 172M