NTSB investigations: Beech 95-B55, CA
8 cases on aircraft the registry lists as Beech 95-B55. 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 |
| 1968 | 1 |
| 1998 | 1 |
| 2003 | 1 |
| 2024 | 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 ('1152705'))
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 ('1152705'))
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 WPR25FA007Accident · 5 fatalClass 3 · FieldPreliminary reportBeech 95-B55 · Avalon, CAOn October 8, 2024, at 2005 Pacific daylight time, a Beech 95-B55, N73WA, was destroyed when it was involved in an accident near Avalon, California. The pilot, two pilot rated passengers, and two student pilot passengers were fatally injured. The airplane was…NTSB LAX04LA074Accident · No injuriesLimited investigationFinal reportBeech B55 · Angwin, CAThe pilot's continued VFR flight into adverse weather conditions during cruise flight, which resulted in a low fuel state and a precautionary landing in rough terrain.NTSB LAX98LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Hollister, CAThe failure of the instructors and dual students in both aircraft to maintain an adequate visual lookout, which resulted in their combined failures to see and avoid each other. Inadequate supervision of the two flights by the respective instructor pilots were…NTSB LAX68A0111Accident · 4 fatalClosedBeech 95-B55 · Buena Park, CANTSB OAK66A0017Accident · 2 fatalClosedBeech 95-B55 · Salinas, CANTSB OAK66D0001Accident · No injuriesClosedBeechcraft 95-B55 · Columbia, CANTSB LAX65A0081Accident · 1 fatalClosedBeechcraft 95B-55 · Santa Barbara, CANTSB UNK64X1423Accident · No injuriesClosedBeechcraft B35 · Gasquet, CA