NTSB investigations: Globe GC-1B, 1971
13 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 | 28 |
|---|---|
| 1965 | 29 |
| 1966 | 25 |
| 1967 | 21 |
| 1968 | 13 |
| 1969 | 9 |
| 1970 | 15 |
| 1971 | 13 |
| 1972 | 8 |
| 1973 | 8 |
| 1974 | 11 |
| 1975 | 7 |
| 1976 | 7 |
| 1977 | 6 |
| 1978 | 8 |
| 1979 | 5 |
| 1980 | 4 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 4 |
| 1984 | 5 |
| 1985 | 7 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 2 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 2 |
| 2010 | 3 |
| 2011 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 4 |
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 year(c.\"eventDate\") = 1971
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 year(c."eventDate") = 1971
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 LAX72AL037Accident · 1 fatalClosedGlobe GC-1B · Palos Vrdes, CANTSB MIA72FKG49Accident · Serious injuriesClosedGlobe GC-1B · Cordele, GANTSB NYC72FIG14Accident · Minor injuriesClosedGlobe GC-1B · Perry Hall, MDNTSB CHI72FEP18Accident · No injuriesClosedGlobe GC-1B · Sheboygan, WINTSB OAK72FJA05Accident · 1 fatalClosedGlobe GC-1B · Kailua-Kna, HINTSB MKC72AK007Accident · 2 fatalClosedGlobe GC-1B · St.Paul, MNNTSB MKC71FTK32Accident · No injuriesClosedGlobe GC-1B · Rapid City, SDNTSB DEN71FTM25Accident · Serious injuriesClosedGlobe GC-1B · Spanish Fork, UTNTSB SEA71AS042Accident · 1 fatalClosedGlobe GC-1B · Monroe, WANTSB CHI71FBJ68Accident · Minor injuriesClosedSwift GC-1B · Kalamazoo, MINTSB MIA71DLD58Accident · No injuriesClosedGlobe GC-1B · Silver Spgs, FLNTSB MIA71AM075Accident · 1 fatalClosedGlobe GC-1B · Norcross, GANTSB MIA71DLD49Accident · No injuriesClosedGlobe GC-1B · Wauchula, FL