NTSB investigations: Cessna 172R, 2018
10 cases on aircraft the registry lists as Cessna 172R. 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
| 1998 | 2 |
|---|---|
| 1999 | 12 |
| 2000 | 8 |
| 2001 | 8 |
| 2002 | 6 |
| 2003 | 8 |
| 2004 | 9 |
| 2005 | 13 |
| 2006 | 7 |
| 2007 | 18 |
| 2008 | 12 |
| 2009 | 4 |
| 2010 | 6 |
| 2011 | 12 |
| 2012 | 10 |
| 2013 | 5 |
| 2014 | 10 |
| 2015 | 5 |
| 2016 | 9 |
| 2017 | 8 |
| 2018 | 10 |
| 2019 | 8 |
| 2020 | 6 |
| 2021 | 8 |
| 2022 | 4 |
| 2023 | 7 |
| 2024 | 6 |
| 2025 | 4 |
| 2026 | 3 |
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\") = 2018
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401'))
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") = 2018
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401'))
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 GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.NTSB CEN18CA323Accident · No injuriesData collectionFinal reportCessna 172 · Greeley, COThe pilot’s and safety pilot's conflicting control inputs during landing, which resulted in their failure to maintain a proper airspeed and resulted in an aerodynamic stall. Contributing to the accident was the lack of communication between the pilot and…NTSB GAA18CA464Accident · No injuriesData collectionFinal reportCessna 172 · Spring, TXThe student pilot’s improper landing flare in a crosswind, which resulted in a hard landing.NTSB WPR18FA195Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Deer Park, WAAn in-flight breakup as a result of the airplane exceeding the structural strength of the airplane during a rapid descent that the flight instructor was unable to recover from following a collision with a large bird.NTSB GAA18CA498Accident · No injuriesData collectionFinal reportCessna 172 · Beaver Falls, PAThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA18CA276Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe pilot’s decision to take off with the airplane over its maximum gross weight due to his failure to perform preflight weight and balance calculations, which affected the airplane’s takeoff performance, and his subsequent decision to abort the takeoff with…NTSB GAA18CA199Accident · No injuriesData collectionFinal reportCessna 172 · New Bedford, MAThe student pilot’s failure to maintain a proper landing flare, which resulted in a porpoised landing.NTSB GAA18CA175Accident · Minor injuriesData collectionFinal reportCessna 172 · Beaver Falls, PAThe student pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA163Accident · No injuriesData collectionFinal reportCessna 172 · Bedford, MAThe pilot’s improper landing flare, which resulted in substantial damage.NTSB GAA18CA151Accident · No injuriesData collectionFinal reportCessna 172 · Lakeland, FLThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a bounced landing.