Skip to content

NTSB investigations: Rolls-Royce DART-542 series

25 cases on aircraft whose registry engine model is Rolls-Royce DART-542 series. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('54522')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.engine_model_code IN ('54522'))
  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.engine_model_code IN ('54522'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 FTW92FA025Accident · No injuriesField investigationFinal reportBeech B19 · Forth Worth, TXInadequate visual lookout by the pilots-in-command of both aircraft, which resulted in their failure to see-and-avoid the other aircraft. A factor related to the accident was: failure of the developmental controller or the supervisor to provide adequate…Nov 20, 1991 · N9343S · 2 aircraft · Substantial damage NTSB ANC91IA046Incident · No injuriesIncident investigationFinal reportNihon YS-11A-600 · Anchorage, AKA jammed nose gear due to incorrect installation of the shear pin. Contributing to the accident was the insufficiently defined maintenance procedure.Mar 27, 1991 · N173RV · Minor damage NTSB CHI90IA106Incident · No injuriesIncident investigationFinal reportNihon YS-11A-600F · West Lafayette, INAn undetected accumulation of ice on the horizontal stabilizer. Relating factors were the manufacturer's lack of information and aircraft manuals relative to the understanding of, and appropriate procedures to prevent the loss of control.Apr 3, 1990 · N112MP · No damage NTSB ATL89FA189Accident · No injuriesField investigationFinal reportConvair 640 (340D) · Atlanta, GAPilot in command failed to place the airplane at a position from which a stabilized approach to landing could be made. His procedure for the recovery from the bounced landing was inadequate and the nose gear structural strength was exceeded during following…Aug 3, 1989 · N5509K · Substantial damage NTSB FTW88MA021Accident · Minor injuriesMajor investigationFinal reportConvair 640 (340D) · Bartlesville, OKThe capt was cross-feeding both engines from the right tank while the first officer (f/o) was flying, without informing the f/o. the capt then left the cockpit while cross-feeding. Both tank valves and the right boost pump were on. The right tank ran dry, the…Oct 28, 1987 · N3411 · Destroyed NTSB NYC87IA167Incident · No injuriesIncident investigationFinal reportNihon YS-11 · Hyannis, MAThe YS-11 was landing with a right crosswind. The pilot said he touched down on the right main landing gear first and upon touchdown, the right main landing gear collapsed. The aircraft stayed on the runway and received minor damage. The cockpit crew of 2, 2…Jun 6, 1987 · N187P · Minor damage NTSB ANC81FA043Accident · No injuriesClosedNihon YS-11A · Sand Point, AKApr 18, 1981 · N173RV · Substantial damage NTSB ATL81IA064Incident · No injuriesClosedNamc YS-11 · Charlotte, NCApr 13, 1981 · N259P · Minor damage NTSB IAD79IA064Incident · No injuriesClosedNamc YS-11A · Charlottesvlle, VAJul 18, 1979 · N259P · Minor damage NTSB MKC79FA033Accident · No injuriesClosedConvair 640 · St Louis, MOMay 31, 1979 · N640R · Substantial damage NTSB CHI79DA001Incident · No injuriesClosedConvair CV-600 · Cleveland, OHOct 3, 1978 · N74855 · Minor damage NTSB FTW72AF074Accident · No injuriesClosedConvair 600 · Alexandria, LAMay 8, 1972 · N94236 · Substantial damage NTSB MIA72IM097Incident · No injuriesClosedConvair 640 · San Juan, PRMar 23, 1972 · N3407 · Minor damage NTSB FTW72AF054Accident · No injuriesClosedConvair 600 · Beaumont, TXFeb 16, 1972 · N94226 · Substantial damage NTSB MIA71AM047Accident · No injuriesClosedConvair 640 · St.Thomas, VIDec 10, 1970 · N3417 · Substantial damage NTSB FTW71AF011Accident · Serious injuriesClosedConvair 600 · Lake Charles, LASep 16, 1970 · N94236 · No damage NTSB IAD71II007Incident · No injuriesClosedNihon YS-11A · Washington, DCJul 28, 1970 · N259P · Minor damage NTSB IAD70II056Incident · No injuriesClosedNihon YS-11A · Roanoke, VAApr 2, 1970 · N159P · Minor damage NTSB IAD70AI047Accident · Serious injuriesClosedNihon YS-11A · Warrenton, VAFeb 23, 1970 · N273P · No damage NTSB OAK68A0056Accident · Serious injuriesClosedConvair 640 · Hilo, HIJan 28, 1968 · N5510K · No damage NTSB FTW67A0009Accident · No injuriesClosedConvair CV-600 · Harlingen, TXJul 11, 1966 · N94215 · Substantial damage NTSB MIA65A0109Accident · No injuriesClosedConvair CV-340 · Ponce, PRApr 27, 1965 · N3412 · Substantial damage NTSB UNK65X0158Incident · No injuriesClosedConvair 240 · Roswell, NMOct 6, 1964 · N94240 · No damage NTSB UNK64X4043Incident · No injuriesClosedConvair CV-340 · San Juan, PRSep 19, 1964 · N3410 · No damage NTSB UNK64X0550Accident · Serious injuriesClosedConvair CV-440 · Hilo, HIFeb 13, 1964 · N5512K · Substantial damage