NTSB investigations: Continental W670 series
601 cases on aircraft whose registry engine model is Continental W670 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 ('17018'))
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 ('17018'))
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 NYC95FA224Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Marlborough, MAthe Stearman, N89X, pilot's inadequate visual lookout. A factor was the failure of the flight instructor of the Cessna 150, N1766Q, to announce his position in the traffic pattern in accordance with recommended procedures.NTSB ANC95LA143Accident · Serious injuriesLimited investigationFinal reportWaco UPF-7 · Anchorage, AKThe pilot's inadequate preflight planning/preparation, which resulted in an unlocked engine primer and subsequent loss of engine power.NTSB ATL95LA107Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Fayetteville, GAA malfunction of the carburetor needle valve which resulted in fuel starvation to the engine.NTSB SEA95LA109Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Rawlins, WYThe pilot's failure to maintain a proper climb rate. Factors contributing to the accident were the high density altitude and the rising terrain.NTSB NYC95LA021Accident · 2 fatalLimited investigationFinal reportBoeing A-75N1 · Sayville, NYA loss of control in flight by the pilot(s) while maneuvering, with insufficient altitude for recovery.NTSB NYC95LA010Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-17 · Fitchburg, MAThe pilot's failure to adequately compensate for the crosswind condition during landing, which resulted in a ground loop and the subsequent wing tip collision with the runway.NTSB CHI94LA189Accident · 1 fatalLimited investigationFinal reportWaco UPF-7 · Good Hope, ILFailure of the pilot to maintain control of the aircraft, while maneuvering. A factor related to the accident was: the pilot's impairment due to use of a prescription drug that was not approved for use while flying.NTSB CHI94LA188Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · New Paris, INthe pilot's inadequate visual lookout. Factors associated with the accident are a fence post, and the pilot's lack of familiarity with the geographic area (landing environment).NTSB CHI94LA150Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Sandwich, ILthe pilot in command's failure to maintain directional control during a crosswind landing and attempted go around.NTSB SEA94LA110Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Lander, WYPoor in-flight planning decision. Factors to the accident were: whiteout conditions and inadvertent VFR into IMC.NTSB MIA94LA082Accident · No injuriesLimited investigationFinal reportCessna 190 · Fort Lauderdale, FLLocking of the right main landing gear brake for undetermined reasons.NTSB MIA94LA055Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Zellwood, FLInadvertent stall/spin by the pilot-in-command while executing a spiral to landing maneuver during the base to final turn.NTSB FTW94LA054Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Madisonville, TXThe pilot's continued flight into adverse weather. Factors were weather conditions and collision with a sign.NTSB CHI94LA007Accident · Minor injuriesLimited investigationFinal reportBoeing 75N1 · St Paul, MNFailure of the pilot to maintain proper altitude.NTSB CHI93LA357Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Springfield, MOthe disconnection of the primer supply line at the fuel strainer.NTSB CHI93LA349Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Delevan, WIthe excessive use of brakes and rudder by the pilot-in-command. A factor related to the accident was the pilot-in-command's lack of total experience in this type of aircraft.NTSB LAX93LA117Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Hughson, CAThe failure of the intake valve. The soft terrain contributed to this accident.NTSB CHI92LA288Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Belvidere, ILThe pilot's failure to maintain adequate clearance from obstacles during the aborted landing. Related factors are the failure to maintain directional control, and the pilot's lack of total experience in the type of operation.NTSB FTW92FA197Accident · 1 fatalField investigationFinal reportBoeing A75 · Cibolo, TXFailure of the engine crankshaft due fatigue and the resultant collapsing of the left wing.NTSB SEA92LA168Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Brigham City, UTA partial power loss for undetermined reasons and the pilot in command's inability to execute corrective action during the noseover. A factor contributing to the accident was the berm.NTSB LAX92FA257Accident · 2 fatalField investigationFinal reportWaco UPF-7 · Sedona, AZFuel exhaustion due to the pilots inadequate preflight planning and his failure to refuel the airplane prior to departure. Factors in the accident were: 1) the unreliable fuel sight gauges which were contaminated with a tar like residue which may have…NTSB ATL92LA128Accident · Minor injuriesLimited investigationFinal reportBoeing D75N1 · Stockbridge, GAThe improper compensation for the downwind condition by the pilot in command. A factor in the accident was the improper in flight planning to attempt a downwind landing on the short runway with rising terrain by the pilot in command.NTSB DEN92LA063Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Brighton, COThe pilot's inadequate visual lookout.NTSB SEA92LA094Accident · No injuriesLimited investigationFinal reportFairchild 24W-40 · Toledo, WAThe pilot's inadequate compensation for wind conditions resulting in failure to maintain directional control. A factor contributing to the accident was crosswinds.NTSB LAX92LA195Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chino, CAThe pilot's failure to maintain directional control during the landing roll out.NTSB CHI92LA133Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Washington, MOThe pilot in command's improper use of the carburetor heat control.NTSB MIA92LA105Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Deland, FLThe pilot's inadequate compensation for wind conditions.NTSB DEN91LA124Accident · No injuriesLimited investigationFinal reportBoeing A 75N1 · Lordsburg, NMUnexpected encounter with adverse wind (downdraft).NTSB LAX91LA370Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Wallace, CAThe pilot's failure to properly align his airplane with the runway and his failure to maintain directional control during takeoff. Contributing factors related to the presence of rough and downhill terrain adjacent to the runway.NTSB ATL91LA152Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Manning, SCThe pilot's failure to maintain directional control during the takeoff roll, and his failure to abort the takeoff in a timely manner once the airplane had departed the runway surface. A factor in the accident was the pilot's failure to utilize the entire…NTSB NYC91LA176Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Stebensville, PAThe pilot's failure to refuel the airplane, his improper fuel consumption calculations, and his failure to flare the airplane during the forced landing.NTSB CHI91LA194Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Mundelein, ILThe pilot in command's not maintaining visual contact with the previously identified airplane.NTSB LAX91LA250Accident · Minor injuriesLimited investigationFinal reportEagle DW-1 · Stockton, CAFailure of the pilot to maintain an adequate visual outlook to detect power transmission wires in his flight path resulting in an abrupt maneuver and subsequent inadvertent stall.NTSB FTW91LA087Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Horseshoe Bend, ARThe pilot's failure to maintain directional control of the airlane. A factor was the crosswind.NTSB MIA91LA147Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLA momentary loss of engine power due to undetermined reasons.NTSB SEA91LA102Accident · Minor injuriesLimited investigationFinal reportBoeing A-75 · Seattle, WAThe pilot did not maintain directional control during the landing roll. The factor to the accident was: the pilot's remedial action was inadequate.NTSB LAX91FA094Accident · 2 fatalField investigationFinal reportBoeing N2S-3 · Sonoma, CAThe pilot-in-command/cfi's performance of a low altitude aerobatic maneuver from which he failed to recover. Factors which contributed to the accident related to the pic's improper inflight decision, poor judgment, and his psychological condition.NTSB NYC90LA194Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Burdett, NYThe pilot did not properly compensate for the cross wind and failed to maintain directional control during takeoff.NTSB MIA90LA157Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Plant City, FLEngine failure for undetermined reasons resulting in the forced landing.NTSB FTW90LA130Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · San Antonio, TXPilot's failure to maintain adequate speed. Contributing to the accident was the momentary power loss.NTSB CHI90LA156Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Aurora, ILThe pilot's inadequate compensation for wind conditions, and his not maintaining proper directional control on landing.NTSB MIA90LA122Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Daytona Beach, FLThe failure of the pilot of the tailwheel equipped airplane to maintain a visual lookout while taxiing.NTSB MKC90LA085Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Pleasant Grove, ARImproper use of carburetor heat by the pilot, which resulted in carburetor icing. The weather (carburetor icing condition) was a related factor.NTSB MIA90IA036Incident · No injuriesIncident investigationFinal reportWaco UPF-7 · Key West, FLThe failure of the pilot to adequately watch for parked aircraft after becoming distracted.NTSB MIA89LA245Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLInadequate visual lookout by the Waco pilot, which resulted in his misjudgement of clearance between his aircraft and the Cessna 172 and a subsequent collision.NTSB MIA89FA237Accident · 1 fatalField investigationFinal reportEagle DW-1-220 · Oklawaha, FLThe loss of control on the ground during the landing roll for undetermined reasons.NTSB LAX89LA231Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Sacramento, CAThe partial blockage of the engine induction system which resulted from improper maintenance.NTSB MKC89LA128Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Creve Coeur, MOImproper use of the carburetor heat by the pilot and carburetor ice. Contributing factors were: carburetor icing conditions, high obstructions and terrain conditions (corn crop).NTSB NYC89LA145Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Erwinna, PALoss control and collision with trees due to failure of the student pilot to compensate for the wind and lack of supervision by the CFI.NTSB MIA89LA160Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Fort Lauderdale, FLFailure of the pilot to maintain directional control which resulted in an inadvertent ground swerve. The crosswind and the pilot's improper use of brakes were contributing factors.