NTSB investigations: Cessna A185F, 1993
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 | 11 |
| 2022 | 6 |
| 2023 | 9 |
| 2024 | 8 |
| 2025 | 5 |
| 2026 | 14 |
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 ('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") = 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 ('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 FTW94LA040Accident · No injuriesLimited investigationFinal reportCessna A185F · Maybell, COThe pilot's failure to ascertain the condition of the landing area. The snow covered condition of the runway was a factor.NTSB ANC94LA016Accident · No injuriesLimited investigationFinal reportCessna A185F · Chefornak, AKThe failure of the pilot-in-command to adequately compensate for the gusty cross wind condition. A factor in the accident was the wind gust.NTSB ANC93LA147Accident · No injuriesLimited investigationFinal reportCessna 185 · Point Barrow, AKFuel exhaustion as a result of the pilot in command's not refueling. A factor in the accident was the operator/management inadequate flight following and operational control over the flight.NTSB ANC93FA107Accident · Minor injuriesField investigationFinal reportCessna 185 · Wasilla, AKThe pilot in command's failure to use all of the available runway (waterway). A factor in the accident was the pilot in command's lack of recent experience in the type of operation.NTSB ANC93T#A01Accident · No injuriesClass 3Final reportCessna A185F · Gulkana, AKNTSB ANC93LA079Accident · No injuriesLimited investigationFinal reportCessna A185F · Kahiltna Glacie, AKThe pilot-in-command not maintaining directional control. A factor is the rough condition of the glacier airstrip.NTSB ANC93LA075Accident · No injuriesLimited investigationFinal reportCessna 185F · Gustavus, AKThe pilot misjudging his speed while landing on a wet grass strip.NTSB ANC93LA071Accident · No injuriesLimited investigationFinal reportCessna 185 · Bulchitna Lake, AKThe failure of the landing gear leg due to a fatigue fracture caused by corrosion.NTSB ANC93LA044Accident · No injuriesLimited investigationFinal reportCessna 185 · Barrow, AKThe pilot in command inadvertently stalling the airplane.NTSB ANC93LA039Accident · No injuriesLimited investigationFinal reportCessna A185F · Fairbanks, AKThe fuel system selector valve being placed in the off position due to the improper installation of the fuel selector placard by an unqualified person. The snow covered forced landing area was a factor.NTSB SEA93LA059Accident · No injuriesLimited investigationFinal reportCessna A185F · Inglewood, WAFuel exhaustion, the pilot in command's inadequate preflight, and his failure to flare on landing. A factor contributing to the accident was fog.