NTSB investigations: Continental IO-520 series, 1982, MS
4 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
| 1966 | 2 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 4 |
| 1975 | 2 |
| 1976 | 2 |
| 1977 | 3 |
| 1978 | 4 |
| 1979 | 6 |
| 1980 | 8 |
| 1981 | 8 |
| 1982 | 4 |
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 2 |
| 1987 | 3 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 1 |
| 2009 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2022 | 2 |
| 2023 | 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\") = 1982
AND c.\"eventStateOrRegion\" = 'MS' 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" = 'MS' 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 ATL82DA242Accident · Minor injuriesFinal reportCessna 210M · Holly Springs, MSThe pilot, an aircraft mechanic, made a night forced landing on a highway near Holly Springs, MS. During the landing roll, the right wing contacted two signposts which caused substantial damage to the aircraft. The aircraft continued 520 feet before leaving…NTSB ATL82DA180Accident · No injuriesFinal reportCessna 185 · Scooba, MSThe aircraft was climbing to cruise altitude of 8500 feet. The engine began to lose power, then quit entirely. The pilot called the accompaning aircraft and made an emergency landing in a plowed field. The aircraft nosed over during landing. Examination…NTSB ATL82FKQ16Accident · No injuriesFinal reportBeech 58 · Madison, MSThe pilot reported that during flight, the right front door suddenly opened after light turbulence was encountered. The pilot followed the procedure, as prescribed by the owner's manual, to secure and close the door. As a precaution, he canceled the remainder…NTSB ATL82DA074Accident · No injuriesFinal reportCessna A188B · Terry, MSDuring departure from a 2100 ft runway the pilot realized the plane was overloaded for the conditions. He opened the dump gate about 100 ft from the end of the runway. However he reported that lumps of fertilizer in the bottom of the hopper prevented the load…