NTSB investigations: Beech C35, CO
7 cases on aircraft the registry lists as Beech C35. 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
| 1966 | 1 |
|---|---|
| 1983 | 1 |
| 1988 | 1 |
| 1995 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2016 | 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 ('1151508'))
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 ('1151508'))
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 CEN16FA086Accident · 1 fatalField investigationFinal reportBeech C35 · Meeker, COThe non-instrument-rated pilot's decision to fly the airplane in instrument meteorological conditions at high altitude for greater than 30 minutes without the use of supplemental oxygen which resulted in hypoxia, and a subsequent loss of control. Contributing…NTSB CEN10FA458Accident · 3 fatalField investigationFinal reportBeech C35 · Rollinsville, COA loss of engine power for undetermined reasons.NTSB CEN09CA307Accident · No injuriesData collectionFinal reportBeech C35 · Englewood, COThe collapse of the landing gear due to the mechanic's failure to properly wire the landing gear squat switch.NTSB FTW96FA072Accident · 2 fatalField investigationFinal reportBeech 35 · Kremmling, COa loss of engine power due to fuel starvation as a result of the student pilot's improper positioning of the fuel selector and the the CFI's inadequate fuel management. Factors in the accident were: the unmarked fuel selector and the CFI's excessive descent…NTSB DEN88LA140Accident · No injuriesLimited investigationFinal reportBeech C35 · Brighton, COShortly after takeoff and while cruise flight, the eng lost pwr. The fuel pressure gauge indicated o PSI. The plt switched on the electric fuel pump. The eng did not respond. The plt activated the auxiliary (wobble) pump and switched fuel tanks. The eng still…NTSB DEN83LA174Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Salida, COThe acft crashed into a mountain in a controlled crash situation with full flaps and full power at the 11,312 ft level the density alt was computed to be 12,370 ft MSL. The plt was aware that the weather was questionable in some areas of his route and the…NTSB DEN67F0126Accident · No injuriesClosedBeech C35 · Littleton, CO