NTSB investigations: Sud SA316B ALOUETTE III

11 cases on aircraft the registry lists as Sud SA316B ALOUETTE III. 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

19742026

NTSB investigations: Sud SA316B ALOUETTE III per year, 1974–2026: 11 cases
1974	2
1978	2
1982	2
1983	2
1984	1
1988	1
1989	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.aircraft_model_code IN ('8680207')) 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.aircraft_model_code IN ('8680207'))
  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.aircraft_model_code IN ('8680207'))
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 DEN90FA028Accident · 1 fatalField investigationFinal reportAerospatiale SA316B · Park City, UTFailure of the pilot to make a vertical takeoff, while departing with a cable attached, and his failure to insure the cable remained clear of the trailer. The trailer (vehicle) was a contributing factor.Nov 28, 1989 · N62268 · Substantial damage NTSB DEN88FA091Accident · No injuriesField investigationFinal reportAerospatiale SA316B · Silver Plume, COApr 2, 1988 · N72590 · Substantial damage NTSB DEN84FA106Accident · Serious injuriesField investigationFinal reportAerospatiale SA-316B · Story, WYOn the day prior to the accident, the plt noted that the fuel gage indicated 30 to 35 gal remaining. He added 40 gal & made a flt of about 15 min. On the next day, he noted that the gage indicated about 40 gal of fuel remaining. The reported fuel consumption…Mar 13, 1984 · N8655 · Substantial damage NTSB NYC83FA244Accident · No injuriesField investigationFinal reportSud SA316B · Pittsburgh, PAThe helicopter was on a flt to transport an acutely ill patient from one hospital to another. The aircrew consisted of a plt & two flt nurses. During arrival at the destination, the plt began an apch to an athletic field that was surrounded by tall bldgs & a…Sep 17, 1983 · N72590 · Destroyed NTSB CHI83LA152Accident · No injuriesLimited investigationFinal reportAerospatiale 316B · Wauseon, OHThe helicopter was involved in a hard landing while engaged in a patient pickup flight for st. vincent hospital. The pilot, doctor and nurse aboard were not injured. The pilot reported the wind at departure 25 miles away was 10 knots. However he estimated the…Mar 27, 1983 · N62268 · Substantial damage NTSB NYC83LA028Accident · No injuriesLimited investigationFinal reportAerospatiale SA316B · West Mifflin, PAPilot turned aircraft into the wind to perform power check. Approximately 3-5 ft above the ground the pilot reportedly began receiving feedback through the cyclic. Moderate then severe vibration of the airframe was reported. Aircraft yawed 90 degrees left and…Nov 13, 1982 · N72590 · Substantial damage NTSB NYC82FGM12Accident · No injuriesFinal reportAerospatiale SA 316B · Crafton, PAShortly after takeoff the pilot heard a loud grinding noise and felt a vibration emanating from the rear of the aircraft. Immediately, the nose yawed to the left and the engine failed. The pilot entered autoration and made a hard landing. Examination of the…Jul 5, 1982 · N8259 · Substantial damage NTSB OAK79DVM06Accident · No injuriesClosedAlouette 316B · King City, CADec 4, 1978 · N62268 · Substantial damage NTSB SEA78FYM32Accident · No injuriesClosedS.N.I.A.S. SA316B · Portland, ORMay 11, 1978 · N5954 · Substantial damage NTSB OAK74FXQ34Accident · Minor injuriesClosedAlouette III · East Dayton, NVApr 24, 1974 · N8259 · Substantial damage NTSB OAK74DVA51Accident · No injuriesClosedAlouette Iiib · Turlock, CAMar 30, 1974 · N7326 · Substantial damage