NTSB investigations: Beech 65, FL

11 cases on aircraft the registry lists as Beech 65. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19732026

NTSB investigations: Beech 65, FL per year, 1973–2026: 11 cases
1973	1
1974	1
1979	4
1980	2
1984	1
1987	1
1992	1

Where

Open the map

Latest cases

Query with SQL

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 ('1152802')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('1152802'))
  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 ('1152802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 MIA93FA031Accident · 5 fatalField investigationFinal reportBeech 65 · Orlando, FLThe pilot's failure to feather the propeller to maintain altitude following a loss of power of the left engine. The power loss was due to an improperly maintained fuel system. In addition, the right engine lost power for an undetermined reason(s).Dec 19, 1992 · N555GC · Destroyed NTSB MIA87LA097Accident · No injuriesLimited investigationFinal reportBeech B-65 · Key Largo, FLThe aircraft was found crashed in shallow water near Key Largo FL. Attempts to locate the pilot or current operator were fruitless. The circumstances surrounding the crash and the cause are unknown.Mar 3, 1987 · N822Q · Destroyed NTSB MIA85FA057Accident · No injuriesField investigationFinal reportBeech 65 · Marathon, FLAccording to the plt, aprx 20 min after departure at 4,000 to 5,000 ft the left eng failed followed 10 min later by a power loss in the right eng. During the desc the right eng restarted momentarily but only ran for about 1 min. The plt ditched near a…Dec 10, 1984 · N101V · Substantial damage NTSB MIA80FA099Accident · 6 fatalClosedBeech 65 · Clearwater, FLSep 12, 1980 · N625GP · Destroyed NTSB MIA80FA077Accident · 4 fatalClosedBeech 65 · Ft.Pierce, FLJun 29, 1980 · N156F · Destroyed NTSB MIA79FA090Accident · 1 fatalClosedBeech 65 · Boca Raton, FLMay 27, 1979 · N72DR · Destroyed NTSB MIA79FA058Accident · 2 fatalClosedBeech 65 · Arcadia, FLMar 19, 1979 · N70GC · Destroyed NTSB MIA79DKT44Accident · No injuriesClosedBeech 65 · Belle Glade, FLJan 31, 1979 · N707E · Substantial damage NTSB MIA79FKT33Accident · No injuriesClosedBeech 65 · South Bay, FLJan 14, 1979 · N465L · Substantial damage NTSB MIA74AM056Accident · 5 fatalClosedBeech 65 · Jacksonville, FLJan 10, 1974 · N671T · Destroyed NTSB MIA73FKT96Accident · No injuriesClosedBeech 65 · Palm Beach, FLMay 12, 1973 · N956B · Substantial damage