NTSB investigations: Beech N35, CA
13 cases on aircraft the registry lists as Beech N35. 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.
Cases per year
| 1965 | 3 |
|---|---|
| 1966 | 2 |
| 1967 | 2 |
| 1968 | 1 |
| 1975 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('1151528'))
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 ('1151528'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 LAX90LA173Accident · No injuriesLimited investigationFinal reportBeech N35 · Los Banos, CAThe pilot's failure to maintain directional control of the aircraft during the takeoff roll.NTSB LAX89FA057Accident · 1 fatalField investigationFinal reportBeech N35 · Hanford, CAThe pilot failed to maintain sufficient altitude and descended below the minimum descent altitude while executing the missed approach. Contributing to this accident was the deteriorating weather conditions and the pilot's wish to return the airplane to its…NTSB LAX84LA345Accident · No injuriesLimited investigationFinal reportBeech 35 · Concord, CAThe plt stated he landed in a x-wind & wanted to raise the flaps but raised the gear instead.NTSB LAX83FA350Accident · 5 fatalField investigationFinal reportBeech N35 · Mount Shasta, CAThe acft flew into mt reddy at about 9000 ft level. The clouds were as low as 5000 and the mountain tops were obscured. The plts in flt wx briefing contained the advice that VFR flt along his route was not recommended because the mt tops were obscured in…NTSB LAX75AL030Accident · 2 fatalClosedBeech N35 · Daggett, CANTSB OAK69A0011Accident · 2 fatalClosedBeech N35 · Truckee, CANTSB LAX68D0098Accident · No injuriesClosedBeech N35 · Daggett, CANTSB LAX68A0014Accident · 3 fatalClosedBeech N35 · Los Angeles, CANTSB LAX67F0157Accident · No injuriesClosedBeech N35 · Santa Monica, CANTSB OAK67F0102Accident · No injuriesClosedBeech N35 · Hayward, CANTSB LAX66D0083Accident · No injuriesClosedBeechcraft 35 · Big Bear, CANTSB OAK66D0076Accident · No injuriesClosedBeechcraft N-35 · Trinity Cntr, CANTSB OAK65F0065Accident · No injuriesClosedBeechcraft N-35 · Stockton, CA