NTSB investigations: Cessna 172R, 2008
12 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\") = 2008
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") = 2008
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 ERA09CA110Accident · No injuriesData collectionFinal reportCessna 172R · Morristown, NJThe flight instructor's failure to execute a missed approach when insufficient runway remained for landing. Contributing to the accident were the low ceiling and visibility conditions.NTSB ERA09FA080Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · Ft. Lauderdale, FLThe failure of both pilots to see and avoid the other aircraft.NTSB CEN09CA002Accident · No injuriesData collectionFinal reportCessna 172 · Alton, ILThe student pilot's failure to maintain directional control during landing. A contributing factor was the presence of the sign struck during the runway excursion.NTSB NYC08CA314Accident · No injuriesData collectionFinal reportCessna 172R · Brunswick, GAThe student pilot's improper flare while landing.NTSB CHI08CA253Accident · No injuriesData collectionFinal reportCessna 172R · Cincinnati, OHThe student pilot's inadequate recovery from a bounced landing. Contributing to the accident were the improper flare and excessive airspeed.NTSB LAX08CA222Accident · No injuriesData collectionFinal reportCessna 172R · Byron, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB DEN08LA111Accident · No injuriesLimited investigationFinal reportCessna 172R · Tishomingo, OKThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall during the landing flare. Contributing factors in this accident was the terrain-induced turbulence, and the instructor's inadequate supervision of the pilot.NTSB SEA08FA146Accident · 2 fatalField investigationFinal reportCessna 172R · Monticello, UTThe in-flight collision with mountainous terrain for undetermined reasons. *This report was modified on December 10, 2009.NTSB LAX08LA121Accident · No injuriesLimited investigationFinal reportCessna 172R · S. Lake Tahoe, CAThe pilot's improper flare and subsequent hard landing. Contributing to the accident were the gusty winds and the high density altitude.NTSB CHI08LA096Accident · No injuriesLimited investigationFinal reportCessna 172R · Monroe, WIThe pilot's decision to land on the wrong runway for the existing wind conditions and his improper recovery from a bounced landing.NTSB CHI08CA091Accident · No injuriesData collectionFinal reportCessna 172R · Batavia, OHThe pilot's misjudgment of the landing flare and her inadequate recovery from the bounced landing.NTSB NYC08CA135Accident · No injuriesData collectionFinal reportCessna 172R · Richmond, VAThe student pilot's improper flare, which resulted in a hard landing.