NTSB investigations: Beech G35, FL
16 cases on aircraft the registry lists as Beech G35. 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
| 1965 | 2 |
|---|---|
| 1967 | 2 |
| 1970 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1980 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1995 | 1 |
| 2008 | 1 |
| 2017 | 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 ('1151516'))
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 ('1151516'))
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 ERA18FA056Accident · 1 fatalField investigationFinal reportBeech G35 · Cross City, FLThe pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in the pilot experiencing spatial disorientation and a subsequent loss of airplane control.NTSB NYC08LA164Accident · No injuriesLimited investigationFinal reportBeech G35 · New Smyrna Beach, FLThe pilot's inadvertent encounter with turbulence that was not forcast.NTSB NYC95FA049Accident · 1 fatalField investigationFinal reportBeech G35 · West Palm Beach, FLImproper top overhaul by maintenance personnel, and improperly torqued crackcase thru-bolts and cylinder deck studs at the number one cylinder, which led to fatigue failure of four of the bolts, failure and/or separation of the number one cylinder, and a…NTSB MIA89LA074Accident · Minor injuriesLimited investigationFinal reportBeech G-35 · Panacea, FLPilots loss of control when entering the fog bank during the takeoff, due to spatial disorientation.NTSB MIA86LA019Accident · No injuriesLimited investigationFinal reportBeech G35 · Destin, FLThe acft veered off rwy 14 and struck a rwy light and small trees during an attempted x-wind takeoff. The plt stated that he thought the x-wind was from the right, however, the surface winds were reported as 050 at 9 KTS with gusts 12 to 15 KTS, a left x-wind.NTSB MIA81FA040Accident · 1 fatalClosedBeech G35 · St.Petersburg, FLNTSB MIA80FKT21Accident · Minor injuriesClosedBeech G35 · Pompano, FLNTSB MIA74FLA39Accident · No injuriesClosedBeech G35 · Jacksonville, FLNTSB MIA74DLD64Accident · No injuriesClosedBeech 35G · Venice, FLNTSB IAD73AI003Accident · 1 fatalClosedBeech G35 · Winter Haven, FLNTSB MIA71DLD09Accident · No injuriesClosedBeech G-35 · Merritt Isl, FLNTSB MIA70FKT27Accident · Serious injuriesClosedBeech G35 · Pompano Beach, FLNTSB MIA68F0164Accident · No injuriesClosedBeech D35 · Sarasota, FLNTSB MIA67F0520Accident · No injuriesClosedBeech 35G · Merritt Isle, FLNTSB MIA66F0311Accident · No injuriesClosedBeechcraft G-35 · Orlando, FLNTSB MIA66F0100Accident · No injuriesClosedBeechcraft G-35 · Sarasota, FL