Skip to content

Fatal NTSB investigations: Aero Commander 680

21 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

Where

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."highestInjuryLevel" = 'Fatal' 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.\"highestInjuryLevel\" = 'Fatal'
    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."highestInjuryLevel" = 'Fatal'
  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 SEA95FA111Accident · 3 fatalField investigationFinal reportAero Commander 680 · North Bend, ORThe pilot initiating flight into weather conditions beyond what he was capable of handling. The pilot's overconfidence in his personal ability and the low ceiling were factors in the accident.Jun 1, 1995 · N6877S · Destroyed NTSB ATL93FA004Accident · 1 fatalField investigationFinal reportAero Commander 680 · Headland, ALThe pilot's failure to maintain control of the airplane while conducting a high speed taxi maneuver which resulted in inadvertent flight. Factors were the pilot's over confidence in his ability, his lack of familiarity with the airplane and the wind gust.Oct 6, 1992 · N4490 · Substantial damage NTSB NYC83FA193Accident · 2 fatalField investigationFinal reportNorth American Rockwell 680 · Bayport, NYAt about 60 ft AGL black smoke was observed coming from the left eng. The acft continued a climb in a nose high attitude& the nose pitched down & the acft rolled inverted. Eng teardown revealed extensive damage to the supercharger assembly. The impeller shaft…Jul 28, 1983 · N6878S · Destroyed 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 MIA81FA061Accident · 2 fatalClosedAero Comdr 680 · Labelle, FLApr 2, 1981 · N777A · Destroyed NTSB FTW79FA034Accident · 1 fatalClosedAero Comdr 680 · Oklahoma City, OKDec 28, 1978 · N6818S · Destroyed NTSB MIA78DA080Accident · 2 fatalClosedAero Comdr 680 · Missing AircraftMar 25, 1978 · N128C · Destroyed NTSB MIA77FA068Accident · 6 fatalClosedAero Cmdr 680 · Ft Lauderdale, FLJul 16, 1977 · N6892S · Destroyed NTSB LAX77FA049Accident · 5 fatalClosedAero Comdr 680 · Upland, CAJun 7, 1977 · N6853S · Destroyed NTSB DEN76AD026Accident · 4 fatalClosedAero Comdr 680 · Pagosa Spgs, CODec 28, 1975 · N6221D · Destroyed NTSB FTW73AF052Accident · 3 fatalClosedAero Comdr 680 · Oklahoma Cty, OKMar 18, 1973 · N7312 · Destroyed NTSB FTW73AF017Accident · 2 fatalClosedAero Comdr 680 · Dallas, TXNov 6, 1972 · N6204D · Destroyed NTSB IAD71AI055Accident · 6 fatalClosedAero Comdr 680E · Roanoke, VAMay 28, 1971 · N601JJ · Destroyed NTSB SEA68A0024Accident · 1 fatalClosedAero Comdr 680 · Portland, ORSep 4, 1967 · N6809S · No damage NTSB MIA67A0062Accident · 1 fatalClosedAero Comdr 680 · Spring City, TNDec 2, 1966 · N6857S · Destroyed NTSB CHI67A0070Accident · 2 fatalClosedAero Comdr 680F · Bangor, MINov 26, 1966 · N226AA · Destroyed NTSB DEN66A0068Accident · 6 fatalClosedAero Comdr 680 · Meeker, COMar 20, 1966 · N94T · Destroyed NTSB OAK66A0035Accident · 2 fatalClosedAero Comor 680 · Red Bluff, CAFeb 25, 1966 · N6820S · Destroyed NTSB CHI66A0056Accident · 6 fatalClosedAero CDR 680 · Kite, KYDec 6, 1965 · N6819S · Destroyed NTSB UNK65X0150Accident · 1 fatalClosedAero CDR 680 · Charlotte, NCOct 4, 1964 · N6271D · Destroyed NTSB UNK64X2383Accident · 2 fatalClosedAero Cmdr 680 · Southhampton, MAJun 19, 1964 · N344S · Destroyed