NTSB investigations: Cessna A185E

7 cases on aircraft the registry lists as Cessna A185E, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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

19822026

NTSB investigations: Cessna A185E per year, 1982–2026: 7 cases
1982	1
1986	1
1989	2
1990	1
1991	1
1997	1

Where

Open the map

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 ('2072818') 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" = 353)) 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 ('2072818')
      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\" = 353))
  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 ('2072818')
    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" = 353))
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 ANC97LA153Accident · No injuriesLimited investigationFinal reportCessna 185E · Wasilla, AKThe loss of engine power due to water contaminated fuel, and the pilot's inadequate preflight inspection of the airplane. A factor associated with the accident was the lack of suitable terrain for a forced landing.Sep 21, 1997 · N70122 · Substantial damage NTSB ANC91LA074Accident · No injuriesLimited investigationFinal reportCessna A185E · King Salmon, AKFuel exhaustion, the pilot's inadequate preflight and the inadequate fuel consumption calculations. Contributing to the accident was the soft terrain, and tundra.Jun 15, 1991 · N70148 · Substantial damage NTSB ANC90LA058Accident · No injuriesLimited investigationFinal reportCessna 185E · Bethel, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadeqaute supply of fuel.Apr 16, 1990 · N2214T · Substantial damage NTSB ANC90LA006Accident · No injuriesLimited investigationFinal reportCessna 185 · Tuluksak, AKMounting shaft (airbox through-shaft) for the throttle and mixture controls had become loose and backed out, which resulted in loss of engine power. Factors related to the accident were: darkness and rough terrain.Oct 15, 1989 · N70022 · Substantial damage NTSB ANC89LA052Accident · No injuriesLimited investigationFinal reportCessna 185E · Alexander Lake, AKThe pilot's improper in-flight planning, decisions which resulted in exceeding the amount of fuel available which resulted in fuel exhaustion.Mar 9, 1989 · N70122 · Substantial damage NTSB SEA86LA241Accident · Minor injuriesLimited investigationFinal reportCessna 185 · St. John, WAAfter running a fuel tank dry in flight, the plt switched fuel tanks but failed to assure that the fuel selector was in the detent. The engine quit running and a forced landing was made in rough terrain.Sep 7, 1986 · N2262T · Substantial damage NTSB NYC82DA120Accident · No injuriesFinal reportCessna 185E · Round Lake, NYThe pilot stated that during his preflight, he drained the main sediment bowl for 5 seconds, then repeated draining it for another 5 seconds. He reported that he performed an engine run-up, switched all tanks on, and initiated a takeoff. Reportedly, the…Jun 9, 1982 · N70232 · Substantial damage