NTSB investigations: Continental IO-520 series, 1987
11 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\") = 1987
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") = 1987
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 MIA88FA012Accident · Serious injuriesField investigationFinal reportCessna 210M · Jacksonville, FLDuring a part 135 on-demand air taxi cargo flt, the plt reported an eng malfunction when the acft was aprx 15 miles sw of the arpt while on apch to land. The flt continued & the plt then reported that the eng quit & the flt was 5 miles sw of the arpt. A…NTSB NYC88LA002Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Newport, VTShortly after takeoff, the eng lost power as the acft was climbing thru about 75' AGL. Subsequently, the acft was damaged during an emerg landing. An exam revealed the acft had a very loosely fitting fuel cap & water was found in the fuel lines & sumps. The…NTSB ATL87LA260Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Louisville, KYThe plt made two attempts to land and during his 2nd go around the eng cut out. The plt stated that he switched from left tank to rt tank but was unable to start the eng prior to making a forced landing which resulted in a collision with a house and tree. The…NTSB ANC87LA160Accident · No injuriesLimited investigationFinal reportCessna 185 · Mt. Watana, AKAfter liftoff from a lake the airplane's engine stopped producing power and the airplane began settling toward the remaining lake. The engine surged and the airplane crashed on the tundra, 200 yards from the lake's edge. The pilot stated that he drained the…NTSB MIA87FA217Accident · Serious injuriesField investigationFinal reportCessna 185F · Hollywood, FLThe plt stated that he performed a thorough preflight of the acft to include the draining of the sumps & fuel strainer and no water was found. After takeoff while on the downwind leg, the eng quit. The plt attempted to return to the airport; however, the acft…NTSB FTW87FA170Accident · Serious injuriesField investigationFinal reportBellanca 17-30A · Mc Kinney, TXOn the third touch and go landing, while on the downwind leg of the approach, the pilot switched fuel tanks and shortly thereafter the engine failed. The pilot attempted 3 to 4 times to restart the engine by switching fuel tanks and activating the boost pump.…NTSB ATL87LA190Accident · No injuriesLimited investigationFinal reportCessna A188B · Dyersburg, TNDrg a spraying opn, the plt returned to land on an asphalt hiway & reload with chemicals. As he flared to lnd, the eng accelerated to aprx '2/3 throttle' with no throttle movement. He believed the throttle was in the off psn when this occurred. A nose hi…NTSB MIA87LA151Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Titusville, FLFlt experienced complete loss of power in both engines due to fuel exhaustion. While attempting a forced landing at an airport the aircraft touched down 200 feet short of the runway and then rolled up onto the runway. The aircraft was substantially damaged in…NTSB LAX87LA145Accident · No injuriesLimited investigationFinal reportCessna U206A · Williams, AZDuring a crosswind turn, shortly after takeoff, the pilot noticed that the fuel pressure gauge was registering a loss of fuel pressure and the engine was experiencing a smooth loss of power. The pilot said that he turned on the emergency boost pump and…NTSB FTW87LA081Accident · No injuriesLimited investigationFinal reportCessna 185A · Midland, TXDuring take off, the aircrafts engine failed due to fuel exhaustion. The pilot made an emergency forced landing in a rough uneven field, causing substantial damage to the left wing spar, left main gear, and left elevator. The pilot did not hold a…NTSB CHI87LA091Accident · Minor injuriesLimited investigationFinal reportBeech BE 36 · Alma, MIAccording to the plt, during the preflight inspection, he determined that both gas tanks were full and 'everything was in order.' After aprx one hour of local flight, the plt entered a left downwind for rwy 27 at gratiot community airport, Alma, Michigan. The…