Cessna 172N
NTSB investigations · 1,815
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 ('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_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 ('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 LAX97LA119Accident · No injuriesLimited investigationFinal reportCessna 172N · Oakland, CAthe student pilot's failure to completely reduce the throttle after landing, and his failure to maintain proper runway alignment.NTSB SEA97LA060Accident · No injuriesLimited investigationFinal reportCessna 172N · Delta, UTThe pilot's failure to adequately compensate for the prevailing wind conditions, and his subsequent failure to maintain directional control during the landing roll. Factors contributing to the accident are a sudden shift in the prevailing wind at the time of…NTSB SEA97LA059Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Madras, ORThe pilot's inadvertent visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors include the pilot's improper decision to fly under a low ceiling while in mountainous/hilly terrain, and his encounter with fog and low clouds…NTSB CHI97LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Wayne, INthe pilot's inadequate fuel management and fuel system exhaustion. A factor involved was the inadequate in-flight planning/decision.NTSB FTW97LA085Accident · No injuriesLimited investigationFinal reportCessna 172N · Steamboat Spgs, COFailure of the flight instructor and the dual student to maintain an adequate visual lookout. Factors were the flight instructor's inadequate supervision of the flight, inadequate altitude in which to clear obstacles, and the dual student's lack of…NTSB ATL97LA032Accident · No injuriesLimited investigationFinal reportCessna 172N · Anderson, SCThe pilot's improper recovery from a bounced landing. A factor was the pilot's improper level off.NTSB IAD97LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Manville, NJThe pilot's failure to perform a go-around, and his failure to retract the flaps in increments.NTSB MIA97LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot's improper flare and improper recovery from a ballooned/bounced landing. The gusty wind was a related factor.NTSB MIA97LA007Accident · No injuriesLimited investigationFinal reportCessna 172N · Fruitland Park, FLThe pilot's inadequate compensation for wind conditions and failure to maintain proper runway alignment during takeoff. The unfavorable wind condition was a related factor.NTSB NYC97LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Coudersport, PAthe pilot's improper in-flight planning/decision, and his failure to ensure that adequate airspeed would be maintained, while maneuvering at low altitude to photograph a residence. The rising terrain and lack of altitude were related factors.NTSB NYC96LA184Accident · No injuriesLimited investigationFinal reportCessna 172N · Shirley, NYthe pilot's prematurely retraction of flaps during the go-around, which resulted in settling (mushing) of the airplane and a collision with the ground.NTSB LAX96LA324Accident · No injuriesLimited investigationFinal reportCessna 172N · Auburn, CAthe pilot's misjudged landing flare and improper bounced landing recovery. A contributing factor was his lack of recent flying experience.NTSB CHI96LA302Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenwood, ILthe pilot's failure to obtain a proper touchdown point.NTSB LAX96LA304Accident · No injuriesLimited investigationFinal reportCessna 172N · Fullerton, CAthe pilot's misjudged glide path and delayed remedial action by not promptly initiating a go-around. A contributing factor was the pilot's lack of experience flying the airplane.NTSB SEA96LA183Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Enumclaw, WAfailure of the engine magneto drive, which resulted in a loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB ATL96LA118Accident · No injuriesLimited investigationFinal reportCessna 172N · Nashville, TNinadequate annual inspection by other maintenance personnel and inadequate pre-flight inspection by the pilot.NTSB MIA96LA199Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Victoria, MSThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.NTSB LAX96LA283Accident · No injuriesLimited investigationFinal reportCessna 172 · Boulder City, NVa loss of directional control due to the student pilot's inadequate compensation for wind conditions and improper remedial action. Factors in the accident were crosswinds, inadvertent brake application, and failure to use the ailerons.NTSB IAD96LA120Accident · No injuriesLimited investigationFinal reportCessna 172 · Stowe, VTfailure of the pilot to follow proper IFR procedures and to maintain proper terrain clearance (altitude) during an NDB approach. Factors related to the accident were: the pilot's lack of instrument experience, low ceiling, and mountainous terrain.NTSB LAX96LA274Accident · No injuriesLimited investigationFinal reportCessna 172N · Daggett, CAThe fracture and separation of an exhaust valve head for undetermined reasons.NTSB ATL96LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsborough, NCThe failure of the magneto impulse coupling spring. A factor was the power line at the approach end of the forced landing site.NTSB NYC96LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Newry, PAfailure of the pilot to identify the inoperative airspeed indication and abort the takeoff, while there was sufficient runway remaining; excessive speed during the approach/landing; and the pilot's failure to perform a go-around after not attaining a proper…NTSB CHI96LA227Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cottage Grove, WIthe pilot's failure to maintain directional control of the airplane during landing. A factor was the delayed go-around.NTSB LAX96LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Avalon, CAthe pilot's failure to initiate a landing flare, which resulted in a bounced landing and porpoise, and his loss of directional control during an attempt to initiate a go-around with insufficient airspeed, which resulted in an inadvertent stall/mush and…NTSB ATL96FA094Accident · 1 fatalField investigationFinal reportCessna 172N · Arlington, TNThe pilot's failure to maintain clearance above the trees. A factor was the dark night.NTSB FTW96LA246Accident · No injuriesLimited investigationFinal reportCessna 172N · Farmington, NMfailure of the pilot to maintain directional control during a touch-and-go landing, which resulted in a ground swerve and subsequent collision with a parked airplane.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 LAX96FA223Accident · 3 fatalField investigationFinal reportCessna 172N · Bermuda Dunes, CAthe pilot's impairment of judgment and performance due to alcohol and drugs (methamphetamine, amphetamine, & marijuana), his excessive maneuvering (pull-up) after making a touch-and-go landing, and his failure to maintain sufficient airspeed, which resulted…NTSB LAX96LA237Accident · No injuriesLimited investigationFinal reportCessna 172N · Ramona, CAthe pilot's misjudged and delayed landing flare, and inadequate recovery technique from a bounced landing (porpoise). Sun glare was a factor in the accident.NTSB IAD96LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · Findlay, OHthe student pilot's misjudged flare during landing.NTSB CHI96LA156Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Crystal Lake, ILthe pilot not flying a proper glidepath for the displaced runway threshold.NTSB FTW96LA182Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COthe student pilot's inadequate compensation for wind conditions, and his failure to obtain/maintain directional control. A factor was the cross wind.NTSB CHI96LA140Accident · No injuriesLimited investigationFinal reportCessna 172 · Dekalb, ILThe flight instructor's inadequate supervision, and his delay in taking remedial action to regain directional control of the airplane. Factors relating to the accident were: the student's improper flare for landing, improper recovery from a bounced landing,…NTSB CHI96LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Middleton, WIfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the gusty crosswind condition, the pilot's excessive lowering of flaps, and the…NTSB SEA96LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Cheyenne, WYthe pilot's improper flare during the landing and improper recovery from the subsequent bounced landing. A factor relating to the accident was: the pilot's failure to maintain the proper approach path during the approach for landing.NTSB MIA96LA105Accident · No injuriesLimited investigationFinal reportCessna 172N · New Smyrna Bch, FLThe student pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise, and subsequent overload failure of the nose gear.NTSB ANC96LA029Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Ketchikan, AKloss of engine power for undetermined reason(s). A factor relating to the accident was: the lack of a suitable area for an emergency landing.NTSB SEA96LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Jordan, UTimproper installation of the airplane's carburetor fuel lines by maintenance personnel.NTSB FTW96LA134Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Austin, TXthe partial loss of engine power due to the failure of the #3 connecting rod. A factor was the lack of suitable terrain for the forced landing.NTSB LAX96FA115Accident · 3 fatalField investigationFinal reportCessna 172N · Julian, CAthe pilot's delay in requesting assistance to avoid high terrain. Factors were: the downdrafts, mountainous terrain, and the pilot's improper in-flight planning.NTSB FTW96LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Norman, OKthe student pilot's improper level-off during landing.NTSB CHI96LA075Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Forks, NDthe pilot's failure to maintain control of the airplane while taxiing. Factors in the accident were the icy condition of the taxiway and the high gusting wind.NTSB MIA96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lantana, FLLoss of engine power for an undetermined reason, while over water, which resulted in a forced landing/ditching at sea.NTSB LAX96LA092Accident · No injuriesLimited investigationFinal reportCessna 172N · Kailua Kona, HIThe failure of the Waco pilot to see and avoid the opposite direction Cessna 172 while both aircraft were taxiing in a non-movement area of the airport. Factors in the accident were: the congested nature of the taxi lane, which limited the Waco pilot's…NTSB SEA96LA035Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacific City, ORThe pilot's delay in aborting the landing, which resulted in his failure to clear the perimeter fence. Factors relating to the accident were: the tailwind, and the pilot's failure to land at the proper touchdown point.NTSB MIA96LA044Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bryceville, FLThe pilot's improper planning/decision. Factors relating to the accident were: the pilot's inaccurate evaluation of the weather conditions, the pilot becoming lost/disoriented, and the lack of braking action on wet grass during the precautionary landing.NTSB NYC96LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, MEthe pilot's failure to adequately compensate for a crosswind during the landing roll, which resulted in a collision with a snowbank. Factors relating to the accident were: ice on the runway and the gusty crosswind condition.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 CHI96LA039Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Stevens Point, WIflying into known icing conditions and descending below the minimum descent altitude.NTSB CHI96LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Niles, MIfuel exhaustion as a result of the pilot's improper fuel consumption calculations. Factors related to the accident were: the pilot's lack of familiarity with the aircraft and operating with a known malfunctioning fuel gauge.
Back to Cessna 172N