NTSB investigations: Robinson Helicopter R22

7 cases on aircraft the registry lists as Robinson Helicopter R22, where the first occurrence was “Loss of engine power”. 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

19832026

NTSB investigations: Robinson Helicopter R22 per year, 1983–2026: 7 cases
1983	1
1985	2
1987	1
1988	1
1999	1
2004	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 ('7640102') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350)) 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 ('7640102')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
  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 ('7640102')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 DEN04LA142Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Spanish Fork, UTthe instructor's premature flare, resulting in a hard landing, and his failure to align the helicopter with the direction of travel, resulting in a rollover.Contributing factors were the low rotor RPM and inadequate airspeed. The reason for the loss of engine…Sep 14, 2004 · N777UH · Substantial damage NTSB NYC99FA157Accident · 1 fatalField investigationFinal reportRobinson R-22 · Hurricane, WVA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain rotor rpm and the transmission wires.Jun 23, 1999 · N9070F · Substantial damage NTSB NYC89LA041Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Sharon, MAEngine power loss while landing due to fuel exhaustion.Nov 29, 1988 · N9035U · Substantial damage NTSB NYC87LA217Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sterling, MABefore flying solo, the student plt & his instructor (CFI) practiced autorotations for about 1/2 hr. The CFI deplaned & the student took off on a solo flt. He flew to a reservoir area for more practice. After descending from about 1000' to 500', the eng lost…Aug 2, 1987 · N9078Z · Destroyed NTSB BFO86LA007Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Manassas, VAA simulated straight in autorotation to runway 34L was entered from final approach by lowering the collective, and a pwrrecovery was planned at the bottom of the autorotation. At about 150 feet AGL, the throttle was rolled in to match the engine and rotor…Nov 29, 1985 · N8499B · Substantial damage NTSB NYC86LA013Accident · No injuriesLimited investigationFinal reportRobinson R22A · Sterling, MAThe accident occurred when the CFI allowed the student who was in a hover maneuver to lose rotor RPM. The helicopter drift rearward, the left rear skid dug into the ground and the helicopter rolled over. RPM decayed so badly that the helicopter could not…Oct 18, 1985 · N9069G · Substantial damage NTSB CHI83FET01Accident · No injuriesFinal reportRobinson R-22 · Wabash, INDuring autorotation practice, when the pilot rolled the throttle off, the engine quit. An engine restart was attempted. This time lapse allowed the rotor RPM to decay and a proper autorotation could not be done in theremaining altitude. The acft landed hard…Aug 12, 1983 · N9031F · Substantial damage