NTSB investigations: Beech V35B
7 cases on aircraft the registry lists as Beech V35B, where the first occurrence was “In flight collision with object”. 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 |
|---|---|
| 1983 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1995 | 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\" = 220))
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" = 220))
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 NYC95LA166Accident · No injuriesLimited investigationFinal reportBeech V35B · Goshen, OHthe pilot's premature liftoff which resulted in an inadvertent stall and a subsequent collision with trees.NTSB SEA91FA157Accident · 3 fatalField investigationFinal reportBeech V35B · Roche Harbor, WAThe pilot's failure to plan his takeoff path to provide adequate terrain clearance. The rising terrain and dark night light conditions were contributing factors.NTSB NYC91FA005Accident · 4 fatalField investigationFinal reportBeech V35B · Ottawa, OHFailure of the pilot to follow the proper instrument procedure and maintain the minimum descent altitude (mda) during an approach to the airport at night in instrument meteorological conditions.NTSB DEN84LA022Accident · No injuriesLimited investigationFinal reportBeech V35B · Greeley, COThe plt reported that immediately prior to rotation speed he saw a deer running towards the acft at a 90 deg collision angle. He 'hauled back' on the control wheel & the acft 'mushed off the ground.' The deer impacted the bottom of the fuselage & the wing…NTSB ATL83FA163Accident · 4 fatalField investigationFinal reportBeech V35B · Frisco, NCThe destination arpt was unlighted & was closed from 30 min after sunset until 30 min before sunrise. Prior to the flt, the plt made arrangements for someone to take his car to the destination arpt & park it with the headlights turned on at the apch end of…NTSB DEN83LA042Accident · No injuriesLimited investigationFinal reportBeech V35B · Kamis, UTThe plt stated he noticed a drop in oil pressure & a prop surge & decided to make a precautionary landing on a road. During the landing the acft struck several sign posts. Post accident tests showed no evidence of oil starvation or drop in oil pressure.NTSB LAX82DA101Accident · No injuriesFinal reportBeech V35B · Taft, CAThe aircraft made contact with an antenna during a low pass over a job site. The windshield shattered and the engine stalled forcing the pilot to make an emergency landing.