Cessna 172P
NTSB investigations · 844
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 ('2072436')
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 ('2072436')
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 ATL05CA125Accident · No injuriesData collectionFinal reportCessna 172P · Monroeville, ALThe student pilot's failure to maintain directional control and the subsequent collision with the ground during landing.NTSB CHI05CA150Accident · No injuriesData collectionFinal reportCessna 172P · St. Francis, KSThe pilot's failure to compensate for the crosswind conditions during landing and the unsuccessful go-around. A factor was the crosswind.NTSB NYC05LA123Accident · No injuriesLimited investigationFinal reportCessna 172P · Islip, NYThe pilot's failure to maintain clearance from a parked vehicle while taxiing.NTSB NYC05CA082Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's improper flare and recovery from a bounced landing.NTSB CHI05CA095Accident · No injuriesData collectionFinal reportCessna 172P · Ann Arbor, MIThe failure of the carburetor nozzle resulting in loss of engine power and the unsuitable terrain encountered during the forced landing. A factor was the low altitude.NTSB ATL05CA062Accident · Minor injuriesData collectionFinal reportCessna 172P · Redstone Arsnl, ALThe pilot's failure to maintain adequate airspeed during approach, which resulted in an inadvertent stall and subsequent collision with the runway. Factors were the turbulence and crosswind conditions.NTSB MIA05CA061Accident · No injuriesData collectionFinal reportCessna 172 · Brooksville, FLThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.NTSB IAD05CA037Accident · No injuriesData collectionFinal reportCessna 172P · Cross Keys, NJThe pilots failure to maintain directional control. Factors contributing to the accident were the pilots lack of experience, and the snow bank.NTSB DFW05CA046Accident · No injuriesData collectionFinal reportCessna 172P · Houston, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the muddy condition of the terrain.NTSB DEN05LA031Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe student pilot's failure to maintain directional control during landing.NTSB DEN05LA037Accident · No injuriesLimited investigationFinal reportCessna 172P · Loveland, COthe student pilot's failure to maintain directional control during landing and the student pilot's inadequate in-flight planning and decision making. Contributing factors include the quartering tail wind, the high airspeed, and the airport sign.NTSB SEA05FA013Accident · 1 fatalField investigationFinal reportCessna 172P · Olympia, WAThe pilot's failure to maintain clearance from terrain while maneuvering in known adverse weather conditions. Clouds, rain, high wind, dark night, trees, mountainous terrain and the pilot's inadequate in-flight planning/decision were factors.NTSB DEN04LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Spanish Fork, UTthe pilot's improper inflight planning and decision making, and his failure to maintain terrain clearance. Contributing factors were his intentional low altitude flight and maneuvering, the aircraft's climb performance being exceeded, and the trees.NTSB DEN04FA119Accident · 2 fatalField investigationFinal reportCessna 172P · Monarch Crest, COthe pilot's failure to maintain airspeed which resulted in a stall, and his decision to conduct flight beyond the performance capability of the aircraft. A contributing factor was the high density altitude, and an inadvertent stall.NTSB LAX04CA282Accident · No injuriesData collectionFinal reportCessna 172P · Big Bear City, CAthe instructor's inadequate compensation for wind conditions and delayed decision to perform a go-around. Contributing factors were wind gusts, windshear, and an excessive descent rate.NTSB ATL04CA133Accident · No injuriesData collectionFinal reportCessna 172 · Kennesaw, GAThe student pilot's failure to maintain directional control during landing roll that resulted in the on ground collision with the ground, and the subsequent collapse of the nose gear.NTSB ATL04CA131Accident · No injuriesData collectionFinal reportCessna 172 · Meridianville, ALThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with the ground.NTSB DEN04TA088Accident · Serious injuriesFinal reportCessna C172P · Las Cruces, NMthe pilot's failure to maintain clearance from terrain and the improper go-around procedure. Contributing factors include the pilot's diverted attention, improper in-flight planning and decision making, pilot fatigue, the night conditions and the mesquite…NTSB CHI04CA136Accident · No injuriesData collectionFinal reportCessna 172P · Milwaukee, WIThe CFI failed to maintain adequate airspeed during the go-around which resulted in an inadvertent stall.NTSB FTW04LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesquite, TXThe student pilot's delayed landing flare and the improper supervision provided by the flight instructor.NTSB SEA04LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Battle Ground, WAThe student pilot's misjudgment of distance and his failure to do a go-around. Also causal was the instructor's inadequate supervision of the flight. Factors include gusty crosswinds, the dual student's failure to adequately compensate for those winds, a wet…NTSB CHI04CA114Accident · No injuriesData collectionFinal reportCessna 172P · Schaumburg, ILThe student pilot not maintaining directional control during the takeoff roll and his inadequate remedial action.NTSB NYC04CA102Accident · No injuriesData collectionFinal reportCessna 172P · Westfield, MAThe student pilot's improper flare and his failure to maintain aircraft control while landing.NTSB NYC04CA089Accident · No injuriesData collectionFinal reportCessna 172P · Zelienople, PAThe pilot's improper recovery from a bounced landing.NTSB ANC04LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Clewiston, FLThe student pilot's misjudged landing flare, which resulted in a hard landing, a collapse of the nose wheel landing gear, and the airplane nosing over when it encountered a ditch.NTSB LAX04CA098Accident · No injuriesData collectionFinal reportCessna 172P · Granada Hills, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB LAX04LA053Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fountain Hills, AZThe flight instructor's delayed remedial action and inadequate altitude during a go-around following a simulated forced landing, which resulted in an in-flight collision with terrain.NTSB ATL04LA013Accident · No injuriesLimited investigationFinal reportCessna 172P · Pell City, ALThe pilot's inadequate compensation for wind and his failure to maintain directional control during landing. A factor was the crosswind.NTSB MIA03TA175Accident · Serious injuriesFinal reportCessna 172P · Jay, FL**This case was modified on 2/18/2016. Refer to the public docket for this accident to view the changes.** Loss of engine power for undetermined reasons.NTSB CHI03LA280Accident · No injuriesLimited investigationFinal reportCessna 172P · Wichita, KSFailure of the maintenance crew to provide adequate clearance to an active taxiway during the engine run-up. Contributing factors were the failure of the control tower to provide a wake turbulence advisory to the accident aircraft when assigning a taxi route…NTSB NYC03CA167Accident · No injuriesData collectionFinal reportCessna 172P · Plainfield, CTThe pilot's failure to maintain directional control, which resulted in a collision with a ditch. A factor in this accident was the crosswind condition.NTSB CHI03LA229Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntingburg, INThe pilot's inadequate flare and the failure to perform a go-around during landing. The planned approach with a quartering tailwind were contributing factors.NTSB MIA03LA143Accident · No injuriesLimited investigationFinal reportCessna 172P · Plymouth, FLThe pilot's continue operation with known deficiencies (engine vibration) resulting in a partial loss of engine power during climb after takeoff and overrun of the runway during the aborted takeoff.NTSB DEN03LA132Accident · No injuriesLimited investigationFinal reportCessna 172P · Watkins, COthe right seat shifting aft during the take off roll, rendering aircraft control not possible by the flight instructor. Contributing factors include the inboard seat pin which did not engage fully, the outboard seat pin which was installed incorrectly, the…NTSB CHI03LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Pinckneyville, ILThe planned approach not maintained by the pilot and the delayed remedial action by the certified flight instructor. A contributing factor to the accident was the approach light.NTSB ANC03LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Seldovia, AKThe failure of company maintenance personnel to properly maintain the airplane's brake system, which resulted in a loss of the right brake during landing roll due to a chafed brake line.NTSB SEA03LA103Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe dual student's failure to maintain aircraft control and the flight instructor's delayed remedial action. Contributing factors were the crosswind condition and the flight instructor's lack of experience.NTSB CHI03FA151Accident · 2 fatalField investigationFinal reportCessna 172P · Sheboygan, WIThe pilot failed to maintain control of the airplane after encountering instrument meteorological conditions during takeoff. Factors associated with the accident were the low ceiling, fog and lack of instrument rating.NTSB FTW03LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Gainesville, TXThe pilot's failure to maintain directional control while landing. Contributing factors were the prevailing crosswind and the pilot's failure to abort landing.NTSB ATL03LA097Accident · No injuriesLimited investigationFinal reportCessna 172P · Newnan, GAThe pilot's failure to maintain directional control during the landing roll that resulted in the collapse of the right main landing gear.NTSB MIA03LA100Accident · No injuriesLimited investigationFinal reportCessna 172P · Lantana, FLthe pilot's use of excessive airspeed and the improper touchdown point during the landing roll, which resulted in the airplane departing the runway, and impacting with trees.NTSB DEN03LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Colo. Springs, COthe student pilot's failure to obtain and maintain adequate altitude during the go-around. Factors contributing to the accident were the encountered windshear, the student pilot's premature raising of the flaps, the instructor pilot's inadequate supervision,…NTSB LAX03FA124Accident · 2 fatalField investigationFinal reportCessna 172P · North Las Vegas, NVthe applicant pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall/spin.NTSB LAX03LA117Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Van Nuys, CAthe pilot's failure to maintain directional control during an aborted landing. A contributing factor is the pilot's improper recovery from a bounced landing.NTSB MIA03LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Potts Camp, MSThe pilot's inadequate planning which resulted in fuel exhaustion, a forced landing to a field, and damage to the airplane during the landing rollout.NTSB NYC03LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Linden, NJThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Factors in the accident were the crosswind and the snowbank.NTSB ATL03LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NCThe pilot's improper flare during touchdown and failure to properly recover from a bounced landing, which resulted in a loss of control and inflight collision with the runway. A factor was the pilot did not understand the porpoise condition during landing.NTSB MIA03FA066Accident · 1 fatalField investigationFinal reportCessna 172P · Osteen, FLThe intentional suicidal act by the pilot-in-command resulting in the in-flight collision with trees then the ground.NTSB LAX03FA090Accident · Serious injuriesField investigationFinal reportCessna 172P · Santa Susana, CAThe flight instructor's inadequate in-flight decision to cross mountainous terrain at a inadequate altitude to guarantee terrain clearance.NTSB DEN03MA035Accident · 5 fatalMajor investigationFinal reportCessna 172P · Denver, COBoth pilots' inadequate visual lookout. A contributing factor was the Cheyenne pilot operating the airplane with a known transponder deficiency.
Back to Cessna 172P