# NTSB investigations: Wright C7BA series: 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 ATL98LA121](https://openairdocs.org/ntsb/ATL98LA121.md): Rockwell S-2R · Colquitt, GA · Accident · Serious injuries · Limited investigation · Final report · Aug 25, 1998 · N5506X · Destroyed
  > The pilot's inadequate visual lookout, and his failure to maintain adequate clearance of known equipment, resulted in the collision with the field irrigation system.
- [NTSB MKC89LA018](https://openairdocs.org/ntsb/MKC89LA018.md): Rockwell S2R · Sublette, KS · Accident · Serious injuries · Limited investigation · Final report · Nov 1, 1988 · N5517X · Substantial damage
  > While conducting an aerial application operation, the aircraft struck some cross-country power lines. The acft nosed down and struck the terrain, causing substantial damage to the acft and serious injuries to the pilot. The pilot was unable to recall the…
- [NTSB SEA86LA178](https://openairdocs.org/ntsb/SEA86LA178.md): Ayres S-2R · Kuna, ID · Accident · 1 fatal · Limited investigation · Final report · Jul 24, 1986 · N5017X · Destroyed
  > Acft was observed in orbit pattern near object field for night aerial application. Plt overflew object field secured acft lights and shortly thereafter collided with powerline tower. Plt had made application at this field four previous times this year. Ground…

## 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 ('67017')
    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?engine=67017&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.