Cessna 172D
NTSB investigations · 330
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 ('2072410')
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 ('2072410')
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 CEN26LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna 172D · Post, TXThe pilot’s failure to see the blockage in the fuel tank vent tube during the preflight inspection which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was the deterioration of the right fuel cap vent to the point…NTSB ERA24LA269Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Eastham, MAThe pilot’s inadequate preflight inspection of the airplane’s fuel quantity, which resulted in total loss of engine power due to fuel exhaustion.NTSB CEN23FA187Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Chambers, NEThe pilot’s continued VFR flight into instrument meteorological conditions at night and his failure to maintain adequate altitude, which resulted in controlled flight into terrain.NTSB ERA18LA169Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172D · Quinton, VAA loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR18LA047Accident · No injuriesClass 3 · LimitedFinal reportCessna 172D · Auburn, WAThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB ERA17LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cape Coral, FLA total loss of engine power due to fuel contamination with water and the pilot's inadequate preflight inspection that detected, but did not fully resolve, the water contamination of the fuel system.NTSB GAA16CA286Accident · No injuriesData collectionFinal reportCessna 172 · Arlington, WAThe failure of the airplane’s right steering rod end, which resulted in the pilot’s inability to maintain directional control.NTSB GAA16CA150Accident · No injuriesData collectionFinal reportCessna 172 · La Junta, COThe pilot's decision to take off with a tailwind, and exceed the critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.NTSB CEN15LA292Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Shenandoah, TXThe pilot's delayed application of carburetor heat, which resulted in the total loss of engine power due to carburetor icing during cruise flight.NTSB WPR15LA077Accident · No injuriesLimited investigationFinal reportCessna 172D · Fresno, CAThe pilot's improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA14LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Fairhope, ALThe pilot’s failure to maintain adequate separation from a helicopter during the approach to landing, which resulted in an encounter with the helicopter’s trailing vortices, a loss of airplane control, and impact with terrain.NTSB ERA13LA037Accident · No injuriesLimited investigationFinal reportCessna 172D · Indian Trail, NCThe pilot’s improper use of flaps for takeoff, which resulted in the airplane’s failure to attain adequate climb airspeed and subsequent collision will trees during takeoff.NTSB ANC13CA003Accident · No injuriesData collectionFinal reportCessna 172D · Buckland, AKThe pilot's loss of airplane control during takeoff from an off-airport site, which resulted in a runway excursion and collision with terrain.NTSB WPR12LA189Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Beckwourth, CAThe pilot’s failure to maintain sufficient airspeed during initial climb, which resulted in a loss of airplane control.NTSB ERA12LA101Accident · No injuriesLimited investigationFinal reportCessna 172D · Belhaven, NCA total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Durango, COA total loss of engine power due to the pilot inadvertently moving the fuel selector to the OFF position. Contributing to the accident was the pilot's unfamiliarity with this model accident airplane.NTSB CEN10LA282Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Las Cruces, NMA loss of engine power due to fuel starvation as a result of water contamination in the fuel, and the pilot's inadequate preflight inspection. Contributing the accident was an inoperative number 5 cylinder exhaust valve.NTSB CEN10FA181Accident · 1 fatalField investigationFinal reportCessna 172D · Hillsboro, OHImpact with the runway pavement for unknown reasons.NTSB ERA09LA372Accident · No injuriesLimited investigationFinal reportCessna 172D · Shepherdsville, KYThe mechanic's improper inspection of the mixture control cable.NTSB WPR09CA113Accident · Minor injuriesData collectionFinal reportCessna 172D · Bow, WAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection and failure to verify the fuel quantity on board.NTSB ANC08LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to maintain directional control during the landing flare/touchdown, which resulted in a runway excursion and collapse of the nose gear.NTSB SEA07CA168Accident · No injuriesData collectionFinal reportCessna 172D · Halls Crossing, UTThe pilot's failure to select suitable terrain for landing. A contributing factor was the rough/uneven terrain.NTSB DFW07CA070Accident · Minor injuriesData collectionFinal reportCessna 172B · Stephenville, TXThe loss of engine power during the landing approach due to the pilot's failure to follow the appropriate procedures to preclude carburetor ice in known carburetor icing conditions.NTSB SEA07LA052Accident · No injuriesLimited investigationFinal reportCessna 172D · Beaver Marsh, ORThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC06CA107Accident · No injuriesData collectionFinal reportCessna 172D · Lumberton, NJThe student pilot's failure to maintain aircraft control while landing, which resulted in an runway overrun and subsequent impact with terrain.NTSB SEA04FA191Accident · 1 fatalField investigationFinal reportCessna 172D · Mountain Home, IDThe pilot's failure to maintain clearance from high terrain while maneuvering. High terrain was a factor.NTSB SEA04CA141Accident · No injuriesData collectionFinal reportCessna 172D · Morton, WAThe pilot's misjudgment of altitude on final approach which resulted in an improper touchdown point and subsequent runway overrun. A factor was sunglare.NTSB MIA03LA099Accident · No injuriesLimited investigationFinal reportCessna 172D · South Ponotoc, MSthe pilot's failure to maintain altitude and aircraft control during a low pass over a grass runway, which resulted in the airplane impacting the ground.NTSB NYC02LA024Accident · No injuriesLimited investigationFinal reportCessna 172D · Argyle, NYThe pilot's failure to maintain aircraft control while maneuvering.NTSB CHI99LA320Accident · Serious injuriesLimited investigationFinal reportCessna 172D · South Wayne, WIthe pilot's improper selection of an emergency field and failure to maintain clearance from the trees. The cause of the loss of engine power was not determined.NTSB FTW99LA167Accident · No injuriesLimited investigationFinal reportCessna 172D · Jonesboro, ARThe pilot's inadequate preflight planning and preparation, and her delayed aborted takeoff. Factors were the high density altitude and the tall grass on the airstrip.NTSB SEA99LA059Accident · No injuriesLimited investigationFinal reportCessna 172D · Glenns Ferry, IDThe failure of both pilots to see-and-avoid wires crossing the river. Factors included: transmission wires; inattention of both pilots to the aircraft's flight path; and the pilots' low-altitude flight.NTSB FTW99LA091Accident · No injuriesLimited investigationFinal reportCessna 172D · Homer, LAThe loss of engine power due to fuel starvation, as a result of fuel moving away from the fuel supply outlets. Factors were the low fuel level and the turbulence.NTSB SEA98LA189Accident · No injuriesLimited investigationFinal reportCessna 172D · Ronan, MTThe pilot's failure to attain adequate airspeed during liftoff from a soft field takeoff. Factors include high density alttiude.NTSB NYC98LA195Accident · No injuriesLimited investigationFinal reportCessna 172D · Louisville, KYThe student pilot's failure to perform a preflight inspection of the airplane before his first solo flight, and inadequate supervision by the certified flight instructor, which resulted in fuel exhaustion.NTSB IAD98LA064Accident · No injuriesLimited investigationFinal reportCessna 172D · Beverly, MAfailure of the pilot to maintain control of the airplane during the landing and attempted go-around. A related factor was the crosswind.NTSB FTW98LA133Accident · No injuriesLimited investigationFinal reportCessna 172D · El Paso, TXThe pilots improper compensation for the wind conditions and his failure to maintain control of the aircraft. A factor was the high wind condition.NTSB CHI96LA350Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Germantown Hill, ILthe pilot's inadequate fuel supply and his misjudging distance and altitude. The trees were a factor.NTSB MIA96LA143Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Vilarica, GAThe student pilot's failure to maintain airspeed (VSO) during a go-around resulting in an in-flight loss of control (inadvertent stall), and subsequent in-flight collision with terrain. Contributing to the accident was the pilot's improper use of flaps.NTSB CHI96LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Camp Lake, WIFailure of the pilot to maintain clearance from trees that were located beside the runway.NTSB ATL96LA060Accident · No injuriesLimited investigationFinal reportCessna 172D · Macon, GAThe pilot's improper planning/decision, which resulted in fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB MIA96FA089Accident · 2 fatalField investigationFinal reportCessna 172D · Hawthorne, FLthe pilot's failure to maintain the proper glidepath during an instrument approach.NTSB LAX96FA121Accident · 3 fatalField investigationFinal reportCessna 172D · Julian, CAthe pilot's continued VFR flight into instrument meteorological conditions which resulted in an inadvertent stall/spin. The pilot's inadequate preflight/preparation, low clouds, fog, and mountain obscuration were factors in the accident.NTSB BFO96LA041Accident · No injuriesLimited investigationFinal reportCessna 172D · Rineyville, KYthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA023Accident · No injuriesLimited investigationFinal reportCessna 172D · Pryor, OKThe high wind and the pilot's poor judgment in attempting the flight.NTSB FTW95LA391Accident · No injuriesLimited investigationFinal reportCessna 172D · Prim, ARThe loss of engine power for undetermined reasons. Factors were the pilot's inability to initiate a flare due to the fracture of the yoke assembly, and the lack of suitable terrain for the forced landing.NTSB BFO95LA076Accident · No injuriesLimited investigationFinal reportCessna 172D · Hague, VAFailure of the pilot to maintain proper alignment with the runway during the landing. Factors relating to the accident were: the crosswind and the proximity of tall corn (crop) to the narrow runway.NTSB SEA95LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Twisp, WAThe improper installation of a nose landing gear assembly bolt (no cotter key installed) by unknown maintenance personnel. This led to a failure of the nose landing gear steering and subsequent noseover during landing rollout.NTSB FTW95FA349Accident · 4 fatalField investigationFinal reportCessna 172D · Tsaile, AZThe pilot's failure to maintain terrain clearance. Factors were the pilot's lack of mountain flying experience and the rising terrain.NTSB SEA95LA071Accident · No injuriesLimited investigationFinal reportCessna 172D · Lake Oswego, ORThe pilot's improper touchdown on the surface of the water.
Back to Cessna 172D