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 DEN91LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Watkins, COThe pilot selected the wrong runway and landed with a tailwind.NTSB NYC91LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln Park, NJThe decision of the pilot to discontinue a go-around, from an attempted landing, resulting in the airplane striking trees. A factor related to the accident was the lack of total flight experience of the student pilot.NTSB NYC91LA186Accident · No injuriesLimited investigationFinal reportCessna 172N · Columbus, OHThe failure of the pilot to maintain an adequate visual lookout which resulted in a ground collision with a parked aircraft. Factors related to the accident was the failure of the pilot to taxi on the taxiway centerline and night conditions.NTSB LAX91LA312Accident · No injuriesLimited investigationFinal reportCessna 172N · Mariposa, CAThe pilot misjudging his planned approach. A down-sloping runway surface was a factor in the accident.NTSB MIA91LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Rontonda West, FLThe failure of the pilot-in-command to maintain an adequate visual lookout which caused him to fly the airplane into wires.NTSB SEA91LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Waldron, WAVisual lookout was not maintained, and diverted attention.NTSB NYC91LA166Accident · Minor injuriesLimited investigationFinal reportCessna C-172 · Clarence Center, NYFailure of the pilot to maintain airspeed during a heavy weight takeoff, resulting in a stall and landing in rough terrain.NTSB MIA91LA173Accident · No injuriesLimited investigationFinal reportCessna 172N · Punta Gorda, FLFailure of the pilot to observe the windsock before landing resulting in failure to maintain directional control after landing with a quartering tailwind. The airplane collided with a ditch. Contributing to the accident was lack of total experience of the…NTSB DEN91LA085Accident · No injuriesLimited investigationFinal reportCessna 172J · Rifle, COThe student pilot improperly flared the aircraft during landing.NTSB LAX91LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Thermal, CAThe partial failure of the engine/powerplant from a worn intake valve and the failure of company/operator management to perform an overhaul on the engine within the time frame recommended by the engine manufacturer.NTSB CHI91LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chicago, ILThe pilot in command (student)'s improper judgement of the proper touchdown point. A factor contributing was the pilot in command's delaying an aborted landing.NTSB ANC91LA062Accident · No injuriesLimited investigationFinal reportCessna 172-N · Egegik, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was the high winds.NTSB NYC91LA138Accident · No injuriesLimited investigationFinal reportCessna 172N · Canadensis, PAThe pilot's improper planning/decision. A factor related to the accident was the downhill slope of the runway.NTSB BFO91FA049Accident · 1 fatalField investigationFinal reportCessna 172N · Lebanon, NHThe pilot's failure to maintain adequate terrain clearance. Contributing was mountainous terrain, low clouds, and VFR flight into IMC.NTSB NYC91LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Meadville, PAThe improper use of carburetor heat control by the pilot, which resulted in the total loss of engine power and the subsequent emergency forced landing in rough terrain. A factor relating to the accident was the lack of experience of the student pilot.NTSB LAX91LA183Accident · No injuriesLimited investigationFinal reportCessna 172N · Grass Valley, CAThe failure of the pilot to maintain directional control and to adequately compensate for the wind conditions resulting in an on ground loss of control and subsequent on ground collision with a drainage ditch.NTSB FTW91LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Huntsville, TXThe pilot's failure to maintain directional control of the airplane. A factor was the emphasis placed upon full-stall landings by his instructor.NTSB ATL91FA084Accident · 2 fatalField investigationFinal reportCessna 172N · Dunlap, TNThe pilot-in-command's inadequate preflight planning/preparation, his attempted VFR flight into IFR conditions, and his subsequent failure to maintain a proper altitude. Factors in the accident were: the mountainous terrain, the foggy, low ceiling conditions…NTSB FTW91LA065Accident · No injuriesLimited investigationFinal reportCessna 172N · Weatherford, OKThe inadvertent stalling of the airplane. A factor was the gusty wind.NTSB SEA91LA084Accident · No injuriesLimited investigationFinal reportCessna C-172N · Ellensburg, WAThe improper maintenance inspection of the airccraft. A factor relating to the accident was a ditch in the ladning area.NTSB LAX91LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Stockton, CAThe installation by maintenance personnel of an incorrect gasket that resulted in the loss of the engine magneto.NTSB CHI91LA124Accident · Minor injuriesLimited investigationFinal reportCessna C172N · North Liberty, INThe pilot's inadvertent touchdown and inadequate remedial action. Related factors are the low pass maneuver, and the soft terrain.NTSB NYC91LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, METhe engine lost power for an undetermined reason.NTSB MIA91LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Clewiston, FLMisjudged wind direction resulting in incorrect runway selection and failure by the PIC to initiate a go-around after landing with a tailwind. Contributing to the accident was the lack of the pilot's total experience.NTSB BFO91LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Hagerstown, MDWorn camshaft lobes which resulted in the loss of engine power.NTSB MIA91LA099Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Panama City, FLCarburetor icing due to improper use of carburetor heat by the pilot, resulting in a forced landing and ditching.NTSB CHI91DCJ01Accident · 1 fatalFinal reportCessna 172N · Western, NESpatial disorientation which resulted in a loss of aircraft control. A factor related to the accident was VFR flight into IMC.NTSB FTW91FA042Accident · 1 fatalField investigationFinal reportCessna 172N · Thornton, TXThe pilot's decision to fly into known adverse weather and the wet microburst. A factor was his disregard for the forecast.NTSB LAX91LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · San Carlos, CAThe pilot's improper flare landing.NTSB CHI91LA084Accident · No injuriesLimited investigationFinal reportCessna 172N · Rochester, MNInadequate compensation or wind conditions, and failure to maintain directional control by the pilot. Factors related to the accident are lack of total experience, and the crosswind conditions.NTSB CHI91LA081Accident · No injuriesLimited investigationFinal reportCessna 172N · Lansing, ILInadequate compensation for wind conditions and failure to maintain directional control. A factor related to the accident is the snow covered runway.NTSB LAX91LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Ukiah, CAThe failure of the pilot to maintain an adequate clearance from ground obstructions. A factor in the accident was: failure of the pilot to maintain an altitude sufficient to clear all obstructions along his route of flight.NTSB LAX91LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Tucson, AZBoth pilots used poor visual lookout procedures.NTSB LAX91LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Yucca Valley, CAThe pilot's improper use of the flaps. Contributing to this accident was the loss of control during tailwind landing, and his tailwind and the pilot's inadequate inflight planning.NTSB FTW91LA020Accident · No injuriesLimited investigationFinal reportCessna 172N · Plano, TXThe pilot's failure to follow the approved start procedures which resulted in an induction fire and the destruction of the airplane.NTSB MIA91LA038Accident · No injuriesLimited investigationFinal reportCessna 172N · Vero Beach, FLThe failure of the pilot to perfrom a proper landing flare and touchdown resulting in a hard landing.NTSB ATL91LA023Accident · No injuriesLimited investigationFinal reportCessna 172N · Chamblee, GAPilot's failure to maintain adequate wingtip clearance during taxi.NTSB CHI91LA023Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Scott, KSThe mixture control was set incorrectly resulting in fuel starvation, and the check list was not followed by the cfi/pic.NTSB BFO91LA009Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Elkton, VAThe pilot's failure to use carburetor heat which resulted in a reduction in engine power. A factor was the rough terrain.NTSB FTW91LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Abilene, TXPilot's failure to compensate for gusty wind condition.NTSB CHI91LA017Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Portage, WIThe PIC became lost and disorientated and performed a premature precautionary landing.NTSB FTW91LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Prairie, TXThe student pilot's improper flare technique and use of rudder.NTSB NYC91LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Dayton, OHA carburetor fire due to an engine backfire. A factor relating to the accident was improper remedial action taken by the pilot to extinguish the engine fire.NTSB ATL91LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAThe student pilot's failure to maintain directional control during a takeoff attempt. Factors to the accident were the student's overall lack of flight experience, and the reported wind gust.NTSB SEA90LA199Accident · 2 fatalLimited investigationFinal reportCessna 172N · Neilton, WAThe failure of the crew to maintain adequate clearance from the terrain. Factors to the accident were mountainous and box canyon terrain.NTSB LAX90LA333Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Reno, NVThe pilot's failure to maintain sufficient airspeed resulting in an inadvertent stall. A factor in the accident was the strong crosswind conditions.NTSB LAX90LA337Accident · No injuriesLimited investigationFinal reportCessna 172 · Fresno, CAThe pilot misjudged the flare altitude and failed to properly recover from a bounced landing.NTSB CHI90FA263Accident · 2 fatalField investigationFinal reportCessna 172N · Paris, ILThe pilot's continuation of VFR flight into instrument meteorological conditions. Factors contributing to the accident were the fog and the dark night.NTSB SEA90LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Dillon, MTPilot misjudged the flare that resulted in a bounced landing.NTSB CHI90FA252Accident · 1 fatalField investigationFinal reportCessna 172N · Pine City, MNThe pilot's misjudgement of the fuel supply, and his failure to maintain adequate airspeed. A factor was the pilot's lack of experience in the make and model of aircraft.
Back to Cessna 172N