NTSB investigations: Beech 35, CO
13 cases on aircraft the registry lists as Beech 35. 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 | 2 |
|---|---|
| 1967 | 3 |
| 1976 | 1 |
| 1980 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2010 | 1 |
| 2023 | 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 ('1151502'))
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 ('1151502'))
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 CEN23LA146Accident · No injuriesClass 4 · LimitedFinal reportBeech 35 · Telluride, COThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB CEN10CA231Accident · No injuriesData collectionFinal reportBeech 35 · Boulder, COThe pilot's failure to maintain directional control while landing in a crosswind.NTSB DEN02LA064Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Cortez, COan inadvertent stall as the pilot attempted to clear a cliff and ravine and avoid power lines, resulting in a collision with the ground. Contributing factors were a loss of engine power for undetermined reasons, a leaking carburetor and fuel pump, and the…NTSB DEN01FA088Accident · 1 fatalField investigationFinal reportBeech 35 · Glenwood Sprgs, COthe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/mush to the ground. Contributing factors were the pilot's lack of experience in make/model airplane, the high density altitude weather condition, and the pilot's attempted…NTSB FTW96FA119Accident · 2 fatalField investigationFinal reportBeech 35 · Allenspark, COAircraft control not maintained by the pilot in command for reasons undetermined.NTSB DEN92FA028Accident · No injuriesField investigationFinal reportBeech 35 · Nucla, COImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter.NTSB DEN80DTE64Accident · No injuriesClosedBeech 35 · Elbert, CONTSB DEN76FTE87Accident · No injuriesClosedBeech 35 · Englewood, CONTSB DEN68F0173Accident · No injuriesClosedBeech 35 · Boulder, CONTSB DEN68F0113Accident · Minor injuriesClosedBeech 35 · Littleton, CONTSB DEN68F0075Accident · No injuriesClosedBeech 35 · Broomfield, CONTSB DEN66D0073Accident · No injuriesClosedBeechcraft 35 · Denver, CONTSB DEN65A0061Accident · 2 fatalClosedBeechcraft 35 · Aspen, CO