Skip to content

NTSB investigations · 25

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2072806') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2072806')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2072806')
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 ANC13CA028Accident · No injuriesData collectionFinal reportCessna 185B · Flat, AKThe pilot's inadequate compensation for gusting, variable wind conditions during initial climb after takeoff.Mar 5, 2013 · N2550Z · Substantial damage NTSB CHI02LA235Accident · Minor injuriesLimited investigationFinal reportCessna 185B · Brainerd, MNThe pilot's evasive maneuver to avoid obstacle clearance, resulting in a premature lift off with inadequate airspeed followed by a stall. The presence of the boat was a factor.Aug 4, 2002 · N11LP · Substantial damage NTSB DEN00LA103Accident · No injuriesLimited investigationFinal reportCessna 185B · Moab, UTThe fire in the engine compartment for unknown reason.Jun 6, 2000 · N185RL · Destroyed NTSB CHI98FA356Accident · 2 fatalField investigationFinal reportCessna 185B · Seymour Twp., WIthe pilots of both airplanes not maintaining visual separation from the other airplane.Sep 1, 1998 · N100TS · 2 aircraft · Destroyed NTSB ANC91LA002Accident · No injuriesLimited investigationFinal reportCessna 185B · Koyuktolik, AKPilot-in-command's failure to properly execute a stabilized approach to the first 1/3 of the runway. Contributing to the accident was the excessive airpseed maintained during the approach and landing.Oct 7, 1990 · N2525Z · Substantial damage NTSB ANC90LA145Accident · No injuriesLimited investigationFinal reportCessna 185B · Mcgrath, AKFailure of the left inside wheel bearing, for undetermined reasons.Aug 15, 1990 · N2550Z · Substantial damage NTSB NYC83LA247Accident · No injuriesLimited investigationFinal reportCessna 185B · Orange, MADuring arrival, the plt used a grass landing area on the north side of rwy 32/14. The wind had previously been from 290 deg, but had swung to 350 deg. The plt reported that he landed in a level attitude on the main gear, then reduced the throttle to idle.…Sep 18, 1983 · N11LP · Substantial damage NTSB CHI78DEP57Accident · No injuriesClosedCessna 185 · Juneau, WIAug 19, 1978 · N2638Z · Substantial damage NTSB ANC77FA083Accident · 3 fatalClosedCessna 185 · Minto Lake, AKSep 2, 1977 · N2563Z · 2 aircraft · Minor damage NTSB ANC76DAG91Accident · No injuriesClosedCessna 185 · Nondalton, AKJan 26, 1976 · N2550Z · Substantial damage NTSB ANC76DAG32Accident · No injuriesClosedCessna 185B · Gulkana, AKSep 1, 1975 · N62532 · Substantial damage NTSB ANC75AA028Accident · No injuriesClosedCessna 185 · Elim, AKSep 25, 1974 · N2588Z · Substantial damage NTSB ANC75PAG17Accident · No injuriesClosedCessna 185 · Anchorage, AKAug 22, 1974 · N2525Z · Substantial damage NTSB ANC75AA018Accident · No injuriesClosedCessna 185 · Kongiganak, AKAug 19, 1974 · N2554Z · Substantial damage NTSB ANC74AA010Accident · No injuriesClosedCessna 185 · Healy, AKJul 17, 1973 · N2554Z · Substantial damage NTSB MIA73AM106Accident · 1 fatalClosedCessna 185B · Sun City Ctr, FLJun 3, 1973 · N2560Z · Destroyed NTSB ANC73DAG01Accident · No injuriesClosedCessna 185B · Iliamna, AKJul 2, 1972 · N2550Z · Substantial damage NTSB ANC71DAG05Accident · Minor injuriesClosedCessna 185 · Kenai, AKJul 17, 1970 · N2579Z · Substantial damage NTSB LAX69F0352Accident · Minor injuriesClosedCessna 185B · Santa Mnica, CAApr 25, 1969 · N2569Z · Substantial damage NTSB MIA68F0422Accident · Minor injuriesClosedCessna 185B · Chamblee, GANov 15, 1967 · N2560Z · Substantial damage NTSB CHI66D0605Accident · No injuriesClosedCessna 185 · Marion, INFeb 16, 1966 · N2531Z · Substantial damage NTSB FTW66F0447Accident · No injuriesClosedCessna 185B · Orange, TXDec 6, 1965 · N2532Z · Substantial damage NTSB UNK65X0309Accident · 4 fatalClosedCessna 185B · Augusta, MTOct 17, 1964 · N2566Z · Destroyed NTSB UNK64X1206Accident · No injuriesClosedCessna 185 · Bull River, AKApr 6, 1964 · N2545Z · Substantial damage NTSB UNK64X0724Accident · Minor injuriesClosedCessna 185 · Ft Lobos, CAFeb 28, 1964 · N2517Z · Substantial damage

Back to Cessna 185B