NTSB investigations: Cessna 310Q, 1983
5 cases on aircraft the registry lists as Cessna 310Q. 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 | 1 |
|---|---|
| 1972 | 3 |
| 1973 | 5 |
| 1974 | 7 |
| 1975 | 5 |
| 1976 | 5 |
| 1977 | 9 |
| 1978 | 9 |
| 1979 | 4 |
| 1980 | 6 |
| 1981 | 3 |
| 1982 | 6 |
| 1983 | 5 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 4 |
| 1990 | 2 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 4 |
| 1996 | 1 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 2 |
| 2004 | 1 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 1 |
| 2008 | 3 |
| 2011 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 2 |
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 year(c.\"eventDate\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074242'))
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 year(c."eventDate") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074242'))
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 FTW84LA053Accident · No injuriesLimited investigationFinal reportCessna 310Q · Amarillo, TXThe plt was starting a flt to reposition the acft from the tradewind arpt to the Amarillo intl arpt. He reported that he had started to takeoff on rwy 17, then aborted to avoid a Cessna 182. He reported the Cessna 182 plt was crossing rwy 17, on his way to…NTSB NYC83FA207Accident · 1 fatalField investigationFinal reportCessna 310Q · Scranton, PAShortly after takeoff the acft ws observed on radar making a left 360 deg turn. The plt did not respond to a call from the controller. A witness heard the plane 'sputtering' & observed it in erratic maneuvers prior to it hitting a house. Post exam revealed…NTSB SEA83LA174Accident · No injuriesLimited investigationFinal reportCessna 310Q · Spokane, WAWhile landing with a slight left x-wind, the plt purposely touched down on the left main gear first. Momentarily after touching down on the other main wheel, the right gear collapsed. At first, the plt thought the right tire had blown out & corrective action…NTSB ATL83LA288Accident · No injuriesLimited investigationFinal reportCessna 310Q · Fredricksburg, VAThe acft crashed and burned during a go-around after touching down on the rwy at about the 1500 ft point on a 3000 ft rwy. The right propeller was feathered. The pilot was attempting a single engine practice landing and believed he could not stop on the rwy…NTSB NYC83FA054Accident · 4 fatalField investigationFinal reportCessna 310R · Atlantic City, NJThe flt proceeded routinely from chicago to Atlantic City. Communications and procedures all seemed routine and normal and at 1901 local control at Atlantic City informed the pilot that he was one mile out and should be picking up the 'rabbit' momentarily. At…