# NTSB investigations: Great Lakes 2T-1A-2: Nose over

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 MIA98LA108](https://openairdocs.org/ntsb/MIA98LA108.md): Great Lakes 2T-1A-2 · Pierson, FL · Accident · No injuries · Limited investigation · Final report · Mar 25, 1998 · N3751F · Substantial damage
  > the pilot's failure to note the windsock before touchdown which resulted in a downwind landing, and the pilot's improper elevator control. Factors were the tailwind and the pilot's complacency.
- [NTSB CHI95LA010](https://openairdocs.org/ntsb/CHI95LA010.md): Great Lakes 2T-1A-2 · Mt. Horeb, WI · Accident · No injuries · Limited investigation · Final report · Oct 10, 1994 · N933EB · Substantial damage
  > the pilot's excessive braking while taxiing from landing.
- [NTSB LAX84LA468](https://openairdocs.org/ntsb/LAX84LA468.md): Great Lakes 2T-1A-2 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Sep 4, 1984 · N3673L · Substantial damage
  > During the third touch & go landing the certificated plt receiving dual instruction was at the controls when directional control was temporarily lost. The CFI in the front cockpit regained control. Shortly thereafter the plt under instruction applied heavy…

## 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" = 300))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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