NTSB investigations: Beech 35, WA
18 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 | 4 |
|---|---|
| 1965 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 2 |
| 1981 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2010 | 1 |
| 2019 | 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\" = 'WA' 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" = 'WA' 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 WPR19LA171Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Deer Park, WAAn empennage flutter event for reasons that could not be determined based on the available information.NTSB WPR10LA235Accident · No injuriesLimited investigationFinal reportBeech 35 · South Bend, WAA loss of engine power during takeoff for undetermined reasons, which resulted in a runway overrun.NTSB CHI97IA122Incident · No injuriesIncident investigationFinal reportBeech 35 · Spokane, WAthe vibration of the fuselage was due to flutter.NTSB SEA96LA181Accident · No injuriesLimited investigationFinal reportBeech 35 · Spokane, WAfailure (cracking) of the aft fuselage bulkhead for undetermined reason(s).NTSB SEA91FA261Accident · No injuriesField investigationFinal reportBeech 35 · Walla Walla, WAImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter. Improper installation of the trim tabs and an encounter with turbulence were related factors.NTSB SEA88LA085Accident · No injuriesLimited investigationFinal reportBeech 35 · Pasco, WADuring lndg roll, NLG and rmlg collapsed. During tow in from rwy, lndg gear cb was noted to be tripped. Cause of cb activation unk.NTSB SEA84LA040Accident · No injuriesLimited investigationFinal reportBeech A35 · Renton, WAThe acft was damaged during a forced landing after the engine quit after takeoff. The plt said he noticed the oil pressure drop to zero a few minutes after takeoff and was turning back to the arpt when the engine quit. He did not lower the landing gear since…NTSB SEA81FYE23Accident · No injuriesClosedBeech 35 · Puyallup, WANTSB SEA71DWD19Accident · No injuriesClosedBeech 35 · Auburn, WANTSB SEA70FWD06Accident · No injuriesClosedBeech 35 · Georgetown, WANTSB SEA70D0012Accident · No injuriesClosedBeech 35 · Lynden, WANTSB SEA69A0051Accident · 3 fatalClosedBeech 35 · Albion, WANTSB SEA69D0090Accident · No injuriesClosedBeech 35 · Neah Bay, WANTSB SEA66D0179Accident · No injuriesClosedBeechcraft 35 · Pullman, WANTSB SEA65A0025Accident · 2 fatalClosedBeechcraft 35 · Granite Fals, WANTSB UNK64X3003Accident · 2 fatalClosedBeech D-35 · Richland, WANTSB UNK64X2272Accident · Serious injuriesClosedBeechcraft 35 · Martha Lake, WANTSB UNK64X1083Accident · No injuriesClosedBeechcraft 35 · Renton, WA