NTSB investigations: Cessna 172M
30 cases on aircraft the registry lists as Cessna 172M, where the sequence of events included Abnormal runway contact. 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
| 2009 | 2 |
|---|---|
| 2010 | 1 |
| 2012 | 4 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 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 ('2072418')
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\" = '090' 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 ('2072418')
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" = '090' 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 CEN26LA138Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Solon Springs, WIThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB WPR25LA296Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Albany, ORThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing.NTSB ERA24LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Shelbyville, TNThe student pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB ERA23LA375Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Winston-Salem, NCThe pilot’s loss of directional control upon landing which resulted in substantial damage to the left wing and left horizontal stabilizer.NTSB ERA23LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Toughkenamon, PAThe solo student pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in substantial damage to the airplane.NTSB CEN22LA329Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Saint Joseph, ILThe pilot’s failure to remain clear of obstacles while landing.NTSB WPR22FA022Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Ukiah, CAA power interruption due to water-contaminated fuel, which resulted in the student pilot aborting the takeoff and landing hard. Contributing to the accident were a leak in the left fuel tank that allowed water to enter and damage to the fuel tank that…NTSB CEN20CA351Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Conway, ARThe pilot’s improper recovery from a bounced landing.NTSB ERA20CA235Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Chesapeake, VAThe student pilot's improper landing flare and failure to recover from the ensuing bounced landing, which resulted in a runway excursion.NTSB ERA20CA227Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Churchville, MDThe student pilot's improper landing flare and improper recovery from a bounced landing in gusty wind conditions, which resulted in a hard landing.NTSB GAA19CA311Accident · No injuriesData collectionFinal reportCessna 172 · Culpeper, VAThe student pilot's improper landing flare, which resulted in a porpoised landing.NTSB GAA18CA201Accident · Minor injuriesData collectionFinal reportCessna 172 · Livermore, CAThe student pilot’s failure to maintain runway centerline and flight instructor’s delayed remedial action during landing.NTSB GAA17CA556Accident · No injuriesData collectionFinal reportCessna 172 · Gallatin, TNThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA17CA448Accident · No injuriesData collectionFinal reportCessna 172 · Manassas, VAThe student pilot’s improper landing flare, which resulted in a porpoised landing.NTSB GAA17CA394Accident · No injuriesData collectionFinal reportCessna 172 · TamuningThe pilot's improper landing flare, which resulted in a porpoised landing.NTSB GAA17CA079Accident · No injuriesData collectionFinal reportCessna 172 · Dayton, TNThe student pilot’s inability to maintain pitch and bank control during the landing after the airplane was struck by a deer.NTSB GAA17CA080Accident · No injuriesData collectionFinal reportCessna 172 · Woodbine, NJThe student pilot's improper landing flare, which resulted in a porpoised landing.NTSB GAA16CA361Accident · No injuriesData collectionFinal reportCessna 172 · Lancaster, OHThe pilot's improper landing flare in gusting wind conditions, which resulted in a hard landing.NTSB ERA16CA222Accident · No injuriesData collectionFinal reportCessna 172M · Lenoir, NCThe student pilot’s failure to compensate for gusting wind conditions during landing, which resulted in a bounced landing. Contributing to the accident was the flight instructor’s inadequate review of the weather conditions with the student and his inadequate…NTSB GAA15CA290Accident · No injuriesData collectionFinal reportCessna 172M · Shiocton, WIThe pilot's decision to continue to land at an unlighted airstrip, at night, after the landing light failed on approach, which resulted in a bounced landing, runway excursion, and collision with terrain.NTSB GAA15CA049Accident · No injuriesData collectionFinal reportCessna 172M · Clearwater, FLThe pilot's excessive airspeed during landing, which resulted in abnormal runway contact, a runway excursion, and substantial damage to the airplane.NTSB WPR15CA069Accident · No injuriesData collectionFinal reportCessna 172M · ObyanThe student pilot's loss of airplane control during the landing flare in gusting wind conditions.NTSB ERA15CA033Accident · No injuriesData collectionFinal reportCessna 172M · Apopka, FLThe student pilots improper landing flare which resulted in a hard landing and loss of aircraft control. Contributing to the accident was the flight instructor's delayed remedial actions.NTSB CEN13CA112Accident · No injuriesData collectionFinal reportCessna 172M · Eveleth, MNThe student pilot’s improper landing flare, which resulted in a hard nosewheel landing.NTSB ERA12LA539Accident · No injuriesLimited investigationFinal reportCessna 172M · Canadensis, PAThe pilot’s failure to attain a proper glidepath.NTSB CEN12LA408Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Griswold, IAThe pilot’s failure to maintain adequate airspeed during an attempted go-around, resulting in an aerodynamic stall.NTSB WPR12CA079Accident · No injuriesData collectionFinal reportCessna 172M · Richland, WAThe student pilot's improper landing flare and inadequate directional control during landing.NTSB WPR10CA323Accident · No injuriesData collectionFinal reportCessna 172M · Twin Falls, IDThe student pilot's improper landing flare.NTSB CEN10CA075Accident · No injuriesData collectionFinal reportCessna 172 · Pearland, TXThe student pilot's failure to control the airplane's descent rate during the short-field landing, resulting in a hard landing. Contributing to the accident was the flight examiner's delayed response.NTSB CEN09CA140Accident · No injuriesData collectionFinal reportCessna 172M · Little Rock, ARThe loss of engine power due to the missing nut on the bolt connecting the throttle cable and carburetor's lever arm.