NTSB investigations: Continental IO-520 series, 2005
11 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 8 |
|---|---|
| 1983 | 14 |
| 1984 | 14 |
| 1985 | 6 |
| 1986 | 10 |
| 1987 | 6 |
| 1988 | 8 |
| 1989 | 8 |
| 1990 | 6 |
| 1991 | 4 |
| 1992 | 8 |
| 1993 | 6 |
| 1994 | 5 |
| 1995 | 8 |
| 1996 | 13 |
| 1997 | 5 |
| 1998 | 12 |
| 1999 | 11 |
| 2000 | 8 |
| 2001 | 5 |
| 2002 | 7 |
| 2003 | 10 |
| 2004 | 11 |
| 2005 | 11 |
| 2006 | 4 |
| 2007 | 5 |
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\") = 2005
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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") = 2005
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 LAX06CA042Accident · Minor injuriesData collectionFinal reportCessna A185E · Show Low, AZthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control, which resulted in a ground loop.NTSB ANC05CA141Accident · No injuriesData collectionFinal reportCessna 185F · Bettles, AKThe pilot's inadequate compensation for a gusty crosswind, which resulted in a loss of control and an inadvertent ground-loop during the landing roll. Factors associated with the accident were the ground-loop and gusts.NTSB DFW05CA216Accident · No injuriesData collectionFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain directional control during the take-off roll.NTSB CHI05CA201Accident · No injuriesData collectionFinal reportCessna 188 · Mexico, MOThe pilot's failure to maintain directional control. Factors were the grass terrain adjacent to the runway and the collapse of the main landing gear.NTSB ANC05LA104Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's failure to compensate for wind conditions and his failure to maintain directional control of the airplane during the landing roll, which resulted in an excursion off the side of the runway and a nose over.NTSB DFW05CA161Accident · No injuriesData collectionFinal reportCessna A188B · Osceola, ARThe pilot's failure to maintain directional control during takeoff. A contributing factor was the prevailing crosswind.NTSB ANC05CA060Accident · No injuriesData collectionFinal reportCessna A185E · Wasilla, AKThe flight instructor's failure to provide adequate supervision of the second pilot during the landing roll, which resulted in a loss of control and an intentional ground-loop by the instructor. A factor in the accident was the dual student's ( a certificated…NTSB SEA05LA081Accident · No injuriesLimited investigationFinal reportCessna 185F · Medford, ORThe pilot's failure to maintain directional control during the landing roll. Factors include variable winds that at times were crosswinds.NTSB LAX05LA110Accident · No injuriesLimited investigationFinal reportCessna A185E · Tucson, AZa loss of directional control due to the failure of unknown maintenance personnel to install the tailwheel-locking collar, and the inadequate maintenance inspection of the worn tailwheel steering arm.NTSB ANC05LA041Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Kipnuk, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a departure from the runway and collision with a snow bank. A factor contributing to the accident was snow-covered terrain.NTSB ANC05TA022Accident · No injuriesFinal reportCessna 185 · Eek, AKThe pilot's inadequate evaluation of weather conditions, which resulted in an on ground encounter with terrain during the landing roll. Factors associated with the accident were a tailwind, and snow-covered, icy terrain conditions.