Skip to content

Aero Commander 500-A

NTSB investigations · 24

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('0141104') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('0141104')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('0141104')
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 CEN15FA056Accident · 1 fatalField investigationFinal reportAero Commander 500A · McDade, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack for reasons that could not be determined based on the available evidence, which resulted in an aerodynamic stall/spin. Contributing to the accident…Nov 23, 2014 · N14AV · Substantial damage NTSB ANC97FA143Accident · 2 fatalField investigationFinal reportAero Commander AC-500A · Ketchikan, AKThe rupture of the right engine fuel supply line as a result of inadequate inspection by the pilot/mechanic, and the pilot's excessive pull up which resulted in exceeding the design stress limits of the airplane. Factors were the improper emergency procedures…Sep 6, 1997 · N543AN · Destroyed NTSB SEA94FA121Accident · 4 fatalField investigationFinal reportAero Commander 500A · Livermore, CAA fuel system leak, inadequate preflight by the pilot (PIC), and by the non-flying pilot/passenger intentionally allowing operation of the aircraft with a known deficiency (fuel leak). A factor related to the accident was: the lack of suitable terrain for a…May 20, 1994 · N601MK · Destroyed NTSB NYC94FA040Accident · 2 fatalField investigationFinal reportAero Commander 500A · White Mills, PAwas the fracture and separation of the airplane wing, and the subsequent loss of control and collision with trees, as a result of the pilot's repeated performance of acrobatic maneuvers, which exceeded the design limits of the airplane.Dec 16, 1993 · N9379R · Destroyed NTSB LAX81FUK01Accident · Minor injuriesClosedAero Comdr 500A · Flagstaff, AZSep 10, 1981 · N6JB · Substantial damage NTSB NYC81FFA07Accident · No injuriesClosedAero Comdr 500-A · Glens Falls, NYNov 18, 1980 · N20MA · Substantial damage NTSB LAX78FA031Accident · 7 fatalClosedAero Comdr 500A · Solvang, CAFeb 28, 1978 · N6143X · Destroyed NTSB CHI76FEE61Accident · No injuriesClosedAero Comdr 500A · Dekalb, ILJun 3, 1976 · N78379 · Substantial damage NTSB LAX26O0011Accident · 5 fatalClosedAero Comdr 500A · Baja Ca Norte, MexicoDec 21, 1975 · N9392R · Destroyed NTSB OAK76AP017Accident · 6 fatalClosedAero Comdr 500A · Walnut Grove, CAOct 10, 1975 · N9394R · Destroyed NTSB CHI76AC006Accident · 2 fatalClosedAero Comdr 500A · Valparaiso, INJul 28, 1975 · N78378 · Destroyed NTSB FTW75FPG49Accident · Minor injuriesClosedAero Comdr 500A · Springdale, ARMay 1, 1975 · N6147X · Substantial damage NTSB IAD74DLT11Accident · No injuriesClosedAero Comdr 500-A · Memphis, TNDec 27, 1973 · N6143X · Substantial damage NTSB LAX74OL039Accident · No injuriesClosedAero Comdr 500-A · Las Cruces, MexicoOct 27, 1973 · N9392R · Substantial damage NTSB CHI73AC043Accident · 6 fatalClosedAero Comdr 500-A · Pekin, ILOct 23, 1972 · N78376 · Destroyed NTSB LAX72AL061Accident · 2 fatalClosedAero Comdr 500-A · Safford, AZJun 2, 1972 · N140X · Destroyed NTSB LAX72AL027Accident · 5 fatalClosedAero Comdr 500-A · San Diego, CAOct 21, 1971 · N11MK · Destroyed NTSB MIA71AM053Accident · 1 fatalClosedAero Comdr 500-A · Mcalpin, FLDec 16, 1970 · N6170X · Destroyed NTSB MIA70F0269Accident · No injuriesClosedAero Comdr 500-A · Tallahassee, FLNov 1, 1969 · N6170X · Substantial damage NTSB OAK69A0060Accident · 1 fatalClosedAero Comdr 500-A · Ione, CAMar 22, 1969 · N6145X · Substantial damage NTSB CHI69F0380Accident · Minor injuriesClosedAero Comdr 500-A · Paducah, KYNov 27, 1968 · N9381R · Destroyed NTSB FTW67D0115Accident · No injuriesClosedAero Comdr 500-A · Dimmit, TXAug 1, 1966 · N6262X · Substantial damage NTSB NYC66F0544Accident · Minor injuriesClosedAero Comdr 500-B · Hagerstown, MDFeb 24, 1966 · N9388R · Substantial damage NTSB OAK66F0136Accident · Minor injuriesClosedAero Cmdr 500A · Lanai, HISep 27, 1965 · N9376R · Substantial damage

Back to Aero Commander 500-A