Fatal NTSB investigations: Aero Commander 1121

8 cases on aircraft the registry lists as Aero Commander 1121. 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

19662026

Fatal NTSB investigations: Aero Commander 1121 per year, 1966–2026: 8 cases
1966	1
1968	2
1969	1
1970	1
1971	1
1980	1
1995	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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0142002')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0142002'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0142002'))
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 MIA96WA046Accident · 2 fatalForeign investigationAero Commander 1121 · Guatemala City, GuatemalaDec 14, 1995 · N503U · Destroyed NTSB FTW81FA018Accident · 3 fatalClosedAero Cmdr 1121 · Many, LADec 19, 1980 · N29LB · Destroyed NTSB NYC71AN085Accident · 5 fatalClosedAero Comdr 1121A · South Burlington, VTJan 27, 1971 · N400CP · Destroyed NTSB CHI71A0033Accident · 2 fatalClosedAero Comdr 1121 · Lexington, KYNov 14, 1970 · N100RC · Destroyed NTSB IAD70A0028Accident · 3 fatalClosedAero Comdr 1121 · Rural Retreat, VAOct 31, 1969 · N236JP · Destroyed NTSB LAX69A0014Accident · 2 fatalClosedAero Comdr 1121A · N Hollywood, CASep 13, 1968 · N148E · Destroyed NTSB FTW69A0001Accident · 1 fatalClosedAero Comdr 1121 · Fayetteville, ARJul 1, 1968 · N196KC · Destroyed NTSB MKC67A0022Accident · 5 fatalClosedAero Comdr 1121 · Nplatte, SDSep 26, 1966 · N500JR · Destroyed