NTSB investigations: Beech 65-80, FL
9 cases on aircraft the registry lists as Beech 65-80. 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
| 1966 | 1 |
|---|---|
| 1969 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1980 | 2 |
| 1983 | 1 |
| 1984 | 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 ('1152806'))
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 ('1152806'))
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 MIA84FA163Accident · Serious injuriesField investigationFinal reportBeech 65-80 · Opa Locka, FLThe plt stated that he did not check the acft fuel visually prior to departure. About 10 minutes after takeoff, while using auxiliary fuel tanks, the right eng lost power. The plt selected crossfeed & the eng restarted. He then turned off the right fuel…NTSB MIA83FA235Accident · Serious injuriesField investigationFinal reportBeech 65-80 · Miami, FLSeveral days prior, a fam flt was intended in the acft to be given to the plt by another person who represented himself as a plt. The flt was cancelled due to a problem with the left eng. On the day of the accident, the other person told the plt that the eng…NTSB MIA80FLD96Accident · No injuriesClosedBeech 65-B80 · Lake Marion, FLNTSB MIA80FLD52Accident · Serious injuriesClosedBeech 65-80 · Sebring, FLNTSB MIA7LDLD77Accident · No injuriesClosedBeech 65-80 · Lake Placid, FLNTSB MIA76FLD68Accident · No injuriesClosedBeech 65-80 · Clearwater, FLNTSB MIA74FLA28Accident · No injuriesClosedBeech 65-80 · Crestview, FLNTSB MIA70D0013Accident · No injuriesClosedBeech 65-80 · Ft.Meyers, FLNTSB MIA67F0162Accident · No injuriesClosedBeech 65-80 · Merritt Isl., FL