Skip to content

NTSB investigations: Continental C125 series

199 cases on aircraft whose registry engine model is Continental C125 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17011')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17011'))
  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 ('17011'))
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 MIA71DLD58Accident · No injuriesClosedGlobe GC-1B · Silver Spgs, FLMar 28, 1971 · N78055 · Substantial damage NTSB MIA71FKG54Accident · Serious injuriesClosedGlobe GC-1B · Stone Mountain, GADec 19, 1970 · N78146 · Substantial damage NTSB CHI71FBA21Accident · Serious injuriesClosedGlobe GC-1B · Monticello, INDec 18, 1970 · N78119 · Substantial damage NTSB CHI71FGG14Accident · No injuriesClosedGlobe GC-1B · Lima, OHSep 27, 1970 · N3760K · Substantial damage NTSB MIA71FLA13Accident · No injuriesClosedGlobe GC-1B · Tallahassee, FLSep 10, 1970 · N90333 · Substantial damage NTSB LAX71AL010Accident · 2 fatalClosedGlobe GC-1B · Morristown, AZSep 5, 1970 · N3317K · Destroyed NTSB FTW71DQG26Accident · No injuriesClosedGlobe GC-1B · Big Spring, TXAug 8, 1970 · N78118 · Substantial damage NTSB MKC71DCA10Accident · No injuriesClosedGlobe GC-1B · Lesterville, MOAug 2, 1970 · N80970 · Substantial damage NTSB LAX71DUJ10Accident · No injuriesClosedGlobe GC-1B · Showlow, AZJul 1, 1970 · N78246 · Substantial damage NTSB IAD70AI060Accident · 1 fatalClosedGlobe GC-1B · Blue Ridge, VAMay 16, 1970 · N80792 · Destroyed NTSB FTW70F0319Accident · Minor injuriesClosedGlobe GC-1B · Abilene, TXNov 30, 1969 · N80833 · Substantial damage NTSB MIA70F0203Accident · No injuriesClosedGlobe GC-1B · Gallatin, TNOct 4, 1969 · N2424B · Substantial damage NTSB CHI70F0348Accident · No injuriesClosedGlobe GC-1B · Delavan, WIAug 23, 1969 · N78137 · Substantial damage NTSB SEA70D0084Accident · Minor injuriesClosedCallair A-3 · Goldendale, WAAug 18, 1969 · N2911V · Substantial damage NTSB OAK70F0057Accident · No injuriesClosedGlobe GC-1A · Reno, NVJul 13, 1969 · N2419B · Substantial damage NTSB SEA70A0002Accident · 2 fatalClosedGlobe GC-1B · Winlock, WAJul 10, 1969 · N78155 · Destroyed NTSB OAK70D0071Accident · No injuriesClosedSwift GC-1B · Sheltr Cove, CAJun 29, 1969 · N78209 · Substantial damage NTSB LAX69F0350Accident · Serious injuriesClosedGlobe GC-1B · Tucson, AZMay 7, 1969 · N78038 · Destroyed NTSB NYC69F0325Accident · No injuriesClosedSwift GC1B · Forty Fort, PAJan 26, 1969 · N2336B · Substantial damage NTSB CHI69A0052Accident · 1 fatalClosedGlobe GC-1B · Reed City, MINov 17, 1968 · N78061 · Destroyed NTSB LAX69D0292Accident · Serious injuriesClosedGlobe GC-1B · Casa Grande, AZOct 28, 1968 · N90369 · Substantial damage NTSB MKC69F0235Accident · No injuriesClosedGlobe GC-1B · Washburn, IAOct 26, 1968 · N3764K · Substantial damage NTSB MKC69F0213Accident · No injuriesClosedGlobe GC-1B · Washburn, IAOct 12, 1968 · N3764K · Substantial damage NTSB NYC69F0186Accident · No injuriesClosedGlobe GC-1B · Medford, NJAug 31, 1968 · N599Z · Substantial damage NTSB CHI69D0241Accident · Minor injuriesClosedGlobe GC-1B · Galion, OHAug 18, 1968 · N3744K · Substantial damage NTSB CHI69D0076Accident · No injuriesClosedGlobe GC-1B · Benton, ILJun 3, 1968 · N78181 · Substantial damage NTSB NYC69D0019Accident · No injuriesClosedGlobe GC-1B · Titusville, PAApr 27, 1968 · N78063 · Substantial damage NTSB DEN68D0138Accident · No injuriesClosedGlobe GC-1B · Aurora, CONov 10, 1967 · N3246K · Substantial damage NTSB MIA68D0247Accident · No injuriesClosedGlobe GC-1B · Kennesaw, GAOct 20, 1967 · N90310 · Substantial damage NTSB CHI68F0578Accident · No injuriesClosedGlobe Swift GC-1B · W Lafayette, INSep 24, 1967 · N80792 · Substantial damage NTSB OAK68D0137Accident · No injuriesClosedGlobe GC-1B · Columbia, CASep 17, 1967 · N78324 · Substantial damage NTSB MKC68D0297Accident · No injuriesClosedGlobe GC-1B · Harrisonville, MOSep 16, 1967 · N3843K · Substantial damage NTSB LAX68D0088Accident · No injuriesClosedGlobe GC-1B · Ramona, CAAug 10, 1967 · N78246 · Substantial damage NTSB LAX68D0070Accident · No injuriesClosedGlobe GC-1B · Marana, AZJul 29, 1967 · N78296 · Substantial damage NTSB DEN68D0033Accident · No injuriesClosedTemco D-16 · Colo.Springs, COJul 18, 1967 · N2311B · Substantial damage NTSB MKC68D0004Accident · No injuriesClosedGlobe GC-1B · Missouri City, MOJun 15, 1967 · N80947 · Substantial damage NTSB OAK67D0328Accident · No injuriesClosedGlobe GC-1B · San Jose, CAMay 15, 1967 · N3321K · Substantial damage NTSB LAX67F0384Accident · Minor injuriesClosedGlobe GC-1B · Van Nuys, CAMay 3, 1967 · N3749K · Substantial damage NTSB OAK67D0292Accident · No injuriesClosedGlobe GC-1B · San Carlos, CAApr 17, 1967 · N2419B · Substantial damage NTSB MIA67F0516Accident · Serious injuriesClosedGlobe GC-1B · St Augustine, FLApr 15, 1967 · N80646 · Destroyed NTSB FTW67F0537Accident · Minor injuriesClosedGlobe GC-1B · Stillwater, OKApr 13, 1967 · N3346K · Substantial damage NTSB CHI67D0608Accident · No injuriesClosedGlobe GC-1A · Monee, ILMar 25, 1967 · N80748 · Substantial damage NTSB NYC67F0609Accident · No injuriesClosedGlobe GC-1B · Latrobe, PAMar 23, 1967 · N78217 · Substantial damage NTSB LAX67F0255Accident · No injuriesClosedGlobe GC-1B · Hawthorne, CAJan 20, 1967 · N78248 · Substantial damage NTSB SEA67F0234Accident · No injuriesClosedGlobe GC-1B · Portland, ORJan 15, 1967 · N3761K · Substantial damage NTSB LAX67A0060Accident · 1 fatalClosedGlobe GC-1B · Moorpark, CADec 18, 1966 · N3818K · Substantial damage NTSB MIA67F0301Accident · No injuriesClosedTemco GC-1B · Agricola, MSNov 17, 1966 · N3856K · Substantial damage NTSB OAK67D0161Accident · No injuriesClosedGlobe GC-1B · Las Vegas, NVNov 15, 1966 · N3880K · Substantial damage NTSB MIA67F0244Accident · No injuriesClosedGlobe GC-1B · Brooksville, FLOct 23, 1966 · N80682 · Substantial damage NTSB CHI68D0039Accident · Minor injuriesClosedGlobe GC-1B · Polo, ILSep 9, 1966 · N78082 · Substantial damage