NTSB investigations: Continental W670 series, 2000
8 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\") = 2000
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") = 2000
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 MIA01LA019Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLThe failure of the pilot to maintain directional control during landing with a quartering tail wind, resulting in the aircraft nosing over and coming to rest inverted.NTSB MIA01LA010Accident · No injuriesLimited investigationFinal reportJim Price Pitts Special S · Indiantown, FLThe failure of the pilot of N56JP, during landing rollout, to see and avoid N49713, who was turning off the runway after landing from the opposite direction, resulting in the 2 aircraft colliding on the runway.NTSB NYC01LA011Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Warrenton, VAThe pilot's improper recovery from a bounced landing.NTSB NYC00LA204Accident · No injuriesLimited investigationFinal reportBoeing PT17 · Easton, MDThe pilot's failure to maintain aircraft control.NTSB IAD00LA062Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75-N1 · Atwater, OHLoss of total engine power due to a fractured crankshaft.NTSB CHI00LA195Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman A75N1(PT17) · Windsor, MOfuel exhaustion and the pilot abruptly applying normal brakes during the landing roll. Factors relating to this accident were the precautionary landing, and the pilot's inadequate in-flight planning/ decision.NTSB NYC00LA197Accident · Serious injuriesLimited investigationFinal reportFairchild M-62C · Carthage, NYthe pilot's improper decision to depart with obstacles ahead which exceeded the climb capability of the airplane. Factors were the grass runway, and trees at the departure end of the runway.NTSB NYC00LA180Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Bally, PAThe pilot's failure to maintain control of the airplane after an aborted takeoff.