NTSB investigations: Cessna 310D, TX
15 cases on aircraft the registry lists as Cessna 310D. 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 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 2 |
| 1969 | 2 |
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 2023 | 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 ('2074212'))
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 ('2074212'))
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 CEN23FA173Accident · 1 fatalClass 3 · FieldFinal reportCessna 310D · Ennis, TXThe partial loss of right engine power due to reduced fuel flow as a result of the contamination of the fuel screen.NTSB FTW96LA064Accident · No injuriesLimited investigationFinal reportCessna 310D · Fort Worth, TXFailure of the left main landing gear strut at the fork weld.NTSB FTW92LA032Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Hamilton, TXThe inadvertend encounter with icing conditions. Factors were the unavailability of an airport weather observation facility and the deteriorated aircraft performance.NTSB FTW79DRG12Accident · No injuriesClosedCessna 310B · Austin, TXNTSB FTW76DPA35Accident · No injuriesClosedCessna 310D · Dallas, TXNTSB FTW75FPD50Accident · Minor injuriesClosedCessna 310 · Possum Kingdom, TXNTSB FTW75FRG39Accident · Minor injuriesClosedCessna 310D · Austin, TXNTSB FTW72FPA21Accident · No injuriesClosedCessna 310D · Addison, TXNTSB FTW69A0088Accident · 1 fatalClosedCessna 310 · Somerset, TXNTSB FTW69D0483Accident · No injuriesClosedCessna 310D · Kerrville, TXNTSB FTW68D0410Accident · Minor injuriesClosedCessna 310D · Midland, TXNTSB FTW68F0391Accident · No injuriesClosedCessna 310D · Addison, TXNTSB FTW67F0228Accident · Minor injuriesClosedCessna 310D · Addison, TXNTSB FTW66F0238Accident · No injuriesClosedCessna 310 · Addison, TXNTSB UNK65X1428Accident · No injuriesClosedCessna 310 · Laporte, TX