NTSB investigations: Cessna 210G, 1982
2 cases on aircraft the registry lists as Cessna 210G. 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
| 1967 | 3 |
|---|---|
| 1968 | 2 |
| 1969 | 5 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 5 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 2 |
| 1976 | 3 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 3 |
| 1980 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 3 |
| 1998 | 1 |
| 1999 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2011 | 1 |
| 2017 | 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\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073430'))
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") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073430'))
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 SEA82DYK12Accident · No injuriesFinal reportCessna 210 · Rosenburg, ORThe pilot attempted to hand start the aircraft due to a weak battery. The pilot told passenger to hold the brakes and assumed the passenger knew how, because of his many hours of flight time (as a passenger). When the engine started the aircraft began to move…NTSB LAX82FUG08Accident · 2 fatalFinal reportCessna 210G · Etiwanda, CAThe aircraft struck a ridge at an elevation of about 2000 ft MSL. At the impact point, the terrain sloped upward at an angle of about 35 degrees. The aircraft impacted in a near level flight attitude. The weather at the crash site was not determined. However,…