NTSB investigations: Consolidated Aeronautics LAKE LA-4-200, 1987
6 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
| 1976 | 3 |
|---|---|
| 1977 | 9 |
| 1978 | 3 |
| 1979 | 6 |
| 1980 | 5 |
| 1981 | 5 |
| 1982 | 6 |
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 6 |
| 1988 | 5 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 3 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2009 | 1 |
| 2010 | 4 |
| 2011 | 1 |
| 2012 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 2 |
| 2025 | 1 |
| 2026 | 2 |
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 year(c.\"eventDate\") = 1987
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 year(c."eventDate") = 1987
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 NYC87LA229Accident · No injuriesLimited investigationFinal reportLake LA-4 · Lake George, NYWhile taking off from a Lake, the amphibious aircraft struck an object. The plane settled back into the water breaking the windshield on the passenger's side. The cockpit began filling with water and the acft sank in about 45 feet of water.NTSB MIA87LA221Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · St.Augustine, FLDuring the water takeoff run the plt's forward visibility was momentarily lost as he rotated the acft onto the step. When visibility was regained he realized that the acft was headed towards the shoreline & turned to avoid it during which the rt wing tip was…NTSB CHI87DEM07Accident · Minor injuriesFinal reportLake LA 4-200 · Fife Lake, MIThe plt stated that the engine started to run rough while in cruise flt. After all efforts to smooth it out failed, the plt elected to make a precautionary landing on Fife Lake. The acft landed normally followed by a loud noise and water started to enter the…NTSB ATL87LA146Accident · Minor injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Sparta, NCThe plt attempted a precautionary ldg at a private grass airstrip he had located, after being advised of wx at his intended destination by ATC. Just prior to touchdown, he observed a balloon at mid-field and excuted a go-around. During climbout, he lost sight…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 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…