Skip to content

Universal GLOBE GC-1B

NTSB investigations · 20

Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('9230112') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('9230112')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('9230112')
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 WPR09CA440Accident · No injuriesData collectionFinal reportUniversal Globe GC-1 · Pacoima, CAThe pilot's failure to maintain directional control during the landing roll.Sep 4, 2009 · N2345B · Substantial damage NTSB LAX91FA209Accident · 1 fatalField investigationFinal reportUniversal Globe GC-1B · Chandler, AZThe pilot-in-command's failure to maintain airspeed in a forced landing resulting in an in flight loss of control, stall, and subsequent in flight colliison with terrain. Factor related to the accident was the pilot's improper procedure which restuled in a…May 12, 1991 · N42WW · Destroyed NTSB LAX90LA286Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Vacaville, CAFailure of the pilot to maintain adequate altitude resulting in an inflight encounter with an unfavorable wind at a low altitude in a hilly terrain.Aug 13, 1990 · N3314K · Destroyed NTSB LAX89LA071Accident · Serious injuriesLimited investigationFinal reportUnivair Globe GC-1B · Chino, CA**This report was modified on 2/24/2016. Please refer to the public docket for this accident for additional information.** The pilot's failure to maintain airspeed during an emergency landing following an inflight loss of engine power, resulting in an…Dec 27, 1988 · N3388K · Substantial damage NTSB SEA84LA210Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Sheridan, ORCFI stated, 'the acft became airborne aprx 2/3 of the way down a 3000 ft gravel and dirt rwy. At lift off, OR slightly before or after, student put on full flaps. Until this point student was in control of the airplane except for minor corrections from me.…Aug 22, 1984 · N2345B · Substantial damage NTSB NYC77DHA26Accident · No injuriesClosedGlobe GC1B · Pottstown, PASep 11, 1977 · N78110 · Substantial damage NTSB MIA77FKG04Accident · No injuriesClosedGlobe GC-1B · Zebulon, GAOct 10, 1976 · N3320K · Substantial damage NTSB MIA75AM085Accident · 1 fatalClosedTemco GC-1B · Clayton, GAMay 31, 1975 · N2382B · Destroyed NTSB NYC73FHM31Accident · Serious injuriesClosedGlobe GC-1B · Fairfield, NJMay 13, 1973 · N3394K · Destroyed NTSB MKC72DCG47Accident · No injuriesClosedGlobe GC-1B · St Joseph, MOApr 12, 1972 · N3845K · Substantial damage NTSB CHI71FBA21Accident · Serious injuriesClosedGlobe GC-1B · Monticello, INDec 18, 1970 · N78119 · Substantial damage NTSB SEA70A0002Accident · 2 fatalClosedGlobe GC-1B · Winlock, WAJul 10, 1969 · N78155 · Destroyed NTSB MKC68D0004Accident · No injuriesClosedGlobe GC-1B · Missouri City, MOJun 15, 1967 · N80947 · Substantial damage NTSB NYC67F0609Accident · No injuriesClosedGlobe GC-1B · Latrobe, PAMar 23, 1967 · N78217 · Substantial damage 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 OAK66D0277Accident · No injuriesClosedGlobe GC-1B · San Jose, CAApr 13, 1966 · N3827K · Substantial damage NTSB LAX66D0070Accident · No injuriesClosedGlobe GC-1B · Thousand Oaks, CAJun 25, 1965 · N90385 · Substantial damage NTSB UNK65X0784Accident · No injuriesClosedGlobe GC-1B · White Sulpr Sp, VANov 22, 1964 · N78110 · Destroyed NTSB UNK64X1358Accident · No injuriesClosedGlobe Swift GC1B · New Haven, CTApr 18, 1964 · N711M · Substantial damage

Back to Universal GLOBE GC-1B