NTSB investigations: Continental W670 series, MA
10 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 per year
| 1966 | 1 |
|---|---|
| 1976 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2008 | 2 |
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.\"eventStateOrRegion\" = 'MA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'MA' AND c."eventCountry" = 'USA'
AND 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 NYC08CA274Accident · No injuriesData collectionFinal reportBoeing E75 · Sterling, MAThe owner/pilot's improper flare. Contributing to the accident was the pilot-in-command's inadequate remedial action.NTSB MIA08CA107Accident · No injuriesData collectionFinal reportWaco GXE · Provincetown, MAThe pilot's failure to maintain directional control while landing.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 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 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 NYC86LA008Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Norwood, MAAccording to the pilot, during the takeoff climb the aircraft did not develop sufficient power to maintain altitude. The pilot turned the aircraft to the right in an attempt to return to the airport. During the approach to the airport, the aircraft collided…NTSB NYC85LA085Accident · No injuriesLimited investigationFinal reportBoeing JB-75 · Marston Mills, MAThe acft nosed over after contacting an utility pole during an overrun landing. The acft touched down aprx 1/2 way down the rwy and the plt applied brakes, however, braking action was poor because of the wet grass rwy. The acft skidded off the end of the rwy…NTSB NYC84LA220Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Orange, MAThe plt stated that he was giving local sightseeing flights. He indicated that a 'wide' gentleman and a 'moderate' size gentleman boarded the acft. The plt moved the throttle to ensure clearance but found one of the pax restricted the movement slightly. The…NTSB NYC76FNA51Accident · No injuriesClosedStearman A75 · Norwood, MANTSB NYC67F0402Accident · No injuriesClosedCessna 190 · Newburyport, MA