Skip to content

Fatal NTSB investigations: Beech E35

25 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

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."highestInjuryLevel" = 'Fatal' 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

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.\"highestInjuryLevel\" = 'Fatal'
    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."highestInjuryLevel" = 'Fatal'
  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

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 WPR22FA215Accident · 2 fatalClass 3 · FieldFinal reportBeech E35 · Buckeye, AZThe pilots’ failure to climb and complete a normal traffic pattern after making a low approach and their failure to extend the flaps for reasons that could not be determined, and the flight instructor’s failure to ensure adequate airspeed and bank control…Jun 18, 2022 · N13AR · Destroyed NTSB WPR13FA368Accident · 1 fatalField investigationFinal reportBeech E35 · West Yellowstone, MTThe pilot's failure to maintain airplane control while aligning the airplane with the runway for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's…Aug 12, 2013 · N3226C · Substantial damage NTSB SEA02FA146Accident · 3 fatalField investigationFinal reportBeech BE-35 · Idaho Falls, IDThe flying pilot's failure to maintain adequate airspeed resulting in a stall/spin. An additional cause was the flight instructor's inadequate supervision of the flight.Aug 5, 2002 · N82Z · Destroyed NTSB ATL02FA077Accident · 1 fatalField investigationFinal reportBeech E35 · Blowing Rock, NCThe pilot's continued VFR flight in to known IMC, which resulted in an in-flight collision with trees in mountainous terrain. A factor was low ceiling.Apr 8, 2002 · N3292C · Destroyed 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.Aug 7, 1993 · N3233C · Destroyed NTSB FTW81FA074Accident · 4 fatalClosedBeech E35 · Fay, OKApr 18, 1981 · N3281C · Destroyed NTSB MIA79FA048Accident · 1 fatalClosedBeech E35 · Brunswick, GAFeb 6, 1979 · N2059C · Substantial damage NTSB MKC78FA052Accident · 3 fatalClosedBeech E35 · Potosi, MOJun 23, 1978 · N13AV · Destroyed NTSB OAK78FA005Accident · 4 fatalClosedBeech E35 · Willows, CANov 21, 1977 · N3274C · Destroyed NTSB CHI75AC049Accident · 1 fatalClosedBeech E35 · Westland, MIJan 7, 1975 · N7308B · Destroyed NTSB MKC74AK006Accident · 3 fatalClosedBeech E35 · Alta, IAAug 16, 1973 · N389W · Destroyed NTSB MKC73AK061Accident · 1 fatalClosedBeech E35 · Junction Cty, KSApr 14, 1973 · N7339B · Destroyed NTSB CHI73AC079Accident · 2 fatalClosedBeech E35 · Hanover, MIMar 30, 1973 · N3506B · Destroyed NTSB NYC73AN113Accident · 4 fatalClosedBeech E35 · Marion, NCFeb 21, 1973 · N3207C · Destroyed NTSB MIA73AM072Accident · 5 fatalClosedBeech E35 · Mobile, ALJan 6, 1973 · N3294C · Destroyed NTSB OAK72AP031Accident · 1 fatalClosedBeech E35 · Dublin, CAMar 2, 1972 · N766B · Destroyed NTSB MKC72AK030Accident · 4 fatalClosedBeech E35 · Garden City, KSNov 24, 1971 · N3202C · Destroyed NTSB OAK71AP049Accident · 1 fatalClosedBeech E35 · Williams, CAMay 28, 1971 · N7333B · Destroyed NTSB NYC71AN107Accident · 3 fatalClosedBeech E35 · Indiana, PAMay 3, 1971 · N7366B · Destroyed NTSB NYC70A0020Accident · 1 fatalClosedBeech E35 · Block Island, RIAug 6, 1969 · N8818A · Destroyed NTSB FTW69A0015Accident · 3 fatalClosedBeech E35 · Lake Village, ARSep 2, 1968 · N3319C · Destroyed NTSB CHI68A0075Accident · 3 fatalClosedBeech E35 · Springfield, ILFeb 20, 1968 · N7380B · Destroyed NTSB MKC68A0009Accident · 2 fatalClosedBeech E35 · Nevada, MOAug 3, 1967 · N3313C · Destroyed NTSB FTW67A0116Accident · 1 fatalClosedBeech E35 · Crowley, LAMay 31, 1967 · N7372B · Destroyed NTSB UNK64X0605Accident · 1 fatalClosedBeechcraft E35 · Loup City, NEFeb 19, 1964 · N7358B · Destroyed