NTSB investigations: Beech M35, MO

13 cases on aircraft the registry lists as Beech M35. 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 M35, MO per year, 1964–2026: 13 cases
1964	1
1965	1
1966	1
1967	1
1972	2
1976	1
1977	1
1978	1
1982	1
1993	1
2004	1
2021	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" = 'MO' 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 ('1151526')) 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\" = 'MO' 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 ('1151526'))
  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" = 'MO' 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 ('1151526'))
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 CEN21LA453Accident · No injuriesClass 4 · LimitedFinal reportBeech M35 · Osage Beach, MOThe pilot and flight instructor’s failure to ensure that the landing gear were extended prior to landing.Sep 17, 2021 · N9835R · Substantial damage NTSB CHI04LA144Accident · No injuriesLimited investigationFinal reportBeech M35 · Strafford, MOThe improper installation of the cylinder during the engine overhaul which resulted in the fatigue failure of the cylinder studs and through-bolts and the subsequent separation of the cylinder. Factors associated with the accident were the fence and the guy…Jun 3, 2004 · N693V · Substantial damage NTSB CHI93LA360Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Marshfield, MOfuel exhaustion due to the failure of the fuel tank selector valve handle which prohibited the pilot from switching to a tank containing fuel.Sep 11, 1993 · N650V · Substantial damage NTSB MKC82IA070Incident · No injuriesIncident investigationFinal reportBeech M35 · Ava, MODuring a night cross-country from pryor, ok to Ava, MO, the aircraft experienced a total electrical failure as a result of a loose alternator belt and a depleted battery. On arrival at his destination, the pilot selected gear down with the normal extension…May 2, 1982 · N9783R · Minor damage NTSB MKC78FCA11Accident · Serious injuriesClosedBeech M35 · West Plains, MOJan 2, 1978 · N686V · Destroyed NTSB MKC77DCG36Accident · No injuriesClosedBeech M35 · Pleasant Hill, MOJul 4, 1977 · N9358Y · Substantial damage NTSB MKC76FCG89Accident · Minor injuriesClosedBeech M35 · Grain Valley, MOJul 23, 1976 · N9328Y · Destroyed NTSB MKC73FCG22Accident · No injuriesClosedBeech M35 · Independence, MODec 23, 1972 · N2028C · Substantial damage NTSB MKC72FCA25Accident · 1 fatalClosedBeech M35 · Florissant, MOMay 12, 1972 · N843R · Destroyed NTSB MKC68D0197Accident · No injuriesClosedBeech M35 · Keyetsville, MOMay 26, 1967 · N9884R · Substantial damage NTSB MKC66F0574Accident · No injuriesClosedBeech M35 · St. Joseph, MOMay 22, 1966 · N9730R · Substantial damage NTSB MKC66D0185Accident · No injuriesClosedBeechcraft M-35 · Osage Beach, MOAug 20, 1965 · N313Z · Substantial damage NTSB UNK64X1922Accident · No injuriesClosedBeechcraft M35 · Gainesville, MOMay 23, 1964 · N9818R · Substantial damage