Cessna 172I
NTSB investigations · 235
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 ('2072426')
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 ('2072426')
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 ERA25LA138Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Knoxville, TNThe student pilot’s failure to maintain clearance from a truck while taxiing.NTSB WPR25LA040Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172I · Mayer, AZThe accumulation of carburetor ice, which resulted in a loss of engine power and a subsequent forced landing.NTSB WPR25LA037Accident · No injuriesClass 3 · LimitedFinal reportCessna 172I · Los Angeles, CAA partial loss of engine power due to carburetor ice accumulation.NTSB ERA24LA289Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Lewiston Woodville, NCThe obstruction of the engine’s cooling system by foreign object debris (residential-type insulation), which resulted in smoke, an elevated oil temperature, and a subsequent off-airport landing on unsuitable terrain.NTSB CEN24LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Ada, OKThe student pilot’s failure to maintain directional control during landing resulting in a runway excursion and impact with a sign.NTSB CEN24LA123Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Clarion, IAThe pilot’s failure to maintain directional control during the landing flare in a crosswind with gusts.NTSB CEN22LA398Accident · No injuriesClass 3 · LimitedFinal reportCessna 172I · Olivet, MIThe pilot’s failure to attain/maintain a proper glidepath that resulted in a hard landing and impact with the runway.NTSB ERA22LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Westminster, MDThe student pilot’s failure to attain the proper touchdown point which resulted in a runway overrun.NTSB WPR22LA161Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172I · Blanding, UTThe pilot’s improper landing flare which, resulted in a bounced landing and loss of airplane control during an aborted landing in gusty wind conditions.NTSB WPR21LA295Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Renton, WAThe boat operator’s failure to remain a safe distance from the floatplane during the takeoff run, which resulted in a collision.NTSB WPR21LA067Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Dillon, MTThe student pilot’s exceedance of the airplane’s critical angle attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB CEN20LA392Accident · 3 fatalClass 3 · LimitedFinal reportCessna 172 · Cottage Grove, MNA steep descent and impact with terrain for reasons that could not be determined based on the available information.NTSB ANC17LA028Accident · Minor injuriesClass 2 · LimitedFinal reportCessna 172 · Chugiak, AKThe pilot's improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA16CA333Accident · Minor injuriesData collectionFinal reportCessna 172 · Anthony, NMThe pilot's failure to maintain clearance from a cable while maneuvering at a low altitude over water, which resulted in a collision with a cable and impact with water.NTSB ERA15CA113Accident · No injuriesData collectionFinal reportCessna 172I · Nashua, NHThe student pilot's lack of vigilance during taxi, which resulted in a collision with a parked truck. A factor in the accident was the truck operator's decision to park on the edge of an active taxiway.NTSB ERA14CA206Accident · No injuriesData collectionFinal reportCessna 172I · Huntsville, ALThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ANC12CA022Accident · No injuriesData collectionFinal reportCessna 172I · McCarthy, AKThe pilot lost directional control during landing.NTSB ERA12LA148Accident · No injuriesLimited investigationFinal reportCessna 172I · Springfield, TNThe pilot did not apply carburetor heat during approach to landing, which resulted in a total loss of engine power due to carburetor icing.NTSB ERA10CA078Accident · No injuriesData collectionFinal reportCessna 172 · Panancea, FLThe pilot's failure to maintain directional control during the landing rollout.NTSB CEN09CA139Accident · No injuriesData collectionFinal reportCessna 172I · Rockford, ILThe pilot's inability to maintain directional control during the landing roll after contacting a low-lying snow bank that was obscured by drifting snow.NTSB ERA09CA077Accident · No injuriesData collectionFinal reportCessna 172I · Frederick, MDThe student pilot's delayed decision to abort the landing.NTSB CEN09CA072Accident · No injuriesData collectionFinal reportCessna 172I · Osh Kosh, NEThe pilot's failure to maintain control of the airplane while taxing in strong winds.NTSB CHI08FA033Accident · 1 fatalField investigationFinal reportCessna 172I · Gladwin, MIThe pilot's failure to maintain aircraft control while maneuvering at a low altitude. Contributing to the accident was the pilot's diverted attention while attempting to photograph ground objects.NTSB CHI07CA134Accident · Minor injuriesData collectionFinal reportCessna 172I · Shelby, OHThe pilot's failure to properly achieve the correct touch down point which resulted in a runway over run and subsequent nose over into a ditch. Other factors were the pilot's improper decision to land with a tailwind and the ditch.NTSB SEA07CA109Accident · Minor injuriesData collectionFinal reportCessna 172I · Peach Springs, AZThe pilot's failure to adequately compensate for the gusty wind condition encountered on final approach, resulting in a loss of control and an in-flight collision with a dirt berm. A contributing factor was the gusty wind condition.NTSB DFW05FA111Accident · 2 fatalField investigationFinal reportCessna 172 · Midland, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the low altitude.NTSB SEA05CA080Accident · No injuriesData collectionFinal reportCessna 172 · Yamhill, ORThe pilot's failure to maintain aircraft control while on final approach for landing. A crosswind, a fence post and the pilot's inadequate compensation for the crosswind condition were contributing factors.NTSB DEN04FA104Accident · 2 fatalField investigationFinal reportCessna 172I · Paris, ARthe pilot's inadequate preflight preparation, his attempted flight into adverse weather conditions, and his failure to maintain clearance from the trees resulting in the airplane's collision with the trees and subsequent impact with the ground. Factors…NTSB LAX02LA274Accident · No injuriesLimited investigationFinal reportCessna 172I · Tucson, AZthe certified flight instructor's failure to maintain an adequate distance from a jet during taxi. A factor was the local/ground controller's failure to issue a safety alert or cautionary advisory to the pilot with regards to the jet blast of the departing…NTSB LAX02LA136Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lake Los Angele, CAa reconditioned engine cylinder barrel failure due to previous rust damage and improper maintenance practices.NTSB NYC01LA080Accident · No injuriesLimited investigationFinal reportCessna 172I · Suffolk, VAThe pilot's improper in-flight planning/decision and his failure to refuel, which resulted in fuel exhaustion.NTSB SEA00LA187Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberg, ORThe pilot's failure to maintain a proper glide path on final approach. Factors include a vehicle on the roadway and a downdraft.NTSB SEA00LA125Accident · No injuriesLimited investigationFinal reportCessna 172I · Sandy, ORThe pilot's failure to attain the proper touchdown point for landing, and his failure to go around from the improperly executed approach. Factors included the pilot's failure to attain the proper glidepath on the approach, a short landing runway, and…NTSB NYC00LA011Accident · No injuriesLimited investigationFinal reportCessna 172I · N. East Carry, METhe pilot's decision to attempt a takeoff under gusty wind and rough water conditions.NTSB DEN99LA067Accident · No injuriesLimited investigationFinal reportCessna 172I · Las Cruces, NMThe pilot of N46204's failure to maintain visual lookout and to identify the other aircraft visually during landing.NTSB ANC99LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Bethel, AKThe pilot's attempted flight into adverse weather. Factors associated with the accident were the pilot's inadequate evaluation of the weather conditions, icing conditions, and an inadvertent stall.NTSB CHI99LA028Accident · No injuriesLimited investigationFinal reportCessna 172I · Jacksonville, ILthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the student's lack of experience and the road which the airplane contacted.NTSB LAX98FA141Accident · 2 fatalField investigationFinal reportCessna 172 · Ramona, CAThe loss of control of the aircraft on final approach for undetermined reasons.NTSB MIA98LA126Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Mallards Ldg, GAA deer on the runway which led to the pilot's evasive manuever to avoid the deer.NTSB MIA98LA104Accident · No injuriesLimited investigationFinal reportCessna 172I · Kinston, NCthe pilot's inadequate preflight and improper fuel management, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Soft terrain in the emergency landing area was a related factor.NTSB MIA98LA026Accident · Serious injuriesLimited investigationFinal reportCessna 172I · Cummings, GAthe pilot landed the airplane with a tailwind condition, too long and too fast for the runway conditions.NTSB NYC97FA186Accident · 1 fatalField investigationFinal reportCessna 172 · Normalville, PAthe pilot's inadequate clearance above an unlighted ridgeline in clouds and fog at night, and his decision to not file an IFR flight plan and his VFR flight into IMC conditions.NTSB SEA97LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Naches, WAinadequate preflight by the pilot, and subsequent fuel exhaustion, which led to a forced landing and subsequent nose over of the aircraft. Related factors were: the FBO did not refuel the aircraft as requested, and soft terrain was encountered during the…NTSB ATL97LA081Accident · No injuriesLimited investigationFinal reportCessna 172I · N. Myrtle Beach, SCThe pilot's inadequate pre-flight inspection which resulted in fuel exhaustion and total loss of engine power. A factor was the soft terrain at the emergency landing site.NTSB CHI94LA261Accident · No injuriesLimited investigationFinal reportCessna 172 · Aberdeen, SDthe pilot's failure to maintain directional control during landing. A related factor is the dark night conditions.NTSB CHI94FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172I · Kalamazoo, MIUndetermined.NTSB CHI94LA033Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Moberly, MOthe failure of the pilot-in-command to use all of the available runway.NTSB NYC93LA171Accident · No injuriesLimited investigationFinal reportCessna 172 · Phillips, METhe pilot's inadequate preflight and inflight decision which resulted in fuel exhaustion and the loss of engine power.NTSB CHI93FA139Accident · 2 fatalField investigationFinal reportCessna 172I · Ettrick, WIAn inflight explosion of a toluene-based fluid inside the airplane's cockpit.NTSB FTW92LA225Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Victoria, TXBlocked engine assembly breather tube and the pilot's continued operation with known maintenance discrepancies. Factors were oil on windsheild and reduced visibility due to oil on the windscreen..
Back to Cessna 172I