NTSB investigations: Consolidated Aeronautics LAKE LA-4-200
109 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, newest first
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.\"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."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 CHI88LA228Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Fox Lake, ILThe plt had just completed a course at the Lake acft factory school, but had not yet obtained a seaplane rating. After he flew home, he landed on local lakes. He reported that drg a landing on calm water, he expected to hear a 'slush sound' as the hull…NTSB NYC88LA198Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Montpelier, VTEngine power loss due to fuel contamination of water and rust particles in fuel system.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 NYC88LA165Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Wantagh, NYThe pilot was on a return VFR flight to republic airport after having repairs performed on the aircraft. The pilot stated that he experienced an engine power loss and prepared for an emergency landing with the gears retracted. The aircraft landed between two…NTSB FTW88LA121Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Mico, TXThe pilot said he was practicing water landings in the Lake. During a landing, the airplane started porpoising due to the wake of a passing boat. The airplane landed hard. The windsheild cracked and the pilot elected to take the airplane to the home airport…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…NTSB ANC86LA119Accident · No injuriesLimited investigationFinal reportLake LA-4 · Kotzebue, AKDuring the climbout over the mountain ridge, the aircraft began to lose altitude eventually contacting the edge of the ridge. At the time of the accident strong winds and heavy rain was reported in the area.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 MIA86LA127Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · San Juan, PRThe plt stated that on landing the acft started to porpoise. He lost control, the landing gear collapsed and the acft slid to a stop on the rwy.NTSB MIA86FA081Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Auburndale, FLThe plt stated that just after passing lakeland, FL, his eng RPM began to fluctuate. He selected his aux fuel tanks but the RPM continued to deteriorate. He elected to make his forced landing on a small lake but not having enough alt to turn & land into the…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.NTSB MIA84FA203Accident · Serious injuriesField investigationFinal reportLake LA-4-200 · Hollywood, FLAfter arriving at south Lake, the plt made a water landing on a westerly heading. He stated that he was attempting a step-landing & after touching down, the acft traveled about 100 ft, then the control yoke was jerked from his hands. He & the passengers…NTSB CHI84LA258Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Mears, MIThe pilot reported that when the amphibious aircraft reached 8 to 10 feet AGL during takeoff, a x-wind gust caused the left sponson to contact the water surface. This caused loss of control and resulted in the plane crashing inverted in the Lake.NTSB NYC83FNA05Accident · Serious injuriesFinal reportLake LA-4-200 · Stow, MADuring takeoff, the plt encountered a noticeable loss of power & lowered the nose to maintain airspeed. The acft continued to lose altitude, so he selected an open field for an emergency landing. While landing on uneven terrain, the left wing struck the…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…NTSB LAX81FA115Accident · 1 fatalClosedLake LA-4 · Hilo, HINTSB MIA81DLD39Accident · No injuriesClosedLake LA4200 · Sanibel Island, FLNTSB MIA81DA080Accident · No injuriesClosedLake 4-200 · Ponce, PRNTSB LAX81FUA04Accident · Minor injuriesClosedLake LA-4 · Los Angeles, CANTSB FTW81DRG17Accident · No injuriesClosedLake LA-4 · Burnet, TXNTSB NYC81FA001Accident · 2 fatalClosedLake 4-200 · Little Egg, NJNTSB CHI80FEE45Accident · No injuriesClosedLake LA-4 · Highland Park, ILNTSB FTW80FRA44Accident · No injuriesClosedLake LA-4 · Tomball, TXNTSB LAX80DVG48Accident · No injuriesClosedLake LA-4 · Lake Berryessa, CANTSB MIA80DLD77Accident · No injuriesClosedLake LA4200 · Blue Cypress, FLNTSB NYC79DNC32Accident · Minor injuriesClosedLake LA-4 · Wolfeboro, NHNTSB SEA79DYE23Accident · No injuriesClosedLake LA-4 · Bellingham, WANTSB IAD79DID16Accident · No injuriesClosedLake LA4 · Oak Grove, VANTSB NYC79FNC26Accident · No injuriesClosedLake 4-200 · Whitefield, NHNTSB OAK79DVD18Accident · No injuriesClosedLake LA-200 · Stockton, CANTSB SEA79FA023Accident · 3 fatalClosedLake 4-200 · Battle Ground, WANTSB ANC79DA021Accident · 2 fatalClosedLake LA-4 · Missing AircraftNTSB CHI78DEM37Accident · Serious injuriesClosedLake LA4200 · Foster City, MINTSB FTW78FRA37Accident · No injuriesClosedLake 4-200 · Tomball, TXNTSB IAD78FLQ01Accident · No injuriesClosedLake LA-4 · Moscow, OHNTSB ANC77DAH28Accident · No injuriesClosedLake LA-4 · Turquoise Lake, AKNTSB OAK77FXQ32Accident · No injuriesClosedLake LA4 · Lovelock, NV