Skip to content

NTSB investigations: Cessna 185A, AK

21 cases on aircraft the registry lists as Cessna 185A. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072804')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072804'))
  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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072804'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 GAA19CA327Accident · No injuriesData collectionFinal reportCessna 185 · Gulkana, AKThe pilot's loss of airplane control just before touchdown in gusting wind conditions, which resulted in ground loop after touchdown.Jun 8, 2019 · N4057Y · Substantial damage NTSB ANC10LA087Accident · Serious injuriesLimited investigationFinal reportCessna 185A · Paxson, AKThe pilot's decision to make a climbing turn close to the ground in gusting wind at a low airspeed, resulting in a loss of control and collision with terrain.Sep 12, 2010 · N4038Y · Substantial damage NTSB ANC05CA013Accident · No injuriesData collectionFinal reportCessna 185 · Skwentna, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over during the landing roll. A factor associated with the accident was deep wet snow.Oct 29, 2004 · N185CQ · Substantial damage NTSB ANC95LA140Accident · No injuriesLimited investigationFinal reportCessna 185A · Teller, AKDeflation of the left main tundra tire due to valve stem damage (failure) when the tire rotated independently of the wheel rim, resulting in loss of directional control and a ground swerve.Aug 15, 1995 · N4145Y · Substantial damage NTSB ANC93LA106Accident · No injuriesLimited investigationFinal reportCessna 185 · Victory, AKThe pilot selected unsuitable terrain for landing.Jun 20, 1993 · N1679Z · Substantial damage NTSB ANC91LA103Accident · No injuriesLimited investigationFinal reportCessna 185 · Jago River, AKThe pilot's loss of directional control of the airplane during the landing roll. Contributing to the accident was the wet surface of the airstrip, the curve in the airstrip, and the vegetation which covered the entire airstrip.Jul 19, 1991 · N1650Z · Substantial damage NTSB ANC91LA098Accident · No injuriesLimited investigationFinal reportCessna 185A · Wood River, AKThe pilot's improper in-flight planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. Soft sand in the emergency landing area was a related factor.Jul 13, 1991 · N1689Z · Substantial damage NTSB ANC90LA092Accident · No injuriesLimited investigationFinal reportCessna 185-A · Anchorage, AKFailure of the right main gear torque plate causing an uncontrollable landing roll out.Jun 22, 1990 · N4145Y · Substantial damage NTSB ANC88FA021Accident · 3 fatalField investigationFinal reportCessna 185 · Fairbanks, AKThe pilot and his two passengers were returning from a hunting trip when the airplane crashed 7 miles from the Fairbanks international airport. The airplane struck the ground in a vertical attitude at a high rate of speed. Evidence at the scene suggests that…Nov 27, 1987 · N4056Y · Destroyed NTSB SEA87FA162Accident · 2 fatalField investigationFinal reportHughes 369D · Ketchikan, AKN58318 (Hughes 369, under contract with us geological survey) was inbnd fm se to lnd at Ketchikan-temsco heliport (6Z4) as N73WS (Cessna 185 amphibian) was depg se fm Ketchikan intl arpt (ktn). Ktn & 6Z4 were located in tongass narrows withmtns NE & sw. Rprtd…Aug 12, 1987 · N58318 · 2 aircraft · Destroyed NTSB ANC84LA191Accident · No injuriesLimited investigationFinal reportCessna 185 · Mt Plummer, AKThe plt stated that while landing in a crosswind, he ground looped the airplane. The acft departed the airstrip surface and rolled off the mountainside backward.Sep 21, 1984 · N1688Z · Substantial damage NTSB ANC83LA185Accident · No injuriesLimited investigationFinal reportCessna 185A · Aniak, AKThe plt was taking off from a strip near a camp site. Reportedly, the strip was located on a hill (level bench area) & was oriented generally in a north/south direction. The plt reported that the wind was from 080 deg at about 15 gusting 18 KTS. The acft was…Sep 14, 1983 · N1688Z · Substantial damage NTSB ANC81DA065Accident · Serious injuriesClosedCessna 185 · Bethel, AKJun 19, 1981 · N1688Z · Minor damage NTSB ANC80FA023Accident · 7 fatalClosedCessna 185 · Shungnak, AKJan 14, 1980 · N1690Z · Destroyed NTSB ANC77DA005Accident · No injuriesClosedCessna 185 · Ambler, AKNov 7, 1976 · N1690Z · Substantial damage NTSB ANC72FAD02Accident · No injuriesClosedCessna 185A · Haines, AKJan 7, 1972 · N1688Z · Substantial damage NTSB ANC72DAG60Accident · No injuriesClosedCessna 185A · Homer, AKOct 2, 1971 · N1646Z · Substantial damage NTSB ANC68F0080Accident · No injuriesClosedCessna 185A · King Salmon, AKJun 13, 1967 · N1609Z · Substantial damage NTSB ANC68D0064Accident · No injuriesClosedCessna 185 · Kaltag, AKMay 27, 1967 · N1632Z · Substantial damage NTSB ANC66D0024Accident · No injuriesClosedCessna 185 · Suntrana, AKAug 19, 1965 · N1632Z · Substantial damage NTSB ANC66D0046Accident · No injuriesClosedCessna 185S · Cold Bay, AKJun 15, 1965 · N4177Y · Substantial damage