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(total) - nonmechanical”. 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

19822026

NTSB investigations: Robinson Helicopter R22 per year, 1982–2026: 7 cases
1982	1
1984	3
1987	1
1998	1
2003	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" = 353)) 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\" = 353))
  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" = 353))
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 FTW03LA124Accident · No injuriesLimited investigationFinal reportRobinson R22 · Freer, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel en route. A contributing factor was the lack of suitable terrain available for the forced landing.Apr 5, 2003 · N9071K · Substantial damage NTSB NYC98LA173Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Duncannon, PAThe pilot's disregard of the fuel condition during the preflight which resulted in a takeoff with contaminated fuel and a loss of power. A factor was the pilot's lack of recent experience.Aug 26, 1998 · N9067G · Substantial damage NTSB NYC87LA134Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Ellington, CTDuring an instructional flight, the instructor pilot simulated a forced landing at about 250 feet and 60 KIAS. The student pilot at this time entered an autorotation and the helicopter started to descend. Collective was pulled but this failed to stop the…Apr 29, 1987 · N9070F · Substantial damage NTSB ATL85FA070Accident · 1 fatalField investigationFinal reportRobinson R22 · Moundsville, WVThe helicopter crashed aprx 1/2 mi from the marshall county arpt while on a personal flt. Investigaton revealed that the plt, a doctor who specialized in emergency room procedures, commuted between hospitals located in three different cities. The plt had been…Dec 30, 1984 · N9030B · Destroyed NTSB ATL85LA010Accident · No injuriesLimited investigationFinal reportRobinson R22 · Hueytown, ALThe acft crashed into a river while on final approach to land. The plt reported that he allowed engine RPM to drop and at the same time applied collective pitch. The acft struck the water in a steep descent. There was no report of any failures or malfunctions.Oct 13, 1984 · N90218 · Destroyed NTSB MKC84FPG01Accident · Serious injuriesFinal reportRobinson R22 · Frenchman'Bayou, ARThe acft crashed during autorotation into a soy bean field after the engine lost power. The plt was a student who did not have authorization to fly nor the proper certificate and endorsement from the CFI. The acft engine stopped due to fuel exhaustion. The…Aug 21, 1984 · N9073Y · Substantial damage NTSB ATL83LA061Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Nashville, TNDuring an autorotation at about 125 ft AGL the student attempted to apply power for a recovery but noted that the oil pressure light was illuminated & the eng had quit. The CFI took the controls & executed an emergency landing. He maneuvered to avoid power…Dec 11, 1982 · N90773 · Substantial damage