Fatal NTSB investigations: Continental IO-520 series, 1979
30 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
| 1964 | 1 |
|---|---|
| 1966 | 3 |
| 1967 | 1 |
| 1968 | 4 |
| 1969 | 4 |
| 1970 | 2 |
| 1972 | 5 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 3 |
| 1976 | 9 |
| 1977 | 6 |
| 1978 | 17 |
| 1979 | 30 |
| 1980 | 15 |
| 1981 | 15 |
| 1982 | 22 |
| 1983 | 21 |
| 1984 | 13 |
| 1985 | 7 |
| 1986 | 13 |
| 1987 | 5 |
| 1988 | 18 |
| 1989 | 9 |
| 1990 | 9 |
| 1991 | 11 |
| 1992 | 9 |
| 1993 | 9 |
| 1994 | 6 |
| 1995 | 12 |
| 1996 | 11 |
| 1997 | 9 |
| 1998 | 12 |
| 1999 | 13 |
| 2000 | 8 |
| 2001 | 19 |
| 2002 | 17 |
| 2003 | 20 |
| 2004 | 21 |
| 2005 | 26 |
| 2006 | 16 |
| 2007 | 18 |
| 2008 | 15 |
| 2009 | 10 |
| 2010 | 14 |
| 2011 | 22 |
| 2012 | 9 |
| 2013 | 6 |
| 2014 | 14 |
| 2015 | 11 |
| 2016 | 8 |
| 2017 | 6 |
| 2018 | 10 |
| 2019 | 16 |
| 2020 | 13 |
| 2021 | 10 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 7 |
| 2025 | 6 |
| 2026 | 8 |
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\") = 1979
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 ('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") = 1979
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 ('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 SEA80FA011Accident · 2 fatalClosedBeech V35A · Sublett, IDNTSB CHI80FA012Accident · 3 fatalClosedCessna 210L · Fort Wayne, INNTSB FTW80FA008Accident · 1 fatalClosedBeech C55 · Fordyce, ARNTSB DEN81FA066Accident · 4 fatalClosedBeech C33 · Dubois, WYNTSB LAX80FA006Accident · 2 fatalClosedBeech V35B · Lucerne Valley, CANTSB MIA80FA001Accident · 2 fatalClosedCessna 210 · Osteen, FLNTSB NYC79FA105Accident · 3 fatalClosedBeech 35C33A · Warren, VTNTSB LAX79IA082Incident · 1 fatalClosedCessna 210 · Tucson, AZNTSB DEN79FA061Accident · 2 fatalClosedBeech A-36 · Garfield, CONTSB NYC79FA092Accident · 1 fatalClosedBellanca 17-30A · Hanover, PANTSB ANC79FA076Accident · 1 fatalClosedCessna 207A · Nikishki, AKNTSB DCA79AA020Accident · 8 fatalClosedDehavilland DH-114 · St Croix, VINTSB FTW79FA097Accident · 1 fatalClosedCessna A185F · Lafayette, LANTSB FTW79FA089Accident · 2 fatalClosedBeech V35B · Pampa, TXNTSB OAK79FA032Accident · 3 fatalClosedBeech F33A · Orleans, CANTSB FTW79FRG36Accident · 1 fatalClosedCessna A188B · Falfurrias, TXNTSB LAX79FA052Accident · 2 fatalClosedCessna 320E · Tucson, AZNTSB FTW79FA076Accident · 3 fatalClosedCessna 320E · Covington, LANTSB ANC797A014Accident · 2 fatalClosedCessna U206 · Nightmute, AKNTSB LAX79FA046Accident · 2 fatalClosedCessna 310R · Heber, AZNTSB DEN79FA023Accident · 4 fatalClosedCessna 206 · Moose, WYNTSB FTW79FA052Accident · 1 fatalClosedCessna 210G · Jennings, LANTSB OAK79FA016Accident · 2 fatalClosedBeech A36 · San Jose, CANTSB MIA80FA051Accident · 1 fatalClosedBeech S35 · Horseshoe Bch, FLNTSB FTW79FA046Accident · 1 fatalClosedBellanca 17-30A · Bryans Corner, OKNTSB ANC79FA033Accident · 1 fatalClosedCessna U206 · Cape Romanzof, AKNTSB MKC79FA014Accident · 1 fatalClosedCessna 210L · Junction City, KSNTSB OAK79FA014Accident · 3 fatalClosedCessna 182Q · Truckee, CANTSB MIA79DA038Accident · 3 fatalClosedCessna 210G · Gt Inagua, Burkina FasoNTSB MIA79FA035Accident · 1 fatalClosedCessna 310R · Madison, MS