Cessna 172R
NTSB investigations · 228
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 ('2072401')
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 ('2072401')
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 WPR26LA365Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172R · Ho'olehua, HINTSB ERA26LA248Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe student pilot’s failure to ensure clearance while taxiing, which resulted in contact with another airplane that was performing an engine run-up.NTSB ERA26LA227Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Maiden, NCThe flight instructor’s inadequate preflight planning, which resulted in a rejected takeoff from a tailwind departure and subsequent runway excursion.NTSB ERA26LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Boca Raton, FLThe low-wing pilot’s inadequate visual lookout, which resulted in a collision with another airplane while taxiing.NTSB CEN25LA350Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Ardmore, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB ERA25LA323Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Spring Hill, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and substantial damage to the airplane’s fuselage.NTSB ERA25LA117Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Fort Myers, FLThe student pilot’s failure to maintain clearance from a truck while taxiing.NTSB CEN24LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lincoln, NEThe student pilot’s failure to maintain directional control during landing.NTSB ERA24LA364Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Louisa, VAThe pilot’s improper landing flare which resulted in a hard landing.NTSB CEN24LA263Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lockhart, TXThe pilot’s decision to continue the landing attempt with insufficient runway remaining, which resulted in a runway overrun.NTSB CEN24LA349Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Hooper, NEThe solo student pilot’s unstable approach to the runway, which resulted in a hard, bounced landingNTSB CEN24LA233Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Murphysboro, ILThe pilot’s failure to maintain directional control during landing.NTSB CEN24FA218Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Gainesville, TXThe fuel pump manufacturer’s improper torquing of screws on the engine-driven fuel pump, which resulted in a disruption in the fuel system and a loss of engine power on initial climb.NTSB CEN24LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Riesel, TXAn in-flight collision with a bird.NTSB CEN24LA003Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Arlington, TXA reported loss of engine power during the landing approach due to undetermined reasons, which resulted in a forced landing and collision with a fence.NTSB WPR23LA357Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot’s loss of airplane control during takeoff, which resulted in a bounced landing and impact with the airport’s windsock.NTSB CEN23LA292Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Burlington, VTThe student pilot’s improper landing flare, which resulted in a hard, bounced landing and the flight instructor’s delayed remedial action.NTSB WPR23LA216Accident · No injuriesClass 3 · LimitedFinal reportCessna 172R · Santa Monica, CAA failure of the nose wheel upper torque link bolt, which resulted in a loss of steering control. Contributing to the accident were maintenance personnel’s failure to inspect and replace the fractured bolt and the pilot’s oversight of the bolt during his…NTSB ERA23LA259Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Miami, FLThe pilot's improper landing flare, which resulted in substantial damage the airplane’s fuselage.NTSB CEN23LA256Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Romeoville, ILThe student pilot’s failure to attain/maintain a proper landing flare and failure to perform a go-around that resulted in an impact with the runway.NTSB ERA22LA385Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kissimmee, FLThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the nose landing gear impacting the runway.NTSB ERA22LA280Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Owensboro, KYThe student pilot's improper flare, which resulted in a loss of control during landing.NTSB WPR22LA167Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot's improper landing flare and remedial action which resulted in a bounced landing.NTSB CEN22LA170Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Houston, TXThe student pilot’s failure to maintain direction control during takeoff in gusty wind conditions.NTSB CEN22LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Chesterfield, MOThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard, bounced landing and the nose landing gear collapsing. .NTSB ANC21LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Birchwood, AKThe flight instructor’s inadequate supervision of the student pilot, and student pilot’s improper landing flare, resulting in a hard landing.NTSB ERA21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Louisville, KYA loss of directional on takeoff for reasons that could not be determined.NTSB WPR21LA269Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Petaluma, CAThe pilot’s improper landing flare which resulted in a hard landing following a partial loss of electrical power. Contributing to the accident was the pilot’s distraction and hampered visual function.NTSB WPR21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 172R · Missoula, MTThe pilot’s failure to maintain airspeed and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB ERA21LA249Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Groton, CTThe pilot’s failure to maintain directional control of the airplane during landing, resulting in a runway excursion and collision with an airport sign.NTSB WPR21LA193Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172R · Chandler, AZThe pilot’s failure to locate the airport which resulted in an approach to a road and subsequent collision with powerlines during a go-around in low light conditions.NTSB ERA21LA119Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lawrenceville, GAThe pilot's failure to maintain directional control during landing in a gusting crosswind, which resulted in a loss of control and runway excursion.NTSB ANC21LA010Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172R · Hope, AKThe pilot’s selection of unsuitable terrain for landing. A factor was the certified flight instructor’s selection of unsuitable terrain for landing.NTSB CEN21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Columbus, MSThe pilot’s failure to maintain directional control during a touch-and-go landing.NTSB CEN20LA429Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Higginsville, MOThe airplane’s collision with a deer on the runway during takeoff at night.NTSB WPR20CA219Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Concord, CAThe student pilot's failure to maintain airplane control when the airplane drifted off of runway centerline and subsequently collided with a taxiway sign during a go-around.NTSB ERA20CA250Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Auburn, METhe student pilot's improper landing flare, which resulted in a hard landing on the nosegear and nosegear collapse.NTSB WPR20CA167Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Las Vegas, NVThe student pilot's failure to maintain directional control of the airplane during a soft-field takeoff and the flight instructor's delayed remedial action.NTSB GAA19CA472Accident · No injuriesData collectionFinal reportCessna 172 · Mt. Sterling, KYThe pilot's loss of directional control during the takeoff roll due to distraction by the passenger window being unsecured, which resulted in a runway excursion and impact with a runway distance marker. Contributing to the accident was pilot’s failure to…NTSB GAA19CA440Accident · No injuriesData collectionFinal reportCessna 172 · Denver, COThe student pilot's failure to maintain lateral control during a soft-field takeoff, which resulted in the left wing striking the runway and a runway excursion.NTSB CEN19FA212Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Oxford, MSThe student pilot's failure to maintain airplane control during a go around with a tailwind, which resulted in an uncontrolled descent and impact with terrain.NTSB GAA19CA368Accident · No injuriesData collectionFinal reportCessna 172 · Tulsa, OKThe pilot's failure to maintain directional control while landing in gusting crosswind conditions, which resulted in a runway excursion and impact with a taxiway sign.NTSB GAA19CA326Accident · No injuriesData collectionFinal reportCessna 172 · Orlando, FLThe student pilot's excessive rudder application during takeoff and the flight instructor's delayed remedial action, which resulted in a loss of directional control, a runway excursion, and subsequent substantial damage.NTSB GAA19CA162Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe student pilot's failure to maintain the runway heading during a go-around with a crosswind, which resulted in the left main landing gear impacting a runway sign.NTSB GAA19CA151Accident · No injuriesData collectionFinal reportCessna 172 · Morristown, NJThe student pilot's improper rudder input and the flight instructor's delayed remedial action during takeoff, which resulted in a loss of directional control, a runway excursion, and the landing gear collapsing.NTSB GAA19CA130Accident · No injuriesData collectionFinal reportCessna 172 · Hanover, VAThe student pilot's improper decision to release the seat latch to adjust the seat position during taxi, which resulted in his inability to reach the rudder or brake pedals and a subsequent loss of directional control and impact with a ditch and fence.NTSB GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.NTSB CEN18CA323Accident · No injuriesData collectionFinal reportCessna 172 · Greeley, COThe pilot’s and safety pilot's conflicting control inputs during landing, which resulted in their failure to maintain a proper airspeed and resulted in an aerodynamic stall. Contributing to the accident was the lack of communication between the pilot and…NTSB GAA18CA464Accident · No injuriesData collectionFinal reportCessna 172 · Spring, TXThe student pilot’s improper landing flare in a crosswind, which resulted in a hard landing.NTSB WPR18FA195Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Deer Park, WAAn in-flight breakup as a result of the airplane exceeding the structural strength of the airplane during a rapid descent that the flight instructor was unable to recover from following a collision with a large bird.
Back to Cessna 172R