NTSB investigations: Consolidated Aeronautics LAKE LA-4-200, 1985
4 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\") = 1985
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") = 1985
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 MIA86LA043Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Homestead, FLThe plt stated that while on a flight from marco island FL, to ocean reef FL, he heard a loud bang and elected to land at Homestead general arpt. Upon landing he found the left muffler had seperated from the acft, struck the propeller and was driven through…NTSB NYC86LA035Accident · Serious injuriesLimited investigationFinal reportLake LA4-200 · Millbrook, NYDuring a go-around the aircraft stalled and crashed on the airport.NTSB SEA85LA130Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Truckee, CAContrary to common departure practice, the pilot commenced his takeoff from the lake headed westbound and towards rising terrain. Additionally, he failed to use all the takeoff surface available. The density altitude at donner lake at the time of the accident…NTSB SEA85LA093Accident · No injuriesLimited investigationFinal reportLake Buccaneer · Dexter, ORThe acft bounced during touchdown several times while attending to land on the water. The acft was too close to a dam to make a go-around. The acft then struck the dam head on.