# NTSB investigations: Lake LA-4: Loss of control - on ground/water

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 ANC93LA136](https://openairdocs.org/ntsb/ANC93LA136.md): Lake LA04 · Blair Lake, AK · Accident · No injuries · Limited investigation · Final report · Aug 7, 1993 · N6669L · Substantial damage
  > The pilot's inadvertant entry into a porpoise and subsequent loss of control while step-taxiing prior to takeoff. A factor in the accident was the rough water conditions.
- [NTSB ANC87LA098](https://openairdocs.org/ntsb/ANC87LA098.md): Lake LA-4 · Cool Lake, AK · Accident · No injuries · Limited investigation · Final report · Jul 16, 1987 · N1135L · Substantial damage
  > The pilot stated that during the takeoff on the Lake the aircraft would not lift off the water and he lost directional control of the aircraft causing it to collide with the Lake shore.
- [NTSB NYC85LA188](https://openairdocs.org/ntsb/NYC85LA188.md): Lake LA-4 · Sidney, ME · Accident · No injuries · Limited investigation · Final report · Jul 21, 1985 · N6668L · Substantial damage
  > According to the plt, the acft was on step and in indicating about 45 KTS airspeed. It then encountered a boat wake and began flying. The acft porpoised 2 or 3 times and then collided with the water in an estimated 10 to 15 deg nose down attitude. The pwr was…

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

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

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