NTSB investigations: Globe GC-1B
5 cases on aircraft the registry lists as Globe GC-1B, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1985 | 2 |
|---|---|
| 1991 | 1 |
| 1999 | 1 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230104')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351))
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 ATL03LA143Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Summerville, SCA loss of engine power due to the failure of the engine # 6 connecting rod bearing. A factor was the collision with a gate.NTSB FTW00FA046Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Edgewood, TXthe pilot's failure to maintain aircraft control during a forced landing which resulted in a stall/spin. Contributing factors were the failure of the engine driven fuel pump, the engine manufacturer's use of an inadequate fuel pump which was only intended for…NTSB ATL92LA018Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1D · Brewton, ALA blockage of the fuel vent system which prevented the pilot from topping off the fuel system. A factor in this accident was the inadequate design by the manufacturer of the fuel vent system.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 MIA85FA102Accident · 2 fatalField investigationFinal reportGlobe Swift GC-1B · Rockledge, FLThe acft crashed into a field after experiencing a loss of pwr. Inspection revealed one of the two check valves inside the eng driven fuel pump was unsetted and wedged between the metal pump housing and the pump diaphram actuating plate. With the check valve…