Fatal NTSB investigations: Aero Commander 100
12 cases on aircraft the registry lists as Aero Commander 100. 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 | 2 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1991 | 1 |
| 1994 | 1 |
| 2009 | 1 |
| 2020 | 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 ('0140202'))
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 ('0140202'))
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 ERA21LA020Accident · 1 fatalClass 3 · LimitedFinal reportAero Commander 100 · Citra, FLThe student pilot’s inadequate preflight planning likely due to impairment from ethanol, which resulted in a total loss of engine power due to fuel exhaustion. Contributing was his improper decision to depart from an unlit airstrip in dark night conditions.NTSB ERA10FA052Accident · 1 fatalField investigationFinal reportAero Commander 100 · Weston, FLThe flight's descent for undetermined reasons, resulting in the in-flight collision with terrain.NTSB LAX94FA211Accident · 1 fatalField investigationFinal reportAero Commander 100 · Ocotillo Wells, CAthe failure of the pilot to maintain flying speed after experiencing a partial power failure while maneuvering. A factor in the accident was the failure of the pilot to drain accumulated water from the aircraft fuel system during the preflight inspection.NTSB MIA92FA004Accident · 1 fatalField investigationFinal reportAero Commander 100 · Carrabelle, FLThe non instrument-rated pilot-in-command's decision to continue flight into known instrument meteorological conditions (thunderstorm) and failure to maintain airspeed (vso) while maneuvering. Contributing to the accident was the pilot-in-command's failure to…NTSB FTW75AK018Accident · 3 fatalClosedAero Comdr 100 · Inola, OKNTSB MIA74AM070Accident · 2 fatalClosedAero Comdr 100 · Ft Meade, FLNTSB FTW74AF027Accident · 4 fatalClosedAero Comdr 100 · Dialville, TXNTSB FTW72AF041Accident · 1 fatalClosedAero Comdr 100 · Seguin, TXNTSB MIA71AM055Accident · 2 fatalClosedAero Comdr 100 · Boca Raton, FLNTSB NYC70AN111Accident · 1 fatalClosedAero Comdr 100 · Grantville, PANTSB MKC70A0011Accident · 1 fatalClosedAero Comdr 100 · Brentwood, ARNTSB UNK69X0133Accident · 4 fatalClosedAero Comdr 100 · Lacey Springs, AL