NTSB investigations: Continental IO-520 series
4,750 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 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 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 LAX06FA129Accident · 2 fatalField investigationFinal reportBeech A36 · Santa Monica, CAThe failure of an aviation maintenance technician to properly torque and cotter pin the number 2 connecting rod bolts at their attach point to the crankshaft, which resulted in the separation of the connecting rod in flight, and complete power loss.NTSB CHI06FA090Accident · 2 fatalField investigationFinal reportBeech J35 · Holland, MIA lossof engine power due to fuel starvation as a result of the pilot's improper fuel system management and failure to select a tank containing fuel. A factor was the dark night conditions.NTSB ANC06LA024Accident · No injuriesLimited investigationFinal reportCessna 185 · Ely, NVThe pilot's inadequate compensation for a quartering tailwind while taxiing, which resulted in a loss of control and an on ground encounter with terrain. A factor in the accident was the quartering crosswind.NTSB SEA06CA059Accident · No injuriesData collectionFinal reportBeech V35B · Burns, ORThe pilot's failure to maintain clearance from the terrain during the takeoff sequence. Factors include his inadequate removal of snow and ice from the wings prior to takeoff, his improper decision to retract the landing gear before it had been positively…NTSB DFW06LA073Accident · No injuriesLimited investigationFinal reportBeech V35 · San Antonio, TXThe pilot's loss of control while on approach to the runway. Contributing factors were the downdraft and the lack of suitable terrain for the off-airport landing.NTSB LAX06FA113Accident · Serious injuriesField investigationFinal reportCessna 210M · Long Beach, CAan erroneous low fuel quantity indication that led the pilot to attempt a precautionary landing in a congested and less than ideal location. The erroneous fuel level indication was due to multiple anomalies with the alternator installation that precipitated a…NTSB LAX06FA099Accident · 1 fatalField investigationFinal reportBeechcraft F33A · Buckeye, AZThe student pilot's failure to maintain aircraft control for undetermined reasons.NTSB SEA06CA048Accident · No injuriesData collectionFinal reportCessna A185E · Lewiston, IDThe failure of the left main landing gear attaching bolt, which resulted in the left main gear collapsing during the landing roll.NTSB ANC06LA017Accident · No injuriesLimited investigationFinal reportCessna TU206G · Cordova, AKThe pilot's selection of unsuitable terrain for takeoff, and his delay in aborting the takeoff, which resulted an overrun and subsequent collision with an embankment. A factor contributing to the accident was the snow-covered airstrip.NTSB NYC06LA054Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Lexington, KYFailure of the throttle cable. Contributing to the accident was unsuitable terrain for a forced landing.NTSB CHI06LA060Accident · No injuriesLimited investigationFinal reportCessna 310R · St. Charles, MOThe in-flight collision with a duck during cruise flight resulting in a ruptured fuel tank and the strobe/light assembly electrical short resulting in a fire to the right wing tip tank. Contributing factors were the dusk light conditions.NTSB NYC06FA048Accident · 2 fatalField investigationFinal reportBeech D55 · Dawson, GAThe pilot's failure to maintain sufficient airspeed to preclude a stall, which resulted in an inadvertent stall and loss of control while circling to land. Factors associated with the accident were the pilot's inadequate in-flight planning and weather…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 MIA06LA037Accident · No injuriesLimited investigationFinal reportCessna P206C · Lake Wales, FLThe loss of engine power during takeoff-initial climb due to fuel starvation, which resulted in a hard, off-airport forced landing.NTSB LAX06FA066Accident · 2 fatalField investigationFinal reportBeech 36 · Livermore, CAThe pilot's failure to maintain the appropriate glidepath alignment during an instrument landing system approach, resulting in collision with terrain. A contributing factor to the accident was the failure of the air traffic controllers to issue a minimum safe…NTSB LAX06LA065Accident · No injuriesLimited investigationFinal reportBeech F33A · La Verne, CAthe failure of the pilot of the other aircraft to comply with his air traffic control clearance and line up for the proper runway, and his failure to maintain an adequate visual lookout, which resulted in his in-flight collision with the Cessna airplane.NTSB DFW06LA040Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Columbus, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA034Accident · No injuriesData collectionFinal reportCessna 210M · Kirbyville, TXThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06CA042Accident · Minor injuriesData collectionFinal reportCessna A185E · Show Low, AZthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control, which resulted in a ground loop.NTSB LAX06FA031Accident · 1 fatalField investigationFinal reportBeech F33A · Geyserville, CAthe pilot's failure to maintain an adequate terrain clearance altitude profile during the descent that resulted in controlled flight into terrain.NTSB ANC06TA009Accident · Minor injuriesFinal reportCessna 185 · Cordova, AKA fracture and separation of the main landing gear strut during the landing roll, which resulted in a loss of control, and subsequent nose down. Factors contributing to the accident were the manufacturer's and the FAA's insufficient standards/requirements…NTSB DFW06CA016Accident · No injuriesData collectionFinal reportCessna 210L · Baker, LAThe pilot's failure to maintain clearance during takeoff roll.NTSB ANC06CA008Accident · No injuriesData collectionFinal reportCessna 185 · Skwentna, AKThe pilot's selection of an unsuitable taxi area, which resulted in an encounter with a hidden obstruction, and an on-ground collision with trees while taxiing to takeoff. Factors associated with the accident were trees and a hidden obstruction.NTSB SEA06CA009Accident · No injuriesData collectionFinal reportCessna A185F · Lake Powell, UTThe pilot's failure to maintain clearance from terrain during an aborted water takeoff run which resulted in the airplane colliding with a canyon wall. A contributing factor was the submerged object that the airplane struck during the takeoff run.NTSB SEA06WA042Accident · 1 fatalForeign investigationCessna 185 · Limestone Lake, CanadaNTSB CHI06CA009Accident · No injuriesData collectionFinal reportCessna U206G · Hanover, MIThe pilot misjudged the landing flare which resulted in the bounced landing and subsequent overload failure of the nose landing gear wheel. A factor associated with the accident was the grass airstrip.NTSB CHI06CA008Accident · Minor injuriesData collectionFinal reportCessna 310R · Ottumwa, IAThe pilot misjudged his altitude and airspeed while landing which resulted in the airplane stalling 20 feet above the runway. A factor associated with the accident was the pilot's execution of the approach when reported weather conditions were below the…NTSB ATL06CA004Accident · No injuriesData collectionFinal reportBeech F33A · Millington, TNThe pilot's improper fuel management resulting in a total loss of engine power due to fuel starvation. A factor in the accident was the pilot's failure to maintain airspeed and misjudged distance to the forced landing area resulting in a stall and collision…NTSB LAX06CA008Accident · No injuriesData collectionFinal reportBellanca 17-30A · Riverside, CAThe failure of the steering control rod during an unknown phase of the accident flight that resulted in the unavailability of steering control upon landing.NTSB NYC06FA004Accident · 3 fatalField investigationFinal reportBeech A36 · Pikeville, KYThe pilot's failure to follow the published instrument approach which resulted in controlled flight into terrain. A factor was the low ceiling.NTSB MIA06CA003Accident · No injuriesData collectionFinal reportBeech 58 · Jacksonville, FLThe pilot's improper use of the normal brakes during the landing roll and his delay in performing a go-around resulting in an emergency descent/landing on grass past the departure end of the runway and subsequent collapse of the left main landing gear.NTSB DEN06FA001Accident · 2 fatalField investigationFinal reportBeechcraft V35B · Barnum, WYthe pilot's improper in-flight planning and decision to continue flight into forecasted icing conditions and the pilot's inability to maintain aircraft control due to wing contamination in the form of ice. Contributing factors included the weather conditions…NTSB NYC06CA053Accident · No injuriesData collectionFinal reportBeech E-55 · Providence, RIThe pilot's failure to verify landing gear extension after a landing gear malfunction, which resulted in a wheels up landing.NTSB LAX05LA317Accident · No injuriesLimited investigationFinal reportCessna A185F · Tracy, CAloss of engine power for undetermined reasons.NTSB DFW05CA238Accident · No injuriesData collectionFinal reportCessna A188B · Paris, TXThe loss of engine power due the failure of a connecting rod. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA05WA193Accident · 2 fatalForeign investigationCessna A185F · Port Hardy, CanadaNTSB ANC05CA141Accident · No injuriesData collectionFinal reportCessna 185F · Bettles, AKThe pilot's inadequate compensation for a gusty crosswind, which resulted in a loss of control and an inadvertent ground-loop during the landing roll. Factors associated with the accident were the ground-loop and gusts.NTSB ANC05LA142Accident · No injuriesLimited investigationFinal reportCessna 185E · Pilot Point, AKThe pilot's misjudged landing flare, which resulted in a hard landing and an overload failure of the main landing gear during the landing touchdown.NTSB MIA05WA154Accident · 1 fatalForeign investigationBeech BE-58 · Exuma Cay, BahamasNTSB DFW05LA229Accident · 1 fatalLimited investigationFinal reportCessna A188B · Blytheville, ARThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB ANC05LA133Accident · No injuriesLimited investigationFinal reportCessna 206 · Yakutat, AKThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain adequate airspeed during takeoff initial climb from a remote airstrip, which resulted in the airplane descending to the ground and colliding with soft terrain beyond the end…NTSB LAX05CA287Accident · No injuriesData collectionFinal reportCessna A185E · San Andreas, CAthe pilot's failure to maintain directional control of the airplane upon encountering a dust devil during the takeoff roll.NTSB ANC05LA125Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Skwentna, AKThe pilot's misjudged distance/altitude on final approach, which resulted in a noseover following an undershoot and in-flight collision with rough/uneven terrain. A factor associated with the accident was the rough/uneven terrain.NTSB ATL05FA148Accident · 2 fatalField investigationFinal reportBeech A36 · Jamestown, TNThe pilot's decision to continue flight into an area of known thunderstorm activity, which resulted in loss of aircraft control and collision with trees and the ground during the result uncontrolled descent.NTSB ATL05FA145Accident · 1 fatalField investigationFinal reportCessna 310R · Apopka, FLThe pilot's failure to maintain adequate visual lookout and object clearance, which resulted in the in-flight collision with trees.NTSB DFW05CA216Accident · No injuriesData collectionFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain directional control during the take-off roll.NTSB DFW05LA215Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Joiner, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05LA233Accident · Serious injuriesLimited investigationFinal reportNorth American Navion A (L-17B) · Zeeland, MIThe loss of engine power after takeoff due to a fuel selector valve leak and low altitude and low airspeed at the time of power loss. A factor was the recommended maintenance service for the fuel selector not performed by the airplane owner/pilot.NTSB ATL05FA142Accident · 1 fatalField investigationFinal reportBeech V35B · Ellijay, GAThe pilot's continued cruise flight under visual flight rules into known adverse weather, which resulted in his loss of control of the airplane due to spatial disorientation, and an uncontrolled descent and collision with terrain. A factor associated with the…NTSB ANC05FA121Accident · 2 fatalField investigationFinal reportBeech V35B · Denali Park, AKThe pilot's failure to maintain altitude/clearance from mountainous terrain while climbing, and his improper in-flight decision making by electing to fly at a low altitude toward rising terrain. A factor associated with the accident was mountainous terrain.