NTSB investigations: Continental IO-520 series, 1985
6 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\") = 1985
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") = 1985
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 ANC86LA018Accident · No injuriesLimited investigationFinal reportCessna 185 · Aleknagik, AKThe pilot stated that on landing at a frozen lake he lost control of the aircraft causing the plane to ground loop. The aircraft then struck a snow bank on the beach.NTSB MIA85LA226Accident · No injuriesLimited investigationFinal reportCessna 210N · Melbourne, FLAct swerved left after landing and crashed at drainage ditc h appx 50 ft north of rwy. The pilot stated he was unable to effect a timely recovery from the left swerve and that 'a more consistent training effort could sharpen my reactions to this sort of…NTSB ANC85LA142Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Nome, AKThe plt stated on short final apch he noticed a x-wind stronger then expected. After touchdown directional control of the acft was lost. The acft then exited the rwy into a open ditch. At the time of the accident the wind was 280 degs at 12 KTS.NTSB SEA85LA169Accident · No injuriesLimited investigationFinal reportCessna 185F · Boise, IDThe acft ground looped and the left main gear collapsed during a landing roll. The plt reported that the left wing came up during the landing roll which resulted in the acft veering to the right. When the wing settled, the left main gear collapsed allowing…NTSB ANC85LA081Accident · No injuriesLimited investigationFinal reportCessna 185F · Talkeetna, AKPlt did not use all available takeoff area and failed to recognized need to abort until too late. Possible overweight airplane loaded beyond centre of gravity rangeNTSB MIA85LA136Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Melbourne, FLThe acft was departing on rwy 27L, when aprx 1200 ft down the rwy, on the takeoff roll, it veered off the left side of the rwy & crossed two taxiways. The acft came to rest about 350 ft off the left side of rwy 27L. A post crash exam of the landing gear…