Fatal NTSB investigations: Rockwell International 690A
11 cases on aircraft the registry lists as Rockwell International 690A. 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
| 1974 | 1 |
|---|---|
| 1978 | 1 |
| 1983 | 2 |
| 1985 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 2011 | 1 |
| 2024 | 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.\"highestInjuryLevel\" = 'Fatal'
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"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."highestInjuryLevel" = 'Fatal'
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" 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 ERA24FA209Accident · 2 fatalClass 3 · FieldFinal reportRockwell International 690A · Palmyra, VAThe pilot’s loss of control following an encounter with structural icing, which resulted in an inflight breakup of the airplane.NTSB WPR12MA046Accident · 6 fatalMajor investigationFinal reportRockwell 690 · Apache Junction, AZThe pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…NTSB FTW95FA114Accident · 2 fatalField investigationFinal reportRockwell 690A · Guthrie, OKThe pilot's failure to maintain adequate airspeed due to airframe ice, which resulted in a loss of control. Factors contributing to the accident were the pilot's continued flight into adverse weather, his failure to obtain weather information either before or…NTSB CHI93FA302Accident · 5 fatalField investigationFinal reportRockwell 690-A · Norfolk, NEThe failure of the pilots of the Rockwell 690-A, N707BP, and the Piper PA-28R, N33056, to see and avoid each other. A factor which contributed to the accident was the failure of both pilot's to follow recommended communication procedures contained in the…NTSB FTW92FA099Accident · 1 fatalField investigationFinal reportRockwell 690A · Taos, NMThe pilot in command's failure to maintain the climb after departing the runway environment. Factors were the weather conditions and the dark night.NTSB MKC88FA089Accident · 1 fatalField investigationFinal reportAero Commander 690A · Little Rock, ARThe plt had just rtrnd fm vacation in the Bahamas bfr starting a flt fm Little Rock to atlanta with an intermediate stopat memphis. This itinerary was flwd by a rtrn flt to Little Rock via a reverse routing. Witnesses rprtd the plt said he had only 2 hrs of…NTSB CHI86FA007Accident · 2 fatalField investigationFinal reportGulfstream 690A · Cadillac, MIThe acft was cleared for an NDB approach to Cadillac. The wkwas 300 ft ovcst, 1 mile vis. Shortly after cancelling IFR the acft crashed on the opposite side of the arpt from the approach end of the rwy. The pilot activated rwy lights were never turned on…NTSB FTW83FA431Accident · 2 fatalField investigationFinal reportRockwell 690A · Nacogdoches, TXAfter transporting passengers from longview, TX to Oklahoma city, ok & return to longview, the acft was refueled for a flt back to Nacogdoches, TX, where the acft was based. About 12 min after takeoff, the plt was cleared for an NDB apch to Nacogdoches &…NTSB MIA83FA074Accident · 2 fatalField investigationFinal reportRockwell 690A · Winter Haven, FLThe 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…NTSB FTW78FA047Accident · 2 fatalClosedAero Comdr 690A · Calumet, OKNTSB DEN75AD027Accident · 1 fatalClosedRockwell 690A · Kingston, UT