Aero Commander 100-180

NTSB investigations · 63

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 ('0140208')
  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.

NTSB FTW72AF010Accident · 4 fatalClosedAero Comdr 100 · Georgetown, TXAug 18, 1971 · N3715X · DestroyedNTSB MKC72DCJ09Accident · No injuriesClosedAero Comdr 100 · Atkinson, NEJul 26, 1971 · N4066X · Substantial damageNTSB MKC71DCD92Accident · Minor injuriesClosedAero Comdr 100 · Atlantic, IAJun 28, 1971 · N4055X · Substantial damageNTSB CHI71FCA07Accident · Minor injuriesClosedAero Comdr 100 · Cahokia, ILJun 17, 1971 · N3731X · DestroyedNTSB NYC71FGM40Accident · No injuriesClosedAero Comdr 100 · Connellsville, PAApr 19, 1971 · N5500M · Substantial damageNTSB MKC71FDM35Accident · Minor injuriesClosedAero Comdr 100 · Lake Elmo, MNDec 6, 1970 · N4050X · DestroyedNTSB LAX71FUA10Accident · No injuriesClosedAero Cmdr 100 · Avalon, CAAug 29, 1970 · N4013X · Substantial damageNTSB LAX71DUJ17Accident · Minor injuriesClosedAero Comdr 100 · Flagstaff, AZAug 19, 1970 · N3736X · Substantial damageNTSB FTW71DPD12Accident · No injuriesClosedAero Comdr 100 · Anson, TXJul 24, 1970 · N3703X · Substantial damageNTSB CHI70DGJ16Accident · No injuriesClosedAero Comdr 100 · Albany, KYJun 20, 1970 · N4010X · Substantial damageNTSB NYC69F0470Accident · Minor injuriesClosedAero Comdr 100 · Fall River, MAJun 1, 1969 · N3752X · DestroyedNTSB ANC69A0048Accident · No injuriesClosedCessna 180 · Bethel, AKApr 25, 1969 · N3733X · Substantial damageNTSB DIA69D0125Accident · No injuriesClosedAero Comdr 100 · White Marsh, MDNov 29, 1968 · N3742X · Substantial damage
Back to Aero Commander 100-180