# NTSB investigations: Boeing A75: 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 CHI04LA243](https://openairdocs.org/ntsb/CHI04LA243.md): Boeing A75 · Wisconsin Rapid, WI · Accident · 1 fatal · Limited investigation · Final report · Aug 28, 2004 · N86600 · Substantial damage
  > The pilot's improper in-flight decision when he decided to fly at a low altitude over the river and failed to maintain clearance from the power lines. A factor was the wires.
- [NTSB FTW94LA254](https://openairdocs.org/ntsb/FTW94LA254.md): Boeing A75 · Comfort, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 1994 · N60459 · Substantial damage
  > The pilot's inadequate compensation for the crosswind and his failure to push the propeller lever full forward. Factors were the crosswind and the pilot's failure to follow the before takeoff checklist.
- [NTSB LAX86LA215](https://openairdocs.org/ntsb/LAX86LA215.md): Boeing A75 · Angels Camp, CA · Accident · Minor injuries · Limited investigation · Final report · May 10, 1986 · N56760 · Destroyed
  > Numerous ground witnesses observed the aircraft fly low along the river which fed into the new melonies reservoir lake and then collide with unmarked high tension power lines which spanned a narrow portion of the lake. The pilot thought the aircraft was at…
- [NTSB FTW82FRA19](https://openairdocs.org/ntsb/FTW82FRA19.md): Boeing A75 · Chapell Hill, TX · Accident · 1 fatal · Final report · Apr 27, 1982 · N1774B · Destroyed
  > During a pull-up from a swath run, the right wing of the aircraft struck the top of a 45 ft pecan tree. The lower right wing tip separated, and the aircraft rolled inverted and crashed.

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