Skip to content

NTSB investigations: Cessna 185D, AK

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

19662026

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 ('2072812')) 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 ('2072812'))
  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 ('2072812'))
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 GAA18CA488Accident · No injuriesData collectionFinal reportCessna 185 · Brooks Range, AKThe airplane's encounter with downdraft conditions during takeoff, which resulted in a subsequent loss of altitude and collision with terrain.Aug 12, 2018 · N62882 · Substantial damage NTSB GAA16CA503Accident · Minor injuriesData collectionFinal reportCessna 185 · Fairbanks, AKThe pilot’s failure to recognize he was taking off with a tailwind and his inadequate compensation for taking off with a tailwind, which led to the airplane’s failure to attain a climb and a subsequent forced landing.Sep 22, 2016 · N5892T · Substantial damage NTSB ANC13CA075Accident · No injuriesData collectionFinal reportCessna 185D · North Pole, AKThe malfunction of the right main wheel brake during taxi due to a faulty O-ring in the right brake pedal master cylinder.Aug 8, 2013 · N75LE · Substantial damage NTSB ANC98LA106Accident · No injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe pilot's failure to maintain directional control.Jul 23, 1998 · N5892T · Substantial damage NTSB ANC93LA086Accident · No injuriesLimited investigationFinal reportCessna 185 · Barrow, AKThe fatigue fracture of the main landing gear spring.May 23, 1993 · N75LE · Substantial damage NTSB ANC89LA111Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. The crosswind and gusts were contributing factors.Jul 1, 1989 · N75LE · Substantial damage NTSB ANC87LA027Accident · No injuriesLimited investigationFinal reportCessna 185D · North Pole, AKThe pilot stated that during the right downwind approach to the airstrip the aircraft ran out of fuel; the engine quit and then he attempted an emergency landing. The plt attempted to land on the rwy. Inspection revealed no fuel in the acft and the fuel…Jan 27, 1987 · N75LE · Substantial damage NTSB ANC85LA095Accident · No injuriesLimited investigationFinal reportCessna 185 · Kantishna, AKThe plt was on a flt from fairbanks to Kantishna, AK; however, the rwy at Kantishna was muddy, so he elected to return to fairbanks. While returning, he elected to land at an abandoned mine strip for a comfort stop. During the landing, a hydraulic line to the…Jun 14, 1985 · N75LE · Substantial damage NTSB ANC84FA027Accident · Serious injuriesField investigationFinal reportCessna C-185-D · Anchorage, AKThe acft crashed shortly after takeoff following a power loss. The plt stated that smoke entered the cockpit from the heat vents. He thought the smoke was from residual oil spilled on the engine during an oil change and he pulled the engine cut off mistaking…Dec 19, 1983 · N5886T · Substantial damage NTSB ANC81DA006Accident · No injuriesClosedCessna 185 · Fort Yukon, AKNov 26, 1980 · N75LE · Substantial damage NTSB ANC78FA049Accident · Minor injuriesClosedCessna 185 · Kotzebue, AKJul 11, 1978 · N5885T · Substantial damage NTSB ANC78DAG17Accident · Serious injuriesClosedCessna 185D · Mt.Susitna, AKDec 27, 1977 · N1553F · Substantial damage NTSB ANC76DAG46Accident · No injuriesClosedCessna 185 · Cordova, AKSep 19, 1975 · N5886T · Substantial damage NTSB ANC75DAG27Accident · No injuriesClosedCessna 185 · Glennallen, AKSep 1, 1974 · N1516F · Substantial damage NTSB ANC74DAG67Accident · Minor injuriesClosedCessna 185 · Anchorage, AKOct 13, 1973 · N1531F · Substantial damage NTSB ANC70AA086Accident · No injuriesClosedCessna 185 · Ketchikan, AKJun 8, 1970 · N1523F · Substantial damage NTSB ANC70A0011Accident · No injuriesClosedCessna 185 · Seward, AKJul 25, 1969 · N5886T · Substantial damage NTSB ANC67D0084Accident · No injuriesClosedCessna 185 · Healy Fork, AKFeb 21, 1967 · N685LA · Substantial damage NTSB ANC66D0107Accident · No injuriesClosedCessna 185 · North Pole, AKMay 19, 1966 · N685LA · Substantial damage NTSB ANC66A0042Accident · No injuriesClosedCessna 185 · Anchorage, AKMay 2, 1966 · N5892T · Substantial damage