NTSB investigations: Beech 35
13 cases on aircraft the registry lists as Beech 35, where the first occurrence was “Loss of control - in flight”. 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 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 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 ('1151502')
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\" = 250))
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 ('1151502')
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" = 250))
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 DEN03FA157Accident · 1 fatalField investigationFinal reportBeech 35 · Belen, NMThe pilot's failure to maintain aircraft control immediately after takeoff due to spatial disorientation. A factor was the dark night light conditions.NTSB FTW02FA155Accident · 2 fatalField investigationFinal reportBeech BE-35 · Stephenville, TXThe pilot's failure to maintain control and adequate airspeed, resulting in the inadvertent stall/spin. A contributing factor was the low altitude.NTSB DEN01FA088Accident · 1 fatalField investigationFinal reportBeech 35 · Glenwood Sprgs, COthe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/mush to the ground. Contributing factors were the pilot's lack of experience in make/model airplane, the high density altitude weather condition, and the pilot's attempted…NTSB IAD99LA048Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Boonville, NYThe pilot's failure to attain takeoff speed and his failure to maintain directional control.NTSB FTW96FA119Accident · 2 fatalField investigationFinal reportBeech 35 · Allenspark, COAircraft control not maintained by the pilot in command for reasons undetermined.NTSB LAX92FA188Accident · 3 fatalField investigationFinal reportBeech 35 · Reno, NVThe pilot's poorly planned approach to compensate for the existing wind conditions, and his failure to maintain adequate airspeed.NTSB LAX89LA176Accident · No injuriesLimited investigationFinal reportBeech 35 · Sierraville, CAThe pilot's attempt to land downwind on the runway and the inability to attain a climb after aborting the landing which resulted in a stall and uncontrolled descent into the ground.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 MIA86LA210Accident · No injuriesLimited investigationFinal reportBeech 35 · Plymouth, FLThe plt lost control of the acft when it rotated early due to the elevator trim tab being set at four notches nose up. The acft then stalled & landed hard collapsing the landing gear. The plt failed to use a checklist.NTSB LAX85FA283Accident · Serious injuriesField investigationFinal reportBeech 35 · Cameron Park, CAIt could not be determined which of the two private plts on board the acft was serving as PIC & at the controls of the acft. The density alt was computed to be 4100 ft. there was very little wind & the max allowable gross weight was exceeded by aprx 123…NTSB MKC85LA002Accident · No injuriesLimited investigationFinal reportBeech 35 · Nashville, ARDuring the flare the acft ballooned, decelerated and stalled. The resultant hard ldg collapsed the ldg gear.NTSB MKC84LA151Accident · No injuriesLimited investigationFinal reportBeech BE35 · Nashville, ARThe acft collided with the ground after takeoff. The plt said he over-rotated during takeoff. The acft rolled right and left, striking the right landing gear and then the left wing on the rwy.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…