# NTSB investigations: Lake LA-4, FL

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 MIA00LA240](https://openairdocs.org/ntsb/MIA00LA240.md): Lake LA-4 · Pensacola, FL · Accident · Serious injuries · Limited investigation · Final report · Aug 17, 2000 · N2015L · Substantial damage
  > The pilot receiving instruction failure to achieve the proper touch down point during a water landing, and the CFI's improper supervision and failure to initiate a go-around in sufficient time to avoid and in-flight collision with trees, water, and subsequent…
- [NTSB MIA92LA009](https://openairdocs.org/ntsb/MIA92LA009.md): Lake LA-4 · Panama City, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 1991 · N25PA · Substantial damage
  > Loss of power due to undetermined reasons. Contributing to the accident was the cfi's inadequate emergency procedures following the reported loss of power.
- [NTSB MIA83LA193](https://openairdocs.org/ntsb/MIA83LA193.md): Lake LA-4 · Gainesville, FL · Accident · No injuries · Limited investigation · Final report · Jul 2, 1983 · N1FQ · Substantial damage
  > The plt stated that during takeoff, the eng appeared to lose power at about 200 ft AGL, but the gauges showed no malfunction. The acft began to settle, so he elected to land on the rwy overrun area. Reportedly, the acft was landed successfully, however, while…
- [NTSB MIA83LA167](https://openairdocs.org/ntsb/MIA83LA167.md): Lake LA-4 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Jun 27, 1983 · N2019L · Substantial damage
  > The acft collided with a tree and landed gear up on floats after an engine failure. The pilot was cruising at 1000 ft MSL when the oil pressure dropped to zero and the engine seized. The acft collided with the tops of pine trees while approaching a nearby…
- [NTSB MIA78FA053](https://openairdocs.org/ntsb/MIA78FA053.md): Lake LA-4 · Pierson, FL · Accident · 1 fatal · Closed · Mar 14, 1978 · N2038L · Destroyed
- [NTSB MIA74FLA47](https://openairdocs.org/ntsb/MIA74FLA47.md): Lake LA-4 · Jacksonville, FL · Accident · No injuries · Closed · Jun 11, 1974 · N7636L · Substantial damage
- [NTSB MIA73DKT78](https://openairdocs.org/ntsb/MIA73DKT78.md): Lake LA-4 · Key West, FL · Accident · No injuries · Closed · Mar 25, 1973 · N455 · Substantial damage
- [NTSB MIA68D0337](https://openairdocs.org/ntsb/MIA68D0337.md): Lake LA-4 · Miami, FL · Accident · No injuries · Closed · Nov 17, 1967 · N1154L · 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" = 'FL' 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=FL

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