# NTSB investigations: Beech 58P: In flight collision with object

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 CHI03FA296](https://openairdocs.org/ntsb/CHI03FA296.md): Beech 58P · Grand Marais, MN · Accident · 2 fatal · Field investigation · Final report · Aug 28, 2003 · N285V · Destroyed
  > The continued descent below minimum descent altitude and the altitude/clearance not maintained by the pilot during approach to the airport. The low ceiling was a contributing factor.
- [NTSB SEA99FA027](https://openairdocs.org/ntsb/SEA99FA027.md): Beech 58P · Yamhill, OR · Accident · 4 fatal · Field investigation · Final report · Jan 7, 1999 · N700LF · Destroyed
  > The pilot's failure to maintain clearance from hilly terrain while maneuvering below a low ceiling. Factors include a dark night, a low ceiling, fog, and hilly terrain.
- [NTSB SEA88LA043](https://openairdocs.org/ntsb/SEA88LA043.md): Beech 58P · Ketchikan, AK · Accident · 2 fatal · Limited investigation · Final report · Feb 1, 1988 · N3689D · Destroyed
  > Acft collided with trees 1400 ft short of rwy during ILS approach. The acft was left of centerline and about 100 ft below glideslope at that time. Witnesses heard sounds of increased power and impact. When the approach clearance was given the wx was 1000 ft…

## 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.aircraft_model_code IN ('1152744')
    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" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1152744&occurrence=220

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