NTSB investigations: Aerofab LAKE LA-250
4 cases on aircraft the registry lists as Aerofab LAKE LA-250, where the first occurrence was “Loss of control - in flight”. 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 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 2004 | 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 IAD04CA026Accident · Minor injuriesData collectionFinal reportLake LA-250 · Deep River, CTThe pilot's improper recovery from a bounced water landing.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 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…