Skip to content

NTSB investigations: Consolidated Aeronautics LAKE LA-4

17 cases on aircraft the registry lists as Consolidated Aeronautics LAKE LA-4. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19752026

Where

Latest cases

Query with SQL

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 ('2400102')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2400102'))
  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 ('2400102'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 GAA16CA062Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4 · Morganton, NCThe pilot's failure to maintain directional control during the departure, resulting in substantial damage to the airplanes right wing.Nov 14, 2015 · N1204L · Substantial damage NTSB GAA15CA078Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA4-200 · Mineral, VAThe pilot's failure to maintain directional control during a high-speed water taxi in rough water conditions, resulting in a collision with a dock.May 16, 2015 · N1105L · Substantial damage NTSB ATL97LA020Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · St. Petersburg, FLFuel exhaustion for undetermined reasons.Nov 27, 1996 · N1109L · Substantial damage NTSB BFO90LA040Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Have De Grace, MDThe pilot failed to maintain directional control, and used excessive braking trying to regain control.Apr 28, 1990 · N1086L · Substantial damage NTSB MIA90LA016Accident · Minor injuriesLimited investigationFinal reportLake LA-4 · Apalachicola, FLBinding and subsequent failure of the #1 exhaust valve. A factor related to the accident was: the soft/wet (swampy) terrain condition in the emergency landing area.Oct 21, 1989 · N1212L · Substantial damage NTSB ANC87LA102Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Kenai, AKThe pilot-in-command of the amphibious airplane applied inadequate technique during the takeoff attempt and compounded the problem by delaying aborting the takeoff. He changed his mind twice before flying/skidding into trees. The pilot stated that he should…Jul 20, 1987 · N1217L · Substantial damage NTSB MIA84FA197Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Marathon, FLThe plt reported that he was flying low & in level flt over the ocean when the acft hit the wake from a large boat & flipped over. According to witnesses, the acft began a right turn while flying low, then the right wing hit the water & the acft cartwheeled &…Jun 30, 1984 · N1211L · Destroyed NTSB MIA84FA165Accident · 1 fatalField investigationFinal reportConsolidated Aeronautics Lake LA-4 · Fort Myers, FLThe eng was heard 'popping' & misfiring during the takeoff roll. About 1 min later while climbing thru 400-500 ft, the plt reported an eng failure & was cleared to land on any rwy. The acft entered a left turn, stalled & spun into a parking lot. An exam of…May 11, 1984 · N1119L · Destroyed NTSB SEA82DA121Accident · No injuriesFinal reportLake LA-4 · Newport, ORThe pilot reported that during takeoff, he had accelerated to about 40 mph, and was on the step, when he hit a wave of sufficient size to bounce and become momentarily airborne. He was still accelerating and bounced a second time when it became apparent that…Jul 16, 1982 · N1216L · Substantial damage NTSB MIA81DLA35Accident · No injuriesClosedLake LA-4 · Gainesville, FLSep 13, 1981 · N2528P · Substantial damage NTSB ANC80FA089Accident · 1 fatalClosedLake 4-200 · Hewitt Lake, AKAug 24, 1980 · N1108L · Substantial damage NTSB IAD78FA068Accident · 1 fatalClosedTed Smith 601P · Bumpass, VAMay 26, 1978 · N10HF · Substantial damage NTSB FTW76DQG96Accident · No injuriesClosedLake LA-4 · Littlefield, TXJul 2, 1976 · N1211L · Substantial damage NTSB FTW76FRA34Accident · No injuriesClosedLake LA-4 · Baytown, TXApr 22, 1976 · N1109L · Substantial damage NTSB MIA76FKG38Accident · Serious injuriesClosedLake LA4200 · Ringgold, GADec 21, 1975 · N1082L · Substantial damage NTSB ANC76DAG60Accident · Minor injuriesClosedLake LA-4 · Paxson, AKOct 17, 1975 · N1097L · Substantial damage NTSB CHI76FEG04Accident · No injuriesClosedLake LA-4 · Batavia, OHSep 2, 1975 · N1082L · Substantial damage