NTSB investigations: Cessna A185F
19 cases on aircraft the registry lists as Cessna A185F, where the first occurrence was “On ground/water encounter with terrain/water”. 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
| 1982 | 3 |
|---|---|
| 1984 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1994 | 3 |
| 1995 | 2 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
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 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 320))
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 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 320))
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 ANC03LA057Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's excessive taxi speed while attempting to turn the airplane in soft snow, which resulted in a nose over. A factor in the accident was soft snow.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 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 CHI00LA035Accident · No injuriesLimited investigationFinal reportCessna A185F · Raymond, NEthe pilot's lack of recent experience in the type of aircraft and type of operation, and the pilot not maintaining directional control. A finding was the glassy condition of the water.NTSB ANC98LA080Accident · No injuriesLimited investigationFinal reportCessna 185F · Chitina, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were uneven and soft terrain on the landing strip.NTSB ANC98LA034Accident · No injuriesLimited investigationFinal reportCessna 185F · Coldfoot, AKThe pilot's selection of unsuitable terrain for takeoff. Soft, snow covered terrain was a factor in the accident.NTSB ANC98LA009Accident · No injuriesLimited investigationFinal reportCessna 185F · Barrow, AKThe pilot's selection of unsuitable terrain for takeoff, and his delay in aborting the takeoff. A factor in the accident was the presence of gravel/sand in the takeoff area.NTSB ANC95LA059Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe failure of the pilot-in-command to identify unsafe snow conditions at the site. A factor associated with the accident is the soft snow in the takeoff area.NTSB CHI95LA105Accident · No injuriesLimited investigationFinal reportCessna 185 · Baudette, MNan encountered with a hidden obstruction during taxi. A factor was the ski assembly not having been installed.NTSB ANC95LA011Accident · No injuriesLimited investigationFinal reportCessna 185F · Anchorage, AKThe pilot's selection of unsuitable terrain for landing. The pilot's disregard of a NOTAM that closed the runway and a slush covered runway area were factors in the accident.NTSB ANC95LA003Accident · No injuriesLimited investigationFinal reportCessna A185F · Kotzebue, AKA failure of the pilot to maintain adequate distance from the terrain (snow bank). Flat lighting and low contrast conditions were factors in the accident.NTSB SEA94LA234Accident · No injuriesLimited investigationFinal reportCessna A185F · Conrad, MTThe cfi's failure to assure an adequate inspection of the aircraft, including the proper engagement and function of the rudder pedals, prior to the flight.NTSB SEA87LA078Accident · No injuriesLimited investigationFinal reportCessna 185 · Burnett Inlet, AKThe plt left the landing gear in the down position after takeoff. During the water landing, with the gear in the down position, the acft nosed over.NTSB ANC86LA053Accident · No injuriesLimited investigationFinal reportCessna 185 · Bethel, AKThe pilot stated that he was taxiing for takeoff on the frozen river when the left main gear broke through the ice. The aircraft's left wing and left gear were damaged.NTSB ANC84LA170Accident · No injuriesLimited investigationFinal reportCessna A185F-II · Iliamna, AKThe float plane plt began taking off from a small lake in calm wind & glassy water conditions. Realizing the situation was marginal, he reduced power to abort (before lifting off) & began a step turn to the left. The plt reported that the radius of the turn…NTSB ANC84LA083Accident · No injuriesLimited investigationFinal reportCessna 185F · Anchorage, AKWhile landing his float equipped acft, the plt noticed that another acft that had landed before him had not cleared the landing area. He attempted a sharp left turn around the other acft & the acft hit a beach & flipped over.NTSB ANC82DA097Accident · No injuriesFinal reportCessna 185 · Near Barrow, AKThe pilot flew to a fishing camp Near Barrow, AK. During the landing roll, the aircraft struck a wet snow drift (about 2FT. Deep) and flipped over.NTSB ANC82DA050Accident · 1 fatalFinal reportCessna 185F · Near Chinitna B, AKThe aircraft was chartered to salvage gear from a burned hovercraft that was beached about one mile south of Chinitna bay. The pilot reported that the two passengers got the gear ready to load while he held the plane off the beach by hand, trying to keep the…NTSB ANC82DA018Accident · No injuriesFinal reportCessna 185 · Fort Yukon, AKThe pilot had landed the wheel/ski equipped aircraft at a field site to pick-up a passenger. While taxiing in snow, estimated to be 14 to 15 inches deep, the right ski hit something in the snow and the plane nosed over.