NTSB investigations: Beech 35-B33, CA
18 cases on aircraft the registry lists as Beech 35-B33. 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
| 1964 | 1 |
|---|---|
| 1965 | 3 |
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1989 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2009 | 2 |
| 2011 | 1 |
| 2013 | 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 ('1151406'))
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 ('1151406'))
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 WPR13LA346Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Lone Pine, CAA partial loss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot's decision to not…NTSB WPR11FA192Accident · Serious injuriesField investigationFinal reportBeech 35-B33 · Camarillo, CAThe loss of engine power during the landing approach for undetermined reasons.NTSB WPR10LA053Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Chico, CAA loss of engine power during final approach for undetermined reasons.NTSB WPR09LA355Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Truckee, CAA loss of engine power during initial climb for undetermined reasons.NTSB LAX01FA222Accident · 1 fatalField investigationFinal reportBeech 35-B33 · Lakeside, CALoss of control in flight due to cardiovascular incapacitation.NTSB LAX98FA297Accident · 2 fatalField investigationFinal reportBeech 35-B33 · San Jose, CAthe pilot's loss of aircraft control and entry into a spiral dive for undetermined reasons. The dark night lighting conditions and the pilot's probable low recent flight experience were factors in this accident.NTSB LAX89FA082Accident · 3 fatalField investigationFinal reportBeech 35-B33 · Ripon, CAContinued flight by the pilot into known icing conditions and structural (wing) icing, which subsequently resulted in an uncontrolled stall. A contributing factor was the icing condition.NTSB LAX73AL018Accident · 4 fatalClosedBeech 35-B33 · Beaumont, CANTSB LAX72FUA01Accident · No injuriesClosedBeech 35-B33 · Torrance, CANTSB OAK71DVG30Accident · No injuriesClosedBeech 35-B33 · Wilbur Spgs, CANTSB LAX68A0083Accident · 3 fatalClosedBeech 35-B33 · Fullerton, CANTSB OAK68D0166Accident · No injuriesClosedBeech 35-B33 · San Jose, CANTSB OAK67D0108Accident · No injuriesClosedBeech 35-33 · Salinas, CANTSB LAX66D0204Accident · No injuriesClosedBeechcraft 35-33 · Burbank, CANTSB OAK66D0145Accident · No injuriesClosedBeechcraft 35-B33 · Merced, CANTSB OAK65D0072Accident · No injuriesClosedBeechcraft B-33 · Dos Palos, CANTSB OAK65F0051Accident · No injuriesClosedBeechcraft C-33 · Redding, CANTSB UNK64X4164Accident · No injuriesClosedBeechcraft 35B33 · Burmuda Dunes, CA