NTSB investigations: Beech G18S, AK

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

19682026

NTSB investigations: Beech G18S, AK per year, 1968–2026: 9 cases
1968	1
1976	1
1977	2
1989	1
1995	1
1997	1
2009	1
2017	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 ('1151010')) 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 ('1151010'))
  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 ('1151010'))
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 ANC17LA017Accident · Minor injuriesLimited investigationFinal reportBeech G18 · Metlakatla, AKAn engine power loss for reasons that could not be determined because the airplane was not recovered.Mar 3, 2017 · N103AF · Substantial damage NTSB ANC09CA066Accident · No injuriesData collectionFinal reportBeech G18S · Yakutat, AKThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion, and main landing gear collapse.Jul 13, 2009 · N93CA · Substantial damage NTSB ANC97LA046Accident · No injuriesLimited investigationFinal reportBeech G18S · Nome, AKfracture of a propeller blade tip.Mar 21, 1997 · N555CG · Substantial damage NTSB ANC96LA020Accident · Minor injuriesLimited investigationFinal reportBeech G18S · Nome, AKThe pilot exceeding the weight and balance limitations of the airplane and improperly utilizing the airplane's elevator trim by selecting full nose up trim.Dec 18, 1995 · N340K · Substantial damage NTSB ANC90LA017Accident · No injuriesLimited investigationFinal reportBeech 18 · Brevig Mission, AKLoss of power in the the right engine for an unknown reason. The rough/uneven terrain was a contributing factor.Dec 23, 1989 · N220H · Substantial damage NTSB ANC77DAH08Accident · No injuriesClosedBeech G18S · Anchorage, AKAug 17, 1977 · N741GB · Substantial damage NTSB ANC77DA034Accident · No injuriesClosedBeech G18S · Tyonek, AKMar 4, 1977 · N9965L · Substantial damage NTSB ANC76AA114Accident · 5 fatalClosedVolpar C18S · Dutch Harbor, AKJul 22, 1976 · N600WA · Destroyed NTSB ANC69A0033Accident · Serious injuriesClosedBeech G18S · Kenai, AKDec 18, 1968 · N5730U · Destroyed