NTSB investigations: Continental IO-520 series, 1982
5 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “Loss of engine power”. 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 | 5 |
|---|---|
| 1983 | 2 |
| 1984 | 6 |
| 1985 | 6 |
| 1986 | 4 |
| 1987 | 5 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 6 |
| 1993 | 5 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 11 |
| 1997 | 9 |
| 1998 | 9 |
| 1999 | 10 |
| 2000 | 5 |
| 2001 | 8 |
| 2002 | 7 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 13 |
| 2006 | 7 |
| 2007 | 11 |
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\") = 1982
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\" = 350))
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") = 1982
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" = 350))
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 CHI82DA253Accident · No injuriesFinal reportCessna A185F · Lake Delton, WIThe float equipped aircraft was being operated on its first flight of the day. After takeoff, the pilot noted a deterioration of power as he was climbing through about 400 ft AGL. He was unable to restore the power and could not maintain level flight. During…NTSB LAX82FA258Accident · Minor injuriesField investigationFinal reportCessna 210L · Santa Ana, CAAbout 3 mi se of the arpt, with gear down & full flaps, the eng fuel pressure went to zero & the eng lost power. The pltdid not declare an emergency, but advised tower that the acft lost the fuel pressure. The plt was then cleared for a landing on rwy 19R. As…NTSB NYC82DA140Accident · No injuriesFinal reportCessna U206 · Nelson, NHThe pilot of the float equipped aircraft stated that during takeoff, there was a loss of power and lift. He tried to turn and land; however, the plane crashed into the lake and was destroyed. The pilot and passengers evacuated without injury.NTSB MIA82DA124Accident · No injuriesFinal reportCessna 188 · Alpha, FLThe pilot reported that during takeoff, the engine began running rough at about 1000 ft. he noted that the fuel pressure had increased abnormally and black puffs of smoke were coming out of the exhaust. He dumped his load and gained a small amount of…NTSB LAX82DA139Accident · No injuriesFinal reportCessna 210D · N. South Lake T, CAAfter takeoff, the pilot made a normal climb to about 8500 ft. he then noticed indications of higher than normal EGT and fuel pressure and a lower than normal fuel flow. The pilot reported that he had leveled off and throttled back when the engine began to…