Skip to content

NTSB investigations: Beech H35, CA

36 cases on aircraft the registry lists as Beech H35. 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

19652026

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 ('1151520')) 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 ('1151520'))
  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 ('1151520'))
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 WPR21LA075Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Santa Ynez, CAThe pilot’s mismanagement of fuel, which resulted in fuel starvation and a total loss of engine power.Dec 28, 2020 · N5474D · Substantial damage NTSB LAX97LA301Accident · No injuriesLimited investigationFinal reportBeech H35 · Goleta, CAwas a loss of engine power for undetermined reasons.Aug 25, 1997 · N222M · Destroyed NTSB LAX97LA298Accident · No injuriesLimited investigationFinal reportBeech H35 · Vacaville, CAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was inoperative fuel gauges.Aug 22, 1997 · N4689D · Substantial damage NTSB LAX90LA178Accident · Serious injuriesLimited investigationFinal reportBeech H35 · San Marcos, CAThe pilot's improper fuel management.May 17, 1990 · N5586D · Substantial damage NTSB LAX89LA047Accident · No injuriesLimited investigationFinal reportBeech H35 · Corning, CAThe flt originated at hayward, CA, with a stop at san carlos, CA and Corning, CA. The plt's destination was the red bluff arpt (rbl). The plt reported that when he departed hayward both main fuel tanks were full. He flew to san carlos where he picked up three…Nov 12, 1988 · N5594D · Destroyed NTSB LAX87LA330Accident · No injuriesLimited investigationFinal reportBeech H35 · Avenal, CADuring a pleasure flight, the pilot noted that the oil pressure was reading low. The pilot decided to make a 180 degree turn to land at a nearby airport. En route the oil pressure continued to drop. During the first landing attempt the pilot stated the…Sep 9, 1987 · N7962D · Substantial damage NTSB LAX84LA112Accident · 1 fatalLimited investigationFinal reportBeech H35 · Modesto, CAThe plt taxied & initiated a takeoff without obtaining a clearance. The tower controller observed the acft take off, immediately turn left, then collide with a 10 ft dirt bank, located between the parallel rwys. After hitting the dirt bank, the acft skidded…Dec 22, 1983 · N5441D · Destroyed NTSB LAX83FA256Accident · 4 fatalField investigationFinal reportBeech H35 · Antioch, CAThe acft collided with the ground in a nose low attitude during flt in the traffic pattern to land. Witnesses described the pattern as being close in, slow and low compared to normal traffic. The attitude of the acft was described as nose high. As the acft…May 31, 1983 · N391B · Destroyed NTSB LAX80FVM08Accident · No injuriesClosedBeech H35 · San Jose, CADec 5, 1979 · N391B · Substantial damage NTSB OAK79FVM20Accident · Minor injuriesClosedBeech H35 · Palo Alto, CAMay 13, 1979 · N7944D · Substantial damage NTSB LAX79DVA25Accident · No injuriesClosedBeech H35 · Porterville, CAApr 14, 1979 · N202BC · Substantial damage NTSB OAK78FVD04Accident · Serious injuriesClosedBeech H35 · Novato, CAOct 25, 1977 · N388B · Substantial damage NTSB LAX77FUA09Accident · No injuriesClosedBeech H35 · Fullerton, CAApr 13, 1977 · N225X · Substantial damage NTSB LAX77FA032Accident · 1 fatalClosedBeech H35 · Wrightwood, CAMar 24, 1977 · N5508D · Destroyed NTSB OAK77FA007Accident · 4 fatalClosedBeech H-35 · Vacaville, CADec 18, 1976 · N5458D · Destroyed NTSB LAX76FUQ12Accident · No injuriesClosedBeech H35 · Burbank, CAOct 12, 1975 · N4679D · Substantial damage NTSB OAK75FVM23Accident · Minor injuriesClosedBeech H35 · San Jose, CAMar 8, 1975 · N5433D · Substantial damage NTSB OAK75AP021Accident · 3 fatalClosedBeech H35 · Hayward, CADec 1, 1974 · N5419D · Destroyed NTSB OAK74AP021Accident · 2 fatalClosedBeech H35 · Georgetown, CADec 2, 1973 · N5581D · Destroyed NTSB LAX74DUM03Accident · No injuriesClosedBeech H35 · El Cajon, CAAug 19, 1973 · N7983D · Substantial damage NTSB LAX72FUG56Accident · No injuriesClosedBeech H35 · Corona, CAFeb 19, 1972 · N371B · Substantial damage NTSB OAK70AP043Accident · 6 fatalClosedPiper PA-28 · Placerville, CAFeb 14, 1970 · N5942W · 2 aircraft · Destroyed NTSB OAK70DXQ02Accident · No injuriesClosedBeech H35 · Susanville, CAJan 29, 1970 · N116QT · Substantial damage NTSB LAX70A0020Accident · 2 fatalClosedBeech H35 · Azusa, CAOct 3, 1969 · N5434D · Destroyed NTSB OAK69D0321Accident · No injuriesClosedBeech H35 · Dos Palos, CAMay 19, 1969 · N353B · Substantial damage NTSB LAX69F0299Accident · Minor injuriesClosedBeech H35 · Daggett, CAMar 8, 1969 · N5551D · Destroyed NTSB OAK69D0242Accident · No injuriesClosedBeech H35 · Oakland, CAMar 6, 1969 · N8213D · Substantial damage NTSB OAK68D0248Accident · No injuriesClosedBeech H35 · Monterey, CADec 11, 1967 · N4634D · Substantial damage NTSB OAK68D0190Accident · No injuriesClosedBeech H35 · Trinity Ctr, CASep 15, 1967 · N7971D · Substantial damage NTSB OAK68D0115Accident · No injuriesClosedBeech H35 · Watsonville, CAAug 26, 1967 · N5455D · Substantial damage NTSB OAK68F0121Accident · No injuriesClosedBeech H35 · San Carlos, CAJun 22, 1967 · N4683D · Substantial damage NTSB LAX67F0340Accident · No injuriesClosedBeech H35 · S.Barbara, CAMar 5, 1967 · N7928D · Substantial damage NTSB OAK67D0218Accident · No injuriesClosedBeech A35 · Visalia, CAJan 15, 1967 · N5428D · Substantial damage NTSB LAX66D0058Accident · No injuriesClosedBeechcraft H-35 · Chino, CAJul 28, 1965 · N5434D · Substantial damage NTSB LAX66D0016Accident · No injuriesClosedBeechcraft H-35 · Riverside, CAMar 7, 1965 · N7998D · Substantial damage NTSB OAK65D0024Accident · Minor injuriesClosedBeechcraft H-35 · Modesto, CAMar 3, 1965 · N5419D · Substantial damage