Skip to content

NTSB investigations: Continental A&C65 series, WA

104 cases on aircraft whose registry engine model is Continental A&C65 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, newest first

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" = 'WA' 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 ('17003')) 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\" = 'WA' 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 ('17003'))
  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" = 'WA' 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 ('17003'))
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 SEA83LA106Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Cle Elum, WAThe acft collided with a power line while flying low over a river. Reportedly the student pilot was buzzing some rafterson the yakima river when the acft collided with a power line about 25 feet AGL. The powerline was downed by the impact and the acft right…May 21, 1983 · N71836 · Substantial damage NTSB SEA83LA071Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Everett, WAThe pilot collided with a parked aircraft while taxiing for takeoff. The weather was VMC and the taxiways were clear. The pilot said the right wing of his aircraft struck the left wing of the parked aircraft and the moving aircraft swung around into the other…Apr 1, 1983 · N44025 · Substantial damage NTSB SEA82DYE03Accident · No injuriesClosedLuscombe 8A · Friday Harbor, WANov 29, 1981 · N45651 · Substantial damage NTSB SEA81DYE29Accident · No injuriesClosedPiper J-3 · Bainbridge Isl, WAMay 12, 1981 · N51565 · Substantial damage NTSB SEA80DYE49Accident · No injuriesClosedAeronca 7AC · Kent, WAAug 3, 1980 · N3011E · Substantial damage NTSB SEA80FA017Accident · 1 fatalClosedAeronca 7AC · Stevenson, WAJan 23, 1980 · N83586 · Destroyed NTSB SEA79DYP39Accident · Minor injuriesClosedTaylorcraft DC-65 · Mead, WAJul 23, 1979 · N57833 · Substantial damage NTSB SEA79FYM22Accident · Minor injuriesClosedPiper J3C-65 · Camas, WAMar 24, 1979 · N1326N · Substantial damage NTSB SEA79FA025Accident · 2 fatalClosedTaylorcraft BC-65 · Orting, WAMar 17, 1979 · N23633 · Destroyed NTSB SEA78FYP09Accident · Serious injuriesClosedTaylorcraft BC12D · Othello, WAJan 14, 1978 · N43271 · Substantial damage NTSB SEA77FA035Accident · 2 fatalClosedTaylorcraft L-2B · Yelm, WAMay 30, 1977 · N50290 · Destroyed NTSB SEA77FYE18Accident · Minor injuriesClosedLuscombe 8A · Alderwood Mnr, WAMay 15, 1977 · N1289K · Substantial damage NTSB SEA77DYM31Accident · No injuriesClosedPiper J-3 · Yacolt, WAMay 14, 1977 · N42448 · Destroyed NTSB SEA77DYM28Accident · Minor injuriesClosedAeronca 7AC · Vancouver, WAApr 11, 1977 · N82960 · Substantial damage NTSB SEA77FYP17Accident · Minor injuriesClosedAeronca 11AC · Harrah, WAJan 20, 1977 · N9791E · Substantial damage NTSB SEA77DYG07Accident · No injuriesClosedTaylorcraft BL-12 · Wilson Creek, WAOct 26, 1976 · N29875 · Substantial damage NTSB SEA76FYE33Accident · No injuriesClosedLuscombe 8A · Maple Valley, WAApr 4, 1976 · N1202B · Substantial damage NTSB SEA76DYE27Accident · No injuriesClosedAeronca 11AC · Waldron Island, WAMar 1, 1976 · N9448E · Substantial damage NTSB SEA76FYC14Accident · No injuriesClosedLuscombe 8A · Vancouver, WAAug 26, 1975 · N2267K · Substantial damage NTSB SEA74DYG45Accident · No injuriesClosedAeronca 7AC · Walla Walla, WAJun 6, 1974 · N84607 · Substantial damage NTSB SEA74DYE24Accident · No injuriesClosedLuscombe 8A · Auburn, WAOct 17, 1973 · N28461 · Substantial damage NTSB SEA73DYE38Accident · Minor injuriesClosedAeronca 7AC · Maple Valley, WAJun 17, 1973 · N2492E · Substantial damage NTSB SEA73DYE34Accident · No injuriesClosedTaylorcraft BC12-D · Bellevue, WAMay 17, 1973 · N95514 · Substantial damage NTSB SEA73ASO13Accident · 1 fatalClosedLuscombe 8A · Ellensburg, WANov 28, 1972 · N1170B · Destroyed NTSB SEA72FYG44Accident · Serious injuriesClosedTaylorcraft BC1265 · Warden, WAJun 4, 1972 · N36240 · Destroyed NTSB SEA72FYG09Accident · Minor injuriesClosedLuscombe 8A · Newport, WASep 5, 1971 · N28443 · Substantial damage NTSB SEA71FWD18Accident · No injuriesClosedAeronca 7AC · Fircrest, WAOct 13, 1970 · N1229E · Substantial damage NTSB SEA71FWG23Accident · 1 fatalClosedTaylorcraft BC12-D · Lowden, WASep 28, 1970 · N96265 · Destroyed NTSB SEA71FWG22Accident · No injuriesClosedPiper J3C-65 · Coulee Dam, WASep 27, 1970 · N3591K · Substantial damage NTSB SEA71FWA15Accident · Minor injuriesClosedAeronca 7AC · Orchards, WASep 6, 1970 · N81933 · Substantial damage NTSB SEA71AS012Accident · No injuriesClosedLuscombe 8A · Bremerton, WAAug 30, 1970 · N28480 · 2 aircraft · Substantial damage NTSB SEA70AS032Accident · 1 fatalClosedAeronca 7AC · Snohomish, WAFeb 8, 1970 · N83800 · 2 aircraft · Substantial damage NTSB SEA70AS029Accident · 1 fatalClosedLuscombe 8A · Mead, WAJan 31, 1970 · N71395 · Destroyed NTSB SEA70D0085Accident · No injuriesClosedLuscombe 8A · Snohomish, WASep 7, 1969 · N28436 · Substantial damage NTSB SEA70D0040Accident · No injuriesClosedTaylorcraft BC-65 · Colville, WAAug 17, 1969 · N21223 · Substantial damage NTSB SEA70F0005Accident · No injuriesClosedAeronca 7AC · Kent, WAMay 31, 1969 · N2943E · Substantial damage NTSB SEA68D0325Accident · No injuriesClosedAeronca 7AC · Edmonds, WAMay 18, 1968 · N83800 · Substantial damage NTSB SEA68D0318Accident · No injuriesClosedAeronca 7AC · Deer Park, WAMay 11, 1968 · N2273E · Substantial damage NTSB SEA68F0253Accident · Serious injuriesClosedPiper J3C-65 · Pomeroy, WAMar 2, 1968 · N6951H · Substantial damage NTSB SEA68D0264Accident · No injuriesClosedTaylorcraft BC-65 · Vantage, WAFeb 25, 1968 · N23668 · Substantial damage NTSB SEA68F0196Accident · No injuriesClosedLuscombe 8A · Renton, WANov 2, 1967 · N28425 · Substantial damage NTSB SEA68D0105Accident · No injuriesClosedLuscombe 8A · Deer Park, WAAug 28, 1967 · N28833 · Substantial damage NTSB SEA68F0070Accident · No injuriesClosedTaylorcraft BC12-D · Bellevue, WAJul 12, 1967 · N95896 · Substantial damage NTSB SEA68F0028Accident · No injuriesClosedAeronca 7AC · Snohomish, WAApr 15, 1967 · N84842 · Substantial damage NTSB SEA67D0103Accident · No injuriesClosedMooney M-18 · Easton, WAAug 21, 1966 · N4180 · Substantial damage NTSB SEA67D0001Accident · No injuriesClosedAeronca 7AC · Ocean Shores, WAApr 17, 1966 · N84312 · Substantial damage NTSB SEA66D0257Accident · No injuriesClosedAeronca 7AC · Spanaway, WAMar 22, 1966 · N2132E · Substantial damage NTSB SEA66F0182Accident · Minor injuriesClosedTaylorcraft DC0-65 · Kent, WADec 11, 1965 · N49174 · Substantial damage NTSB SEA66F0176Accident · Minor injuriesClosedAeronca 7AC · Vancouver, WANov 17, 1965 · N81933 · Substantial damage NTSB SEA66F0115Accident · No injuriesClosedAeronca 11AC · Bellevue, WAAug 22, 1965 · N9500E · Substantial damage