NTSB investigations: Cessna 180, 1992
14 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\") = 1992
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") = 1992
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 LAX93FA055Accident · 5 fatalField investigationFinal reportCessna T210M · Thornton, CAThe failure of the pilots of both airplanes to see and avoid each other. Contributing to the accident was the failure of the sacramento controller to advise the stockton controller of the impending unsafe situation, and the failure of the stockton controller…NTSB LAX93LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Clarksburg, CAThe pilot's improper use of the ailerons.NTSB FTW93LA025Accident · No injuriesLimited investigationFinal reportCessna 180 · Lubbock, TXThe partial power loss due to a disconnected throttle cable. A factor was the lack of suitable terrain at the pilot's disposal.NTSB LAX92LA394Accident · No injuriesLimited investigationFinal reportCessna 180 · Avalon, CAThe pilot's improper landing flare which resulted in a hard landing and a collapse of the left main landing gear.NTSB ANC92T#A08Accident · No injuriesClass 3Final reportCessna 180 · Eielson Afb, AKNTSB ANC92LA127Accident · No injuriesLimited investigationFinal reportCessna 180 · Eureka, AKThe loss of engine power and undetermined reasons.NTSB ANC92LA111Accident · No injuriesLimited investigationFinal reportCessna 180 · Wrangell, AKAn inoperative tailwheel.NTSB BFO92LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Sanford, METhe pilot's inadequate compensation for wind conditions.NTSB ANC92LA102Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot's failure to maintain directional control. Factors include gusty crosswind conditions.NTSB LAX92LA269Accident · No injuriesLimited investigationFinal reportCessna 180 · Glendale, AZThe failure of the left main gear inner tube due to dry rot, and, the inadequate maintenance and preflight inspections conducted on the aircraft.NTSB ANC92LA068Accident · No injuriesLimited investigationFinal reportCessna 180 · Kenai, AKThe pilot's improper use of carburetor heat which resulted in loss of engine power due to carburetor ice.NTSB NYC92LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Winfield, WVThe improper in-flight planning and decision of the pilot to land on the strip and the pilot's delay in attempting the go-around. Factors in this accident were: the pilot was unable to maintain control of the aircraft due to the wet grass and the tail wind.NTSB DEN92LA044Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Erie, COA loss of directional control when the pilot failed to adequately compensate for crosswind conditions during landing roll. A factor was: a 27 knot crosswind gust.NTSB SEA92LA053Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Quilcene, WAThe pilot's failure to maintain directional control. Factors include a poor in flight decision and unfavorable/gusty winds.