NTSB investigations: Cessna 172N
14 cases on aircraft the registry lists as Cessna 172N, 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
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2012 | 1 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2025 | 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 ('2072434')
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 ('2072434')
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 WPR25LA243Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Ronan, MTThe student pilot's inadequate landing flare and recovery from a bounced landing.NTSB CEN22LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Jacksonville, ILThe pilot’s failure to attain proper flare during landing, resulting in a bounced landing.NTSB ERA20CA249Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Pickens, SCThe student pilot's improper landing flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB ANC18LA079Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fullerton, CAThe National Transportation Safety Board did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of…NTSB GAA18CA064Accident · No injuriesData collectionFinal reportCessna 172 · Pompano, FLThe pilot’s improper landing flare, which resulted in a porpoise.NTSB GAA17CA076Accident · No injuriesData collectionFinal reportCessna 172 · Salmon, IDThe airplane's encounter with a depression in a dirt runway during takeoff, which resulted in a tail strike.NTSB GAA16CA460Accident · No injuriesData collectionFinal reportCessna 172 · Winchester, VAThe student pilot's incorrect pitch control during the landing flare, which resulted in a porpoise, a loss of directional control, and a runway excursion.NTSB GAA16CA301Accident · No injuriesData collectionFinal reportCessna 172 · Urbana, OHThe pilot's abnormal runway contact during the landing flare, which resulted in a porpoise, hard landing, and runway excursion.NTSB GAA15CA274Accident · No injuriesData collectionFinal reportCessna 172N · Herington, KSThe pilot's failure to maintain pitch control during the landing roll, which resulted in a porpoise.NTSB GAA15CA214Accident · No injuriesData collectionFinal reportCessna 172N · Miami, FLThe student pilot's failure to maintain pitch control resulting in a hard landing and damage to the airplane firewall.NTSB GAA15CA162Accident · No injuriesData collectionFinal reportCessna 172N · Lubbock, TXThe student pilot's improper flare during landing which resulted in abnormal runway contact and damage to the firewall.NTSB CEN13CA098Accident · No injuriesData collectionFinal reportCessna 172N · Moline, ILThe student pilot's misjudgment of the landing flare, which resulted in a bounced landing.NTSB ERA10CA167Accident · No injuriesData collectionFinal reportCessna 172 · Poughkeepsie, NYThe pilot's failure to maintain directional control during the landing flare.NTSB ERA09CA103Accident · No injuriesData collectionFinal reportCessna 172 · Corning, NYThe student pilot's failure to maintain directional control during landing. Contributing to the accident were the gusty wind conditions and the flight instructor's delayed remedial action.