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 MIA96LA184Accident · No injuriesLimited investigationFinal reportCessna 172M · Orlando, FLthe student pilot's improper level off during landing.NTSB LAX96LA255Accident · No injuriesLimited investigationFinal reportCessna 172 · Frazier Park, CAthe failure of the pilot to maintain terrain clearance after a misjudged approach and landing that necessitated a go-around and subsequent collision with some wires. Factors were high density altitude and an inadequate evaluation by the pilot-in-command of…NTSB LAX96LA246Accident · No injuriesLimited investigationFinal reportCessna 172M · Sedona, AZthe pilot's improper recovery from a bounced landing. The variable/gusty/quartering tail wind was a related factor.NTSB SEA96LA115Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Tooele, UTfailure of the flight instructor (CFI) to ensure that adequate airspeed was maintained during initial climb after lift-off, which resulted in an inadvertent stall/mush. High density altitude was a related factor.NTSB CHI96LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Terre Haute, INthe pilot's improper planning/decision, which resulted in his inadequate compensation (or inability to compensate) for the wind condition. The high/gusty wind condition was a related factor.NTSB IAD96LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Roanoke, VAloss of engine power for undetermined reason(s). Darkness and the pilot's improper emergency procedures were related factors.NTSB FTW96LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Fredericksburg, TXfailure of the pilot to maintain adequate airspeed during the approach and go-around, which resulted in a stall and subsequent collision with the ground. Factors relating to the accident were: the high, gusty, crosswind conditions, and the pilot's lack of…NTSB LAX96LA134Accident · No injuriesLimited investigationFinal reportCessna 172M · Napa, CAthe failure of both pilots to see and avoid the other aircraft, and the failure of the pilot of the Cessna 172L, N7668G, to follow VFR procedures by not yielding the right of way to the Cessna 172M, N20858, which was already established in the traffic pattern.NTSB CHI96LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Valparaiso, INthe pilot's continued flight into adverse weather. Factors were the low ceilings, icing conditions, airframe ice, and the muddy field.NTSB NYC96LA068Accident · No injuriesLimited investigationFinal reportCessna 172M · Bedford, MAthe flight instructor's inadequate supervision of the flight, the pilot's improper compensation for the wind conditions, and the high wind. The instructor's inadequate evaluation of the weather was a contributing factor.NTSB NYC96LA075Accident · No injuriesLimited investigationFinal reportCessna 172M · Warehouse Point, CTthe pilot's inadequate compensation for the crosswind and gusts. The wind conditions were factors.NTSB SEA96LA047Accident · No injuriesLimited investigationFinal reportCessna 172M · Mcleary, WAfailure of the pilot to maintain sufficient altitude/clearance from mountainous/wooded terrain. Factors relating to the accident were: the terrain and downdraft conditions.NTSB NYC96LA050Accident · No injuriesLimited investigationFinal reportCessna 172M · Nashua, NHthe pilot's inadequate crosswind compensation during the go-around.NTSB CHI96LA062Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Excelsior Sprg, MOthe pilot's selection of the wrong runway for landing and the delayed aborted landing. Factors associated with the accident were the tailwind condition and the pilot's inadequate level-off.NTSB LAX96LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Bakersfield, CAthe pilot's improper aborted landing procedure which resulted in the aircraft stalling and impacting terrain.NTSB LAX96LA071Accident · No injuriesLimited investigationFinal reportCessna 172M · Palm Springs, CAthe pilot's inadequate bounced landing recovery technique, which resulted in porpoising during a downwind emergency landing. The loss of engine power for undetermined reasons was a factor.NTSB LAX96LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Mohave Valley, AZthe failure of the pilot to assure that clearance was maintained while taxiing in proximity of buildings at an excessive taxi speed.NTSB MIA96LA034Accident · No injuriesLimited investigationFinal reportCessna 172M · Madison, MSThe pilot's premature raising of flaps during a go-around.NTSB BFO96FA007Accident · 2 fatalField investigationFinal reportCessna 172M · Norwich, VTloss of engine power for undetermined reason(s), during a low altitude operation. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW96LA014Accident · No injuriesLimited investigationFinal reportCessna 172M · Sugar Land, TXthe student pilot's diverted attention and failure to maintain directional control.NTSB ATL96LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Savannah, GAThe pilot's selection of unsuitable terrain for a precautionary landing, and his failure to maintain clearance from an obstacle (road sign) during the landing.NTSB FTW95FA393Accident · 3 fatalField investigationFinal reportCessna 172M · Witter, ARfailure of the pilot to maintain sufficient altitude/clearance from high/wooded terrain. Factors relating to the accident were: darkness, high terrain, and foggy weather conditions. Also, the pilot's use of Methamphetamine (not approved by the FAA) was a…NTSB CHI95FA307Accident · 1 fatalField investigationFinal reportCessna 172M · Orr, MNthe pilot misjudged the landing flare. Factors associated with the accident were the visual illusion caused by the glassy smooth water condition and the forward center of gravity.NTSB NYC95FA210Accident · 3 fatalField investigationFinal reportCessna 172M · Portland, MEan engine malfunction for an undetermined reason, and the pilot's failure to maintain airspeed during a forced landing which resulted in an accelerated stall. A factor was the pilot's lack of recent experience.NTSB NYC95LA207Accident · 1 fatalLimited investigationFinal reportCessna 172M · Kingswood Twsp, NJFailure of the pilot to maintain control of the airplane, which resulted in an in-flight collision with trees.NTSB NYC95LA205Accident · No injuriesLimited investigationFinal reportCessna 172M · Williamson, NYthe loss of engine power and the eruption of a fire for undetermined reasons.NTSB CHI95LA298Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Independence, MOthe pilot's failure to perform the pre-takeoff checklist and set the elevator trim tab to the takeoff position.NTSB NYC95LA200Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Hopedale, MAthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a loss of control and collision with a fence and a building.NTSB SEA95FA171Accident · 2 fatalField investigationFinal reportCessna 172M · Quilcene, WAThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain clearance from the mountains. Factors in the accident were the clouds and mountainous terrain.NTSB ATL95LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Bayboro, NCThe pilot's inadequate procedure in that he elected to land the aircraft on unsuitable terrain with no mechanical malfunctions.NTSB ANC95LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Kotzebue, AKFuel exhaustion due to the pilot's improper planning/decision. The unfavorable (stronger than forecast) headwind was a related factor.NTSB LAX95LA236Accident · No injuriesLimited investigationFinal reportCessna 172M · New Cuyama, CAthe pilot's failure to attain and maintain an adequate airspeed, his premature rotation, and his failure to maintain directional control when the aircraft settled back onto the runway. The pilot's selection of a closed airport for the takeoff attempt was a…NTSB NYC95LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Bridgewater, CTthe loss of engine power for undetermined reasons resulting in a forced landing, and a subsequent collision with trees.NTSB ANC95LA072Accident · No injuriesLimited investigationFinal reportCessna 172 · Skwentna, AKThe pilot's failure to maintain directional control. Factors associated with the accident are the wet and uneven airstrip surface.NTSB CHI95LA147Accident · No injuriesLimited investigationFinal reportCessna 172M · Brooklyn, MIFatigue failure of the left main landing gear. Factors relating to the accident were: the pilot's improper flare for landing, and soft terrain.NTSB NYC95WA097Accident · 1 fatalForeign investigationCessna 172M · St. Johns, CanadaNTSB LAX95LA163Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Yolo, CAthe pilot's improper preflight preparation which led to fuel exhaustion.NTSB MIA95LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Panacea, FLThe pilot's failure to attain the proper touchdown point during a forced landing to a runway. This resulted in the airplane rolling off the departure end of the runway, and subsequent on ground collision with a fence and a telephone booth. Contributing to the…NTSB BFO95FA045Accident · 3 fatalField investigationFinal reportCessna 172M · Eldersburg, MDThe pilot's failure to maintain proper airspeed. Factors in the accident were the pilot's failure to remove carburetor heat during the go-around and the presence of a tailwind.NTSB NYC95LA061Accident · No injuriesLimited investigationFinal reportCessna 172M · West Seneca, NYThe pilot's improper planning/decision to attempt a takeoff on a narrow icy runway with crosswind conditions, which resulted in the loss of control of the airplane, impact with a snow bank, and a nose over.NTSB LAX95LA110Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Corona, CAthe pilot's failure to maintain runway alignment after aborting a takeoff and improper use of the brakes during the abort.NTSB FTW95LA110Accident · No injuriesLimited investigationFinal reportCessna 172M · Boulder, COThe pilot's premature rotation.NTSB NYC95LA038Accident · No injuriesLimited investigationFinal reportCessna 172J · Batavia, OHFailure of the pilot to maintain control of the airplane during the landing flare/toughdown. Factors related to the accident were: the crosswind and proximity of the ditch to the runway.NTSB MIA95LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Crystal River, FLThe pilot in command's failure to maintain visual outlook during taxiing.NTSB FTW95LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Farmington, NMThe pilot's inadequate compensation for wind conditions. Factors were wind shear, crosswinds, and gusts.NTSB LAX95LA002Accident · No injuriesLimited investigationFinal reportCessna 172M · Coalinga, CAthe pilot's failure to maintain a proper glide path.NTSB NYC94LA179Accident · Minor injuriesLimited investigationFinal reportCessna 172M · New London, PAThe pilot failed to maintain adequate airpseed which resulted in an inadvertent stall and inflight collision with terrain.NTSB FTW94LA298Accident · No injuriesLimited investigationFinal reportCessna 172M · Oil Trough, ARThe pilot's loss of aircraft directional control during the landing roll. A factor was the wet grass landing surface.NTSB SEA94LA238Accident · No injuriesLimited investigationFinal reportCessna 172 · Bullfrog, UTThe pilot-in-command exceeded the airplane's maximum crosswind component capability. A factor related to the accident was the gusty crosswind.NTSB SEA94LA235Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Coolin, IDThe failure of the engine manufacturer to properly remanufacture and adequately inspect the no. 1 rocker arm prior to its installation on the engine. This resulted in fatigue cracking of the rocker arm and a subsequent loss of engine power.
Back to Cessna 172M