NTSB investigations: Beech C35, TX
17 cases on aircraft the registry lists as Beech C35. 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.
Cases per year
| 1964 | 3 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 2 |
| 1971 | 2 |
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2009 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('1151508'))
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 ('1151508'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C35 · Lakeview, TXThe pilot’s fuel system mismanagement which resulted in a loss of engine power due to fuel starvation.NTSB CEN09FA405Accident · 1 fatalField investigationFinal reportBeech C35 · Weslaco, TXThe pilot's failure to maintain aircraft control while operating with a fuel imbalance. Contributing to the accident was the pilot/owner's decision to fly the airplane outside of the operating limitations.NTSB FTW02LA065Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Paris, TXthe failure of the pilot of the other aircraft to maintain adequate visual lookout during taxi.NTSB FTW95FA300Accident · Serious injuriesField investigationFinal reportBeech C35 · Plano, TXFuel starvation due to the improper position of the fuel selector, and failure the pilot to follow emergency procedures.NTSB FTW79FA111Accident · 3 fatalClosedBeech C35 · Ranger, TXNTSB FTW77FA066Accident · Minor injuriesClosedBeech C35 · Fort Worth, TXNTSB FTW76FQD19Accident · No injuriesClosedBeech C35 · El Paso, TXNTSB FTW74FPA25Accident · Serious injuriesClosedBeech C35 · Hebron, TXNTSB FTW72AF026Accident · 2 fatalClosedBeech C35 · Hamilton, TXNTSB FTW71FPA21Accident · Minor injuriesClosedBeech C35 · Athens, TXNTSB FTW68D0608Accident · No injuriesClosedBeech C35 · Hamilton, TXNTSB FTW68F0423Accident · No injuriesClosedBeech C35 · San Angelo, TXNTSB FTW68D0087Accident · No injuriesClosedBeech 35C · Dalhart, TXNTSB FTW67D0164Accident · No injuriesClosedBeech C35 · Garland, TXNTSB UNK65X1112Accident · No injuriesClosedBeech C35 · Paris, TXNTSB UNK65X0356Accident · No injuriesClosedBeechcraft C35 · Ft Worth, TXNTSB UNK64X3644Accident · No injuriesClosedBeech C35 · Abilene, TX