NTSB investigations: Beech E35, CA
16 cases on aircraft the registry lists as Beech E35. 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 | 1 |
| 1967 | 2 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1993 | 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 ('1151512'))
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 ('1151512'))
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 LAX93FA315Accident · 2 fatalField investigationFinal reportBeech E35 · Big Bear, CAA loss of engine power due to unporting of the selected main fuel tank at a critical time, which was caused by the pilot's failure to follow the directives in the flight manual regarding prolonged turns or slips with less than 10 gallons in the selected tank.NTSB OAK78FA005Accident · 4 fatalClosedBeech E35 · Willows, CANTSB OAK77DVA31Accident · No injuriesClosedBeech E35 · Turlock, CANTSB OAK76FVG79Accident · No injuriesClosedBeech E35 · Jackson, CANTSB OAK75FXQ34Accident · Serious injuriesClosedBeech E35 · Truckee, CANTSB OAK72AP031Accident · 1 fatalClosedBeech E35 · Dublin, CANTSB OAK71AP049Accident · 1 fatalClosedBeech E35 · Williams, CANTSB OAK70DVD27Accident · No injuriesClosedBeech E35 · Tracy, CANTSB LAX70DUG19Accident · No injuriesClosedBeech E35 · Blythe, CANTSB LAX68F0264Accident · No injuriesClosedBeech E35 · Calipatria, CANTSB OAK68D0016Accident · No injuriesClosedBeech E35 · Oakland, CANTSB LAX67F0106Accident · No injuriesClosedBeech E35 · Torrance, CANTSB OAK66F0099Accident · No injuriesClosedBeechcraft E-35 · Modesto, CANTSB UNK65X1526Accident · No injuriesClosedPiper PA18 · Fremont, CANTSB UNK65X1250Accident · No injuriesClosedBeechraft E35 · Oakland, CANTSB UNK64X3257Accident · No injuriesClosedBeechcraft E35 · Pauma Valley, CA