# NTSB investigations: 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.

Page 19 of 19 · 902 cases

## Cases, newest first

- [NTSB SEA82IA029](https://openairdocs.org/ntsb/SEA82IA029.md): Embraer EMB-11OP1 · Boise, ID · Incident · No injuries · Incident investigation · Final report · Feb 18, 1982 · N101RA · Minor damage
  > This aircraft, which was departing on a scheduled flight to lewiston, ID., was just accelerated to rotation speed when the crew heard one of the passengers scream. The takeoff WA successfuly aborted and the aircraft was returned to the gate. Investigation…
- [NTSB ATL82FA032](https://openairdocs.org/ntsb/ATL82FA032.md): Mooney M20G · Henderson, NC · Accident · 1 fatal · Field investigation · Final report · Jan 10, 1982 · N3688N · Destroyed
  > The pilot and his wife were at 6000 ft on a VFR cross-country when he became unconscious. The aircraft was equipped with a wing leveler and continued in level flight while the pilot's wife attended to him. When the pilot's wife could do nothing more for him,…

## 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 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&page=19

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