NTSB investigations: Beech V35A, TX
9 cases on aircraft the registry lists as Beech V35A. 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
| 1969 | 1 |
|---|---|
| 1975 | 2 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 1 |
| 1984 | 1 |
| 2014 | 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 ('1151544', '1151542'))
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 ('1151544', '1151542'))
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 CEN15FA081Accident · 1 fatalField investigationFinal reportBeech V35A · Seagoville, TXThe pilot’s loss of control and subsequent impact with terrain in instrument meteorological conditions.NTSB FTW85FA078Accident · 1 fatalField investigationFinal reportBeech V35A · Midlothian, TXN7460N, operating as mid-america flt 401, crashed while on an IFR flt plan enroute to corpus christi, TX. After having been vectored around a heavy thunderstorm & cleared direct to waco, TX. The plt contacted fort worth center & stated that he had 'lost my…NTSB FTW82FRG22Accident · 1 fatalFinal reportBeech V35A · Cibolo, TXBefore starting the flight, the pilot was involved in an automobile accident. He called an employee and asked to be picked up. The employee reported that the pilot was drinking when he arrived. The pilot insisted on going to the airport to get keys from his…NTSB FTW82FA026Accident · 2 fatalClosedBeech V35A · Addison, TXNTSB FTW82DA002Accident · No injuriesClosedBeech V35A · Dallas, TXNTSB FTW81FA004Accident · 2 fatalClosedBeech V35A · Cedar Hill, TXNTSB FTW76AF027Accident · 3 fatalClosedBeech V35A · Mccamey, TXNTSB FTW75AF064Accident · 4 fatalClosedBeech V35A · Abilene, TXNTSB FTW70D0121Accident · No injuriesClosedBeech V35 · Amarillo, TX