NTSB investigations: Globe GC-1B, PA
11 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 | 2 |
|---|---|
| 1965 | 3 |
| 1967 | 1 |
| 1968 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1985 | 1 |
| 1986 | 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\" = 'PA' 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" = 'PA' 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 NYC86LA139Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Johnstown, PAThe flight departed Johnstown-cambria airport at about 1600 hours and returned at about 1700 hours. On landing, the pilot forgot to lower the landing gear and landed gear up. The aircraft slid to a stop and about five minutes later fire erupted.NTSB NYC85LA134Accident · No injuriesLimited investigationFinal reportGlobe GC1B · Whitpain, PAThe acft overran the end of the rwy and contacted rough terrain during takeoff. The plt stated the acft lifted off aprx 1/2 the way down the rwy but it did not have enough airspeed to accelerate and climb. The plt attempted to abort the takeoff however, the…NTSB NYC74FGM36Accident · No injuriesClosedGlobe GC-1B · Mt Pleasant, PANTSB NYC73AN015Accident · 1 fatalClosedGlobe GC-1B · Coudersport, PANTSB NYC69D0019Accident · No injuriesClosedGlobe GC-1B · Titusville, PANTSB NYC68F0042Accident · No injuriesClosedGlobe GC-1B · Lehighton, PANTSB NYC66F0191Accident · Minor injuriesClosedGlobe GC-1B · Florence, PANTSB NYC66F0180Accident · No injuriesClosedGlobe GC-1B · Butler, PANTSB NYC65F0079Accident · Serious injuriesClosedGlobe GC-1B · Quakertown, PANTSB UNK64X3008Accident · No injuriesClosedGlobe Swift GC1B · Butler, PANTSB UNK64X1192Accident · No injuriesClosedSwift GC1B · Latrobe, PA