NTSB investigations: Continental I0-470 series, 1967, IL
12 cases on aircraft whose registry engine model is Continental I0-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 | 6 |
|---|---|
| 1965 | 5 |
| 1966 | 7 |
| 1967 | 12 |
| 1968 | 3 |
| 1969 | 3 |
| 1970 | 4 |
| 1971 | 3 |
| 1972 | 4 |
| 1973 | 4 |
| 1974 | 2 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 6 |
| 1979 | 3 |
| 1980 | 4 |
| 1981 | 2 |
| 1982 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 5 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2011 | 1 |
| 2014 | 2 |
| 2021 | 1 |
| 2023 | 1 |
| 2026 | 2 |
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\") = 1967
AND c.\"eventStateOrRegion\" = 'IL' 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 ('17027'))
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") = 1967
AND c."eventStateOrRegion" = 'IL' 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 ('17027'))
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 CHI68F0458Accident · No injuriesClosedBeech P35 · Marion, ILNTSB CHI68D0434Accident · No injuriesClosedCessna 310 · Sugar Grove, ILNTSB CHI68F0369Accident · Minor injuriesClosedCessna 310H · Streator, ILNTSB CHI68F0319Accident · No injuriesClosedCessna 310C · Waukegan, ILNTSB CHI68D0246Accident · No injuriesClosedBeech J35 · Chicago, ILNTSB CHI68D0008Accident · No injuriesClosedBeech B35 · Mattoon, ILNTSB CHI67D0634Accident · No injuriesClosedCessna 185 · Sycamore, ILNTSB CHI67F0562Accident · No injuriesClosedCessna 310H · Streator, ILNTSB CHI67D0574Accident · No injuriesClosedBeech J35 · Polo, ILNTSB CHI67F0462Accident · No injuriesClosedBeech M35 · East Alton, ILNTSB CHI67D0456Accident · No injuriesClosedBeech 35-C33 · East Moline, ILNTSB CHI67F0449Accident · No injuriesClosedCessna 310 · Springfield, IL