Skip to content

NTSB investigations: Beech P35, CA

25 cases on aircraft the registry lists as Beech P35. 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 ('1151530')) 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 ('1151530'))
  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 ('1151530'))
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 WPR23FA287Accident · 3 fatalClass 3 · FieldFinal reportBeech P35 · Upland, CAThe pilot’s exceedance of the airplane’s critical angle of attack, for reasons that could not be determined, which resulted in a subsequent aerodynamic stall and impact with a building.Jul 30, 2023 · N8572M · Substantial damage NTSB WPR23LA262Accident · Serious injuriesClass 4 · LimitedFinal reportBeech P35 · Shelter Cove, CAA partial loss of engine power for reasons that could not be determined because the airplane was not located and recovered.Jul 8, 2023 · N9520Y · Substantial damage NTSB LAX05FA076Accident · Minor injuriesField investigationFinal reportBeech P35 · Willits, CAThe pilot's failure to maintain control of the airplane during an instrument landing approach, resulting in an in-flight collision with trees and terrain. Factors contributing to the accident were turbulence, and the pilot's diverted attention.Jan 26, 2005 · N222V · Substantial damage NTSB LAX88LA062Accident · No injuriesLimited investigationFinal reportBeech P35 · Maricopa, CADuring a pleasure cross country flt, a precautionary landing was made due to smoke in the cockpit and a low oil pressure indication. After landing, it was found that the oil line to the oil pressure gauge was broken. After repairs, the plt took off and 10…Nov 27, 1987 · N413EE · Substantial damage NTSB LAX83LA233Incident · No injuriesLimited investigationFinal reportBeech 35P · San Rafael, CAThe plt reported that during his final apch to land, he observed an individual on a small lawn-type tractor, well clear on the left side of the rwy. Just after touchdown, as he was lowering the nose, he observed the tractor pass under the left wing of the…May 16, 1983 · N8512M · Minor damage NTSB LAX78FUQ34Accident · No injuriesClosedBeech P35 · Santa Paula, CAJun 18, 1978 · N1438G · Substantial damage NTSB LAX76AL039Accident · 3 fatalClosedBeech P35 · Big Bear City, CANov 28, 1975 · N1528Z · Destroyed NTSB OAK75AP050Accident · 1 fatalClosedBeech P35 · Chester, CAMay 4, 1975 · N53KW · Destroyed NTSB OAK74FVG68Accident · Serious injuriesClosedBeech P35 · Tulelake, CAJun 30, 1974 · N1534S · Destroyed NTSB OAK74AP034Accident · 2 fatalClosedBeech P35 · Gilroy, CAJan 18, 1974 · N1578S · Destroyed NTSB LAX73FUA10Accident · No injuriesClosedBeech P35 · Santa Ana, CASep 10, 1972 · N9728Y · Substantial damage NTSB LAX71FUA14Accident · No injuriesClosedBeech P35 · Huntngton B, CAAug 9, 1970 · N985Q · Substantial damage NTSB OAK71AP004Accident · 6 fatalClosedBeech P-35 · S.Lke Tahoe, CAJul 22, 1970 · N1536S · Destroyed NTSB LAX70AL062Accident · 1 fatalClosedBeech P35 · Brea, CAMar 30, 1970 · N8698M · Destroyed NTSB LAX70FUQ16Accident · Minor injuriesClosedBeech P35 · Goleta, CAMar 4, 1970 · N1578S · Substantial damage NTSB OAK69D0062Accident · 1 fatalClosedBeech P35 · San Francisco, CAJul 24, 1968 · N9640Y · No damage NTSB LAX69D0071Accident · No injuriesClosedBeech P35 · Lancaster, CAJul 7, 1968 · N1528Z · Substantial damage NTSB LAX68D0357Accident · No injuriesClosedBeech P35 · Thermal, CAMar 3, 1968 · N713WB · Substantial damage NTSB OAK68D0289Accident · No injuriesClosedBeech P35 · Half Moon Bay, CAFeb 18, 1968 · N446Q · Substantial damage NTSB LAX68F0308Accident · No injuriesClosedBeech P35 · Lakewood, CAJan 31, 1968 · N985Q · Substantial damage NTSB LAX67F0455Accident · No injuriesClosedBeech P35 · Torrance, CAMay 26, 1967 · N1593Z · Substantial damage NTSB LAX67F0214Accident · No injuriesClosedBeech P35 · Corona, CANov 17, 1966 · N1440G · Destroyed NTSB OAK66F0124Accident · No injuriesClosedBeechcraft B35 · Marysville, CAOct 26, 1965 · N9578Y · Substantial damage NTSB LAX65D0091Accident · No injuriesClosedBeechcraft P-35 · Sj Capistrano, CAJun 4, 1965 · N8698M · Substantial damage NTSB LAX65F0077Accident · No injuriesClosedBeechcraft P-35 · Torrance, CAApr 7, 1965 · N8905M · Substantial damage