# NTSB investigations: Lake LA-4, CA

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 WPR21LA312](https://openairdocs.org/ntsb/WPR21LA312.md): Lake LA-4 · Lake Isabell, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 3, 2021 · N7615L · Substantial damage
  > The pilot’s failure to establish a positive climb rate after takeoff, which resulted in an impact with an object.
- [NTSB WPR17LA165](https://openairdocs.org/ntsb/WPR17LA165.md): Lake LA 4 · Byron, CA · Accident · No injuries · Class 3 · Limited · Final report · Jul 25, 2017 · N7628L · Substantial damage
  > The pilot’s failure to activate the hydraulic system during the approach, and his failure to ensure that the landing gear was down and locked before touchdown. Contributing to the accident was the pilot's decision to operate the airplane with an inoperative…
- [NTSB LAX87LA019](https://openairdocs.org/ntsb/LAX87LA019.md): Lake LA4-180 · Folsom, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 18, 1986 · N1118L · Substantial damage
  > During a local cross country pleasure flight, the pilot attempted a landing on Lake Folsom. Upon touchdown the aircraft began settling in the water then nosed over and sank. The pilot stated he felt there was an object in the water that was struck. Witnesses…
- [NTSB LAX76FUA08](https://openairdocs.org/ntsb/LAX76FUA08.md): Lake LA-4 · Long Beach, CA · Accident · No injuries · Closed · Sep 17, 1975 · N6683L · Destroyed
- [NTSB LAX68D0214](https://openairdocs.org/ntsb/LAX68D0214.md): Lake LA-4 · Avalon, CA · Accident · No injuries · Closed · Nov 12, 1967 · N2007L · Substantial damage
- [NTSB LAX67D0311](https://openairdocs.org/ntsb/LAX67D0311.md): Lake LA-4 · Mortmar, CA · Accident · No injuries · Closed · Mar 2, 1967 · N2006L · Destroyed
- [NTSB LAX67D0286](https://openairdocs.org/ntsb/LAX67D0286.md): Lake LA-4 · Oxnard, CA · Accident · No injuries · Closed · Feb 13, 1967 · N1132L · Substantial damage
- [NTSB LAX66D0005](https://openairdocs.org/ntsb/LAX66D0005.md): Lake LA-4 · Long Beach, CA · Accident · No injuries · Closed · Jun 14, 1965 · N1120L · Substantial damage
- [NTSB LAX65F0028](https://openairdocs.org/ntsb/LAX65F0028.md): Lake LA-4 · Los Angeles, CA · Accident · No injuries · Closed · Mar 29, 1965 · N1137L · Substantial damage
- [NTSB LAX65F0039](https://openairdocs.org/ntsb/LAX65F0039.md): Lake LA-4 · Catalina Is, CA · Accident · Serious injuries · Closed · Mar 7, 1965 · N1027L · Destroyed
- [NTSB LAX65F0035](https://openairdocs.org/ntsb/LAX65F0035.md): Lake LA-4 · Long Beach, CA · Accident · Minor injuries · Closed · Feb 16, 1965 · N1134L · Substantial damage
- [NTSB UNK64X0432](https://openairdocs.org/ntsb/UNK64X0432.md): Lake LA4 · Long Beach, CA · Accident · No injuries · Closed · Feb 2, 1964 · N1120L · Substantial damage

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

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

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