NTSB investigations: Beech V35B
8 cases on aircraft the registry lists as Beech V35B, where the first occurrence was “In flight collision with terrain/water”. 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
| 1982 | 2 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151548')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151548')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
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 SEA06CA059Accident · No injuriesData collectionFinal reportBeech V35B · Burns, ORThe pilot's failure to maintain clearance from the terrain during the takeoff sequence. Factors include his inadequate removal of snow and ice from the wings prior to takeoff, his improper decision to retract the landing gear before it had been positively…NTSB ANC05FA121Accident · 2 fatalField investigationFinal reportBeech V35B · Denali Park, AKThe pilot's failure to maintain altitude/clearance from mountainous terrain while climbing, and his improper in-flight decision making by electing to fly at a low altitude toward rising terrain. A factor associated with the accident was mountainous terrain.NTSB DEN02LA023Accident · 1 fatalLimited investigationFinal reportBeech V35B · American Fork, UTThe pilot's poor judgment in that he intentionally initiated VFR flight into instrument meteorological conditions. Contributing factors were low ceiling and obscuration, and the pilot's lack of recent instrument time.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 FTW88LA053Accident · No injuriesLimited investigationFinal reportBeech V35B · Temple, TXThe pilot failed to execute a missed approach when he descended through decision height.NTSB FTW85LA096Accident · No injuriesLimited investigationFinal reportBeech V35B · Amarillo, TXDuring takeoff, the cabin door opened & the plt elected to return for a landing. He reported that he was distracted by wind noise & 'nervousness' and failed to assure that the gear was extended. As he flared, the propeller contacted the rwy. The plt added…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 ATL82DKJ10Accident · No injuriesFinal reportBeech V35B · Tuskegee, ALDuring landing, the pilot put the landing gear and flap handles in the down positions. He heard noises that sounded like both had extended and assumed everything was in place. The pilot was unaware that the landing gear was not down until after touchdown. An…