Skip to content

NTSB investigations · 29

Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('8141604') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('8141604')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('8141604')
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 WPR24LA173Accident · No injuriesClass 4 · LimitedFinal reportSikorsky S-55QT · Benton City, WAThe pilot’s failure to maintain clearance from power lines during a low altitude operation.Jun 3, 2024 · N2302F · Substantial damage NTSB ERA13LA018Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Yorktown, NYThe pilot's improper decision to perform a downwind precautionary landing and the helicopter’s resultant settling with power and impact with terrain.Oct 12, 2012 · N443FD · Substantial damage NTSB WPR11FA350Accident · 1 fatalField investigationFinal reportSikorsky S-55B · Chelan, WAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.Jul 25, 2011 · N5663 · Substantial damage NTSB ATL88DKG08Accident · No injuriesFinal reportSikorsky S-55B · Valdosta, GAJun 16, 1988 · N6489 · Substantial damage NTSB FTW87LA101Accident · Serious injuriesLimited investigationFinal reportSikorsky S-55B · De Quincy, LAThe pilot experienced an engine surge followed by a complete loss of power during a swath run of a tree spraying ag operation. The helicopter was over a densely wooded area and autorotated into trees. The owner was aware of a carburetor problem and had…Apr 23, 1987 · N414A · Substantial damage NTSB DEN84LA230Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Richey, MTThe pilot stated that he landed in a pasture where he intended to refuel. During the landing roll, one of the wheels dropped into a hole, causing the main rotor blade to flex downward and severe the tailboom.Jul 20, 1984 · N24111 · Substantial damage NTSB CHI82DA150Accident · No injuriesFinal reportSikorsky S-55B · Otsego, OHThe pilot was spreading fertilizer by using external buckets. As he was unhooking a bucket, the engine lost power. He did a hovering autorotation, but the helicopter settled on a bucket, tipped over and allowed the main rotor blades to hit the ground. An…May 4, 1982 · N16861 · Substantial damage NTSB MIA80FLD93Accident · Minor injuriesClosedSikorsky S-55B · Titusville, FLAug 27, 1980 · N31611 · Substantial damage NTSB CHI80FEK18Accident · No injuriesClosedSikorsky S-55B · Rushville, OHJul 2, 1980 · N16861 · Substantial damage NTSB MIA79FLD24Accident · No injuriesClosedSikorsky S-55B · Haines, FLDec 19, 1978 · N6489 · Substantial damage NTSB OAK78FVM31Accident · Minor injuriesClosedSikorsky S-55B · Scotts Valley, CAJun 11, 1978 · N865RL · Destroyed NTSB FTW76FPM01Accident · No injuriesClosedSikorsky S-55B · Tulsa, OKOct 1, 1976 · N2305 · Substantial damage NTSB LAX76AL097Accident · 4 fatalClosedSikorsky S-55B · San Bernardino, CASep 22, 1976 · N9389 · Destroyed NTSB IAD76AI047Accident · 1 fatalClosedSikorsky S-55 · California, MDJan 9, 1976 · N3498 · Substantial damage NTSB FTW76FPG34Accident · No injuriesClosedSikorsky S-55B · Little Rock, ARNov 18, 1975 · N15187 · Substantial damage NTSB MKC76DER29Accident · No injuriesClosedSikorsky S-55B · Eden Prairie, MNSep 26, 1975 · N17376 · Substantial damage NTSB MKC76AK003Accident · Minor injuriesClosedSikorsky S-55B · Pine Ridge, SDJul 4, 1975 · N111RS · Substantial damage NTSB OAK74FJA21Accident · No injuriesClosedSikorsky S55B · Kaneohe, HIMay 7, 1974 · N865RL · Substantial damage NTSB SEA74FYC40Accident · No injuriesClosedSikorsky S-55B · Corvallis, ORMar 22, 1974 · N5663 · Substantial damage NTSB NYC74AN032Accident · 1 fatalClosedSikorsky S-55B · Nemacolin, PAOct 9, 1973 · N414A · Destroyed NTSB ANC72AA009Accident · 2 fatalClosedSikorsky S-55B · Valdez, AKAug 12, 1971 · N5096V · Destroyed NTSB ANC71AA018Accident · 1 fatalClosedSikorsky S-55B · Valdez, AKAug 26, 1970 · N455Z NTSB IAD71AI001Accident · No injuriesClosedSikorsky S-55B · Davis, WVJun 30, 1970 · N414A · Substantial damage NTSB NYC70DHA10Accident · Minor injuriesClosedSikorsky S-55B · Scotrun, PAMay 1, 1970 · N16861 · Destroyed NTSB ANC68A0022Accident · No injuriesClosedSikorsky S-55B · Pt.Woronzoff, AKOct 4, 1967 · N5096V · Substantial damage NTSB NYC68A0038Accident · No injuriesClosedSikorsky S-55B · Pittsfield, PASep 1, 1967 · N6872C · Destroyed NTSB ANC67A0035Accident · No injuriesClosedSikorsky S-55B · Clear, AKOct 8, 1966 · N5096V · Substantial damage NTSB UNK64X3246Accident · No injuriesClosedSikorsky S55 · Keene Valley, NYAug 6, 1964 · N6872C · Substantial damage NTSB UNK64X2139Accident · No injuriesClosedSikorsky S55 · Holopaw, FLJun 5, 1964 · N873Z · Substantial damage

Back to Sikorsky S-55B