Skip to content

NTSB investigations: Beech K35, CA

29 cases on aircraft the registry lists as Beech K35. 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 ('1151524')) 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 ('1151524'))
  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 ('1151524'))
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 WPR22LA062Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Temecula, CAThe total loss of engine power for reasons that could not be determined from the available evidence.Dec 11, 2021 · N654HR · Substantial damage NTSB LAX05LA209Accident · Minor injuriesLimited investigationFinal reportBeechcraft K35 · Apple Valley, CAfuel starvation due to the pilot's inadequate in-flight fuel system management and failure to set the fuel selector valve to a tank containing fuel. A factor was the ditch that the aircraft encountered.Jun 18, 2005 · N3067C · Substantial damage NTSB LAX00FA300Accident · 1 fatalField investigationFinal reportBeech K35 · Newberry Spring, CAThe crankshaft's fatigue failure at the site of an electrical arc mark stress riser, during cruise flight. Contributing factors were the pilot's inadequate preflight inspection, improper decision, and maintenance.Aug 14, 2000 · N878R · Destroyed NTSB LAX92LA012Accident · No injuriesLimited investigationFinal reportBeech K35 · Grass Valley, CAThe inadvertent encounter with a microburst/downburst phenomena associated with thunderstorm activity. A factor in the accident was the failure of the pilot to adequately assess the weather conditions during the landing attempt.Oct 11, 1991 · N9559R · Substantial damage NTSB LAX89LA061Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Arbuckle, CADuring cruise flight, the pilot noted oil on the windshield. The pilot diverted to a nearby airport. Enroute the windshield became covered with oil. The pilot opted to make an emergency landing on a road. Due to power lines, he diverted to an open field. Just…Dec 7, 1988 · N9569R · Substantial damage NTSB LAX88LA232Accident · No injuriesLimited investigationFinal reportBeech B35 · Weaverville, CAJun 24, 1988 · N5354E · Substantial damage NTSB LAX87FA016Accident · No injuriesField investigationFinal reportBeech K35 · Bakersfield, CAThe flight was in level cruise at an altitude of 3,500 feet when the engine began to run rough. A precautionary landing was made. As the aircraft was touching down, tower personnel notified the pilot that the aircraft was on fire. The pilot evacuated the…Oct 15, 1986 · N107Q · Substantial damage NTSB LAX81FUG46Accident · No injuriesClosedBeech K35 · Temecula, CAAug 10, 1981 · N677T · Substantial damage NTSB LAX81DVA41Accident · No injuriesClosedBeech K35 · Groveland, CAMay 25, 1981 · N9570R · Substantial damage NTSB LAX81FA014Accident · 1 fatalClosedBeech K35 · Big Bear Lake, CANov 16, 1980 · N5362E · Destroyed NTSB LAX79DVA60Accident · No injuriesClosedBeech K35 · Oakdale, CAAug 17, 1979 · N9517R · Substantial damage NTSB LAX79DUG49Accident · No injuriesClosedBeech K-35 · Barstow, CAJul 7, 1979 · N677T · Substantial damage NTSB LAX77FA028Accident · 4 fatalClosedBeech K35 · Big Bear City, CAFeb 21, 1977 · N5315E · Destroyed NTSB OAK76AP028Accident · 2 fatalClosedBeech K35 · S.Lake Tahoe, CANov 11, 1975 · N3062C · Destroyed NTSB LAX71FUA59Accident · No injuriesClosedBeech K35 · Santa Ana, CAMay 9, 1971 · N5362E · Substantial damage NTSB LAX71FUA25Accident · No injuriesClosedBeech K35 · Santa Ana, CANov 8, 1970 · N5360E · Substantial damage NTSB LAX70AL047Accident · 1 fatalClosedBeech K35 · Wrightwood, CAFeb 9, 1970 · N618V · Destroyed NTSB LAX70A0017Accident · Minor injuriesClosedBeech K35 · Van Nuys, CASep 19, 1969 · N6093E · Destroyed NTSB OAK69F0090Accident · Serious injuriesClosedBeech K35 · Ukiah, CAAug 1, 1968 · N9515R · Destroyed NTSB LAX68A0079Accident · 3 fatalClosedBeech K35 · Redondo Bch, CAFeb 25, 1968 · N622LA · Destroyed NTSB OAK68D0083Accident · No injuriesClosedBeech K35 · Oakland, CAJul 3, 1967 · N680T · Substantial damage NTSB OAK68D0108Accident · No injuriesClosedBeech K35 · San Jose, CAJun 14, 1967 · N6048E · Substantial damage NTSB LAX67F0289Accident · No injuriesClosedBeech K35 · Palm Sprgs, CAJan 31, 1967 · N622LA · Substantial damage NTSB LAX66F0348Accident · Serious injuriesClosedBeech K35 · Bermuda Dunes, CAApr 4, 1966 · N6035E · Substantial damage NTSB LAX66A0275Accident · Serious injuriesClosedBeech K35 · Santa Ynez, CAFeb 25, 1966 · N3063C · Substantial damage NTSB LAX66F0053Accident · No injuriesClosedBeechcraft K-35 · Chino, CAJul 11, 1965 · N878R · Substantial damage NTSB LAX66F0022Accident · No injuriesClosedBeechcraft K-35 · Desert Center, CAFeb 26, 1965 · N3091C · Substantial damage NTSB UNK64X4179Accident · No injuriesClosedBeechcraft K35 · Turlock, CASep 27, 1964 · N246K · Substantial damage NTSB UNK64X0934Accident · Serious injuriesClosedBeechcraft K35 · San Fernando, CAMar 15, 1964 · N5370E · Destroyed