NTSB investigations: Continental IO-520 series, 1985
8 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “In flight collision with object”. 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 | 10 |
| 1984 | 3 |
| 1985 | 8 |
| 1986 | 7 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 12 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 4 |
| 1996 | 7 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 7 |
| 2002 | 4 |
| 2003 | 7 |
| 2004 | 5 |
| 2005 | 5 |
| 2006 | 6 |
| 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\" = 220))
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" = 220))
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 LAX86FA057Accident · 1 fatalField investigationFinal reportBeech F33A · Sacramento, CAOn December 4, 1985 at 2230 PST, a Beech F33A, operated by the owner, collided with trees during a missed approach at Sacramento metropolitan airport, Sacramento, California, while on a business flight. Instrument meteorological conditions prevailed at the…NTSB ATL85LA244Accident · No injuriesLimited investigationFinal reportCessna A188B · Benton, MSThe plt attempted to takeoff on the rwy a during takeoff ground run the acft lifted off prematurely and stalled into high vegetation. The plt stated that the grass on the runway should have been cut before it got too tall.NTSB MKC85FA177Accident · Serious injuriesField investigationFinal reportCessna A188B · Dodge City, KSThe plt was was making east & west runs over a milo field as he was dispensing parathion. He reported that he had been working under high voltage power lines each time he flew past the west edge of the field. He stated that on the last pass, the acft…NTSB MKC85LA162Accident · No injuriesLimited investigationFinal reportCessna A188B · Indianola, NEN4848Q was loaded to max gross wt and was taking off on a 2,350 ft, turf rwy. The plt said the wind was light and favored rwy 29 before takeoff. The density alt was about 2,500 ft. the plt said the acft did not seem to be developing quite the power it should…NTSB LAX85FA262Accident · 2 fatalField investigationFinal reportCessna TU-206E · San Manuel, AZThis plt was attempting to air drop illegal drugs to someone on the ground. While executing an intentional low pass, at dusk, theacft inadvertently collided with a cactus tree & crashed.NTSB FTW85LA223Accident · No injuriesLimited investigationFinal reportCessna 210D · Austin, TXThe plt touched down long on rwy 17 with 30 degs of flaps, apparently goind downwind. He attempted a go-around, drifted to the right and the left main gear hit a large boulder separating the gear from the acft. The plt then flew to another nearby arpt and…NTSB CHI85LA191Accident · No injuriesLimited investigationFinal reportCessna A188B · Virden, ILDuring aerial application, the pilot attempted to pass over a set of low wires and under high tension lines. The wires are 300 ft. apart horizontally. The prop contacted the high tension lines and the acft was destroyed on contact with the ground.NTSB CHI85LA140Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Marshall, MNThe acft contacted 10 ft high trees during takeoff from a gravel taxiway. The plt then performed a forced landing in a cultivated fld during which the landing gear separated from the acft.