# NTSB investigations: Great Lakes 2T-1A-2, TX

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CEN11LA209](https://openairdocs.org/ntsb/CEN11LA209.md): Great Lakes 2T-1A-2 · Kingsville, TX · Accident · No injuries · Limited investigation · Final report · Feb 26, 2011 · N6196L · Substantial damage
  > A pre-existing crack in the front spar of the right horizontal stabilizer near a riveted fitting, causing it to fail and separate from the airplane in flight. Contributing to the accident was the failure of maintenance personnel comply with existing service…
- [NTSB CEN09CA349](https://openairdocs.org/ntsb/CEN09CA349.md): Great Lakes 2T-1A-2 · Hamilton, TX · Accident · No injuries · Data collection · Final report · Jun 7, 2009 · N3812F · Substantial damage
  > The pilot's failure to maintain clearance from a tree while on short final.
- [NTSB FTW87LA154](https://openairdocs.org/ntsb/FTW87LA154.md): Great Lakes 2T-1A-2 · Baytown, TX · Accident · No injuries · Limited investigation · Final report · Jun 26, 1987 · N3564L · Substantial damage
  > Drg the lndg roll, the acft started to drift to the left, so the plt corrected with right rudder. He said he over- controlled, then applied left rudder & brake, followed by right rudder & brake. Subsequently, the situation became aggravated until both main…
- [NTSB FTW86FA156](https://openairdocs.org/ntsb/FTW86FA156.md): Great Lakes 2T-1A-2 · Houston, TX · Accident · 1 fatal · Field investigation · Final report · Aug 30, 1986 · N6198L · Destroyed
  > The ends of the outer string and the inner reinforcing wire of the engine air intake duct were not properly positioned under the duct clamp during installation. As a result, they unwound during engine operation and moved out of their normal position on and in…
- [NTSB FTW85LA345](https://openairdocs.org/ntsb/FTW85LA345.md): Great Lakes 2T-1A-2 · Caddo Mills, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 9, 1985 · N6262L · Destroyed
  > The CFI PIC stated the eng lost power with the acft about 400 to 500 ft AGL. He couldn't return to the arpt due to lack of altitude. He elected to land in the plowed field. The acft touched down and flipped inverted. The air induction duct was found…
- [NTSB FTW82DPA06](https://openairdocs.org/ntsb/FTW82DPA06.md): Great Lakes 2T-TA · Waco, TX · Accident · No injuries · Closed · Nov 18, 1981 · N101GL · Substantial damage
- [NTSB FTW81FRG26](https://openairdocs.org/ntsb/FTW81FRG26.md): Great Lakes 2T-1A2 · Alamo, TX · Accident · No injuries · Closed · Mar 13, 1981 · N6053L · Substantial damage
- [NTSB FTW79FRG05](https://openairdocs.org/ntsb/FTW79FRG05.md): Great Lakes 2T-1A · Fredericksburg, TX · Accident · No injuries · Closed · Oct 21, 1978 · N3808F · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 c."eventStateOrRegion" = 'TX' 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 ('3910101'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3910101&state=TX

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
