NTSB investigations: Beech S35
5 cases on aircraft the registry lists as Beech S35, 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
| 1990 | 1 |
|---|---|
| 1992 | 2 |
| 2002 | 1 |
| 2005 | 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 ('1151532')
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 ('1151532')
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 DEN05LA088Accident · No injuriesLimited investigationFinal reportBeech S35 · Colorado Spring, COthe flight instructor and pilot's improper decision to continue the attempted high altitude takeoff when Vy airspeed was not obtained, and failure to abort the takeoff which resulted in an off-field landing and subsequent impact with terrain. A contributing…NTSB LAX02FA212Accident · 3 fatalField investigationFinal reportBeech S35 · Ojai, CAthe pilot's inadequate in-flight planning and failure to maintain an adequate terrain clearance altitude within the canyon.NTSB LAX92FA220Accident · 2 fatalField investigationFinal reportBeech S-35 · Avalon, CA1) Improper preflight planning, 2) the pilots selection of the wrong runway for departure which put the aircraft immediately in an area of restricted visibility and fog after liftoff, 3) the pilots intentional flight into instrument conditions, and 4) his…NTSB SEA92LA102Accident · 1 fatalLimited investigationFinal reportBeech S35 · Davenport, WAPoor in flight planning/decision. Factors to the accident were: mountainous/hilly terrain and terrain clearance was not maintained.NTSB LAX91FA040Accident · 2 fatalField investigationFinal reportBeech S-35 · Kingman, AZProper altitude not maintained. Contributing to the accident was: the lack of supplemental oxygen on board the aircraft, pilot fatigue, improper use of the auto pilot, and pilot complacency.