Skip to content

NTSB investigations: Cessna 185E

14 cases on aircraft the registry lists as Cessna 185E. 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072816')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072816'))
  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 ('2072816'))
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 ANC21LA002Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Anchorage, AKThe pilot receiving instruction’s failure to maintain directional control during the landing roll, which resulted in a runway excursion onto soft terrain. Contributing to the accident was the flight instructor's inadequate supervision of the pilot while…Oct 20, 2020 · N850WB · Substantial damage NTSB WPR15CA102Accident · No injuriesData collectionFinal reportCessna 185 - E · Carson City, NVThe pilot's failure to maintain directional control during landing with a crosswind which resulted in a ground loop.Feb 11, 2015 · N185NV · Substantial damage NTSB ANC13CA106Accident · No injuriesData collectionFinal reportCessna 185E · Pilot Point, AKThe pilot's decision to land the airplane on the ramp, in the vicinity of buildings, in gusty wind conditions.Sep 29, 2013 · N1592F · Substantial damage NTSB ANC05LA142Accident · No injuriesLimited investigationFinal reportCessna 185E · Pilot Point, AKThe pilot's misjudged landing flare, which resulted in a hard landing and an overload failure of the main landing gear during the landing touchdown.Sep 10, 2005 · N1592F · Substantial damage NTSB ANC00GA071Accident · 4 fatalFinal reportCessna 185E · Talkeetna, AKThe pilot's continued flight into known adverse weather conditions and subsequent in-flight break-up. Factors in the accident were weather conditions consisting of low ceilings, turbulence, and an occluded front with convective activity, and inadequate…Jun 20, 2000 · N1589F · Destroyed NTSB ANC92LA096Accident · No injuriesLimited investigationFinal reportCessna 185 · Sole Lake, AKThe pilot in command's inadequate compensation for the wind conditions. Factor was the unfavorable wind.Jun 21, 1992 · N1589F · Substantial damage NTSB ANC90FA040Accident · No injuriesField investigationFinal reportCessna A185E · Alexander Lake, AKLoss of engine power for an unknown reason. Factors related to the accident were: darkness and trees in the emergency landing area.Mar 20, 1990 · N3386L · Substantial damage NTSB ANC90FA010Accident · No injuriesField investigationFinal reportCessna A185E · Anchorage, AKThe throttle control linkage became disconnected on the first flight after an annual inspection due to improper maintenance. Darkness and high vegetation were contributing factors.Nov 7, 1989 · N1592F · Substantial damage NTSB ANC88LA058Accident · No injuriesLimited investigationFinal reportCessna 185E · Tuntutuliak, AKThe private pilot-in-command of the Cessna 185 was performing business flying for the federal aviation administration. When he ran out of fuel during a cross country flight, he attempted an off-airport forced landing which resulted in a noseover accident. The…May 17, 1988 · N1592F · Substantial damage NTSB SEA79DTI07Accident · No injuriesClosedCessna 185E · Cut Bank, MTFeb 2, 1979 · N70263 · Substantial damage NTSB ANC77DA080Incident · No injuriesClosedCessna 185 · Barrow, AKAug 29, 1977 · N1592F · Minor damage NTSB ANC75DAA27Accident · No injuriesClosedCessna 185 · Oliktok, AKMar 21, 1975 · N1598F · Substantial damage NTSB ANC70AA089Accident · Serious injuriesClosedCessna 185 · Glenn Allen, AKJun 19, 1970 · N4521F · Substantial damage NTSB SEA67A0028Accident · 5 fatalClosedCessna 185E · Ngrangeville, IDSep 23, 1966 · N1590F · Destroyed