NTSB investigations: Continental W670 series, 1971
18 cases on aircraft whose registry engine model is Continental W670 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 | 31 |
|---|---|
| 1965 | 28 |
| 1966 | 27 |
| 1967 | 32 |
| 1968 | 24 |
| 1969 | 21 |
| 1970 | 17 |
| 1971 | 18 |
| 1972 | 14 |
| 1973 | 23 |
| 1974 | 23 |
| 1975 | 14 |
| 1976 | 17 |
| 1977 | 14 |
| 1978 | 11 |
| 1979 | 12 |
| 1980 | 18 |
| 1981 | 9 |
| 1982 | 9 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 7 |
| 1986 | 2 |
| 1987 | 6 |
| 1988 | 8 |
| 1989 | 14 |
| 1990 | 6 |
| 1991 | 10 |
| 1992 | 10 |
| 1993 | 5 |
| 1994 | 8 |
| 1995 | 7 |
| 1996 | 5 |
| 1997 | 7 |
| 1998 | 8 |
| 1999 | 4 |
| 2000 | 8 |
| 2001 | 2 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 6 |
| 2005 | 5 |
| 2006 | 6 |
| 2007 | 7 |
| 2008 | 5 |
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 5 |
| 2017 | 7 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 5 |
| 2023 | 2 |
| 2024 | 5 |
| 2025 | 3 |
| 2026 | 1 |
Where
Open the mapLatest 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\") = 1971
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17018'))
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") = 1971
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17018'))
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 FTW72DPJ26Accident · No injuriesClosedBoeing A75N1 · Hollis, OKNTSB LAX72DUG23Accident · No injuriesClosedStinson L-5E · Elsinore, CANTSB MIA72FKG30Accident · No injuriesClosedCessna 190 · Brunswick, GANTSB NYC72FIA03Accident · No injuriesClosedStearman PT-17 · Bealeton, VANTSB FTW72DRD08Accident · No injuriesClosedGrumman G-164 · Jeanerette, LANTSB LAX72DVA11Accident · Minor injuriesClosedBoeing B75N1 · Wheeler Rdg, CANTSB FTW72DRD02Accident · No injuriesClosedBoeing A75 · Houma, LANTSB NYC72FNE02Accident · No injuriesClosedCommandaire 5C3 · Ellington, CTNTSB CHI72DEP02Accident · No injuriesClosedBoeing B75N1 · Blck Rvr Flls, WINTSB OAK72FVG03Accident · No injuriesClosedBoeing A75N1 · Sacramento, CANTSB FTW71DPM32Accident · No injuriesClosedGrumman G-164 · Dustin, OKNTSB FTW71DQG72Accident · No injuriesClosedWaco QCF-2 · Wink, TXNTSB FTW71DRD44Accident · Serious injuriesClosedBoeing E75 · Reeves, LANTSB FTW71FRA49Accident · No injuriesClosedBoeing E75 · Fannett, TXNTSB MKC71DCQ35Accident · No injuriesClosedBoeing A75N1 · Liberal, KSNTSB FTW71FRD41Accident · Serious injuriesClosedBoeing A75N1 · Opelousas, LANTSB LAX71FUM31Accident · Serious injuriesClosedFairchild M-62C · Chula Vista, CANTSB FTW71DQG50Accident · No injuriesClosedCallair A-7T · Spearman, TX