NTSB investigations: Globe GC-1B, IL
12 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1996 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA'
AND 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" DESCRun 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 CHI96FA323Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Hampshire, ILimproper use of the mini-bike by the driver. Factors relating to the accident were: darkness, the unlighted mini-bike, and insufficient standards required by the residents of the airstrip concerning use of the taxiways at night.NTSB CHI89LA142Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Metropolis, ILPilot's failure to adhere to procedures and ensure the aircraft had sufficient airspeed before attempting rotation and climbout. Airspeed was inadequate to maintain flight, and just after the landing gear was retracted the aircraft settledto the ground.NTSB CHI85FA370Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Romeoville, ILThe pilot was reportly departing on a xcountry flt. During climbout, in the traffic pattern, upon reaching base leg area the acft was observed to turn back towards the arpt descend and strike the ground. Witnesses reported no sound of engine was heard. The…NTSB CHI77FEE21Accident · Minor injuriesClosedGlobe GC-1B · Marengo, ILNTSB CHI76FEV64Accident · No injuriesClosedGlobe GC-1B · Burnside, ILNTSB CHI70F0344Accident · Minor injuriesClosedGlobe GC-1B · Wheeling, ILNTSB CHI70F0243Accident · No injuriesClosedGlobe GC-1B · Carthage, ILNTSB CHI69D0076Accident · No injuriesClosedGlobe GC-1B · Benton, ILNTSB CHI67D0608Accident · No injuriesClosedGlobe GC-1A · Monee, ILNTSB CHI68D0039Accident · Minor injuriesClosedGlobe GC-1B · Polo, ILNTSB CHI66F0508Accident · No injuriesClosedGlobe GC-1B · Marissa, ILNTSB UNK64X1373Accident · No injuriesClosedGlobe Swift GC1B · Hampshire, IL