NTSB investigations: Cessna 310R, MT
8 cases on aircraft the registry lists as Cessna 310R. 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 |
|---|---|
| 2000 | 2 |
| 2001 | 1 |
| 2006 | 1 |
| 2010 | 1 |
| 2016 | 1 |
| 2020 | 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\" = 'MT' 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 ('2074245'))
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" = 'MT' 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 ('2074245'))
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 WPR20CA183Accident · No injuriesClass 4 · Data collectionFinal reportCessna 310 · Butte, MTThe pilot's failure to maintain clearance from a fence post during final approach which resulted in a damage to the left main landing gear, and its subsequent collapse during landing.NTSB WPR16LA171Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Schafer Meadows, MTA loss of directional control while landing, which resulted in a runway excursion and landing gear collapse for reasons that could not be determined.NTSB WPR10LA476Accident · No injuriesLimited investigationFinal reportCessna 310R · Great Falls, MTThe uncommanded retraction of the right main landing gear during taxi due to the failure of the landing gear extension system to move the right main gear upper side link into the locked position for undetermined reasons.NTSB SEA06CA087Accident · No injuriesData collectionFinal reportCessna 310R · Billings, MTCollapse of the right main landing gear during the landing roll for an undetermined reason.NTSB SEA02LA019Accident · No injuriesLimited investigationFinal reportCessna 310 · Sidney, MTThe pilot's improper abort procedure and inadequate remedial action, leading to a loss of directional control after losing power in one engine during the takeoff roll. Factors include the loss of power from one engine, and a fence around the perimeter of the…NTSB SEA00LA091Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Wolf Point, MTIn flight collision with birds.NTSB SEA00LA040Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Columbia Falls, MTFailure of the pilot-in-command to follow the prescribed instrument approach missed approach procedure.NTSB DEN83LA029Accident · No injuriesLimited investigationFinal reportCessna 310R · Miles City, MTAfter executing a missed approach to rwy 22 the acft began accumulating rime ice. An approach was made to rwy 4. The acft had accumulated about 1/4 in ice, & during the flare the acft shuddered & stalled onto the rwy.