NTSB investigations: Beech D18S, AK

8 cases on aircraft the registry lists as Beech D18S. 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

NTSB investigations: Beech D18S, AK per year, 1966–2026: 8 cases
1966	1
1967	2
1977	2
1993	1
1997	1
2007	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."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 ('1151004')) 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 ('1151004'))
  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 ('1151004'))
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 ANC07LA032Accident · No injuriesLimited investigationFinal reportBeech D18S · Levelock, AKThe pilot's misjudged flare, which precipitated a hard landing, and damage to the main landing gear, resulting in a main landing gear collapse during the landing roll. A factor contributing to the accident was the overload failure of the main landing gear…Apr 26, 2007 · N502CK · Substantial damage NTSB ANC97LA090Accident · No injuriesLimited investigationFinal reportBeech D18S · Willow, AKThe loss of engine power for an undetermined reason.Jun 25, 1997 · N765D · Destroyed NTSB ANC93LA127Accident · Minor injuriesLimited investigationFinal reportBeech D18S · Kodiak, AKThe pilot's improper in flight planning/decision. A factor was the partial loss of power on one engine.Jul 25, 1993 · N2053D · Substantial damage NTSB ANC77DA058Incident · No injuriesClosedBeech E18S · Golovin, AKJul 11, 1977 · N80386 · Minor damage NTSB ANC77DA049Accident · No injuriesClosedBeech D18S · Quinhagak, AKMay 20, 1977 · N35W · Substantial damage NTSB ANC68D0073Accident · No injuriesClosedBeech D18S · Kodiak, AKNov 30, 1967 · N234S · Substantial damage NTSB ANC67A0055Accident · 2 fatalClosedBeech D18S · Kodiak, AKMar 16, 1967 · N80194 · Destroyed NTSB ANC67D0046Accident · No injuriesClosedBeech D18S · Kodiak, AKJun 23, 1966 · N234S · Substantial damage