NTSB investigations: Beech V35A, FL
10 cases on aircraft the registry lists as Beech V35A. 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 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1994 | 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 ('1151544', '1151542'))
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 ('1151544', '1151542'))
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 MIA94LA063Accident · No injuriesLimited investigationFinal reportBeech 35 · Leesburg, FLThe pilot-in-command's poor evaluation of the weather and failure to remain in visual meteorological conditions, resulting in an in-flight collision with water.NTSB MIA89LA002Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Fort Lauderdale, FLThe plt stated that aprx 15 minutes after takeoff from Fort Lauderdale, the eng quit completely & he was unable to make it back to the arpt. While attempting a forced landing in a field, he landed nose down, the nose gear collapsed, and the acft slid to a…NTSB MIA83FA168Accident · Serious injuriesField investigationFinal reportBeech V35A · Lehigh Acres, FLAccording to the pilot he started to make a go around after he realized that he would not be able to stop the aircraft on the wet runway. He failed to gain sufficient altitude to clear the trees just beyond the airport boundary. He said he landed at the…NTSB MIA81DLD36Accident · No injuriesClosedBeech V-35A · St.Petersburg, FLNTSB MIA79DLA25Accident · No injuriesClosedBeech V35A · Newberry, FLNTSB MIA75DLA36Accident · No injuriesClosedBeech V35A · Perry, FLNTSB MIA71FLD42Accident · Serious injuriesClosedBeechcraft V35ATC · Orlando, FLNTSB MIA71AM029Accident · 2 fatalClosedBeech V35A · Ft.Lauderdale, FLNTSB MIA70A0051Accident · 4 fatalClosedBeech V35A · Tampa, FLNTSB MIA66F0107Accident · No injuriesClosedBeechcraft B-50 · Jacksonville, FL