NTSB investigations: Aero Commander 100

8 cases on aircraft the registry lists as Aero Commander 100, where the first occurrence was “Loss of control - in flight”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Aero Commander 100 per year, 1982–2026: 8 cases
1982	1
1985	1
1986	1
1987	1
2000	1
2001	1
2004	1
2007	1

Where

Open the map

Latest cases

Query with SQL

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0140202') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0140202')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0140202')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 NYC07LA175Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Collegeville, PAThe pilot's inadequate recovery from a bounced landing.Jul 25, 2007 · N3900X · Substantial damage NTSB IAD05LA003Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Pittsburgh, PAThe delayed remedial action by the flight instructor.Oct 12, 2004 · N81DC · Substantial damage NTSB CHI02LA030Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Hillman, MNThe inadvertent stall by the pilot. Factors were the tailwind, and the improper decision of the pilot to takeoff with a tailwind.Nov 10, 2001 · N3761X · Substantial damage NTSB LAX00LA128Accident · Serious injuriesLimited investigationFinal reportAero Commander 100 · Buckeye, AZThe pilot's improper judgment and his failure to maintain clearance from the ground. A factor was the pilot's lack of recent experience.Mar 16, 2000 · N3896X · Substantial damage NTSB ATL88LA027Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Moultrie, GAThe plt took off to the north at the private, sod airstrip. He rptd that the acft began to 'drop' shortly after liftoff. He then attempted to arrest the descent by increasing the nose-up pitch angle, and the acft 'began to stall'. He aborted the takeoff and…Nov 1, 1987 · N3798X · Substantial damage 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…Apr 27, 1986 · N3789X · Substantial damage NTSB DEN85LA170Accident · No injuriesLimited investigationFinal reportRockwell Aerocommander 112 · Landers, WYOn June 22, 1985, a Rockwell aerocommander 112 impacted the ground immediately after takeoff. The density alt was 7700 ft. after takeoff the plt realized the acft would not clear a ridgetop. The acft began to descend & was maneuvered to land on level terrain.…Jun 22, 1985 · N37775 · Destroyed NTSB DEN83FTA01Accident · Serious injuriesFinal reportAero Commander 100 · Red Lodge, MTAfter takeoff, the aircraft lost airspeed and started an uninitiated descent. The pilot was unable to power out of it and the aircraft contacted two buildings and a fence before stopping in an open field. The winds were from 200 degrees at 30 KTS, gusting to…Oct 17, 1982 · N5539M · Destroyed