NTSB investigations: Temco GC-1B, 1986
4 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.
Cases per year
| 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 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\") = 1986
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") = 1986
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" 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 FTW86LA165Accident · Minor injuriesLimited investigationFinal reportTemco Glode Swift · Temple, TXThe plt departed rwy 36 at charping field to perform touch and go landings. The plt stated that the acft eng quit on final apch. The plt elected to land short of the airfield with the landing gear retracted because of a power line along the final apch path.…NTSB ATL86LA221Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Bowling Green, KYPlt reported that he failed to reposition the fuel selector from auxillary fuel tank to main fuel tank during the landing check. Engine quit due to fuel starvation on short final approach at too low an altitude for corrective action.NTSB LAX86LA308Accident · Minor injuriesLimited investigationFinal reportTemco GC-1B · Huntington Bch, CAThe pilot stated that he was putting some time on the engine after maintenance had been performed when the engine quit. He initially stated that he departed at 1300 PDT with 12 gallons of fuel on board. He later stated that he departed at 1400 PDT and that…NTSB FTW86LA065Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Del Rio, TXThe student pilot was being instructed in the landing of a tail dragger aircraft, when he lost control of the aircraft at touchdown. The instructor failed to take corrective action when the student pilot inadvertently applied left brake, causing the aircraft…