NTSB investigations: Beech S35, FL
12 cases on aircraft the registry lists as Beech S35. 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
| 1973 | 1 |
|---|---|
| 1975 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 2006 | 1 |
| 2014 | 2 |
| 2021 | 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\" = 'FL' 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 ('1151532'))
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" = 'FL' 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 ('1151532'))
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 ERA22LA082Accident · Minor injuriesClass 3 · LimitedFinal reportBeech S35 · Tallahassee, FLA total loss of engine power due to a lack of oil lubrication.NTSB ERA14FA403Accident · 1 fatalField investigationFinal reportBeech S35 · Laurel Hill, FLA total loss of engine power due to detonation/preignition damage of the No. 6 cylinder. Contributing to the accident was the pilot’s decision to continue flight after receiving an indication of an impending engine failure.NTSB ERA14CA175Accident · Minor injuriesData collectionFinal reportBeech S35 · Marathon, FLThe pilot's distraction in the cockpit while on a visual approach over water during a dark night resulting in the airplane descending until impact with the water.NTSB NYC06FA230Accident · 1 fatalField investigationFinal reportBeech S35 · Lake City, FLA loss of control during an unintentional takeoff for an undetermined reason.NTSB MIA92LA027Accident · 1 fatalLimited investigationFinal reportBeech BE-35 · St. Petersburg, FLThe passenger's loss of balance resulting from a previous impairment.NTSB MIA89FA100Accident · 2 fatalField investigationFinal reportBeech S35 · Daytona Beach, FLThe pilot's improper IFR procedure and his failure to maintain proper altitude. Contributing factors were: his improper use of the navigation receiver, his delay in making a missed apch, his lack of experience in the type of aircraft, his lack of recent…NTSB MIA81FLD22Accident · No injuriesClosedBeech S35 · Sanford, FLNTSB MIA80FKT56Accident · Minor injuriesClosedBeech 60 · Pompano Beach, FLNTSB MIA80FA051Accident · 1 fatalClosedBeech S35 · Horseshoe Bch, FLNTSB MIA76FLD79Accident · Serious injuriesClosedBeech S35 · Tampa, FLNTSB MIA76DKT25Accident · Minor injuriesClosedBeech B-35 · Palm Beach, FLNTSB MIA73FLD55Accident · No injuriesClosedCessna 172E · Sebring, FL