NTSB investigations: Continental E185 series, 1968, CA
14 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\") = 1968
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") = 1968
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 OAK69D0246Accident · No injuriesClosedNavion A · Davis, CANTSB LAX69D0212Accident · No injuriesClosedBeech A35 · Santa Ana, CANTSB LAX69D0197Accident · No injuriesClosedBeech 35 · Palm Springs, CANTSB OAK69D0163Accident · No injuriesClosedBeech 35 · San Jose, CANTSB OAK69D0108Accident · No injuriesClosedBeech 35 · Redding, CANTSB OAK69A0011Accident · 2 fatalClosedBeech N35 · Truckee, CANTSB OAK69F0105Accident · No injuriesClosedBeech A35 · Tah0e Valley, CANTSB OAK69D0019Accident · No injuriesClosedBeech 35 · S.Luis Obispo, CANTSB LAX68F0430Accident · No injuriesClosedBeech A35 · S.J.Capistrno, CANTSB LAX68D0391Accident · No injuriesClosedBeech C35 · Oxnard, CANTSB LAX68F0387Accident · No injuriesClosedBeech C35 · Santa Ana, CANTSB OAK68D0346Accident · No injuriesClosedBeech B35 · Stockton, CANTSB LAX68D0344Accident · No injuriesClosedNavion G · Baker, CANTSB LAX68D0299Accident · No injuriesClosedBeech C35 · Santa Ana, CA