NTSB investigations: Cessna 172L, 2005
9 cases on aircraft the registry lists as Cessna 172L. 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
| 1970 | 2 |
|---|---|
| 1971 | 17 |
| 1972 | 34 |
| 1973 | 40 |
| 1974 | 28 |
| 1975 | 23 |
| 1976 | 17 |
| 1977 | 19 |
| 1978 | 17 |
| 1979 | 5 |
| 1980 | 8 |
| 1981 | 7 |
| 1982 | 5 |
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 6 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 11 |
| 1989 | 4 |
| 1990 | 8 |
| 1991 | 1 |
| 1992 | 6 |
| 1993 | 3 |
| 1994 | 7 |
| 1995 | 6 |
| 1996 | 7 |
| 1997 | 2 |
| 1998 | 6 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 9 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 9 |
| 2006 | 7 |
| 2007 | 5 |
| 2008 | 4 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 5 |
| 2025 | 5 |
| 2026 | 4 |
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\") = 2005
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072432'))
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") = 2005
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072432'))
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 DEN06LA014Accident · No injuriesLimited investigationFinal reportCessna 172L · Rock Springs, WYthe loss of engine power for reasons undetermined. Contributing to the accident was the dark night and lack of suitable terrain for a forced landing.NTSB NYC06LA028Accident · No injuriesLimited investigationFinal reportCessna 172L · Lehighton, PAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during takeoff due to fuel contamination, and a subsequent forced landing to a field.NTSB CHI06FA010Accident · 4 fatalField investigationFinal reportPlavcan Lancair 235 · Rootstown, OHThe failure of both pilots to maintain an adequate visual lookout during cruise flight, which resulted in their failure to see and avoid each other and a midair collision.NTSB ANC05CA103Accident · No injuriesData collectionFinal reportCessna 172 · Kenai, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over. A factor associated with the accident was swampy terrain.NTSB NYC05CA107Accident · No injuriesData collectionFinal reportCessna 172L · Tangier, VAThe pilot's failure to maintain directional control during landing.NTSB LAX05LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Santa Ynez, CAthe pilot's failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in a stall and collision with terrain.NTSB DFW05CA100Accident · No injuriesData collectionFinal reportCessna 172L · Stephenville, TXThe pilot's improper recovery from a bounced landing, which resulted in a hard landing. A contributing factor was the prevailing crosswind.NTSB LAX05CA127Accident · No injuriesData collectionFinal reportCessna 172L · Chino, CAthe pilot's inadequate compensation for a gusting crosswind and his failure to maintain directional control.NTSB IAD05LA029Accident · No injuriesLimited investigationFinal reportCessna 172L · Poughkeepsie, NYThe pilot's inadequate preflight, which resulted in a loss of engine power due to fuel contamination.