NTSB investigations: Temco GC-1B, 1971

8 cases on aircraft the registry lists as Temco 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: Temco GC-1B, 1971 per year, 1964–2026: 108 cases
1964	10
1965	7
1966	11
1967	11
1968	4
1969	6
1970	4
1971	8
1972	3
1973	3
1974	2
1975	5
1976	5
1977	1
1978	1
1980	2
1982	1
1984	2
1985	1
1986	4
1989	2
1991	1
1993	1
2001	1
2004	1
2005	1
2007	1
2011	2
2012	1
2014	1
2017	2
2020	1
2023	1
2025	1

Where

Open the map

Latest cases

Query with SQL

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 ('9230108')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('9230108'))
  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 ('9230108'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 MKC72FCJ42Accident · No injuriesClosedTemco GC-1B · Grand Island, NEDec 24, 1971 · N2329B · Substantial damage NTSB FTW72FRA21Accident · Minor injuriesClosedGlobe GC-1B · Lamarque, TXNov 14, 1971 · N80891 · Substantial damage NTSB MIA72DKG47Accident · No injuriesClosedGlobe GC-1B · Albany, GAOct 16, 1971 · N2414B · Substantial damage NTSB OAK72DVD17Accident · Serious injuriesClosedGlobe GC-1B · Newark, CAOct 2, 1971 · N80962 · Destroyed NTSB MKC72FCG16Accident · Serious injuriesClosedGlobe GC-1B · Brunswick, MOSep 12, 1971 · N3843K · Substantial damage NTSB MKC72DER06Accident · No injuriesClosedGlobe GC-1B · Big Fork, MNJul 8, 1971 · N80613 · Substantial damage NTSB DEN71FQA53Accident · No injuriesClosedGlobe GC-1B · Albuquerque, NMApr 14, 1971 · N3863K · Substantial damage NTSB MIA71DLA40Accident · No injuriesClosedSwift GC-1B · Defuniak Spgs, FLMar 30, 1971 · N3823K · Substantial damage