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 MIA78DKG27Accident · No injuriesClosedGlobe GC-1A · Stone Mountain, GAMar 19, 1978 · N80956 · Substantial damage NTSB LAX78FUQ17Accident · Serious injuriesClosedGlobe GC-1B · Lancaster, CAMar 10, 1978 · N78272 · Substantial damage NTSB NYC78FA024Accident · 1 fatalClosedTemco GC1B · Newport, RIJan 14, 1978 · N2406B · Destroyed NTSB MIA77DLD16Accident · No injuriesClosedGlobe GC-1B · Titusville, FLDec 3, 1977 · N90325 · Substantial damage NTSB MIA77FKT65Accident · No injuriesClosedGlobe GC-1B · Homestead, FLAug 14, 1977 · N80955 · Substantial damage NTSB CHI77FEE21Accident · Minor injuriesClosedGlobe GC-1B · Marengo, ILMay 14, 1977 · N187WE · Substantial damage NTSB FTW77FRA11Accident · No injuriesClosedGlobe GC-1B · Cypress, TXFeb 16, 1977 · N3249K · Substantial damage NTSB MKC77DCJ11Accident · No injuriesClosedGlobe GC-1B · Tekamah, NEFeb 9, 1977 · N3746K · Destroyed NTSB FTW77FA031Accident · 2 fatalClosedGlobe GC-1B · El Paso, TXJan 15, 1977 · N80566 · Destroyed NTSB SEA77FA002Accident · 1 fatalClosedGlobe GC-1B · Hood River, OROct 9, 1976 · N80915 · Destroyed NTSB CHI76FEI50Accident · Minor injuriesClosedUniversal GC-1B · Richmond Hts, OHSep 29, 1976 · N808GB · Destroyed NTSB SEA76AS076Accident · 2 fatalClosedUniversal GC-1B · Mckenzie Brdg, ORSep 8, 1976 · N80826 · Destroyed NTSB CHI76FEV64Accident · No injuriesClosedGlobe GC-1B · Burnside, ILSep 5, 1976 · N80606 · Substantial damage NTSB NYC76FNE27Accident · Serious injuriesClosedGlobe GC-1B · Gardner, MAJul 5, 1976 · N78315 · Destroyed NTSB FTW76FPA26Accident · No injuriesClosedGlobe GC-1B · Waco, TXJun 20, 1976 · N3208K · Destroyed NTSB MIA76AM080Accident · 1 fatalClosedGlobe GC-1B · Valdosta, GAApr 26, 1976 · N78037 · Destroyed NTSB SEA76FYG16Accident · No injuriesClosedGlobe GC-1B · Kennewick, WASep 28, 1975 · N3390K · Substantial damage NTSB FTW76DRJ03Accident · No injuriesClosedGlobe GC-1B · Minden, LAJul 13, 1975 · N3791K · Substantial damage NTSB DEN76FQA05Accident · No injuriesClosedGlobe GC-1B · Albuquerque, NMJul 9, 1975 · N3202K · Substantial damage NTSB LAX75DUG50Accident · No injuriesClosedPiper PA-30 · Riverside, CAJun 15, 1975 · N7122Y · 2 aircraft · Substantial damage NTSB CHI75DEP59Accident · No injuriesClosedGlobe GC-1B · Milwaukee, WIMay 25, 1975 · N80923 · Substantial damage NTSB MIA75DKT81Accident · No injuriesClosedGlobe GC-1A · Pahokee, FLMay 15, 1975 · N90333 · Substantial damage NTSB OAK75FVW18Accident · No injuriesClosedGlobe GC-1B · Boulder City, NVApr 24, 1975 · N78164 · Substantial damage NTSB OAK75FVM18Accident · No injuriesClosedGlobe GC-1B · Palo Alto, CADec 29, 1974 · N78200 · Substantial damage NTSB LAX75A6022Accident · 1 fatalClosedGlobe GC-1B · Claremont, CAOct 27, 1974 · N4962C · Destroyed NTSB OAK75FVG21Accident · Minor injuriesClosedGlobe GC-1B · Chico, CAAug 28, 1974 · N80549 · Destroyed NTSB IAD75AI008Accident · 1 fatalClosedGlobe GC-1B · Manchester, TNAug 20, 1974 · N3716K · Substantial damage NTSB IAD75FKW04Accident · Minor injuriesClosedGlobe GC-1A · Tullahoma, TNJul 14, 1974 · N2450B · Destroyed NTSB NYC75AN005Accident · 1 fatalClosedGlobe GC-1B · Plum Island, MAJul 13, 1974 · N3342K · Destroyed NTSB OAK74FVD37Accident · Minor injuriesClosedGlobe GC-1B · Sohoma, CAJun 22, 1974 · N3311K · Substantial damage NTSB NYC74AN101Accident · 2 fatalClosedGlobe GC-1B · Advance, NCJun 4, 1974 · N80965 · Substantial damage NTSB NYC74FGM36Accident · No injuriesClosedGlobe GC-1B · Mt Pleasant, PAJun 1, 1974 · N80956 · Substantial damage NTSB SEA74AS045Accident · 1 fatalClosedGlobe GC-1B · Metaline Fls, WAMay 27, 1974 · N80951 · Substantial damage NTSB CHI74AC088Accident · 2 fatalClosedGlobe GC-1B · Huntington, INMay 13, 1974 · N3260K · Destroyed NTSB MIA74DKT21Accident · Minor injuriesClosedGlobe GC-1B · Naples, FLSep 23, 1973 · N80813 · Destroyed NTSB MKC74DCD12Accident · No injuriesClosedGlobe GC-1B · Blakesburg, IASep 2, 1973 · N3754K · Substantial damage NTSB NYC74FFA04Accident · No injuriesClosedGlobe GC-1B · Ballston Spa, NYJul 28, 1973 · N3753K · Destroyed NTSB LAX73FUM36Accident · No injuriesClosedGlobe GC-1B · San Diego, CAJun 11, 1973 · N4962C · Substantial damage NTSB IAD73DKM38Accident · No injuriesClosedGlobe GC-1B · Mocksville, NCMay 5, 1973 · N78282 · Substantial damage NTSB LAX73FUJ71Accident · Minor injuriesClosedGlobe GC-1B · Glendale, AZApr 27, 1973 · N78090 · Substantial damage NTSB DEN73DTE56Accident · Minor injuriesClosedGlobe GC-1B · Silt, COFeb 18, 1973 · N78116 · Substantial damage NTSB LAX73AL036Accident · 1 fatalClosedGlobe GC-1B · Desert Cntr, CAJan 28, 1973 · N3262K · Destroyed NTSB SEA73FYE19Accident · No injuriesClosedSwift GC-1B · Snohomish, WANov 12, 1972 · N78165 · Substantial damage NTSB NYC73ANO67Accident · 2 fatalClosedSwift GC-1B · Salisbury, MDNov 12, 1972 · N80658 · Destroyed NTSB NYC73DHA09Accident · No injuriesClosedSwift GC-1B · Blairstown, NJOct 1, 1972 · N101R · Substantial damage NTSB NYC73AN015Accident · 1 fatalClosedGlobe GC-1B · Coudersport, PAJul 23, 1972 · N3217K · Destroyed NTSB FTW72FFD46Accident · Serious injuriesClosedGlobe GC-1B · Weatherford, TXJun 17, 1972 · N3854K · Substantial damage NTSB FTW72DPA23Accident · No injuriesClosedGlobe GC-1B · Dallas, TXMay 19, 1972 · N3803K · Substantial damage NTSB NYC72FNE24Accident · No injuriesClosedGlobe GC-1B · East Haven, CTJan 30, 1972 · N2372B · Substantial damage NTSB LAX72FUA33Accident · No injuriesClosedGlobe GC-1B · S.J.Cpstrno, CAJan 30, 1972 · N3269K · Substantial damage