Fatal NTSB investigations: Continental 0-200 series, 1978
24 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 | 4 |
|---|---|
| 1965 | 3 |
| 1966 | 5 |
| 1967 | 3 |
| 1968 | 11 |
| 1969 | 8 |
| 1970 | 7 |
| 1971 | 4 |
| 1972 | 3 |
| 1973 | 6 |
| 1974 | 3 |
| 1975 | 6 |
| 1976 | 4 |
| 1977 | 13 |
| 1978 | 24 |
| 1979 | 10 |
| 1980 | 14 |
| 1981 | 12 |
| 1982 | 10 |
| 1983 | 15 |
| 1984 | 10 |
| 1985 | 9 |
| 1986 | 4 |
| 1987 | 14 |
| 1988 | 14 |
| 1989 | 7 |
| 1990 | 11 |
| 1991 | 6 |
| 1992 | 10 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 5 |
| 1996 | 6 |
| 1997 | 7 |
| 1998 | 5 |
| 1999 | 4 |
| 2000 | 4 |
| 2001 | 13 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 9 |
| 2005 | 11 |
| 2006 | 7 |
| 2007 | 10 |
| 2008 | 4 |
| 2009 | 6 |
| 2010 | 5 |
| 2011 | 6 |
| 2012 | 6 |
| 2013 | 2 |
| 2014 | 5 |
| 2015 | 5 |
| 2016 | 3 |
| 2017 | 5 |
| 2018 | 8 |
| 2019 | 4 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 3 |
| 2023 | 8 |
| 2024 | 4 |
| 2025 | 3 |
| 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.\"highestInjuryLevel\" = 'Fatal'
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") = 1978
AND c."highestInjuryLevel" = 'Fatal'
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 FTW79FA023Accident · 1 fatalClosedCessna 150M · Baytown, TXNTSB IAD79FA021Accident · 1 fatalClosedCessna 150L · Bolivar, TNNTSB IAD79FA015Accident · 1 fatalClosedCessna 172 · Mt Airy, NCNTSB SEA79FA008Accident · 1 fatalClosedCessna 150H · Swan Lake, MTNTSB CHI79FEX02Accident · 1 fatalClosedCassutt LSS · Cloverdale, INNTSB SEA79FA001Accident · 2 fatalClosedCessna 150H · Omak, WANTSB OAK78FA057Accident · 2 fatalClosedPiper PA-28 · Concord, CANTSB NYC78FA089Accident · 2 fatalClosedCessna 150M · Millbury, MANTSB IAD78FA105Accident · 2 fatalClosedCessna 150 · Louisville, KYNTSB MKC78FCQ36Accident · 1 fatalClosedVari-Eze · Liberal, KSNTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILNTSB CHI78FEK24Accident · 1 fatalClosedCessna 150M · Urbana, OHNTSB ANC78FA052Accident · 1 fatalClosedCessna 150M · Cantwell, AKNTSB OAK78FVG59Accident · 1 fatalClosedVarieze · Dorris, CANTSB LAX78FA058Accident · 1 fatalClosedCessna 182 · San Diego, CANTSB MKC78FA049Accident · 1 fatalClosedCessna 150H · St Louis, MONTSB FTW78FA051Accident · 1 fatalClosedCessna 150 · Mckinney, TXNTSB CHI78FA042Accident · 1 fatalClosedCessna 150M · Waukesha, WINTSB MIA78FA086Accident · 1 fatalClosedCessna 150L · Ft.Lauderdale, FLNTSB OAK78FA024Accident · 2 fatalClosedCessna 150M · Carson City, NVNTSB LAX78FA038Accident · 1 fatalClosedCessna 150L · Huntington Bch, CANTSB FTW78FA030Accident · 1 fatalClosedCessna 150M · Denton, TXNTSB DEN78FTE30Accident · 1 fatalClosedCessna 150G · Ft Garland, CONTSB LAX78FUQ10Accident · 1 fatalClosedCessna 150 · Pacoima, CA