NTSB investigations: Continental IO-520 series, 1982, AZ
5 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 | 3 |
|---|---|
| 1966 | 2 |
| 1967 | 4 |
| 1968 | 6 |
| 1969 | 2 |
| 1970 | 7 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 5 |
| 1975 | 3 |
| 1976 | 6 |
| 1977 | 8 |
| 1978 | 8 |
| 1979 | 7 |
| 1980 | 5 |
| 1981 | 6 |
| 1982 | 5 |
| 1983 | 4 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 3 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 3 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 2 |
| 2010 | 5 |
| 2011 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 1 |
| 2022 | 3 |
| 2023 | 1 |
| 2026 | 1 |
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\") = 1982
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 ('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") = 1982
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 ('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 LAX83FA050Accident · 4 fatalField investigationFinal reportBellanca 17-30A · Williams, AZThe original departure point was camarillo, CA. Before departing camarillo, the pilot obtained a weather briefing for a flight to flagstaff, AZ. At about that time, the flagstaff weather was, in part: zero ceiling, 1/16 mi visibility. The pilot was warned of…NTSB LAX83FA030Accident · 1 fatalField investigationFinal reportCessna T337D · Scottsdale, AZFour minutes after takeoff the plt radioed that his eng had failed & he was going down. The acft crashed into a residential area, striking power lines, a fence & two houses. The acft had been flown during the day with no refueling the right aux tank contained…NTSB LAX82DA325Accident · No injuriesFinal reportCessna 188 · Casa Grande, AZThe pilot initiated his takeoff with a light quartering tail wind from a 2300 ft runway that was covered with tall grass. The temperature and elevation were 95 deg and about 1500 ft, respectively. He reported that the plane accelerated slowly, but was about…NTSB LAX82DA266Accident · No injuriesFinal reportBeech A36 · Grand Canyon, AZThe aircraft dragged a wingtip during an aborted takeoff and swerved off the runway. The density altitude was 8200 feet. The pilot said he could not maintain a climb so he lowered the landing gear to abort the takeoff and lost control of the aircraft. The…NTSB LAX82FA111Accident · 5 fatalField investigationFinal reportCessna 401 · Sunflower, AZAt 1027 the plt received a wx briefing for holbrook, AZ. The plt was told of forecasts for "at least moderate icing in clouds or in precipitation above the freezing level" & the briefer stated "I guarantee you moderate to severe turbulence..." For a route…