NTSB investigations: Aerofab LAKE LA-250
14 cases on aircraft the registry lists as Aerofab LAKE LA-250. 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
| 1986 | 2 |
|---|---|
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 1997 | 1 |
| 2004 | 2 |
| 2008 | 1 |
| 2016 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5110321'))
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 ('5110321'))
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 ERA17WA090Accident · 3 fatalForeign investigationAerofab Lake LA 250 · Puerto Plata, Dominican RepublicOn October 17, 2016, about 2200 coordinated universal time, an AeroFab, Inc. Lake-250, N724ST, was substantially damaged when it impacted the ocean while on approach to Gregorio Luperón International Airport (POP), Puerto Plata, Dominican Republic. The pilot…NTSB MIA08FA091Accident · 1 fatalField investigationFinal reportAeroFab Lake LA-250 · Skaneateles, NYThe certified flight instructor's failure to maintain airspeed during a steep turn.NTSB IAD04CA026Accident · Minor injuriesData collectionFinal reportLake LA-250 · Deep River, CTThe pilot's improper recovery from a bounced water landing.NTSB FTW04LA086Accident · No injuriesLimited investigationFinal reportLake LA4-270T · Crowley, LAThe pilot's inadvertant water landing with the landing gear extended. Contributing factors were the sunglare and the pilot's failure to verify the position of the flaps and landing gear.NTSB MIA98LA014Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · Miami, FLloss of engine power for an undetermined reason(s), which resulted in a forced landing and subsequent encounter with rough water.NTSB NYC95LA019Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Westfield, MAthe pilot's improper in-flight planning and inaccurate fuel consumption calculations, resulting in fuel exhaustion and the subsequent forced landing at night.NTSB CHI94LA214Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Jefferson City, MOthe pilot allowing the airplane to get into an uncontrolled porpoising situation. A factor related to the accident was the choppy water.NTSB SEA91FA255Accident · 3 fatalField investigationFinal reportLake LA-250 · Sisters, ORImproper planning/decision by the pilot(s), and failure to attain sufficient altitude to remain clear of obstructions. Factors related to the accident were: the pilot(s) failure to use all available runway, high density altitude, rising terrain and trees…NTSB DEN89LA193Accident · Serious injuriesLimited investigationFinal reportAerofab Lake LA-250 · Bullfrog, UTA submerged object in the landing area.NTSB MIA89FA015Accident · Serious injuriesField investigationFinal reportLake LA-4-250 · Key West, FLThe plt reduced engine power during initial climb from a touch and go landing on the gulf of Mexico. The acft stalled and descended uncontrolled back to the water, striking the water hard. The acft then bounced and again hit the water in a nose low right wing…NTSB NYC87LA212Accident · Serious injuriesLimited investigationFinal reportLake LA-4-250 · Westport, NYDrg the takeoff run on a Lake, the amphibian enctrd rough water & became airborne prematurely. The acft then settled onto the water in a slightly nose high attitude & touched down in front of a large wave. The acft's nose crashed head-on into the wave which…NTSB NYC87LA198Accident · No injuriesLimited investigationFinal reportLake LA-250 · Alton Bay, NHThe Lake renegade 250 was making a water takeoff when it started a sharp left turn. The aircraft stopped in the water and the pilot exited without injuries prior to the aircraft turning over. Examination of the aircraft showed that the engine pylon had…NTSB CHI86LA173Accident · No injuriesLimited investigationFinal reportLake LA-250 · Frankfort, MIThe plt rprtd that during an attempted go-around, a crosswind caught the right wing and blew the acft to the left. The left wing hit a hangar door & was torn off, then the acft crashed to the ground & came to rest upside down. The wind was rprtd to be gusting…NTSB SEA86FA126Accident · 4 fatalField investigationFinal reportLake LA-4-250 · Blue River, ORSeveral witnesses reported seeing the acft flying near the eugene arpt at an alt of 400 to 500 ft AGL. The acft was heading toward the Blue River. The acft was then seen flying over the Blue River forest ranger station aprx 7 minutes prior to the accident. At…