NTSB investigations: Cessna 172S
42 cases on aircraft the registry lists as Cessna 172S, where the defining event was 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 | 4 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 4 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 8 |
| 2017 | 5 |
| 2018 | 5 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 2 |
| 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 ('2072439', '2072442')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '090'))
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 ('2072439', '2072442')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '090'))
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 CEN26LA133Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Denver, COThe solo student pilot's improper landing flare and subsequent improper recovery from a bounced landing which resulted in substantial damage to the airplane.NTSB ERA25LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and substantial damage to the airplane’s fuselage.NTSB ERA24LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Elizabeth City, NCThe pilot’s improper flare and subsequent improper recovery from a bounced landing.NTSB ERA24LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Zelienople, PAThe pilot’s inadequate compensation for the gusting crosswind condition during landing.NTSB CEN23LA159Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Fredericksburg, TXThe pilot’s failure to maintain airplane control during an attempted go-around resulting in abnormal contact with the runway pavement and a runway excursion.NTSB ERA23LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Sanford, FLThe pilot's unstable approach, which resulted in a hard landing and impact with a runway threshold light. Also causal was the flight instructor’s failure to take remedial action to prevent the hard landing.NTSB WPR22LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · San Carlos, CAThe pilot’s improper landing flare which resulted in a bounced landing.NTSB ERA22LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Palm Coast, FLThe student pilot’s improper landing flare and subsequent improper recovery from a bounced landing, resulting in a hard landing and substantial damage to the lower fuselage and firewall.NTSB GAA19CA076Accident · No injuriesData collectionFinal reportCessna 172 · Ogden, UTThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA18CA340Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, TXThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent porpoise.NTSB GAA18CA348Accident · No injuriesData collectionFinal reportCessna 172 · Orlando, FLThe pilot’s improper landing flare, which resulted in a bounced, hard landing.NTSB GAA18CA294Accident · No injuriesData collectionFinal reportCessna 172 · Palo Alto, CAThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA143Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot’s improper approach and landing flare, which resulted in a porpoised landing.NTSB GAA18CA085Accident · No injuriesData collectionFinal reportCessna 172 · Park Rapids, MNThe student pilot’s improper landing flare, which resulted in the propeller striking the ground.NTSB GAA18CA045Accident · No injuriesData collectionFinal reportCessna 172 · Trenton, NJThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA17CA470Accident · No injuriesData collectionFinal reportCessna 172 · Carlsbad, CAThe student pilot’s improper landing flare in gusting wind conditions.NTSB GAA17CA312Accident · No injuriesData collectionFinal reportCessna 172 · El Cajon, CAThe student pilot's incorrect landing flare, which resulted in the airplane porpoising upon touchdown.NTSB GAA17CA300Accident · No injuriesData collectionFinal reportCessna 172 · Clarksville, TNThe pilot’s unstabilized approach and improper landing flare, which resulted in a hard, porpoised landing.NTSB GAA17CA104Accident · No injuriesData collectionFinal reportCessna 172 · Palm Coast, FLThe student pilot’s improper landing flare, which resulted in a hard landing and porpoise.NTSB ERA17LA026Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fort Lauderdale, FLThe pilot’s improper landing flare in gusting crosswind conditions, which resulted in a nose landing gear collapse.NTSB GAA16CA421Accident · No injuriesData collectionFinal reportCessna 172 · Oak Island, NCThe pilot's failure to maintain pitch control during the landing flare, which resulted in a hard landing and substantial damage to the firewall.NTSB GAA16CA386Accident · No injuriesData collectionFinal reportCessna 172 · Chesterfield, MOThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.NTSB GAA16CA268Accident · No injuriesData collectionFinal reportCessna 172 · Newport News, VAThe student pilot's incorrect pitch control during the landing flare, which resulted in abnormal runway contact and a substantially damaged firewall.NTSB GAA16CA219Accident · No injuriesData collectionFinal reportCessna 172 · Mesa, AZThe student pilot's failure to maintain pitch control during the landing flare, which resulted in an abnormal runway contact, porpoise, nose gear collapse, runway excursion, and impact with terrain.NTSB GAA16CA188Accident · No injuriesData collectionFinal reportCessna 172 · Payson, AZThe student pilot's failure to maintain pitch control during the landing flare, resulting in the subsequent porpoise during landing and substantial damage to the firewall.NTSB GAA16CA187Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe failure of the student pilot to maintain pitch control while landing, which resulted in a hard landing, loss of directional control, and runway excursion.NTSB GAA16CA048Accident · No injuriesData collectionFinal reportCessna 172 · Mesa, AZThe pilot's failure to maintain pitch control during landing, resulting in a porpoise, and firewall damage.NTSB GAA15CA026Accident · No injuriesData collectionFinal reportCessna 172S · Vernal, UTThe student pilot's failure to maintain attitude control during landing flare.NTSB WPR15CA028Accident · No injuriesData collectionFinal reportCessna 172 - S · Hawthorne, CAThe pilot's improper flare which resulted in a loss of aircraft control and subsequent hard landing.NTSB WPR14CA351Accident · No injuriesData collectionFinal reportCessna 172S · Santa Ynez, CAThe student pilot's inadequate flare and loss of aircraft control during landing, which resulted in multiple bounces.NTSB ERA14CA078Accident · No injuriesData collectionFinal reportCessna 172S · Miami, FLThe pilot's improper flare during a gusty, crosswind landing.NTSB ERA13CA395Accident · No injuriesData collectionFinal reportCessna 172S · Fort Lauderdale, FLThe student pilot’s failure to apply power to go-around following a bounced landing resulting in abnormal runway contact and collapse of the nose landing gear.NTSB ERA12CA496Accident · Minor injuriesData collectionFinal reportCessna 172S · Culpeper, VAThe pilot’s failure to maintain directional control during an attempted takeoff.NTSB WPR12LA444Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot's inadequate flare and compensation for gusting wind conditions, which resulted in a bounced landing.NTSB CEN12CA240Accident · No injuriesData collectionFinal reportCessna 172S · Monroe, LAThe student pilot's improper landing flare, which resulted in a bounced landing and loss of directional control.NTSB WPR12CA088Accident · No injuriesData collectionFinal reportCessna 172S · Mokuleia, HIThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB ERA11CA408Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe student pilot's improper recovery from a bounced landing.NTSB ERA10CA350Accident · No injuriesData collectionFinal reportCessna 172S · Salisbury, MDThe student pilot's improper recovery from a bounced landing.NTSB CEN09LA579Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Park Rapids, MNThe pilot's failure to maintain a proper climb rate during a night takeoff.NTSB CEN09LA586Accident · No injuriesLimited investigationFinal reportCessna 172S · Duluth, MNThe pilot's failure to maintain aircraft control during landing, resulting in a hard landing and a propeller strike with the ground.NTSB CEN09CA495Accident · No injuriesData collectionFinal reportCessna 172S · New Braunfels, TXThe student pilot's improper flare resulting in a bounced landing.NTSB ERA09CA404Accident · No injuriesData collectionFinal reportCessna 172 · York, PAThe student pilot's improper recovery from a bounced landing.