NTSB investigations: Beech K35, TX
11 cases on aircraft the registry lists as Beech K35. 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
| 1965 | 1 |
|---|---|
| 1969 | 3 |
| 1972 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1985 | 2 |
| 1991 | 1 |
| 2000 | 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 ('1151524'))
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 ('1151524'))
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 FTW00LA082Accident · Minor injuriesLimited investigationFinal reportBeech BE-35K · Houston, TXThe pilot's failure to refuel resulting in fuel exhaustion and a total loss of engine power. Factors were the low ceilings, mist, and the pilot's inability to fly the ILS approach.NTSB FTW91LA140Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Laredo, TXThe improper installation of the oil filter adaptor 'o' ring (seal) by other maintenance personnel who distorted it. A factor was the rough, uneven terrain.NTSB FTW86FRG02Accident · Serious injuriesFinal reportBeech K35 · Austin, TXThe acft stalled & crashed during a go-around attempt. The plt/owner was flying the acft from the left seat with the mechainc, who had just completed an annual inspection on the acft, seated in the co-plts seat. The mechanic received serious injuries when the…NTSB FTW86LA005Accident · No injuriesLimited investigationFinal reportBeech K35 · El Paso, TXThe plt stated his straight-in landing final apch was smooth. The airspeed had decreased from 80 to 65 KTS & the acft's wheels were only inches above the rwy when the right wing suddenly lifted and caused the acft to veer left and touch down on the dirt…NTSB FTW82DA383Accident · No injuriesFinal reportBeechcraft K35 · Houston, TXPilot stated that he lifted the nose off the runway too soon and the aircraft became airborne but would not climb or accelerate. The aircraft drifted to the left and collided with a canal dirt bank.NTSB FTW81DQD08Accident · No injuriesClosedBeech K35 · Alpine, TXNTSB FTW72FRG74Accident · No injuriesClosedBeech K35 · Port Aransas, TXNTSB FTW70F0023Accident · Minor injuriesClosedBeech K35 · Harper, TXNTSB FTW69D0551Accident · No injuriesClosedBeech K35 · San Marcos, TXNTSB FTW69A0061Accident · 3 fatalClosedBeech K35 · Spicewood, TXNTSB FTW66F0134Accident · Serious injuriesClosedBeech K35 · Lipscomb, TX