NTSB investigations: Consolidated Aeronautics LAKE LA-4-200, 1988

5 cases on aircraft the registry lists as Consolidated Aeronautics LAKE LA-4-200. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

19762026
NTSB investigations: Consolidated Aeronautics LAKE LA-4-200, 1988 per year, 1976–2026: 109 cases
19763
19779
19783
19796
19805
19815
19826
19831
19842
19854
19864
19876
19885
19893
19901
19911
19922
19931
19941
19951
19963
19983
19993
20002
20012
20021
20031
20043
20051
20061
20071
20091
20104
20111
20121
20151
20161
20171
20202
20212
20222
20251
20262

Latest cases

Query with SQL
duckdb -csv -c "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 year(c.\"eventDate\") = 1988
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2400108'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB CHI88LA228Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Fox Lake, ILThe plt had just completed a course at the Lake acft factory school, but had not yet obtained a seaplane rating. After he flew home, he landed on local lakes. He reported that drg a landing on calm water, he expected to hear a 'slush sound' as the hull…Sep 1, 1988 · N8012A · DestroyedNTSB NYC88LA198Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Montpelier, VTEngine power loss due to fuel contamination of water and rust particles in fuel system.Jul 30, 1988 · N2883P · Substantial damageNTSB LAX88LA228Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Clearlake, CAThe pilot reported the airplane's right wing struck a swell during takeoff from a lake. The surface winds, however, were out of the southwest at 10 knots. The pilot had not flown within the preceding 24 calendar months. There were no reported airplane…Jun 20, 1988 · N6026V · Substantial damageNTSB NYC88LA165Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Wantagh, NYThe pilot was on a return VFR flight to republic airport after having repairs performed on the aircraft. The pilot stated that he experienced an engine power loss and prepared for an emergency landing with the gears retracted. The aircraft landed between two…Jun 14, 1988 · N6110V · Substantial damageNTSB FTW88LA121Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Mico, TXThe pilot said he was practicing water landings in the Lake. During a landing, the airplane started porpoising due to the wake of a passing boat. The airplane landed hard. The windsheild cracked and the pilot elected to take the airplane to the home airport…Jun 12, 1988 · N666BK · Substantial damage