NTSB investigations: Cessna 310A

7 cases on aircraft the registry lists as Cessna 310A. 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

19682026

NTSB investigations: Cessna 310A per year, 1968–2026: 7 cases
1968	1
1970	1
1972	1
1974	1
1975	1
1977	1
1981	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074204')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074204'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074204'))
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 CHI81DEE25Accident · Minor injuriesClosedCessna 172 · Bellevue, IAApr 1, 1981 · N12119 · Substantial damage NTSB MKC78FCJ47Accident · No injuriesClosedCessna 310A · Lincoln, NESep 22, 1977 · N17U · Substantial damage NTSB MKC76FCG28Accident · No injuriesClosedCessna 310A · Whiteman Afb, MOOct 16, 1975 · N12NP · Substantial damage NTSB ANC75FAG59Accident · Serious injuriesClosedCessna 310A · Anchorage, AKDec 7, 1974 · N6340 · Substantial damage NTSB CHI73ACO48Accident · No injuriesClosedCessna 310A · Lafayette, INNov 16, 1972 · N347P · 2 aircraft · Substantial damage NTSB IAD71FHD11Accident · No injuriesClosedCessna 310A · Middletown, DEJul 22, 1970 · N2199C · Substantial damage NTSB NYC69F0132Accident · No injuriesClosedCessna 310 · Pittstown, NJAug 30, 1968 · N2199C · Substantial damage