Cessna 172N
NTSB investigations · 1,815
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 ('2072434')
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 ('2072434')
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 NYC92LA154Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Keene, NHAn inadvertent stall during flap retraction, following an aborted landing.NTSB LAX92LA342Accident · No injuriesLimited investigationFinal reportCessna 172 · Van Nuys, CAThe student pilot's improper use of the checklist to assure that the trim tab was in the proper position and failure to follow normal procedures and directives. Contributing to this accident was the pilot's lack of total experience, misreading of the trim…NTSB MIA92LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Panama City, FLThe pilot-in-command's failure to stand clear of the propeller as he rotated it by hand, resulting in the propeller rotating around due to engine compression, striking the pilot, causing him to lose his balance and fall to the ramp, resulting in serious…NTSB CHI92FAMS2Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Lake Michigan, MIUndetermined.NTSB CHI92LA207Accident · No injuriesLimited investigationFinal reportCessna 172N · Bates City, MOTotal failure of the airplane windshield.NTSB MIA92LA148Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sanford, FLInadequate visual lookout by both pilots, which resulted in their failure to see-and-avoid of the power line. The proximity of the power line was a related factor.NTSB CHI92FA201Accident · 4 fatalField investigationFinal reportCessna 172N · St Paul, MNInadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid conflicting traffic, and failure of the relieving controllers to use the radar display to identify and sequence an airplane entering the pattern.…NTSB CHI92LA199Accident · No injuriesLimited investigationFinal reportCessna 172N · Chesterfield, MOThe improper use of the aircraft brake system by the pilot in command.NTSB LAX92LA265Accident · No injuriesLimited investigationFinal reportCessna 172N · Hayward, CAThe student pilot's misjudging the landing flare, the cfi's delayed remedial action and his failure to adequately supervise the conduct of the flight.NTSB NYC92FA093Accident · 3 fatalField investigationFinal reportCessna 172N · Brookeville, MDImproper inflight planning/decision by the flight instructor (pic/cfi) in the Cessna 172, his misjudgement of distance between the two airplanes, and inadequate visual lookout by both pilots in the Cessna 172.NTSB BFO92LA081Accident · No injuriesLimited investigationFinal reportCessna 172M · Coatesville, PAThe passengers interference with the control yoke, which resulted in the airplane entering an unusual attitude, and the pilot overstressing the wings during the recovery.NTSB BFO92LA074Accident · Serious injuriesLimited investigationFinal reportCessna 172N · St Francis, MEFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. The wind condition was a related factor.NTSB ANC92FA069Accident · No injuriesField investigationFinal reportCessna 172 · Ruth Glacier, AKThe failure of the pilots of both airplanes to maintain an adequate visual lookout. Factors which contributed to the accident was the failure of the pilot of the CE-172 to become aware of and to use the listed frequency for inter aircraft communications, and…NTSB SEA92LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Parkdale, ORThe pilot's failure to use the proper touchdown point for landing. A factor relating to the accident was the soft dirt runway surface.NTSB SEA92LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Grants Pass, ORA failure to maintain runway alignment, and a delayed go-around. Factors include a crosswind, gusts, and a fence in the go-around path.NTSB NYC92LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bryan, OHThe failure of the student pilot to maintain directional control during landing roll. Factors related to the accident were: the pilot's lack of total experience and lack of recent experience.NTSB NYC92LA084Accident · No injuriesLimited investigationFinal reportCessna 172N · New Madison, OHThe pilot's failure to attain a proper touchdown point. Contributing to the accident was the pilot inadequately planned his approach and his failure to perform a go-around.NTSB NYC92LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Blaine Hill, PAA leaking fuel line which resulted in a power loss and inflight fire. A factor related to the accident was the rolling terrain.NTSB NYC92LA077Accident · No injuriesLimited investigationFinal reportCessna 172N · Sidney, OHThe failure of the pilot to maintain airplane directional control after landing, which resulted in a departure from the runway and encounter with rough terrain.NTSB LAX92FA164Accident · Serious injuriesField investigationFinal reportCessna 172N · Claremont, CAThe pilots improper preflight and inflight planning/decisions, his continued VFR flight into IMC conditions, and his failure to initiate timely remedial actions.NTSB LAX92LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Prescott, AZThe other airplane's flight instructor's poor supervision of the flight; the other airplane's flight instructor's and dual student's misidentification of the airplane the student pilot was following and the other airplane's flight instructor's and dual…NTSB MIA92LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · Orlando, FLThe pilots in command of both aircraft failure to maintain vigilance and see and avoid each other resulting in a midair collision. Contributing to the accident was the local controllers failure to issue traffic advisories.NTSB DEN92LA033Accident · No injuriesLimited investigationFinal reportCessna 172N · Parshall, COImproper use of powerplant controls by the duel student and inadequate supervision by the CFI. Factors were: carburetor heat not used, deep snow covered terrain, and carburetor ice conditions.NTSB FTW92LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during landing. A factor was his lack of total experience.NTSB LAX92LA089Accident · No injuriesLimited investigationFinal reportCessna 172N · Show Low, AZThe failure of the carburetor heat box attach straps which allowed the carburetor heat box to separate from the exhaust system heat muff and rendered the carburetor heat system inoperative. The engine then lost power due to carburetor ice.NTSB LAX92LA071Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZThe failure of the pilot to maintain an adequate visual lookout while taxiing the aircraft.NTSB MIA92LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Gulfport, MSFailure of the pilot-in-command to perform a go-around and inadvertent stall.NTSB CHI92FA059Accident · 4 fatalField investigationFinal reportCessna 172N · Cumberland, WIFailure to maintain aircraft control by the pilot in commnd. Factors in the accident are the pilot's continued flight into known adverse weather, a blocked pitot static system, lack of total expereince in type of operation, and lack of total expereince in…NTSB LAX92LA051Accident · No injuriesLimited investigationFinal reportCessna 172M · Saipan, SarkA loss of engine power due to carburetor icing and the failure of the pilot to correctly use carburetor heat.NTSB MIA92GA024Accident · 1 fatalFinal reportCessna 172N · Okeechobee, FLThe pilot-in-command's failure to maintain altitude during a low pass at night. Contributing factors were the pilot's likely spatial disorientation due to the lack of surface visual clues, the dark night conditions, and the patchy fog conditions.NTSB CHI92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bemidji, MNInadequate preflight planning and preparation by the pilot in command, the non performance o fan emergency procedure and not maintaining a positive rate of climb on behalf of the pilot in command. Factors contributing to the accident were the pilot in…NTSB SEA92FA013Accident · 3 fatalField investigationFinal reportCessna 172N · Columbus, MTThe pilot in command's operation at too low an altitude over the river and his failure to maintain adequate clearance from the power lines. Factors contributing to the accident were the wires crossing the river and the pilot in command's poor judgement in…NTSB NYC92LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Toledo, OHThe pilot's failure to preform an aircraft preflight, and remove the gust lock from the aileron, resulting in a loss of airplane control during initial climb.NTSB NYC92LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Auburn, METhe pilot was buzzing and stalled the airplane at too low an altitude to recover.NTSB LAX92LA003Accident · Minor injuriesLimited investigationFinal reportCessna C-172N · Palo Alto, CAAn inflight los of control due to the failure of the student pilot to correctly configure the rudder trim for takeoff.NTSB ATL91LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberry, SCThe pilot's failure to maintain visual lookout and clearance while maneuvering at a low altitude.NTSB ATL91LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe pilot's failure to accurately evaluate the weather conditions before attempting a takeoff and his delay in aborting the takeoff procedure. A factor was the dark night.NTSB SEA91LA253Accident · No injuriesLimited investigationFinal reportCessna 172N · Chiloquin, ORThe loss of engine power in flight due to improper maintenance inspections. A factor relating to the accident was the rough terrain at the accident site.NTSB LAX91LA404Accident · No injuriesLimited investigationFinal reportCessna 172 · Cottonwood, AZThe pilot-in-command's delay in raising the flaps and the subsequent inadvertent stall/mush.NTSB ATL91FA176Accident · 2 fatalField investigationFinal reportCessna C-172N · Alabaster, ALThe pilot's failure to maintain flying speed which resulted in an unintentional stall and collision with the ground. A factor was the pilot's use of unprescribed drugs.NTSB DEN91FA132Accident · 2 fatalField investigationFinal reportCessna 172N · Tererro, NMA failure of the pilot to maintain adequate obstacle clearance in mountainous terrain. Factors were: lack of familiarity with the aircraft, and insufficient standards by the operator.NTSB SEA91LA241Accident · No injuriesLimited investigationFinal reportCessna 172N · St George, UTImproper planning/decision by the student pilot. The crosswind and the student's lack of experience were related factors.NTSB LAX91LA383Accident · 3 fatalLimited investigationFinal reportCessna 172 · Arroyo Grande, CAThe pilot's failure to maintain a proper altitude, and continued flight into instrument meteorological conditions.NTSB SEA91LA228Accident · No injuriesLimited investigationFinal reportCessna 172N · Butte, MTUnfavorable winds. Factors to the accident were: inadequate weather evaluation and lack of total flight experience.NTSB MIA91LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lake City, FLThe pilot in command's failure to maintain airspeed during a demonstrated downwind soft field takeoff. This resulted in an in flight loss of control, stall, and collision with terrain.NTSB DEN91LA128Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe student pilot misjudged his landing flare. A factor was: the pilot's lack of experience.NTSB MIA91WA203Accident · No injuriesForeign investigationCessna 172N · Nassau, BahamasNTSB LAX91LA336Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe pilot's misjudged landing flare and his failure to maintain a proper go-around course over the runway.NTSB CHI91LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Sheboygan, WIThe pilot's failure to maintain aircraft control. Factors are the pilot's lack of total expereince, his inadequate recovery from the bounced landing and the crosswind condition.NTSB LAX91LA325Accident · No injuriesLimited investigationFinal reportCessna 172N · Napa, CAThe cfi's failure to initiate the go-around maneuver in a timely manner, and his failure to terminate the simulated emergency maneuver at a proper altitude. A contributing factor was the gusty surface wind.
Back to Cessna 172N