NTSB investigations: Beech B35, CA
40 cases on aircraft the registry lists as Beech B35. 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 | 6 |
|---|---|
| 1965 | 2 |
| 1966 | 5 |
| 1967 | 2 |
| 1968 | 3 |
| 1969 | 1 |
| 1970 | 2 |
| 1971 | 1 |
| 1973 | 2 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 4 |
| 1980 | 1 |
| 1982 | 2 |
| 1983 | 2 |
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 2010 | 1 |
Where
Latest 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 ('1151506'))
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 ('1151506'))
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 WPR10CA226Accident · No injuriesData collectionFinal reportBeech B35 · Burbank, CAThe airplane's encounter with turbulence while at an airspeed above maneuvering airspeed, which exceeded the limit load of the stabilizers and ruddervators.NTSB LAX89LA282Accident · Serious injuriesLimited investigationFinal reportBeech B35 · San Diego, CALoss of engine power for undetermined reasons. Factors that related to the accident were: unavaliable altitude, remedial action not possible, unsuitable terrain, high vegetation, and the trees.NTSB LAX88FA331Accident · 4 fatalField investigationFinal reportBeech B-35 · Ocotillo, CAInflight collision with terrain for undetermined reasons.NTSB LAX85FA100Accident · 4 fatalField investigationFinal reportBeech B-35 · Death Valley, CAThe plt got an extended wx fcst the day prior to departure which indicated bkn to ovc clouds based at about 8,000 ft for the first part of the trip & sct to bkn clouds for the last half. Mountain areas were predicted to be obscured. Plt was encouraged to call…NTSB LAX84FA048Accident · No injuriesField investigationFinal reportBeech B35 · Long Beach, CAThe plt reported that as he raised the landing gear during takeoff, the eng simultaneously lost power. He initiated an emergency landing on the remaining portion of the rwy. Acccording to him, the acft stalled while he was holding it in a nose high attitude &…NTSB LAX83IA342Incident · No injuriesIncident investigationFinal reportBeech B-35 · Fullerton, CAThe gear collapsed on the landing roll. Gear were found to be dry. Tge pilot had a gear flag but does not remember a green light.NTSB LAX83FVD03Accident · Serious injuriesFinal reportBeech B35 · Linden, CAThe aircraft engine lost power during a night cross-country. The pilot was forced to land in a grove of young walnut trees. The aircraft hit with one wing low and spun around. All motion stopped in a very short distance. An examination revealed that both fuel…NTSB LAX82DA091Accident · No injuriesFinal reportBeech B35 · La Jolla, CADuring flight over the water, the engine lost power and the pilot was unable to glide to a safe landing area on shore. The plane was ditched in the pacific ocean about 1/4 mile from the shore.NTSB LAX80DVA24Accident · No injuriesClosedBeech B35 · Bakersfield, CANTSB OAK77FA002Accident · 2 fatalClosedBeech B35 · Lower Lake, CANTSB LAX76AL085Accident · 5 fatalClosedBeech B35 · Rubidoux, CANTSB LAX76FUQ31Accident · No injuriesClosedBeech B35 · Sepulveda, CANTSB LAX76FUG37Accident · No injuriesClosedPiper PA-28 · Rice, CANTSB LAX75AL051Accident · 2 fatalClosedBeech B35 · Hawthorne, CANTSB LAX75DVA40Accident · No injuriesClosedBeech B35 · Bakersfield, CANTSB LAX75FUA13Accident · No injuriesClosedBeech B35 · Long Beach, CANTSB LAX74FUQ20Accident · No injuriesClosedBeech A35 · Burbank, CANTSB OAK73AP021Accident · 4 fatalClosedBeech B35 · June Lake, CANTSB OAK71DVG85Accident · No injuriesClosedBeech B35 · Rio Linda, CANTSB LAX71AL007Accident · 4 fatalClosedBeech B35 · Temecula, CANTSB OAK70FVD23Accident · Serious injuriesClosedBeech B35 · Concord, CANTSB LAX70D0065Accident · No injuriesClosedBeech B35 · Corona, CANTSB LAX69D0053Accident · No injuriesClosedBeech 35 · Gorman, CANTSB LAX68A0113Accident · 3 fatalClosedBeech B35 · Greenfield, CANTSB OAK68D0346Accident · No injuriesClosedBeech B35 · Stockton, CANTSB OAK68F0010Accident · No injuriesClosedBeech B35 · Redding, CANTSB OAK67A0059Accident · 4 fatalClosedBeech B35 · Mineral, CANTSB LAX67D0232Accident · No injuriesClosedBeech B35 · Hawthorne, CANTSB LAX67F0234Accident · No injuriesClosedBeech B35 · Long Beach, CANTSB LAX67D0243Accident · No injuriesClosedBeech B35 · Palm Desert, CANTSB LAX66A0094Accident · 2 fatalClosedBeech B35 · San L.Obispo, CANTSB LAX66D0342Accident · No injuriesClosedBeech N35 · Gorman, CANTSB OAK66A0010Accident · 1 fatalClosedBeechcraft B35 · Lone Pine, CANTSB LAX65F0034Accident · No injuriesClosedBeechcraft B-35 · Bishop, CANTSB UNK65X0697Accident · Minor injuriesClosedBeechcraft B35 · Long Beach, CANTSB UNK65X0683Accident · No injuriesClosedBeechcraft 35 · Long Beach, CANTSB UNK65X0490Accident · No injuriesClosedBeech B35 · Upland, CANTSB UNK64X3289Accident · No injuriesClosedBeechcraft B35 · Fresno, CANTSB UNK64X1062Accident · No injuriesClosedBeechcraft B35 · Napa, CANTSB UNK64X0985Accident · No injuriesClosedBeechcraft B35 · Long Beach, CA