NTSB investigations: Beech V35

7 cases on aircraft the registry lists as Beech V35, where the first occurrence was “In flight encounter with weather”. 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

19852026

NTSB investigations: Beech V35 per year, 1985–2026: 7 cases
1985	1
1989	2
1996	1
1997	1
2003	1
2006	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151538') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151538')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151538')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 DFW06LA073Accident · No injuriesLimited investigationFinal reportBeech V35 · San Antonio, TXThe pilot's loss of control while on approach to the runway. Contributing factors were the downdraft and the lack of suitable terrain for the off-airport landing.Feb 20, 2006 · N510LM · Substantial damage NTSB CHI03LA072Accident · No injuriesLimited investigationFinal reportBeech V35 · Sparta, MIThe pilots improper decision to fly into known adverse weather, and his failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was airframe icing.Feb 18, 2003 · N9439S · Substantial damage NTSB ATL97FA054Accident · 3 fatalField investigationFinal reportBeech V35 · Marco Island, FLinadvertent flight by the pilot into adverse weather conditions (severe thunderstorms), which led the design stress limits of the airplane being exceeded, subsequent in-flight break-up of the airplane, and an uncontrolled collision with water.Mar 25, 1997 · N9049S · Destroyed NTSB MIA96FA134Accident · 2 fatalField investigationFinal reportBeech V35 · Powelton, GAthe pilot's continued flight into known adverse weather conditions, resulting in an in-flight separation of the left wing and ruddervator. Factors in this accident were: level three and four thunderstorms, intense to extreme precipitation, and severe…Apr 29, 1996 · N102A · Destroyed NTSB LAX90FA010Accident · 1 fatalField investigationFinal reportBeech V35 · Goleta, CAThe pilot's attempt to conduct visual flight into adverse weather conditions at an altitude that would not provide terrain clearance. The weather condition was a related factor.Oct 22, 1989 · N288BH · Destroyed NTSB BFO89FA019Accident · 1 fatalField investigationFinal reportBeech V35TC · Roanoke, VAThe pilot failed to maintain control of the aircraft due to spatial disorientation.Mar 3, 1989 · N27FH · Destroyed NTSB FTW86MA010Accident · 4 fatalMajor investigationFinal reportBeech V35 · Bridger, MTDrg a preflt wx briefing, the plt was advised that VFR flt was not recommended due to forecast frontal activity moving southbound along his route. Severe turbulence & icing had been reported just to the north of his course. He filed a VFR flt plan & took off…Oct 3, 1985 · N8475H · Destroyed