Skip to content

NTSB investigations: Beech M35, TX

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" = 'TX' 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\" = 'TX' 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" = 'TX' 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 CEN23LA088Accident · No injuriesClass 3 · LimitedFinal reportBeech M35 · Tomball, TXA loss of engine power during cruise flight for undetermined reasons.Jan 22, 2023 · N9306Y · Substantial damage NTSB CEN21FA043Accident · 1 fatalClass 3 · FieldFinal reportBeech J35 · Fredericksburg, TXThe pilot of the J35’s failure to maintain clearance from the M35, which resulted in a midair collision and the J35 pilot’s subsequent loss of control and impact with terrain.Nov 6, 2020 · N617Q · 2 aircraft · Destroyed NTSB CEN20LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Seguin, TXThe pilot’s mismanagement of airspeed and glidepath during approach for a precautionary landing, which resulted in a runway excursion and a collision with a fence.Apr 1, 2020 · N9883R · Substantial damage NTSB FTW02LA001Accident · No injuriesLimited investigationFinal reportBeech M35 · Denton, TXthe loss of engine power for an undetermined reason, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.Oct 2, 2001 · N9765R · Substantial damage NTSB FTW97LA147Accident · No injuriesLimited investigationFinal reportBeech M35 · Iowa Park, TXThe pilot's refueling of the airplane with automotive grade fuel which resulted in engine failure due to detonation. A factor was the lack of suitable terrain for the forced landing.Mar 30, 1997 · N223C · Substantial damage NTSB FTW90LA103Accident · No injuriesLimited investigationFinal reportBeech BE-35M · Tomball, TXAn engine failure due to detonation and subsequent piston overtemperature and erosion. A factor related to the accident was the lack of suitable terrain.Apr 28, 1990 · N1ZY · Substantial damage NTSB FTW86FA035Accident · 3 fatalField investigationFinal reportBeech M-35 · Valley View, TXThe non-instrument rated pvt plt received a wx briefing that called for marginal VFR to IFR conditions throughout his route of flt. Destination wx was briefed as 700' ovc, vis 2 miles in haze and fog and the en route wx was considerably worse. Several…Jan 17, 1986 · N7BU · Destroyed NTSB FTW80DPD11Accident · No injuriesClosedBeech M35 · Wichita Falls, TXFeb 20, 1980 · N9860R · Substantial damage NTSB FTW75AF024Accident · 1 fatalClosedBeech M35 · Merkel, TXSep 24, 1974 · N364Z · Destroyed NTSB FTW72DRG68Accident · No injuriesClosedBeech M35 · San Marcos, TXApr 20, 1972 · N364Z · Substantial damage NTSB FTW69A0049Accident · 3 fatalClosedBeech M35 · Austin, TXJan 20, 1969 · N9927R · Destroyed NTSB FTW68F0539Accident · No injuriesClosedBeech M35 · Alief, TXMar 26, 1968 · N122X · Substantial damage NTSB FTW67D0653Accident · No injuriesClosedBeech M35 · Dallas, TXJun 3, 1967 · N136X · Substantial damage NTSB FTW67F0179Accident · No injuriesClosedBeech M35 · Austin, TXAug 16, 1966 · N9593R · Substantial damage NTSB FTW67F0004Accident · No injuriesClosedBeech M35 · Arlington, TXMay 23, 1966 · N9589R · Substantial damage NTSB FTW66F0300Accident · Serious injuriesClosedBeechcraft M35 · El Paso, TXSep 13, 1965 · N9709R · Destroyed NTSB FTW66D0008Accident · No injuriesClosedBeechcraft M-35 · Rankin, TXMar 14, 1965 · N9823R · Substantial damage NTSB UNK65X0699Accident · No injuriesClosedBeechcraft M35 · Midland, TXNov 14, 1964 · N9817R · Substantial damage