# NTSB investigations: Raven Industries RALLY RX7: 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 NYC04LA078](https://openairdocs.org/ntsb/NYC04LA078.md): Raven Industries Rally RX7 · Nicholasville, KY · Accident · 1 fatal · Limited investigation · Final report · Feb 28, 2004 · N4110M · Substantial damage
  > The pilot's improper decision to continue the inadvertent flight in variable wind conditions, which resulted in an impact with power lines. Factors were the variable wind conditions and the unsuitable takeoff area.
- [NTSB DEN93LA026](https://openairdocs.org/ntsb/DEN93LA026.md): Raven RX7 · Durango, CO · Accident · No injuries · Limited investigation · Final report · Jan 31, 1993 · N3581T · Substantial damage
  > Partial failure of the balloon's burner for undetermined reasons. A factor was: unfavorable wind.
- [NTSB FTW91LA136](https://openairdocs.org/ntsb/FTW91LA136.md): Raven RX7 · Gonzales, LA · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 1991 · N2801F · Minor damage
  > Unfavorable winds at low altitude. A factor was the electrical power lines.
- [NTSB DEN89LA161](https://openairdocs.org/ntsb/DEN89LA161.md): Raven RX-7 · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 1989 · N4069H · Substantial damage
  > Inadequate visual lookout by the pilot. Contributing to the accident were the power lines.
- [NTSB DEN88LA051](https://openairdocs.org/ntsb/DEN88LA051.md): Raven RX-7 · Rio Rancho, NM · Accident · No injuries · Limited investigation · Final report · Jan 9, 1988 · N2797L · Substantial damage
  > During the landing the plt reported a wind shift which drifted the balloon into pwr lines before the landing could be accomplished. The plt reported she could not see the pwr lines due to the balloon restricting visibility and the pax pointed the lines out to…

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