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 IAD03CA057Accident · Minor injuriesData collectionFinal reportBoeing A75N1(PT17) · Sutton, WVThe pilot's failure to abort the takeoff in a timely manner. Factors included the high density altitude conditions, and the pilot's lack of familiarity with the airplane's high density altitude performance characteristics.NTSB NYC03LA115Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman D75-N1 · Avis, PAA loss of engine power due to carburetor ice. A factor in this accident were weather conditions favorable to carburetor ice.NTSB FTW03LA144Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Houston, TXThe pilot's failure to maintain directional control while landing.NTSB ATL03LA079Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75L3 · Gainesville, GAThe pilot's failure to maintain directional control during the landing roll resulting in an inadvertent ground loop.NTSB SEA03LA062Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air C-4000 · Florence, ORPilot's failure to maintain directional control during the landing roll. Factors include rough terrain.NTSB MIA03CA083Accident · No injuriesData collectionFinal reportCessna 190 · Lakeland, FLThe pilot's inadequate compensation for wind and his failure to maintain directional control. A related factor was the crosswind.NTSB FTW03LA108Accident · No injuriesLimited investigationFinal reportWaco UKS-7 · El Paso, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the crosswind.NTSB CHI02LA222Accident · Serious injuriesLimited investigationFinal reportWhite New Standard D-25 · Oshkosh, WIThe partial loss of engine power due to carburetor icing. Factors to the accident include the weather conditions conducive to carburetor icing and the transmission wire.NTSB FTW02LA212Accident · No injuriesLimited investigationFinal reportCessna 190 · Albuquerque, NMThe pilot's failure to maintain aircraft control. A contributing factor was the crosswind.NTSB NYC02LA141Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Dayton, OHThe inadequate visual lookout by the pilot of the Kitfox. Factors related to the accident were the non-radio equipped Waco, and the hazy visual conditions.NTSB NYC02LA140Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Bardstown, KYThe pilot's inadequate preflight inspection, which resulted in fuel contamination and subsequent loss of engine power. A factor in this accident was that the wing tank fuel drains were wire closed and could not be used.NTSB NYC02LA111Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Toughkenamon, PAThe pilot's failure to maintain directional control while landing, a factor was the gusting wind conditions.NTSB SEA02LA038Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Creswell, ORThe pilot's failure to maintain directional control on landing resulting in the aircraft leaving the runway environment, crossing a ditch and nosing over. Contributing factors were variable winds reported by the pilot and the ditch.NTSB FTW01FA095Accident · 2 fatalField investigationFinal reportCessna 190 · Lurton, ARthe pilot's continued VFR flight into IMC, which resulted in spatial disorientation and the ensuing loss of aircraft control while in cruise flight. Contributory factors were the haze and fog weather conditions.NTSB DEN01LA069Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Heber, UTUncommanded locking of the right brake, resulting in loss of control and nose over during landing.NTSB MIA01LA019Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLThe failure of the pilot to maintain directional control during landing with a quartering tail wind, resulting in the aircraft nosing over and coming to rest inverted.NTSB MIA01LA010Accident · No injuriesLimited investigationFinal reportJim Price Pitts Special S · Indiantown, FLThe failure of the pilot of N56JP, during landing rollout, to see and avoid N49713, who was turning off the runway after landing from the opposite direction, resulting in the 2 aircraft colliding on the runway.NTSB NYC01LA011Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Warrenton, VAThe pilot's improper recovery from a bounced landing.NTSB NYC00LA204Accident · No injuriesLimited investigationFinal reportBoeing PT17 · Easton, MDThe pilot's failure to maintain aircraft control.NTSB IAD00LA062Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75-N1 · Atwater, OHLoss of total engine power due to a fractured crankshaft.NTSB CHI00LA195Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman A75N1(PT17) · Windsor, MOfuel exhaustion and the pilot abruptly applying normal brakes during the landing roll. Factors relating to this accident were the precautionary landing, and the pilot's inadequate in-flight planning/ decision.NTSB NYC00LA197Accident · Serious injuriesLimited investigationFinal reportFairchild M-62C · Carthage, NYthe pilot's improper decision to depart with obstacles ahead which exceeded the climb capability of the airplane. Factors were the grass runway, and trees at the departure end of the runway.NTSB NYC00LA180Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Bally, PAThe pilot's failure to maintain control of the airplane after an aborted takeoff.NTSB ATL99LA124Accident · No injuriesLimited investigationFinal reportCessna 190 · Enterprise, ALThe fatigue failure of the main landing gear spring.NTSB NYC99LA158Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Marston Mills, MAThe inadvertent control interference of the airplane's brakes by the passenger. A factor related to the accident was the pilot in commands insufficient passenger briefing.NTSB IAD99LA050Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman PT17 · Lock Haven, PAthe pilot's improper inflight decision to fly at an inadequate altitude and his improper visual lookout which resulted in a collision with wires.NTSB CHI99LA158Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman PT-27 · Grainfield, KSThe pilot's improper in-flight decision and failure to maintain adequate clearance with the ground.NTSB LAX99LA007Accident · Minor injuriesLimited investigationFinal reportCessna 190 · Lost Hills, CAA loss of engine power due to fatigue failure of the number 4 cylinder articulating rod.NTSB LAX98LA279Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Big Bear, CAThe pilot's encounter with an unfavorable wind condition, which caused the aircraft to descend at a rate that exceeded the aircraft's climb capability.NTSB MIA98LA217Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLA loss of engine power due to undetermined reasons, resulting in an inadvertent stall at too low an altitude to allow recovery.NTSB MIA98LA147Accident · No injuriesLimited investigationFinal reportWaco 10 GXE · Americus, GAThe pilot's failure to maintain directional control and his improper compensation for wind. Contributing was a crosswind.NTSB FTW98LA168Accident · No injuriesLimited investigationFinal reportBoeing A75N (PT-17) · Grand Junction, COFailure by the pilot to maintain control of the aircraft during landing roll. Factors were variable winds and the pilot's lack of recent experience in make and model.NTSB ATL98LA057Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Chamblee, GAthe pilot's inadequate compensation for wind conditions and excessive application of braking action, which resulted in an on-ground loss-of-control and a nose over. Related factors were: the pilot's selection of the wrong runway, and the crosswind condition.NTSB LAX98LA087Accident · No injuriesLimited investigationFinal reportCessna 195 · Carefree, AZThe pilot's misjudging the wind direction and his selection of the wrong runway for the landing attempt.NTSB LAX98LA074Accident · No injuriesLimited investigationFinal reportCessna 195 · Long Beach, CAThe pilot's failure to maintain directional control during the landing, which led to a ground loop and a resultant overload failure of the right main landing gear attach points.NTSB ANC97LA101Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Eagle, AKThe pilot's inadequate recovery from a bounced landing and his inadequate in-flight planning/decision making during an aborted landing.NTSB CHI97LA186Accident · Minor injuriesLimited investigationFinal reportHulliberger Starduster II · Berrien Springs, MIthe failure of the landing gear axle due to fatigue.NTSB MIA97LA149Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Huntersville, NCThe pilot's failure to maintain a visual lookout on landing rollout, resulting in an on-ground collision with a known obstacle (ditch) and subsequent nose over.NTSB MIA97FA142Accident · 2 fatalField investigationFinal reportBoeing Stearman N2S-4 · Apex, NCThe pilot-in-command's ostentatious display by performing an aerobatic maneuver with inadequate altitude.NTSB MIA97LA130Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Lake Wales, FLThe partial loss of engine power for undetermined reasons.NTSB SEA97LA102Accident · No injuriesLimited investigationFinal reportBoeing E75 · Spokane, WAThe pilot-in-command's inadequate application of crosswind controls during landing rollout. Factors were gusty crosswinds.NTSB MIA97LA062Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Sanibel, FLA partial loss of engine power (rough running engine) for undetermined reason.NTSB ATL96LA110Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer 164 · Bainbridge, GAThe pilot's misjudgment of the clearance from the trees during the swath run that resulted in the collision.NTSB FTW96FA234Accident · 4 fatalField investigationFinal reportFairchild KR-31 · Bartlesville, OKThe failure of each pilot-in-command to maintain visual lookout. Factors were: the lack of each pilot-in-command obtaining/maintaining communication with the control tower, and inadequate lookout by each pilot-rated passenger, the inadequate…NTSB LAX96LA201Accident · No injuriesLimited investigationFinal reportBoeing-Brown E75NL · Columbia, CAthe pilot's failure to maintain directional control during the landing rollout.NTSB NYC96LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Toms River, NJThe loss of engine power for undetermined reasons.NTSB FTW96LA107Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Bernal, NMthe pilot's improper planning/decision, including his failure to maintain sufficient altitude/clearance from mountainous terrain to compensate for altitude deviations that resulted from mountain wave/wind conditions. Factors relating to the accident were: the…NTSB LAX96LA066Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Chino, CAthe pilot's failure to see and avoid light poles. A poorly planned approach was a factor.NTSB MIA96LA018Accident · Minor injuriesLimited investigationFinal reportBoeing E75N1 · Wauchula, FLA total loss of engine power due to worn serrated teeth on the valve timing gear and intermediate camshaft drive gear which prevented the valve train and generator from operating. A factor was the lack of suitable terrain for the forced landing.NTSB NYC95LA231Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Staten Island, NYFailure of the propeller blade due to fatigue, which resulted in severe vibration, subsequent separation of the engine, and a forced landing.