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_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 ('1182122')
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 ('1182122')
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 CEN26FA015Accident · Serious injuriesClass 3 · FieldPreliminary reportBell 222 · Huntington Beach, CAOn October 11, 2025, at 1401 Pacific daylight time, a Bell 222 helicopter, N222EX, was substantially damaged when it was involved in an accident near Huntington Beach, California. The pilot and passenger received serious injuries. One person on the ground…NTSB ERA19LA145Accident · Minor injuriesClass 3 · LimitedFinal reportBell 222 · Montgomery, NYA partial loss of engine power, as reported by the pilot, during takeoff for reasons that could not be determined based on available information.NTSB CEN09CA218Accident · No injuriesData collectionFinal reportBell 222 · Milliken, COThe separation of the left engine cowling for undetermined reasons.NTSB CEN09MA019Accident · 4 fatalMajor investigationFinal reportBell 222 · Aurora, ILThe pilot's failure to maintain clearance from the 734-foot-tall lighted tower during the visual night flight due to inadequate preflight planning, insufficient altitude, and a flight route too low to clear the tower. Contributing to the accident was the air…NTSB LAX03IA252Incident · No injuriesIncident investigationFinal reportBell 222 · Salinas, CAThe fatigue failure (fracture) of the right forward transmission lift link during cruise flight, which resulted in a severe vibration and an emergency landing.NTSB LAX99FA003Accident · Minor injuriesField investigationFinal reportBell 222 · Las Vegas, NVThe pilot's failure to ensure that both throttles were in the takeoff position. Factors were the pilot's decision to takeoff with a tailwind, and his lack of recurrent emergency procedure training in this helicopter.NTSB CHI98FA323Accident · 3 fatalField investigationFinal reportBell 222 · Spencer, IAThe below standard (loose) fit of the 'white' swashplate outer ring pin resulting in fatigue and subsequent separation of the pin, and ultimately the in-flight breakup of the rotorcraft. A factor was the manufacturer's dissemination of the pin which did not…NTSB LAX92LA237Accident · Minor injuriesLimited investigationFinal reportBell 222 · Mariposa, CAThe pilot decision to takeoff and fly with a known deficiency in one of the helicopter's engines.NTSB DEN89LA090Accident · No injuriesLimited investigationFinal reportBell 222 · Leadville, COFailure of the pilot to compensate adequately for wind conditions with rudder pedals while maneuvering in unfavorable wind and high density altitude.NTSB NYC86FA183Accident · No injuriesField investigationFinal reportBell B-222A · Staten Island, NYThe helicopter, on a FAR 135 flight was in cruise flt at 900 ft. the plt was checking for called VFR traffic and the co-pilot was occuppied with the RNAV when a loud bang was heard and a sudden yaw was felt. Both crew members stated they reacted as instructed…NTSB FTW86FA016Accident · No injuriesField investigationFinal reportBell 222A · Charenton, LAThe helicopter had just completed a phase two check, twenty minutes into the flight the occupants heard a loud noise and a severe one-to-one vibration ensued. A successful emergency landing was performed. Examination revealed that one swash plate drive link…NTSB ATL85LA017Accident · Minor injuriesLimited investigationFinal reportBell 222 · Pascagoula, MSThe acft sustained substantial damage while taking off from a barge during a FAR 135 medevac flt. Investigation revealedthat the barge was pitching due to rough seas. As the acft lifted, the rear of the acft was struck by the landing platform as it pitched…NTSB ATL84FA277Accident · Serious injuriesField investigationFinal reportBell 222 · Knoxville, TNThe helicopter was in a hover when a rt pedal turn was initiated and a climb attempted. Plt stated, 'I was unable to climb, and the aircraft began to lose rotor RPM. I increased power to 100% mrtq. The acft was settling.' Unable to sustain flt, a landing was…NTSB FTW83IA084Incident · No injuriesIncident investigationFinal reportBell 222 · Houston, TXThe helicopter developed a severe vibration while in flt. The pilot executed an emergency landing with no further acft damage. An examination of the acft revealed that the walking beam assembly located between the swash plate and rotor pitch link had failed.…NTSB NYC82FA230Accident · 1 fatalField investigationFinal reportBell 222 · New York, NYThe helicopter (hel) was being loaded with the engines running. The flt crew were at the ctls when the acdnt occurred. Initially, 4 paxs were escorted to the hel by a customer svc agent. As the 4 boarded, the agent retrieved their carry on baggage. Aft they…NTSB FTW81IA067Incident · No injuriesClosedBell 222 · Lake Charles, LANTSB FTW78FPD07Accident · No injuriesClosedBell 222 · Mansfield, TX
Back to Bell 222