NTSB investigations: Beech 35-33, CA
14 cases on aircraft the registry lists as Beech 35-33. 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 | 2 |
| 1966 | 1 |
| 1969 | 1 |
| 1970 | 2 |
| 1975 | 1 |
| 1977 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 2000 | 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 ('1151402'))
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 ('1151402'))
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 LAX01FA014Accident · 2 fatalField investigationFinal reportBeech 35-33 · Monterey, CAThe pilot's inadequate in-flight planning/decision by which he conducted visual flight into instrument meteorological conditions and his failure to maintain control of the airplane. Contributing factors were low ceiling, spatial disorientation and lack of…NTSB LAX97LA042Accident · Serious injuriesLimited investigationFinal reportBeech 35-33 · Apple Valley, CAfuel starvation, due to plugged fuel system vent lines, which resulted in loss of engine power.NTSB LAX90FA211Accident · 1 fatalField investigationFinal reportBeech 35-33 · Paso Robles, CAUndetermined.NTSB LAX90LA057Accident · Minor injuriesLimited investigationFinal reportBeech 33 · Gorman, CAThe malfunctioning propeller governor, and the pilot's misjudgement of altitude and distance of the approach path during an emergency landing. Factors contributing to the accident were: the power lines across the approach path to the runway and the…NTSB OAK77FA035Accident · 2 fatalClosedBeech A33 · Coalinga, CANTSB OAK77FA022Accident · 2 fatalClosedBeech 35 · Sacramento, CANTSB OAK76FVA22Accident · No injuriesClosedBeech 35-33 · Los Banos, CANTSB LAX71FUA27Accident · Serious injuriesClosedBeech 35-33 · Avalon, CANTSB LAX70DUG35Accident · No injuriesClosedBeech 35-33 · Daggett, CANTSB OAK70D0194Accident · No injuriesClosedBeech 35-33 · Selma, CANTSB OAK67F0079Accident · No injuriesClosedBeech 35-33 · Hanford, CANTSB LAX65A0075Accident · 1 fatalClosedBeech 35-33 · Frazier Pk, CANTSB OAK65A0047Accident · 4 fatalClosedPiper PA24 · Folsom Lake, CANTSB UNK64X1840Accident · No injuriesClosedBeechcraft 33 · Columbia, CA