NTSB investigations: Cessna 172N, 2011
8 cases on aircraft the registry lists as Cessna 172N, 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 |
|---|---|
| 2009 | 7 |
| 2010 | 7 |
| 2011 | 8 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 4 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 6 |
| 2018 | 3 |
| 2019 | 5 |
| 2020 | 11 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 4 |
| 2024 | 5 |
| 2025 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 2011
AND 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' 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 year(c."eventDate") = 2011
AND 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' 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 CEN12CA099Accident · No injuriesData collectionFinal reportCessna 172N · Wauseon, OHThe student pilot's loss of directional control during landing.NTSB CEN11CA674Accident · No injuriesData collectionFinal reportCessna 172N · Wadsworth, OHThe pilot's misjudgment of his speed and distance, which resulted in an overrun.NTSB ERA11CA236Accident · No injuriesData collectionFinal reportCessna 172N · Millville, NJThe pilot’s improper recovery from a bounced landing which resulted in a loss of aircraft control during the go-around.NTSB CEN11CA261Accident · No injuriesData collectionFinal reportCessna 172N · Colorado Springs, COThe pilot loss of directional control during landing in gusty crosswind conditions.NTSB CEN11CA271Accident · No injuriesData collectionFinal reportCessna 172N · Appleton, WIThe student pilot's failure to maintain directional control of the airplane during takeoff.NTSB WPR11LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Spanish Fork, UTThe student pilot's inadequate compensation for the gusting wind, which resulted in a loss of airplane control during landing. Contributing to the accident was the pilot's decision to depart with a high gusting wind.NTSB CEN11CA184Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe student pilot's failure to maintain directional control of the airplane during the takeoff.NTSB ERA11CA115Accident · No injuriesData collectionFinal reportCessna 172N · Lebanon, TNThe student pilot´s failure to maintain directional control during an aborted takeoff, resulting in a runway excursion.