NTSB investigations: Beech J35, TX
17 cases on aircraft the registry lists as Beech J35. 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 |
|---|---|
| 1965 | 2 |
| 1967 | 3 |
| 1969 | 1 |
| 1971 | 2 |
| 1975 | 1 |
| 1980 | 1 |
| 1994 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2020 | 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 ('1151522'))
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 ('1151522'))
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 CEN21FA043Accident · 1 fatalClass 3 · FieldFinal reportBeech J35 · Fredericksburg, TXThe pilot of the J35’s failure to maintain clearance from the M35, which resulted in a midair collision and the J35 pilot’s subsequent loss of control and impact with terrain.NTSB DFW08LA025Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Fort Worth, TXFailure of the operator to ensure that the metering unit's throttle arm and throttle cable were secured using manufacturer approved hardware. A contributing factor to the pilot's injuries was the lack of shoulder retraints.NTSB DFW05FA058Accident · 2 fatalField investigationFinal reportBeech J-35 · Abernathy, TXThe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.NTSB FTW94LA290Accident · Minor injuriesLimited investigationFinal reportBeech J35 · Crockett, TXThe fuel starvation induced loss of engine power due to the pilot's improper fuel tank selection.NTSB FTW80FA047Accident · 2 fatalClosedBeech 35 · Barksdale, TXNTSB FTW76AF042Accident · 2 fatalClosedLing-T-Vogt SA341G · Houston, TXNTSB FTW72AF029Accident · 1 fatalClosedBeech J35 · Jacksboro, TXNTSB FTW71FRA56Accident · No injuriesClosedBeech J35 · Spring Branch, TXNTSB FTW70A0040Accident · 1 fatalClosedBeech J35 · Fulton, TXNTSB FTW68F0387Accident · No injuriesClosedBeech J35 · Beaumont, TXNTSB FTW68F0008Accident · No injuriesClosedBeech J35 · Lufkin, TXNTSB FTW67D0480Accident · No injuriesClosedBeech J35 · Midland, TXNTSB FTW66D0033Accident · No injuriesClosedBeechcraft J-35 · Amarillo, TXNTSB FTW66F0022Accident · No injuriesClosedBeechcraft J-35 · Amarillo, TXNTSB UNK65X0856Accident · No injuriesClosedBeech J35 · San Antonio, TXNTSB UNK64X2252Accident · No injuriesClosedBeechcraft J35 · Beaumont, TXNTSB UNK64X1217Accident · No injuriesClosedBeechcraft J35 · Midland, TX