NTSB investigations: Continental O-470 series, 2001, AZ
5 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 | 6 |
|---|---|
| 1965 | 4 |
| 1966 | 10 |
| 1967 | 8 |
| 1968 | 3 |
| 1969 | 5 |
| 1970 | 2 |
| 1971 | 4 |
| 1972 | 4 |
| 1973 | 3 |
| 1974 | 6 |
| 1975 | 2 |
| 1976 | 7 |
| 1977 | 2 |
| 1978 | 6 |
| 1979 | 5 |
| 1980 | 2 |
| 1981 | 3 |
| 1982 | 5 |
| 1983 | 6 |
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 5 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 2000 | 2 |
| 2001 | 5 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 2 |
| 2006 | 4 |
| 2007 | 3 |
| 2008 | 2 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2025 | 2 |
| 2026 | 2 |
Where
Latest 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\") = 2001
AND c.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
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") = 2001
AND c."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA'
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 LAX02FA041Accident · 2 fatalField investigationFinal reportCessna 182E · Prescott, AZthe pilot's failure to adequately deice the airplane prior to takeoff, which resulted in the airplane's degraded aerodynamic and climb performance capability, failure to maintain an adequate airspeed, and a stall/spin. Contributing factors were the pilot's…NTSB LAX01LA300Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Cottonwood, AZThe pilot's failure to obtain/maintain a proper descent rate, as well as prematurely starting his decent during nighttime operations, subsequently colliding with 60-foot power lines 4 miles from the airport.NTSB LAX01LA224Accident · No injuriesLimited investigationFinal reportCessna 182P · Mesa, AZThe pilot's improper use of the rudder control to correct for torque and P-factor effects, which resulted in a loss of directional control and an inadvertent ground loop/swerve.NTSB LAX01LA155Accident · No injuriesLimited investigationFinal reportCessna 180K · Glendale, AZThe pilot's loss of directional control during the landing roll resulting in a ground loop/swerve and collision with a runway marker sign.NTSB LAX01LA138Accident · No injuriesLimited investigationFinal reportCessna 180 · Tucson, AZthe pilot's failure to attain and maintain a sufficient airspeed, which resulted in an inadvertent stall/mush.