NTSB investigations: Continental IO-520 series, 1986
7 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 21 |
|---|---|
| 1983 | 10 |
| 1984 | 14 |
| 1985 | 14 |
| 1986 | 7 |
| 1987 | 11 |
| 1988 | 14 |
| 1989 | 8 |
| 1990 | 5 |
| 1991 | 5 |
| 1992 | 8 |
| 1993 | 9 |
| 1994 | 4 |
| 1995 | 7 |
| 1996 | 4 |
| 1997 | 7 |
| 1998 | 2 |
| 1999 | 4 |
| 2000 | 6 |
| 2001 | 6 |
| 2002 | 2 |
| 2003 | 6 |
| 2004 | 6 |
| 2005 | 8 |
| 2006 | 7 |
| 2007 | 3 |
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\") = 1986
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\" = 353))
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") = 1986
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" = 353))
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 SEA86LA241Accident · Minor injuriesLimited investigationFinal reportCessna 185 · St. John, WAAfter running a fuel tank dry in flight, the plt switched fuel tanks but failed to assure that the fuel selector was in the detent. The engine quit running and a forced landing was made in rough terrain.NTSB MKC86LA152Accident · No injuriesLimited investigationFinal reportCessna 188 · Jonesboro, ARThe acft was engaged in spraying a rice field when, according to the plt, a total loss of power occurred. The acft was subsequently damaged during a forced landing in an open field. Due to the lack of fuel which he observed after the accident, the acft owner…NTSB MIA86LA201Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Marco Island, FLDuring landing apch, the plt stated that he switched from the left fuel tank to the right tank & shortly thereafter, the eng failed. He was unable to restart the eng and a forced ldg was made. An exam of the left tank revealed it to be empty while the right…NTSB ANC86LA079Accident · No injuriesLimited investigationFinal reportCessna 185F · Naknek, AKAirplane ran out of fuel on one tank. Altitude was too low to restart on other tank prior to ground impact.NTSB FTW86LA070Accident · Serious injuriesLimited investigationFinal reportBellanca 17-300 · El Paso, TXThe eng quit due to fuel starvation. The acft had been flown 2.6 hours on the main tanks. Normal operating time on the main tanks is 2.5 hours according to the owner's manual of the Bellanca viking 300 series. At the crash site the main tanks were found empty…NTSB ATL86LA075Accident · No injuriesLimited investigationFinal reportBeech V35B · Lake Lure, NCThe plt contacted approach control for VFR staging to airport and radar service. The plt later indicated a forced landing was necessary due to fuel exhaustion. The plt calculated full fuel tanks for flt but failed to recall two local flights that were made…NTSB ATL86FA057Accident · Serious injuriesField investigationFinal reportCessna 210M · Tucker, GADuring a night VFR flt the acft experienced a total loss of power and made a forced landing in a small parking lot in a business area. When rescue personnel asked the plt what had happened he stated that the acft ran out of fuel. Inspection of the wreckage…