NTSB investigations: Continental O-470 series, 1978, CA
21 cases on aircraft whose registry engine model is Continental O-470 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 | 27 |
|---|---|
| 1965 | 33 |
| 1966 | 27 |
| 1967 | 37 |
| 1968 | 17 |
| 1969 | 23 |
| 1970 | 24 |
| 1971 | 23 |
| 1972 | 16 |
| 1973 | 18 |
| 1974 | 16 |
| 1975 | 22 |
| 1976 | 12 |
| 1977 | 15 |
| 1978 | 21 |
| 1979 | 21 |
| 1980 | 15 |
| 1981 | 10 |
| 1982 | 8 |
| 1983 | 14 |
| 1984 | 14 |
| 1985 | 4 |
| 1986 | 10 |
| 1987 | 9 |
| 1988 | 7 |
| 1989 | 6 |
| 1990 | 14 |
| 1991 | 14 |
| 1992 | 8 |
| 1993 | 5 |
| 1994 | 3 |
| 1995 | 6 |
| 1996 | 7 |
| 1997 | 10 |
| 1998 | 6 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 10 |
| 2003 | 9 |
| 2004 | 6 |
| 2005 | 9 |
| 2006 | 7 |
| 2007 | 7 |
| 2008 | 2 |
| 2009 | 4 |
| 2010 | 7 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 6 |
| 2015 | 4 |
| 2016 | 9 |
| 2017 | 5 |
| 2018 | 6 |
| 2019 | 5 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 3 |
| 2025 | 8 |
| 2026 | 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\") = 1978
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 ('17026'))
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") = 1978
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 ('17026'))
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 LAX79DUQ09Accident · No injuriesClosedCessna 182 · Santa Barbara, CANTSB OAK79DA001Accident · 1 fatalClosedCessna 182 · Monterey, CANTSB LAX78DUG56Accident · No injuriesClosedCessna 182M · El Monte, CANTSB LAX78DUQ43Accident · No injuriesClosedCessna 182 · Burbank, CANTSB OAK78FA044Accident · 1 fatalClosedCessna 182Q · Eureka, CANTSB OAK78DVM36Accident · No injuriesClosedCessna 182 · Salinas, CANTSB LAX78FUG41Accident · No injuriesClosedCessna 182E · Temecula, CANTSB LAX78FUA20Accident · No injuriesClosedCessna 180 · Long Beach, CANTSB LAX78FVA21Accident · No injuriesClosedCessna 182 · Avalon, CANTSB OAK78FAO36Accident · 4 fatalClosedCessna 182A · Red Bluff, CANTSB OAK78DVG55Accident · No injuriesClosedCessna 182 · Fair Oaks, CANTSB LAX78FA058Accident · 1 fatalClosedCessna 182 · San Diego, CANTSB OAK78FA035Accident · 4 fatalClosedCessna 182P · S Lake Tahoe, CANTSB LAX78AA050Accident · 4 fatalClosedCessna 310 · Irvine, CANTSB OAK78DA032Accident · 3 fatalClosedCessna 182Q · Weber Peak, CANTSB LAX78DVM23Accident · Minor injuriesClosedCessna 182C · Simmler, CANTSB OAK78FA025Accident · 1 fatalClosedCessna 182F · Half Moon Bay, CANTSB OAK78FVA27Accident · Serious injuriesClosedCessna 182P · Gustine, CANTSB OAK78FA015Accident · 1 fatalClosedCessna 182 · Turlock, CANTSB OAK78DVG15Accident · No injuriesClosedCessna 180 · Redding, CANTSB LAX78FUM08Accident · No injuriesClosedCessna 182L · Santa Paula, CA