Final NTSB investigations: Wright C9HE series

9 cases on aircraft whose registry engine model is Wright C9HE 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

19682026

Final NTSB investigations: Wright C9HE series per year, 1968–2026: 9 cases
1968	3
1970	2
1976	1
1977	1
1981	1
1983	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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67029')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67029'))
  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.engine_model_code IN ('67029'))
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 ATL83FA312Accident · No injuriesField investigationFinal reportSikorsky S-58D · Gatlingurg, TNThe helicopter collided with terrain on a wooded mountainside after liftoff. The plt said a power loss occurred after itwas to late to abort. Takeoff was made from a lot that was 5200 ft MSL. The plt hover-checked at 2500 RPM and 39.5 inches of manifold…Aug 6, 1983 · N6488 · Substantial damage NTSB SEA81FA050Accident · 2 fatalClosedSikorsky S-58B · Bellevue, WAAug 7, 1981 · N4247 · Destroyed NTSB CHI78FA002Accident · No injuriesClosedSikorsky S-58E · Flat Rock, MIOct 16, 1977 · N99275 · Destroyed NTSB CHI77FA009Accident · Serious injuriesClosedSikorsky S-58B · Hartford Twp, OHNov 30, 1976 · N8561 · Destroyed NTSB NYC71FFA11Accident · No injuriesClosedSikorsky S-58B · Fonda, NYAug 26, 1970 · N8561 · Substantial damage NTSB NYC71DHD33Accident · No injuriesClosedSikorsky S-58 · Salem, NJJul 8, 1970 · N4247 · No damage NTSB CHI69F0152Accident · No injuriesClosedSikorsky S-58A · Robinson Creek, KYJul 28, 1968 · N4247 · Substantial damage NTSB NYC69F0130Accident · Minor injuriesClosedSikorsky S-58B · North Creek, NYJul 18, 1968 · N887 · Destroyed NTSB DIA69F0015Accident · No injuriesClosedSikorsky S-58A · Duty, VAMay 20, 1968 · N887 · Substantial damage