NTSB investigations: Cessna A185F, 2022
6 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 | 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\") = 2022
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") = 2022
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 WPR23LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fergus Falls, MNThe pilot’s failure to maintain directional control during the takeoff roll, resulting in a runway excursion.NTSB ANC23FA001Accident · 1 fatalClass 3 · FieldFinal reportCessna A185F · Fairbanks, AKThe improperly maintained floats, which allowed water to fill the front compartments and resulted in the airplane nosing over during taxi. Contributing to the fatal injury of the pilot was the improperly secured cargo, which prevented the pilot from egressing…NTSB ERA22LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Plymouth, CTThe pilot’s encounter with known and forecast adverse weather which resulted in a collision with trees during the initial climb.NTSB WPR22LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Sunriver, ORThe pilot's failure to maintain control of the airplane during takeoff, which resulted in a collision with terrain.NTSB CEN22LA172Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Evansville, INThe pilot did not maintain directional control during the landing roll resulting in a ground loop.NTSB WPR22LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Gila Bend, AZThe pilot's failure to maintain directional control during the landing roll