Fatal NTSB investigations: Beech C18S

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

19642026

Fatal NTSB investigations: Beech C18S per year, 1964–2026: 10 cases
1964	1
1965	3
1966	1
1967	1
1972	1
1980	1
1993	1
1999	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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1150902')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1150902'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1150902'))
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 FTW99FA148Accident · 1 fatalField investigationFinal reportBeech C18S · Waldron, ARthe separation of a propeller blade in cruise flight as a result of fatigue cracking emanating from surface corrosion pitting.May 24, 1999 · N9729H · Destroyed NTSB CHI93FA180Accident · 1 fatalField investigationFinal reportBeech C-18S · North Branch, MNexcessive use of brakes by the pilot-in-command.May 22, 1993 · N67E · Destroyed NTSB ATL80FA066Accident · 2 fatalClosedBeech C18S · Wassaw Is, GAJul 4, 1980 · N35MS · Destroyed NTSB DEN72AD045Accident · 7 fatalClosedBeech C-18S · Mcfadden, WYApr 2, 1972 · N1322M · Destroyed NTSB FTW68A0046Accident · 1 fatalClosedBeech C-18S · Brownsville, TXOct 21, 1967 · N6795C · Destroyed NTSB ANC67A0016Accident · 4 fatalClosedBeech C-18S · Anchorage, AKAug 15, 1966 · N445 · Destroyed NTSB MIA66A0031Accident · 3 fatalClosedBeech C-18S · St.Thomas, VISep 15, 1965 · N8063H · Destroyed NTSB LAX65A0093Accident · 9 fatalClosedBeechcraft C-18S · Corona Dl Mar, CAMay 29, 1965 · N9107R · Destroyed NTSB NYC65F0073Accident · 6 fatalClosedBeechcraft C-18S · Sonora, TXFeb 28, 1965 · N5974V · Destroyed NTSB UNK65X0728Accident · 4 fatalClosedBeech C18S · Fairfield, NJNov 15, 1964 · N39Q · Destroyed