Final NTSB investigations: Fairchild Heli-Porter PILATUS PC6/C-H2

10 cases on aircraft the registry lists as Fairchild Heli-Porter PILATUS PC6/C-H2. 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

19672026

Final NTSB investigations: Fairchild Heli-Porter PILATUS PC6/C-H2 per year, 1967–2026: 10 cases
1967	1
1968	1
1972	2
1974	2
1977	1
1979	1
1983	1
2016	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.aircraft_model_code IN ('3375014')) 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.aircraft_model_code IN ('3375014'))
  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 ('3375014'))
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 ANC17FA004Accident · 1 fatalField investigationFinal reportFairchild Heli-Porter Pilatus PC-6 · Port Alsworth, AKThe airplane's collision with mountainous terrain while operating in an area of reduced visibility and icing conditions. Contributing to the accident was the pilot's inadequate preflight planning, which would have identified deteriorating weather conditions…Oct 29, 2016 · N5308F · Substantial damage NTSB LAX83FVD07Accident · No injuriesFinal reportPilatus PC-6/C-H2 · Lodi, CAAccording to the pilot as he made an approach to land he advanced the power lever to gain more thrust but he felt that the propeller went into beta range due to play in the propeller control linkage. At aprx 50 feet AGL and 200 feet from the end of the…Sep 26, 1983 · N361F · Substantial damage NTSB IAD79IA044Incident · No injuriesClosedFairchild PC-6C · Raeford, NCApr 11, 1979 · N361F · Minor damage NTSB FTW78FA001Accident · 5 fatalClosedPilatus PC6CH2 · Oklahoma City, OKOct 5, 1977 · N331V · Destroyed NTSB LAX75DUJ05Accident · No injuriesClosedPilatus PC-6 · Mt Baldy, AZJul 9, 1974 · N351FH · Destroyed NTSB FTW74FQD13Accident · No injuriesClosedPilatus PC6CH2 · El Paso, TXJan 13, 1974 · N62524 · Substantial damage NTSB OAK72DJY02Accident · No injuriesClosedPilatus PC6CH2 · Bn Xieng Lom, LaosApr 7, 1972 · N359F · Substantial damage NTSB OAK72DJY17Accident · No injuriesClosedPilatus PC6CH2 · Nong Kha, LaosMar 20, 1972 · N365F · Substantial damage NTSB OAK69O0006Accident · No injuriesClosedPilatus PC-6C · Vientiane, LaosMay 25, 1968 · N359F · Substantial damage NTSB SEA68D0042Accident · Serious injuriesClosedFairchild PC-6CH · Mccall, IDJul 9, 1967 · N358F · Substantial damage