Skip to content

NTSB investigations: Hughes 269A

401 cases on aircraft the registry lists as Hughes 269A. 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, newest first

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 ('4470402')) 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 ('4470402'))
  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 ('4470402'))
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 ATL82DA226Accident · No injuriesFinal reportHughes 269A · Wetumpka, ALThe pilot reported that at the end of a spray run, the engine lost power. He stated that the engine RPM dropped to zero, the airspeed was zero, and he established an autorotation. According to the pilot, the helicopter touched down on rough hilly terrain,…Aug 2, 1982 · N8801F · Substantial damage NTSB NYC82DA172Accident · No injuriesFinal reportHughes 269A · Westfield, MAThe helicopter started to spin around after takeoff during a hover in strong wind. The pilot decided to land. Sideloading broke a skid and the helicopter rolled over during touchdown.Jul 29, 1982 · N8782F · Substantial damage NTSB FTW82FPJ15Accident · Serious injuriesFinal reportHughes 269 · Boise City, OKThe plt had completed conducting tests with dyed water to determine spray pattern & coverage after recently installing special purpose aerial application equipment. While approaching for a landing at a forward speed of 15-20 mph & descending rapidly he…Jul 17, 1982 · N8873F · Substantial damage NTSB CHI82DA245Accident · No injuriesFinal reportHughes 269A · Davison, MIThe student pilot was making a 180 degree pedal turn to the right while hovering. The instructor pilot (ip) stated that after 90 degrees of turn, the rate of turning started to increase and the student applied left pedal to slow the turn. The ip noted that…Jul 12, 1982 · N8902F · Substantial damage NTSB SEA82DA082Accident · No injuriesFinal reportHughes 269A · 2nm Nnm Redmond, WAThe engine lost power during the climb and the pilot executed an autorotation. Upon landing the aircraft rocked back and the main rotor severed the tail boom.Jun 9, 1982 · N8730F · Substantial damage NTSB CHI82DA129Accident · Minor injuriesFinal reportHughes 269A · Lowell, MIDuring the first solo flight in a helicopter the pilot was instructed to make three normal takeoffs and landings. On the second landing, when the aircraft came to a hover, the back of the skid struck the ground during a drift-back. The helicopter rolled and…Apr 21, 1982 · N8059F · Substantial damage NTSB ATL82FA013Accident · 2 fatalClosedHughes 269A · Elizabethton, TNNov 1, 1981 · N8833F · Destroyed NTSB CHI81FEK26Accident · Serious injuriesClosedHughes 269A · Newark, OHJul 25, 1981 · N8737F · Substantial damage NTSB FTW81FPD03Accident · Serious injuriesClosedHughes 269A · Newport, TXNov 9, 1980 · N8825F · Substantial damage NTSB ANC81DAG10Accident · No injuriesClosedHughes 269A · Goose Bay, AKNov 1, 1980 · N8775F · Substantial damage NTSB ATL80FLG15Accident · No injuriesClosedHughes 269 · Beaufort, SCJun 27, 1980 · N8845F · Destroyed NTSB NYC80FFJ06Accident · Minor injuriesClosedHughes 269A · Rochester, NYMay 12, 1980 · N8748F · Substantial damage NTSB FTW80DPD09Accident · No injuriesClosedHughes 269A · Ringo, TXFeb 3, 1980 · N8825F · Substantial damage NTSB MIA79DLG38Accident · Minor injuriesClosedHughes 269A · Trenton, SCSep 29, 1979 · N8853F · Destroyed NTSB LAX79FUK19Accident · No injuriesClosedHughes 269A · Phoenix, AZSep 11, 1979 · N87592 · Substantial damage NTSB ANC79FA089AccidentClosedHughes 269A · Ketchikan, AKSep 8, 1979 · N8746F · Substantial damage NTSB MIA79FKT90Accident · Minor injuriesClosedHughes 269A · Tamiami, FLAug 30, 1979 · N8797F · Destroyed NTSB CHI79FEC32Accident · No injuriesClosedHughes 269A · Pontiac, MIJun 24, 1979 · N8863F · Substantial damage NTSB MKC79FA032Accident · Serious injuriesClosedHughes 269A · Kansas City, MOMay 25, 1979 · N8864F · Destroyed NTSB FTW79DPJ15Accident · Minor injuriesClosedHughes 269A · Alva, OKMay 5, 1979 · N8892F · Substantial damage NTSB IAD78FKW11Accident · Minor injuriesClosedHughes 269A · Columbia, TNSep 10, 1978 · N8808F · Substantial damage NTSB DEN78FTE94Accident · No injuriesClosedHughes 269A · Crook, COAug 31, 1978 · N8892F · Substantial damage NTSB MKC78FA057Accident · Serious injuriesClosedHughes 269A · Jefferson City, MOAug 1, 1978 · N90MP · Substantial damage NTSB MKC78DCG52Accident · No injuriesClosedHughes 269A · Springhill, KSJul 17, 1978 · N8864F · Substantial damage NTSB CHI78FEV42Accident · No injuriesClosedHughes 269A · Williamsfield, ILJul 10, 1978 · N8774F · Substantial damage NTSB MKC78DCA38Accident · Minor injuriesClosedHughes 269A · Hannibal, MOJul 7, 1978 · N8777F · Destroyed NTSB SEA78FA033Accident · 1 fatalClosedHughes 269A · Vancouver, WAMay 25, 1978 · N8850F · Destroyed NTSB MIA78FLD43Accident · Serious injuriesClosedHughes 269A · Vero Beach, FLMay 10, 1978 · N8798F · Destroyed NTSB DEN78DTC05Accident · No injuriesClosedHughes 269A · Rawlins, WYNov 25, 1977 · N8891F · Substantial damage NTSB MIA77DKG70Accident · No injuriesClosedHughes 269A · Royston, GAAug 24, 1977 · N8869F · Destroyed NTSB MIA77DKJ77Accident · No injuriesClosedHughes 269A · Clanton, ALAug 21, 1977 · N8877F · Substantial damage NTSB FTW77FPM18Accident · No injuriesClosedHughes 269A · Council Hill, OKAug 21, 1977 · N8716F · Substantial damage NTSB MIA77DKJ71Accident · No injuriesClosedHughes 269A1 · Mt.Meigs, ALAug 11, 1977 · N8897F · Substantial damage NTSB MKC77FCQ48Accident · Minor injuriesClosedHughes 269A · Herndon, KSJul 15, 1977 · N8892F · Substantial damage NTSB CHI77FEE30Accident · No injuriesClosedHughes 269 · Woodstock, ILJun 27, 1977 · N8925F · Substantial damage NTSB CHI77FEG20Accident · No injuriesClosedHughes 269A · Cincinnati, OHJun 15, 1977 · N8910F · Substantial damage NTSB MKC77DCQ18Accident · Minor injuriesClosedHughes 269A · Caldwell, KSFeb 18, 1977 · N8751F · Substantial damage NTSB MKC760CQ73Accident · No injuriesClosedHughes 269A · Alden, KSAug 7, 1976 · N8873F · Substantial damage NTSB CHI76FEP38Accident · Minor injuriesClosedHughes 269A · Abbotsford, WIJul 25, 1976 · N8929F · Substantial damage NTSB MIA76FLG38Accident · Minor injuriesClosedHughes 269A · Fair Play, SCJul 12, 1976 · N8718F · Substantial damage NTSB FTW76DRG53Accident · No injuriesClosedHughes 269A · Castroville, TXMay 22, 1976 · N8871F · Substantial damage NTSB MIA76FKG51Accident · Serious injuriesClosedHughes 269A · Comer, GAApr 3, 1976 · N8897F · Substantial damage NTSB CHI76FEG12Accident · Serious injuriesClosedHughes 269A · West Charlestn, OHApr 3, 1976 · N444E · Destroyed NTSB CHI76FEC36Accident · Minor injuriesClosedHughes 269A · Richmond, MIMar 28, 1976 · N8880F · Destroyed NTSB IAD76FLJ18Accident · No injuriesClosedHughes 269A · Pinehurst, NCFeb 8, 1976 · N8769F · Destroyed NTSB CHI76DEC11Accident · No injuriesClosedHughes 269A · Howell, MISep 14, 1975 · N8823F · Substantial damage NTSB MIA76FLG11Accident · No injuriesClosedHughes 269A · Lexington, SCAug 20, 1975 · N8872F · Substantial damage NTSB MKC75DCQ58Accident · No injuriesClosedHughes 269A · Atwood, KSJun 26, 1975 · N8892F · Substantial damage NTSB NYC75FKG79Accident · No injuriesClosedHughes 269A · Brooklet, GAJun 17, 1975 · N8731F · Substantial damage NTSB MIA75FLG41Accident · Serious injuriesClosedHughes 269A · Reidville, SCJun 8, 1975 · N8853F · Substantial damage