NTSB investigations: Beech 35, AR
10 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 |
|---|---|
| 1967 | 2 |
| 1975 | 1 |
| 1978 | 1 |
| 1984 | 2 |
| 1997 | 1 |
| 2001 | 1 |
| 2022 | 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\" = 'AR' 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" = 'AR' 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 CEN22LA364Accident · No injuriesClass 4 · LimitedFinal reportBeechcraft 35 · Star City, ARThe pilot’s delayed decision to abort the takeoff, which resulted in a runway excursion and impact with a ditch.NTSB FTW01LA140Accident · Serious injuriesLimited investigationFinal reportBeech BE-35 · Springdale, ARthe loss of engine power due to an undetermined reason.NTSB FTW98LA078Accident · No injuriesLimited investigationFinal reportBeech 35 · Springdale, ARThe fuel exhaustion due to the pilot's failure to refuel and his inadequate pre-flight planning. Factors were the pilot's disorientation due to instrument meteorological conditions. Another factor, was the lack of suitable terrain for the pilot to execute a…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 FTW78DPG62Accident · No injuriesClosedBeech 35 · Wynne, ARNTSB FTW76AF019Accident · 1 fatalClosedBeech 35 · Harrison, ARNTSB FTW68D0365Accident · No injuriesClosedBeech 35 · Booneville, ARNTSB FTW67A0110Accident · 1 fatalClosedBeech 35 · Umpire, ARNTSB UNK64X2668Accident · No injuriesClosedBeechcraft 35 · Springdale, AR