NTSB investigations: Beech V35

9 cases on aircraft the registry lists as Beech V35, where the first occurrence was “Loss of control - in flight”. 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

19832026

NTSB investigations: Beech V35 per year, 1983–2026: 9 cases
1983	1
1986	1
1989	1
1993	1
1996	1
1997	2
1999	1
2004	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" = 250)) 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\" = 250))
  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" = 250))
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 LAX04LA178Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Elko, NVthe pilot's improper mixture leaning technique and failure to attain an adequate airspeed during takeoff, which resulted in a stall/mush.Apr 5, 2004 · N7923M · Destroyed NTSB FTW99FA177Accident · 1 fatalField investigationFinal reportBeech V35 · Baton Rouge, LAThe pilot's performance of an abrupt maneuver immediately after takeoff, which resulted in an inadvertent stall.Jul 2, 1999 · N5608S · Destroyed NTSB FTW97FA199Accident · 3 fatalField investigationFinal reportBeech V35 · Shawnee, OKThe pilot's inadvertent entry into a spin. A factor was the pilot's initiated flight into adverse weather.May 23, 1997 · N5459U · Destroyed NTSB FTW97FA174Accident · 2 fatalField investigationFinal reportBeech V35 · Lake George, COThe pilot-in-command's failure to maintain control of the airplane. A factor was the terrain-induced turbulence.May 3, 1997 · N831U · Destroyed NTSB NYC96FA125Accident · 3 fatalField investigationFinal reportBeech V35 · Williamstown, NJinadequate supervision by the flight instructor (CFI); and failure of the pilot rated (dual) student to maintain control of the airplane during a simulated forced landing after takeoff, which resulted in a stall and collision with the terrain. Factors…Jun 13, 1996 · N2011W · Destroyed NTSB LAX94FA048Accident · 4 fatalField investigationFinal reportBeech V-35 · Shaver Lake, CAAn in-flight breakup of the airplane following the pilot's continued VFR flight into IMC conditions during which directional control of the airplane was not maintained, and the design limits of the airplane were exceeded. The pilot's inadequate evaluation of…Nov 12, 1993 · N630AW · Destroyed NTSB CHI90LA042Accident · No injuriesLimited investigationFinal reportBeech V35 · Cable, WIThe pilot's failure to adequately compensate for crosswind conditions. Contributing to the accident was the gusty, crosswind conditions which existed.Dec 9, 1989 · N7988M · Substantial damage NTSB LAX86FA127Accident · 1 fatalField investigationFinal reportBeech V35-B · Irvine, CAThe pilot had executed the ILS rwy 19R approach and then requested a missed approach, stating that he 'had a localizer problem'. On the second attempt he was cleared to land and then was twice issued a low altitude alert. The pilot was further issued…Feb 27, 1986 · N58SB · Destroyed NTSB FTW83FA387Accident · 4 fatalField investigationFinal reportBeech V35 · Conchas, NMIt was reported that the plt had been giving rides to various family members & the acft was observed flying in the area of Conchas lake on several occasions. It was also reported that the acft had 'buzzed' boats on the lake several times during the day. The…Aug 21, 1983 · N5429U · Destroyed