# NTSB investigations: Rockwell International 690B, CA

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 WPR15TA002](https://openairdocs.org/ntsb/WPR15TA002.md): Rockwell International 690B · Grass Valley, CA · Accident · No injuries · Final report · Oct 4, 2014 · N700PQ · Substantial damage
  > The pilot’s unstabilized approach and failure to go around and his subsequent failure to maintain directional control during the landing roll.
- [NTSB LAX99LA241](https://openairdocs.org/ntsb/LAX99LA241.md): Rockwell 690B · Monterey, CA · Accident · No injuries · Limited investigation · Final report · Jun 17, 1999 · N480K · Substantial damage
  > The failure of maintenance personnel to properly adjust the drag brace preload during recent landing gear maintenance, which resulted in the overload failure and separation of the hydraulic cylinder attach boss.
- [NTSB LAX93FA086](https://openairdocs.org/ntsb/LAX93FA086.md): Rockwell 690B · Herlong, CA · Accident · 2 fatal · Field investigation · Final report · Dec 31, 1992 · N300CP · Destroyed
  > An inadvertent encounter with severe turbulence which exceeded the design strength of the airplane's structure.

## 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" = 'CA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7630516'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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