NTSB investigations: Continental IO-520 series, 2003
73 cases on aircraft whose registry engine model is Continental IO-520 series. 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, newest first
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\") = 2003
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'))
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") = 2003
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'))
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 NYC03LA089Accident · No injuriesLimited investigationFinal reportCessna P206 · Newport, RIThe pilot's inadvertent encounter with propeller blast.NTSB LAX03LA139Accident · 1 fatalLimited investigationFinal reportAero Commander 200D · Corona De Tucso, AZThe pilot's failure to maintain an adequate clearance from obstructions while performing low level passes. The pilot's physical impairment due to a high blood alcohol level was also causal.NTSB SEA03FA165Accident · 2 fatalField investigationFinal reportCessna 320D · Mazama, WAThe pilot's failure to maintain clearance from terrain while maneuvering. Mountainous terrain, trees and mountain obscuration were factors.NTSB FTW03LA129Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Fort Worth, TXA loss of engine power due to corrosion and contamination of the fuel system, and the partially blocked fuel lines and nozzles.NTSB IAD03FA045Accident · 1 fatalField investigationFinal reportBeech A36 · Pomona, NJThe pilot's failure to follow instrument approach procedures. Factors in the accident included the pilot's lack of recent instrument experience and the instrument weather conditions.NTSB NYC03FA079Accident · 2 fatalField investigationFinal reportRaytheon V35A · Delaware City, DEThe pilot's failure to maintain aircraft control. A factor in the accident was instrument meteorological conditions.NTSB ANC03LA039Accident · No injuriesLimited investigationFinal reportCessna 207 · Aniak, AKThe pilot's improper fuel management, and subsequent fuel starvation during cruise flight. A factor contributing to the accident was unsuitable terrain for a forced landing.NTSB MIA03LA082Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Tavernier, FLThe control interference by the pilot-rated passenger in an attempt to avoid an obstacle, which resulted in a loss of control.NTSB CHI03FA094Accident · 3 fatalField investigationFinal reportBeech A36 · New Vienna, IAThe improper planning/decision by the pilot to fly into forecast icing conditions with an airplane not equipped with a certified deice system. The continued flight in known icing conditions and the flight to an alternate destination not performed by the pilot…NTSB DEN03FA059Accident · 4 fatalField investigationFinal reportCessna A185F · Grand Junction, COthe pilot's poor judgment and his failure to maintain aircraft control. Contributing factors were the high winds and downdrafts, and the pilot's self-induced pressure to go home.NTSB SEA03LA049Accident · No injuriesLimited investigationFinal reportCessna 172G · Packwood, WALoss of partial engine power for undetermined reasons during the initial climb after takeoff. Loose gravel/sandy was a factor during the landing roll.NTSB IAD03LA038Accident · No injuriesLimited investigationFinal reportCessna U206A · Honesdale, PAThe pilot's failure to maintain directional control while landing. A factor was the crosswind.NTSB ATL03FA055Accident · 1 fatalField investigationFinal reportBeech A-36 · Milledgeville, GAThe pilot's improper IFR procedure by which he failed to maintain the minimum descent altitude, and his failure to maintain obstacle clearance. A factor was low the ceiling.NTSB ATL03FA052Accident · 5 fatalField investigationFinal reportBeech BE-36A · Mount Airy, NCThe pilots failure to maintain control of the aircraft due to spatial disorientation. A factor was low clouds.NTSB MIA03FA068Accident · 1 fatalField investigationFinal reportBeech 36 · Captiva Island, FLThe pilot's VFR flight into instrument meteorological conditions and his ensuing failure to maintain altitude/clearance resulting in an in-flight collision with the ocean. A factor was the fog.NTSB ATL03LA046Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Morristown, TNThe pilot's inadequate preflight planning/decision to initiate flight into known adverse weather conditions, resulting in the in-flight encounter with weather and subsequent in-flight collision with terrain. A factor was airplane performance deteriorated due…NTSB NYC03WA049Accident · No injuriesForeign investigationCessna 188B · Badger, Nfld, CanadaNTSB FTW03LA094Accident · No injuriesLimited investigationFinal reportCessna 210L · Morrilton, ARThe failure of the main landing gear to extend and lock, as a result of a hydraulic fluid leak caused by a chaffed and ruptured flex line.NTSB LAX03LA080Accident · No injuriesLimited investigationFinal reportBeech S-35 · Quartzsite, AZThe driver of the vehicle did not stop prior to crossing the airstrip as directed by airstrip signage.NTSB DEN03FA040Accident · 1 fatalField investigationFinal reportBeech V35B · Rock Springs, WYthe pilot's failure to maintain adequate airspeed, resulting in a stall. Factors contributing to the accident were the icing conditions, low altitude, and the high gusting winds.NTSB NYC03FA043Accident · 2 fatalField investigationFinal reportBeech V35B · Delaware City, DEThe mechanic's improper engine overhaul. A factor was the night condition.NTSB LAX03LA070Accident · No injuriesLimited investigationFinal reportCessna A188A · Brawley, CAloss of engine power for undetermined reasons.NTSB FTW03LA075Accident · No injuriesLimited investigationFinal reportCessna 401 · Mc Allen, TXThe pilot's failure to manually extend the landing gear to the full down and locked position. A contributing faction was a loss of electrical power, which resulted in the failure of the landing gear to extend.