NTSB investigations: Beech 95, CA

12 cases on aircraft the registry lists as Beech 95. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: Beech 95, CA per year, 1964–2026: 12 cases
1964	1
1966	2
1967	1
1970	1
1974	1
1980	1
1987	1
1988	1
1991	1
2003	1
2005	1

Where

Open the map

Latest cases

Query with SQL

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 ('1153402')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('1153402'))
  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 ('1153402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 LAX05FA099Accident · 2 fatalField investigationFinal reportBeech 95 · Calistoga, CAThe pilot's inadequate preflight and in-flight planning/decision, which resulted in continued VFR flight into instrument meteorological conditions at an altitude insufficient to ensure adequate terrain clearance and impact with rising terrain.Feb 15, 2005 · N8269D · Destroyed NTSB LAX03FA074Accident · 1 fatalField investigationFinal reportBeech 95 · Rancho Cucamong, CAThe fracture and separation of a propeller blade during cruise flight due to fatigue and corrosion pits in the blade pilot bore, and an improper overhaul of the separated propeller by repair station personnel. Factors contributing to the accident were the…Jan 25, 2003 · N2733Y · Destroyed NTSB LAX91LA123Accident · No injuriesLimited investigationFinal reportBeech B95 · Riverside, CAFailure of the pilot to follow the emergency gear extension procedure to fully extend the landing gear. Contributing to the accident was the failure of the pilot to monitor the condition of the electrical power system, leading to the complete loss of…Feb 10, 1991 · N2712Y · Substantial damage NTSB LAX89FA050Accident · 1 fatalField investigationFinal reportBeech 95 · Milpitis, CAThe pilot failed to maintain altitude while performing a maneuver.Nov 18, 1988 · N663Q · Destroyed NTSB LAX87FA331Accident · 3 fatalField investigationFinal reportBeech 95 · Monterey, CAThe coml plt was rcvg mult-eng dual instrn in a Beech 95. After tkof, the aircrew began practicing inst apchs. After making an ILS rwy 10 apch to enter left traffic for rwy 28, the flt was clrd onto a south downwind to be sequenced to follow a psa BAE-146.…Sep 9, 1987 · N845B · Destroyed NTSB LAX80FA127Accident · 4 fatalClosedBeech 95 · Rubidoux, CAJul 27, 1980 · N688Q · Substantial damage NTSB LAX74AL082Accident · 4 fatalClosedBeech 95 · Muscoy, CAJun 16, 1974 · N232H · Destroyed NTSB OAK70AP059Accident · 2 fatalClosedBeech B95 · Sacramento, CAMay 20, 1970 · N2063C · Destroyed NTSB LAX67A0091Accident · 2 fatalClosedBeech 95 · Saugus, CAApr 4, 1967 · N117S · Destroyed NTSB LAX66F0274Accident · No injuriesClosedBeech 95 · Long Beach, CAMar 10, 1966 · N2013C · Substantial damage NTSB OAK66D0220Accident · No injuriesClosedBeechcraft 95 · San Francisco, CAFeb 25, 1966 · N2080C · Substantial damage NTSB UNK64X2182Accident · 3 fatalClosedBeechcraft 95 · Camp Angelus, CAJun 7, 1964 · N2055C · Destroyed