NTSB investigations: Rockwell International 690C
8 cases on aircraft the registry lists as Rockwell International 690C. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1981 | 1 |
|---|---|
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2008 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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 ('7630517'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 ('7630517'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA08LA117Accident · No injuriesLimited investigationFinal reportRockwell 690C · Minden, NVThe collapse of both main landing gear for undetermined reasons.NTSB LAX96LA343Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Truckee, CAThe inadequate visual outlook by both pilots while in the vicinity of the airport. A factor was that each aircraft was on a different frequency at the time.NTSB FTW94LA092Accident · No injuriesLimited investigationFinal reportRockwell 690C · Hayden, COFailure by the pilot to maintain proper altitude. A factor was dark night conditions.NTSB DEN93FA017Accident · 1 fatalField investigationFinal reportRockwell 690C · Golden, COThe pilot flying the aircraft beyond the design maneuvering speed and exceeding the design stress limits. A factor was: clear air turbulence.NTSB DEN91IA076Incident · No injuriesIncident investigationFinal reportAero Commander 690C · Denver, COFatigue failure of flap cable.NTSB BFO91LA017Accident · No injuriesLimited investigationFinal reportRockwell 690C · Summerville, WVPilot's failure to maintain adequate aircraft control during the landing flare/touchdown. The turbulent weather was a related factor.NTSB LAX88LA218Accident · No injuriesLimited investigationFinal reportRockwell 690C · Hayward, CAAt the end of a cross country flight, while on final approach to the runway, the right engine quit. Shortly thereafter, the left engine quit. The pilot made a forced landing in a field short of the runway where during the landing roll the airplane collided…NTSB FTW81FA032Accident · 2 fatalClosedAero Comdr 690C · Patterson, LA