NTSB investigations: Beech V35B, MT
5 cases on aircraft the registry lists as Beech V35B. 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
| 1980 | 1 |
|---|---|
| 1982 | 1 |
| 1985 | 2 |
| 1991 | 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\" = 'MT' 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 ('1151548'))
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" = 'MT' 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 ('1151548'))
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 SEA91LA206Accident · No injuriesLimited investigationFinal reportBeech V35B · Belgrade, MTThe pilot's failure to maintain a positive rate of climb during the takeoff. Factors contributing to the accident were the open cabin window and the pilot's diverting his attention.NTSB DEN86LA050Accident · Serious injuriesLimited investigationFinal reportBeech V-35B · Wibaux, MTThe plt stated that light snow was falling at the arpt at the time of departure. The pax stated after the accident that the plt encountered clouds at their cruise alt of about 6000 ft. he continued to state that the acft made a shallow descent at first…NTSB DEN85LA149Accident · No injuriesLimited investigationFinal reportBeech V35B · Kalispell, MTN904V, a privately owned B-35, skidded off to the side of a runway during landing. The plt said that he inadvertently activated the gear up switch instead of the flap switch. The right landing gear collapsed causing the plt to lose control of acft.NTSB DEN82AA115Accident · 6 fatalFinal reportBeech V35B · Near Ringling, MTAlthough IMC existed over mountainous areas, the plt attempted a visual flt direct to salt lake city. The probable flt path of the acft was one which is usually flown by plts on VFR flts. The course taken by plts desiring to cross over themountain ridges west…NTSB DEN81FTA02Accident · No injuriesClosedBeech V35B · Billings, MT