NTSB investigations: Continental IO-520 series, 1978, CA
16 cases on aircraft whose registry engine model is Continental IO-520 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
| 1965 | 10 |
|---|---|
| 1966 | 8 |
| 1967 | 17 |
| 1968 | 7 |
| 1969 | 8 |
| 1970 | 9 |
| 1971 | 6 |
| 1972 | 9 |
| 1973 | 13 |
| 1974 | 7 |
| 1975 | 11 |
| 1976 | 8 |
| 1977 | 17 |
| 1978 | 16 |
| 1979 | 23 |
| 1980 | 10 |
| 1981 | 7 |
| 1982 | 10 |
| 1983 | 9 |
| 1984 | 12 |
| 1985 | 4 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 8 |
| 1991 | 4 |
| 1992 | 8 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 9 |
| 1996 | 7 |
| 1997 | 7 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 3 |
| 2004 | 7 |
| 2005 | 10 |
| 2006 | 8 |
| 2007 | 6 |
| 2008 | 7 |
| 2009 | 7 |
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 8 |
| 2018 | 3 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 5 |
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 ('17032'))
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 ('17032'))
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 OAK79DVG04Accident · No injuriesClosedCessna T210 · Oroville, CANTSB OAK78DVA56Accident · No injuriesClosedCessna 188 · Turlock, CANTSB OAK78DXQ35Accident · Minor injuriesClosedBeech A36 · Chester, CANTSB OAK78DVA52Accident · No injuriesClosedCessna 188B · Modesto, CANTSB OAK78FVD39Accident · No injuriesClosedCessna T210 · Santa Rosa, CANTSB OAK78FVA46Accident · No injuriesClosedBeech V35 · Fresno, CANTSB OAK78DVA45Accident · No injuriesClosedCessna 188B · Dos Palos, CANTSB OAK78FA030Accident · Serious injuriesClosedCessna 411 · Fresno, CANTSB LAX78FUM21Accident · No injuriesClosedCessna A185F · Ramona, CANTSB OAK78DVD28Accident · No injuriesClosedCessna 185 · Tracy, CANTSB LAX78DUM20Accident · No injuriesClosedCessna 206 · Imperial, CANTSB OAK78DVG24Accident · No injuriesClosedCessna 188 · Locke, CANTSB OAK78FVD21Accident · No injuriesClosedCessna 310R · Oakland, CANTSB OAK78DVA24Accident · No injuriesClosedCessna A188B · Merced, CANTSB LAX78FUQ12Accident · No injuriesClosedDowner 17-30 · Lancaster, CANTSB LAX78FUG11Accident · Minor injuriesClosedCessna 210A · La Verne, CA