Skip to content

Fatal NTSB investigations: Aero Commander 680FL

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

19652026

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 ('0141608')) 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 ('0141608'))
  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 ('0141608'))
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 WPR11FA078Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Perris, CAThe pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.Dec 20, 2010 · N316KW · Substantial damage NTSB SEA98FA100Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Helena, MTThe pilot's failure to maintain the correct altitude while turning inbound during a procedure turn to the ILS final approach course. Factors include hilly/mountainous terrain and clouds in the area where the course reversal was performed.Jun 17, 1998 · N446JR · Destroyed NTSB SEA93FA046Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Lester, WAUndetermined.Dec 26, 1992 · N111MN · Destroyed NTSB SEA88FA069Accident · 2 fatalField investigationFinal reportAero Commander 680FL · Soda Springs, IDWhile en route on a night IFR cargo flt, the plt reqd & was clrd for a dscnt from an IFR cruise alt of 16,000 ft to proceed vfr-on-top. The last transmission from the acft was at 2106 when the plt acknowledged that he was familiar with the terrain along the…Apr 9, 1988 · N291NC · Destroyed NTSB NYC86FA201Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Duxsbury, VTThe plt was on a VFR flight from montpelier, VT to burlington, VT; a distance of about 80 mis. A mountain range is between the two location. Shortly after takeoff the plt radioed burlington approach control and requested an IFR clearance to land at…Aug 8, 1986 · N6341U · Destroyed NTSB MKC86FA101Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Grand Island, NEThe twin eng acft crashed and burned 4 miles north of the arpt while on an instrument apch. The plt had transmitted that he had an engine problem. The #5 cylinder was found detached from the left engine but the left propeller was not feathered. An engine…May 9, 1986 · N1198Z · Destroyed NTSB DEN85FA240Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Fort Collins, COThe plt was operating his acft under the rules of 14 CFR 135, I.e., a scheduled domestic cargo flt. He made a normal departure and climb en route to salt lake city, Utah. Normal communications and radar flt following was established with denver ARTCC.…Sep 12, 1985 · N45724 · Destroyed NTSB DEN83FA131Accident · 2 fatalField investigationFinal reportAero Commander 680FL · Monticello, UTThe acft crashed while doing magnetometer surveys at low altitude. The right engine had lost power then regained it for a short period and lost it again. A videotape in the acft recorded the plt saying, 'I changed that # just in time.' The acft yawed and the…Jun 2, 1983 · N271VT · Destroyed NTSB MIA81FA105Accident · 4 fatalClosedAero Comdr 680FL · St.Croix, VIAug 16, 1981 · N6600M · Destroyed NTSB ANC81DA013Accident · 1 fatalClosedAero Comdr 680-FL · Gambell, AKDec 30, 1980 · N113NA · Minor damage NTSB CHI80FA067Accident · 1 fatalClosedAero Comdr 680FL · Chicago, ILSep 3, 1980 · N4700E · Destroyed NTSB MIA80FA032Accident · 2 fatalClosedAero Comdr 680FL · Sebring, FLFeb 14, 1980 · N662B · Destroyed NTSB NYC79FA082Accident · 3 fatalClosedAero Comdr 680FL · Rexville, NYAug 23, 1979 · N5003E · Destroyed NTSB MIA78DA115Accident · 2 fatalClosedAero Comdr 680F · Ngreat Inagua (Atlantic Ocean)Aug 7, 1978 · N669SA · Destroyed NTSB IAD78FA041Accident · 4 fatalClosedAero Cmdr 680FL · Morrisville, NCFeb 13, 1978 · N26511 · Destroyed NTSB LAX74AL027Accident · 1 fatalClosedAero Comdr 680FL · Van Nuys, CAOct 12, 1973 · N7377B · Substantial damage NTSB NYC71AN007Accident · 3 fatalClosedAero Comdr 680-FL · Butler, PAJul 17, 1970 · N6501V · Destroyed NTSB FTW69A0005Accident · 1 fatalClosedAero Comdr 680-FL · Paris, TXJul 19, 1968 · N224W · Destroyed NTSB NYC68A0027Accident · 1 fatalClosedAero Comdr 680-FL · Greenland Ice Cap, GreenlandAug 14, 1967 · N6362U · Destroyed NTSB ANC66A0009Accident · 4 fatalClosedAero Comm 680 · Lk.Tustumena, AKSep 4, 1965 · N6305U · Destroyed