NTSB investigations: Cessna 310C, FL
11 cases on aircraft the registry lists as Cessna 310C. 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 | 1 |
|---|---|
| 1966 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1984 | 1 |
| 1998 | 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 ('2074210'))
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 ('2074210'))
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 ATL99LA032Accident · No injuriesLimited investigationFinal reportCessna 310C · Ft Myers, FLThe inadequate preflight inspection of the airplane by the pilot and subsequent malfunction of the nose gear strut, and the pilot's failure to follow the landing checklist.NTSB MIA84LA118Accident · Serious injuriesLimited investigationFinal reportCessna 310C · Key West, FLWhile en route, the plt had switched from the main tanks to the aux tanks, then back to the main tanks. About 10 min later, both engs lost power. He was able to restart the right eng, but it lost power again. Subsequently, he ditched the acft at sea. Both…NTSB MIA78FLA11Accident · No injuriesClosedCessna 310C · Jacksonville, FLNTSB MIA76FLD54Accident · No injuriesClosedCessna 310C · Kissimmee, FLNTSB MIA75FLD01Accident · No injuriesClosedCessna 310C · Vero Beach, FLNTSB MIA73FLA23Accident · No injuriesClosedCessna 310C · Jacksonville, FLNTSB MIA73FKT29Accident · No injuriesClosedCessna 310C · Naples, FLNTSB MIA72FKT21Accident · Minor injuriesClosedCessna 310C · Punta Gorda, FLNTSB MIA70F0170Accident · No injuriesClosedCessna 310C · Panama City, FLNTSB MIA66D0466Accident · No injuriesClosedCessna 310C · West Palm Bc, FLNTSB MIA65F0129Accident · No injuriesClosedCessna 310C · Avon Park, FL