NTSB investigations: Cessna A185F, 2000
14 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\") = 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 ('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") = 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 ('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 SEA01LA025Accident · No injuriesLimited investigationFinal reportCessna A185F · Lynwood, WAFuel exhaustion due to refueling was not performed by the pilot-in-command. Trees and a fence were factors.NTSB FTW01FA020Accident · 1 fatalField investigationFinal reportCessna 185F · Jena, LAThe pilot's decision to land on a highway with vehicle traffic and obstacles and his failure to maintain proper clearance from the obstacles.NTSB LAX01LA034Accident · No injuriesLimited investigationFinal reportCessna 185F · Carson City, NVFuel starvation precipitated by the pilot's continued use of the fuel selector valve that was not seating in the detents properly.NTSB SEA00WA196Accident · 3 fatalForeign investigationCessna A185F · Smithers, CanadaNTSB FTW00LA261Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Burnet, TXThe pilot's failure to maintain directional control of the airplane while landing. A factor was the crosswind.NTSB ANC00LA105Accident · No injuriesLimited investigationFinal reportCessna 185 · Yakutat, AKThe total fatigue failure of the right main landing gear leg.NTSB ANC00LA103Accident · No injuriesLimited investigationFinal reportCessna 185 · Kaktovik, AKThe pilot's selection of an unsuitable takeoff area on the airstrip. Factors associated with this accident were the rough takeoff area, and the pilot's loss of directional control.NTSB ANC00LA099Accident · No injuriesLimited investigationFinal reportCessna 185F · Barrow, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was a hidden obstruction, and soft terrain.NTSB SEA00LA147Accident · No injuriesLimited investigationFinal reportCessna A185F · Tillamook, ORThe pilot's failure to maintain directional control.NTSB LAX00LA243Accident · No injuriesLimited investigationFinal reportCessna A185F · Marana, AZthe pilot's excessive use of wheel brakes during the landing roll resulting in the airplane's nosing over.NTSB FTW00LA180Accident · No injuriesLimited investigationFinal reportCessna A185F · New Orleans, LAThe pilot's failure to maintain directional control during landing roll, which resulted in a ground loop.NTSB FTW00WA173Accident · Minor injuriesForeign investigationCessna A185F · Mixcolaja, GuatemalaNTSB ANC00TA059Accident · Minor injuriesFinal reportCessna 185F · Anchorage, AKThe pilot's improper remedial action and his failure to maintain directional control of the airplane during landing. A factor in the accident was the pilot's excessive use of the airplane brakes.NTSB NYC00LA077Accident · No injuriesLimited investigationFinal reportCessna 185 · Saratoga Sprngs, NYThe pilot's loss of control of the airplane during the landing.