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

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19772026

NTSB investigations: Consolidated Aeronautics LAKE LA-4-200, AK per year, 1977–2026: 12 cases
1977	4
1982	1
1986	2
1987	1
1989	1
1993	1
2010	1
2022	1

Where

Open the map

Latest cases

Query with 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" = 'AK' 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 ('2400108')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 c.\"eventStateOrRegion\" = 'AK' 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 ('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.

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" = 'AK' 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 ('2400108'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB ANC22LA062Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Anchorage, AKThe pilot’s failure to maintain directional control during the landing rollout in crosswind conditions, which resulted in a runway excursion and impact with equipment.Jul 28, 2022 · N6165V · Substantial damage NTSB ANC10LA062Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Skwentna, AKThe pilot's inadequate flare, which resulted in a nose-low impact with glassy water and a subsequent nose-over. Contributing to the accident was the pilot's diverted attention while landing.Jul 18, 2010 · N8543H · Substantial damage NTSB ANC93LA118Accident · No injuriesLimited investigationFinal reportLake LA4 · Turner Lake, AKPilot-in-command misjudged the landing flare on a glassy water landing. A factor in the accident was the glassy water condition.Jul 15, 1993 · N2672P · Substantial damage NTSB SEA89LA166Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics LAKE-LA-4-200 · Klawock, AKThe pilot misjudged the aircraft height above water while attempting to land on a lake. A contributing factor was the smooth, glassy water surface conditions on the lake.Sep 8, 1989 · N2582P · Destroyed NTSB SEA87LA061Accident · Minor injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Haines, AKWhile at cruise a total loss of engine oil pressure occurred with the engine seizing shortly afterwards. The aircraft was force landed into trees in a remote area. The aircraft came to rest inverted. Due to the position of the aircraft, examination of the…Mar 1, 1987 · N200LK · Destroyed NTSB ANC86LA119Accident · No injuriesLimited investigationFinal reportLake LA-4 · Kotzebue, AKDuring the climbout over the mountain ridge, the aircraft began to lose altitude eventually contacting the edge of the ridge. At the time of the accident strong winds and heavy rain was reported in the area.Aug 1, 1986 · N6169V · Substantial damage NTSB ANC86LA062Accident · 3 fatalLimited investigationFinal reportLake LA-4-200 · Lake Clark, AKThe aircraft crashed in Lake Clark, Alaska, and sank into 170 feet of water. There were no witnesses to the accident; the aircraft was not recovered.May 24, 1986 · N6190V · Destroyed NTSB SEA82FAD01Accident · 1 fatalFinal reportLake LA-4-200 · Ketchikan Intl., AKDeparting under a special VFR clearance, the acft entered IMC within a period of approximately 15 secs after takeoff. The acft struck trees & the ground approximately 2 mi south of the airport.Jul 30, 1982 · N2708P · Destroyed NTSB ANC77DAH28Accident · No injuriesClosedLake LA-4 · Turquoise Lake, AKSep 19, 1977 · N1228L · Substantial damage NTSB ANC77FA052Accident · 4 fatalClosedLake LA-4 · Matanuska Glcr, AKJun 13, 1977 · N1223L · Destroyed NTSB ANC77DAG75Accident · No injuriesClosedLake LA-4 · Anchorage, AKJun 4, 1977 · N6163V · Substantial damage NTSB ANC77DAG56Accident · No injuriesClosedLake LA-200 · Homer, AKMay 8, 1977 · N6107V · Substantial damage