# NTSB investigations: Rockwell International 690B: Loss of control - in flight

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 CHI95FA007](https://openairdocs.org/ntsb/CHI95FA007.md): Aero Commander 690B · Springfield, MO · Accident · 1 fatal · Field investigation · Final report · Oct 8, 1994 · N27MT · Destroyed
  > Failure of the pilot to maintain control of the airplane, due to spatial disorientation. A factor related to the accident was: the pilot's lack of recent instrument experience.
- [NTSB FTW92FA169](https://openairdocs.org/ntsb/FTW92FA169.md): Rockwell 690B · Konawa, OK · Accident · 1 fatal · Field investigation · Final report · Jun 25, 1992 · N690JC · Destroyed
  > The pilot's failure to maintain control of the airplane which resulted in an inadvertent spiral and subsequent rapid descent. The design stress limits of the airframe were exceeded resulting in an overload failure of the empennage. Factors related to the…
- [NTSB CHI92FA022](https://openairdocs.org/ntsb/CHI92FA022.md): Rockwell AC 690B · Milton, KS · Accident · 2 fatal · Field investigation · Final report · Nov 2, 1991 · N799V · Destroyed
  > Incapacitation of the pilot in command, followed by the loss of control and an inflight breakup with a unqualified person on the controls.

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

This list as a web page: https://openairdocs.org/ntsb?model=7630516&occurrence=250

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