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 CHI67F0167Accident · No injuriesClosedGlobe GC-1B · Lafayette, INAug 15, 1966 · N78119 · Substantial damage NTSB LAX67D0072Accident · No injuriesClosedGlobe GC-1B · Wasco, CAAug 8, 1966 · N78155 · Substantial damage NTSB NYC67D0282Accident · No injuriesClosedGlobe GC-1B · Croton, NYAug 6, 1966 · N2350B · Substantial damage NTSB NYC67D0140Accident · No injuriesClosedGlobe GC-1B · Colts Neck, NJJul 20, 1966 · N80862 · Substantial damage NTSB NYC67F0085Accident · No injuriesClosedGlobe GC-1B · Fairfield, NJJun 20, 1966 · N90359 · Substantial damage NTSB CHI67F0016Accident · No injuriesClosedTemco GC1B · Ann Arbor, MIJun 19, 1966 · N2386B · Substantial damage NTSB DEN66D0352Accident · No injuriesClosedSwift GC1B · Wilcox, AZMay 20, 1966 · N3331K · Substantial damage NTSB OAK66D0259Accident · No injuriesClosedGlobe GC-1B · Sacramento, CAApr 30, 1966 · N3224K · Substantial damage NTSB OAK66D0277Accident · No injuriesClosedGlobe GC-1B · San Jose, CAApr 13, 1966 · N3827K · Substantial damage NTSB SEA66F0297Accident · No injuriesClosedGlobe Swift GC-1B · Mulino, ORApr 6, 1966 · N3366K · Substantial damage NTSB FTW66F0627Accident · Minor injuriesClosedGlove GC1B · Morgan, TXApr 6, 1966 · N78136 · Substantial damage NTSB NYC66F0674Accident · Serious injuriesClosedGlobe GC-1B · Covington, VAApr 1, 1966 · N90316 · Substantial damage NTSB LAX66F0349Accident · No injuriesClosedGlobe GC-1B · San Fernando, CAMar 9, 1966 · N3346K · Substantial damage NTSB FTW66D0592Accident · No injuriesClosedGlobe GC-1B · Laporte, TXMar 9, 1966 · N711E · Substantial damage NTSB MIA66D0408Accident · No injuriesClosedSwift GC-1B · Memphis, TNFeb 3, 1966 · N78290 · Substantial damage NTSB OAK66D0239Accident · No injuriesClosedGlobe D-16 · San Carlos, CAJan 30, 1966 · N2419B · Substantial damage NTSB CHI66D0526Accident · No injuriesClosedGlobe 125 · Franklin, INJan 16, 1966 · N3333K · Substantial damage NTSB NYC66F0195Accident · No injuriesClosedGlobe GC-1B · Johnstown, NYAug 22, 1965 · N78023 · Substantial damage NTSB CHI66F0508Accident · No injuriesClosedGlobe GC-1B · Marissa, ILAug 15, 1965 · N78181 · Substantial damage NTSB MIA66F0090Accident · No injuriesClosedGlobe GC-1B · Forest, MSJul 24, 1965 · N78088 · Substantial damage NTSB LAX66D0099Accident · No injuriesClosedGlobe GC-1B · Santa Ana, CAJul 16, 1965 · N78170 · Substantial damage NTSB LAX66F0061Accident · No injuriesClosedGlobe GC-1B · Upland, CAMay 26, 1965 · N78007 · Substantial damage NTSB FTW65D0019Accident · No injuriesClosedGlobe GC-1B · Kingsville, TXApr 11, 1965 · N78276 · Substantial damage NTSB OAK65F0023Accident · No injuriesClosedGlobe GC-1B · Colusa, CAMar 3, 1965 · N3245K · Substantial damage NTSB LAX65F0051Accident · No injuriesClosedGlobe GC-1B · Thermal, CAFeb 3, 1965 · N78077 · Substantial damage NTSB UNK65X1380Accident · No injuriesClosedGlobe GC1B · Miami, FLFeb 1, 1965 · N78323 · Substantial damage NTSB LAX65D0092Accident · No injuriesClosedGlobe GC-1B · Hemet, CAJan 29, 1965 · N3772K · Substantial damage NTSB MKC65F0005Accident · No injuriesClosedGlobe GC1B · Salina, KSJan 19, 1965 · N90372 · Substantial damage NTSB SEA65F0004Accident · Minor injuriesClosedSwift GC-1B · Troutdale, ORJan 16, 1965 · N3761K · Substantial damage NTSB UNK65X1243Accident · No injuriesClosedSwift GC-1B · Forty Fort, PAJan 6, 1965 · N2336B · Substantial damage NTSB UNK65X1039Accident · No injuriesClosedGlobe GC1B · Purcell, OKDec 18, 1964 · N3398K · Substantial damage NTSB UNK65X1019Accident · No injuriesClosedGlobe GC1B · Lexington, NCDec 15, 1964 · N78243 · Substantial damage NTSB UNK65X0194Accident · No injuriesClosedGlobe GC1B · Powell, TNOct 8, 1964 · N3767K · Substantial damage NTSB UNK64X3937Accident · No injuriesClosedGlobe GC1B · Citra, FLSep 12, 1964 · N80712 · Substantial damage NTSB UNK64X2499Accident · No injuriesClosedGlobe Swift GC1B · Leesburg, VAJun 26, 1964 · N77757 · Substantial damage NTSB UNK64X2035Accident · No injuriesClosedGlobe Swift Gcib · Mobile, ALMay 30, 1964 · N3719K · Substantial damage NTSB UNK64X1962Accident · No injuriesClosedTemco Swift GC1B · Ansonia, CTMay 26, 1964 · N2350B · Substantial damage NTSB UNK64X1759Accident · 1 fatalClosedGlobe GC-1A · Santa Monica, CAMay 13, 1964 · N78087 · Destroyed NTSB UNK64X1731Accident · Serious injuriesClosedGlobe GC1B · Bayport, NYMay 11, 1964 · N113H · Destroyed NTSB UNK64X1543Accident · No injuriesClosedGlobe Swift GC1B · Knoxville, TNMay 1, 1964 · N78230 · Substantial damage NTSB UNK64X1373Accident · No injuriesClosedGlobe Swift GC1B · Hampshire, ILApr 19, 1964 · N78279 · Substantial damage NTSB UNK64X1358Accident · No injuriesClosedGlobe Swift GC1B · New Haven, CTApr 18, 1964 · N711M · Substantial damage NTSB UNK64X1193Accident · 2 fatalClosedSwift GC1B · Mt Laguna, CAApr 5, 1964 · N2371B · Destroyed NTSB UNK64X1192Accident · No injuriesClosedSwift GC1B · Latrobe, PAApr 5, 1964 · N78320 · Substantial damage NTSB UNK64X1108Accident · No injuriesClosedSwift GC1B · Denver, COMar 30, 1964 · N3842K · Substantial damage NTSB UNK64X0428Accident · Serious injuriesClosedStubbe · Pueblo, COFeb 1, 1964 · N5549V · Minor damage NTSB UNK64X0356Accident · No injuriesClosedSwift GC1B · Olathe, KSJan 25, 1964 · N3843K · Substantial damage NTSB UNK64X0290Accident · No injuriesClosedSwift GC1B · Presque Isle, MEJan 19, 1964 · N2431B · Substantial damage NTSB UNK64X0218Accident · No injuriesClosedGlobe Swift GC-1B · Midland, TXJan 11, 1964 · N3351K · Substantial damage