NTSB investigations: Cessna 310J, TX
12 cases on aircraft the registry lists as Cessna 310J. 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 |
|---|---|
| 1967 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1980 | 2 |
| 1997 | 1 |
| 2005 | 1 |
| 2009 | 1 |
| 2014 | 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074226'))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074226'))
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 CEN15LA089Accident · No injuriesLimited investigationFinal reportCessna 310J · San Antonio, TXThe retraction of the left main landing gear after landing for reasons that could not be determined during postaccident examinations.NTSB CEN09CA457Accident · No injuriesData collectionFinal reportCessna 310 · Fort Worth, TXThe failure of the pivot pin in the side brace of the right main landing gear resulting in the gear collapse during taxi for undetermined reasons.NTSB DFW05CA062Accident · No injuriesData collectionFinal reportCessna 310-J · Crosbyton, TXThe pilot's failure to maintain aircraft control, and his inadequate flare which resulted in a hard landing. A contributing factor was the pilot's diverted attention to the open cabin door.NTSB FTW98TA052Accident · Serious injuriesFinal reportCessna 310J · Beaumont, TXThe pilot's failure to maintain control for undetermined reasons. A factor may have been an encounter with wake turbulence.NTSB FTW80FRA46Accident · No injuriesClosedCessna 310J · Houston, TXNTSB FTW80DQG08Accident · No injuriesClosedCessna 310J · Panhandle, TXNTSB FTW79FA012Accident · 2 fatalClosedCessna 310J · Lubbock, TXNTSB FTW76FQG52Accident · No injuriesClosedCessna 310J · Lubbock, TXNTSB FTW73FPD11Accident · No injuriesClosedCessna 310J · Wichita Falls, TXNTSB FTW71FPD34Accident · No injuriesClosedCessna 310J · Saginaw, TXNTSB FTW68D0251Accident · No injuriesClosedCessna 310J · San Angelo, TXNTSB FTW66F0048Accident · No injuriesClosedCessna 310J · Houston, TX