NTSB investigations: Aero Commander 520, 1965

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

19642026

NTSB investigations: Aero Commander 520, 1965 per year, 1964–2026: 69 cases
1964	9
1965	9
1966	5
1967	8
1968	4
1969	5
1970	3
1971	3
1972	3
1973	4
1974	3
1976	1
1977	1
1979	2
1981	2
1982	1
1983	1
1984	2
1986	1
1987	1
2002	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 year(c."eventDate") = 1965 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0141202')) 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 year(c.\"eventDate\") = 1965
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0141202'))
  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 year(c."eventDate") = 1965
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0141202'))
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 FTW66F0565Accident · Serious injuriesClosedAero CDR 520 · Abernathy, TXDec 27, 1965 · N33L · Destroyed NTSB FTW66F0458Accident · No injuriesClosedAero Cmdr 520 · Cleo Springs, OKDec 6, 1965 · N7834 · Substantial damage NTSB FTW66F0422Accident · No injuriesClosedAero Cmdr 520 · Oklahoma City, OKNov 17, 1965 · N264RW · Substantial damage NTSB MKC66F0332Accident · No injuriesClosedAero Cmdr 520 · Minneapolis, MNNov 8, 1965 · N5574V · Substantial damage NTSB FTW66F0354Accident · No injuriesClosedAero Cmdr 520 · Midland, TXOct 16, 1965 · N4183B · Substantial damage NTSB MKC66F0216Accident · No injuriesClosedAero Cmdr 520 · Warrensburg, MOAug 27, 1965 · N2604B · Substantial damage NTSB OAK66F0035Accident · No injuriesClosedAero Cmdr 520 · Modesto, CAJul 16, 1965 · N4130B · Substantial damage NTSB ANC65A0056Accident · 3 fatalClosedAero Comdr 520 · Annette Is., AKJun 19, 1965 · N487 · Destroyed NTSB MIA65D0003Accident · No injuriesClosedAero Cmdr 520 · Fayetteville, GAFeb 28, 1965 · N9093R · Substantial damage