Fatal NTSB investigations: Cessna 310L

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

Fatal NTSB investigations: Cessna 310L per year, 1968–2026: 13 cases
1968	1
1969	1
1971	2
1973	1
1974	1
1976	1
1978	1
1983	1
1984	1
1988	1
1995	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 c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074230')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074230'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074230'))
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 NYC02FA197Accident · 1 fatalField investigationFinal reportCessna 310L · Virgil, NYThe pilot's decision to continue the flight into IMC after canceling his IFR clearance, and his failure to maintain terrain clearance while maneuvering. Factors in the accident were rain, low ceilings, and night.Sep 28, 2002 · N2276F · Destroyed NTSB CHI95FA082Accident · 1 fatalField investigationFinal reportCessna 310L · Valparaiso, INspatial disorientation of the pilot while descending into the clouds. Factors were the moderate turbulance and snow.Feb 5, 1995 · N157JW · Destroyed NTSB MIA89FA054Accident · 2 fatalField investigationFinal reportCessna 310L · Cedar Key, FLThe evidence indicated that personnel failed to tighten a fuel line at the fuel pressure switch on left engine resulting in fuel line leaking into the engine compartment in flight. An inflight fire burned through a fuel crossfeed fuel line which could not be…Dec 21, 1988 · N2251F · Destroyed NTSB MKC85FA036Accident · 1 fatalField investigationFinal reportCessna 310L · Kaiser, MOThe acft was observed departing the airport to the south climbing. IFR flt conditions prevailed in the area. The plt rptd VFR at 2000 ft. the acft was noted by passengers of an earlier flight to have malfunctioning autopilot altitude andguidance…Dec 20, 1984 · N3325X · Destroyed NTSB FTW84FA045Accident · 2 fatalField investigationFinal reportCessna 310L · Bartlesville, OKThe acft was observed at 300-500 ft on a downwind leg over the brightly lighted city. After passing the city the acft entered a very dark & hilly area immediately north of the city. He then made a left turn onto base leg & remained over unlighted & hilly…Nov 8, 1983 · N3256X · Destroyed NTSB MKC78FA017Accident · 2 fatalClosedCessna 310L · Garden City, KSJan 1, 1978 · N2254F · Destroyed NTSB OAK77FA005Accident · 2 fatalClosedCessna 310L · Hawthorne, NVNov 17, 1976 · N2208F · Destroyed NTSB CHI75AC008Accident · 3 fatalClosedCessna 310L · Land O' Lakes, WIJul 17, 1974 · N69939 · Destroyed NTSB MKC74AK033Accident · 2 fatalClosedCessna 310L · Manhattan, KSDec 18, 1973 · N3269X · Destroyed NTSB DEN72AD022Accident · 4 fatalClosedCessna 310L · Jackson, WYOct 28, 1971 · N2217F · Destroyed NTSB NYC71AN084Accident · 2 fatalClosedCessna 310L · Mountoursville, PAJan 26, 1971 · N2255F · Destroyed NTSB FTW69A0069Accident · 2 fatalClosedCessna 310L · De Soto, TXApr 8, 1969 · N2278F · Destroyed NTSB FTW69A0023Accident · 2 fatalClosedCessna 310L · Austin, TXOct 8, 1968 · N2219F · Destroyed