NTSB investigations: Beech C35, FL
10 cases on aircraft the registry lists as Beech C35. 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
| 1967 | 1 |
|---|---|
| 1973 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1992 | 1 |
| 1993 | 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 ('1151508'))
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 ('1151508'))
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 MIA93FA200Accident · 1 fatalField investigationFinal reportBeech C35 · Ocklawaha, FLFailure of a propeller blade for an undetermined reason, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: low pass performed by the pilot, and his possible impairment from…NTSB MIA92LA120Accident · No injuriesLimited investigationFinal reportBeech C35 · Scottsmoor, FLEncounter with clear air turbulence during cruise flight.NTSB MIA86LA245Accident · No injuriesLimited investigationFinal reportBeech G-35 · Lantana, FLShortly after takeoff the cabin door opened. The pilot continued the short flight to his home airfield. During approach he stated that due to the increased noise in the cabin he forgot to lower the landing gear. The aircraft contacted the runway with the…NTSB MIA85FA159Accident · 4 fatalField investigationFinal reportBeech C35 · Tampa, FLWitnesses observed the acft takeoff on rwy 36 in foggy conditions. They reported that during the initial climb after lift-off, the acft pitched up & rolled into a steep left bank, then entered a descent & crashed on an aprx heading of 060 deg. Impact occurred…NTSB MIA79FLD29Accident · No injuriesClosedBeech C35 · Brooksville, FLNTSB MIA78DKT04Accident · Minor injuriesClosedBeech C35 · Key Largo, FLNTSB MIA76FLD07Accident · No injuriesClosedBeech C35 · Bradenton, FLNTSB MIA74DLD40Accident · No injuriesClosedBeech C35 · Orange Lake, FLNTSB MIA74DLD27Accident · Minor injuriesClosedBeech C35 · Castleberry, FLNTSB MIA67F0429Accident · No injuriesClosedBeech C35 · Tampa, FL