NTSB investigations: Continental C85 series, 1982, KS
3 cases on aircraft whose registry engine model is Continental C85 series. 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
| 1964 | 5 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 3 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1982 | 3 |
| 1984 | 2 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2006 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2014 | 1 |
| 2019 | 1 |
| 2020 | 1 |
Where
Latest 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.\"eventStateOrRegion\" = 'KS' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17008'))
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."eventStateOrRegion" = 'KS' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17008'))
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 MKC82DA105Accident · No injuriesFinal reportCessna 120 · Gardner, KSDuring takeoff, the aircraft struck a fence near the departure end of the runway. After hitting the fence, it traveled about 37 yards before nosing over in an adjacent wheat field. The field was soft due to recent rains. The pilot said the 1300 ft runway was…NTSB MKC82DA090Accident · No injuriesFinal reportLuscombe 8E · Goodland, KSWhile en route, the pilot encountered headwinds and elected to land at Goodland, Kansas to refuel. He landed on runway 12 with a crosswind from 320 degrees at 6 knots. The pilot stated that after touchdown, he got a cramp in his right leg and removed his…NTSB MKC82FCG17Accident · 1 fatalFinal reportErcoupe 415-C · Topeka, KSThe aircraft crashed and burned during takeoff at 1303 CST. The pilot received second degree burns over 20 per cent of his body and expired on 3/9/82. Two sailplanes were damaged by impact and fire, and a third sailplane received fire damage. The pilot…