Skip to content

NTSB investigations: Continental R670-SERIES series, CA

18 cases on aircraft whose registry engine model is Continental R670-SERIES 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 per year

19642026

Where

Latest cases

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."eventStateOrRegion" = 'CA' 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 ('17016')) 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.\"eventStateOrRegion\" = 'CA' 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 ('17016'))
  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" = 'CA' 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 ('17016'))
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 GAA15CA001Accident · No injuriesData collectionFinal reportWaco UPF 7 · Rio Vista, CAThe pilot's failure to maintain directional control during the landing roll.Mar 6, 2015 · N32063 · Substantial damage NTSB LAX99LA041Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Vacaville, CAThe pilot's inadequate compensation for the existing variable wind conditions and his failure to maintain directional control.Nov 25, 1998 · N59734 · Substantial damage NTSB LAX97LA016Accident · No injuriesLimited investigationFinal reportWaco QCF · Big Bear City, CAthe pilot's improper response to a perceived in-flight emergency by abruptly retarding the throttle and failing to properly flare the airplane during the aborted takeoff. The pilot's improper perception of the source of smoke was a related factor.Oct 12, 1996 · N11481 · Substantial damage NTSB LAX91LA256Accident · No injuriesLimited investigationFinal reportWeaver WACO-ASO · Montague, CAFailure of the pilot to maintain directional control of the airplane and improper use of the brakes.Jun 9, 1991 · N4W · Substantial damage NTSB LAX91LA102Accident · No injuriesLimited investigationFinal reportCurtiss-Wright E-4000 · Watsonville, CAThe inadequate design and length of the tailwheel assembly cable.Feb 17, 1991 · N9048 · Substantial damage NTSB LAX91LA087Accident · No injuriesLimited investigationFinal reportWaco UIC · Santa Paula, CAThe brittle fracture of the left brake master cylinder tread end causing loss of directional control.Feb 3, 1991 · N13408 · Substantial damage NTSB LAX91LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Watsonville, CAThe failure of the pilots of both aircraft to see and avoid the other.Oct 12, 1990 · N24815 · 2 aircraft · Substantial damage NTSB LAX86LA299Accident · No injuriesLimited investigationFinal reportBoeing N25-3 · Van Nuys, CAA Boeing N2S-3 nosed over on landing while on a local VFR flight. The pilot indicated that he had logged a total of 2.4 hours in this make and model aircraft all within the previous ninety days. The pilot stated that on his last approach, the speed was too…Jul 7, 1986 · N5106N · Substantial damage NTSB LAX80DVA19Accident · No injuriesClosedBoeing A75 · Madera, CAFeb 28, 1980 · N56833 · Substantial damage NTSB LAX79FVG71Accident · 1 fatalClosedStearman A75N1 · Fair Oaks, CAAug 24, 1979 · N48784 · Destroyed NTSB OAK78DVG66Accident · No injuriesClosedBoeing A75 · Lower Lake, CAJul 24, 1978 · N707R · Substantial damage NTSB LAX75FUQ02Accident · Serious injuriesClosedFokker DR-1 · Tehachapi, CAJul 14, 1974 · N41BC · Substantial damage NTSB OAK74DVG15Accident · No injuriesClosedBoeing A75N1 · Auburn, CASep 29, 1973 · N707X · Substantial damage NTSB OAK72DVG79Accident · No injuriesClosedBoeing A75N-1 · Franklin, CAJun 5, 1972 · N707X · Substantial damage NTSB OAK71DVD52Accident · No injuriesClosedBoeing PT-17 · Richmond, CAJun 19, 1971 · N707R · Substantial damage NTSB LAX70F0083Accident · No injuriesClosedStinson L-5 · Elsinore, CAAug 10, 1969 · N63253 · Substantial damage NTSB OAK66F0097Accident · No injuriesClosedFairchild WM-62 · Salinas, CAAug 15, 1965 · N48888 · Substantial damage NTSB UNK65X0321Accident · No injuriesClosedBoeing A75N1 · Santa Monica, CAOct 18, 1964 · N63588 · Substantial damage