Cessna 172K
NTSB investigations · 691
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 ('2072430')
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 ('2072430')
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 FTW96LA203Accident · No injuriesLimited investigationFinal reportCessna 172K · Leadville, COthe pilot's failure to adequately compensate for the wind conditions and to maintain directional control. Factors were: the gusting cross wind and the pilot's lack of total experience in make and model of aircraft.NTSB ATL96LA079Accident · No injuriesLimited investigationFinal reportCessna 172K · Lebanon, TNthe student pilot's failure to maintain directional control during landing.NTSB FTW96LA160Accident · No injuriesLimited investigationFinal reportCessna 172K · Danville, ARthe student pilot's inadequate compensation for the crosswind. Factors were the crosswind and the soft terrain.NTSB ATL96LA059Accident · No injuriesLimited investigationFinal reportCessna 172K · Asheville, NCfailure of the brake on the right main landing gear as a result of water (ice) in the brake fluid, which resulted in a loss of braking control.NTSB FTW96LA116Accident · No injuriesLimited investigationFinal reportCessna 172K · Hedley, TXthe failure of maintenance personnel to properly torque the connecting rod bolts. A factor was the lack of suitable terrain for the forced landing.NTSB SEA96LA041Accident · No injuriesLimited investigationFinal reportCessna 172K · Park City, MTInadequate visual lookout by the pilot, and his failure to maintain sufficient altitude/clearance from the transmission line.NTSB SEA96LA032Accident · No injuriesLimited investigationFinal reportCessna 172K · Owyhee, ORthe pilot's selection of unsuitable terrain for landing. The soft terrain and high vegetation were related factors.NTSB BFO96LA030Accident · No injuriesLimited investigationFinal reportCessna 172K · Lovingston, VAthe pilot's improper planning/decision during the approach/landing phase of flight. Related factors were: the pilot's selection of the wrong runway, and the gusty tailwind conditions.NTSB ANC95LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Gustavus, AKThe pilot's failure to maintain directional control. A factor relating to the accident was: the diminished nosewheel steering capability due to an overinflated nosewheel strut.NTSB CHI95LA088Accident · No injuriesLimited investigationFinal reportCessna 172 · Holland, MIdelayed remedial action by the flight instructor. Factors in the accident were the student pilot not maintaining directional control once airborne.NTSB MIA95LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Wrightsville, GAThe pilot-in-command's failure to maintain adequate airspeed while maneuvering in a turn. The low altitude at the time of the stall was a factor.NTSB CHI95LA070Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cottage Grove, WIThe pilot's selection of unsuitable terrain/runway for landing. Factors related to the accident were: the unfavorable wind, icy runway condition, and snowbank at the end of the runway.NTSB LAX95FA037Accident · 3 fatalField investigationFinal reportCessna 172K · Springerville, AZthe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall/spin. The pilot's diverted attention and overconfidence in the aircraft's ability to fly slow were factors in this accident.NTSB FTW94LA301Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Russellville, ARThe pilot's inadequate compensation for the crosswind during the takeoff ground roll. A factor was the crosswind.NTSB CHI94LA326Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brookfield, WIthe commercial pilot's poor planning/decision making. A related factor is the wet, grass runway selected for landing.NTSB SEA94FA225Accident · 2 fatalField investigationFinal reportCessna 172K · Laramie, WYThe pilot's failure to maintain clearance from terrain. Downdraft wind on the lee side of the ridgeline was a factor.NTSB ANC94LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Wrangell, AKLoss of engine power for undertermined reasons and the lack of a suitable landing area.NTSB CHI94LA251Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Rockford, MIthe student pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB SEA94FA182Accident · 1 fatalField investigationFinal reportCessna 172K · Patos Island, WAThe pilot's impairment of judgment and performance due to drugs (marijuana), and his improper planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from trees, while taking off toward the closed end of a cove.NTSB CHI94LA139Accident · No injuriesLimited investigationFinal reportCessna 172K · Howes, SDThe diverted attention of the pilot-in-command and his failure to maintain proper altitude.NTSB ATL94LA083Accident · No injuriesLimited investigationFinal reportCessna 172K · Spartanburg, SCThe inadequate visual lookout by the pilot of Cessna 172K, N711GT.NTSB NYC94LA060Accident · No injuriesLimited investigationFinal reportCessna 172K · Dayton, OHthe pilot's failure to maintain directional control which resulted in a runway overrun. Factors are the pilot's improper recovery from a bounced landing, and his lack of experience.NTSB MIA94LA074Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Culebra, PRThe failure of the pilot-in-command(CFI) to initiate a go-around after encountering severe turbulence during landing flare and his decision to raise the flaps and reduce engine power to idle after directional control was lost resulting in the aircraft…NTSB LAX94LA123Accident · Minor injuriesLimited investigationFinal reportCessna 172K · New Cuyama, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control of the aircraft.NTSB SEA94FA018Accident · 1 fatalField investigationFinal reportCessna 172K · North Bend, ORLoss of control while in flight due to pilot incapacitation from atherosclerotic heart disease.NTSB FTW94LA013Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, TXThe pilot's failure to follow proper emergency procedures to troubleshoot the electrical system. A factor was an electrical system irregularity of an undetermined nature.NTSB LAX93LA277Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Torrance, CAAn encounter with a windshear condition. The delayed banner jettison was a factor.NTSB ANC93LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Katmai, AKThe unsuitable terrain selected by the pilot-in-command. Factor was soft terrain condition.NTSB SEA93LA093Accident · No injuriesLimited investigationFinal reportCessna 172K · Pony, MTThe improper preflt planning by the PIC and his failure to attain takeoff airspeed during ground roll on a soft snow covered airstrip. A factor relating to the accident was the soft snow on the airstrip.NTSB CHI93LA096Accident · No injuriesLimited investigationFinal reportCessna 172K · Jackson, MIThe pilot's failure to maintain directional control.NTSB LAX93FA110Accident · 4 fatalField investigationFinal reportCessna 172K · Gorman, CAThe pilot's continued flight into known adverse weather conditions and continued visual flight into instrument meteorological conditionsNTSB ANC92LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Taylor Road, AKThe pilot's inadequate compensation for wind conditions. Factors contributing to the accident were the gusting crosswinds and the pilot's lack of total experience in this type operation.NTSB MIA92FA158Accident · 4 fatalField investigationFinal reportCessna 172K · Rockledge, FLFailure of the pilot to maintain adequate airspeed during the final approach resulting in an inadvertent stall. Contributing to the accident was the pilot's lack of recent experience in the type operation, lack of experience at the airport in the type…NTSB BFO92LA104Accident · No injuriesLimited investigationFinal reportCessna 172K · Piqua, OHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB LAX92LA281Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Agua Caliente, CAThe failure of the pilot to maintain an adequate approach airspeed and an inadvertent stall/mush condition which resulted in a collision with the ground short of the runway. A factor in the accident was the pilots lack of total experience in type of aircraft.NTSB LAX92LA072Accident · No injuriesLimited investigationFinal reportCessna 172K · Kamuela, HIThe pilots encounter with a wind gust beyond the ground handling capability of the aircraft and his failure to obtain preflight weather information.NTSB ATL91LA175Accident · No injuriesLimited investigationFinal reportCessna 172K · Greeneville, TNThe inadequate visual lookout by the pilot of N78239, and his failure to accurately judge the distance between the two aircraft. Factors in the accident were the dark night conditions and the resulting visual perception of aircraft lighting in dark conditions.NTSB LAX91FA386Accident · Serious injuriesField investigationFinal reportCessna 172K · Bullhead City, AZ1) A short circuit, 2) electrical overload which ignited the cabin interior, 3) inadequate electrical circuit protection, and 4) insufficient electrical system design standards.NTSB SEA91LA224Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Corbett, ORThe pilot's improper in-flight planning/decision, his delay in taking remedial action, and his failure to maintain clearance from trees on rising terrain. The weather and terrain conditions were related factors.NTSB FTW91LA157Accident · No injuriesLimited investigationFinal reportCessna 172K · Fisher, ARThe pilot's failure to use the aircraft performance data to compute the takeoff distance. A factor was the high density altitude.NTSB NYC91LA180Accident · No injuriesLimited investigationFinal reportCessna 172K · Old Bridge, NJThe failure of both pilots to maintain proper visual lookout. Factor related to the accident was inadequate radio communications by the pilots.NTSB MIA91LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Groveland, FLFailure of the pilot to maintain adequate airspeed resulting in inadvertent stall/mush.NTSB MIA91LA161Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, FLTotal loss of engine power due to fatigue failure of the oil cooler resulting in oil exhaustion. Contributing to the accident was lack of suitable terrain.NTSB MIA91LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bunnell, FLLoss of control in flight due to a foreign object which restricted the movement of the elevator flight control.NTSB CHI91LA109Accident · No injuriesLimited investigationFinal reportCessna 172K · Bridgman, MIThe pilot's failure to correct a descent. A factor in the accident was the pilot's maneuvering at an improper altitude.NTSB MIA91LA092Accident · No injuriesLimited investigationFinal reportCessna 172K · Everglades City, FLInformation given during a weather briefing was disregarded, in-flight encounter with wind gust, and failure of the pilot to execute a go-around. Contributing to the accident was inadequate placement of a windsock which was blocked by trees resulting in an…NTSB LAX91LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · Tonopah, NVThe airplane's encounter with a wind gust while taxiing from landing. Contributing factors related to the pilot's improper weather evaluation and his lack of experience in making weather evaluations.NTSB FTW91LA019Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Granbury, TXTotal loss of engine power due to fuel exhaustion. Factors were the pilot's improper fuel consumption calculations, and the darkness of the night.NTSB DEN90LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Grants, NMThe pilot's failure to maintain directional control.NTSB SEA90FA091Accident · 1 fatalField investigationFinal reportCessna 172K · Tacoma, WAThe pilot did not adequately maintain a proper glide path for landing which resulted in an inflight collision with a tree.
Back to Cessna 172K