NTSB investigations: Consolidated Aeronautics LAKE LA-4-200, CA
10 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
| 1979 | 1 |
|---|---|
| 1980 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 2004 | 1 |
| 2011 | 1 |
| 2021 | 1 |
| 2022 | 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.\"eventStateOrRegion\" = 'CA' 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" = 'CA' 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" 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 WPR22LA327Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Lodi, CAThe pilot’s premature retraction of the landing gear during a go-around, which resulted in a gear up landing.NTSB WPR21LA171Accident · Minor injuriesClass 3 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Twentynine Palms, CAA partial loss of engine power due to inadequate ignition from cracked spark plugs and a failed magneto.NTSB WPR11FA424Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Lakeport, CAThe pilot's decision to continue the takeoff with reduced engine power, which resulted in a collision with terrain during the takeoff initial climb. Contributing to the accident was the partial loss of engine power for reasons that could not be determined…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 LAX92LA256Accident · No injuriesLimited investigationFinal reportLake 200 · Clearlake, CAThe pilot's inadequate weather evaluation of the wind on the Lake and his delay in lift-off. Contributing to the accident was the rough water that existed on the unsheltered section of the Lake.NTSB LAX88LA228Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Clearlake, CAThe pilot reported the airplane's right wing struck a swell during takeoff from a lake. The surface winds, however, were out of the southwest at 10 knots. The pilot had not flown within the preceding 24 calendar months. There were no reported airplane…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 LAX81FUA04Accident · Minor injuriesClosedLake LA-4 · Los Angeles, CANTSB LAX80DVG48Accident · No injuriesClosedLake LA-4 · Lake Berryessa, CANTSB OAK79DVD18Accident · No injuriesClosedLake LA-200 · Stockton, CA