NTSB investigations: Consolidated Aeronautics LAKE LA-4-200, 1982
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\") = 1982
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") = 1982
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 NYC82DA216Accident · No injuriesFinal reportConsolidated Aero LA-4-200 · Moriches Bay, NYAfter taking off, the pilot climbed to 1000 ft MSL and leveled off. As the throttle was retarded, the engine lost power for an unknown reason. While making a forced landing on a bay, the aircraft struck a submerged object about 100 ft after touching down and…NTSB CHI82DA297Accident · No injuriesFinal reportLake LA-4-200 · Standard Rock, MIAfter landing on a Lake to fish, the water got rough, so the pilot attempted a takeoff. During the takeoff run, the left float hit a wave and broke off. The takeoff was aborted without further damage.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 NYC82FFJ13Accident · Serious injuriesFinal reportLake LA-4-200 · Canandaiqua, NYWhile taking off, an intermittent power loss was encountered. According to the pilot, the aircraft settled and bounced on a paved road at the end of the runway, then engine power returned and the plane began climbing again. At about 60 to 70 ft AGL, power was…NTSB FTW82DA206Accident · No injuriesFinal reportLake LA-4-200 · Rockport, TXA partial loss of power was experienced during takeoff and a forced landing was made on a road. As the pilot was landing, a car pulled out on the road ahead of the aircraft. While manuevering to the right to avoid the car, the right wing struck a road sign…NTSB FTW82DA197Accident · No injuriesFinal reportConsolidated Aeronautics LA-4-200 · Canyon Lake, TXAfter taxiing around the shoreline, taking-off, and landing again, the pilot was unable to takeoff a second time because his left pontoon was submerging. He proceeded to drain the water out at a public boat dock and attempted to make a downwind takeoff due to…