NTSB investigations: Cessna 310J, CA

8 cases on aircraft the registry lists as Cessna 310J. 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 310J, CA per year, 1968–2026: 8 cases
1968	2
1969	2
1972	1
1974	1
1979	1
1986	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" = 'CA' 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 ('2074226')) 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\" = 'CA' 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 ('2074226'))
  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" = 'CA' 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 ('2074226'))
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 LAX86LA294Accident · No injuriesLimited investigationFinal reportCessna 310J · Stockton, CAA C-31OJ went out of ctl on the rwy and collided with a dirt bank. The CFI indicated that they were practicing single eng procedures in the tfc pattern. After td on a single eng apch the CFI gave the left eng back to the student and annc go-around. Init climb…Jul 18, 1986 · N3195L · Substantial damage NTSB LAX80DUG13Accident · No injuriesClosedCessna 310J · Banning, CANov 18, 1979 · N3103L · Substantial damage NTSB LAX74FUQ37Accident · No injuriesClosedCessna 310J · Van Nuys, CAApr 20, 1974 · N3195L · Substantial damage NTSB LAX72FUQ66Accident · Minor injuriesClosedCessna 310J · Van Nuys, CAMar 5, 1972 · N3154L · Destroyed NTSB OAK70D0173Accident · No injuriesClosedCessna 310J · Fulton, CANov 13, 1969 · N3106L · Substantial damage NTSB OAK70D0085Accident · No injuriesClosedCessna 310J · Annapolis, CAAug 1, 1969 · N3106L · Substantial damage NTSB LAX69F0189Accident · No injuriesClosedCessna 310J · Santa Ana, CANov 26, 1968 · N3066L · Substantial damage NTSB LAX69F0029Accident · No injuriesClosedCessna 310J · Long Beach, CAJul 1, 1968 · N3006L · Substantial damage