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 LAX72AL037Accident · 1 fatalClosedGlobe GC-1B · Palos Vrdes, CANov 20, 1971 · N250B · Destroyed NTSB MIA72FKG49Accident · Serious injuriesClosedGlobe GC-1B · Cordele, GAOct 23, 1971 · N3351K · Substantial damage NTSB NYC72FIG14Accident · Minor injuriesClosedGlobe GC-1B · Perry Hall, MDOct 16, 1971 · N80551 · Substantial damage NTSB CHI72FEP18Accident · No injuriesClosedGlobe GC-1B · Sheboygan, WIOct 5, 1971 · N80606 · Substantial damage NTSB OAK72FJA05Accident · 1 fatalClosedGlobe GC-1B · Kailua-Kna, HISep 4, 1971 · N78250 · Destroyed NTSB MKC72AK007Accident · 2 fatalClosedGlobe GC-1B · St.Paul, MNJul 21, 1971 · N3792K · Destroyed NTSB MKC71FTK32Accident · No injuriesClosedGlobe GC-1B · Rapid City, SDJun 21, 1971 · N3366K · Substantial damage NTSB DEN71FTM25Accident · Serious injuriesClosedGlobe GC-1B · Spanish Fork, UTMay 13, 1971 · N80695 · Destroyed NTSB SEA71AS042Accident · 1 fatalClosedGlobe GC-1B · Monroe, WAMay 11, 1971 · N80655 · Destroyed NTSB CHI71FBJ68Accident · Minor injuriesClosedSwift GC-1B · Kalamazoo, MIApr 11, 1971 · N80995 · Substantial damage NTSB MIA71DLD58Accident · No injuriesClosedGlobe GC-1B · Silver Spgs, FLMar 28, 1971 · N78055 · Substantial damage NTSB MIA71AM075Accident · 1 fatalClosedGlobe GC-1B · Norcross, GAFeb 25, 1971 · N78043 · Destroyed NTSB MIA71DLD49Accident · No injuriesClosedGlobe GC-1B · Wauchula, FLFeb 14, 1971 · N78321 · Substantial damage NTSB MIA71FKG54Accident · Serious injuriesClosedGlobe GC-1B · Stone Mountain, GADec 19, 1970 · N78146 · Substantial damage NTSB LAX71FUG28Accident · 1 fatalClosedGlobe GC-1B · Running Sprgs, CANov 28, 1970 · N3374K · Destroyed NTSB CHI71FGG14Accident · No injuriesClosedGlobe GC-1B · Lima, OHSep 27, 1970 · N3760K · Substantial damage NTSB LAX71FUQ21Accident · Serious injuriesClosedGlobe GC-1B · S Fernando, CASep 26, 1970 · N90368 · Destroyed 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 IAD71FIA04Accident · No injuriesClosedGlobe GC-1B · Manassas, VAAug 15, 1970 · N78111 · Substantial damage NTSB OAK71FVM08Accident · 1 fatalClosedGlobe GC-1B · Morgan Hill, CAAug 14, 1970 · N3371K · Destroyed NTSB OAK71FVD04Accident · Serious injuriesClosedGlobe GC-1B · San Lorenzo, CAAug 9, 1970 · N2423B · Substantial damage NTSB FTW71DQG26Accident · No injuriesClosedGlobe GC-1B · Big Spring, TXAug 8, 1970 · N78118 · Substantial damage NTSB CHI71FDJ06Accident · Minor injuriesClosedGlobe GC-1B · Franklin, WIAug 2, 1970 · N11HR · Substantial damage NTSB LAX71DUJ10Accident · No injuriesClosedGlobe GC-1B · Showlow, AZJul 1, 1970 · N78246 · Substantial damage NTSB MIA70FKW05Accident · Serious injuriesClosedGlobe GC-1B · Vonore, TNMay 11, 1970 · N3780K · Substantial damage NTSB ANC71DAG38Accident · No injuriesClosedGlobe GC-1B · Homer, AKMay 10, 1970 · N78198 · Substantial damage NTSB MIA70AM057Accident · 2 fatalClosedGlobe GC-1B · Hickory, MSJan 16, 1970 · N521C · Destroyed NTSB FTW70F0319Accident · Minor injuriesClosedGlobe GC-1B · Abilene, TXNov 30, 1969 · N80833 · Substantial damage NTSB LAX70D0191Accident · No injuriesClosedGlobe GC-1A · Casa Grande, AZNov 3, 1969 · N80720 · Substantial damage NTSB CHI70F0344Accident · Minor injuriesClosedGlobe GC-1B · Wheeling, ILOct 23, 1969 · N78172 · Substantial damage NTSB CHI70F0243Accident · No injuriesClosedGlobe GC-1B · Carthage, ILSep 14, 1969 · N3308K · Substantial damage NTSB CHI70F0348Accident · No injuriesClosedGlobe GC-1B · Delavan, WIAug 23, 1969 · N78137 · Substantial damage 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 OAK69D0310Accident · No injuriesClosedGlobe GC-1B · Redding, CAApr 20, 1969 · N78291 · Substantial damage NTSB LAX69A0048Accident · 2 fatalClosedGlobe Swift GC-1B · San Simon, AZJan 31, 1969 · N4198 · Destroyed NTSB CHI69A0052Accident · 1 fatalClosedGlobe GC-1B · Reed City, MINov 17, 1968 · N78061 · Destroyed NTSB NYC69A0051Accident · 2 fatalClosedSwift Globe GC-1B · Willingboro, NJNov 3, 1968 · N9030M · 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 MIA69F0201Accident · Serious injuriesClosedGlobe GC-1B · Gulfport, MSOct 9, 1968 · N2323B · Destroyed 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 MIA69F0072Accident · Minor injuriesClosedGlobe GC-1B · Davie, FLJul 19, 1968 · N78039 · Destroyed NTSB LAX69D0060Accident · No injuriesClosedGlobe GC-1B · Rubidoux, CAJul 14, 1968 · N3762K · 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 MIA68D0407Accident · Serious injuriesClosedGlobe GC-1B · Immokalee, FLFeb 4, 1968 · N78037 · Substantial damage