NTSB investigations: Aero Commander S2R, LA

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

19742026

NTSB investigations: Aero Commander S2R, LA per year, 1974–2026: 7 cases
1974	2
1975	1
1979	1
1980	1
1983	2

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."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0143022')) 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.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0143022'))
  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."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0143022'))
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 FTW83LA446Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Napoleonville, LAThe acft dragged a wing in the sugarcane crop during a start of a swath run. According to the operator the plt was looking at a map as he approached the run. After the wing dragged the acft yawed 90 degrees and settled into the crop. The engine and right main…Sep 29, 1983 · N8890Q · Substantial damage NTSB FTW83LA209Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Cheneyville, LAAccording to the operator, the brakes failed during landing causing the acft to ground loop off of the rwy. He also stated that postcrash investigation revealed a broken brake line on the right brake which he suspects was an act of sabotage by an unknown…Apr 19, 1983 · N3644X · Substantial damage NTSB FTW80FRJ22Accident · No injuriesClosedAero-Comdr S-2R · Cheneyville, LAMay 31, 1980 · N5516X · Substantial damage NTSB FTW79FRJ17Accident · Minor injuriesClosedSnow S2R · Jonesville, LAJul 13, 1979 · N4958X · Destroyed NTSB FTW75FRD50Accident · No injuriesClosedSnow 600S2R · Oakdale, LAMay 10, 1975 · N3652X · Substantial damage NTSB FTW74FRD36Accident · No injuriesClosedAero Comdr 600S2R · Rayne, LAMay 12, 1974 · N4072X · Substantial damage NTSB FTW74DRD29Accident · No injuriesClosedAero Cmdr 600S2R · Eunice, LAApr 18, 1974 · N3652X · Substantial damage