Fatal NTSB investigations: Aero Commander 500-A
13 cases on aircraft the registry lists as Aero Commander 500-A. 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.
Cases per year
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1975 | 3 |
| 1978 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 2014 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('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_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 ('0141104'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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…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…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…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.NTSB LAX78FA031Accident · 7 fatalClosedAero Comdr 500A · Solvang, CANTSB LAX26O0011Accident · 5 fatalClosedAero Comdr 500A · Baja Ca Norte, MexicoNTSB OAK76AP017Accident · 6 fatalClosedAero Comdr 500A · Walnut Grove, CANTSB CHI76AC006Accident · 2 fatalClosedAero Comdr 500A · Valparaiso, INNTSB CHI73AC043Accident · 6 fatalClosedAero Comdr 500-A · Pekin, ILNTSB LAX72AL061Accident · 2 fatalClosedAero Comdr 500-A · Safford, AZNTSB LAX72AL027Accident · 5 fatalClosedAero Comdr 500-A · San Diego, CANTSB MIA71AM053Accident · 1 fatalClosedAero Comdr 500-A · Mcalpin, FLNTSB OAK69A0060Accident · 1 fatalClosedAero Comdr 500-A · Ione, CA