# NTSB investigations: Continental E225 series: In flight collision with terrain/water

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 SEA02FA146](https://openairdocs.org/ntsb/SEA02FA146.md): Beech BE-35 · Idaho Falls, ID · Accident · 3 fatal · Field investigation · Final report · Aug 5, 2002 · N82Z · Destroyed
  > The flying pilot's failure to maintain adequate airspeed resulting in a stall/spin. An additional cause was the flight instructor's inadequate supervision of the flight.
- [NTSB DEN99LA152](https://openairdocs.org/ntsb/DEN99LA152.md): Piper PA-25 · Salida, CO · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1999 · N6249Z · Substantial damage
  > An inadvertent stall during an aborted landing. A factor was the pilot's selection of the wrong runway for landing.
- [NTSB SEA92FA001](https://openairdocs.org/ntsb/SEA92FA001.md): North American Navion · Ola, ID · Accident · 1 fatal · Field investigation · Final report · Oct 4, 1991 · N91577 · Destroyed
  > An incapacitating heart attack while in flight.
- [NTSB DEN83LA174](https://openairdocs.org/ntsb/DEN83LA174.md): Beech C35 · Salida, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1983 · N12370 · Destroyed
  > The acft crashed into a mountain in a controlled crash situation with full flaps and full power at the 11,312 ft level the density alt was computed to be 12,370 ft MSL. The plt was aware that the weather was questionable in some areas of his route and the…
- [NTSB ATL82FKM05](https://openairdocs.org/ntsb/ATL82FKM05.md): Beech F35 · Franklin, NC · Accident · Serious injuries · Final report · Jun 17, 1982 · N248Y · Destroyed
  > The pilot made his initial approach to runway 07 at mason county airport. The approach seemed high to the pilot, so he executed a go-around and decided to land on runway 25. During the second approach, he extended the flaps, but not thelanding gear. When the…
- [NTSB LAX82FUM06](https://openairdocs.org/ntsb/LAX82FUM06.md): Navion A · Ramona, CA · Accident · 3 fatal · Final report · Jan 6, 1982 · N4520K · Destroyed
  > The accident occurred during the final leg of a "share the expenses" commuting flight from hawthorne to romona, CA, when the aircraft collided with the southwest face of mount woodson. Marginal VFR conditions prevailed over the route of flight. During the…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17015')
    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" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17015&occurrence=230

---
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.