NTSB investigations: Continental 0-200 series, 1966, IL
21 cases on aircraft whose registry engine model is Continental 0-200 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 | 3 |
|---|---|
| 1965 | 7 |
| 1966 | 21 |
| 1967 | 16 |
| 1968 | 12 |
| 1969 | 15 |
| 1970 | 7 |
| 1971 | 11 |
| 1972 | 4 |
| 1973 | 8 |
| 1974 | 8 |
| 1975 | 7 |
| 1976 | 10 |
| 1977 | 13 |
| 1978 | 19 |
| 1979 | 5 |
| 1980 | 4 |
| 1981 | 2 |
| 1982 | 5 |
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 4 |
| 1987 | 5 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 3 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 2 |
| 2010 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2025 | 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\") = 1966
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 ('17020'))
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") = 1966
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 ('17020'))
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 CHI67F0431Accident · No injuriesClosedCessna 150D · Deerfield, ILNTSB CHI67D0298Accident · No injuriesClosedCessna 150G · Rockford, ILNTSB CHI67F0334Accident · No injuriesClosedCessna 150 · Northbrook, ILNTSB CHI67D0220Accident · No injuriesClosedCessna 150 · Joliet, ILNTSB CHI67D0229Accident · No injuriesClosedCessna 150 · Northbrook, ILNTSB CHI67D0346Accident · No injuriesClosedCessna 150 · Chicago, ILNTSB CHI67D0124Accident · No injuriesClosedCessna 150 · Rockford, ILNTSB CHI67F0161Accident · No injuriesClosedCessna 150 · Kankakee, ILNTSB CHI67F0099Accident · No injuriesClosedCessna 150 · East St.Louis, ILNTSB CHI67F0042Accident · No injuriesClosedCessna 150F · E St Louis, ILNTSB CHI66D0771Accident · No injuriesClosedCessna 150 · East St.Louis, ILNTSB CHI66F0719Accident · No injuriesClosedCessna 150F · Rockford, ILNTSB CHI66F0708Accident · No injuriesClosedCessna 150 · Rockford, ILNTSB CHI66F0675Accident · No injuriesClosedCessna 150 · Northbrook, ILNTSB CHI66D0626Accident · No injuriesClosedCessna 150 · E St Louis, ILNTSB CHI66F0589Accident · No injuriesClosedCessna 150 · Winnebago, ILNTSB CHI66F0606Accident · Minor injuriesClosedCessna 150B · Millstadt, ILNTSB CHI66F0582Accident · No injuriesClosedCessna 150E · E St Louis, ILNTSB CHI66F0558Accident · No injuriesClosedCessna 150 · Lombard, ILNTSB CHI66F0622Accident · No injuriesClosedCessna 150 · Jacksonville, ILNTSB CHI66F0527Accident · No injuriesClosedCessna 150 · E Alton, IL