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 “In flight collision with terrain/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 | 18 |
|---|---|
| 1983 | 18 |
| 1984 | 4 |
| 1985 | 6 |
| 1986 | 6 |
| 1987 | 2 |
| 1988 | 6 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 6 |
| 1992 | 4 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 7 |
| 1998 | 4 |
| 1999 | 6 |
| 2000 | 2 |
| 2001 | 6 |
| 2002 | 7 |
| 2003 | 6 |
| 2004 | 3 |
| 2005 | 8 |
| 2006 | 3 |
| 2007 | 5 |
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\" = 230))
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" = 230))
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 LAX86LA035Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Fresno, CAThe acft approached the rwy for landing without the landing gear extended. The controller instructed the plt to go around but the plt continued the apch and landed with the gear retracted. Post accident inspection of the acft disclosedthe gear selector was in…NTSB ATL86LMG01Accident · No injuriesFinal reportCessna 310R · Rocky Mount, NCThe acft touched down 150 ft short of rwy 04 at the Rocky mountain-wilson arpt. The acft contacted two rows of apch lights and a ground drop off which sheared all three landing gears. The flt departed wilson municipal arpt and upon reaching 3700 ft the plt…NTSB ANC85LA134Accident · No injuriesLimited investigationFinal reportCessna 206 · Kustatan River, AKThe plt reported that he was taking off from a River/lake area with glassy water on a hot/sultry day. After initial lift-off, the acft settled & touched down on the water, then lifted off again. It flew beyond the edge of the lake, then settled & nosed over…NTSB CHI85LA195Accident · No injuriesLimited investigationFinal reportBeech 58 · Terre Haute, INThe plt was practicing touch-&-go landings on rwy 13, then elected to make another on rwy 5. He stated that the gear was extended on downwind & a safe gear indication was received. However, the acft was landed with the gear retracted. The plt stated that…NTSB LAX85FA213Accident · 1 fatalField investigationFinal reportBeech F33A · Goleta, CAWhen the plt was advised the destn arpt (santa ynez) was directly ahead at 12 mi, he requested a freq change & radar svc was terminated. About 9 min later, he reestablished radio contact (with ARTCC) & reported he was not sure of his psn. The controller told…NTSB FTW85LA096Accident · No injuriesLimited investigationFinal reportBeech V35B · Amarillo, TXDuring takeoff, the cabin door opened & the plt elected to return for a landing. He reported that he was distracted by wind noise & 'nervousness' and failed to assure that the gear was extended. As he flared, the propeller contacted the rwy. The plt added…