NTSB investigations: Beech 35, OH
17 cases on aircraft the registry lists as Beech 35. 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
| 1964 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 2 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1983 | 1 |
| 1987 | 1 |
| 1995 | 2 |
| 1997 | 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\" = 'OH' 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 ('1151502'))
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" = 'OH' 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 ('1151502'))
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 IAD97LA099Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Wadsworth, OHThe pilot's failure to retard the engine throttle to idle during the landing roll. A related factor was the diverted attention.NTSB BFO95LA077Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Paintersville, OHThe pilot's continued VFR flight into instrument meteorological conditions. Factors related to the accident were: the pilot's failure to obtain a weather briefing, and the weather conditions.NTSB NYC95LA063Accident · No injuriesLimited investigationFinal reportBeech 35 · Shadyside, OHThe loss of oil pressure, which resulted in the number six connecting rod failure and penetration through the crankcase.NTSB ATL87FA135Accident · 3 fatalField investigationFinal reportBeech 35 · Avon, OHAcft was seen heading east on a downwind for the private airstrip where it was based. It was turned onto the base leg and as a turn was begun for the final approach course for rwy 27 it stalled, spun, and collided with the ground. The acft wreckage was found…NTSB CHI83FA239Accident · 1 fatalField investigationFinal reportBeech 35 · Auburn, OHThe acft approached the 1800 ft grass strip from the west. Local residents reported the wind as from the wse at 28-30 mph. There was no wind sock at the landing strip. According to witnesses the acft traveled 3/4 of the rwy without touching the ground. At…NTSB CHI78FA038Accident · 4 fatalClosedBeech 35 · Middletown, OHNTSB CHI76FEG08Accident · No injuriesClosedBeech 35 · Dayton, OHNTSB CHI75AC024Accident · 3 fatalClosedBeech 35 · Alliance, OHNTSB CHI73FEI40Accident · Minor injuriesClosedBeech 35 · Ratlesnake I, OHNTSB CHI71FEI64Accident · No injuriesClosedBeech 35 · Shelby, OHNTSB CHI71DGA11Accident · Serious injuriesClosedBeech 35 · Harrison, OHNTSB CHI69D0416Accident · No injuriesClosedBeech 35 · Stillwell, OHNTSB CHI68F0433Accident · No injuriesClosedBeech D35 · London, OHNTSB CHI68F0151Accident · No injuriesClosedBeech 35 · Cleveland, OHNTSB CHI66F0178Accident · No injuriesClosedPiper PA-23 · Sandusky, OHNTSB CHI66F0723Accident · Minor injuriesClosedBeech 35 · Cincinnati, OHNTSB UNK64X0711Accident · No injuriesClosedBeechcraft 35 · Blue Ash, OH