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 - in flight”. 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 | 5 |
| 1984 | 9 |
| 1985 | 6 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 6 |
| 1990 | 7 |
| 1991 | 7 |
| 1992 | 8 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 11 |
| 1996 | 6 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 6 |
| 2001 | 9 |
| 2002 | 9 |
| 2003 | 8 |
| 2004 | 7 |
| 2005 | 5 |
| 2006 | 8 |
| 2007 | 7 |
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\") = 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\" = 250))
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" = 250))
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 ANC85LA186Accident · No injuriesLimited investigationFinal reportCessna A185F · Port Alsworth, AKThe pilot took off in turbulent wind conditions and lost control of the airplane; striking ground and upending.NTSB ATL85FA285Accident · 2 fatalField investigationFinal reportBeech A36 · Lafayette, GAThe acft crashed in a trailer parking lot after a steep left turn & uncontrolled descent. The acft impacted the ground in a nose low attitude. The rt wing had struck a parked trailer prior to the nose striking the ground. The acc occurred about 1/4 mile from…NTSB MIA85LKG04Accident · No injuriesFinal reportCessna A188B · Bainbridge, GAThe acft stalled during aerial application operations and collided with the ground. The plt said the wind was gusting to 30 KTS and during a steep downwind turn the loaded acft stalled at 100 ft AGL. The plt recommended less steep turns and not operating in…NTSB ANC85LA141Accident · No injuriesLimited investigationFinal reportCessna 188 · Dry Creek Mine, AKThe plt reported that while on final apch aprx 100 ft from touchdown, the acft yawed to the left and the left wing dropped. The acft contacted the ground aprx 25 ft left of the rwy and nosed over.NTSB ANC85FA124Accident · Minor injuriesField investigationFinal reportCessna A-185F · Elmendorf Afb, AKImmediately after takeoff from a lake the acft stalled, did a half spin & nosed into the water. Witnesses reported seeing acft nose pitching up & down & wings wobbling just prior to the stall. This was plt's first flt in this type acft without an instructor.…NTSB DEN85LA081Accident · No injuriesLimited investigationFinal reportCessna A185F · Rifle, COThe plt had been practicing takeoffs and landings with what he described as a slight 90 deg x-wind. During the final landing, the plt reported, the right wing rose and the left wing dropped contacting the ground. He was able to level the acft and initiate an…