NTSB investigations: Globe GC-1B
6 cases on aircraft the registry lists as Globe GC-1B, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 2001 | 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\" = 130))
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" = 130))
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 ATL01LA043Accident · No injuriesLimited investigationFinal reportGlobe GC1B · Cherry Point, NCFatigue cracking of the propeller hub that resulted in the in-flight separation of a propeller blade.NTSB LAX98LA034Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Los Angeles, CAThe pilot's loss of directional control due to an inadvertent ground loop resulting from a deflated tire.NTSB MIA92FA108Accident · 2 fatalField investigationFinal reportGlobe GC1-B · Miami, FLAn abrupt pitch up maneuver during acrobatic flight resulting in an overload failure of the right wing spar.NTSB MIA88LA175Accident · No injuriesLimited investigationFinal reportGlobe GC1-B · Miami, FLHydraulic motor activated light remained on after landing gear retraction. The pilot believing this to indicate a landing gear malfunction slowed the acft and extended the gear. A gear down indicator illuminated. However, the hydraulic motor activated light…NTSB LAX84LA482Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Calistoga, CAThe starboard entrance hatch opened during takeoff roll. The pilot aborted the takeoff. The acft could not be stopped on the remaining rwy & collided with a ditch. The takeoff was attempted with a light tailwind on a unidirectional rwy.NTSB MIA83LA130Accident · No injuriesLimited investigationFinal reportGlobe GC1B · Miami, FLThe acft groundlooped and collapsed the landing gear after the rt brake failed during taxi from landing. The pilot said he had installed new brake pads and had spent time taxiing to wear them in. After completing one takeoff and landing theacft was being…