NTSB investigations: Continental W670 series
32 cases on aircraft whose registry engine model is Continental W670 series, where the defining event was Loss of control on ground. 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 per year
| 2008 | 2 |
|---|---|
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 3 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 3 |
Where
Open the mapLatest cases
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230'))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '230'))
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 WPR24LA250Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1/N2S-3 · Hollister, CAThe pilot’s loss of directional control on landing, which resulted in a nose over.NTSB ANC24LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 190 · San Luis Obispo, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a failure of the right main landing gear and subsequent ground loop.NTSB ERA24LA125Accident · No injuriesClass 4 · LimitedFinal reportWaco UPF-7 · Atlanta, GAThe pilot’s failure to maintain directional control during the landing in gusting crosswind conditions.NTSB CEN23LA156Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Evansville, INThe pilot’s failure to engage the tailwheel lock before landing which resulted in the loss of control and ground loop.NTSB WPR23LA050Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Long Beach, CAThe pilot’s failure to maintain directional control during landing.NTSB WPR23LA014Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Petaluma, CAThe pilot’s failure to maintain directional control during landing in gusting wind.NTSB WPR21LA126Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 190 · Camarillo, CAThe failure of the pilot to maintain directional control of the airplane during the landing roll which resulted in a runway excursion and subsequent nose over.NTSB WPR20CA271Accident · No injuriesClass 4 · Data collectionFinal reportRyan ST3KR · Port Townsend, WAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with vegetation.NTSB ERA20CA175Accident · No injuriesClass 4 · Data collectionFinal reportWaco QCF · Shirley, NYThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a nose over.NTSB ERA18TA179Accident · Minor injuriesFinal reportStearman B75 · Lexington, NCThe pilot’s overapplication of the wheel brakes during landing, which resulted in a nose-over.NTSB GAA18CA354Accident · No injuriesData collectionFinal reportBoeing B75 · Waukegan, ILThe flight instructor’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control.NTSB GAA18CA286Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Eden Prairie, MNThe pilot’s failure to maintain directional control during landing in crosswind conditions.NTSB GAA18CA079Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Chino, CAThe pilot’s failure to maintain directional control during a touch-and-go landing.NTSB GAA18CA050Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Rosamond, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA290Accident · No injuriesData collectionFinal reportCessna 190 · Prescott, AZThe pilot’s use of excessive speed during a right turn from the runway to the taxiway, which resulted in a loss of directional control.NTSB GAA16CA206Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Spring, TXThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion and substantial damage to the lower left wing spar.NTSB GAA16CA049Accident · No injuriesData collectionFinal reportCurtiss Wright Travel Air · Carlsbad, CAThe pilot's failure to maintain directional control during the landing roll, resulting in a ground-loop, and substantial damage to the right wing and wing strut.NTSB GAA15CA082Accident · Minor injuriesData collectionFinal reportBoeing PT 17 · Williamson, GAThe pilot landed off the right side of the runway resulting in a collision with terrain.NTSB ERA15CA162Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · St Marys, PAThe pilot's failure to maintain directional control while landing in a gusty crosswind, which resulted in a runway excursion and a nose over.NTSB ERA14CA280Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Reading, PAThe pilot's loss of control while landing the tailwheel-equipped airplane in a quartering tailwind. A factor in the accident was the changing wind conditions.NTSB WPR14CA221Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · McCall, IDLoss of directional control during landing rollout due to a wind disturbance, which resulted in a runway veeroff and impact with a ditch.NTSB WPR13CA324Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Canby, ORThe pilot's failure to maintain directional control during the landing rollout in gusting wind conditions.NTSB WPR13CA146Accident · Minor injuriesData collectionFinal reportWaco UPF-7 · Paso Robles, CAThe pilot's failure to adequately compensate for crosswind conditions, which resulted in a loss of directional control during the landing roll.NTSB CEN12CA405Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Glencoe, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ERA12CA334Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Weirsdale, FLThe pilot's failure to maintain directional control while landing in a gusty variable crosswind.NTSB WPR11CA251Accident · No injuriesData collectionFinal reportBoeing B75N1 · Torrance, CAThe pilot's inadequate compensation for wind conditions.NTSB WPR10CA290Accident · No injuriesData collectionFinal reportWaco UKC-S · Seattle, WAThe pilot’s inadequate compensation for the crosswind condition, resulting in a loss of directional control during the landing roll.NTSB ERA10LA063Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright Travel AIR · Fort Myers, FLThe pilot's improper recovery from a bounced landing and failure to maintain directional control, which resulted in a ground loop. Contributing to the accident was the pilot's minimal experience in the airplane make and model.NTSB ERA09CA424Accident · No injuriesData collectionFinal reportWhite New Standard · Rhinebeck, NYThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was a depression near the edge of the turf runway that the airplane encountered during the takeoff roll.NTSB WPR09CA328Accident · No injuriesData collectionFinal reportBoeing A75N1 · Gig Harbor, WAThe pilot's inadequate compensation for the crosswind and failure to maintain directional control.NTSB NYC08LA247Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control of the airplane while landing in a quartering tailwind.NTSB MIA08CA107Accident · No injuriesData collectionFinal reportWaco GXE · Provincetown, MAThe pilot's failure to maintain directional control while landing.