Skip to content

NTSB investigations: Cessna 172RG, FL

31 cases on aircraft the registry lists as Cessna 172RG. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19802026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072438')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072438'))
  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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072438'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA26LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Pembroke Pines, FLThe pilot's failure to extend the landing gear before landing.Feb 1, 2026 · N949SM · Substantial damage NTSB ERA21LA219Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Miami, FLThe collapse of the left main landing gear for reasons that could not be determined.May 8, 2021 · N9795B · Substantial damage NTSB ANC18LA009Accident · No injuriesLimited investigationFinal reportCessna 172RG · Opa Locka, FLA failure of the airplane 's electrical system, which led to the failure of the landing gear system, for reasons that could not be determined because postaccident examination and testing revealed no mechanical anomalies that would have precluded normal…Nov 16, 2017 · N6102R · Substantial damage NTSB ERA14LA374Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Apalachicola, FLA total loss of engine power for reasons that could not be determined during postaccident examination and testing.Aug 1, 2014 · N5276U · Substantial damage NTSB ERA12LA070Accident · No injuriesLimited investigationFinal reportCessna 172RG · Kissimmee, FLA fatigue failure of the right main landing gear pivot assembly, which prevented the landing gear from extending.Nov 8, 2011 · N5095V · Substantial damage NTSB ERA11LA231Accident · No injuriesLimited investigationFinal reportCessna 172RG · Okeechobee, FLThe failure of the main landing gear to lock in the extended position for undetermined reasons and both pilots’ failure to ensure that the landing gear was down and locked prior to landing.Apr 6, 2011 · N5284V · Substantial damage NTSB MIA07LA109Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lantana, FLSeparation of a landing gear hydraulic line at the fitting for undetermined reasons.Jun 10, 2007 · N522GC · Substantial damage NTSB SEA07LA062Accident · No injuriesLimited investigationFinal reportCessna 172RG · Daytona Beach, FLThe fracture and failure of the right landing gear actuator, which resulted in a gear collapse during the landing roll.Feb 8, 2007 · N9395B · Substantial damage NTSB ATL04CA145Accident · No injuriesData collectionFinal reportCessna 172 RG · Fernandina, FLThe pilot's failure to follow the checklist and lower the landing gear prior to landing.Jul 8, 2004 · N6321R · Substantial damage NTSB MIA04LA038Accident · No injuriesLimited investigationFinal reportCessna 172RG · Key West, FLPilot's improper emergency landing gear extension procedure which resulted in the right main landing gear not locking in the down position subsequent right main landing gear collapsing on landing.Dec 25, 2003 · N4721R · Substantial damage NTSB MIA03LA070Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe intentional cutting of the hydraulic line by an unknown person resulting in the loss of hydraulic fluid and the inability of the pilot-in-command to extend and lock the main landing gear, and subsequent collapse of the main landing gear after touchdown.Feb 24, 2003 · N5177R · Substantial damage NTSB MIA99LA270Accident · No injuriesLimited investigationFinal reportCessna 172RG · Orlando, FLthe pilot's failure to ensure that the landing gear was down and locked following loss of electrical power for undetermined reasons, resulting in substantial damage to the airplane when the right main landing gear collapsed upon landing.Sep 24, 1999 · N9536B · Substantial damage NTSB MIA99LA233Accident · No injuriesLimited investigationFinal reportCessna 172RG · Miami, FLThe delay by the pilot-in-command to extend the gear resulting in collapse of the main landing gear after touchdown. Factors in the accident were the inoperative gear warning system associated with the throttle due to the broken wire at the throttle…Aug 21, 1999 · N6231V · Substantial damage NTSB ATL99LA097Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe pilot's failure to maintain directional control during landing.May 28, 1999 · N9561B · Substantial damage NTSB MIA98LA142Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe inadvertent stall of the airplane and inadequate supervision of the student by the CFI-PIC while performing a soft field takeoff.Apr 24, 1998 · N9303D · Substantial damage NTSB MIA95FA174Accident · 2 fatalField investigationFinal reportCessna 172RG · Ft. Lauderdale, FLThe failure of the pilot to maintain airspeed after a momentary loss of engine power during takeoff, resulting in an inadvertent stall/spin. The reason for power loss could not be determined.Jul 7, 1995 · N9324B · Destroyed NTSB MIA94LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Parkland, FLImproper planning/decision by the director of operations, and failure of the instructor pilot to take adequate remedial action. A factor related to the accident was: the soft/wet runway condition.Mar 28, 1994 · N9786B · Substantial damage NTSB MIA94LA103Accident · No injuriesLimited investigationFinal reportCessna 172RG · Boca Raton, FLThe failure of the aircraft operator to comply with engine manufacturers service bulletins which resulted in improper inspection of exhaust valves and subsequent sticking of the no. 4 exhaust valve.Mar 26, 1994 · N9781B · Substantial damage NTSB MIA94LA068Accident · No injuriesLimited investigationFinal reportCessna 172RG · Orlando, FLThe failure of the student pilot to follow instuctions given by ground control and the failure of both pilots to maintain proper obstruction clearance between aircraft.Feb 6, 1994 · N9346D · 2 aircraft · Substantial damage NTSB MIA93LA123Accident · No injuriesLimited investigationFinal reportCessna 172RG · Fort Lauderdale, FLThe failure of the left main gear pivot assembly, resulting in the collapse of the left main landing gear during the landing rollout.May 20, 1993 · N5338V · Substantial damage NTSB MIA93LA019Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Key Largo, FLThe pilot in command's failure to obtain the proper touchdown point on landing. Contributing to the accident was the pilot in command's improper preflight planning preparation and selection of the wrong runway relative to the wind.Nov 18, 1992 · N5190V · Substantial damage NTSB MIA92FA118Accident · Serious injuriesField investigationFinal reportCessna 172RG · Cedar Key, FLImproper recovery from the bounced landing by the pilot-in-command, and failure to maintain directional control. Contributing to the accident was the crosswind.Apr 26, 1992 · N9888B · Substantial damage NTSB MIA92FA053Accident · Serious injuriesField investigationFinal reportCessna 172RG · Melbourne, FLThe flight instructor pilot in command's failure to maintain airspeed while demonstrating a power off approach to the student and his improper retraction of the wing flaps during go around from the approach resulting in an inadvertent stall and inflight loss…Dec 28, 1991 · N9718B · Substantial damage NTSB MIA90LA048Accident · No injuriesLimited investigationFinal reportCessna 172RG · Astatula, FLLoss of engine power for an undetermined reason during a simulated forced landing.Jan 5, 1990 · N6290R · Substantial damage NTSB MIA85FA227Accident · 2 fatalField investigationFinal reportCessna 172RG · Cedar Key, FLThe manager of the destination arpt said the plt had called earlier in the evening & had asked to be picked up at the arpt. The plt said that he would fly over the manager's house after he arrived. The manager heard the acft fly over from east to west.…Aug 10, 1985 · N6419R · Destroyed NTSB MIA84FA038Accident · 1 fatalField investigationFinal reportCessna 172RG · Cross City, FLWhile in the vicinity of Cross City the plt requested VFR flt following from jacksonville ARTCC. While he was in radio &radar contact, the controller suddenly lost radar contact with the flt. Radar indicated that the acft made a rapid descent from the cruise…Dec 2, 1983 · N9682B · Destroyed NTSB MIA83FA113Accident · 1 fatalField investigationFinal reportCessna 172RG · Gainesville, FLThe acft crashed about 8 miles from the intended destination during weather on a dark night. The plt had gone outbound that afternoon with two passengers who did not return with him because of motion sickness. According to the one of his former instructors…Apr 10, 1983 · N6418V · Destroyed NTSB MIA82FKT10Accident · Minor injuriesFinal reportCessna 172RG · Labelle, FLThe pilot and two passengers planned to depart on a flight to spot hogs for hunters. The aircraft was loaded with about 50 gallons of fuel and was near its maximum gross weight. Before takeoff, the pilot noted the wind. He reported that it was light and…May 27, 1982 · N5143V · Destroyed NTSB MIA82FKT03Accident · No injuriesClosedCessna 172RG · Miami, FLOct 15, 1981 · N4662V · Substantial damage NTSB MIA81DLA26Accident · No injuriesClosedCessna 172RG · Perry, FLMay 20, 1981 · N6117R · Substantial damage NTSB MIA80FA035Accident · 1 fatalClosedCessna 172RG · Palm Bay, FLFeb 18, 1980 · N6265R · Destroyed