NTSB investigations: Cessna T310R
6 cases on aircraft the registry lists as Cessna T310R, where the first occurrence was “In flight encounter with weather”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1998 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074246')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074246')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 DEN06FA065Accident · 1 fatalField investigationFinal reportCessna T310R · Heber City, UTthe pilot's loss of aircraft control due to the loss of engine power due to induction icing. Contributing factors include the in-flight encounter with structural icing, the severe turbulence, and the pilot's increased workload.NTSB CHI06LA036Accident · No injuriesLimited investigationFinal reportCessna T310R · Fergus Falls, MNThe presence of wing ice during landing. Contributing factors were the icing conditions and flight into known adverse weather by the pilot.NTSB LAX05FA045Accident · 1 fatalField investigationFinal reportCessna T310R · Flagstaff, AZThe pilot's decision to attempt flight into known adverse weather conditions beyond the capability of the airplane and his failure to ensure that the airplane's wings were free of ice and/or snow contamination that accumulated while the airplane was on the…NTSB FTW98FA393Accident · 1 fatalField investigationFinal reportCessna T310R · Pie Town, NMThe pilot's continuing VFR flight into instrument meteorological conditions. Contributing factors were weather conditions, that included clouds, and mountainous terrain.NTSB FTW85LA068Accident · No injuriesLimited investigationFinal reportCessna T310R · Lubbock, TXAccording to the plt icing conditions were encountered during the asr apch. Deicing equipment was utilized several times during the apch and worked normally. The acft broke out at 400 ft AGL. Ice accumulation on the wings resulted in an excessive rate of…NTSB CHI83LA061Accident · No injuriesLimited investigationFinal reportCessna 310R · Gaylord, MIPrior to a flight from charleston, WV to sault ste marie, MI, the pilot was briefed to expect icing conditions. During the flight, mixed and rime icing conditions were encountered; however, the deicing equipment removed it satisfactorily. An update weather…