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 LAX03LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · Early, TXThe student pilot's inadequate in-flight planning/decision, which resulted in a loss of engine power while on approach to land, and subsequent off-airport landing.NTSB ATL03LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bristol, TNThe pilot's improper use of the rudder controls during the takeoff roll resulting in a loss of directional control, and the on-ground collision with an embankment.NTSB FTW03LA100Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, TXThe pilot's inadequate preflight planning and preparation for the flight which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA03LA038Accident · No injuriesLimited investigationFinal reportCessna 172K · Melbourne, FLThe failure of the pilot of the North American AT6A, N57318 to maintain a proper visual lookout while taxiing, which resulted in him impacting the rear of the Cessna 172K, N522F.NTSB NYC03LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Prestonsburg, KYThe loss of oil pressure for undetermined reasons, which resulted in a failure of connecting rod end bolts, due to an over temperature condition.NTSB CHI03LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Neenah, WIThe pilot failed to maintain clearance from the post. Factors included the post and the sun glare.NTSB IAD02LA080Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Patuxent River, MDThe pilot's inadequate fuel calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB DEN02FA084Accident · 1 fatalField investigationFinal reportCessna 172K · Greeley, COthe student pilot's improper handling of the airplane's controls (for reason undetermined), and the inadequate supervision of the flight instructor. A contributing factor was the high density altitude weather condition.NTSB SEA02LA099Accident · No injuriesLimited investigationFinal reportCessna 172K · Clarkston, WAThe pilot's failure to maintain control of the aircraft during taxi along the gravel landing site after having landed off the designated runway. A contributing factor was the embankment which the aircraft's left wing impacted during taxi.NTSB LAX02LA172Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Lake Thomas A., CAa partial loss of engine power due to the partial malfunction of the left magneto and leakage of the ignition leads for that magneto, due to inadequate maintenance inspections. Factors in the accident include the high density altitude, the maintenance…NTSB DEN02LA045Accident · No injuriesLimited investigationFinal reportCessna 172K · Cedar City, UTthe pilot's inadvertent stall/mush during the landing flare/touchdown. A contributing factor was the gusty crosswind weather conditions.NTSB DEN02FA017Accident · 1 fatalField investigationFinal reportCessna 172K · Boulder, COthe pilot's intentional suicidal flight into terrain. Contributing factors were the pilot's psychological depressive state, and his use of inappropriate medication.NTSB ANC01LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Wasilla, AKThe pilot's delay in aborting the takeoff roll.NTSB NYC01LA110Accident · No injuriesLimited investigationFinal reportCessna 172K · Honesdale, PAThe pilot's loss of directional control during the landing roll. A factor was gusting winds.NTSB CHI01LA107Accident · No injuriesLimited investigationFinal reportCessna 172K · Holland, MIThe pilot failed to maintain directional control of the airplane. Factors included the soft ground and the runway lights.NTSB CHI01FA064Accident · 2 fatalField investigationFinal reportCessna 172K · Martinsville, INThe pilots decision not to fly to the alternate airport, his decision to continue the flight in known adverse weather conditions, spatial disorientation by the pilot, and his failure to maintain aircraft control. Factors were the low ceilings, the dark night,…NTSB SEA01LA036Accident · No injuriesLimited investigationFinal reportCessna 172K · Troutdale, ORThe pilot's failure to adequately compensate for wind conditions while taxiing the airplane.NTSB FTW01LA022Accident · No injuriesLimited investigationFinal reportCessna 172K · Belcher, LAthe total loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive to carburetor icing and the lack of suitable terrain available for the forced landing.NTSB NYC01LA038Accident · No injuriesLimited investigationFinal reportCessna 172K · Hagerstown, MDThe pilot's failure to remove the gust lock from the control column before takeoff, and his failure to abort the takeoff.NTSB ATL01LA006Accident · No injuriesLimited investigationFinal reportCessna 172K · Indiantown, FLThe pilot had excessive airspeed, misjudged the landing distance, and did not perform a go-around, which resulted in a nose over. The ditch was a contributing factor.NTSB SEA00LA194Accident · No injuriesLimited investigationFinal reportCessna 172K · Burns, ORThe separation of a portion of one propeller blade as a result of a fatigue crack that initiated at the site of foreign object damage to the blade.NTSB LAX00LA335Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Novato, CAFailure of the student pilot to maintain directional control of the airplane during the landing rollout resulting in a collision with a berm.NTSB NYC00LA236Accident · No injuriesLimited investigationFinal reportCessna 172K · Warwick, RIThe pilot's delayed recovery from a bounced landing.NTSB LAX00LA289Accident · No injuriesLimited investigationFinal reportCessna 172K · Palo Alto, CAThe pilot of the other airplane's (Cessna) inadequate visual lookout and misjudged distance to the standing Beech.NTSB DEN00LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Orchard, COThe pilot inadvertently stalling the airplane. A factor was his failure to maintain sufficient airspeed.NTSB MIA00FA103Accident · 4 fatalField investigationFinal reportCessna 172K · Sarasota, FLThe failure of the supervisor/ground controller and the local controller to provide effective separation between the accident airplanes on the runway, resulting in a collision during takeoff. Contributing to the accident was the failure of the pilot and…NTSB FTW00LA088Accident · No injuriesLimited investigationFinal reportCessna 172K · Alpine, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.NTSB FTW99LA260Accident · No injuriesLimited investigationFinal reportCessna 172K · Mountain Home, ARThe pilot's failure to obtain runway alignment. Factors were the dark night conditions, an embankment, and the pilot's lack of total experience flying at night.NTSB CHI99LA333Accident · No injuriesLimited investigationFinal reportCessna 172K · Pickrell, NEthe loose oil dipstick guide tube resulting in loss of oil and the engine failure. The night condition was a contributing factor.NTSB ANC99LA098Accident · No injuriesLimited investigationFinal reportCessna 172 · Sheldon Point, AKThe pilot's inadequate compensation for the gusty crosswind conditions during takeoff. Factors associated with the accident were a crosswind, and wind gusts.NTSB LAX99LA252Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Taft, CAThe pilot's selection of the wrong runway in consideration of the wind conditions and his subsequent failure to maintain directional control. The pilot's decision to abort the landing attempt with inadequate runway remaining for the takeoff phase was also…NTSB NYC99FA107Accident · 1 fatalField investigationFinal reportCessna 172K · Shirley, NYThe pilot's loss of control of the airplane due to intoxication. A factor was the pilot's self-induced pressure to conduct the flight.NTSB MIA99LA084Accident · No injuriesLimited investigationFinal reportCessna 172K · Marathon, FLThe pilot's improper use of elevator control while landing in gusty winds resulting in the aircraft nosing down and the propeller and wing contacting the runway.NTSB IAD99LA001Accident · No injuriesLimited investigationFinal reportCessna 172K · Middlefield, OHThe pilot's inadequate preflight inspection which resulted in fuel exhaustion.NTSB NYC98LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Chateaugay, NYBinding in the control yoke for undetermined reasons.NTSB CHI98LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · Eagle River, WIthe pilot failed to compensate for the wind conditions, improperly executed a go-around when he raised the flaps, and failed to maintain obstacle clearance with the trees.NTSB FTW98LA137Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Marietta, OKThe pilot's improper compensation for the wind conditions. A factor was the crosswind.NTSB NYC98FA063Accident · 1 fatalField investigationFinal reportCessna 172K · Boxborough, MAThe failure of the pilot to remove the frost on the wings before departure, which resulted in a stallNTSB IAD98LA025Accident · No injuriesLimited investigationFinal reportCessna 172K · Oxford, MAThe pilot's failure to maintain directional control.NTSB LAX97FA331Accident · 1 fatalField investigationFinal reportCessna 172K · Sandy Valley, NVthe pilot's intentional VFR flight into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from mountainous/hilly terrain. Related factors were: the high/mountainous/hilly terrain, and the adverse weather condition (low…NTSB MIA97WA220Accident · 1 fatalForeign investigationCessna 172K · Normans Cay, BahamasNTSB CHI97LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Olathe, KSthe pilot's improper inflight planning/decision and exceeding the airplane recommended crosswind component. Factors associated with this accident were the weather conditions of a high wind, gusts, and a crosswind.NTSB FTW97LA145Accident · No injuriesLimited investigationFinal reportCessna 172K · Glenwood Spgs, COThe pilot's failure to maintain airplane directional control, and his use of excessive rudder control.NTSB FTW97LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Telluride, COThe pilot's misjudged landing flare and his improper bounced landing recovery technique. A factor was the snow bank.NTSB NYC96LA189Accident · No injuriesLimited investigationFinal reportCessna 172K · Deal, NJthe pilot's improper decision/planning, which resulted in fuel exhaustion and a subsequent forced landing.NTSB ANC96LA112Accident · No injuriesLimited investigationFinal reportCessna 172K · Nikiski, AKThe pilot's inadequate compensation for wind conditions. A factor was the windshear.NTSB NYC96LA154Accident · No injuriesLimited investigationFinal reportCessna 172K · West Milford, NJthe pilot's failure in attaining the proper touchdown point, and his delay in initiating a go-around (aborted landing).NTSB IAD96LA118Accident · No injuriesLimited investigationFinal reportCessna 172 · Frederick, MDthe private pilot's inadvertently stalling the airplane immediately after takeoff. A related factor was the pilot's improper procedures during lift-off.NTSB NYC96LA124Accident · No injuriesLimited investigationFinal reportCessna 172 · Gardner, MAthe pilot 's misjudgment of speed and distance during landing.NTSB MIA96LA145Accident · No injuriesLimited investigationFinal reportCessna 172K · Englewood, FLFailure of the pilot-in-command to maintain visual lookout while taxiing to takeoff resulting in an on-ground collision with a tree.
Back to Cessna 172K