NTSB investigations: Cessna 310, TX
19 cases on aircraft the registry lists as Cessna 310. 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 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 3 |
| 1967 | 1 |
| 1970 | 1 |
| 1971 | 3 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1988 | 1 |
| 2001 | 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 ('2074202'))
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 ('2074202'))
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 FTW01LA118Accident · No injuriesLimited investigationFinal reportCessna 310 · Decatur, TXthe flight instructor's failure to maintain directional control during the landing roll. A contributing factor was the left main wheel brake which was locked for an undetermined reason.NTSB FTW88FA051Accident · 1 fatalField investigationFinal reportCessna 310 · Conroe, TXThe newly certificated private pilot, who had 55.2 hours total flight experience, was on his initial solo flight in the Cessna 310 model. His flight logbook had been endorsed for solo flight in the aircraft on November 20, 1987. Witnesses observed a rather…NTSB FTW79FRG39Accident · Minor injuriesClosedCessna 310 · San Antonio, TXNTSB FTW79FPA06Accident · No injuriesClosedCessna 310 · Sherman, TXNTSB FTW78FA015Accident · 3 fatalClosedCessna 310 · Wharton, TXNTSB FTW77FA018Accident · 2 fatalClosedCessna 310 · Bronte, TXNTSB FTW76FQG85Accident · No injuriesClosedCessna 310 · Friona, TXNTSB FTW76DRJ05Accident · No injuriesClosedCessna 310 · Longview, TXNTSB FTW74FRA36Accident · No injuriesClosedCessna 310 · Beaumont, TXNTSB FTW72AF036Accident · 1 fatalClosedCessna 310 · San Antonio, TXNTSB FTW71FPD55Accident · No injuriesClosedCessna 310 · Albany, TXNTSB FTW71DQG59Accident · No injuriesClosedCessna 310 · Slaton, TXNTSB FTW71AF012Accident · 3 fatalClosedCessna 310 · Aledo, TXNTSB FTW68D0228Accident · No injuriesClosedCessna 310 · Greenville, TXNTSB FTW67D0158Accident · No injuriesClosedCessna 310 · Addison, TXNTSB FTW66F0534Accident · No injuriesClosedCessna 310 · Mineral Wells, TXNTSB FTW66F0516Accident · No injuriesClosedCessna 310 · Dallas, TXNTSB FTW65F0008Accident · No injuriesClosedCessna 310 · Fort Worth, TXNTSB UNK65X0719Accident · No injuriesClosedCessna 310 · Waco, TX