NTSB investigations: Cessna T210L
8 cases on aircraft the registry lists as Cessna T210L, where the defining event was Landing gear not configured. 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
| 2009 | 2 |
|---|---|
| 2012 | 1 |
| 2015 | 3 |
| 2017 | 2 |
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 ('2073449')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '095'))
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 ('2073449')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '095'))
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 GAA17CA543Accident · No injuriesData collectionFinal reportCessna T210 · St George, UTThe pilot’s failure to extend the landing gear before landing.NTSB GAA17CA423Accident · No injuriesData collectionFinal reportCessna T210L · Yuba City, CAThe pilot’s failure to extend the landing gear before landing.NTSB GAA15CA259Accident · No injuriesData collectionFinal reportCessna T210L · Soda Springs, IDThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing.NTSB GAA15CA206Accident · No injuriesData collectionFinal reportCessna T210L · Duluth, MNThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing. Contributing to the accident was the pilot's diverted attention to another airplane in the vicinity and that he inaccurately…NTSB WPR15CA112Accident · No injuriesData collectionFinal reportCessna T210 - L · The Dalles, ORThe pilot's failure to extend the landing gear prior to touch down. Contributing to the accident was the pilot's failure to utilize the pre-landing checklist.NTSB WPR12CA311Accident · No injuriesData collectionFinal reportCessna T210L · Idaho Falls, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was an uncorrected malfunction of the landing gear warning horn system.NTSB WPR09FA212Accident · No injuriesField investigationFinal reportCessna T210L · Moab, UTThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's self-induced distraction by maneuvering on final to show a point of interest to passengers.NTSB CEN09CA125Accident · No injuriesData collectionFinal reportCessna T210L · Albuquerque, NMThe pilot's failure to remove the airplane's tow bar before takeoff.