NTSB investigations: Continental IO-520 series, CA
10 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 | 2 |
|---|---|
| 1984 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 2 |
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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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 LAX06FA075Accident · 3 fatalField investigationFinal reportBeech V35A · Valley Center, CAthe pilot's failure to maintain an adequate airspeed margin following a loss of engine power in the takeoff initial climb, resulting in a stall/spin. While the laboratory tests indicated the presence of an unknown biological contaminant in the fuel manifold…NTSB LAX05LA317Accident · No injuriesLimited investigationFinal reportCessna A185F · Tracy, CAloss of engine power for undetermined reasons.NTSB LAX03LA070Accident · No injuriesLimited investigationFinal reportCessna A188A · Brawley, CAloss of engine power for undetermined reasons.NTSB LAX02LA091Accident · No injuriesLimited investigationFinal reportBeech V35 · San Jose, CAa loss of engine power for undetermined reasons, which resulted in a forced landing into a residential area.NTSB LAX98LA280Accident · No injuriesLimited investigationFinal reportCessna 188B · Dixon, CAA partial loss of engine power for an undetermined reason, and the ignition of a highly combustible compound in the application hopper.NTSB LAX96FA308Accident · 1 fatalField investigationFinal reportCessna 210E · Big Bear City, CAan inadequate annual inspection conducted by other maintenance personnel.NTSB LAX92LA270Accident · No injuriesLimited investigationFinal reportBeech A36 · Brawley, CAFuel starvation due to the pilot's; 1) failure to refuel the aircraft, 2) improper use of the fuel system, and 3) his delayed positioning of the fuel selector valve to a tank containing fuel. A factor in the accident was the pilot's failure to adhere to the…NTSB LAX84FA183Accident · No injuriesField investigationFinal reportBeech A36 · Santa Monica, CAThe plt stated that after takeoff, the electrical sys failed as he retracted the gear. He elected to return to the arpt & land. Shortly thereafter, the eng lost power. He further stated that he hand cranked the gear to the down position & received a light…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 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…