NTSB investigations: Beech V35A
5 cases on aircraft the registry lists as Beech V35A, where the first occurrence was “In flight encounter with weather”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1994 | 1 |
| 1999 | 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 ('1151544', '1151542')
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\" = 240))
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 ('1151544', '1151542')
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" = 240))
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 DEN99FA093Accident · 1 fatalField investigationFinal reportBeech V35A · Nederland, COThe pilot's intentional and continued flight into instrument meteorological conditions. Factors were his failure to obtain a weather briefing, the existing weather conditions that included snow, hail, obscuration and lightning, and the mountainous terrain.NTSB MIA94LA063Accident · No injuriesLimited investigationFinal reportBeech 35 · Leesburg, FLThe pilot-in-command's poor evaluation of the weather and failure to remain in visual meteorological conditions, resulting in an in-flight collision with water.NTSB ATL87FA187Accident · 1 fatalField investigationFinal reportBeech V35A · Augusta, GAThe plt ctcd apch ctl for radar svc & wx info. The destn arpt had hvy rain & thunderstorm activity, but the plt rprtd he had the arpt in sight. Radar svc was terminated & the plt began a visual apch. Witnesses rprtd the visibility dropped to 1/2 mi in hvy…NTSB DEN84LA178Accident · No injuriesLimited investigationFinal reportBeech V35A · Dove Creek, COWhile en route, the plt encountered hazy wx after crossing the Continental divide. Near montrose, CO, he deviated about 50 mi north to avoid adverse wx. He was unable to get thru, so he proceeded back to montrose to skirt the southern edge of the wx. He…NTSB NYC83FA192Accident · 1 fatalField investigationFinal reportBeech V35A · Acra, NYThe pilot stated that he was looking for VMC even though he was on an IFR flight. While inbound to albany he said he was circling down from 4000 feet in a VFR spot to get under the clouds. He subsequently cancelled his IFR flt plan and said he was going to…