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

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 SEA86LA247](https://openairdocs.org/ntsb/SEA86LA247.md): Great Lakes 2T-1A-2 · Tillamook, OR · Accident · No injuries · Limited investigation · Final report · Sep 18, 1986 · N3565L · Substantial damage
  > A precautionary landing was made on a field due to low fuel, lowering ceiling and visibility, ensuing darkness, and the pilot not knowing his exact position. Landing was made on an uphill field with a slight tail wind. The aircraft struck a swale and then…
- [NTSB SEA85LA141](https://openairdocs.org/ntsb/SEA85LA141.md): Great Lakes 2T-1A-2 · North Plains, OR · Accident · No injuries · Limited investigation · Final report · Jun 16, 1985 · N44SJ · Substantial damage
  > An overrun occurred due to excess speed and touching down 1/4 of the way down the 2100 foot glider strip. The aircraft rolled onto two foot high alfalfa where it then nosed over. The pilot previously landed gliders on the gliderport but never an engine…

## 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" = 'OR' 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=OR

---
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.