Skip to content

NTSB investigations: Beech F35, CA

30 cases on aircraft the registry lists as Beech F35. 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 ('1151514')) 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 ('1151514'))
  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 ('1151514'))
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 WPR15FA222Accident · 1 fatalField investigationFinal reportBeech F35 · Riverside, CAThe total loss of engine power for reasons that could not be determined during postaccident examination of the airplane and engine. Also causal to the accident was the pilot's decision to attempt to reach the farthest runway and land into the wind instead of…Jul 27, 2015 · N988RH · Destroyed NTSB SEA08LA012Accident · No injuriesLimited investigationFinal reportBeech F35 · San Carlos, CAA total loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.Oct 27, 2007 · N5050B · Substantial damage NTSB LAX03LA082Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Middletown, CAThe pilot's failure to attain an adequate takeoff airspeed and failure to abort the takeoff when the lack of acceleration was apparent.Feb 4, 2003 · N3361C · Substantial damage NTSB LAX03LA024Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Santa Ana, CAThe pilot's encounter with wake turbulence resulting in a loss of control. A related factor was insufficient separation by air traffic control.Nov 7, 2002 · N3373C · Substantial damage NTSB LAX99FA077Accident · 4 fatalField investigationFinal reportBeech F35 · Chino, CAThe pilot's intentional flight into known instrument meteorological conditions in hilly terrain and his failure to maintain aircraft control due to spatial disorientation. Factors were the pilot's inadequate evaluation of the weather conditions, dark night…Jan 19, 1999 · N3364C · Destroyed NTSB LAX90FA017Accident · 2 fatalField investigationFinal reportBeech F35 · Lake Berryessa, CAInadequate visual lookout by the pilot and his failure to maintain proper altitude. The power lines was a related factor.Oct 26, 1989 · N5034B · Destroyed NTSB LAX88LA116Accident · No injuriesLimited investigationFinal reportBeech F35 · Pacoima, CAThe plt rprtd that he had initially psnd the fuel selector (sel) to the left main tank. He said that after abt 1 hr of flt (near palmdale, CA), he psnd the sel to the rgt main tank for a short time, then (near Pacoima), he moved it back to the left main tank.…Feb 25, 1988 · N5041B · Substantial damage NTSB LAX79FUG55Accident · No injuriesClosedBeech F35 · El Monte, CASep 6, 1979 · N3219C · Substantial damage NTSB OAK79DVG56Accident · No injuriesClosedBeech F-35 · Napa, CAJun 24, 1979 · N3354C · Substantial damage NTSB OAK76DVA88Accident · No injuriesClosedBeech F35 · Visalia, CASep 10, 1976 · N3858B · Substantial damage NTSB LAX76AL055Accident · 1 fatalClosedBeech F35 · Crestline, CAFeb 15, 1976 · N5088B · Destroyed NTSB OAK75FVG25Accident · Minor injuriesClosedBeech F35 · Live Oak, CASep 28, 1974 · N3396C · Substantial damage NTSB LAX75DUG06Accident · No injuriesClosedBeech F35 · Laverne, CAAug 1, 1974 · N3269C · Substantial damage NTSB LAX74FUG09Accident · No injuriesClosedBeech F35 · Riverside, CAJul 5, 1973 · N3849B · Destroyed NTSB OAK73AP022Accident · 1 fatalClosedBeech F35 · San Fran, CAJan 13, 1973 · N5000B · Destroyed NTSB LAX70DUG23Accident · No injuriesClosedBeech F35 · Parker Dam, CAMar 25, 1970 · N3849B · Substantial damage NTSB LAX69F0310Accident · No injuriesClosedBeech F35 · Burbank, CAApr 8, 1969 · N3219C · Substantial damage NTSB OAK69A0032Accident · 3 fatalClosedBeech F35 · Gustine, CANov 20, 1968 · N3854B · Destroyed NTSB LAX69F0174Accident · Minor injuriesClosedBeech F35 · Calexico, CAOct 20, 1968 · N4275B · Destroyed NTSB LAX69A0020Accident · 1 fatalClosedBeech F35 · Los Angeles, CAOct 2, 1968 · N4226B · Destroyed NTSB OAK69D0053Accident · No injuriesClosedBeech F35 · Vacaville, CAJul 1, 1968 · N5073B · Substantial damage NTSB OAK68D0124Accident · No injuriesClosedBeech F35 · Carmel Vall, CAAug 26, 1967 · N5043B · Substantial damage NTSB OAK67D0231Accident · No injuriesClosedBeech F35 · Stockton, CAFeb 17, 1967 · N5008B · Substantial damage NTSB LAX67D0275Accident · No injuriesClosedBeech F35 · Bakersfield, CAJan 21, 1967 · N3381C · Substantial damage NTSB OAK67D0119Accident · No injuriesClosedBeech F35 · Salinas, CAOct 20, 1966 · N3286C · Substantial damage NTSB OAK67F0040Accident · No injuriesClosedBeech F35 · Fresno, CAJul 22, 1966 · N3381C · Substantial damage NTSB OAK66D0217Accident · No injuriesClosedBeechcraft F35 · Monterey, CAMar 19, 1966 · N4920B · Substantial damage NTSB LAX66F0213Accident · Serious injuriesClosedBeech F35 · Tujunga, CAJan 15, 1966 · N3392C · Destroyed NTSB OAK66F0043Accident · Minor injuriesClosedBeechcraft F-35 · Redding, CAMay 26, 1965 · N3374C · Substantial damage NTSB LAX65F0041Accident · No injuriesClosedBeechcraft F-35 · Hawthorne, CAApr 13, 1965 · N3396C · Substantial damage