Fatal NTSB investigations: Consolidated Aeronautics LAKE LA-4-200
15 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
| 1977 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1996 | 2 |
| 2004 | 2 |
| 2020 | 1 |
| 2026 | 1 |
Where
Open the mapLatest 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 c.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal'
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" DESCRun 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 ERA26FA317Accident · 2 fatalClass 3 · FieldPreliminary reportConsolidated Aeronautics Lake LA-4-200 · Ithaca, NYOn August 30, 2026, about 1250 eastern daylight time, a Consolidated Aeronautics Inc., Lake LA-4-200, N6185V, was substantially damaged when it was involved in an accident near Ithaca, New York. The pilot and passenger were fatally injured. The airplane was…NTSB WPR20LA301Accident · 1 fatalClass 3 · LimitedFinal reportLake LA4 · Rawlins, WYThe pilot’s decision to depart despite a known mechanical trim malfunction and with a high-density altitude and the airplane at or above its maximum gross weight.NTSB LAX04FA300Accident · 2 fatalField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Oroville, CAthe pilot's failure to maintain clearance from the water's surface, which resulted in his dragging of the right wing pontoon during low-altitude flight. The glassy-surfaced water was a contributing factor to the accident.NTSB NYC04FA157Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Wilmot, NHThe pilot's continued VFR flight into IMC conditions, and his failure to maintain terrain clearance, which resulted in a controlled flight into terrain. Factors in the accident were the low cloud ceiling and the pilot's lack of recent instrument time.NTSB NYC96WA191Accident · 1 fatalForeign investigationLake LA-4 · Azores, PortugalNTSB ATL96FA084Accident · 3 fatalField investigationFinal reportLake 4-200 · Melbourne, FLThe pilot's failure to maintain clearance from trees while maneuvering. A factor was the tailwind condition.NTSB NYC90FA171Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Gt. Barrington, MAThe pilot in command's failure to properly maintain the engine, the inadequate annual maintenance inspection, low compression, and improper magneto timing. A factor was the resultant deteriorated climb performance.NTSB MKC87FA078Accident · 2 fatalField investigationFinal reportLake LA-4-200 · Nixa, MOThe normal procedure for operating at this airstrip was to always take off to the east and land to the west when winds were not excessive. Winds elsewhere in area were from southeast at 13 knots while at this strip, they were from the east at 30 knots. After…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.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.NTSB LAX81FA115Accident · 1 fatalClosedLake LA-4 · Hilo, HINTSB NYC81FA001Accident · 2 fatalClosedLake 4-200 · Little Egg, NJNTSB SEA79FA023Accident · 3 fatalClosedLake 4-200 · Battle Ground, WANTSB ANC79DA021Accident · 2 fatalClosedLake LA-4 · Missing AircraftNTSB ANC77FA052Accident · 4 fatalClosedLake LA-4 · Matanuska Glcr, AK