Fatal NTSB investigations: Beech 95-55

13 cases on aircraft the registry lists as Beech 95-55. 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

19652026

Fatal NTSB investigations: Beech 95-55 per year, 1965–2026: 13 cases
1965	2
1967	1
1968	2
1969	2
1972	1
1973	1
1978	1
1990	1
1994	1
1998	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 ('1152702')) 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 ('1152702'))
  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 ('1152702'))
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 CHI98FA082Accident · 1 fatalField investigationFinal reportBeech 95-55 · Pinckneyville, ILThe pilot descent below minimum descent altitude and his intentional operation with known deficiencies in equipment. Factors were the dark night, fog, rain, and the trees.Jan 15, 1998 · N54643 · Destroyed NTSB MIA94FA141Accident · 1 fatalField investigationFinal reportBeech 95-55 · New Port Richey, FLThe pilot's feathering of the wrong propeller after an engine failure for undetermined reason(s).May 15, 1994 · N9319Y · Destroyed NTSB SEA91FA021Accident · 3 fatalField investigationFinal reportBeech 95-55 · Hayden Lake, IDThe pilot's improper IFR procedure in failing to intercept the proper glideslope path.Nov 22, 1990 · N903T · Destroyed NTSB IAD78FA030Accident · 1 fatalClosedBeech 55 · Lexington, KYJan 6, 1978 · N25N · Destroyed NTSB MKC74AK035Accident · 6 fatalClosedBeech 95-55 · New Salem, NDDec 24, 1973 · N9385Y · Destroyed NTSB NYC73AN048Accident · 5 fatalClosedBeech 95-55 · Hamburg, PASep 29, 1972 · N914Q · Destroyed NTSB DEN69A0050Accident · 2 fatalClosedBeech 95-55 · Lander, WYJun 13, 1969 · N1242Z · Destroyed NTSB NYC69A0095Accident · 5 fatalClosedCessna 150H · Middletown, RIApr 23, 1969 · N23140 · 2 aircraft · Destroyed NTSB DEN69A0028Accident · 1 fatalClosedBeech 95-55 · Eureka, UTNov 27, 1968 · N1347Z · Destroyed NTSB OAK68A0060Accident · 1 fatalClosedBeech 95 · Angels Camp, CAFeb 19, 1968 · N9379Y · Destroyed NTSB MIA67A0098Accident · 2 fatalClosedBeech 95-55 · Greenwood, MSMar 27, 1967 · N1333Z · Destroyed NTSB FTW66A0040Accident · 2 fatalClosedBeech 95-55 · Lawton, OKNov 3, 1965 · N1344Z · Destroyed NTSB DEN65A0059Accident · 4 fatalClosedBeechcraft 95-55 · Kingman, AZMar 12, 1965 · N1210Z · Destroyed