NTSB investigations: Beech G35, MI

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

NTSB investigations: Beech G35, MI per year, 1964–2026: 9 cases
1964	1
1966	2
1967	1
1968	1
1969	1
1975	1
1981	1
1997	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 ('1151516')) 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 ('1151516'))
  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 ('1151516'))
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 CHI97LA268Accident · No injuriesLimited investigationFinal reportBeech G35 · Belleville, MIthe pilot's improper planning/decision by failing to assure that the airplane was either tied down or chocked prior to pulling the propeller through, which started the engine with no one at the controls.Aug 21, 1997 · N4630D · Substantial damage NTSB CHI82FEC04Accident · No injuriesClosedBeech G-35 · Pontiac, MIOct 17, 1981 · N4653D · Substantial damage NTSB CHI75DEM29Accident · No injuriesClosedBeech 35 · Gladwin, MIMar 1, 1975 · N4416D · Substantial damage NTSB CHI69F0422Accident · No injuriesClosedBeech G35 · Ypsilanti, MIJan 11, 1969 · N4233D · Substantial damage NTSB CHI68F0538Accident · No injuriesClosedBeech G35 · Newberry, MIJan 8, 1968 · N4574D · Substantial damage NTSB CHI68A0050Accident · 2 fatalClosedBeech G35 · Cadillac, MINov 26, 1967 · N4445D · Destroyed NTSB CHI66F0661Accident · No injuriesClosedBeech G35 · Gladwin, MIMar 28, 1966 · N4416D · Substantial damage NTSB CHI66F0522Accident · No injuriesClosedBeechcraft G35 · Benton Harbor, MIJan 5, 1966 · N4226D · Substantial damage NTSB UNK65X0410Accident · No injuriesClosedBeechcraft G35 · Ann Arbor, MIOct 24, 1964 · N934D · Substantial damage