Final NTSB investigations: Rockwell International 500-S
11 cases on aircraft the registry lists as Rockwell International 500-S. 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
| 1978 | 1 |
|---|---|
| 1983 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1999 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2008 | 1 |
| 2011 | 1 |
| 2014 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7630410'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7630410'))
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 WPR14TA278Accident · No injuriesFinal reportRockwell International 500 S · Willcox, AZThe pilot’s failure to compensate for tailwind conditions and maintain directional control during landing, which resulted in a runway excursion.NTSB CEN11TA279Accident · No injuriesFinal reportRockwell International 500-S · Eden Prairie, MNThe pilot's inadequate compensation for the crosswind while landing, which resulted in a loss of directional control.NTSB CEN09CA156Accident · No injuriesData collectionFinal reportRockwell International 500-S · Grand Forks, NDThe pilot's failure to extend the landing gear prior to touchdown.NTSB ANC03LA032Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Chickaloon, AKThe improper installation of an engine fuel line fitting by contracted maintenance personnel resulting in an in-flight engine fire. Contributing factors in the accident were an inadequate annual inspection by company maintenance personnel, and the lack of…NTSB ATL02IA079Incident · No injuriesIncident investigationFinal reportRockwell International 500-S · Jackson, ALThe pilot's inadequate preflight planning and preparation, which resulted in fuel exhaustion, loss of engine power in both engines, and subsequent forced landing in a field.NTSB NYC02FA060Accident · 1 fatalField investigationFinal reportRockwell 500S · Exeter, RIThe pilot's failure to maintain control after encountering icing conditions while on approach for landing. Factors in this accident were the night light conditions and pilot's failure to select the airplane's propeller de-icing switches to the "on" position.NTSB CHI99LA059Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Plymouth, INthe pilot's failure to maintain directional control of the airplane while landing. Factors associated with the accident were the tailwind condition and the pilot landing in the wrong direction.NTSB LAX91LA313Accident · No injuriesLimited investigationFinal reportRockwell 500S · Kahului, HIThe pilot's inadequate preflight inspection of the aircraft after refueling. The failure of the aircraft manufacturer to publish the refueling instructions in the operator's manual, the inadequate fuel servicing of the aircraft by other maintenance personnel…NTSB MIA88LA165Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Jacksonville, FLThe plt stated that he had just brought the acft to a stop & had shut down both engs. At that time, the lt. gear collapsed. Maintenance crew found that one of the actuating cyls was out of adjustment & the bungee cords were weak. The gear assy itself appeared…NTSB MKC83FA059Accident · No injuriesField investigationFinal reportRockwell 500-S · Kansas City, KSA gear up, forced landing was made on the east bank of the Kansas river after both engines quit due to fuel exhaustion. The pilot had landed at new orleans for fuel and requested the tanks be topped off. En route to Kansas City,the pilot stopped at Nevada, MO…NTSB NYC78FGM41Accident · No injuriesClosedAero Comdr 500S · Beaver Falls, PA