NTSB investigations: Cessna A185F, 2016
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\") = 2016
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") = 2016
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 ANC17LA005Accident · No injuriesLimited investigationFinal reportCessna A185 · Ninilchik, AKA loss of brake system fluid due to leaks in the o-rings, which resulted in asymmetrical braking and a subsequent loss of directional control during the landing roll.NTSB GAA17CA041Accident · No injuriesData collectionFinal reportCessna A185 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll.NTSB GAA17CA013Accident · No injuriesData collectionFinal reportCessna A185 · San Antonio, TXThe pilot's failure to recognize the tailwind condition and maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA16CA446Accident · No injuriesData collectionFinal reportCessna A185 · Caldwell, IDThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.NTSB GAA16CA438Accident · No injuriesData collectionFinal reportCessna A185 · Fayetteville, TNThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion and a ground loop.NTSB GAA16CA443Accident · No injuriesData collectionFinal reportCessna A185 · Klamath Falls, ORThe pilot's improper landing flare, which resulted in the airplane porpoising and the subsequent loss of directional control.NTSB ANC16CA036Accident · No injuriesData collectionFinal reportCessna A185F · King Salmon, AKThe pilot's failure to maintain airplane control while landing in gusty wind conditions, resulting in a noseover.NTSB GAA16CA375Accident · No injuriesData collectionFinal reportCessna A185 · Hayden Lake, IDThe pilot's failure to retract the amphibious airplane's land-wheels prior to landing on a lake, which resulted in a nose over.NTSB WPR16FA131Accident · 1 fatalField investigationFinal reportCessna A185F · Coeur d'Alene, IDThe pilot's failure to maintain clearance from trees while maneuvering at low altitude in mountainous terrain.NTSB GAA16CA260Accident · No injuriesData collectionFinal reportCessna A185 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.NTSB GAA16CA217Accident · No injuriesData collectionFinal reportCessna A185 · Chesterfield, MOThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop and a wing strike.