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 MIA07CA065Accident · No injuriesData collectionFinal reportCessna 172R · Orlando, FLThe student pilot's inadequate compensation for the wind conditions while landing. Factors associated with the accident are a crosswind and wind gusts.NTSB CHI07CA089Accident · No injuriesData collectionFinal reportCessna 172R · Columbus, OHThe pilot's failure to maintain directional control while landing. Contributing factors to the accident were the wind conditions and the runway sign.NTSB NYC07CA078Accident · No injuriesData collectionFinal reportCessna 172R · Norfolk, VAThe pilot's failure to maintain directional control while landing, which resulted in a collision with a runway sign. A factor was the crosswind.NTSB ATL07CA047Accident · No injuriesData collectionFinal reportCessna 172R · Cartersville, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in a loss of control and an on-ground collision with a sign.NTSB DEN07CA056Accident · No injuriesData collectionFinal reportCessna 172R · Olathe, KSThe pilot's improper flare during landing and failure to maintain directional control during the landing roll. Factors were the gusting winds and the crosswinds.NTSB NYC07CA046Accident · No injuriesData collectionFinal reportCessna 172R · Northhampton, MAThe pilot's inadequate recovery from a bounced landing.NTSB CHI07LA034Accident · No injuriesLimited investigationFinal reportCessna 172R · Lake in the Hil, ILThe directional control not maintained/obtained by the pilot, and the lack of recent experience by the pilot. The snow bank was a contributing factor.NTSB SEA07IA019Incident · No injuriesIncident investigationFinal reportCessna 172 · Seattle, WAThe instructor pilot's improper in-flight decision not to take evasive action as a heavy aircraft passed by while on an upwind parallel approach path to an adjacent runway, leading to a wake vortices encounter. Factors include a nearly direct crosswind…NTSB CHI06CA189Accident · No injuriesData collectionFinal reportCessna 172R · Waterford, MIThe directional control not obtained/maintained, the inadequate compensation for wind conditions, and the go-around not performed during landing by the pilot. An additional cause was the lack of experience by the pilot. A contributing factor was the crosswind.NTSB MIA06CA113Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare.NTSB MIA06LA091Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Fort Myers, FLThe flight instructor's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. Contributing to the accident was a malfunction of the elevator control for an undetermined reason, which required excessive forward pressure on the…NTSB NYC06FA071Accident · 2 fatalField investigationFinal reportCessna 172R · Mitchellville, MDThe pilot's improper inflight planning/decision to attempt a landing in weather conditions below landing minimums, and his failure to maintain airspeed while maneuvering. Factors in the accident were the fog and snow.NTSB CHI06CA053Accident · No injuriesData collectionFinal reportCessna 172R · Morris, ILThe pilot's improper in-flight decision to land with a quartering tailwind and not maintaining directional control. Factors were the quartering tailwind and the snowdrift.NTSB MIA06CA021Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare and remedial action during landing resulting in an in-flight loss of control and subsequent collision with terrain. A related factor was the crosswind.NTSB LAX06LA032Accident · No injuriesLimited investigationFinal reportCessna 172R · Ramona, CAthe student pilot's failure to maintain directional control during the landing.NTSB DFW06CA004Accident · No injuriesData collectionFinal reportCessna 172 · Spring, TXThe pilot's failure to maintain directional control while landing.NTSB DFW05CA219Accident · No injuriesData collectionFinal reportCessna 172R · Springtown, TXThe pilot's improper decision to shut down the engine. Contributing factors were the failure of the oil pressure switch and the lack of a suitable landing area.NTSB LAX05CA207Accident · No injuriesData collectionFinal reportCessna 172R · Santa Maria, CAthe student pilot's improper flare and recovery from a bounced landing.NTSB MIA05CA120Accident · No injuriesData collectionFinal reportCessna 172R · Fort Myers, FLThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL05CA090Accident · No injuriesData collectionFinal reportCessna 172R · Louisburg, NCThe pilot's failure to maintain adequate airspeed, which resulted in a stall and subsequent loss of control and collision with the ground.NTSB ATL05CA088Accident · No injuriesData collectionFinal reportCessna 172 · Raleigh, NCThe pilot's failure to maintain adequate obstacle clearance during initial climb, which resulted in an in-flight collision with treesNTSB NYC05FA075Accident · 2 fatalField investigationFinal reportCessna 172R · Armonk, NYThe flight instructor's failure to maintain the proper altitude\clearance during the approach, which resulted in an in-flight collision with trees. Factors in this accident were low ceilings, fog, and gusty wind conditions.NTSB CHI05CA090Accident · No injuriesData collectionFinal reportCessna 172R · Kalamazoo, MIThe pilot's failure to maintain directional control and the excessive taxispeed.NTSB IAD05LA043Accident · No injuriesLimited investigationFinal reportCessna 172N · Frederick, MDThe inadequate visual lookout of the pilots in each airplane, which resulted in a ground collision.NTSB MIA05CA065Accident · No injuriesData collectionFinal reportCessna 172 · Madison, MSThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.NTSB NYC05LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Smoketown, PAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a parked airplane.NTSB NYC05LA024Accident · No injuriesLimited investigationFinal reportCessna 172R · Martinsburg, WVA loss of engine power for undetermined reasons.NTSB ATL04CA170Accident · Minor injuriesData collectionFinal reportCessna 172R · Atlanta, GAThe intentional interuption of the flight controls in flight that resulted in a uncontrolled descent and collision with a fence.NTSB CHI04CA241Accident · No injuriesData collectionFinal reportCessna 172R · Olathe, KSThe student pilot flared too high and failed to recover from a bounced landing.NTSB NYC04CA145Accident · No injuriesData collectionFinal reportCessna 172R · Hartford, CTThe student pilot's improper flare and inadequate compensation for wind conditions. A factor was the gusty winds.NTSB CHI04LA097Accident · No injuriesLimited investigationFinal reportCessna 172R · Kalamazoo, MIThe air traffic control procedures/directives not followed by tower air traffic controller, the inadequate compensation for wind conditions by the student pilot during landing, the lack of total experience by the student pilot, and the recommended crosswind…NTSB CHI04LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Dubuque, IAThe flight instructor's inadequate in-flight planning/decision which resulted in ice accretion on the airframe, and his failure to maintain adequate airspeed resulting in a stall. Contributing factors were the ice contamination, the aircraft's low altitude…NTSB NYC04CA070Accident · No injuriesData collectionFinal reportCessna 172R · Batavia, OHThe student pilot's improper flare and improper recover from a bounced landing, which resulted in a hard landing.NTSB IAD04CA009Accident · No injuriesData collectionFinal reportCessna 172R · Fredrick, MDThe student pilot's failure to maintain directional control during the landing. A factor was the snow bank.NTSB NYC04CA053Accident · No injuriesData collectionFinal reportCessna 172R · Bluffton, OHThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB ATL04LA062Accident · No injuriesLimited investigationFinal reportCessna 172R · Atlanta, GAThe pilot's improper flare resulting in a hard landing. A factor is lack of total experience.NTSB IAD04LA003Accident · No injuriesLimited investigationFinal reportCessna C172R · Lexington, KYThe ground controller's failure to advise the relieving controller information regarding an engine run-up, which subsequently resulted in the flight instructor's inadvertent encounter with jet blast during ground taxi.NTSB DEN04LA017Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Cloudcroft, NMthe dual student's failure to maintain clearance from the terrain. Also causal was the flight instructor's inadequate supervision. Low altitude flight and rising terrain are contributing factors.NTSB ATL04LA031Accident · No injuriesLimited investigationFinal reportCessna 172R · New Bern, NCThe student pilot's improper landing flare resulting in a hard landing.NTSB LAX04LA027Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · San Diego, CAthe pilot of the other airplane's inadvertent application of the rudder pedals rather than the brakes, which resulted in the collision with the Cessna 172R.NTSB ATL03FA070Accident · 1 fatalField investigationFinal reportCessna 172R · Cherokee, NCThe pilot's failure to maintain adequate terrain clearance, which resulted in an in-flight collision with mountainous terrain.NTSB LAX03LA112Accident · No injuriesLimited investigationFinal reportCessna 172R · Thermal, CAthe student pilot's failure to use aileron controls to compensate for the known crosswind and failure to maintain directional control during the landing rollout.NTSB CHI02LA295Accident · No injuriesLimited investigationFinal reportCessna 172R · Greenwood, ILThe CFI's poor inflight planning/decision to allow the airplane to get to too low of an altitude to assure a safe recovery from the simulated forced landing. Factors associated with the accident were the student pilot's delay initiating the go around and the…NTSB IAD02LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norwood, MAThe student pilot's failure to maintain directional control during an aborted landing.NTSB FTW02LA122Accident · No injuriesLimited investigationFinal reportCessna 172R · McKinney, TXthe pilot's failure to maintain directional control of the airplane while taxiing from landing.NTSB LAX02LA115Accident · No injuriesLimited investigationFinal reportCessna 172R · Camarillo, CAThe pilot's failure to maintain directional control.NTSB NYC02LA053Accident · No injuriesLimited investigationFinal reportCessna 172R · Richmond, VAThe pilot's improper recovery from a bounced landing. A factor in the accident was the pilot improper flare.NTSB ATL02FA032Accident · 1 fatalField investigationFinal reportCessna 172R · Tampa, FLThe pilot's unauthorized use of an aircraft for the purpose of commiting suicide.NTSB ATL02LA007Accident · No injuriesLimited investigationFinal reportNorth American SNJ-6 · Kissimmee, FLSee narrative for ATL02LA007A.NTSB ATL01LA110Accident · No injuriesLimited investigationFinal reportCessna 172R · Orlando, FLThe improper installation of the engine vacuum pump by maintenance personnel which resulted in oil exhaustion and the subsequent loss of engine power. A factor was the none-suitable terrain.