NTSB investigations: Continental IO-520 series, 1998
12 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\") = 1998
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") = 1998
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 MIA99LA040Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Star, NCThe failure of the pilot to use proper short-field landing procedure, resulting in an extended flare and touchdown by the nose wheel and right main wheel simultaneously, and the subsequent loss of directional control and collision with trees.NTSB LAX99LA021Accident · No injuriesLimited investigationFinal reportCessna 185E · Tucson, AZFailure of the pilot to properly secure the seat which subsequently slid back on the takeoff roll and lead to the pilot's loss of aircraft control.NTSB ANC98LA132Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe pilot's inadvertent ground loop/swerve. A factor associated with the accident was the pilot's inadequate recovery from a bounced landing.NTSB LAX98LA268Accident · No injuriesLimited investigationFinal reportCessna 185 · Susanville, CAThe pilot's failure to maintain directional control. A factor was the gusty wind conditions.NTSB FTW99LA028Accident · No injuriesLimited investigationFinal reportCessna 185F · Venice, LAThe pilot's failure to maintain control of the airplane during high speed step-taxi. A factor was the swell left by the boat.NTSB CHI98LA276Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Delavan, WIthe pilot's failure to maintain aircraft control during the takeoff roll. Factors contributing to this accident were the pilot's inadequate preflight, his operation of an airplane with a known deficiency, low air pressure on both main tires, the snow fence,…NTSB FTW98LA324Accident · No injuriesLimited investigationFinal reportCessna A188B · Erie, COThe pilot's failure to maintain directional control of the airplane. A factor was a crosswind gust.NTSB ANC98LA089Accident · No injuriesLimited investigationFinal reportCessna 185E · Iliamna, AKThe pilot's inadequate compensation for crosswind conditions. Factors associated with the accident were a crosswind and the pilot's lack of recent experience in a tailwheel airplane.NTSB ANC98LA049Accident · No injuriesLimited investigationFinal reportCessna U206G · Iliamna, AKThe pilot's inadequate compensation for quartering tailwind conditions. A factor in the accident is the presence of a quartering tailwind.NTSB ANC98LA030Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions during landing. A factor was the crosswind.NTSB ANC98LA027Accident · No injuriesLimited investigationFinal reportCessna A185F · Homer, AKThe pilot's failure to maintain directional control. Factors in the accident are the sheared valve stem/deflation of the tire, and subsequent fracturing of the associated wheel.NTSB ANC98LA029Accident · No injuriesLimited investigationFinal reportCessna 185 · Mcgrath, AKThe pilot's failure to maintain directional control after landing. Factors associated with the accident are the presence of snow covered terrain, a tree, and the pilot's selection of an unsuitable landing area.