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 LAX91LA187Accident · No injuriesLimited investigationFinal reportBeech F33A · Goodyear, AZThe pilot's failure to ensure that the airplane's landing gear was extended by the passenger who he was allowing fly the airplane. A contributing factor related to the pilot's inadequate supervision of the passenger.NTSB FTW91LA062Accident · No injuriesLimited investigationFinal reportCessna A188B · Tipton, OKFailure of the pilot to maintain poroper clearance above obstacles. A factor was the sun glare.NTSB LAX91LA149Accident · Minor injuriesLimited investigationFinal reportBeech V-35-A · Superior, AZVisual flight into instrument meteorological conditions.NTSB ATL91LA071Accident · No injuriesLimited investigationFinal reportBeech F33A · Chamblee, GAThe hole in the airport taxiway, which was created by the erosion of soil beneath the taxiway, and the failure of the airport to inspect and maintain ditches which run beneath the runways and taxiways.NTSB ANC91T#A01Accident · Minor injuriesClass 3Final reportCessna A185F · Galena, AKNTSB FTW91FA049Accident · 2 fatalField investigationFinal reportBeech 36 · New Braunfels, TXThe pilot's disregard for the minimum descent altitude and failure to perform a missed approach. Factors were the pilot's attempt to fly into known adverse weather conditions, low ceiling, rain, and fog.NTSB DEN91LA050Accident · No injuriesLimited investigationFinal reportBeech V35B · Englewood, COThe pilot's premature liftoff and inadvertent stall mush. Factors were: downdrafts, high density altitude, and unsuitable terrain.NTSB CHI91DCQ04Accident · 1 fatalFinal reportCessna A-188 · Harper, KSThe pilot inadvertently stalling the airplane.NTSB ANC91IA039Incident · No injuriesIncident investigationFinal reportCessna U206G · Sparrevohn Afs, AKThe loss of engine power due to the ice in the fuel strainer/gascalator. Contributing was: the inadequate preflight preparation by the pilot, and unsuitable terrain on which to make the forced landing.NTSB LAX91LA114Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Coalinga, CAFuel starvation and the improper use of the fuel selector by the pilot. The rough terrain on which the aircraft landed was a factor in the accident.NTSB DEN91FA037Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Olton, TXThe pilot exceeded the design stress limits of the airframe and the performance of aerobatics at an altitude insufficient for recovery.NTSB NYC91LA062Accident · Minor injuriesLimited investigationFinal reportCessna P206 · Cleveland, OHFatigue failure of the number two propeller blade actuating pin, due to improper installation of the pins and non-compliance with an airworthiness directive (AD 77-13-77).NTSB SEA91LA041Accident · Minor injuriesLimited investigationFinal reportAero Commander 200D · Tooele, UTEngine fuel system blockage due to ice formation in the fuel system during a period of weather temperature extremes. A factor was the lack of suitable terrain for a forced landing.NTSB MIA91WA062Accident · 2 fatalForeign investigationBeech 58 · St. Maarten I., NTNTSB MIA91IA061Incident · No injuriesIncident investigationFinal reportCessna 210M · Lutz, FLFuel line chafing, and in-flight fire caused by shorting of the electrical system which resulted in a forced landing with the landing gear not extended.NTSB NYC91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 210L · New Haven, CTThe failure of the vehicle driver to adequately monitor the radio/traffic pattern. Factors related to the accident were: darkness, the aircraft's loss of electrical power after activating the runway lights and entering the pattern, and the lack of visual…NTSB LAX91LA035Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Fallbrook, CAThe failure of the number 5 cylinder piston connecting rod due to bending and subsequent fatigue fracture. Contributing to the accident was the improper starting procedure accomplished by an unidentified person which resulted in excessive fuel in the cylinder…NTSB NYC91LA021Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Columbus, OHFailure by pilots of the other aircraft to see and alter taxi path to avoid the standing aircraft.NTSB NYC91FA005Accident · 4 fatalField investigationFinal reportBeech V35B · Ottawa, OHFailure of the pilot to follow the proper instrument procedure and maintain the minimum descent altitude (mda) during an approach to the airport at night in instrument meteorological conditions.NTSB SEA91LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210K · Everett, WAA loss of engine power for undetermined reasons.NTSB MIA90LA185Accident · No injuriesLimited investigationFinal reportCessna A188B · Vicksburg, MSFailure of the pilot to avoid a mud hole on the runway during the ground roll to takeoff.NTSB ANC90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Egegik, AKThe improper use of elevator controls by the pilot.NTSB ATL90LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Hertsboro, ALFatigue failure of the propeller blade which resulted from improper overhaul procedures, and the absence of oil in the propeller hub which would allow the detection of blade cracks.NTSB ANC90LA180Accident · No injuriesLimited investigationFinal reportCessna 185 · Upper Colleen, AKThe pilot-in-command's failure to select suitable terrain for landing. Contributing to the accident was the rough and uneven terrain.NTSB ANC90LA175Accident · No injuriesLimited investigationFinal reportCessna 206 · Puntilla Lake, AKAn inadequate preflight.NTSB ANC90LA172Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKFailure of the pilot to obtain or maintain adequate airspeed which resulted in a stall or mush.NTSB SEA90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Lewistown, MTThe pilot did not maintain an adequate lookout while maneuvering which resulted in a collision with a transmission wire.NTSB MIA90WA178Accident · No injuriesForeign investigationBeech 58 · Union Island, St. Vincent & GrenadinesNTSB ANC90FA158Accident · 2 fatalField investigationFinal reportCessna 414 · Sitka, AKImproper planning/decision by the pilot, and his failure to follow IFR procedures and maintain clearance from mountainous terrain.NTSB DEN90DTE05Accident · No injuriesFinal reportCessna 188B · Eckley, COA failure on the part of the pilot in command to maintain adequate terrain clearance.NTSB SEA90FA163Accident · 1 fatalField investigationFinal reportCessna A185F · Wrangell, AKThe pilot did not maintain an adequate airspeed. The pilot's lack of recent experience in the Cessna 185 was a contributing factor.NTSB ANC90LA136Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKFailure of the right main landing gear spring upon landing.NTSB FTW90DRD15Accident · No injuriesFinal reportCessna 188 · Archibald, LAThe power loss for undetermined reasons. A factor was the rough uneven terrain in which the forced landing was performed.NTSB NYC90LA160Accident · 1 fatalLimited investigationFinal reportCessna U206F · Augusta, MEImproper planning/decision by the pilot, and his failure to compensate for wind conditions. The unfavorable wind conditions and rough water were related factors.NTSB LAX90LA257Accident · No injuriesLimited investigationFinal reportCessna A185F · Discovery Bay, CAThe pilot's improper visual lookout to assure the area was clear of boats before departing.NTSB NYC90LA183Accident · No injuriesLimited investigationFinal reportCessna 310R · Mansfield, OHAn unavoidable collision with a deer while taking off which bent the drag brace and prevented it from locking. Factors related to the accident were the night conditions which reduced the pilots visibility to the illuminated area of the landing lights.NTSB DEN90LA156Accident · No injuriesLimited investigationFinal reportCessna 188 · Michigan, NDThe failure of the pilot to maintain proper alignment during landing.NTSB LAX90LA249Accident · No injuriesLimited investigationFinal reportBeech V35B · Big Bear, CAThe fuel starvation due to the pilot's inadvertent selection of an empty fuel tank.NTSB CHI90LA168Accident · No injuriesLimited investigationFinal reportBeech V35B · Lockport, ILThe pilot's failure to maintain aircraft directional control and keep the aircraft on the runway during the landing roll.NTSB LAX90LA243Accident · Minor injuriesLimited investigationFinal reportBeech 95-C55 · Fullerton, CAThe pilot's failure to detect an incorrect rudder trim adjustment, his failure to follow the prescribed pre-takeoff instructions that call for the trim to be adjusted. The collision with the fence and the incorrect rudder trim adjustment were factors in the…NTSB ANC90LA108Accident · No injuriesLimited investigationFinal reportCessna 185 · King Salmon, AKTotal loss of engine power caused by the failure of the piston rod assemblies.NTSB ANC90FA105Accident · 2 fatalField investigationFinal reportCessna 185 · Iliamna, AKThe pilot's failure to follow proper procedures and directives (excessive flaps); failure to operate the airplane within the allowable gross weight limitations; improper compensation for wind conditions and failure to maintain minimum safe flying speed,…NTSB LAX90FA233Accident · Minor injuriesField investigationFinal reportBellanca 17-30A · Ojai, CAStructural damage sustained by the Bellanca, N39843, as a result of encountering wake turbulence during a near-collision with a navy F-14A.NTSB MKC90LA137Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Goddard, KSFuel starvation due to a loose fuel strainer screen. A factor related to this accident was lack of suitable terrain for a forced landing.NTSB FTW90FA125Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Dallas, TXThe initial partial loss of engine power, followed by the total loss of engine power and the striking of a hidden set of transmission wires.NTSB CHI90LA163Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Savoy, ILThe loss of engine power for undetermined reasons and the inadvertent stall during the forced landing.NTSB MIA90IA144Incident · No injuriesIncident investigationFinal reportCessna 210L · Fort Lauderdale, FLIncorrect placement of the retaining ring in the left main landing gear door actuator by the mechanic resulting in the loss of hydraulic fluid. This prevented the gear from extending resulting in the gear up landing.NTSB FTW90LA123Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Mc Allen, TXLoss of engine power for undetermined reasons. The concrete canal that he impacted was a factor.NTSB LAX90LA225Accident · No injuriesLimited investigationFinal reportBellanca BL26 · Santa Ana, CAThe pilot's use of an improper starting technique.NTSB ANC90LA091Accident · No injuriesLimited investigationFinal reportCessna 185 · Chandler, AKThe pilot-in-command's failure to maintain control of the airplane.