# NTSB investigations: Beech C90: 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 NYC00FA067](https://openairdocs.org/ntsb/NYC00FA067.md): Beech C-90 · Somerset, KY · Accident · 4 fatal · Field investigation · Final report · Jan 18, 2000 · N74CC · Destroyed
  > the failure of the pilot to follow his approach clearance, and subsequent descent into unprotected airspace which resulted in a collision with the guy wire. Factors were the failure of the air traffic controller to verify the approach he cleared the pilot to…
- [NTSB MIA92GA107](https://openairdocs.org/ntsb/MIA92GA107.md): Beech C90 · St. Augustine, FL · Accident · 2 fatal · Final report · Apr 9, 1992 · N105FL · Destroyed
  > The pilot's failure to properly adhere to the published instrument approach procedure which resulted in descent below the minimum descent altitude. Factors which contributed to the accident were the low ceiling and fog.
- [NTSB ATL86FA032](https://openairdocs.org/ntsb/ATL86FA032.md): Beech C90 · East Greenwich, RI · Accident · 2 fatal · Field investigation · Final report · Nov 27, 1985 · N220F · Destroyed
  > The acft crashed about nine miles short of the rwy during an ILS approach to warwick, RI in IMC wx. The acft had been cleared to descend from 13000 to 3000 ft. the acft crashed outside the outer marker. The co-plt had reported the acft as inside the outer…

## 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 ('1152913', '1153928')
    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=1152913&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.