Final NTSB investigations: Aero Commander 1121

10 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

Final NTSB investigations: Aero Commander 1121 per year, 1966–2026: 10 cases
1966	2
1968	2
1969	1
1970	1
1971	1
1975	1
1980	1
1987	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."completionStatus" = 'Completed' 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.\"completionStatus\" = 'Completed'
    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."completionStatus" = 'Completed'
  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 MIA87LA207Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1121 · Jackson, MSDuring the ground run at 80 KTS the cabin door unsafe light illuminated. The takeoff was aborted with heavy braking & deployment of the thrust reversers. The door was then opened & reclosed which extinguished the light, & a second takeoff was attempted. Aprx…Jul 16, 1987 · N133ME · Substantial damage NTSB FTW81FA018Accident · 3 fatalClosedAero Cmdr 1121 · Many, LADec 19, 1980 · N29LB · Destroyed NTSB IAD75AI052Accident · Minor injuriesClosedAero Comdr 1121 · Tullahoma, TNMar 13, 1975 · N711JT · Substantial damage 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 NTSB MIA66A0090Accident · No injuriesClosedAero Comdr 1121 · W.Palm Beach, FLFeb 19, 1966 · N95B · Substantial damage