Aero Commander 200D
NTSB investigations · 41
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 ('0140312')
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 ('0140312')
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 WPR24FA290Accident · 1 fatalClass 3 · FieldFinal reportAero Commander 200D · Novato, CAThe pilot’s failure to abort takeoff or compensate for gusty crosswind conditions during takeoff, which resulted in a loss of control and subsequent runway excursion.NTSB CEN19FA279Accident · 2 fatalClass 3 · FieldFinal reportAero Commander 200 · Howell, MIThe improper installation of the engine’s metal intake screen, which allowed the filter element to become displaced and subsequently lodge in the intake, blocking intake air and causing the total loss of engine power, at low altitude and low airspeed…NTSB ERA17LA212Accident · Minor injuriesLimited investigationFinal reportAero Commander 200D · Panama City, FLThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to use the emergency checklist to restart the engine.NTSB CEN14LA263Accident · No injuriesLimited investigationFinal reportAero Commander 200D · La Grange, TXThe loss of engine power due to oil starvation for reasons that could not be determined based on the available evidence.NTSB CHI08CA225Accident · Serious injuriesData collectionFinal reportAero Commander 200D · Tecumseh, MIThe pilot flaring too high, and his inadvertent pilot-induced oscillation during the landing flare/touchdown. Contributing to the accident was the collapse of the nose landing gear.NTSB SEA05FA037Accident · 2 fatalField investigationFinal reportAero Commander AC200D (Meyers) · Hatch, UTThe pilot's failure to maintain aircraft control while maneuvering. Inadequate airspeed, the pilot's diverted attention, and low altitude flight were factors.NTSB LAX03LA139Accident · 1 fatalLimited investigationFinal reportAero Commander 200D · Corona De Tucso, AZThe pilot's failure to maintain an adequate clearance from obstructions while performing low level passes. The pilot's physical impairment due to a high blood alcohol level was also causal.NTSB FTW02LA032Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Houston, TXthe failure of the left outboard elevator attachment, which resulted in the partial separation of the left elevator and induced an airframe vibration.NTSB DEN99LA056Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Evanston, WYA total loss of engine power for undetermined reasons.NTSB LAX98LA040Accident · No injuriesLimited investigationFinal reportAero Commander 200D · San Carlos, CAThe pilot's failure to verify that there was an adequate supply of fuel in the selected fuel tank prior to takeoff.NTSB FTW97LA224Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Little Rock, ARa loss of engine power due to fuel starvation from a partially blocked fuel line which was the result of improper maintenance by unknown person(s). A factor was the lack of suitable terrain for landing.NTSB SEA96LA085Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Covington, WAfuel starvation, due to the pilot's improper fuel management. The uneven terrain in the forced landing area was a related factor.NTSB LAX95LA070Accident · 1 fatalLimited investigationFinal reportAero Commander 200D · Lancaster, CAfuel starvation due to the pilot's failure to select a tank containing fuel.NTSB LAX88LA090Accident · Serious injuriesLimited investigationFinal reportAero Commander 200D · Chico, CAAt the end of a cross country flt, while in the pattern turning from base to final, the plt stated that the arpt environment was lost. At the same time, the instrument white lights, under the glareshield began to flicker which drowned out the normal…NTSB DEN87LA217Accident · No injuriesLimited investigationFinal reportRockwell 200D · Ogden, UTThe pilot stated that he was on a ferry flight to Ogden, UT and experienced smoke in the cockpit shortly after deprt. The pilot executed a straight in visual approach to runway 34 and before he was able to stop the aircraft a fire erupted. The aircraft was…NTSB SEA85LA157Accident · No injuriesLimited investigationFinal reportMeyers 2000 · Reno, NVA loss of pwr occurred just as the acft was entering the traffic pattern. The acft was landed 650 ft short of the rwy. The reason for the pwr loss could not be determined by an a & p mechanic. The plt did not plan the apch accurately enough to touchdown on…NTSB FTW78FRD57Accident · No injuriesClosedAero Comdr 200D · Patterson, LANTSB DEN78FQG03Accident · Minor injuriesClosedAero Cmdr 200D · Clovis, NMNTSB IAD77FIG18Accident · Serious injuriesClosedAero Cmdr 200D · Sussex, MDNTSB IAD75FIJ15Accident · Serious injuriesClosedAero Comdr 200D · Jonesville, VANTSB MKC74AK061Accident · 2 fatalClosedAero Comdr 200-D · Patterson, MONTSB NYC74FGM10Accident · No injuriesClosedAero Comdr 200D · West Mifflin, PANTSB MKC74FCJ14Accident · No injuriesClosedAero Comdr 200D · Emerald, NENTSB LAX73AL015Accident · 1 fatalClosedAero Comdr 200D · Wittmann, AZNTSB NYC72FHD27Accident · No injuriesClosedAero Comdr 200-D · Vineland, NJNTSB CHI72AC044Accident · No injuriesClosedAero Comdr 200-D · Louisville, KYNTSB FTW72FRD13Accident · Minor injuriesClosedAero Comdr 200D · Kentwood, LANTSB MKC72FTG11Accident · No injuriesClosedAero Comr 200D · Carpio, NDNTSB MIA71FKW54Accident · Minor injuriesClosedAero Comdr 200 · Livingston, TNNTSB CHI70DBJ18Accident · No injuriesClosedAero Comdr 200-D · East Jordan, MINTSB MIA70F0306Accident · Minor injuriesClosedAero Comdr 200-D · Ashburn, GANTSB LAX70D0006Accident · No injuriesClosedAero Comdr 200-D · Scottsdale, AZNTSB MKC70F0003Accident · No injuriesClosedAero Comdr 200-D · Columbus, NENTSB FTW69F0411Accident · No injuriesClosedAero Comdr 200-D · Bogalusa, LANTSB OAK69D0078Accident · No injuriesClosedAero Comdr 200D · Butte Meadows, CANTSB MIA68F0272Accident · Minor injuriesClosedAero Comdr 200-D · Marietta, GANTSB OAK68A0020Accident · No injuriesClosedAero Comdr 200 · Davis, CANTSB FTW68F0064Accident · No injuriesClosedAero Comdr 200D · Baton Rouge, LANTSB CHI67F0168Accident · No injuriesClosedAero Cmdr 200D · Marion, OHNTSB MIA67F0173Accident · No injuriesClosedAero Cmdr 200-D · Albany, GANTSB CHI66A0102Accident · 4 fatalClosedAero Comdr 200D · Chicago, IL
Back to Aero Commander 200D