NTSB investigations: Cessna A185F, 2002
11 cases on aircraft the registry lists as Cessna A185F. 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
| 1972 | 1 |
|---|---|
| 1973 | 2 |
| 1974 | 4 |
| 1975 | 15 |
| 1976 | 29 |
| 1977 | 25 |
| 1978 | 38 |
| 1979 | 24 |
| 1980 | 31 |
| 1981 | 25 |
| 1982 | 20 |
| 1983 | 18 |
| 1984 | 20 |
| 1985 | 19 |
| 1986 | 16 |
| 1987 | 15 |
| 1988 | 15 |
| 1989 | 16 |
| 1990 | 13 |
| 1991 | 13 |
| 1992 | 19 |
| 1993 | 11 |
| 1994 | 14 |
| 1995 | 8 |
| 1996 | 12 |
| 1997 | 18 |
| 1998 | 18 |
| 1999 | 13 |
| 2000 | 14 |
| 2001 | 7 |
| 2002 | 11 |
| 2003 | 9 |
| 2004 | 16 |
| 2005 | 13 |
| 2006 | 5 |
| 2007 | 13 |
| 2008 | 8 |
| 2009 | 7 |
| 2010 | 5 |
| 2011 | 10 |
| 2012 | 7 |
| 2013 | 9 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 11 |
| 2017 | 9 |
| 2018 | 12 |
| 2019 | 6 |
| 2020 | 10 |
| 2021 | 12 |
| 2022 | 6 |
| 2023 | 9 |
| 2024 | 8 |
| 2025 | 6 |
| 2026 | 13 |
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\") = 2002
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072821', '2070107'))
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") = 2002
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072821', '2070107'))
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 DEN02GA102Accident · 1 fatalFinal reportCessna A185F · Howard, COthe pilot's failure to maintain clearance of the terrain. Contributing factors were the clear air turbulent weather condition, and the high density altitude condition.NTSB ANC02LA114Accident · No injuriesLimited investigationFinal reportCessna 185 · Pilot Point, AKThe pilot's inadequate compensation for P-factor, and his failure to abort the takeoff which resulted in a collision with trees during the takeoff initial climb.NTSB ANC02FA107Accident · 2 fatalField investigationFinal reportCessna A185F · Kodiak, AKThe pilot's failure to maintain adequate airspeed and his operation of the airplane in an over gross condition. A contributing factor was noncompliance with written company weight and balance procedures.NTSB ANC02LA065Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's failure to attain the proper touchdown point resulting in an undershoot, and an in-flight collision with a log during the landing flare. A contributing factor in the accident was a hidden obstruction.NTSB ANC02LA050Accident · No injuriesLimited investigationFinal reportCessna 185F · Talkeetna, AKA fracture failure of the lower end of the spring steel landing gear strut. Factors contributing to the accident were the manufacturer's and the FAA's insufficient standards/requirements for inspection procedures.NTSB ANC02TA045Accident · No injuriesFinal reportCessna 185 · Kaktovik, AKThe pilot's inadequate evaluation of the weather conditions during landing at a remote lake, resulting in a downwind landing. Factors contributing to the accident were the presence of a tailwind, and an icy lake surface.NTSB LAX02LA185Accident · No injuriesLimited investigationFinal reportCessna A185F · Angwin, CAThe pilot's inadequate compensation for the wind conditions resulted in a loss of directional control and a ground loop/swerve.NTSB CHI02TA149Accident · No injuriesFinal reportCessna A185F · Necedah, WIDirectional control of the airplane not maintained by the pilot. The gusting winds was a contributing factor.NTSB NYC02FA106Accident · 2 fatalField investigationFinal reportCessna A185F · Pleasant Mount, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control, resulting in overstress of the aircraft. A factor was the thunderstorm activity.NTSB ANC02LA039Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate evaluation of weather conditions, which precipitated an in-flight loss of control and subsequent collision with terrain. A factor contributing to the accident was the tailwind.NTSB CHI02LA124Accident · No injuriesLimited investigationFinal reportCessna 185F · Cumberland, WIthe failure of the pilot to maintain directional control after encountering high winds and gusty winds during taxi from landing.