# NTSB investigations, RI: Miscellaneous/other

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 NYC03LA060](https://openairdocs.org/ntsb/NYC03LA060.md): Piper PA-28-235 · Westerly, RI · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 2003 · N8547N · Substantial damage
  > The pilot-in-command's delayed remedial action when the airplane flew below the glidepath, and a total loss of engine power for undetermined reasons.
- [NTSB NYC03LA005](https://openairdocs.org/ntsb/NYC03LA005.md): Piper PA-28-181 · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 2002 · N5675V · Substantial damage
  > The pilot's misjudgment of speed and distance as a result of physical impairment due to smoke.
- [NTSB IAD97LA094](https://openairdocs.org/ntsb/IAD97LA094.md): Piper PA-28-161 · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1997 · N80964 · Destroyed
  > The pilot's failure to comply with the airplane's takeoff checklist and his delayed decision to abort the takeoff.
- [NTSB NYC96LA150](https://openairdocs.org/ntsb/NYC96LA150.md): Saab-Scania 340A · Providence, RI · Accident · Serious injuries · Limited investigation · Final report · Jul 11, 1996 · N744BA · No damage
  > the passenger inadvertently lost his balance and fell, while deplaning.
- [NTSB NYC88IA112](https://openairdocs.org/ntsb/NYC88IA112.md): Boeing 757 · Providence, RI · Incident · No injuries · Incident investigation · Final report · Mar 22, 1988 · N628DL · No damage
  > The Boeing 757 was climbing through 20000 ft with the first officer on the flight controls when the 55 year old captain became incapacitated. The first officer delcared an emergency and made a normal landing. When clear of the runway, the aircraft was stopped…

## 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" = 430)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=430&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.