Fatal NTSB investigations: Cessna 310G
10 cases on aircraft the registry lists as Cessna 310G. 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1970 | 1 |
| 1973 | 2 |
| 1978 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 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 ('2074218'))
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 ('2074218'))
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 SEA88FA083Accident · 1 fatalField investigationFinal reportCessna 310G · Las Vegas, NVDuring initial climb at 100 ft after takeoff, the pilot announced he had lost an engine. Witnesses observed the aircraft enter a nose high attitude, roll to the right and descend in a vertical nose down attitude until impact with the ground. The aircraft…NTSB ATL86FA058Accident · 4 fatalField investigationFinal reportCessna 310G · Ragland, ALThe acft with sputtering engs was heard circling overhead in low overcast skies. The horizontal tail surfaces separated in-flt and came to rest aprx 450 ft from the main wreckage in mountainous terrain. The student plt had no instrument experience. The acft…NTSB MKC85FA088Accident · 2 fatalField investigationFinal reportCessna 310G · Mena, ARThe acft crashed out of control after an in-flt airframe failure. The plt had entered an area of thunderstorms after being advised that VFR flt was not recommended in that area. The plt was single eng rated and his flt time in this z eng acft was 18 hrs.NTSB NYC84FA073Accident · 4 fatalField investigationFinal reportCessna 310G · Pequannock, NJAn FBO mechanic reported that the plt had requested a jumpstart. The wx was cold (20 deg) & the initial attempted eng start was unsuccessful. After being preheated, both engs were started. Nothing abnormal was noted during taxi, run-up & the takeoff roll.…NTSB MIA78FA039Accident · 1 fatalClosedCessna 310 · St Petersburg, FLNTSB CHI73AC089Accident · 3 fatalClosedCessna 310G · Ann Arbor, MINTSB MIA73AM089Accident · 1 fatalClosedCessna 310G · College Park, GANTSB MIA71AM002Accident · 6 fatalClosedCessna 310G · Missing AircraftNTSB MIA66A0087Accident · 2 fatalClosedCessna 310G · Ft.Payne, ALNTSB MKC65A0047Accident · 2 fatalClosedCessna 310G · Nebraska Cty, NE