NTSB investigations: Continental E185 series, 1982, CA
3 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 | 5 |
|---|---|
| 1965 | 8 |
| 1966 | 11 |
| 1967 | 10 |
| 1968 | 14 |
| 1969 | 6 |
| 1970 | 5 |
| 1971 | 7 |
| 1972 | 6 |
| 1973 | 4 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 3 |
| 1980 | 2 |
| 1981 | 2 |
| 1982 | 3 |
| 1983 | 2 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 2 |
| 1996 | 1 |
| 1998 | 2 |
| 2002 | 1 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2017 | 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\" = 'CA' 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" = 'CA' 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 LAX83FVD03Accident · Serious injuriesFinal reportBeech B35 · Linden, CAThe aircraft engine lost power during a night cross-country. The pilot was forced to land in a grove of young walnut trees. The aircraft hit with one wing low and spun around. All motion stopped in a very short distance. An examination revealed that both fuel…NTSB LAX83FUM01Accident · 4 fatalFinal reportBeech A35 · Oceanside, CADuring arrival, the aircraft entered downwind for a right traffic pattern to runay 24. At that time, a witness (a well qualified pilot) noted that the wind was from the northeast at about 8 KTS. Another pilot-witness stated that the wind was from the…NTSB LAX82DA091Accident · No injuriesFinal reportBeech B35 · La Jolla, CADuring flight over the water, the engine lost power and the pilot was unable to glide to a safe landing area on shore. The plane was ditched in the pacific ocean about 1/4 mile from the shore.