NTSB investigations: Beech 95-B55 (T42A), MI

10 cases on aircraft the registry lists as Beech 95-B55 (T42A). 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

NTSB investigations: Beech 95-B55 (T42A), MI per year, 1965–2026: 10 cases
1965	1
1966	1
1967	2
1969	1
1973	1
1981	1
1990	1
1992	1
2008	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" = 'MI' 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 ('1152706')) 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\" = 'MI' 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 ('1152706'))
  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" = 'MI' 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 ('1152706'))
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 CHI08CA110Accident · No injuriesData collectionFinal reportBeech 95-B55 · Lansing, MIThe pilot's inadvertent raising of the landing gear during rollout.Apr 18, 2008 · N8991M · Substantial damage NTSB CHI92FAMS1Accident · 2 fatalMissing aircraftFinal reportBeech 95-BE55 · Benton Harbor, MIUndetermined.Feb 3, 1992 · N1123B · Destroyed NTSB CHI90LA139Accident · No injuriesLimited investigationFinal reportBeech B-55 · Detroit, MIThe pilot in command's execution of a turn shortly after takeoff resulting in loss of engine power due to fuel starvation and the pilot in command's execution of a turn back to the airport resulting in fuel starvation of the second engine which resulted in a…May 29, 1990 · N8390N · Substantial damage NTSB CHI82FET03Accident · No injuriesClosedBeech 95-B55 · Dowagiac, MIDec 26, 1981 · N2BB · Substantial damage NTSB CHI74DEM10Accident · No injuriesClosedBeech B95 · Northport, MIJul 27, 1973 · N9430 · Substantial damage NTSB CHI69D0539Accident · No injuriesClosedBeech 95-B55 · Niles, MIFeb 11, 1969 · N779NM · Substantial damage NTSB CHI68F0420Accident · Minor injuriesClosedBeech 95-55 · Prt St.James, MINov 5, 1967 · N8637Q · Destroyed NTSB CHI68F0332Accident · No injuriesClosedBeech 95B55 · Detroit, MISep 25, 1967 · N8991M · Substantial damage NTSB CHI67A0080Accident · No injuriesClosedBeech B95-B · Detroit, MIDec 19, 1966 · N9494S · Substantial damage NTSB CHI65F0003Accident · No injuriesClosedBeechraft B55 · Negaunee, MIJan 18, 1965 · N3001S · Substantial damage