NTSB investigations: Aero Commander 100, FL
18 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
| 1967 | 2 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 2006 | 1 |
| 2009 | 1 |
| 2020 | 1 |
| 2022 | 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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
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 ERA23LA020Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 100 · New Smyrna Beach, FLThe pilot’s exceedance of the critical angle of attack during takeoff and corresponding stall/mush. Contributing to the accident were the pilot’s operation of the airplane above the maximum specified gross weight.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 MIA06CA080Accident · Minor injuriesData collectionFinal reportAero Commander 100 · Englewood, FLThe pilot's failure to abort the takeoff in time to stop on the remaining runway, which resulted in the airplane overrunning the runway.NTSB MIA92LA181Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Panacea, FLFailure of the nose landing gear push/pull rod end bearing for undetermined reasons.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 MIA86LA137Accident · Minor injuriesLimited investigationFinal reportRockwell 100 · Ft.Lauderdale, FLThe acft was stolen by a 17 year old non-pilot rated male. While taxiing on a taxiway the acft was reported to be fish tailing before it ran off the taxiway and became airborne. When the acft touched down it bounced aprx 10 ft into the air and performed a…NTSB MIA85FA248Accident · Minor injuriesField investigationFinal reportAero Commander 100 · Oak Hill, FLThe plt was making his first flt in his recently purchased acft. The plt stated that both fuel tanks were full prior to take-off. Approximately 20 mins after take-off, an attempt was made to switch from the right fuel tank to the left fuel tank. Seconds…NTSB MIA82DA084Accident · No injuriesFinal reportRockwell Commander AC-100 · Chipley, FLThe student pilot/mechanic was attempting to fly the aircraft from where the owner kept the aircraft to the maintainance facility approximately 4 miles away. The pilot stated that just after level off the engine quit. A road was selected to land on but at the…NTSB MIA81DLD63Accident · Minor injuriesClosedAero Comdr 100 · Ft Pierce, FLNTSB MIA79FLD64Accident · No injuriesClosedAero Cmdr 100 · Bonita Springs, FLNTSB MIA75FLD57Accident · No injuriesClosedAero Comdr 100 · Tampa, FLNTSB MIA74DLD85Accident · No injuriesClosedAero Comdr 100 · Tampa, FLNTSB MIA74AM070Accident · 2 fatalClosedAero Comdr 100 · Ft Meade, FLNTSB MIA71AM055Accident · 2 fatalClosedAero Comdr 100 · Boca Raton, FLNTSB MIA71FLA25Accident · No injuriesClosedAero Comdr 100 · Marianna, FLNTSB MIA68D0335Accident · No injuriesClosedAero Comdr 100 · Bunnell, FLNTSB MIA68D0334Accident · No injuriesClosedAero Comdr 100 · Bunnell, FL