Skip to content

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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" DESC

Run 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 SEA94LA242Accident · Minor injuriesLimited investigationFinal reportCessna P206D · Lopez, WAA worn throttle control lever.Sep 18, 1994 · N8761Z · Substantial damage NTSB CHI94LA333Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Elkhart, INthe pilot's improper use of the fuel selector position which resulted in fuel starvation.Sep 17, 1994 · N732HS · Substantial damage NTSB BFO94FA160Accident · 1 fatalField investigationFinal reportBeech A36 · Barstow, MDThe pilot's failure to maintain clearance from the tower.Sep 17, 1994 · N60360 · Destroyed NTSB LAX94LA365Accident · No injuriesLimited investigationFinal reportCessna 210L · Payson, AZAnimals on the runway.Sep 16, 1994 · N210LX · Substantial damage NTSB SEA94LA234Accident · No injuriesLimited investigationFinal reportCessna A185F · Conrad, MTThe cfi's failure to assure an adequate inspection of the aircraft, including the proper engagement and function of the rudder pedals, prior to the flight.Sep 7, 1994 · N5387H · Substantial damage NTSB CHI94LA314Accident · No injuriesLimited investigationFinal reportCessna 188B · Oakdale, ILmisalignment of the number one connecting rod during major overhaul. Factors were the subsequent scoring and fatigue failure of the crankshaft.Sep 7, 1994 · N731SV · Substantial damage NTSB SEA94LA232Accident · No injuriesLimited investigationFinal reportCessna 210D · Paris, IDAn inadvertent wheels up landing.Sep 3, 1994 · N3759Y · Substantial damage NTSB MIA94LA203Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Egypt, MSPilot-in-command's inadvertent stall during an agricultural turn resulting in the loss of control and subsequent in flight collision with terrain.Aug 30, 1994 · N4811R · Substantial damage NTSB FTW94FA282Accident · Minor injuriesField investigationFinal reportCessna 402 · Harlingen, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. Factors were a partial loss of power on all engines due to worn and fouled spark plugs and inadequate maintenance by company maintenance personnel, aircraft weight beyond limitations,…Aug 28, 1994 · N966JW · Substantial damage NTSB ATL94LA161Accident · No injuriesLimited investigationFinal reportCessna 207 · Nags Head, NCThe failure of the mixture control cable which resulted in a loss of engine power.Aug 20, 1994 · N1670U · Substantial damage NTSB CHI94LA291Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sublette, KSimproper preflight planning by the pilot. Factors associated with the accident were the delayed jettisoning of the airplane's hopper load and the inability of the airplane to climb.Aug 19, 1994 · N133MC · Substantial damage NTSB ANC94LA102Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Bethel, AKThe pilot misjudged the strength of the tailwind and did not perform a go-around in a timely fashion so as to avoid landing the airplane halfway down the strip. Factors in the accident were the wet landing strip and the tailwind.Aug 9, 1994 · N756NG · Substantial damage NTSB FTW94LA264Accident · No injuriesLimited investigationFinal reportCessna A188B · Sherman, TXThe pilot's failure to refuel the airplane. A factor was the leaking fuel caps.Aug 8, 1994 · N4826R · Substantial damage NTSB ANC94LA099Accident · No injuriesLimited investigationFinal reportCessna 206 · King Salmon, AKThe pilot's failure to use the available longer portion of the lake for the takeoff run.Aug 6, 1994 · N5120X · Substantial damage NTSB ANC94LA097Accident · No injuriesLimited investigationFinal reportCessna 206 · Mosquito Flats, AKThe missing number 6 cylinder piston pin cap and the subsequent failure of the number 6 cylinder connecting rod cap. Also, the lack of suitable landing area for the forced landing.Aug 5, 1994 · N5200X · Substantial damage NTSB CHI94LA254Accident · Serious injuriesLimited investigationFinal reportBeech 33 · Wichita, KSthe pilot's inadequate management of the fuel which resulted in fuel starvation.Aug 1, 1994 · N7960M · Substantial damage NTSB CHI94LA252Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Flushing, MIthe pilot's improper touchdown position on the runway. A factor associated with the accident is the moving vehicle on the adjacent road.Jul 31, 1994 · N90074 · Substantial damage NTSB MIA94LA187Accident · No injuriesLimited investigationFinal reportCessna 210-M · Orlando, FLThe improper installation of a nose gear actuator hydraulic line by an unknown person that bent it at installation. Contributing to the accident was the failure of the line allowing all hydraulic fluid to vent overboard disabling the normal and emergency gear…Jul 29, 1994 · N761VX · Substantial damage NTSB CHI94LA249Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Waterford, MIundetermined.Jul 29, 1994 · N93572 · Substantial damage NTSB ANC94LA092Accident · No injuriesLimited investigationFinal reportCessna A185F · Anchorage, AKThe pilot misjudged the landing flare. A factor in the accident was the glassy water.Jul 24, 1994 · N1758R · Substantial damage NTSB ANC94LA088Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe failure of the throttle control lever arm as a result of the improper 100 hour inspection by company maintenance personnel.Jul 18, 1994 · N4685F · Substantial damage NTSB ANC94LA083Accident · No injuriesLimited investigationFinal reportCessna 206 · Noatak, AKThe pilot's selection of unsuitable landing area. A factor was a 'cut bank' in the landing area.Jul 16, 1994 · N8287Q · Substantial damage NTSB CHI94FA222Accident · 4 fatalField investigationFinal reportBeech A36 · Wichita, KSthe pilot's attempt to take off into known adverse weather and the subsequent stall. Factors were the thunderstorm, the tailwind, and the excessive airplane gross weight and aft center of gravity.Jul 7, 1994 · N107JT · Destroyed NTSB LAX94LA283Accident · Minor injuriesLimited investigationFinal reportMeyers ME 200 · Chico, CAA separation of the exhaust pipe from the cabin heat control valve and the lack of insulation on electrical wiring between the ammeter and the avionics bus.Jul 6, 1994 · N7MV · Substantial damage NTSB ANC94IA075Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Juneau, AKThe failure of the local controller to exercise his responsibility to have each aircraft adjust its flightpath to remain clear of the other, and the failure of the pilot of the Cessna 185 to maintain adequate visual separation from the Boeing 737.Jul 2, 1994 · N769AS · 2 aircraft · No damage NTSB BFO94LA117Accident · No injuriesLimited investigationFinal reportBeech F33A · Quarryville, PAThe pilot's failure to touchdown at the proper point and his delayed remedial action. A factor related to the accident was a tailwind.Jun 26, 1994 · N6728X · Substantial damage NTSB ANC94LA067Accident · No injuriesLimited investigationFinal reportCessna 185 · Kassan Bay, AKThe pilot's inadequate compensation for the wind. Factors were the rough water and the gusty wind condition.Jun 8, 1994 · N4471R · Substantial damage NTSB ANC94LA059Accident · No injuriesLimited investigationFinal reportCessna 185F · Fairbanks, AKThe pilot's failure to maintain directional control during takeoff.May 29, 1994 · N93769 · Substantial damage NTSB CHI94FA157Accident · 4 fatalField investigationFinal reportBellanca 17-30A · Camdenton, MOThe pilot's failure to maintain control of the aircraft. A factor was his lack of experience flying in actual instrument flight conditions.May 14, 1994 · N4226B · Destroyed NTSB BFO94T#001Accident · No injuriesClass 3Final reportCessna 210 · Augusta, MEApr 20, 1994 · N6428C · Substantial damage NTSB ANC94LA048Accident · No injuriesLimited investigationFinal reportCessna A185F · Paxson, AKThe pilot-in-command did not maintain proper clearance from the snow berm. A factor in the accident was the snow berm.Apr 8, 1994 · N8191Q · Substantial damage NTSB SEA94LA095Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Spangle, WAThe pilot not maintaining clearance from the fence. A factor in the accident was the dusk light conditions.Apr 3, 1994 · N6746B · Substantial damage NTSB SEA94LA093Accident · No injuriesLimited investigationFinal reportCessna 210D · Cobalt, IDThe pilot selected unsuitable terrain for landing. Factors in the accident were: the wet runway and rising terrain that precluded a go-around.Mar 30, 1994 · N3820Y · Substantial damage NTSB MIA94LA102Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Key West, FLThe failure of the pilot-in-command to ensure the aircraft was at an adequate altitude above the water before initiating a turn which resulted in the right float contacting the water during the turn and the aircraft cartwheeling.Mar 26, 1994 · N5087R · Substantial damage NTSB SEA94LA089Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Gillette, WYProcedures/directives were not followed and partial failure of the landing gear selector switch. A factor to the accident was an inoperative gear warning system.Mar 21, 1994 · N9415S · Substantial damage NTSB LAX94FA171Accident · 2 fatalField investigationFinal reportCessna 206 · Show Low, AZthe pilot's intentional VFR flight into known adverse IMC weather conditions. Inadequate preflight planning, dark night operations, and weather conditions that included low ceilings and mountain obscuration were factors in the accident.Mar 20, 1994 · N5222U · Destroyed NTSB ANC94LA034Accident · No injuriesLimited investigationFinal reportCessna 206 · New Koliganek, AKThe pilot's failure to maintain control of the airplane. Factors in the accident were the strong crosswinds and the icy/snow covered taxi surface.Feb 11, 1994 · N60491 · Substantial damage NTSB LAX94LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Valley Springs, CAthe pilot's failure to ensure that the landing gear was in the correct configuration for a water landing.Feb 10, 1994 · N4833C · Substantial damage NTSB ANC94LA031Accident · No injuriesLimited investigationFinal reportCessna 207 · Kwigillingok, AKThe pilot-in-command's failure to maintain the proper airspeed which resulted in an inadvertent stall and his failure to initiate a go-around when the runway environment was not clearly defined. A factor in the accident was the fog.Feb 8, 1994 · N6470H · Substantial damage NTSB SEA94FA055Accident · 2 fatalField investigationFinal reportBeech S35 · Ashland, ORPoor in-flight planning/decision. Factors to the accident were: clearance was not maintained and poor supervision.Feb 3, 1994 · N50VT · Destroyed NTSB MIA94LA065Accident · No injuriesLimited investigationFinal reportOconnell LAZER-200 · St. Petersburg, FLThe failure of the pilot of the conventional gear airplane to maintain a visual lookout for other aircraft.Feb 3, 1994 · N199J · 2 aircraft · Substantial damage NTSB FTW94LA079Accident · Minor injuriesLimited investigationFinal reportCessna T210H · Mcallen, TXThe pilot's inadvertent stall of the airplane. Factors were the pilot's failure to refuel and the resultant fuel exhaustion.Feb 3, 1994 · N6914R · Destroyed NTSB CHI94LA075Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Chesterfield, MOThe pilot-in-command's poorly planned approach. A factor in the accident was the loss of engine power for an undetermined reason.Jan 31, 1994 · N810BP · Substantial damage NTSB MIA94LA063Accident · No injuriesLimited investigationFinal reportBeech 35 · Leesburg, FLThe pilot-in-command's poor evaluation of the weather and failure to remain in visual meteorological conditions, resulting in an in-flight collision with water.Jan 29, 1994 · N599LG · Substantial damage NTSB ATL94LA045Accident · No injuriesLimited investigationFinal reportCessna 310R · Memphis, TNThe failure of the pilot of N2069C to follow the ATC directive to give way to N3844C, and the inadequate visual lookout by the pilot of N2069C. A factor was the dark night lighting condition at the time of the accident.Jan 28, 1994 · N3844C · 2 aircraft · Substantial damage NTSB CHI94LA065Accident · No injuriesLimited investigationFinal reportCessna 210M · Festus, MOImproper planning/decision by the pilot. Factors related to the accident were: the icy runway, crosswind and snowbank.Dec 19, 1993 · N761AG · Substantial damage NTSB ATL94FA028Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Lagrange, GAWas the pilot's failure to correct a known low battery condition before departing, which resulted in a loss of electrical power during an instrument approach. Factors were the dark night and the low scattered cloud layer.Dec 10, 1993 · N4195B · Destroyed NTSB ANC94LA022Accident · No injuriesLimited investigationFinal reportCessna 207 · Tuntutuliak, AKFailure of the pilot to maintain proper alignment during the takeoff roll. Factors related to the accident were: darkness and the snow berm along the edge of the runway.Dec 3, 1993 · N36CF · Substantial damage NTSB FTW94LA040Accident · No injuriesLimited investigationFinal reportCessna A185F · Maybell, COThe pilot's failure to ascertain the condition of the landing area. The snow covered condition of the runway was a factor.Nov 30, 1993 · N6613N · Substantial damage NTSB LAX94T#A02Accident · No injuriesClass 3Final reportCessna C206 · Chinle, AZNov 19, 1993 · N4517M · Substantial damage