NTSB investigations: Cessna 172R
39 cases on aircraft the registry lists as Cessna 172R, where the sequence of events included Runway excursion. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 4 |
| 2014 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 5 |
| 2020 | 1 |
| 2021 | 3 |
| 2024 | 3 |
| 2026 | 1 |
Where
Open the mapLatest cases
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 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 CEN24LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lincoln, NEThe student pilot’s failure to maintain directional control during 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 CEN24LA233Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Murphysboro, ILThe pilot’s failure to maintain directional control during landing.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 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 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 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 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 GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.NTSB GAA18CA276Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe pilot’s decision to take off with the airplane over its maximum gross weight due to his failure to perform preflight weight and balance calculations, which affected the airplane’s takeoff performance, and his subsequent decision to abort the takeoff with…NTSB GAA17CA482Accident · No injuriesData collectionFinal reportCessna 172 · Kearney, NEThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion.NTSB ERA17CA216Accident · No injuriesData collectionFinal reportCessna 172 · Emporia, VAThe student pilot's failure to maintain an adequate airspeed for landing and his improper landing flare and recovery from a bounced landing.NTSB GAA16CA194Accident · No injuriesData collectionFinal reportCessna 172 · Stillwater, OKThe student pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and collision with a runway distance remaining sign.NTSB GAA16CA114Accident · No injuriesData collectionFinal reportCessna 172 · Merritt Island, FLThe student pilot's improper flare which resulted in a porpoise, runway excursion, and nose over.NTSB WPR15CA018Accident · No injuriesData collectionFinal reportCessna 172 - R · Lake Havasu, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.NTSB CEN14LA333Accident · No injuriesLimited investigationFinal reportCessna 172R · Joplin, MOThe partial loss of engine power for reasons that could not be determined because an operational test run of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13CA529Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluff, IAThe student pilot's loss of directional control during takeoff.NTSB ERA13CA378Accident · Minor injuriesData collectionFinal reportCessna 172R · Shelter Island, NYThe pilot did not attain the proper touchdown point on the runway, which resulted in a runway excursion.NTSB ERA13CA189Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot's failure to maintain directional control during the landing roll.NTSB CEN13CA151Accident · No injuriesData collectionFinal reportCessna 172 · Murphysboro, ILThe pilot’s failure to maintain control of the airplane during the takeoff roll.NTSB CEN12CA526Accident · Minor injuriesData collectionFinal reportCessna 172R · Leesville, LAThe student pilot's failure to properly re-configure the airplane for a go-around, which resulted in a runway excursion when he decided to land on the remaining runway.NTSB ERA12CA330Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot’s failure to maintain directional control during a touch-and-go landing.NTSB CEN12CA213Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluffs, IAThe student pilot’s improper flare and inadequate recovery from a bounced landing, which resulted in a loss of directional control.NTSB ERA12LA061Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Frederick, MDThe student pilot’s inadequate directional control during the landing roll.NTSB ERA11CA490Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe student pilot's improper flare, which resulted in a hard landing and subsequent loss of directional control.NTSB WPR11CA194Accident · No injuriesData collectionFinal reportCessna 172R · Othello, WAThe pilot's failure to maintain directional during the landing roll.NTSB CEN11CA171Accident · No injuriesData collectionFinal reportCessna 172R · Shreveport, LAThe student pilot's loss of directional control during the landing.NTSB CEN10CA144Accident · Minor injuriesData collectionFinal reportCessna 172R · Newark, OHThe pilot's failure to maintain directional control during takeoff.NTSB WPR10CA098Accident · Minor injuriesData collectionFinal reportCessna 172R · Ramona, CAThe pilot's failure to maintain directional control during a touch-and-go landing.NTSB WPR09CA233Accident · No injuriesData collectionFinal reportCessna 172R · Coeur d'Alene, IDThe student pilot's inadequate compensation for the crosswinds while landing.NTSB ERA09CA110Accident · No injuriesData collectionFinal reportCessna 172R · Morristown, NJThe flight instructor's failure to execute a missed approach when insufficient runway remained for landing. Contributing to the accident were the low ceiling and visibility conditions.NTSB CEN09CA002Accident · No injuriesData collectionFinal reportCessna 172 · Alton, ILThe student pilot's failure to maintain directional control during landing. A contributing factor was the presence of the sign struck during the runway excursion.NTSB CHI08LA096Accident · No injuriesLimited investigationFinal reportCessna 172R · Monroe, WIThe pilot's decision to land on the wrong runway for the existing wind conditions and his improper recovery from a bounced landing.NTSB CHI08CA091Accident · No injuriesData collectionFinal reportCessna 172R · Batavia, OHThe pilot's misjudgment of the landing flare and her inadequate recovery from the bounced landing.