Fatal NTSB investigations: Cessna 310P
17 cases on aircraft the registry lists as Cessna 310P. 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.
Cases per year
| 1970 | 4 |
|---|---|
| 1973 | 1 |
| 1974 | 3 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1987 | 1 |
| 1995 | 1 |
| 2009 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('2074238'))
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 ('2074238'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR09FA248Accident · 3 fatalField investigationFinal reportCessna 172N · Long Beach, CAThe failure of both pilots to see and avoid each other's aircraft.NTSB ATL95FA173Accident · 2 fatalField investigationFinal reportCessna 310P · Lexington, MSthe non-instrument rated pilot's intentional VFR flight into instrument meteorological conditions and his failure to maintain control of the aircraft. The weather was a factor.NTSB ATL87FA064Accident · 2 fatalField investigationFinal reportCessna 310P · Memphis, TNThe plt reported an engine problem inside the outer marker to runway 31. The acft impacted the ground in a nose low attitude. The wreckage examination failed to disclose any system malfunction or failure. The acft was destroyed by impact forces, and a post…NTSB ATL81FA008Accident · 4 fatalClosedCessna 310 · Milledgeville, GANTSB IAD79FA036Accident · 1 fatalClosedCessna 310 · Bristol, VANTSB NYC79FA075Accident · 1 fatalClosedCessna 310P · Sussex, NJNTSB NYC78FA062Accident · 1 fatalClosedCessna 310P · Mattituck, NYNTSB CHI78FA008Accident · 1 fatalClosedCessna 310P · Eagle River, WINTSB CHI77FA008Accident · 2 fatalClosedCessna 310P · Muskegon, MINTSB CHI75AC012Accident · 1 fatalClosedCessna 310P · Antwerp, OHNTSB MKC74AK052Accident · 2 fatalClosedCessna 310P · Jefferson City, MONTSB MIA74AM069Accident · 4 fatalClosedCessna 310P · Opa Locka, FLNTSB MIA73AM069Accident · 2 fatalClosedCessna 310P · Memphis, TNNTSB NYC71AN063Accident · 3 fatalClosedCessna 310P · Grove City, PANTSB NYC71AN002Accident · 1 fatalClosedCessna 310P · Missing AircraftNTSB NYC70AN132Accident · 2 fatalClosedCessna 310 · Verona, NJNTSB MIA70AM069Accident · 6 fatalClosedCessna 310P · Philadelphia, MS