Skip to content

NTSB investigations: Beech M35, CA

18 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

Where

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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 WPR16FA065Accident · 3 fatalField investigationFinal reportBeech M35 · San Pedro, CAThe failure of the pilots of both airplanes to see and avoid each other as they converged nearly head-on, which resulted in a midair collision. Contributing to the accident was sun glare on the pilot.Feb 5, 2016 · N9872R · 2 aircraft · Substantial damage NTSB LAX88DVM01Accident · No injuriesFinal reportBeech M35 · San Jose, CADuring a pleasure flight, while on final approach to the airport, the engine quit. The pilot made a forced landing in a shopping center parking lot, where the aircraft collided with three parked vehicles. Inspection of the engine did not identify any…Feb 9, 1988 · N2036C · Substantial damage NTSB LAX86FA247Accident · Serious injuriesField investigationFinal reportBeech M35 · Swall Meadows, CAThe civil air patrol (cap) organized & provided instructors to teach cap mission plts techniques of 'high altitude' search flying during a 2-DAY course. The curriculum included making a landing approach to a 6080 ft elevation airstrip. The approach was to be…Jun 7, 1986 · N398Z · Destroyed NTSB LAX84LA184Accident · No injuriesLimited investigationFinal reportBeech M35 · Santa Ana, CAThe plt reported that he had an electrical failure after takeoff. He remained in the traffic pattern & lowered the landing gear on the downwind leg. During the landing roll, all three gear collapsed. The plt did not manually crank the landing gear down. The…Feb 19, 1984 · N280AA · Substantial damage NTSB LAX82DA209Accident · No injuriesFinal reportBeech M35 · Coalinga, CAAs the pilot was arriving to an uncontrolled airport, he could see a group of planes on the runup pad at the approach end of the runway. As he continued with his arrival and approach, he radioed his intentions, but heard no transmissions from the departing…Jun 6, 1982 · N9824R · Substantial damage NTSB OAK78FVG77Accident · No injuriesClosedBeech M35 · Auburn, CAAug 28, 1978 · N9808R · Substantial damage NTSB LAX76AL080Accident · 4 fatalClosedBeech M35 · Irvine, CAMay 28, 1976 · N9887R · Destroyed NTSB LAX75AL050Accident · 2 fatalClosedBeech M35 · Alpine, CAApr 6, 1975 · N9803R · Destroyed NTSB LAX75AL039Accident · 1 fatalClosedBeech M35 · Lompoc, CAFeb 8, 1975 · N9845R · Destroyed NTSB OAK73FVA64Accident · No injuriesClosedBeech M35 · Modesto, CAJun 12, 1973 · N9777R · Substantial damage NTSB LAX69F0217Accident · No injuriesClosedBeech M35 · Fullerton, CADec 20, 1968 · N9303Y · Substantial damage NTSB OAK69D0001Accident · No injuriesClosedBeech M35 · S.L.Obispo, CAJun 1, 1968 · N9706R · Substantial damage NTSB OAK68D0215Accident · No injuriesClosedBeech M35 · Livermore, CANov 9, 1967 · N9845R · Substantial damage NTSB OAK67F0136Accident · No injuriesClosedBeech M35 · Nut Tree, CANov 1, 1966 · N9747R · Substantial damage NTSB OAK66F0230Accident · No injuriesClosedBeech M35 · Oakland, CAApr 15, 1966 · N9578R · Substantial damage NTSB OAK66A0016Accident · No injuriesClosedBeechcraft B35 · Marysville, CAOct 12, 1965 · N834R · Substantial damage NTSB UNK65X1078Accident · No injuriesClosedBeechraft M35 · Van Nuys, CADec 21, 1964 · N9775R · Substantial damage NTSB UNK64X1254Accident · No injuriesClosedBeechcraft M35 · Madera, CAApr 11, 1964 · N9861R · Substantial damage