Skip to content

NTSB investigations: Globe GC-1B

303 cases on aircraft the registry lists as Globe 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 ('9230104')) 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 ('9230104'))
  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 ('9230104'))
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 DEN68D0138Accident · No injuriesClosedGlobe GC-1B · Aurora, CONov 10, 1967 · N3246K · Substantial damage NTSB DIA68F0137Accident · No injuriesClosedGlobe GC-1B · Short Creek, WVOct 29, 1967 · N80933 · Substantial damage NTSB DIA68F0101Accident · No injuriesClosedGlobe GC-1B · Anacostia, DCOct 25, 1967 · N3777K · Substantial damage NTSB MIA68D0247Accident · No injuriesClosedGlobe GC-1B · Kennesaw, GAOct 20, 1967 · N90310 · Substantial damage NTSB OAK68D0137Accident · No injuriesClosedGlobe GC-1B · Columbia, CASep 17, 1967 · N78324 · Substantial damage NTSB DEN68F0084Accident · Minor injuriesClosedGlobe GC-1B · Littleton, COSep 8, 1967 · N782E · Substantial damage NTSB MKC68D0142Accident · No injuriesClosedGlobe GC-1B · Larchwood, IAAug 13, 1967 · N78009 · Substantial damage NTSB LAX68D0088Accident · No injuriesClosedGlobe GC-1B · Ramona, CAAug 10, 1967 · N78246 · Substantial damage NTSB NYC68F0042Accident · No injuriesClosedGlobe GC-1B · Lehighton, PAJul 10, 1967 · N78128 · Substantial damage NTSB MIA68F0086Accident · Minor injuriesClosedGlobe GC-1B · Birmingham, ALJul 1, 1967 · N3815K · Substantial damage NTSB LAX68F0024Accident · Minor injuriesClosedGlobe GC-1B · Hntngtn Bch, CAJun 17, 1967 · N78025 · Substantial damage NTSB NYC67D0694Accident · No injuriesClosedGlobe GC-1B · Moorestown, NJMay 28, 1967 · N78111 · Substantial damage NTSB DEN67D0300Accident · Minor injuriesClosedGlobe GC-1B · La Veta, COMay 28, 1967 · N3205K · Substantial damage NTSB OAK67D0328Accident · No injuriesClosedGlobe GC-1B · San Jose, CAMay 15, 1967 · N3321K · Substantial damage NTSB LAX67D0450Accident · No injuriesClosedSwift GC-1B · Riverside, CAMay 13, 1967 · N4962C · Substantial damage NTSB LAX67F0384Accident · Minor injuriesClosedGlobe GC-1B · Van Nuys, CAMay 3, 1967 · N3749K · Substantial damage NTSB MIA67F0516Accident · Serious injuriesClosedGlobe GC-1B · St Augustine, FLApr 15, 1967 · N80646 · Destroyed NTSB SEA67D0315Accident · Minor injuriesClosedGlobe GC-1B · Alderwood Mr, WAApr 8, 1967 · N80659 · Substantial damage NTSB CHI67D0608Accident · No injuriesClosedGlobe GC-1A · Monee, ILMar 25, 1967 · N80748 · Substantial damage NTSB SEA67F0234Accident · No injuriesClosedGlobe GC-1B · Portland, ORJan 15, 1967 · N3761K · Substantial damage NTSB CHI67A0086Accident · 1 fatalClosedGlobe GC-1B · Sheboygan, WIJan 11, 1967 · N3738K · Destroyed NTSB FTW67F0372Accident · 1 fatalClosedGlobe GC-1B · Bellville, TXDec 12, 1966 · N80521 · Destroyed NTSB MIA67F0244Accident · No injuriesClosedGlobe GC-1B · Brooksville, FLOct 23, 1966 · N80682 · Substantial damage NTSB MIA67F0314Accident · No injuriesClosedGlobe GC-1B · Crestview, FLOct 19, 1966 · N3283K · Substantial damage NTSB MKC67F0281Accident · No injuriesClosedGlobe GC-1A · St.Louis, MOOct 2, 1966 · N90321 · Substantial damage NTSB CHI68D0039Accident · Minor injuriesClosedGlobe GC-1B · Polo, ILSep 9, 1966 · N78082 · Substantial damage NTSB SEA67A0021Accident · 2 fatalClosedGlobe GC-1B · Woodinville, WASep 7, 1966 · N80785 · Destroyed NTSB OAK68D0129Accident · No injuriesClosedSwift GC-1B · Oakland, CASep 5, 1966 · N80545 · Substantial damage NTSB OAK67D0126Accident · No injuriesClosedGlobe GC-1B · Las Vegas, NVSep 5, 1966 · N58KB · Substantial damage NTSB SEA67F0163Accident · No injuriesClosedGlobe GC-1B · Vancouver, WAAug 21, 1966 · N80649 · Substantial damage NTSB CHI67F0265Accident · No injuriesClosedGlobe GC-1B · Gladwin, MIAug 20, 1966 · N3232K · Substantial damage NTSB FTW67F0125Accident · No injuriesClosedGlobe GC-1B · Dallas, TXJul 25, 1966 · N3834K · Substantial damage NTSB LAX67A0011Accident · 2 fatalClosedGlobe GC-1B · El Toro, CAJul 24, 1966 · N3786K · Destroyed NTSB FTW67F0075Accident · No injuriesClosedGlobe GC-1B · Addison, TXJul 22, 1966 · N3301K · 2 aircraft · Substantial damage NTSB NYC67D0140Accident · No injuriesClosedGlobe GC-1B · Colts Neck, NJJul 20, 1966 · N80862 · Substantial damage NTSB SEA67D0051Accident · No injuriesClosedGlobe GC-1B · Hardin, MTMay 24, 1966 · N78263 · Substantial damage NTSB DEN66D0352Accident · No injuriesClosedSwift GC1B · Wilcox, AZMay 20, 1966 · N3331K · Substantial damage NTSB OAK66F0287Accident · No injuriesClosedGlobe GC-1B · Novato, CAMay 1, 1966 · N80969 · Substantial damage NTSB OAK66D0259Accident · No injuriesClosedGlobe GC-1B · Sacramento, CAApr 30, 1966 · N3224K · 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 MIA66F0454Accident · No injuriesClosedGlobe GC-1B · Venice, FLMar 1, 1966 · N3797K · Substantial damage NTSB MKC66F0478Accident · Minor injuriesClosedGlobe GC-1B · White Bear Lk, MNFeb 24, 1966 · N2387B · Substantial damage NTSB MIA66D0408Accident · No injuriesClosedSwift GC-1B · Memphis, TNFeb 3, 1966 · N78290 · Substantial damage NTSB CHI66D0526Accident · No injuriesClosedGlobe 125 · Franklin, INJan 16, 1966 · N3333K · Substantial damage NTSB MIA66A0075Accident · 2 fatalClosedUniv Acft GC-1B · Greenville, SCDec 31, 1965 · N2381B · Destroyed NTSB MKC66A0030Accident · 2 fatalClosedUniversal GC-1B · Council Bluffs, IANov 6, 1965 · N3832K · Destroyed NTSB MIA66F0278Accident · No injuriesClosedGlobe GC-1B · Harleyville, SCAug 29, 1965 · N2395B · Destroyed NTSB OAK66F0056Accident · No injuriesClosedGlobe GC1-B · Honolulu, HIAug 26, 1965 · N78250 · Substantial damage