Skip to content

NTSB investigations: Beech H35, TX

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

19652026

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."eventStateOrRegion" = 'TX' 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 ('1151520')) 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\" = 'TX' 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 ('1151520'))
  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" = 'TX' 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 ('1151520'))
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 CEN23LA318Accident · Minor injuriesClass 3 · LimitedFinal reportBeech H35 · Georgetown, TXA loss of engine power for reasons that could not be determined.Jul 23, 2023 · N365B · Substantial damage NTSB CEN12LA501Accident · Serious injuriesLimited investigationFinal reportBeech H35 · Holly Lake Ranch, TXThe incomplete maintenance performed by maintenance personnel, which resulted in a total loss of engine power.Aug 1, 2012 · N4684D · Substantial damage NTSB FTW98LA300Accident · No injuriesLimited investigationFinal reportBeech H35 · Marshall, TXThe loss of engine power due to fuel starvation as a result of the improper position of the fuel selector. A factor was the pilot's lack of experience in this make and model of airplane.Jul 6, 1998 · N5554D · Substantial damage NTSB FTW88FA032Accident · 3 fatalField investigationFinal reportBeech H35 · Port Mansfield, TXThe plt rcvd svrl wx briefings bfr tkof & was adzd of convective activity along the initial route of flt north of the arpt. The planned dep route was twd the wx. While discussing altn routing possibilities, the plt indcd he would ask ATC for deviation arnd…Nov 25, 1987 · N5568D · Destroyed NTSB FTW85FPA02Accident · Serious injuriesFinal reportBeech H35 · Wichita Falls, TXThe acft made a shallow rt turn and descended to ground contact during a go-around after the plt was informed by radio that his landing gear was not fully extended. Investigation revelaed also that the main fuel tanks were empty and the tank selector was on…May 23, 1985 · N4697D · Substantial damage NTSB FTW83LA022Accident · No injuriesLimited investigationFinal reportBeech H35 · Abilene, TXThe pilot stated that he extended the gear about 10 to 15 miles out to hold down the speed and descend. Before landing, he noted that none of his lights were working and he was unable to communicate with Abilene radio. Reportedly, he assumed the gear was down…Oct 24, 1982 · N7937D · Substantial damage NTSB FTW76DQH04Accident · No injuriesClosedBeech H35 · Midland, TXAug 26, 1976 · N7990D · Substantial damage NTSB FTW75FPD04Accident · No injuriesClosedBeech H35 · Rhome, TXAug 26, 1974 · N124X · Substantial damage NTSB FTW74FQG35Accident · No injuriesClosedBeech H35 · Canyon, TXJan 6, 1974 · N4697D · Substantial damage NTSB FTW70AF073Accident · 3 fatalClosedBeech H35 · Tyler, TXMay 14, 1970 · N7934D · Destroyed NTSB FTW70D0279Accident · No injuriesClosedBeech H35 · Cleburne, TXOct 25, 1969 · N622Q · Substantial damage NTSB FTW70F0234Accident · Serious injuriesClosedBeech H35 · College Sta, TXSep 8, 1969 · N7980D · Substantial damage NTSB FTW69F0064Accident · No injuriesClosedBeech H35 · Lubbock, TXJun 29, 1968 · N8216D · Substantial damage NTSB FTW68F0397Accident · No injuriesClosedBeech H35 · Anson, TXDec 11, 1967 · N5566D · Substantial damage NTSB FTW68F0405Accident · No injuriesClosedBeech H35 · Texarkana, TXNov 15, 1967 · N5032B · Substantial damage NTSB FTW68D0073Accident · No injuriesClosedBeech H35 · Wolfe City, TXJul 12, 1967 · N624T · Substantial damage NTSB FTW68D0109Accident · No injuriesClosedBeech H35 · Houston, TXJul 3, 1967 · N704Q · Substantial damage NTSB FTW67D0674Accident · No injuriesClosedBeech 35 · Marfa, TXMay 19, 1967 · N7943D · Substantial damage NTSB FTW67D0358Accident · No injuriesClosedBeech H35 · Dallas, TXDec 17, 1966 · N5032B · Substantial damage NTSB FTW67A0052Accident · 3 fatalClosedBeech H35 · Bryan, TXNov 10, 1966 · N7953D · Destroyed NTSB FTW67D0042Accident · No injuriesClosedBeech H35 · Lockhart, TXJun 16, 1966 · N4692D · Substantial damage NTSB UNK65X1280Accident · No injuriesClosedBeechraft H35 · Addison, TXJan 13, 1965 · N8229D · Substantial damage