NTSB investigations: Cessna 172S, 2024
14 cases on aircraft the registry lists as Cessna 172S. 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
| 1967 | 2 |
|---|---|
| 1970 | 1 |
| 1972 | 1 |
| 1979 | 3 |
| 1987 | 1 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 20 |
| 2002 | 22 |
| 2003 | 29 |
| 2004 | 27 |
| 2005 | 28 |
| 2006 | 25 |
| 2007 | 26 |
| 2008 | 31 |
| 2009 | 22 |
| 2010 | 27 |
| 2011 | 20 |
| 2012 | 29 |
| 2013 | 24 |
| 2014 | 18 |
| 2015 | 18 |
| 2016 | 29 |
| 2017 | 24 |
| 2018 | 22 |
| 2019 | 23 |
| 2020 | 18 |
| 2021 | 22 |
| 2022 | 9 |
| 2023 | 13 |
| 2024 | 14 |
| 2025 | 18 |
| 2026 | 14 |
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\") = 2024
AND 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'))
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") = 2024
AND 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'))
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 ERA25FA082Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Cintrona, PRMaintenance personnel’s inadequate inspection of the airplane, which resulted in inflight the failure of the right aileron carry through cable due to wear, reduced effectiveness of the airplane’s ailerons, and a subsequent loss of control.NTSB ERA25LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Jefferson, GAThe airplane’s collision with a deer on the runway during landing.NTSB ERA25LA072Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Pahokee, FLThe pilots' failure to see and avoid the other airplane, which resulted in a midair collision during short final approach.NTSB ERA25LA052Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Chattanooga, TNA partial loss of engine power due to a fouled spark plug in engine’s the No. 4 cylinder. Contributing was the flight instructor’s failure to maintain aircraft control during an attempted go-around following an unsuccessful landing approach in IMC, which…NTSB WPR24LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Seattle, WAThe Gulfstream pilot’s failure to maintain clearance from the Cessna while taxiing that resulted in a ground collision.NTSB ERA24LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Elizabeth City, NCThe pilot’s improper flare and subsequent improper recovery from a bounced landing.NTSB ERA24LA231Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Pierson, FLThe flight instructor’s failure to attain a proper touchdown point during a precautionary landing, which resulted in a runway excursion during landing.NTSB WPR24LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Prescott, AZThe student pilot’s failure to maintain directional control during landing following an aborted takeoff which resulted in a runway excursion and impact with a ditch.NTSB ERA24LA398Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · St. Augustine, FLThe pilot’s improper landing flare resulting in a hard, bounced landing.NTSB WPR24LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Chandler, AZThe pilot’s failure to maintain clearance from obstacles during taxi operations.NTSB ERA24LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Zelienople, PAThe pilot’s inadequate compensation for the gusting crosswind condition during landing.NTSB ERA24LA137Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Leesburg, VAAn in-flight collision with a bird while on the downwind leg of the airport traffic pattern.NTSB ERA24LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Smyrna, TNAn in-flight collision with a bird during initial climb.NTSB ERA24LA090Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Mooresville, NCThe pilot’s failure to maintain control of the airplane during a go-around in gusting crosswind conditions.