NTSB investigations: Aero Commander 680, FL

11 cases on aircraft the registry lists as Aero Commander 680. 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

19642026

NTSB investigations: Aero Commander 680, FL per year, 1964–2026: 11 cases
1964	1
1975	1
1977	1
1978	1
1979	2
1980	2
1981	1
1982	1
1983	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 ('0141602')) 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 ('0141602'))
  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 ('0141602'))
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 ATL83AA184Accident · 3 fatalFinal reportAero Commander 680 · Titusville, FLWitnesses saw the acft briefly before it crashed. One witness saw the acft flying toward a dark cloud at an unknown alt, but too high to fly under it. Shortly thereafter, he heard the eng noise increase & decrease, then increase until it was loud. He then…May 12, 1983 · N6880S · Destroyed NTSB MIA83LA029Accident · No injuriesLimited investigationFinal reportAero Commander 680 · Belle Glade, FLAcft had been object of an airborne pursuit by U.S. Customs at about 1830 in the vicinity of Belle Glade. During the pursuit the acft door & 15 bales of a controlled substance were observed being jettisoned from the acft. After landing the acft was set on…Nov 15, 1982 · N163KT · Destroyed NTSB MIA81FA061Accident · 2 fatalClosedAero Comdr 680 · Labelle, FLApr 2, 1981 · N777A · Destroyed NTSB MIA81EKT61Accident · No injuriesClosedAero Comdr 680 · Labelle, FLSep 29, 1980 · N1922H · Substantial damage NTSB MIA80DLD33Accident · No injuriesClosedAero Comdr 680E · Bradenton, FLJan 29, 1980 · N6850S · Substantial damage NTSB MIA80FKT05Accident · No injuriesClosedAero Comdr 680 · Clewiston, FLOct 23, 1979 · N5MZ · Substantial damage NTSB MIA79DLE01Accident · No injuriesClosedRockwell 680 · Suwannee, FLSep 30, 1979 · N6822S · Substantial damage NTSB MIA78DLD65Accident · No injuriesClosedAero Comdr 680S · Okeechobee, FLJul 5, 1978 · N141AC · Substantial damage NTSB MIA77FA068Accident · 6 fatalClosedAero Cmdr 680 · Ft Lauderdale, FLJul 16, 1977 · N6892S · Destroyed NTSB MIA75DKT47Accident · No injuriesClosedAero Comdr 680 · Palm Beach, FLFeb 9, 1975 · N680LP · Destroyed NTSB UNK65X1103Accident · No injuriesClosedAero Cmdr 680E · Jacksonville, FLDec 23, 1964 · N58G · Substantial damage