NTSB investigations: Continental 0-200 series, 1981, CA
15 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 | 20 |
|---|---|
| 1965 | 24 |
| 1966 | 46 |
| 1967 | 49 |
| 1968 | 50 |
| 1969 | 45 |
| 1970 | 42 |
| 1971 | 38 |
| 1972 | 29 |
| 1973 | 23 |
| 1974 | 34 |
| 1975 | 25 |
| 1976 | 28 |
| 1977 | 27 |
| 1978 | 26 |
| 1979 | 23 |
| 1980 | 16 |
| 1981 | 15 |
| 1982 | 10 |
| 1983 | 11 |
| 1984 | 13 |
| 1985 | 11 |
| 1986 | 12 |
| 1987 | 9 |
| 1988 | 11 |
| 1989 | 8 |
| 1990 | 9 |
| 1991 | 4 |
| 1992 | 6 |
| 1993 | 10 |
| 1994 | 4 |
| 1995 | 8 |
| 1996 | 6 |
| 1997 | 4 |
| 1998 | 5 |
| 1999 | 6 |
| 2000 | 7 |
| 2001 | 11 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 8 |
| 2006 | 4 |
| 2007 | 3 |
| 2008 | 3 |
| 2009 | 3 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 7 |
| 2022 | 6 |
| 2025 | 4 |
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\") = 1981
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 ('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") = 1981
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 ('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 LAX82DVM07Accident · No injuriesClosedCessna 150 · Ipomo, CANTSB LAX82FUA07Accident · No injuriesClosedCessna 150 · Laguna Beach, CANTSB LAX82FA025Accident · 2 fatalClosedCessna 150M · Antioch, CANTSB LAX81FA132Accident · 1 fatalClosedCessna 150 · Hemet, CANTSB LAX81FUA15Accident · Minor injuriesClosedCessna 150L · Fullerton, CANTSB LAX81DVG64Accident · No injuriesClosedAeronca 7CCM · Jackson, CANTSB LAX81FVD33Accident · No injuriesClosedCessna 140 · San Rafael, CANTSB LAX81FVG50Accident · No injuriesClosedCessna 150 · Georgetown, CANTSB LAX81FA099Accident · 3 fatalClosedPiper PA-28 · Sherman Oaks, CANTSB LAX81DUQ19Accident · No injuriesClosedCessna 150 · Inyokern, CANTSB LAX81DVA34Accident · No injuriesClosedCessna 150M · Planada, CANTSB LAX81FUG15Accident · Minor injuriesClosedCessna 150G · Victorville, CANTSB LAX81DUG18Accident · No injuriesClosedCessna 150 · Corona, CANTSB LAX81FVD12Accident · No injuriesClosedCessna 150 · Tracy, CANTSB LAX81DUG12Accident · Minor injuriesClosedVarieze II · Chino, CA