NTSB investigations: Beech V35, CO
7 cases on aircraft the registry lists as Beech V35. 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
| 1973 | 2 |
|---|---|
| 1976 | 1 |
| 1982 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 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\" = 'CO' 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 ('1151538'))
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" = 'CO' 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 ('1151538'))
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 DEN99LA042Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Telluride, COA loss of engine power due to the ingestion of air in the fuel line, the pilot's failure to purge the fuel line of unwanted air prior to flight as outlined in the Airplane Flight Manual, and inadequate altitude in which to glide to the airport.NTSB FTW97FA174Accident · 2 fatalField investigationFinal reportBeech V35 · Lake George, COThe pilot-in-command's failure to maintain control of the airplane. A factor was the terrain-induced turbulence.NTSB FTW95LA353Accident · No injuriesLimited investigationFinal reportBeech 35N · Creede, COFailure by the pilot to follow the checklist and lower the landing gear.NTSB DEN82DA093Accident · No injuriesFinal reportBeech V35A · Colorado Spring, COThe pilot stated, the engine run-up was normal and the mixture was leaned at 1700 RPM to obtain initial EGT movement off the bottom of the guage. He reported taking off uphill on runway 03. He noted that the acceleration was slow, but attributed it to the…NTSB DEN76FTE75Accident · Serious injuriesClosedBeech V35 · Lamar, CONTSB DEN73FTE71Accident · No injuriesClosedBeech V35 · Walsenburg, CONTSB DEN73FTE72Accident · No injuriesClosedBeech V35TC · Delta, CO