NTSB investigations: Wright R-1820 series
71 cases on aircraft whose registry engine model is Wright R-1820 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.
Cases, newest first
Query with SQL
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.engine_model_code IN ('67020'))
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.engine_model_code IN ('67020'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 NYC90DNE01Accident · No injuriesFinal reportNorth American T-28B · New Braintree, MAThe failure of the nose gear, which failed to retract with the main landing gear after takeoff; the gear was observed to be misaligned, and collapsed during the aircraft's touchdown.NTSB MIA89LA057Accident · No injuriesLimited investigationFinal reportSikorsky S-58B · Kissimmee, FLThe plt stated that he was repositioning the acft for fuel, and during a practice autorotation attempt the engine hydro-mechanical clutch failed. It did not re-engage upon the application of power and the acft was landed hard.NTSB ATL88FA072Accident · 2 fatalField investigationFinal reportNorth American T-28C · Woodstock, GAA plt/witness rptd that the airplane first flew over the arpt to the North at about 500 ft AGL, and subsequently performed a wingover at the North end of the arpt. The airplane then made a high-speed pass over the rwy to the south, at about 50 ft AGL. Upon…NTSB LAX87DJA07Accident · No injuriesFinal reportEmair MA-1B · Pahala, HIAt the end of an aerial application flt, the plt reported that after approaching the arpt in a light rain, he failed to keep the acft centered on the rwy. The acft exited the rwy to the left where it collided with the terrain and nosed over. There were no…NTSB FTW87LA114Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Ville Platte, LAAfter landing on a wet grass strip the pilot realized that the aircraft was not going to stop. Obstructions off the end of the runway prevented a go-around. The aircraft collided with two trees causing substantial damage.NTSB MIA86FA185Accident · 1 fatalField investigationFinal reportAyres S2R-1820 · Dundee, MSThe ag acft was flying low over a water covered muddy rice field when the eng stopped running. The plt then jettisoned the load of fertilizer & entered a steep right turn. Subsequently, the aircraft struck the ground on the right wing & nose, then…NTSB LAX85FJA06Accident · 1 fatalFinal reportEmroth Emair MA-1B · Pahala, HIWitnesses reported seeing pieces of wood and fabric coming off the acft during it's second swath run. At the end of the run, the acft climbed abruptly to clear trees after which it entered an uncontrolled descent to ground impact. The acft was destroyed by…NTSB ATL84LA211Accident · Serious injuriesLimited investigationFinal reportSikorsky S-55B · Gilbertsville, KYThe acft was used for public rides at an amusement park. During the takeoff to ferry the acft back to an overnight parking space the engine quit at 100 ft AGL. The plt said he started the acft and hovered using fuel from the aft fuel tank. When the engine…NTSB LAX84FA220Accident · 2 fatalField investigationFinal reportNorth American T-28B · Rialto, CAPlt was authorized by acft owner to test fly the acft around the traffic pattern with a local FBO owner on board. Plt made 3 flts, last of which culminated in the accident. On the first and third flts, unauthorized passengers were on board. FBO owner stated…NTSB FTW84LA136Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58E · Morgan City, LAThe helicopter was hovering above trees at about 100 ft AGL when the tail rotor chip detector lgt flickered svrl times, then illuminated steadily. This was followed by a loud grinding noise from the tail area & the acft yawed to the right. The acft entered an…NTSB CHI83LA392Accident · Minor injuriesLimited investigationFinal reportAyres S2R-R1820 · Essexville, MIWhile on a swath run, the acft collided with a power line & crashed in a corn field. The plt received a head injury during the accident & was unable to recall details of the occurrence. According to witnesses, he was on a northerly run & was crossing under…NTSB LAX83FVG14Accident · Serious injuriesFinal reportSikorsky S-58 · Biggs, CAThe plt reported that he brought the helicopter to a hover in the loading area & eased forward to the rwy where he attempted to 'transition from a hover to flt.' He became aware that the helicopter was not going to have sufficient performance, so he elected…NTSB FTW83LA277Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Ville Platte, LAThe acft collided with a dirt levee during takeoff after an engine malfunction. According to the plt he experienced a power failure at liftoff. He dumped his spray load and applied brakes. The engine regained partial power and failed again. At about 60 mph…NTSB DEN83FA058Accident · 1 fatalField investigationFinal reportNorth American T-28A · N. Winter Park, COAccording to the surviving passenger (the plt's 15 yr old son), they saw some skiers after crossing over a mountain pass. He stated that as they turned, his father said, 'let's buzz them.' He reported that they turned sharply, 'sort of dove down to buzz…NTSB ATL81DKQ15Accident · No injuriesClosedEmair MA-1B · Webb, MSNTSB LAX81DJA05Accident · No injuriesClosedMurrayair MA-1B · Honokaa, HINTSB CHI80DEP20Accident · Minor injuriesClosedVertol 42A · Neosho, WINTSB LAX79FUM11Accident · No injuriesClosedGrumman F6F · San Marcos, CANTSB OAK78DVA57Accident · No injuriesClosedEmair MA-1B · Tipton, CANTSB LAX77DUG13Accident · No injuriesClosedGrumman F6F-5 · Elsinore, CANTSB LAX71FUG03Accident · No injuriesClosedN.American AT6-G · El Monte, CA