NTSB investigations: Cessna T210L, FL
6 cases on aircraft the registry lists as Cessna T210L. 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
| 1976 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 2011 | 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 ('2073449'))
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 ('2073449'))
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 ERA12IA114Incident · No injuriesIncident investigationFinal reportCessna T210L · Clewiston, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel starvation.NTSB MIA92LA133Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Panama City, FLThe pilot in command's failure to enrich the mixture control during descent, resulting in loss of engine power, and his improper engine restart procedure which resulted in his being unable to get the engine started prior to an off airport landing.NTSB MIA89GA082Accident · Minor injuriesFinal reportCessna T210L · Melbourne, FLFailure of the pilot to accurately determine fuel quantity prior to departure followed by his failure to operate the engine on the fullest fuel tank resulting in a fuel tank being run dry resulting in engine failure while on short final approach at his…NTSB MIA87LA042Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Miami, FLThe eng lost power while the acft was in cruise flt at 6000' over the atlantic ocean, aprx 6 hrs & 32 min after takeoff. Subsequently, the acft was ditched in the ocean when the eng could not be restarted. The acft then sank & was not recovered. Calculations…NTSB MIA86LA051Accident · No injuriesLimited investigationFinal reportCessna T210L · Madison, FLThe pilot stated that he had started the flight at about 1000 EST from miami, FL and had planned on landing at Madison county airport. As he flew overhead he noted an airstrip with county vehicles parked nearby. He landed and was informed that it was local…NTSB CHI76FLD43Accident · No injuriesClosedCessna T210L · Lakeland, FL