NTSB investigations: Cessna 172
10 cases on aircraft the registry lists as Cessna 172, 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 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2021 | 2 |
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 ('2072402')
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 ('2072402')
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 ERA22LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Atlanta, GAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion and a collision with runway approach lighting equipment.NTSB ERA22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Statesboro, GAThe student pilot’s failure reduce power and apply sufficient braking after landing, which resulted in a runway excursion and impact with objects and terrain.NTSB ERA18TA266Accident · No injuriesFinal reportCessna 172 · Somerset, PAThe pilot's decision to land with insufficient runway remaining to stop, which resulted in a runway overrun.NTSB ERA18LA257Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Winter Haven, FLThe student pilot’s improper pitch attitude control during the initial climb, which resulted in a loss of airspeed, and his subsequent decision to conduct a 180° turn following the perceived anomaly, which resulted in a runway overrun.NTSB GAA17CA526Accident · Serious injuriesData collectionFinal reportCessna 172 · Coolin, IDThe pilot's decision to take off in high-density altitude and gusting quartering tailwind conditions, which resulted in a loss of lift and an inability to gain altitude during the initial climb.NTSB GAA17CA018Accident · Minor injuriesData collectionFinal reportCessna 172 · Argyle, NYThe pilot’s failure to maintain a stable descent rate and his improper landing flare, which resulted in a hard landing.NTSB CEN13CA200Accident · No injuriesData collectionFinal reportCessna 172 · Kremmling, COThe student pilot’s failure to maintain directional control while landing.NTSB WPR12CA337Accident · Minor injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot’s improper flare and inadequate recovery from a bounced landing.NTSB WPR11CA177Accident · No injuriesData collectionFinal reportCessna 172 · Republic, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB MIA08CA157Accident · No injuriesData collectionFinal reportCessna 172 · Wingate, NCThe student pilot's failure to maintain control of the airplane during a go-around.