# NTSB investigations: Great Lakes 2T-1A-2: On ground/water collision with object

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 IAD04LA043](https://openairdocs.org/ntsb/IAD04LA043.md): Great Lakes 2T1-A2 · Elkton, KY · Accident · No injuries · Limited investigation · Final report · Aug 22, 2004 · N1XG · Substantial damage
  > The pilot's misidentification of the runway, which resulted in the airplane striking an obscured runway marker. Factors were the tailwheel airplane's reduced forward and lateral visibility during landing rollout and inadequate maintenance of the airport…
- [NTSB LAX89LA174](https://openairdocs.org/ntsb/LAX89LA174.md): Great Lakes 2T-1A-2 · Ramona, CA · Accident · No injuries · Limited investigation · Final report · Apr 29, 1989 · N6220L · 2 aircraft · Minor damage
  > The pilot of the other aircraft did not maintain an adequate visual lookout and collided with this Cessna that was parked in the runup area.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3910101')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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