Fatal NTSB investigations: Continental I0-470 series, 2002
6 cases on aircraft whose registry engine model is Continental I0-470 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 |
|---|---|
| 1966 | 2 |
| 1967 | 3 |
| 1968 | 2 |
| 1969 | 5 |
| 1970 | 3 |
| 1971 | 2 |
| 1972 | 5 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 3 |
| 1976 | 3 |
| 1977 | 1 |
| 1978 | 10 |
| 1979 | 8 |
| 1980 | 9 |
| 1981 | 10 |
| 1982 | 6 |
| 1983 | 9 |
| 1984 | 8 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 8 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 8 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 5 |
| 2001 | 8 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 5 |
| 2005 | 9 |
| 2006 | 7 |
| 2007 | 5 |
| 2008 | 4 |
| 2009 | 5 |
| 2010 | 8 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 5 |
| 2014 | 3 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 3 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 8 |
| 2026 | 3 |
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\") = 2002
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 ('17027'))
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") = 2002
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 ('17027'))
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 ATL03FA002Accident · 1 fatalField investigationFinal reportBeech K35 · Jellico, TNThe pilot's incapacitation in flight due to a heart attack resulting in an in-flight loss of control, and collision with terrain. A factor was the pilot acting as a pilot-in-command with a known medical grounding condition.NTSB NYC02FA197Accident · 1 fatalField investigationFinal reportCessna 310L · Virgil, NYThe pilot's decision to continue the flight into IMC after canceling his IFR clearance, and his failure to maintain terrain clearance while maneuvering. Factors in the accident were rain, low ceilings, and night.NTSB ATL02FA160Accident · 1 fatalField investigationFinal reportBeech BE-55 · Jacksboro, TNPilot incapacitation due to a heart attack resulting in a loss of control and the subsequent in-flight collision with a lake.NTSB CHI02FA237Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Festus, MOThe pilot's lack of recent experience and his failure to maintain adequate airspeed which resulted in a stall and collision with the ground. The pilot's failure to execute a go-around was a factor.NTSB LAX02FA214Accident · 4 fatalField investigationFinal reportCessna 310I · San Dimas, CAthe pilot's failure to maintain control of the airplane following a loss of power in one engine during takeoff. The reason for the loss of power in the left engine could not be determined. Contributing factors to the accident were the pilot's failure to…NTSB DEN02FA050Accident · 1 fatalField investigationFinal reportBeech M35 · Briggsdale, COcontrolled descent into terrain for reasons undetermined.