NTSB investigations: Beech D35, CA
22 cases on aircraft the registry lists as Beech D35. 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 | 5 |
| 1967 | 1 |
| 1968 | 2 |
| 1969 | 1 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1993 | 1 |
| 2000 | 1 |
| 2018 | 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 ('1151510'))
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 ('1151510'))
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 GAA18CA342Accident · No injuriesData collectionFinal reportBeech D35 · Corona, CAThe pilot’s inadvertent landing gear retraction during the landing roll.NTSB LAX00FA168Accident · 1 fatalField investigationFinal reportBeech D35 · Agua Dulce, CAThe pilot's failure to maintain terrain clearance while cruising up a mountain pass, on a dark night, in IMC conditions, and his improper in-flight decision to perform a VFR flight in the inclement weather.NTSB LAX93FA335Accident · 2 fatalField investigationFinal reportBeech D-35 · Alpine, CAThe failure of the pilot to maintain direction control during the initial takeoff climb which placed an obstruction in the airplane's takeoff flight path and a subsequent inadvertent stall. A factor in the accident was the existing crosswind.NTSB LAX79FA034Accident · 3 fatalClosedBeech D-35 · Los Angeles, CANTSB OAK76DVA02Accident · No injuriesClosedBeech D35 · Sanger, CANTSB OAK73DXQ18Accident · No injuriesClosedBeech D35 · Truckee, CANTSB OAK72DXQ09Accident · No injuriesClosedBeech D35 · Susanville, CANTSB OAK70FVA07Accident · No injuriesClosedBeech D35 · Fresno, CANTSB LAX70AL043Accident · 1 fatalClosedBeech D35 · Newhall, CANTSB OAK70D0049Accident · No injuriesClosedBeech D35 · Sanger, CANTSB LAX69D0187Accident · No injuriesClosedBeech D35 · Apple Valley, CANTSB LAX69F0169Accident · 1 fatalClosedBeech D35 · National City, CANTSB OAK68D0071Accident · No injuriesClosedBeech D35 · Arvin, CANTSB LAX67A0037Accident · 1 fatalClosedBeech D35 · Redlands, CANTSB LAX67D0150Accident · No injuriesClosedBeech D35 · Big Bear, CANTSB OAK66D0303Accident · No injuriesClosedBeech D35 · Mendota, CANTSB LAX66F0333Accident · No injuriesClosedBeech D35 · Ontario, CANTSB LAX66F0214Accident · No injuriesClosedBeechcraft D35 · San Diego, CANTSB LAX66F0087Accident · No injuriesClosedBeechcraft D-35 · Fallbrook, CANTSB OAK66F0017Accident · No injuriesClosedBeechcraft D-35 · Hayward, CANTSB LAX65D0017Accident · No injuriesClosedBeechcraft D-35 · Oxnard, CANTSB UNK64X2416Accident · No injuriesClosedBeechcraft D35 · Calexico, CA