Skip to content

NTSB investigations: Beech J35, CA

22 cases on aircraft the registry lists as Beech J35. 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 ('1151522')) 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 ('1151522'))
  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 ('1151522'))
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 LAX99FA270Accident · Serious injuriesField investigationFinal reportBeech J35 · Marysville, CAA loss of engine power due to improperly torque cylinder base nuts by maintenance personnel during a top overhaul.Aug 17, 1999 · N4932B · Destroyed NTSB LAX98FA086Accident · 1 fatalField investigationFinal reportBeech J35 · Morgan Hill, CAThe pilot-in-command's failure to maintain visual separation from N8343D approaching from his right. The controller's failure to provide a traffic advisory and the copilot's and flight engineer's inadequate visual lookout were factors.Feb 11, 1998 · N8343D · 2 aircraft · Destroyed NTSB LAX91LA358Accident · No injuriesLimited investigationFinal reportBeech J35 · San Jose, CAThe failure of the crankshaft counterweight retaining clip due to improper maintenance installation of the part.Aug 14, 1991 · N3028C · Substantial damage NTSB LAX86FUA01Accident · No injuriesFinal reportBeech J35 · Long Beach, CAThe acft collided with an object in flt. The plt reported that his right wing had been struck by what he thought was a large bird. After a safe landing at nearby Long Beach arpt the acft was examined. The rt wing had a hole aft of the leading edge and…Feb 27, 1986 · N7293B · Substantial damage NTSB LAX82FA071Accident · 4 fatalField investigationFinal reportBeech J35 · Gilroy, CAThe plt was advised during the wx briefing that VFR flight was not recommeded across the mountains & that san jose was reporting 3,000 ft scattered; 4,000 ft broken; 9,000 ft overcast with 10 mi visibility with light rain. Approximately 36 min after takeoff…Feb 13, 1982 · N8385D · Destroyed NTSB LAX82FUA03Accident · No injuriesClosedBeech J35 · Torrance, CAOct 23, 1981 · N8377D · Destroyed NTSB LAX81FA084Accident · 4 fatalClosedBeech J35 · Burbank, CAMay 10, 1981 · N7283B · Destroyed NTSB LAX80FVD35Accident · No injuriesClosedBeech J35 · Santa Rosa, CAAug 10, 1980 · N7251B · Substantial damage NTSB LAX80DVA59Accident · No injuriesClosedBeech J35 · Bakersfield, CAAug 6, 1980 · N3014C · Substantial damage NTSB OAK70A0032Accident · 4 fatalClosedBeech J35 · Benton Sta, CADec 8, 1969 · N669B · Destroyed NTSB OAK69D0315Accident · No injuriesClosedBeech J35 · Oceano, CAApr 23, 1969 · N8259D · Substantial damage NTSB LAX69D0236Accident · No injuriesClosedBeech J35 · Santa Monica, CAOct 28, 1968 · N8300D · Substantial damage NTSB LAX69D0170Accident · No injuriesClosedBeech J35 · Brawley, CASep 9, 1968 · N8237D · Substantial damage NTSB OAK68D0199Accident · No injuriesClosedBeech J35 · Oakland, CANov 10, 1967 · N632B · Substantial damage NTSB LAX67D0430Accident · No injuriesClosedBeech J35 · Blythe, CAMay 9, 1967 · N571B · Substantial damage NTSB OAK67D0273Accident · No injuriesClosedBeech 35 · Novato, CAMar 5, 1967 · N8259D · Substantial damage NTSB OAK67F0211Accident · No injuriesClosedBeech J35 · Oceano, CADec 28, 1966 · N8259D · Substantial damage NTSB LAX67D0220Accident · No injuriesClosedBeech J35 · Goleta, CANov 24, 1966 · N735B · No damage NTSB LAX67D0124Accident · No injuriesClosedBeech J35 · Catalina Isle, CAAug 9, 1966 · N8259D · Substantial damage NTSB LAX66D0294Accident · No injuriesClosedBeech J35 · Sunset Beach, CAJan 23, 1966 · N8357D · Substantial damage NTSB OAK65D0061Accident · No injuriesClosedBeechcraft J-35 · Oakland, CAMay 2, 1965 · N614T · Substantial damage NTSB UNK64X0411Accident · No injuriesClosedBeechcraft J35 · Carlsbad, CAJan 31, 1964 · N8391D · Substantial damage