# NTSB investigations: Rockwell International 690A, FL

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 CEN19LA168](https://openairdocs.org/ntsb/CEN19LA168.md): Rockwell 690 · Jacksonville, FL · Accident · No injuries · Class 3 · Limited · Final report · Jun 10, 2019 · N197GB · Substantial damage
  > The overstress fracture of the roll pin in the nose landing gear (NLG) spacer assembly which caused interference between the nose wheel actuator rod and the left forward gear door actuating rods preventing the NLG to fully extend into the full down and locked…
- [NTSB MIA85LA042](https://openairdocs.org/ntsb/MIA85LA042.md): Rockwell 690A · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Nov 21, 1984 · N44WV · Substantial damage
  > Climbing through 10,000 ft the plt noticed a red gear light and dropping hyd pressure. Prior to the precautionary landing, according to the plt, the gear were extended and indicated down and locked. When reverse thrust was applied the left main gear…
- [NTSB MIA83FA074](https://openairdocs.org/ntsb/MIA83FA074.md): Rockwell 690A · Winter Haven, FL · Accident · 2 fatal · Field investigation · Final report · Feb 13, 1983 · N81416 · Destroyed
  > The acft crashed into a ditch off the departure end of the rwy and burst into flames during takeoff. Witnesses said the acft did not sound like it was developing normal RPM for takeoff. One mechanic said the engines sounded like they were still in ground idle…

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

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

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