# NTSB investigations, RI: 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 NYC06FA169](https://openairdocs.org/ntsb/NYC06FA169.md): Piper PA-28R-200 · Block Island, RI · Accident · 3 fatal · Field investigation · Final report · Jul 5, 2006 · N5012S · Substantial damage
  > The pilot's inadequate preflight decision making and his failure to maintain terrain clearance during departure. Contributing, were low ceilings, rain, and thunderstorms.
- [NTSB NYC04CA129](https://openairdocs.org/ntsb/NYC04CA129.md): Grumman American AA-5 · Greene, RI · Accident · Minor injuries · Data collection · Final report · May 23, 2004 · N7132L · Substantial damage
  > The pilots improper decision to depart with the flaps set to 10 degrees, and his failure to obtain proper airspeed, which resulted in a collision with trees.
- [NTSB NYC99LA211](https://openairdocs.org/ntsb/NYC99LA211.md): Aeromot AMT-300 · Block Island, RI · Accident · Serious injuries · Limited investigation · Final report · Aug 25, 1999 · N111TE · Destroyed
  > The pilot's failure to abort the takeoff
- [NTSB NYC94LA139](https://openairdocs.org/ntsb/NYC94LA139.md): Cessna 172A · Block Island, RI · Accident · No injuries · Limited investigation · Final report · Jul 26, 1994 · N5647A · Substantial damage
  > The pilot's improper decision to initiate VFR flight into instrument meteorological conditions. The dark night light conditions and the fog were contributing factors.
- [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…
- [NTSB NYC84LA146](https://openairdocs.org/ntsb/NYC84LA146.md): Piper PA-28-151 · Westerly, RI · Accident · No injuries · Limited investigation · Final report · Apr 22, 1984 · N7634F · Substantial damage
  > On final approach to runway 32, the aircraft contacted trees located approximately 600 yard short of the approach end of the runway. The passenger stated after the accident that as the aircraft approached the runway, he noticed the acft was 'a bit too close…

## 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."eventStateOrRegion" = 'RI' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE 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?occurrence=220&state=RI

---
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.