NTSB investigations: Cessna 172K, 2000
10 cases on aircraft the registry lists as Cessna 172K. 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 | 1 |
|---|---|
| 1968 | 3 |
| 1969 | 29 |
| 1970 | 48 |
| 1971 | 66 |
| 1972 | 52 |
| 1973 | 43 |
| 1974 | 40 |
| 1975 | 21 |
| 1976 | 30 |
| 1977 | 29 |
| 1978 | 25 |
| 1979 | 15 |
| 1980 | 12 |
| 1981 | 13 |
| 1982 | 11 |
| 1983 | 6 |
| 1984 | 5 |
| 1985 | 7 |
| 1986 | 6 |
| 1987 | 12 |
| 1988 | 9 |
| 1989 | 5 |
| 1990 | 7 |
| 1991 | 11 |
| 1992 | 4 |
| 1993 | 7 |
| 1994 | 12 |
| 1995 | 6 |
| 1996 | 12 |
| 1997 | 5 |
| 1998 | 6 |
| 1999 | 6 |
| 2000 | 10 |
| 2001 | 5 |
| 2002 | 8 |
| 2003 | 10 |
| 2004 | 7 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 8 |
| 2008 | 3 |
| 2009 | 1 |
| 2010 | 4 |
| 2011 | 6 |
| 2012 | 6 |
| 2013 | 5 |
| 2014 | 7 |
| 2015 | 2 |
| 2016 | 6 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 8 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 4 |
| 2026 | 2 |
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\") = 2000
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072430'))
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") = 2000
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072430'))
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 FTW01LA022Accident · No injuriesLimited investigationFinal reportCessna 172K · Belcher, LAthe total loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive to carburetor icing and the lack of suitable terrain available for the forced landing.NTSB NYC01LA038Accident · No injuriesLimited investigationFinal reportCessna 172K · Hagerstown, MDThe pilot's failure to remove the gust lock from the control column before takeoff, and his failure to abort the takeoff.NTSB ATL01LA006Accident · No injuriesLimited investigationFinal reportCessna 172K · Indiantown, FLThe pilot had excessive airspeed, misjudged the landing distance, and did not perform a go-around, which resulted in a nose over. The ditch was a contributing factor.NTSB SEA00LA194Accident · No injuriesLimited investigationFinal reportCessna 172K · Burns, ORThe separation of a portion of one propeller blade as a result of a fatigue crack that initiated at the site of foreign object damage to the blade.NTSB LAX00LA335Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Novato, CAFailure of the student pilot to maintain directional control of the airplane during the landing rollout resulting in a collision with a berm.NTSB NYC00LA236Accident · No injuriesLimited investigationFinal reportCessna 172K · Warwick, RIThe pilot's delayed recovery from a bounced landing.NTSB LAX00LA289Accident · No injuriesLimited investigationFinal reportCessna 172K · Palo Alto, CAThe pilot of the other airplane's (Cessna) inadequate visual lookout and misjudged distance to the standing Beech.NTSB DEN00LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Orchard, COThe pilot inadvertently stalling the airplane. A factor was his failure to maintain sufficient airspeed.NTSB MIA00FA103Accident · 4 fatalField investigationFinal reportCessna 172K · Sarasota, FLThe failure of the supervisor/ground controller and the local controller to provide effective separation between the accident airplanes on the runway, resulting in a collision during takeoff. Contributing to the accident was the failure of the pilot and…NTSB FTW00LA088Accident · No injuriesLimited investigationFinal reportCessna 172K · Alpine, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.