Skip to content

NTSB investigations: Beech G35, CA

26 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

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 ('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\" = '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 ('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" = '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 ('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 WPR16FA007Accident · 2 fatalField investigationFinal reportBeech G35 · South Lake Tahoe, CAThe pilot's inability to maintain airplane control due to an encounter with a downdraft that exceeded the airplane’s climb performance capabilities and resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to depart without…Oct 11, 2015 · N4485D · Destroyed NTSB WPR14CA060Accident · No injuriesData collectionFinal reportBeech G35 · Placerville, CAThe airplane's collision with a deer on the runway during landing.Dec 2, 2013 · N145WP · Substantial damage NTSB WPR12LA396Accident · No injuriesLimited investigationFinal reportBeech G35 · Oceano, CAThe pilot’s exceedance of the design maneuvering speed during descent in turbulence, which resulted in structural damage to the aft fuselage.Aug 31, 2012 · N4454D · Substantial damage NTSB LAX02FA134Accident · 2 fatalField investigationFinal reportBeech G35 · Willows, CAthe pilot's entry into an abrupt maneuver at an excessive airspeed beyond Va, which resulted in exceeding the aircraft's design stress limits.Apr 11, 2002 · N4487D · Destroyed NTSB LAX00LA234Accident · 1 fatalLimited investigationFinal reportBeech G35 · Byron, CAin-flight loss of control and inadvertent stall.Jun 19, 2000 · N5801 · Destroyed NTSB LAX91FA292Accident · 2 fatalField investigationFinal reportBeech G35 · Pacoima, CAImproper positioning of the fuel selector by the pilot, which resulted in fuel starvation.Jul 6, 1991 · N164N · Destroyed NTSB LAX85FA067Accident · Serious injuriesField investigationFinal reportBeech G35 · Lakeport, CAAt aprx 150 ft AGL the acft's lost pwr & plt made a tail first hard landing off side of rwy. Acft skidded 60 ft before stopping when it hit a fence. Fuel selector was found in 'aux' position. Plt said he took off on left tank and was moving selector to rt…Dec 12, 1984 · N430WM · Substantial damage NTSB LAX80DA133Accident · 1 fatalClosedBeech 35 · Shelter Cove, CAJul 31, 1980 · N119B · Destroyed NTSB LAX77FUQ26Accident · Minor injuriesClosedBeech G35 · Quartz Hill, CAApr 16, 1977 · N4591D · Substantial damage NTSB OAK76FXQ11Accident · Minor injuriesClosedBeech G35 · Herlong, CAAug 27, 1975 · N4546D · Destroyed NTSB LAX69D0248Accident · Serious injuriesClosedBeech 35G · Van Nuys, CAOct 23, 1968 · N4546D · No damage NTSB LAX67D0366Accident · No injuriesClosedBeech G35 · Bakersfield, CAApr 1, 1967 · N311B · Substantial damage NTSB LAX67F0224Accident · No injuriesClosedBeech G35 · Van Nuys, CANov 27, 1966 · N4502D · Substantial damage NTSB OAK67D0112Accident · No injuriesClosedBeech G35 · Columbia, CASep 27, 1966 · N5095B · Substantial damage NTSB OAK67D0140Accident · No injuriesClosedBeech G35 · Willits, CAJul 4, 1966 · N4597D · Substantial damage NTSB LAX66D0366Accident · No injuriesClosedBeech G35 · Santee, CAMay 30, 1966 · N4490D · Substantial damage NTSB OAK66A0040Accident · 1 fatalClosedBeech G35 · Modesto, CAMar 25, 1966 · N113W · Destroyed NTSB OAK66D0193Accident · No injuriesClosedBeechcraft G35 · Merced, CAJan 30, 1966 · N5095B · Substantial damage NTSB LAX66F0207Accident · No injuriesClosedBeechcraft 35 · Oxnard, CADec 15, 1965 · N306B · Substantial damage NTSB OAK66D0144Accident · No injuriesClosedBeech G35 · Santa Rosa, CAOct 15, 1965 · N4628D · Substantial damage NTSB LAX66F0091Accident · No injuriesClosedBeechcraft G-35 · National City, CAAug 31, 1965 · N335B · Substantial damage NTSB OAK65F0027Accident · No injuriesClosedBeechcraft G-35 · Snelling, CAApr 13, 1965 · N4259D · Substantial damage NTSB UNK65X0565Accident · No injuriesClosedBeechcraft 35 · Concord, CANov 5, 1964 · N4256D · Substantial damage NTSB UNK64X2714Accident · No injuriesClosedBeechcraft G35 · Sacramento, CAJul 8, 1964 · N5096B · Substantial damage NTSB UNK64X1467Accident · No injuriesClosedBeechcraft G35 · Thousand Oaks, CAApr 26, 1964 · N4433D · Substantial damage NTSB UNK64X0528Accident · No injuriesClosedBeechcraft H35 · Truckee, CAFeb 10, 1964 · N4643D · Substantial damage