Fatal NTSB investigations: Continental O-470 series, 2002
11 cases on aircraft whose registry engine model is Continental O-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 | 9 |
|---|---|
| 1965 | 5 |
| 1966 | 2 |
| 1967 | 10 |
| 1968 | 2 |
| 1969 | 6 |
| 1970 | 7 |
| 1971 | 2 |
| 1972 | 5 |
| 1973 | 4 |
| 1974 | 2 |
| 1975 | 4 |
| 1976 | 6 |
| 1977 | 10 |
| 1978 | 25 |
| 1979 | 15 |
| 1980 | 12 |
| 1981 | 12 |
| 1982 | 15 |
| 1983 | 19 |
| 1984 | 16 |
| 1985 | 12 |
| 1986 | 13 |
| 1987 | 12 |
| 1988 | 6 |
| 1989 | 8 |
| 1990 | 9 |
| 1991 | 10 |
| 1992 | 6 |
| 1993 | 6 |
| 1994 | 7 |
| 1995 | 9 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 8 |
| 1999 | 10 |
| 2000 | 3 |
| 2001 | 8 |
| 2002 | 11 |
| 2003 | 19 |
| 2004 | 15 |
| 2005 | 7 |
| 2006 | 16 |
| 2007 | 19 |
| 2008 | 5 |
| 2009 | 11 |
| 2010 | 5 |
| 2011 | 12 |
| 2012 | 7 |
| 2013 | 7 |
| 2014 | 6 |
| 2015 | 12 |
| 2016 | 8 |
| 2017 | 4 |
| 2018 | 5 |
| 2019 | 7 |
| 2020 | 3 |
| 2021 | 6 |
| 2022 | 4 |
| 2023 | 5 |
| 2024 | 6 |
| 2025 | 2 |
| 2026 | 4 |
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 ('17026'))
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 ('17026'))
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 ANC03LA022Accident · 1 fatalLimited investigationFinal reportCessna 180 · Petersburg, AKAn in flight collision with ocean water for an undetermined reason.NTSB ATL03FA017Accident · 1 fatalField investigationFinal reportCessna 182Q · Cornelia, GAThe pilot's failure to follow IFR approach procedures and continue below the minimum descent altitude, which resulted in an inflight collision with trees, and the ground. A factor was the pilot's impairment from a prescription drug.NTSB NYC03FA022Accident · 2 fatalField investigationFinal reportCessna 182D · NewPhiladelphia, OHThe pilot's improper decision to disregard the weather briefing, and to conduct an intentional flight into known icing conditions, with an airplane not equipped for that flight, and his failure to maintain airspeed. Factors were the clouds and icing…NTSB FTW03WA043Accident · 2 fatalForeign investigationCessna 182M · Gonzaga, MexicoNTSB MIA03FA005Accident · 1 fatalField investigationFinal reportCessna 310 · Merritt Island, FLThe pilot's decision to take off with a known equipment deficiency, and his failure to maintain airspeed (VMC) following a loss of engine power to one of the airplane's two engines for undetermined reasons, which resulted in descent and an impact with terrain.NTSB ATL02FA156Accident · 3 fatalField investigationFinal reportCessna 182R · Lake City, TNThe pilot's failure to follow procedures pertaining to mountain flying, and the pilot's failure to maintain airspeed that resulted in an inadvertent stall and subsequent in-flight collision with trees and terrain. A factor was the certified flight instructor…NTSB SEA02FA145Accident · 2 fatalField investigationFinal reportCessna 182A · Emmett, IDThe pilot's failure to maintain clearance from power transmission lines while maneuvering.NTSB CHI02FA172Accident · 1 fatalField investigationFinal reportCessna 182A · Foster City, MIThe incapacitation of the pilot. A contributing factor was the pilot and medical examiner providing false information on the pilot's medical applications.NTSB LAX02FA179Accident · 1 fatalField investigationFinal reportCessna 182P · Pleasanton, CAThe pilot's inadvertent flight into adverse weather and his failure to maintain clearance. Contributing factors included the pilot's inadequate preflight planning, the low ceilings, and the dark night conditions.NTSB FTW02LA125Accident · 1 fatalLimited investigationFinal reportHoward Harder Skybolt · Claremore, OKThe failure of the pilot to maintain clearance with terrain for undetermined reasons while conducting aerobatic maneuvers. A factor contributing to the accident was the physical impairment of the pilot.NTSB LAX02FA110Accident · 1 fatalField investigationFinal reportPilatus UV-20A · Marana, AZthe failure of both pilots to maintain an adequate visual lookout. The failure of the Pilatus pilot to report his proper position was a factor.