NTSB investigations: Cessna 310, AZ

9 cases on aircraft the registry lists as Cessna 310. 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: Cessna 310, AZ per year, 1964–2026: 9 cases
1964	1
1967	2
1971	1
1972	1
1975	1
1979	1
1980	1
1984	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."eventStateOrRegion" = 'AZ' 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 ('2074202')) 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\" = 'AZ' 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 ('2074202'))
  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" = 'AZ' 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 ('2074202'))
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 LAX84LA185Accident · No injuriesLimited investigationFinal reportCessna 310 · Tucson, AZThe acft was for sale & the plt, who represented himself as being qualified to fly it, was performing a pre-purchase flt. He reported that he initially felt uncomfortable flying this acft although he had prevously owned a Cessna 310. He was unfamiliar with…Feb 20, 1984 · N667R · Substantial damage NTSB LAX80FUJ68Accident · 1 fatalClosedCessna 310 · Chandler, AZJun 15, 1980 · N37670 · Destroyed NTSB LAX79FUK02Accident · No injuriesClosedCessna 310 · Prescott, AZAug 11, 1979 · N3676D · Substantial damage NTSB LAX76AUJ49Accident · Serious injuriesClosedCessna 310A · Glendale, AZDec 15, 1975 · N222EH · Destroyed NTSB LAX72FUJ68Accident · No injuriesClosedCessna 310 · Phoenix, AZFeb 13, 1972 · N111R · Substantial damage NTSB LAX72DUJ41Accident · Minor injuriesClosedCessna 310 · Marana, AZSep 5, 1971 · N5262A · Destroyed NTSB LAX68D0111Accident · No injuriesClosedCessna 310 · Window Rock, AZJul 28, 1967 · N530 · Substantial damage NTSB LAX67D0347Accident · No injuriesClosedCessna 310 · Window Rock, AZMar 14, 1967 · N530 · Substantial damage NTSB UNK65X0888Accident · No injuriesClosedCessna 310B · Tucson, AZNov 29, 1964 · N5232A · Substantial damage