Cessna 172RG
NTSB investigations · 256
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 ('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_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 ('2072438')
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 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.NTSB SEA07CA029Accident · No injuriesData collectionFinal reportCessna 172RG · Laurel, MTThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and subsequent nose over. A contributing factor was the crosswind condition.NTSB LAX07LA039Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Diego, CAAn undetermined total electrical failure. The pilot's failure to extend the landing gear to the down and locked position was a factor.NTSB DFW06CA106Accident · No injuriesData collectionFinal reportCessna 172RG · Bridgeport, TXThe flight instructor's delayed remedial action to regain control of the airplane while landing in a crosswind, and the inadvertent retraction of the landing gear by the pilot receiving instruction while executing a go-around. A factor was the prevailing…NTSB LAX06FA106Accident · 3 fatalField investigationFinal reportCessna 172RG · El Cajon, CAThe pilots of both airplanes failure to maintain an adequate visual lookout due to their relative flight paths, which limited the available visual cues. Factors were the failure of the air traffic controller(s) to issue a conflict alert to the Cessna 172RG…NTSB CHI06LA005Accident · 1 fatalLimited investigationFinal reportCessna 172RG · Union City, OHThe pilot's failure to perform a preflight weather evaluation which led to his inadvertent flight into instrument meteorological conditions and his spatial disorientation. The low ceilings and the dark night were contributing factors.NTSB LAX05FA290Accident · 2 fatalField investigationFinal reportCessna 172RG · Avalon, CAan in-flight loss of control for undetermined reasons.NTSB DEN05CA120Accident · No injuriesData collectionFinal reportCessna 172RG · Fort Collins, COthe pilot's failure to maintain directional control. Contributing factors were the crosswind, the pilot's failure to compensate for the wind conditions --- allowing the airplane to touch down without being properly aligned with the runway --- and the flight…NTSB LAX05LA160Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Grand Canyon, AZthe pilot-in-command's failure to properly lean the mixture, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush condition while departing during high density…NTSB CHI05CA060Accident · No injuriesData collectionFinal reportCessna 172RG · Berrien Springs, MIThe pilot not maintaining airspeed leading to an excessive sink rate during a simulated emergency landing after takeoff. An additional cause was the certified flight instructor's inadequate supervision.NTSB LAX05LA027Accident · No injuriesLimited investigationFinal reportCessna 172RG · Kingman, AZLanding gear extension system component failure resulting in a gear up landing.NTSB ATL04CA186Accident · No injuriesData collectionFinal reportCessna 172RG · Montgomery, ALThe separation of a hydraulic line for undetermined reasons, which resulted in a hydraulic fluid leak and malfunction of the landing gear.NTSB LAX04LA277Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Diego, CAThe pilot's failure to ensure that the landing gear was fully extended, by use of the emergency gear extension system, which resulted in its partial collapse during landing rollout. Also causal was the pilot's failure to follow POH procedures relating to…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.NTSB ATL04IA138Incident · No injuriesIncident investigationFinal reportCessna 172RG · Chamblee, GAThe fatigue fracture of the nosewheel bungee assembly, which restricted the movement of the elevator control. A factor was the inadequate equipment from an unknown source/manufacturer.NTSB SEA04LA033Accident · No injuriesLimited investigationFinal reportCessna 172RG · Enumclaw, WAA loss of engine power while maneuvering due to the failure of the heads of six of the eight cam followers. Factors include the pilot's decision to keep the gear retracted during the forced landing, and the rough/uneven terrain.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.NTSB LAX04LA011Accident · No injuriesLimited investigationFinal reportCessna 172RG · Camarillo, CAThe fracture and failure of the left landing gear actuator. Contributing to the accident was the operator's failure to comply with the manufacturer's service bulletin.NTSB LAX03LA290Accident · No injuriesLimited investigationFinal reportCessna 172RG · Santa Ana, CAthe failure of the right main landing gear pivot assembly.NTSB SEA03LA187Accident · No injuriesLimited investigationFinal reportCessna 172RG · Blanchard, IDThe loss of engine oil as a result of the inadequate installation of the idler gear shaft set screw and the lack of a safety wire on the hex head (oil) plug. A contributing factor was the rough and uneven terrain.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.NTSB SEA02LA182Accident · No injuriesLimited investigationFinal reportCessna 172RG · Billings, MTThe failure of the landing gear actuator during landing as a result of fatigue.NTSB LAX02LA292Accident · No injuriesLimited investigationFinal reportCessna 172RG · Del Mar, CAThe loss of engine power due to failure of the number three connecting rod cap. Also causal was the failure of the pilot of a previous flight to report an engine overspeed event precluding the performance of the appropriate maintenance inspection.NTSB NYC02LA161Accident · No injuriesLimited investigationFinal reportCessna 172RG · Rochester, NYThe pilot's improper flare and recovery from a bounced landing. A factor in the accident was the slow response time of the airspeed indicator.NTSB IAD02LA084Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · West Milford, NJThe private pilot's excessive rotation and the flight instructor's delayed remedial action.NTSB FTW02LA128Accident · No injuriesLimited investigationFinal reportCessna 172RG · Alamogordo, NMthe loss of engine power for an undetermined reason, which resulted in a forced landing after takeoff.NTSB CHI02FA113Accident · 1 fatalField investigationFinal reportCessna 172RG · Marthasville, MOThe inadequate supervision and the stall encountered by the certified flight instructor.NTSB SEA01LA177Accident · No injuriesLimited investigationFinal reportCessna 172RG · Newberg, ORThe pilot's failure to lower the landing gear. A factor was the pilot's failure to follow checklist procedures.NTSB DEN01LA164Accident · No injuriesLimited investigationFinal reportCessna 172RG · Englewood, COthe failure of the dual student to verify that the landing gear was down and locked, and the failure of the flight instructor to adequately supervise the dual student.NTSB SEA01LA168Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Carbonado, WAThe pilot-in-command's failure to utilize carburetor heat resulting in a loss of power and consequent descent into trees and terrain. Contributing factors were carburetor icing conditions and mountainous/hilly terrain.NTSB DEN01LA130Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Gunnison, COthe pilot's failure to attain the proper climb rate, and his improper inflight planning/decision to attempt to cross mountainous terrain at an inadequate altitude. Contributing factors were the downdraft and the pilot's total lack of experience in mountain…NTSB MIA01FA163Accident · 1 fatalField investigationFinal reportCessna 172RG · Waveland, MSThe incapacitation of the pilot (cardiovascular) resulting in his inability to fly the airplane and subsequent in-flight collision with trees then a house.NTSB FTW01LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Washington, OKthe in-flight fire for an undetermined reason, which resulted in a forced landing. A contributory factor was the lack of suitable terrain for the forced landing.NTSB SEA01LA071Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Gig Harbor, WAThe pilot's failure to extend the airplane's landing gear while landing.NTSB FTW01LA085Accident · No injuriesLimited investigationFinal reportCessna 172RG · Waco, TXthe failure of the number four cylinder exhaust valve which resulted in a total loss of engine power during cruise. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX01LA123Accident · No injuriesLimited investigationFinal reportCessna 172RG · Stanford, CAFailure of company maintenance personnel to properly install and safety wire the oil filter, which subsequently lead to a loss of engine power.NTSB CHI01LA081Accident · No injuriesLimited investigationFinal reportCessna 172RG · Troy, MIthe excessive touchdown airspeed and the directional control not maintained by the pilot. The snow bank was a contributing factor.NTSB CHI01LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sunfield, MIThe pilot's inadequate preflight preparation and the unsuitable terrain for takeoff encountered. Factors included the slushy runway and the snowbank.NTSB LAX00LA315Accident · No injuriesLimited investigationFinal reportCessna 172RG · Westminister, CAThe pilot of the Pitts misjudged the clearance while maneuvering under the Cessna.NTSB LAX00FA207Accident · 2 fatalField investigationFinal reportCessna 172RG · Prescott, AZThe flight instructor's delayed remedial action, and his failure to correct an inappropriate descent during maneuvering flight, while engaged in commercial flight training maneuvers.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.NTSB FTW99LA258Accident · No injuriesLimited investigationFinal reportCessna 172RG · Fort Smith, ARThe failure of the electric pump motor/hydraulic power pack resulting in the collapse of the right main landing gear upon landing.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…NTSB FTW99LA216Accident · No injuriesLimited investigationFinal reportCessna 172RG · Celina, TXThe failure of the pilot in command to use all of the available runway for takeoff.NTSB ATL99LA097Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe pilot's failure to maintain directional control during landing.NTSB NYC99LA154Accident · No injuriesLimited investigationFinal reportCessna 172RG · Morristown, NJThe right main landing gear collapsed for undetermined reasons.NTSB LAX99LA134Accident · No injuriesLimited investigationFinal reportCessna 172RG · Moorpark, CAThe failure and separation of the number two cylinder for undetermined reasons. A factor was the soft terrain at the forced landing site.NTSB LAX98LA226Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Manuel, AZThe failure of the certified flight instructor to maintain directional control while landing with a sudden windshift.NTSB ANC98FA061Accident · 2 fatalField investigationFinal reportCessna 172RG · Juneau, AKThe failure of both command pilots to maintain an adequate lookout to see and avoid each other's aircraft. Factors associated with the accident were the pilot's failure to follow published advisory procedures to monitor/issue position reports on the…NTSB MIA98LA165Accident · No injuriesLimited investigationFinal reportCessna 172RG · Roberta, GAThe pilot's inadequate compliance with the emergency procedures for his failure to completely pump the main landing gear into the down and locked position. Contributing to the accident was the reported loss of electrical power for undetermined reasons.
Back to Cessna 172RG