NTSB investigations: Continental IO-520 series, 1983
10 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\") = 1983
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") = 1983
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 MKC84LA050Accident · No injuriesLimited investigationFinal reportCessna 210L · Des Moines, IAThe acft departed toronto, Canada at 1927 CST. About 5 hrs & 1 min later, the eng lost power when the plt was on final apch for landing. Subsequently, the acft collided with a vehicle & a light pole when the plt made a forced landing on a snow-covered parking…NTSB SEA83LA180Accident · No injuriesLimited investigationFinal reportCessna 185 Skywagon · Petersburg, AKThe acft made a forced landing in a marshy area and nosed over after the engine quit during takeoff. The pilot stated that after takeoff at about 100 ft AGL during a right turn the engine sputtered. He made a slight adjustment to the throttle and the engine…NTSB CHI83LA332Accident · No injuriesLimited investigationFinal reportCessna 188B · Crookston, MNThe acft collided with a barley crop during a forced landing on a narrow dirt road. The acft had lost power after takeoff for a calibration spray run. The pilot stated he took off with about 10 gallons of fuel (1/8 tank) and did not visually check the fuel…NTSB ATL83LA192Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Stanton, KYWhile on final apch to land, the eng lost power when the acft was at aprx 300 ft AGL. The plt stated that he switched fuel tanks & retracted the landing gear & flaps in an effort to reach the rwy. When he saw that he could not glide to the rwy, he turned to…NTSB CHI83LA200Accident · No injuriesLimited investigationFinal reportCessna U206 · Terre Haute, INThe acft made a forced landing off arpt after the engine lost power on the approach. The plt said he was using fuel fromthe right engine when the engine started to sputter. The plt switched to the left tank and tried to restart the engine to no avail. The…NTSB CHI83LA196Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Logansport, INThe plt had recently purchased the amphibious acft, had received 6.7 hrs dual instruction & was indorsed for solo flt. During a x-country from elizabethton, TN, he landed at richmond, KY & purchased 23. 8 gal of fuel. On the next leg to lafayette, IN, he made…NTSB MIA83FA123Accident · Serious injuriesField investigationFinal reportBeech V35TC · Destin, FLThe acft collided with a powerline, crashed & burned after the engine lost power on the final approach. The acft was using fuel from a tank that was less than half full. The acft had made a go-around and during the pattern was observed to be oscillating from…NTSB ATL83LA153Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Shelbyville, TNThe acft collided with a power line during a forced landing after power loss due to fuel exhaustion. The acft was on thefinal approach. The pilot said he would be landing short of the rwy. When asked the nature of his emergency he said 'I think I am running…NTSB LAX83LA084Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Ocotillo Wells, CAThe acft was on a night sightseeing flight when the engine quit. The fuel selector was on the left tank and the left tank was empty. The pilot switched tanks but the engine did not restart. The acft impacted the desert in a skid with left wing low. Post…NTSB ANC83FA030Accident · No injuriesField investigationFinal reportCessna 207A · Aniak, AKThe acft began to lose power at 700 ft MSL during climbout. The pilot tried the boost pumps and was able to regain some power momentarily. When all power was lost the pilot was forced to land short of the airport on a frozen river. The rough ice sheared the…