NTSB investigations: Continental IO-520 series, 2004, CA
7 cases on aircraft whose registry engine model is Continental IO-520 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
| 1965 | 10 |
|---|---|
| 1966 | 8 |
| 1967 | 17 |
| 1968 | 7 |
| 1969 | 8 |
| 1970 | 9 |
| 1971 | 6 |
| 1972 | 9 |
| 1973 | 13 |
| 1974 | 7 |
| 1975 | 11 |
| 1976 | 8 |
| 1977 | 17 |
| 1978 | 16 |
| 1979 | 23 |
| 1980 | 10 |
| 1981 | 7 |
| 1982 | 10 |
| 1983 | 9 |
| 1984 | 12 |
| 1985 | 4 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 8 |
| 1991 | 4 |
| 1992 | 8 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 9 |
| 1996 | 7 |
| 1997 | 7 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 3 |
| 2004 | 7 |
| 2005 | 10 |
| 2006 | 8 |
| 2007 | 6 |
| 2008 | 7 |
| 2009 | 7 |
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 8 |
| 2018 | 3 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 5 |
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\") = 2004
AND c.\"eventStateOrRegion\" = 'CA' 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 ('17032'))
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") = 2004
AND c."eventStateOrRegion" = 'CA' 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 ('17032'))
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 LAX05FA034Accident · 2 fatalField investigationFinal reportBeech A36 · Lake Havasu, CAthe pilot's continued visual flight into instrument meteorological conditions leading to spatial disorientation and an in-flight loss of control.NTSB LAX04LA312Accident · No injuriesLimited investigationFinal reportBeech F33A · Fresno, CAthe pilot's loss of pitch control authority during landing flare due to an autopilot system failure that inhibited control yoke movement. A factor was inadequate autopilot system maintenance.NTSB LAX04CA278Accident · No injuriesData collectionFinal reportCessna A185F · Gridley, CAThe pilot's improper use of the rudder to correct for torque and P-factor effects and failure to maintain obstacle clearance.NTSB LAX04FA271Accident · 3 fatalField investigationFinal reportBeech 58 · Bishop, CAthe pilot's continued VFR flight into marginal weather conditions with lowering ceilings in a box canyon in mountainous terrain, and his subsequent inability to maintain an adequate airspeed while maneuvering to reverse direction, which led to an accelerated…NTSB LAX04LA170Accident · No injuriesLimited investigationFinal reportCessna 188B · Planada, CAthe partial loss of engine power due to the separation of the number 5 cylinder fuel injector supply line. The fuel line separation was due to company maintenance personnel's failure to secure the b-nut fitting following maintenance. Factors in the accident…NTSB LAX04CA117Accident · No injuriesData collectionFinal reportCessna A185F · Fowler, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply. A factor in the accident was the pilot's lack of familiarity with the airplane.NTSB LAX04CA104Accident · Serious injuriesData collectionFinal reportBeech F33A · Shoshone, CAthe CFI's failure to verify the wind direction prior to takeoff, which resulted in his failure to attain an adequate airspeed and led to an inadvertent stall-mush. The short runway and variable winds were factors.