NTSB investigations: Beech A35, TX

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

NTSB investigations: Beech A35, TX per year, 1965–2026: 14 cases
1965	3
1969	1
1970	1
1972	1
1974	1
1976	1
1980	2
1981	1
2005	1
2010	1
2025	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" = '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 ('1151504')) 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 ('1151504'))
  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 ('1151504'))
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 CEN26FA012Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A35 · Skidmore, TXOn October 7, 2025, at 1223 central daylight time, a Beech A35 airplane, N577B, was destroyed when it was involved in an accident near Skidmore, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…Oct 7, 2025 · N577B · Destroyed NTSB CEN10CA152Accident · No injuriesData collectionFinal reportBeech A35 · Marfa, TXThe pilot's failure to extend the landing gear.Mar 11, 2010 · N541B · Substantial damage NTSB DFW05CA205Accident · No injuriesData collectionFinal reportBeech 35 · Boerne, TXThe airplane's collision with a deer during touchdown. A contributing factor was the prevailing dark night condition.Jun 30, 2005 · N8753A · Substantial damage NTSB FTW81FRA17Accident · Minor injuriesClosedBeech A35 · La Porte, TXFeb 17, 1981 · N8407A · Substantial damage NTSB FTW81DQD11Accident · No injuriesClosedBeech A35 · El Paso, TXDec 15, 1980 · N714B · Destroyed NTSB FTW81FA010Accident · 2 fatalClosedBeech A35 · Rock Springs, TXNov 21, 1980 · N741B · Destroyed NTSB FTW76DRG78Accident · No injuriesClosedBeech A35 · Mason, TXJul 31, 1976 · N8537A · Substantial damage NTSB FTW75AF015Accident · 1 fatalClosedBeech A35 · Pine Springs, TXSep 3, 1974 · N8535A · Destroyed NTSB FTW72FPA13Accident · Serious injuriesClosedBeech A35 · Dallas, TXJan 19, 1972 · N785B · Destroyed NTSB FTW71FQG05Accident · No injuriesClosedBeech A35 · Hale Center, TXJul 3, 1970 · N501B · Substantial damage NTSB FTW70A0042Accident · 1 fatalClosedBeech A35 · Valley View, TXDec 18, 1969 · N8502A · Destroyed NTSB FTW66A0061Accident · 4 fatalClosedBeech A35 · Llano, TXDec 30, 1965 · N126Y · Destroyed NTSB FTW65F0025Accident · No injuriesClosedBeechcraft A-35 · Midland, TXApr 16, 1965 · N8642A · Substantial damage NTSB UNK65X1273Accident · Serious injuriesClosedBeechraft A-35 · Hearne, TXJan 11, 1965 · N8645A · Destroyed