# NTSB investigations: Beech K35: 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 CHI00FA284](https://openairdocs.org/ntsb/CHI00FA284.md): Beech K35 · Manitowish Watr, WI · Accident · 2 fatal · Field investigation · Final report · Sep 2, 2000 · N3076C · Destroyed
  > the pilot not maintaining altitude/clearance from the trees during an approach on a dark, low overcast night, the pilot's improper use of an IFR procedure without clearance, and the pilot's improper in-flight decision to attempt an IFR approach without…
- [NTSB LAX88LA232](https://openairdocs.org/ntsb/LAX88LA232.md): Beech B35 · Weaverville, CA · Accident · No injuries · Limited investigation · Final report · Jun 24, 1988 · N5354E · Substantial damage
- [NTSB ATL87FA082](https://openairdocs.org/ntsb/ATL87FA082.md): Beech K35 · Arden, NC · Accident · 1 fatal · Field investigation · Final report · Mar 9, 1987 · N621M · Destroyed
  > Plt departed charleston, SC for raleigh earlier in the day. While at raleigh he discussed pending legislation with assoc. He departed raleigh about 2228 EST in wx of indef 100 and 1/2 mile visibility. His destination was forecast to have occasional ceilings…
- [NTSB ATL83FA129](https://openairdocs.org/ntsb/ATL83FA129.md): Beech K35 · Birmingham, AL · Accident · 2 fatal · Field investigation · Final report · Mar 7, 1983 · N9543R · Destroyed
  > The acft collided with trees and terrain during a practice localizer approach at night to rwy 23 at Birmingham municipalarpt. The weather was VMC and the pilot was not instrument rated. On approaching Birmingham from tri-cities, NC the pilot asked for a…

## 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 ('1151524')
    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=1151524&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.