# NTSB investigations: Aerofab LAKE LA-250, OR

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB SEA91FA255](https://openairdocs.org/ntsb/SEA91FA255.md): Lake LA-250 · Sisters, OR · Accident · 3 fatal · Field investigation · Final report · Sep 29, 1991 · N1404X · Destroyed
  > Improper 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 SEA86FA126](https://openairdocs.org/ntsb/SEA86FA126.md): Lake LA-4-250 · Blue River, OR · Accident · 4 fatal · Field investigation · Final report · May 17, 1986 · N1403A · Destroyed
  > Several 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…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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."eventStateOrRegion" = 'OR' 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 ('5110321'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=5110321&state=OR

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.