NTSB investigations: Rolls-Royce DART-510&511

7 cases on aircraft whose registry engine model is Rolls-Royce DART-510&511. 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

19622026

NTSB investigations: Rolls-Royce DART-510&511 per year, 1962–2026: 7 cases
1962	1
1963	1
1965	1
1966	1
1980	2
1985	1

Where

Open the map

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 ('54504')) 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 ('54504'))
  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 ('54504'))
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 FTW86LA006Accident · No injuriesLimited investigationFinal reportFairchild F-27 · Houston, TXAcft veered left off the runway shortly after touchdown, collapsing the nose gear. Winds at the time would have resulted in direct crosswind of 9 kns. The crew that was contracted to ferry the acft noted, when they picked it up, that there were several open…Oct 7, 1985 · N4302F · Substantial damage NTSB ATL81IA004Incident · No injuriesClosedFairchild F-27 · Raliegh, NCOct 9, 1980 · N112TA · Minor damage NTSB NYC80IA073Incident · No injuriesClosedFairchild F-27 · Flushing, NYAug 19, 1980 · N112TA · Minor damage NTSB CHI67A0052Accident · No injuriesClosedViscount V-745D · Muskegon, MIOct 13, 1966 · N7408 · Substantial damage NTSB NYC65I0112Incident · No injuriesClosedViscount V-745D · Richmond, VAMar 3, 1965 · N7441 · No damage NTSB FTW63A0119Accident · 3 fatalClosedFairchild F-27 · Salt Lake City, UTJan 17, 1963 · N2703 · Destroyed NTSB MKC62A0006Accident · No injuriesClosedFairchild F-27 · Waterloo, IAFeb 25, 1962 · N4302F · Substantial damage