Fatal NTSB investigations: Continental I0-470 series, 2003
7 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\") = 2003
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") = 2003
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 LAX04FA019Accident · 2 fatalField investigationFinal reportBeech 35-C33 · Mesquite, NVfuel starvation due to the pilot's inadequate in-flight planning and fuel system management, and failure to select a fuel tank containing fuel. Also causal was the certified flight instructor's inadequate supervision.NTSB FTW03FA225Accident · 2 fatalField investigationFinal reportCessna 310J · New Orleans, LAThe pilot's failure to maintain aircraft control of the airplane during a go-around. A contributing factor was the crosswind.NTSB ATL03FA136Accident · 1 fatalField investigationFinal reportBeech BE-55 · Winder, GAThe pilot's inadequate preflight preparation in which he failed to secure the cabin door which diverted his attention and resulted in the failure to maintain directional control.NTSB LAX03LA270Accident · 1 fatalLimited investigationFinal reportBeech K35 · Gerlach, NVthe pilot's failure to maintain an adequate airspeed resulting in a stall mush and collision with terrain.NTSB NYC03FA136Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Harned, KYThe airplane's in-flight collision with terrain for undetermined reasons.NTSB NYC03FA131Accident · 4 fatalField investigationFinal reportCessna 205 · Jeannette, PAThe loss of power caused by fragments of the air filter being ingested in the engine. A factor was the pilot's delayed decision to perform a forced landing after experiencing a partial loss of engine power.NTSB DEN03FA068Accident · 3 fatalField investigationFinal reportCessna 310D · Provo, UTfailure of the student to maintain aircraft control. Contributing factors were the instructor's inattention to the fuel supply, fuel exhaustion, an inadvertent stall/spin during the turn from base leg to final approach. and the instructor's inadequate…