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 ERA13LA281Accident · 1 fatalLimited investigationFinal reportCessna 172K · Newton, MSThe student pilot's failure to increase engine power during the descent for landing when instructed to do so by the flight instructor and the flight instructor's delayed remedial action, which resulted in collision with a static wire. Contributing to the…NTSB CEN13CA222Accident · Minor injuriesData collectionFinal reportCessna 172 · Manvel, TXThe pilot’s failure to maintain airplane control while taking off in gusting wind conditions.NTSB ERA13CA181Accident · No injuriesData collectionFinal reportCessna 172 · Tistusville, FLThe pilot's loss of airplane control while taxiing in gusting wind conditions associated with nearby thunderstorm activity.NTSB ERA13FA062Accident · 1 fatalField investigationFinal reportCessna 172K · Savannah, GAThe pilot's failure to maintain airplane control while operating in night, instrument meteorological conditions, due to spatial disorientation.NTSB ANC12CA108Accident · No injuriesData collectionFinal reportCessna 172K · Atqasuk, AKThe student pilot's failure to maintain directional control while performing a high-speed taxi in windy conditions.NTSB CEN12CA422Accident · No injuriesData collectionFinal reportCessna 172K · Greers Ferry, ARThe pilot’s failure to maintain a positive rate of climb while taking off with a high density altitude.NTSB ERA12CA404Accident · No injuriesData collectionFinal reportCessna 172K · Tupelo, MSThe pilot's improper recovery from a bounced landing.NTSB ERA12LA241Accident · No injuriesLimited investigationFinal reportCessna 172K · Belfast, METhe flight instructor’s failure to ensure the radio was set correctly to activate the pilot-controlled lighting, which resulted in poor positioning for a proper landing and a subsequent off-runway forced landing during an attempted go-around. Contributing to…NTSB ERA12LA234Accident · No injuriesLimited investigationFinal reportCessna 172K · Pensacola, FLA total loss of engine power due to the improper installation of the crankshaft gear bolt or lockplate by maintenance personnel. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB WPR12CA049Accident · No injuriesData collectionFinal reportCessna 172K · Napa, CAThe student pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.NTSB ERA11CA441Accident · No injuriesData collectionFinal reportCessna 172K · Sylacauga, ALA stuck exhaust-valve on the number one cylinder which resulted in a loss of engine power.NTSB CEN11CA322Accident · No injuriesData collectionFinal reportCessna 172K · Farmersville, TXA loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB ERA11CA333Accident · No injuriesData collectionFinal reportCessna 172K · Bar Harbor, METhe pilot's inadequate landing flare while landing with a gusting wind, which resulted in a hard landing.NTSB CEN11CA257Accident · No injuriesData collectionFinal reportCessna 172K · San Antonio, TXThe student pilot's inadequate compensation for wind while landing in gusty wind conditions.NTSB ERA11CA181Accident · Minor injuriesData collectionFinal reportCessna 172K · Ocracoke, NCThe pilot’s inadequate flare and failure to regain control of the airplane while attempting to recover from bounced landing.NTSB CEN11LA073Accident · Serious injuriesLimited investigationFinal reportCessna 172K · San Antonio, TXThe pilot's failure to maintain aircraft control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to land with a tailwind.NTSB ERA10FA502Accident · 2 fatalField investigationFinal reportCessna 172 · Chatsworth, GAThe pilot's inadequate flight planning and in-flight fuel management resulting in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the operator's failure to ensure aircraft records pertaining to engine modifications and…NTSB CEN10CA405Accident · No injuriesData collectionFinal reportCessna 172K · Boyne City, MIThe pilot's failure to attain the proper touchdown point and delayed go-around.NTSB ERA10CA212Accident · Minor injuriesData collectionFinal reportCessna 172K · Romney, WVThe pilot's improper decision to land with a 20-knot tailwind and his failure to initiate a go-around, which resulted in a runway overrun.NTSB CEN09CA437Accident · No injuriesData collectionFinal reportCessna 172K · Pine River, MNThe student pilot's failure to maintain directional control during landing.NTSB MIA08CA182Accident · No injuriesData collectionFinal reportCessna 172K · Tunkhannock, PAThe pilot's improper airspeed while landing.NTSB LAX08FA256Accident · 5 fatalField investigationFinal reportCessna 172K · Gearhart, ORThe pilot's failure to maintain aircraft control during the initial climb after takeoff due to spatial disorientation.NTSB CHI08LA101Accident · 2 fatalLimited investigationFinal reportCessna 172K · Roseglen, NDThe pilot failed to maintain obstacle clearance from the TV antenna during a low altitude maneuver. Contributing factors were the antenna, the night conditions, and pilot impairment due to alcohol.NTSB ATL07CA117Accident · Minor injuriesData collectionFinal reportCessna 172K · Charlotte, NCThe pilot's failure to maintain directional control while landing.NTSB LAX07CA201Accident · No injuriesData collectionFinal reportCessna 172K · Newcastle, UTThe pilot's inadequate compensation for the gusty and crosswind condition, and his failure to maintain control of the airplane during takeoff.NTSB DFW07LA130Accident · No injuriesLimited investigationFinal reportCessna 172K · Amarillo, TXThe failure of the left main landing gear spring assembly as a result of an unapproved repair by an unknown person(s), which resulted in a loss of directional control during the landing roll.NTSB MIA07CA099Accident · No injuriesData collectionFinal reportCessna 172K · Emporia, VAThe failure of the student pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch.NTSB ATL07CA058Accident · No injuriesData collectionFinal reportCessna 172K · Cornelia, GAThe failure of the owner/operator to repair or replace a known leaking brake system components resulting in a total loss of brakes while taxing and an on-ground collision with trees.NTSB ATL07CA050Accident · Minor injuriesData collectionFinal reportCessna 172K · Paris, TNThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.NTSB DFW07LA082Accident · No injuriesLimited investigationFinal reportCessna 172K · Boerne, TXThe pilot of the other airplane's failure to maintain proper spacing during approach to landing and subsequent go-around, which resulted in a midair collision.NTSB ATL07FA038Accident · 2 fatalField investigationFinal reportCessna 172K · Bessemer, ALThe non-instrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions.NTSB CHI06CA185Accident · Minor injuriesData collectionFinal reportCessna 172K · Sullivan, ILThe pilot's misjudged flare and his improper recovery from the bounced landing which led to a loss of directional control and subsequent collision with crops and the ground.NTSB LAX06CA136Accident · No injuriesData collectionFinal reportCessna 172 · Wickenburg, AZthe pilot's failure to maintain directional control.NTSB NYC06CA013Accident · No injuriesData collectionFinal reportCessna 172K · West Milford, NJA loss of aircraft control as a result of the installation of an improper pilot seat which moved during the takeoff roll/run..NTSB ATL05CA107Accident · No injuriesData collectionFinal reportCessna 172 K · Panama City, FLThe pilot's inadequate planning of the fuel supply, which resulted in fuel exhaustion.NTSB LAX05LA124Accident · No injuriesLimited investigationFinal reportCessna 172K · Chino, CAthe pilot of the other airplane's failure to maintain an adequate clearance from obstacles while taxiing.NTSB CHI05CA075Accident · Serious injuriesData collectionFinal reportCessna 172K · Portage, WIThe pilot's failure to maintain adequate airspeed during the aborted landing, which resulted in an inadvertent stall at a low altitude. Factors to the accident were the pilot's lack of experience flying from the right pilot station and his failure to maintain…NTSB ATL05LA031Accident · No injuriesLimited investigationFinal reportCessna 172K · Smyrna, TNThe pilot's inadequate preflight planning of fuel required for the flight, and his inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB ATL05CA002Accident · Serious injuriesData collectionFinal reportCessna 172K · Knoxville, TNThe pilot's failure to maintain airspeed on initial take off climb resulted in an inadvertent stall and an uncontrolled descent into the ground.NTSB ANC04LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Yakutat, AKThe pilot's selection of an unsuitable landing area, which resulted in the collapse of the landing gear, and subsequent nose over during the landing roll. A factor associated with the accident was soft terrain.NTSB CHI04CA113Accident · Minor injuriesData collectionFinal reportCessna 172K · Harrisonville, MOThe dual student's failure to maintain directional control of the aircraft during the landing flare. Contributing factors were the dual student's failure to relinquish the controls to the flight instructor, the resulting inability of the flight instructor to…NTSB FTW04CA106Accident · No injuriesData collectionFinal reportCessna 172K · Bogalusa, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Angleton, TXThe unqualified person's failure to maintain clearance with the power lines. A contributing factor was the night light conditions.NTSB LAX04FA096Accident · 2 fatalField investigationFinal reportCessna 172K · Grass Valley, CAthe pilot's continued visual flight into instrument meteorological conditions and failure to maintain an adequate terrain/object clearance altitude. Also causal was the pilot's improper in-flight decision to return to the origin airport in the face of…NTSB FTW04LA063Accident · No injuriesLimited investigationFinal reportCessna 172K · Lake Charles, LAThe disintegration of the piston, which resulted in the catastrophic failure of the engine. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04FA045Accident · 2 fatalField investigationFinal reportCessna 172K · Grand Saline, TXThe pilot's failure to maintain control of the airplane while on final approach. Factors were the high winds and prevailing crosswind.NTSB NYC04CA028Accident · No injuriesData collectionFinal reportCessna 172K · Kilbourne, OHThe pilot's failure to obtain the proper touchdown point which resulted in an overrun and subsequent nose over.NTSB MIA03LA185Accident · No injuriesLimited investigationFinal reportCessna 172K · Ocean Springs, MSThe failure of the pilot to transfer fuel from the auxiliary fuel tank to the right main fuel tank in-flight resulting in total loss of engine power due to fuel starvation.NTSB NYC03LA139Accident · Minor injuriesLimited investigationFinal reportCessna 172K · White Marsh, MDThe pilot's in-flight decision to not land and refuel, which resulted in fuel exhaustion. A factor in the accident was the pilot's inadequate communications.NTSB LAX03CA208Accident · No injuriesData collectionFinal reportCessna 172K · Overton, NVthe student pilot's failure to maintain an adequate airspeed and his premature raising of the flaps during a go-around, which led to an inadvertent stall/mush. The flight instructor's inadequate supervision of the flight is also causal.
Back to Cessna 172K