NTSB investigations: Cessna 310, FL
17 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 | 2 |
|---|---|
| 1965 | 3 |
| 1966 | 3 |
| 1968 | 1 |
| 1969 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 2002 | 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\" = 'FL' 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" = 'FL' 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 MIA03FA005Accident · 1 fatalField investigationFinal reportCessna 310 · Merritt Island, FLThe pilot's decision to take off with a known equipment deficiency, and his failure to maintain airspeed (VMC) following a loss of engine power to one of the airplane's two engines for undetermined reasons, which resulted in descent and an impact with terrain.NTSB MIA91FA058Accident · Serious injuriesField investigationFinal reportCessna 310 · New Smyrna Bch, FLThe pilot-in-command/mechanic reversal of the aileron control cables on the sprocket during installation. This resulted in an in flight loss of control on takeoff, uncontrolled descent, and in flight collision with terrain.NTSB MIA88LA233Accident · No injuriesLimited investigationFinal reportCessna 310 · Homestead, FLWhile on a personal flt during normal cruise both engs quit due to fuel exhaustion. The plt attempted to land the acft on a road, after which it departed the road surface, and collided with trees. The plt did not file an acc report.NTSB MIA79FLD80Accident · No injuriesClosedCessna 310 · Tampa, FLNTSB MIA77FLD04Accident · No injuriesClosedCessna 310 · Sarasota, FLNTSB MIA75FLA46Accident · No injuriesClosedCessna 310 · Pensacola, FLNTSB MIA73FLA24Accident · No injuriesClosedCessna 310 · Jacksonville, FLNTSB MIA70F0197Accident · No injuriesClosedCessna 310 · Ft Lauderdale, FLNTSB MIA69F0021Accident · No injuriesClosedCessna 310 · Daytona Beach, FLNTSB MIA67F0024Accident · No injuriesClosedCessna 310 · Miami, FLNTSB MIA66F0536Accident · No injuriesClosedCessna 310 · Opa Locka, FLNTSB MIA66D0411Accident · No injuriesClosedCessna 310 · Miami, FLNTSB MIA66F0072Accident · 2 fatalClosedCessna 310 · W Palm Beach, FLNTSB MIA66F0010Accident · No injuriesClosedCessna 310 · Sarasota, FLNTSB UNK65X1458Accident · No injuriesClosedCessna Riley · Jacksonville, FLNTSB UNK64X2095Accident · No injuriesClosedCessna 310 · Miami, FLNTSB UNK64X1741Accident · No injuriesClosedCessna 310 · Merritt Is, FL