NTSB investigations: Continental E185 series, 1982, TX
2 cases on aircraft whose registry engine model is Continental E185 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 | 6 |
|---|---|
| 1965 | 6 |
| 1966 | 4 |
| 1967 | 6 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 4 |
| 1975 | 1 |
| 1976 | 3 |
| 1977 | 3 |
| 1978 | 1 |
| 1979 | 2 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 2 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2005 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2015 | 3 |
| 2021 | 3 |
| 2023 | 1 |
| 2025 | 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 year(c.\"eventDate\") = 1982
AND c.\"eventStateOrRegion\" = 'TX' 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 ('17014'))
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" = 'TX' 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 ('17014'))
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 FTW82DA252Accident · No injuriesFinal reportBeech 35 · Graham, TXWhile descending through about 2800 ft AGL to land, the engine lost power. The pilot was unable to restart the engine and elected to land in an OAT field with oats about 2 to 3 ft high. The pilot reported that during the landing roll, the nose gear collapsed…NTSB FTW82DA218Accident · No injuriesFinal reportBeech 35 · Terrell, TXWhile en route, the cabin door of the aircraft popped open, approximately 10 miles from the destination. The pilot reported that he was distracted by the open door and lost airspeed while on final approach. The aircraft touched down hard just short of the…