NTSB investigations: Cessna 172R, 2021
8 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\") = 2021
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") = 2021
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 CEN22LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Chesterfield, MOThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard, bounced landing and the nose landing gear collapsing. .NTSB ANC21LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Birchwood, AKThe flight instructor’s inadequate supervision of the student pilot, and student pilot’s improper landing flare, resulting in a hard landing.NTSB ERA21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Louisville, KYA loss of directional on takeoff for reasons that could not be determined.NTSB WPR21LA269Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Petaluma, CAThe pilot’s improper landing flare which resulted in a hard landing following a partial loss of electrical power. Contributing to the accident was the pilot’s distraction and hampered visual function.NTSB WPR21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 172R · Missoula, MTThe pilot’s failure to maintain airspeed and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB ERA21LA249Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Groton, CTThe pilot’s failure to maintain directional control of the airplane during landing, resulting in a runway excursion and collision with an airport sign.NTSB WPR21LA193Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172R · Chandler, AZThe pilot’s failure to locate the airport which resulted in an approach to a road and subsequent collision with powerlines during a go-around in low light conditions.NTSB ERA21LA119Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lawrenceville, GAThe pilot's failure to maintain directional control during landing in a gusting crosswind, which resulted in a loss of control and runway excursion.