NTSB investigations: Cessna 172R
228 cases on aircraft the registry lists as Cessna 172R. 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, 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_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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401'))
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 MIA01LA228Accident · No injuriesLimited investigationFinal reportCessna 172R · Orlando, FLthe pilot's failure to keep a proper visual lookout and ensure proper clearance during taxi operations, which resulted in a collision with another parked aircraft.NTSB ATL01LA089Accident · No injuriesLimited investigationFinal reportCessna 172R · Ormond Beach, FLThe student pilots improper flare, and improper recovery from a bounced landing. A factor was the student pilot's lack of total experience.NTSB CHI01LA316Accident · No injuriesLimited investigationFinal reportCessna 172R · Alton, ILThe misjudged flare by the pilot.NTSB IAD01LA042Accident · No injuriesLimited investigationFinal reportCessna 172R · Lawrence, MAThe pilot's improper flare.NTSB MIA01LA095Accident · No injuriesLimited investigationFinal reportCessna 172R · Cartersville, GAthe pilot's failure to maintain control of the airplane which resulted in the airplane veering off course and subsequent impact with trees.NTSB CHI01LA092Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIAircraft control not maintained by the student pilot during the takeoff roll. Factors to the accident were the student pilot's lack of experience and the snowbank.NTSB CHI00LA287Accident · No injuriesLimited investigationFinal reportCessna 172R · New Lenox, ILThe pilot's failure to maintain directional control during landing. Factors to the accident were the pipe that was struck, the crosswind, and the pilot's runway selection.NTSB CHI00LA182Accident · No injuriesLimited investigationFinal reportCessna 172R · Athens, MIthe failure of the student pilot to maintain control of the aircraft, the inadequate supervision by the flight instructor, and the delayed remedial action performed by the flight instructor. A factor to the accident was the runway edge light that was struck…NTSB NYC00LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172R · West Milford, NJA loss of engine power for undetermined reasons.NTSB CHI00LA115Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIthe student pilot's failure to maintain directional control of the airplane during the landing. Factors associated with the accident were the misjudged landing flare, the student's lack of total experience, the runway lights, and the runway signs.NTSB CHI00LA081Accident · No injuriesLimited investigationFinal reportCessna 172R · Waterford, MIthe directional control not obtained/maintained by the dual student and the remedial action not performed by the certified flight instructor. Contributing factors were the crosswind and the snow bank.NTSB MIA00LA086Accident · No injuriesLimited investigationFinal reportCessna 172R · Olive Branch, MSThe student pilot's failure to maintain directional control during landing and the subsequent collision with a taxiway sign and collapsed right main landing gear.NTSB FTW00LA060Accident · No injuriesLimited investigationFinal reportCessna 172R · Angleton, TXThe pilot's failure to maintain control of the airplane during landing. A factor was the gust of wind.NTSB MIA00FA064Accident · 1 fatalField investigationFinal reportCessna 172R · Atlantic Ocean (Atlantic Ocean)The pilot's lack of total experience in instrument flight, simulated instrument flight, and night flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with water. Contributing to the accident was the dark night with…NTSB NYC00FA058Accident · 1 fatalField investigationFinal reportCessna 172P · Leominster, MAThe student pilot's failure to see and avoid the private pilot's airplane. Factors included the student pilot's non-standard traffic pattern entry, the private pilot's failure to check for other traffic before turning onto final, and the position of the sun…NTSB MIA00LA027Accident · No injuriesLimited investigationFinal reportCessna 172R · Daytona Beach, FLWas the pilot's improper flare and improper recovery from a bounced landing resulting in a hard landing and damage to the aircraft.NTSB DEN00LA017Accident · No injuriesLimited investigationFinal reportCessna 172R · Logan, UTThe pilot's improper flare and improper recovery from a bounced landing.NTSB DEN00FA009Accident · 1 fatalField investigationFinal reportCessna 172R · Aspen, COthe pilot's improper decision to fly directly up the center of the valley and not circle climb to gain sufficient terrain clearance altitude. A factor was inadequate route performance planning by the pilot.NTSB MIA99LA216Accident · No injuriesLimited investigationFinal reportCessna 172R · Savannah, GAThe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing, resulting in the airplane running off the runway and colliding with a runway sign.NTSB CHI99LA283Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILthe pilot's misjudged landing flare and his inadequate recovery from the bounced landing.NTSB NYC99LA188Accident · No injuriesLimited investigationFinal reportCessna 172R · Cheswold, DEThe pilot's improper flare and improper recovery from a bounced landing.NTSB CHI99LA203Accident · No injuriesLimited investigationFinal reportCessna 172R · Kokomo, INthe student pilot's failure to maintain directional control during landing. Factors to the accident were the pilot's lack of experience and the VOR station.NTSB LAX99LA185Accident · No injuriesLimited investigationFinal reportCessna 172R · Imperial, CAThe pilot's misjudged landing flare, which led to an inadvertent porpoise condition.NTSB CHI99LA103Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIThe pilot's improper flare and failure to maintain directional control. Related factors were the snowbank and lack of total experience.NTSB CHI99LA091Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIthe loss of directional control by the pilot. Factors to the accident were the lack of total experience of the pilot, the snow covered runway condition, the snowbank, and the flight instructor not verifying the runway snow removal with the Duty Instructor…NTSB CHI99LA071Accident · No injuriesLimited investigationFinal reportCessna 172R · Chesterfield, MOthe instructor pilot's failure to maintain aircraft control. Factors contributing to this accident were the snow covered grassy field area along the side of the runway and the pile of snow.NTSB CHI99FA053Accident · 1 fatalField investigationFinal reportCessna C-172R · Angola, INThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CHI98LA204Accident · 1 fatalLimited investigationFinal reportCessna 172R · Greenfield, INthe pilot's incapacitation due to a heart attack. A factor in the accident was the passenger's, a non-pilot, improper recovery from a bounced landing which resulted in an overload failure of the nose gear.