NTSB investigations: Cessna T210L, 1987
9 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
| 1972 | 4 |
|---|---|
| 1973 | 6 |
| 1974 | 9 |
| 1975 | 14 |
| 1976 | 16 |
| 1977 | 18 |
| 1978 | 15 |
| 1979 | 18 |
| 1980 | 10 |
| 1981 | 8 |
| 1982 | 8 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 11 |
| 1986 | 5 |
| 1987 | 9 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 8 |
| 1991 | 4 |
| 1992 | 10 |
| 1993 | 4 |
| 1994 | 8 |
| 1995 | 6 |
| 1996 | 6 |
| 1997 | 5 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 3 |
| 2008 | 2 |
| 2009 | 6 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 4 |
| 2024 | 3 |
| 2026 | 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 year(c.\"eventDate\") = 1987
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 year(c."eventDate") = 1987
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 LAX88FA052Accident · 4 fatalField investigationFinal reportCessna T210L · Camp Verde, AZNTSB SEA87FA190Accident · 3 fatalField investigationFinal reportCessna T210L · Hailey, IDAfter dark night takeoff, acft was observed to execute an immediate left turn up a canyon into rising terrain. During climb, acft lights were seen to perform maneuver characteristic of stall/spin. Investigation showed acft struck terrain slightly nose low. No…NTSB LAX87FA267Accident · 4 fatalField investigationFinal reportCessna T210L · Marina Del Rey, CAWeather at dept airport was clouds at about 900 ft with tops at 2,400 ft. based on ATC transcripts and the recorded radar flight path, the flt entered the clouds about 1 mile from the end of the runway. Shortly thereafter the flt entered the los angeles tca.…NTSB LAX87LA236Accident · No injuriesLimited investigationFinal reportCessna T210L · Merced, CADuring a cross country flight, the engine lost power and quit aprx 4 miles from the airport. The pilot was unable to reach the runway and made a forced landing aprx 3 miles short of the runway. During the landing roll the aircraft collided with a fence and…NTSB SEA87LA108Accident · No injuriesLimited investigationFinal reportCessna T210L · Dayton, WADuring landing the aircraft floated. The pilot elected to make a go-around but had used up more than one half the runway. Shortly after applying full power the pilot reduced power to idle for landing on a barley field at the departure end of the runway.…NTSB FTW87FA102Accident · Serious injuriesField investigationFinal reportCessna T210L · Lufkin, TXThe pilot reduced power and was descending for a VFR straight-in approach when the engine quit. The pilot had the selector on the left tank with 4 to 5 gallons of fuel remaining in this tank. During the descent the fuel tank outlet line became unported…NTSB LAX87LA111Accident · Serious injuriesLimited investigationFinal reportCessna T210L · El Cajon, CAThe plt indicated that he and his wife were planning to fly together, but at the last minute his wife changed her mind. She exited the acft and departed the area to the rear of the plane. The plt was taxiing from his parking spot when his wife suddenly…NTSB FTW87LA056Accident · No injuriesLimited investigationFinal reportCessna T210L · Borger, TXAccording to the pilot, during flare/touchdown the aircraft was substantially damaged when the right brake jammed causing the aircraft to veer off the rt side of the runway and into a gulley. However witnesses stated that the aircraft came in fast and landed…NTSB DEN87FA061Accident · 4 fatalField investigationFinal reportCessna T210L · Nucla, COThe acft was on an IFR flt to an arpt without an instrument approach procedure. ATC cleared the flt to descend to 12,000 ft, the IFR mea for the area, at 30 NM NE of the arpt. At approx 3 min prior to the mishap, the plt was issued a cruise clearance at…