NTSB investigations: Cessna 310C, 1982
4 cases on aircraft the registry lists as Cessna 310C. 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
| 1964 | 8 |
|---|---|
| 1965 | 12 |
| 1966 | 7 |
| 1967 | 13 |
| 1968 | 7 |
| 1969 | 6 |
| 1970 | 4 |
| 1971 | 4 |
| 1972 | 6 |
| 1973 | 7 |
| 1974 | 6 |
| 1975 | 3 |
| 1976 | 6 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 4 |
| 1981 | 2 |
| 1982 | 4 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1998 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2015 | 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 year(c.\"eventDate\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074210'))
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") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074210'))
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 FTW83LA021Accident · Minor injuriesLimited investigationFinal reportCessna 310C · Bastrop, LAThe pilot was preparing for an enroute landing when he got an unsafe gear light. While trouble-shooting, the left engine stopped. He feathered the left engine and almost immediately the right engine quit. The pilot failed to reach therunway during the power…NTSB ATL82DA250Accident · No injuriesFinal reportCessna 310C · Brunswick, GAThe pilot experienced an electrical failure inflight after takeoff. He hand-cranked the landing gear to the down and locked position prior to landing. After rolling approximately 200 feet, he left main gear collapsed. Examination of the landing gear revealed…NTSB NYC82DA182Accident · No injuriesFinal reportCessna 310C · Schroon Lake, NYThe brakes failed during landing roll and the aircraft went off the end of the runway damaging the prop and nose gear. The left brake was found inoperative and the right brake had excessively worn pucks.NTSB ATL82DA132Accident · No injuriesFinal reportCessna 310 · Allendale, SCThe pilot reported that before landing, the landing gear indicators showed that all gear were down and locked. However, on the landing roll-out, the left main gear collapsed as the nosewheel was lowered to the runway. Subsequently, the left wing, left…