Aero Commander 500
NTSB investigations · 47
Matched to the registry by N-number and event date, newest first.
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_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 ('0141102')
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 ('0141102')
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 ERA10WA498Accident · Minor injuriesForeign investigationAero Commander 500 · Santo Domingo, Dominican RepublicNTSB MIA05LA079Accident · No injuriesLimited investigationFinal reportRockwell Aero Commander 500 · San Juan, PRThe failure of the pilot to follow the emergency checklist and his inadvertent operation of the airplane with known discrepancies resulting in landing overrun and on-ground collision with a ditch during the landing roll.NTSB ATL04LA065Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Allendale, SCThe failure of the hydraulic brake system accumulator due to a ruptured diaphragm. A factor was the ditch.NTSB LAX02LA001Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Petaluma, CAThe pilot's inadvertent (dark, nighttime) VFR flight into instrument meteorological conditions and subsequent loss of altitude control. A factor in the accident was the pilot's inadequate preflight weather evaluation.NTSB MIA00FA058Accident · 2 fatalField investigationFinal reportAero Commander 500 · Georgetown, SCThe noninstrument-rated pilot's improper decision to attempt VFR flight into known instrument flight conditions, willful disregard of FAA Automated Flight Service Station weather forecast/weather observations, failure to maintain airspeed (VSO) while…NTSB CHI99LA173Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Effingham, ILinadvertent wheels-up landing and the checklist not followed by the pilot. The landing gear lever not engaged was an additional cause.NTSB MIA95WA179Accident · 1 fatalForeign investigationAero Commander 500 · Treasure Cay, BahamasNTSB MIA93IA083Incident · No injuriesIncident investigationFinal reportAero Commander 500 · Everglades City, FLThe preexisting fatigue cracking of the propeller hub arm in the bearing retention radius due to polishing and wear of the radius from contact with the split rings, resulting in a propeller blade separating from the propeller hub on the takeoff ground run,…NTSB MIA91LA193Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-698 · Atlantic Ocean (Atlantic Ocean)An inflight loss of power of both engines for undetermined reasons followed by a ditching in the Ocean.NTSB MIA88LA043Accident · No injuriesLimited investigationFinal reportNorth American 500 · San Juan, PRWhile on a part 135 non-scheduled domestic passenger flt in VFR conditions, the plt landed the acft gear up. Operational check of the landing gear & warning horn revealed no failure or malfunction.NTSB ATL86LA033Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Albany, GAThe aircraft landed on the wet sod runway with a 30 to 35 knot tailwind and ran off the end of the runway and into the trees. The pilot related that the wind shifted 180 degrees upon touchdown. The pilot also stated that he touched down approximately 1000 ft…NTSB MIA85IA156Incident · No injuriesIncident investigationFinal reportRockwell AC-500 · Palm Beach, FLOn final apch, the acft was advised twice by the tower to go around because his landing gear was not extended, the acft did not respond & landed gear up on rwy 13. Examination of the landing gear system after the occurrence revealed the warning horn was…NTSB NYC83LA164Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Towanda, PADuring arrival on a dual instructional flt, the UNICOM advised that there was an ultralight overhead & was possibly landing. As the student was landing, an additional UNICOM advisory was received concerning the ultralight acft. The instructor plt (CFI) stated…NTSB LAX83LA074Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Dixon, CAReportedly, the acft was on an air taxi cargo flt, operated by air express, hayward, CA. The acft reportedly departed reno, NV without a flt plan for a flt to sacramento & hayward, cal. While en route, the acft had an electrical failure. The plt stated that…NTSB MIA81FA083Accident · 1 fatalClosedAero Comdr 500 · Flagler Beach, FLNTSB LAX80FVM03Incident · No injuriesClosedAero Comdr 500 · San Francisco, CANTSB MIA80DA002Accident · 1 fatalClosedAero Comdr 500 · Missing AircraftNTSB MIA79DA104Accident · No injuriesClosedAero Comdr 500 · Treasure Cay, Burkina FasoNTSB ANC79DA049Accident · No injuriesClosedRockwell IN 500 · Emmonguk, AKNTSB FTW78FA085Accident · 7 fatalClosedAero Comdr 500 · Laredo, TXNTSB MIA78FA059Accident · No injuriesClosedAero Comdr 500 · Miami, FLNTSB MIA77FKT34Accident · No injuriesClosedAero Comdr 500 · Miami, FLNTSB CHI76FEM55Accident · No injuriesClosedAero Comdr 500 · Hastings, MINTSB LAX76AL074Accident · 1 fatalClosedAero Comdr 500 · Fontana, CANTSB OAK76DVD23Accident · Serious injuriesClosedAero Comdr 500 · Oakland, CANTSB NYC76AN016Accident · Minor injuriesClosedAero Comdr 500 · Baxter St Pk, MENTSB NYC75DHA08Accident · No injuriesClosedAero Comdr 500 · Berwick, PANTSB LAX74FUM21Accident · No injuriesClosedAero Comdr 500 · San Diego, CANTSB FTW73DRG28Accident · No injuriesClosedAero Comdr 500 · Fredricksburg, TXNTSB SEA72AS046Accident · 2 fatalClosedAero Comdr 500 · Noxon, MTNTSB MIA72DLD19Accident · No injuriesClosedAero Comdr 500 · Titusville, FLNTSB SEA71AS033Accident · 1 fatalClosedAero Comdr 500 · Carson, WANTSB SEA71FWG29Accident · No injuriesClosedAero Comdr 500 · Spokane, WANTSB CHI68A0061Accident · 1 fatalClosedAero Comdr 500 · Murray, KYNTSB CHI67F0460Accident · No injuriesClosedAero Comdr 500 · Ft Wayne, INNTSB FTW68O0005Accident · Minor injuriesClosedAero Comdr 500 · Ixmequilpan, MexicoNTSB DEN68F0069Accident · No injuriesClosedAero Comdr 500 · Albuquerque, NMNTSB OAK67A0078Accident · Minor injuriesClosedAero Comdr 500 · Kaunakakai, HINTSB MIA67A0113Accident · 1 fatalClosedAero Comdr 500 · Hazlehurst, MSNTSB MIA67F0326Accident · No injuriesClosedAero Comdr 500 · Vicksburg, MSNTSB LAX67F0094Accident · No injuriesClosedAero Cmdr 500 · Van Nuys, CANTSB MIA67F0061Accident · No injuriesClosedAero Comdr 500 · Ft Lauderdale, FLNTSB LAX66F0276Accident · No injuriesClosedAero Comdr 500 · Palm Sprngs, CANTSB NYC65F0197Accident · No injuriesClosedAero Cmdr 500 · Block Island, RINTSB UNK64X3338Accident · No injuriesClosedAero Comm 500 · Red Bank, NJNTSB UNK64X0460Accident · No injuriesClosedAero Comm 500 · Miami, FLNTSB UNK64X0385Accident · Minor injuriesClosedAero Comm 500 · Nashville, TN
Back to Aero Commander 500