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

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 WPR10CA282](https://openairdocs.org/ntsb/WPR10CA282.md): Great Lakes 2T-1A-2 · Chandler, AZ · Accident · No injuries · Data collection · Final report · May 31, 2010 · N6075L · Substantial damage
  > The pilot’s failure to maintain directional control and the flight instructor's inadequate remedial action during the landing roll, which resulted in a ground loop.
- [NTSB LAX96LA023](https://openairdocs.org/ntsb/LAX96LA023.md): Great Lakes 2T-1A-2 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Oct 26, 1995 · N3808F · Substantial damage
  > the improper installation of an intake manifold tube assembly during engine overhaul which permitted leakage into the induction system resulting in detonation and piston failure in the associated cylinder.
- [NTSB LAX87LA211](https://openairdocs.org/ntsb/LAX87LA211.md): Great Lakes 2T-1A-2 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · May 17, 1987 · N5762G · Substantial damage
  > A Great Lakes 2T-1A-2 nosed over during landing. The pilot indicated that he had contacted the airport on the UNICOM frequency and was informed that the winds were favoring runway 30. On short final approach to runway 30 the pilot glanced a wind sock located…

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

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