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 ATL07LA119Accident · 1 fatalLimited investigationFinal reportCessna P206 · Center Hill, FLThe pilot committed suicide. Contributing to the event was the pilot's impairment due to alcohol.NTSB DFW07IA193Incident · 1 fatalIncident investigationFinal reportCessna A188B · Colorado City, TXThe pilot's failure to maintain clear of the rotating propeller.NTSB ANC07CA089Accident · No injuriesData collectionFinal reportCessna U206G · Iliamna, AKThe pilot's inadequate compensation for gusty wind conditions, which resulted in the float-equipped airplane's right wing striking the bottom of the shallow lake, while taxiing for takeoff. A factor contributing to the accident was the gusty wind condition.NTSB SEA07FA228Accident · 1 fatalField investigationFinal reportCessna T210G · Lomita, CAThe loss of engine power during approach as a result of fuel starvation due to the pilot's improper pre takeoff fuel system selector valve positioning. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB CHI07CA261Accident · No injuriesData collectionFinal reportCessna 210 D · Fort Wayne, INThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight.NTSB ANC07LA100Accident · No injuriesLimited investigationFinal reportCessna 185 · Pedro Bay, AKThe loss of control during the landing roll for an unknown reason.NTSB DFW07CA181Accident · Serious injuriesData collectionFinal reportCessna A188B · Garden City, TXThe pilot's failure to maintain clearance with the ground equipment while maneuvering. A contributing factor was the power lines along the pilot's application path.NTSB LAX07CA244Accident · No injuriesData collectionFinal reportBeech 36 · Jean, NVA loss of engine power for undetermined reasons.NTSB ANC07LA071Accident · No injuriesLimited investigationFinal reportCessna 185E · Talkeetna, AKThe loss of engine power during cruise flight due to an improperly repaired airbox.NTSB DFW07CA174Accident · No injuriesData collectionFinal reportCessna A188B · Garwood, TXThe pilot's failure to maintain proper clearance from terrain/obstacles. A contributing factor was the runway conditions.NTSB LAX07CA230Accident · No injuriesData collectionFinal reportBeech V35B · Yellow Pine, IDThe pilot's failure to attain the proper touchdown point on landing.NTSB CHI07LA224Accident · No injuriesLimited investigationFinal reportBeech V35B · Rockford, ILA loss of engine power for undetermined reasons, which resulted in a forced landing. A contributing factor was the unsuitable terrain (corn field) encountered during the landing.NTSB DEN07LA124Accident · No injuriesLimited investigationFinal reportCessna A185F · Englewood, COThis case was revised 10/31/2007. Low compression in number 2 cylinder, which reduced the airplane's climb capability. Contributing factors in this accident were the high density altitude conditions, and the tree.NTSB SEA07LA210Accident · No injuriesLimited investigationFinal reportBeech E-33C · Laurel, MTThe overload failure of the nose gear retract brace (drag link) during the landing roll.NTSB CHI07CA218Accident · No injuriesData collectionFinal reportCessna 188A · New Hartford, MOThe pilot's failure to maintain clearance from the tree line during the turn between aerial application passes. The low altitude, the downdraft encountered by the pilot, and the trees were contributing factors.NTSB LAX07LA221Accident · No injuriesLimited investigationFinal reportBeech 58 · Chino, CAThe pilot's failure to ensure the landing gear selector handle was in the extended position prior to departure, which resulted in a premature retraction.NTSB ANC07LA066Accident · No injuriesLimited investigationFinal reportBeech 58 · Northway, AKThe collapse of the landing gear during the landing roll for an undetermined reason.NTSB DEN07LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Ulysses, KSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07CA180Accident · Minor injuriesData collectionFinal reportCessna 188B · Wyaconda, MOThe pilot's failure to maintain clearance from the trees. A factor in the accident was the trees.NTSB MIA07LA111Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Cullman, ALThe pilot’s mismanagement of an in-flight emergency, which resulted in a gear-up landing and runway overrun. Contributing to the accident was a breach to the engine crankcase above and in line with the No. 1 cylinder.NTSB ANC07FA051Accident · Serious injuriesField investigationFinal reportCessna 206 · Homer, AKA loss of engine power due to fuel starvation from the pilot's improper fuel selector positioning, and her failure to maintain adequate airspeed to preclude a stall. Contributing to the accident was an inadvertent stall.NTSB DEN07FA100Accident · 1 fatalField investigationFinal reportBeech 58 · Placitas, NMthe failure of the pilot to maintain adequate terrain separation, for undetermined reasons, which resulted in controlled flight into terrain. A contributing factor was the mountainous terrain.NTSB ANC07CA050Accident · Minor injuriesData collectionFinal reportCessna 206 · Seldovia, AKThe pilot's inadequate compensation for wind conditions during the final landing approach, which resulted in an in-flight collision with trees. A factor associated with the accident was turbulence.NTSB CHI07CA166Accident · Serious injuriesData collectionFinal reportCessna A188B · Sargent, NEThe pilot's failure to maintain adequate visual lookout and clearance from the hillside. Factors contributing to the accident include the pilot's diverted attention, the hillside, and the glare from the setting sun.NTSB DFW07CA125Accident · Minor injuriesData collectionFinal reportCessna A188B · Happy, TXAn in-flight fire while maneuvering for an undetermined reason.NTSB SEA07LA140Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Shearer, IDA fracture and separation of the left main landing gear strut during the landing roll due to fatigue.NTSB SEA07FA134Accident · 1 fatalField investigationFinal reportCessna 185 · Wilbur, WAIn-flight collision with terrain shortly after takeoff for undetermined reasons.NTSB DFW07LA120Accident · 1 fatalLimited investigationFinal reportCessna U206G · Leeville, LAThe failure of the operator of the powerboat to maintain separation from the departing floatplane.NTSB CHI07CA148Accident · No injuriesData collectionFinal reportCessna A188 · Scotland, SDThe pilot not maintaining adequate airspeed during takeoff, which resulted in an inadvertent stall. Factors contributing to the accident were the sudden wind shift and the low altitude at which the stall occurred.NTSB SEA07CA127Accident · No injuriesData collectionFinal reportCessna A185F · Renton, WAThe pilot's loss of aircraft control during a landing attempt, which resulted in an inadvertent ground loop.NTSB DFW07LA108Accident · Serious injuriesLimited investigationFinal reportCessna A188A · Clinton, OKSeparation of the exhaust stack and resulting vapor lock. A contributing factor was the none suitable terrain for the forced landing.NTSB CHI07FA140Accident · 3 fatalField investigationFinal reportCessna 172N · Sharonville, OHThe inadequate visual lookout of the pilots in both airplanes and their not maintaining clearance from each others airplane during climb.NTSB SEA07LA118Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Kayenta, AZThe overstress separation of both ruddervators during cruise flight. Contributing to the accident was the flight's encounter with turbulence.NTSB ANC07LA035Accident · No injuriesLimited investigationFinal reportCessna A185F · Haines, AKThe main landing gear attachment bolts to the right ski sheared during the landing roll in deep snow, resulting in a nose down, and structural damage to the right wing and aileron.NTSB CHI07LA127Accident · No injuriesLimited investigationFinal reportBeech S35 · Brookfield, MOImproper maintenance by maintenance personnel by not properly torquing cylinder thru-bolts. The loose stud nuts which resulted in the separation of the cylinder and the crop and ditch were factors.NTSB CHI07CA125Accident · Serious injuriesData collectionFinal reportCessna 210D · Hamilton, OHThe pilot's failure to maintain control of the aircraft. Factors contributing to the accident were the stall encountered during the attempted go around and the wind gusts.NTSB LAX07CA132Accident · No injuriesData collectionFinal reportCessna U206-C · Cottonwood, IDThe pilot's misjudgment of distance/speed, which resulted in a overshoot of the runway in tailwind conditions and subsequent nose over. Factors in the accident were the tail wind condition and the short runway.NTSB MIA07LA081Accident · 2 fatalLimited investigationFinal reportCessna U206G · Welaka, FLThe pilot's continued visual flight into instrument meteorological conditions and his failure to maintain clearance from utility poles. Contributing to the accident were the fog and haze.NTSB NYC07CA097Accident · No injuriesData collectionFinal reportCessna A185F · Ashland, METhe pilot's failure to maintain aircraft control while taxiing, which resulted in a nose over. A factor in this accident was the frozen, slush covered lake.NTSB LAX07LA119Accident · No injuriesLimited investigationFinal reportCessna 320E · Stockton, CAThe landing gear collapsed during taxi as a result of incorrect rigging of the landing gear by other maintenance personnel that prevented the landing gear downlock from functioning as designed.NTSB MIA07IA080Incident · No injuriesIncident investigationFinal reportBeech E-55 · Key West, FLFailure of the nose landing gear drag brace due to overload during landing rollout for undetermined reasons. Contributing to the accident was the airplane had not been modified with an improved nose landing gear drag brace.NTSB ATL07LA065Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Woolsey, GAIn-flight fire of the right wing for undetermined reasons.NTSB NYC07CA076Accident · Minor injuriesData collectionFinal reportBellanca 17-30A · Farmingdale, NJThe pilot's failure to verify the amount of fuel onboard before takeoff. Factors in the accident were the airplane being under fueled, the refueler's experience, the airplane's inoperative fuel gauges, unsuitable terrain for landing, and night lighting…NTSB CHI07FA084Accident · 2 fatalField investigationFinal reportBeech 58 · Munster, INThe fuel starvation for an undetermined reason which led to the loss of power on the left engine. Additional causes were the pilot's failure to maintain airspeed which led to his loss of control of the airplane. Factors in the accident were the flight…NTSB MIA07FA056Accident · 1 fatalField investigationFinal reportBeech 95-C55 · Port Orange, FLThe pilot's failure to maintain airspeed during initial climb resulting in inadvertent stall. Contributing to the accident was the pilot's improper positioning of the left fuel selector which resulted in fuel starvation to the left engine.NTSB DFW07FA073Accident · 1 fatalField investigationFinal reportCessna 210K · Lago Vista, TXThe pilot's failure to maintain clearance from terrain. A factor was the pilot's diverted attention with a reported autopilot malfunction.NTSB MIA07LA050Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Fountain, FLA loss of engine power due to a cracked engine exhaust muffler. Contributing to the accident were the inadequate inspection procedures of the muffler system and the routing of the "P" leads wiring for the magnetos.NTSB ATL07FA040Accident · 4 fatalField investigationFinal reportBeech A36 · Hinesville, GAThe pilot's failure to maintain aircraft control resulting in the in-flight breakup of the airplane due to aerodynamic overload. Contributing to the accident were airframe icing and the pilot's impairment by illegal drugs.NTSB NYC07FA056Accident · 1 fatalField investigationFinal reportBeech A36 · Wayne, NJThe pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB ANC07LA014Accident · No injuriesLimited investigationFinal reportCessna 207 · Kipnuk, AKThe pilot's failure to maintain adequate clearance from terrain during the landing roll, which resulted in a collision with a snow berm with the left main landing gear, and subsequent damage to the right wing. Factors contributing to the accident were dark…