NTSB investigations: Cessna 180, 1993
11 cases on aircraft the registry lists as Cessna 180. 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
| 1964 | 61 |
|---|---|
| 1965 | 58 |
| 1966 | 61 |
| 1967 | 61 |
| 1968 | 32 |
| 1969 | 47 |
| 1970 | 44 |
| 1971 | 33 |
| 1972 | 38 |
| 1973 | 34 |
| 1974 | 35 |
| 1975 | 39 |
| 1976 | 29 |
| 1977 | 27 |
| 1978 | 20 |
| 1979 | 24 |
| 1980 | 29 |
| 1981 | 23 |
| 1982 | 17 |
| 1983 | 16 |
| 1984 | 14 |
| 1985 | 8 |
| 1986 | 9 |
| 1987 | 14 |
| 1988 | 14 |
| 1989 | 10 |
| 1990 | 15 |
| 1991 | 13 |
| 1992 | 14 |
| 1993 | 11 |
| 1994 | 6 |
| 1995 | 13 |
| 1996 | 11 |
| 1997 | 8 |
| 1998 | 12 |
| 1999 | 10 |
| 2000 | 14 |
| 2001 | 4 |
| 2002 | 7 |
| 2003 | 10 |
| 2004 | 5 |
| 2005 | 13 |
| 2006 | 12 |
| 2007 | 9 |
| 2008 | 12 |
| 2009 | 7 |
| 2010 | 12 |
| 2011 | 10 |
| 2012 | 8 |
| 2013 | 9 |
| 2014 | 6 |
| 2015 | 7 |
| 2016 | 4 |
| 2017 | 8 |
| 2018 | 9 |
| 2019 | 5 |
| 2020 | 5 |
| 2021 | 2 |
| 2022 | 7 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 5 |
| 2026 | 9 |
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\") = 1993
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072602'))
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") = 1993
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072602'))
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 ANC94LA010Accident · No injuriesLimited investigationFinal reportCessna CE-180 · King Salmon, AKThe pilot-in-command's selection of unsuitable terrain and the berm on the airstrip.NTSB ANC93LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Pumice Creek, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors were the pilot misjudged the wind information, and the unfavorable wind.NTSB FTW93LA258Accident · No injuriesLimited investigationFinal reportCessna 180 · Watkins, COThe pilot's improper compensation for shifting winds.NTSB SEA93FA187Accident · 3 fatalField investigationFinal reportCessna 180 · Cheyenne, WYImproper in-flight planning/decison by the pilot, which resulted in exceeding the design stress limits of the aircraft after encountering adverse weather. The weather conditions were related factors.NTSB ANC93LA138Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe inadvertent raising of the flaps.NTSB ANC93LA132Accident · No injuriesLimited investigationFinal reportCessna 180 · Sparrevohn, AKThe pilot's failure to maintain directional control of the airplane. A factor was the animal on the runway.NTSB SEA93LA143Accident · No injuriesLimited investigationFinal reportCessna 180 · Bozeman, MTDirectional control was not maintained. A factor to the accident was: inadequate remedial action.NTSB ANC93LA100Accident · No injuriesLimited investigationFinal reportCessna 180 · Merrill Pass, AKThe pilot-in-command's inadequate fuel calculations.NTSB SEA93LA099Accident · No injuriesLimited investigationFinal reportCessna 172K · Ogden, UTThe pilot in command's failure to maintain directional control. Factors contributing to the accident were soft terrain, excessive airspeed, and crosswinds.NTSB BFO93FA034Accident · 1 fatalField investigationFinal reportCessna 180F · Brewer, MELoss of engine power due to undetermined reasons, and the failure of the pilot to maintain adequate airspeed during the forced landing which resulted in a stall.NTSB ANC93LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Elmendorf Afb, AKThe pilot's excessive taxi speed. A factor which contributed to the accident was the snow covered surface.