NTSB investigations: Continental IO-520 series
105 cases on aircraft whose registry engine model is Continental IO-520 series, where the defining event was Loss of control in flight. 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240'))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '240'))
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 ERA15LA357Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Wilmington, NCThe pilot's improper loading of the airplane, which resulted in a sudden pitch up during the attempted takeoff, the pilot’s subsequent loss of directional control, and an aerodynamic stall.NTSB ERA15FA325Accident · 1 fatalField investigationFinal reportCessna 310R · Titusville, FLThe pilot's continued flight into known convective weather conditions, which resulted in the airplane's encounter with thunderstorms and the pilot's subsequent loss of airplane control during a missed approach. Contributing to the accident was the failure of…NTSB CEN15LA144Accident · No injuriesLimited investigationFinal reportBeech 58 · Denver, COThe pilot’s failure to maintain airplane control during a rejected takeoff from a slush-covered runway at night.NTSB CEN15LA137Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Andrews, TXThe pilot's failure to note that icing conditions existed in the airport area despite having received that information in a preflight briefing, which resulted in his flight into an area of icing and the subsequent loss of airplane control due to ice…NTSB WPR15FA088Accident · 2 fatalField investigationFinal reportBeech 36 · Mountain Pass, CAAn in-flight loss of control for reasons that could not be determined based on available information.NTSB CEN15FA081Accident · 1 fatalField investigationFinal reportBeech V35A · Seagoville, TXThe pilot’s loss of control and subsequent impact with terrain in instrument meteorological conditions.NTSB ERA15WA026Accident · 1 fatalForeign investigationCessna 310R · Governors Harbor, BahamasNTSB CEN14LA345Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Las Vegas, NMThe pilot's loss of airplane control during an aborted landing. Contributing to the accident was the pilot's inadequate preflight planning, which resulted in his attempt to land on a runway closed by a notice to airmen and the loss of engine power due to fuel…NTSB ERA14LA218Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Middlesboro, KYThe pilot's failure to maintain airplane control during the landing approach due to his diverted attention to the partially opened main cabin door and the unsecured dog. Contributing to the accident was the pilot's failure to securely latch the main cabin…NTSB WPR14CA162Accident · No injuriesData collectionFinal reportCessna 207 · Shaw Island, WAThe pilot's loss of directional control during the landing flare with a gusting tailwind.NTSB CEN14FA185Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Albany, OHThe pilot’s loss of airplane control during the approach to landing.NTSB ERA14FA120Accident · 2 fatalField investigationFinal reportCessna 210L · Clay, ALThe pilot's failure to maintain control of the airplane while being vectored to intercept the localizer during night instrument meteorological conditions (IMC). Contributing to the accident was the operator's inadequate dispatch procedures, which did not…NTSB WPR14CA110Accident · Minor injuriesData collectionFinal reportBeech V35A · Globe, AZThe pilot's inadequate glide path and failure to maintain adequate airspeed during final approach, which resulted in an aerodynamic stall.NTSB ERA14FA068Accident · 3 fatalField investigationFinal reportCessna 310R · Jacksonville, FLThe pilot’s failure to maintain airplane control during a missed approach in night instrument meteorological conditions due to spatial disorientation and a lack of instrument proficiency.NTSB WPR14CA009Accident · Serious injuriesData collectionFinal reportBeech A36 · Tilden, TXThe pilot's decision to continue the takeoff from a wet and soft airstrip which resulted in his failure to maintain adequate airspeed and aircraft control during the takeoff initial climb.NTSB ERA13FA348Accident · 3 fatalField investigationFinal reportBeech D55 · Conway, SCThe pilot's loss of airplane control, which resulted from his failure to follow the loss of single engine power checklist procedures after a total loss of right engine power due to fuel starvation. Contributing to the accident was the pilot's improper…NTSB ERA13CA338Accident · No injuriesData collectionFinal reportCessna 210M · Shirley, NYThe pilot's loss of control during an aborted takeoff as a result of his failure to properly configure the elevator trim prior to flight.NTSB ANC13CA002Accident · No injuriesData collectionFinal reportCessna U206F · Buckland, AKThe pilot's loss of airplane control during final approach in gusty wind conditions.NTSB CEN12FA291Accident · 1 fatalField investigationFinal reportBeech V35B · Las Vegas, NMThe pilot’s loss of airplane control for reasons that could not be determined because postaccident examination revealed no evidence of preimpact anomalies that would have precluded normal operation.NTSB CEN12FA271Accident · 2 fatalField investigationFinal reportBeech S35 · Lake in the Hills, ILThe pilot's excessive bank angle while on approach to land, which resulted in an inadvertent aerodynamic stall and spin.NTSB WPR12FA184Accident · 3 fatalField investigationFinal reportCessna A185F · Blanding, UTThe pilot's failure to maintain airplane control during low-level maneuvering flight. Contributing to the pilot’s death was the lack of a timely emergency rescue response due to the lack of effective emergency signal transmissions from both the airplane’s…NTSB ERA12FA262Accident · 1 fatalField investigationFinal reportBeech 58 · Calhoun, KYThe failure of the pilot to maintain airplane control after experiencing a loss of power from the left engine due to water contamination of the fuel system. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane and…NTSB CEN12FA210Accident · 1 fatalField investigationFinal reportBeech E-55 · Broken Bow, NEThe pilot’s failure to maintain airspeed and subsequent loss of airplane control during a single-engine landing approach. Contributing to the accident was the pilot's improper fuel management during cruise flight, which resulted in an initial loss of power in…NTSB ANC12FA014Accident · Minor injuriesField investigationFinal reportCessna U206G · Nanwalek, AKThe pilot’s decision to takeoff from a contaminated runway with unfavorable wind conditions, and his failure to maintain airspeed during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the operator’s inadequate…NTSB CEN12LA061Accident · Serious injuriesLimited investigationFinal reportCessna 401A · Gladewater, TXThe pilot’s failure to maintain control of the airplane during the landing and attempted go-around in a gusty crosswind.NTSB ANC12LA002Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Kwigillingok, AKThe pilot's failure to abort the takeoff when he realized the airplane could not attain sufficient takeoff and climb performance and his improper decision to depart from an airport where night operations were prohibited.NTSB CEN12CA064Accident · No injuriesData collectionFinal reportCessna 210F · Phillipsburg, KSThe pilot’s improper recovery from a bounced landing.NTSB ERA12FA007Accident · 1 fatalField investigationFinal reportCessna 207A · Matinicus Island, METhe pilot’s failure to maintain airplane control during the approach after encountering a gusty crosswind, which resulted in an accelerated stall and uncontrolled descent.NTSB CEN11CA502Accident · No injuriesData collectionFinal reportCessna A188B · Devils Lake, NDThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in a stall during the aerial application.NTSB WPR11LA305Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Nogales, AZThe pilot did not maintain airplane control during the initial climb.NTSB CEN11LA452Accident · Minor injuriesLimited investigationFinal reportCessna A188A · Estelline, SDThe pilot’s failure to maintain control of the airplane during takeoff for undetermined reasons because the pilot did not recall the accident.NTSB ERA11FA258Accident · 1 fatalField investigationFinal reportCessna 210D · Altavista, VAThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s lack of experience in actual night instrument conditions.NTSB CEN11FA302Accident · 4 fatalField investigationFinal reportBeech 58 · Topeka, KSThe pilot failed to maintain control of the airplane while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot’s minimal experience flying in actual instrument conditions.NTSB ERA11FA185Accident · 1 fatalField investigationFinal reportCessna 310R · Smyrna, TNThe pilot's improper response to a known autopilot pitch divergence anomaly. Contributing to the accident was the pilot's decision to perform a test flight on a system for which he lacked a complete working knowledge.NTSB CEN11CA208Accident · No injuriesData collectionFinal reportBeech 58 · Prospect Heights, ILThe pilot's inadequate flare, which resulted in a hard landing.NTSB WPR11FA090Accident · 2 fatalField investigationFinal reportBeech S35 · Chester, CAThe pilot's loss of control while maneuvering to land, most likely due to spatial disorientation.NTSB ERA11FA074Accident · 1 fatalField investigationFinal reportBeech A36 · Theodore, ALThe pilot's failure to maintain aircraft control while maneuvering at night in deteriorating weather conditions due to spatial disorientation. Contributing to the accident was the pilot's failure to obtain a weather briefing.NTSB ERA10FA404Accident · 2 fatalField investigationFinal reportBeech 58 · Saltsburg, PAThe pilot’s loss of control of the airplane during low-airspeed airwork and his failure to promptly recover the airplane from the aerodynamic stall, which resulted in a spin. Contributing to the accident were the pilot and certified flight instructor’s…NTSB CEN10FA320Accident · 2 fatalField investigationFinal reportBeech A36 · Lidderdale, IAThe pilot's decision to initiate the flight in marginal weather conditions and his loss of aircraft control.NTSB WPR10FA228Accident · 1 fatalField investigationFinal reportCessna U206G · Yuma, AZThe pilot's loss of situational awareness and failure to maintain aircraft control while maneuvering at low altitude. Contributing to the accident was glare from the rising sun.NTSB ERA10FA246Accident · 2 fatalField investigationFinal reportBeech 58 · Bear Branch, KYThe pilot's improper in-flight planning/decision, his continued flight into adverse weather (icing conditions), and failure to maintain an adequate airspeed during the emergency descent.NTSB WPR09LA432Accident · Serious injuriesLimited investigationFinal reportCessna P206B · Truckee, CAThe pilot’s failure to maintain adequate airspeed for flight, which resulted in an aerodynamic stall and subsequent impact with the ground. Contributing to the accident was the intermittent failure of the stall warning system due to a contaminated switch.NTSB CEN09CA429Accident · Minor injuriesData collectionFinal reportCessna A188B · Elwood, NEThe pilot's inability to maintain a climb after takeoff due to wind shift or downdraft.NTSB CEN09CA336Accident · No injuriesData collectionFinal reportBeech F33A · Midland, TXThe pilot's improper flare resulting in a hard landing. Contributing to the accident was the inadequate oversight of the flight by the instructor pilot.NTSB CEN09CA321Accident · No injuriesData collectionFinal reportCessna U206C · Brainerd, MNThe pilot's failure to maintain aircraft control while landing in gusty winds.NTSB WPR09FA112Accident · 3 fatalField investigationFinal reportBeech A36 · Avalon, CAThe pilot’s failure to follow the published instrument departure procedures during the climb to cruise, and loss of control in instrument meteorological conditions. Contributing to the accident was the pilot’s lack of total experience in instrument…NTSB ANC09FA001Accident · 2 fatalField investigationFinal reportCessna U206C · Anchorage, AKA loss of engine power during takeoff/initial climb for an undetermined reason, and the pilot's decision to make an abrupt and steep low altitude turn toward an intersecting runway, resulting in an aerodynamic stall and loss of aircraft control.NTSB LAX08FA300Accident · 1 fatalField investigationFinal reportBeech A36 · Carlsbad, CAThe pilot's failure to maintain control during the instrument approach and attempted go-around.NTSB CHI08CA225Accident · Serious injuriesData collectionFinal reportAero Commander 200D · Tecumseh, MIThe pilot flaring too high, and his inadvertent pilot-induced oscillation during the landing flare/touchdown. Contributing to the accident was the collapse of the nose landing gear.NTSB LAX08FA244Accident · 2 fatalField investigationFinal reportCessna A185F · Shelton, WAThe pilot's failure to attain and maintain adequate airspeed during initial climb, which resulted in an aerodynamic stall.