NTSB investigations: Continental IO-520 series
4,751 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 ANC99LA096Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKThe total loss of engine power for undetermined reasons. A factor in this accident was the mountainous terrain in which the pilot had to perform a forced landing.NTSB CHI99LA239Accident · No injuriesLimited investigationFinal reportCessna 411 · Troy, MIEngine explosion/fire during start for undetermined reason.NTSB SEA99LA119Accident · No injuriesLimited investigationFinal reportCessna 185 · Renton, WAFailure of the pilot-in-command to maintain directional control after landing, resulting in a ground loop.NTSB ATL99LA106Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Panther Burn, MSThe pilot's failure to maintain clearance that resulted in the in-flight collision with trees. A factor was his diverted attention following the failure of the DGPS.NTSB LAX99LA249Accident · No injuriesLimited investigationFinal reportCessna 185 · Beckwourth, CAThe pilot's inadequate compensation for the wind conditions and subsequent failure to maintain directional control.NTSB FTW99LA180Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30A · Brownfield, TXThe pilot's inadvertent stall while attempting to clear powerlines. Factors were the loss of engine power due to fuel starvation and the pilot's improper use of the fuel tank selector.NTSB NYC99LA156Accident · Serious injuriesLimited investigationFinal reportCessna 185E · East Haddam, CTThe loss of engine power due to water in the fuel system.NTSB ATL99LA101Accident · No injuriesLimited investigationFinal reportCessna A188B · Glen Allan, MSThe improper installation of a nut and bolt assembly by a maintenance personnel that resulted in the in-flight loss of control of the left ailiron.NTSB MIA99WA176Accident · No injuriesForeign investigationCessna 210L · Gt. Harbour Cay, BahamasNTSB LAX99LA219Accident · No injuriesLimited investigationFinal reportBeech A-36 · Van Nuys, CAThe failure of the pilot to verify that the alternator was activated after engine start, subsequently resulting in a total electrical failure; and his inadequate emergency procedures for manual extension of the landing gear following the electrical failure.NTSB DEN99FA093Accident · 1 fatalField investigationFinal reportBeech V35A · Nederland, COThe pilot's intentional and continued flight into instrument meteorological conditions. Factors were his failure to obtain a weather briefing, the existing weather conditions that included snow, hail, obscuration and lightning, and the mountainous terrain.NTSB FTW99LA158Accident · No injuriesLimited investigationFinal reportCessna 210K · Mountain View, ARThe pilot's failure to maintain control during the landing flare/touchdown. Factors were the pilot's delay in aborting the landing and the fence post.NTSB ATL99LA099Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Chapin, SCThe loss of engine power for undetermined reasons. A factor was the collision with a utility wire.NTSB LAX99LA194Accident · No injuriesLimited investigationFinal reportCessna A185F · Elko, NVThe failure of the pilot to adequately compensate for the variable and gusty winds, and, to maintain directional control of the aircraft while landing.NTSB SEA99LA076Accident · No injuriesLimited investigationFinal reportCessna A185E · Othello, WAThe pilot's inadequate compensation for wind conditions after landing. Factors include gusty winds.NTSB NYC99LA114Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Columbus, OHthe failure of the pilot to follow the procedures in the Pilot's Operating Handbook, and the use of tip tanks for level flight only, which resulted in fuel starvation. A factor was the pilot's lack of familiarity with the airplane.NTSB CHI99LA152Accident · No injuriesLimited investigationFinal reportCessna A188B · Lincoln, KSthe altitude/clearance not obtained by the pilot and the unsuitable takeoff area selected by the pilot. Factors to the accident were the high, soft, and wet grass runway.NTSB LAX99LA172Accident · No injuriesLimited investigationFinal reportBeech A36 · San Diego, CAThe pilot's failure to maintain a visual lookout while taxiing resulting in the aircraft's colliding with a runway sign. Contributing factors were dusk light conditions, the sign, and the pilot's diverting his attention to aircraft instrumentation during taxi.NTSB MIA99FA142Accident · 4 fatalField investigationFinal reportCessna 210L · Vero Beach, FLA loss of engine power due to a disconnected throttle/power lever, cable. Also causal was the failure of the mechanic to install a cotter pin in the throttle control cable attach hardware at the throttle control arm, and failure of the company quality control…NTSB ANC99LA049Accident · Minor injuriesLimited investigationFinal reportCessna 185E · Haines, AKThe pilot's inadequate compensation for the gusty crosswind conditions.NTSB LAX99FA150Accident · 2 fatalField investigationFinal reportBeech 36 · San Diego, CAThe pilot's failure to maintain the proper glidepath during an ILS approach. A factor in the accident was the pilot's disregard for the weather reports, which showed the airport as being below landing minimums.NTSB ATL99LA069Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Nashville, TNThe pilot's inflight decision to land on a runway with a strong cross wind, rather then on a runway into the wind. A factor was the strong cross wind conditions.NTSB ATL99LA063Accident · No injuriesLimited investigationFinal reportCessna 185 · Hilton Head, SCThe pilot's inadequate evaluation of weather information that resulted in his failure to maintain directional control during landing. Factors were gusting winds, and a tail wind.NTSB ATL99LA062Accident · No injuriesLimited investigationFinal reportCessna 210 · Opa Locka, FLThe loss of engine power for undetermined reasons.NTSB ATL99LA065Accident · No injuriesLimited investigationFinal reportCessna 206 · Fayetteville, NCThe pilot's failure to maintain directional control during landing. A factor was the crosswind.NTSB CHI99LA111Accident · 1 fatalLimited investigationFinal reportCessna A188B · Atwood, KSThe pilot's failure to maintain clearance from obstacles.NTSB MIA99LA106Accident · No injuriesLimited investigationFinal reportBeech 58 · St CroixThe pilot's failure to extend the landing gear.NTSB DEN99LA056Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Evanston, WYA total loss of engine power for undetermined reasons.NTSB LAX99LA094Accident · No injuriesLimited investigationFinal reportBeech F33 · Prescott, AZA total loss of engine power for undetermined reasons.NTSB MIA99LA081Accident · Minor injuriesLimited investigationFinal reportCessna 210G · Lake Placid, FLa total loss of engine power due to an in-flight separation of the crankshaft, caused by a fatigue crack that originated from the aft fillet radius of the No. 2 main journal, resulting in a forced landing in a field and impact with a tree.NTSB NYC99LA057Accident · No injuriesLimited investigationFinal reportCessna 310R · Monticello, NYThe pilot in command's loss of directional control.NTSB MIA99FA075Accident · 1 fatalField investigationFinal reportCessna 210J · Naples, FLIn-flight collision with water while on base turn to final at night for undetermined reasons.NTSB CHI99FA072Accident · 3 fatalField investigationFinal reportBeech 95-C55 · Pellston, MIthe pilot's failure to maintain proper altitude/clearance on the approach and his flight into known icing conditions. Factors relating to this accident were the pilot flying with known equipment deficiencies, the pilot's physical impairment (alcohol), the…NTSB ATL99LA042Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Hallandale Beac, FLThe loss of engine power for undetermined reasons.NTSB ANC99LA023Accident · No injuriesLimited investigationFinal reportCessna 207 · Chevak, AKThe pilot's continued flight into adverse weather conditions. Factors associated with the accident were freezing rain, an accumulation of ice on the wings and ailerons, and diminished directional control.NTSB ANC99FA021Accident · Minor injuriesField investigationFinal reportCessna 207 · Quinhagak, AKLoss of engine power due to fracture of the engine crankshaft, and the manufacturer's improper manufacturing procedure during engine assembly. Factors associated with the accident were the manufacturer's inadequate quality control standards, trees, and…NTSB MIA99WA123Accident · No injuriesForeign investigationBeech F33A · Crooked Island, BahamasNTSB NYC99WA039Accident · 1 fatalForeign investigationCessna U206G · St John'S, CanadaNTSB FTW99LA051Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Waxahachie, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB MIA99LA040Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Star, NCThe failure of the pilot to use proper short-field landing procedure, resulting in an extended flare and touchdown by the nose wheel and right main wheel simultaneously, and the subsequent loss of directional control and collision with trees.NTSB LAX99LA021Accident · No injuriesLimited investigationFinal reportCessna 185E · Tucson, AZFailure of the pilot to properly secure the seat which subsequently slid back on the takeoff roll and lead to the pilot's loss of aircraft control.NTSB LAX99LA015Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Palmdale, CAThe pilot's improper management of his fuel supply which resulted in fuel starvation. Factors in the accident were the inadequate annual inspection which resulted in fuel siphoning, and a high reading fuel gage.NTSB MIA99LA020Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Jackson, MSThe pilot's failure to ensure the landing gear was down resulting in a wheels up landing.NTSB ATL99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Tellasse, ALThe pilot's failure to maintain clearance from a utility line while conducting a swath run.NTSB MIA98LA255Accident · No injuriesLimited investigationFinal reportCessna A185F · Elizabethton, TNThe failure of the pilot to maintain directional control during the landing roll.NTSB ATL98LA130Accident · No injuriesLimited investigationFinal reportCessna 210L · Orlando, FLA 6-8 inch crack on the right main landing gear strut, which allowed the hydraulic fluid to escape from the system, along with a power pack sequencing valve failure which allowed the main landing gear to fold on landing. A factor in the accident was the…NTSB ANC98LA159Accident · No injuriesLimited investigationFinal reportBeech A36 · New Stuyahok, AKThe pilot's failure to extend the landing gear prior to landing. Factors associated with this accident were the pilot's interference with his normal habit pattern, turbulence, and the crosswind condition during landing.NTSB CHI98FA349Accident · 3 fatalField investigationFinal reportBeech 58 · Oakdale, WIThe installation of the door seal inflation system by company personnel. An additional cause was the emergency procedures not followed by the pilot-in-command. A contributing factor was the trees.NTSB ANC98LA151Accident · No injuriesLimited investigationFinal reportCessna 185F · Fairbanks, AKThe pilot's selection of unsuitable terrain for takeoff and his failure to maintain adequate obstacle clearance.NTSB ANC98LA150Accident · No injuriesLimited investigationFinal reportCessna 207A · Hughes, AKThe pilot's inadequate compensation for the wind conditions, and an inadvertent stall. A factor in the accident was the presence of a tail wind.