Skip to content

NTSB investigations: Temco GC-1B

108 cases on aircraft the registry lists as Temco GC-1B. 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.aircraft_model_code IN ('9230108')) 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.aircraft_model_code IN ('9230108'))
  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.aircraft_model_code IN ('9230108'))
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 OAK72DVD17Accident · Serious injuriesClosedGlobe GC-1B · Newark, CAOct 2, 1971 · N80962 · Destroyed NTSB MKC72FCG16Accident · Serious injuriesClosedGlobe GC-1B · Brunswick, MOSep 12, 1971 · N3843K · Substantial damage NTSB MKC72DER06Accident · No injuriesClosedGlobe GC-1B · Big Fork, MNJul 8, 1971 · N80613 · Substantial damage NTSB DEN71FQA53Accident · No injuriesClosedGlobe GC-1B · Albuquerque, NMApr 14, 1971 · N3863K · Substantial damage NTSB MIA71DLA40Accident · No injuriesClosedSwift GC-1B · Defuniak Spgs, FLMar 30, 1971 · N3823K · Substantial damage NTSB SEA71DWA23Accident · Serious injuriesClosedGlobe GC-1B · Pendleton, ORNov 14, 1970 · N2317B · Destroyed NTSB MKC71DCA10Accident · No injuriesClosedGlobe GC-1B · Lesterville, MOAug 2, 1970 · N80970 · Substantial damage NTSB CHI70FBD46Accident · Serious injuriesClosedGlobe GC-1B · Hinsdale, ILJun 24, 1970 · N2351B · Substantial damage NTSB OAK70FVW01Accident · No injuriesClosedGlobe GC-1B · Las Vegas, NVJan 30, 1970 · N2301B · Substantial damage NTSB MIA70F0203Accident · No injuriesClosedGlobe GC-1B · Gallatin, TNOct 4, 1969 · N2424B · Substantial damage NTSB NYC70D0105Accident · No injuriesClosedGlobe Swift GC-1B · Fitchburg, MAJul 19, 1969 · N2390B · Destroyed NTSB OAK70F0057Accident · No injuriesClosedGlobe GC-1A · Reno, NVJul 13, 1969 · N2419B · Substantial damage NTSB MKC70D0112Accident · No injuriesClosedGlobe GC-1B · Norfolk, NEJun 29, 1969 · N2351B · Substantial damage NTSB CHI69D0570Accident · No injuriesClosedGlobe GC-1B · Cincinnati, OHMar 30, 1969 · N78247 · Substantial damage NTSB NYC69F0325Accident · No injuriesClosedSwift GC1B · Forty Fort, PAJan 26, 1969 · N2336B · Substantial damage NTSB LAX69D0096Accident · No injuriesClosedTemco GC-1B · Riverside, CAAug 28, 1968 · N78314 · Substantial damage NTSB FTW69F0142Accident · Minor injuriesClosedGlobe GC-1B · Okla.City, OKAug 10, 1968 · N2421B · Substantial damage NTSB OAK69F0030Accident · Minor injuriesClosedGlobe GC-1B · Red Bluff, CAJun 16, 1968 · N3826K · Destroyed NTSB NYC69D0014Accident · No injuriesClosedGlobe GC-1B · Farmingdale, NYJun 5, 1968 · N2300B · Substantial damage NTSB LAX68D0151Accident · No injuriesClosedGlobe GC-1B · Afton, CASep 28, 1967 · N2312B · Destroyed NTSB MKC68D0297Accident · No injuriesClosedGlobe GC-1B · Harrisonville, MOSep 16, 1967 · N3843K · Substantial damage NTSB SEA68D0192Accident · No injuriesClosedGlobe GC-1B · Warrenton, ORSep 12, 1967 · N2384B · Substantial damage NTSB LAX68D0123Accident · No injuriesClosedGlobe Swift GC-1B · Peoria, AZSep 4, 1967 · N78293 · Substantial damage NTSB OAK68A0023Accident · 1 fatalClosedTemco GC-1B · Etna, CAAug 28, 1967 · N78289 · Destroyed 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 OAK67D0292Accident · No injuriesClosedGlobe GC-1B · San Carlos, CAApr 17, 1967 · N2419B · Substantial damage NTSB FTW67F0537Accident · Minor injuriesClosedGlobe GC-1B · Stillwater, OKApr 13, 1967 · N3346K · Substantial damage NTSB DEN67F0225Accident · No injuriesClosedUniv Acft GC-1B · Grants, NMMar 18, 1967 · N2320B · Substantial damage NTSB LAX67F0255Accident · No injuriesClosedGlobe GC-1B · Hawthorne, CAJan 20, 1967 · N78248 · 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 NYC67D0282Accident · No injuriesClosedGlobe GC-1B · Croton, NYAug 6, 1966 · N2350B · Substantial damage NTSB CHI67F0016Accident · No injuriesClosedTemco GC1B · Ann Arbor, MIJun 19, 1966 · N2386B · Substantial damage NTSB NYC66F0695Accident · No injuriesClosedGlobe GC1B · Philippi, WVMay 15, 1966 · N77753 · Substantial damage NTSB CHI66D0781Accident · No injuriesClosedGlobe Swift GC-1B · Cleveland, OHMay 11, 1966 · N2455B · Substantial damage NTSB NYC66D0631Accident · No injuriesClosedGlobe GC-1B · Orange, MAApr 17, 1966 · N3785K · 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 OAK66D0239Accident · No injuriesClosedGlobe D-16 · San Carlos, CAJan 30, 1966 · N2419B · Substantial damage NTSB NYC66F0115Accident · No injuriesClosedGlobe GC-1B · Amityville, NYJul 13, 1965 · N2300B · Substantial damage NTSB CHI66F0018Accident · Minor injuriesClosedSwift GC1B · Versailles, OHJun 13, 1965 · N2355B · Substantial damage NTSB LAX65D0050Accident · No injuriesClosedGlobe GC-1B · Carlsbad, CAApr 20, 1965 · N78056 · Substantial damage NTSB NYC65D0153Accident · No injuriesClosedSwift GC-1B · Morgantown, WVApr 12, 1965 · N3876K · Substantial damage NTSB UNK65X1380Accident · No injuriesClosedGlobe GC1B · Miami, FLFeb 1, 1965 · N78323 · Substantial damage NTSB MKC65F0005Accident · No injuriesClosedGlobe GC1B · Salina, KSJan 19, 1965 · N90372 · Substantial damage NTSB UNK65X1243Accident · No injuriesClosedSwift GC-1B · Forty Fort, PAJan 6, 1965 · N2336B · Substantial damage NTSB UNK65X0194Accident · No injuriesClosedGlobe GC1B · Powell, TNOct 8, 1964 · N3767K · Substantial damage NTSB UNK64X2900Accident · No injuriesClosedGlobe Swift · Flushing, NYJul 18, 1964 · N3888K · Substantial damage