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 ('1181420')
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 ('1181420')
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 WPR23LA338Accident · Serious injuriesClass 3 · LimitedFinal reportBell 212 · Balch Camp, CAThe pilot’s inadequate performance planning for the operation that resulted in an excessive gross weight for the operating conditions, leading to a loss of altitude during maneuvering and contact with trees. Contributing to the accident was the pilot’s…NTSB WPR21LA268Accident · No injuriesClass 3 · LimitedFinal reportBell 212HP · Weed, CAThe pilot’s failure to maintain altitude during an approach to a lake. Contributing to the accident was the pilot’s failure to release the full water bucket as the helicopter was settling, which reduced the helicopter’s out-of-ground-effect performance.NTSB WPR18LA242Accident · Serious injuriesClass 3 · LimitedFinal reportBell 212 · Dardanelle, CAAn in-flight failure of the trunnion bearing and subsequent failure of the drive link and swashplate support, which resulted in the loss of helicopter control.NTSB WPR11LA277Accident · Serious injuriesLimited investigationFinal reportBell 212 · Mesa, AZThe pilot's failure to maintain helicopter control while in a low hover.NTSB WPR09TA356Accident · 1 fatalFinal reportBell 212 · Willow Creek, CAThe rappeller's failure to properly latch the rappelling harness to the rappelling assembly before exiting the helicopter.NTSB LAX06TA284Accident · No injuriesFinal reportBell 212 · Happy Camp, CAFailure of compressor second stage stator vane for undetermined reasons while maneuvering.NTSB FTW04LA220Accident · Minor injuriesLimited investigationFinal reportBell 212 · Umpire, ARThe pilot's encounter with settling with power resulting in a loss of control. A contributing factor was the high density altitude.NTSB LAX04TA264Accident · No injuriesFinal reportBell 212HP · Chester, CAthe pilot's excessive use of the cyclic and collective controls in response to the helicopter's unexpected rocking motion, which led to a main rotor contact with the upper wire cutter mounted on the cabin roof. A factor in the accident was the rough, sloping…NTSB ANC03GA023Accident · Serious injuriesFinal reportBell 212 · McMurdo Station, AYThe pilot's continued operation of the helicopter with an unstable external load, which resulted in damage to the cargo hook assembly, adjacent throttle controls, and subsequent loss of engine power, precipitating an emergency descent and impact with terrain.…NTSB SEA03LA012Accident · No injuriesLimited investigationFinal reportBell 212 · Longview, WAThe pilot's failure to maintain clearance from trees while landing. A contributing factor was trees.NTSB DEN01TA134Accident · No injuriesFinal reportBell 212 · Jackson, WYthe Bell 212 helicopter pilot's inadequate visual lookout which resulted in a midair collision.NTSB LAX00FA130Accident · 1 fatalField investigationFinal reportBell 212 · Snelling, CAthe in-flight separation of the main rotor mast while in cruise flight following a mast bumping event. The reason for the mast bumping event was not determined.NTSB DEN00LA045Accident · Serious injuriesLimited investigationFinal reportBell 212 · Mt Pleasant, UTFailure of the main rotor mast due to fatigue that resulted from inadequate quality assurance during the manufacturing process.NTSB MIA00FA030Accident · 2 fatalField investigationFinal reportBell 212 · Philadelphia, MSThe failure of the pilot and company maintenance personnel during preflight and periodic inspections to identify the signs of fretting and looseness in the "red" main rotor blade pitch change horn to main rotor blade grip attachment, resulting in the…NTSB SEA99LA141Accident · No injuriesLimited investigationFinal reportBell 212 · Snoqualmie, WAClearance from an object was not maintained. A tree was a factor.NTSB SEA98GA159Accident · No injuriesFinal reportBell 212 · Juntura, ORThe pilot-in-command's failure to maintain proper clearance between the long line cable and hell hole structure resulting in airframe contact and binding of the cable. This resulted in separation/disabling of the fuel control solenoid and a subsequent…NTSB FTW96TA261Accident · Minor injuriesFinal reportBell 212 · Pagosa Springs, COThe pilot's failure to comply with performance data for hover out of ground effect. A factor was not attaining load jettison.NTSB BFO93WA146Accident · No injuriesForeign investigationBell 212 · Marjan, Saudi ArabiaNTSB FTW92FA077Accident · 1 fatalField investigationFinal reportBell 212 · Morgan City, LAThe inflight separation of the main rotor system as results of the main rotor static stop contacting the mast for undetermined reasons.NTSB LAX91TL#06Accident · No injuriesClass 3Final reportBell 212 · Coulterville, CANTSB LAX90T#A07Accident · Minor injuriesClass 3Final reportBell 212 · Yosemite, CANTSB ANC88LA148Accident · No injuriesLimited investigationFinal reportBell 212 · Deadhorse, AKThe pilot encountered a whiteout condition and elected to land on a frozen lake approximately 3 miles southwest of the airport. After touchdown on the ice, the helicopter broke the ice and rolled over on its back. The helicopter was destroyed by ground fire.NTSB ANC84FA017Accident · Serious injuriesField investigationFinal reportBell 212 · Nuiqsut, AKThe search & rescue flt had been dispatched from barrow to an acft accident site adjacent to the Nuiqsut arpt. Accordingto the plt, upon arriving at Nuiqsut at 300 ft AGL the visibility was 2-3 mi. They lined up with snow machines for a visual apch to the…NTSB SEA84LA012Accident · No injuriesLimited investigationFinal reportBell 212 · Coos Bay, ORThe helicopter snagged a cable with its skid during takeoff and rolled over. The acft had landed for fuel and was takingoff after refueling when a cable attached to a fertilizer dispencer caught on the helicopter's skid. The acft rolled to the right and…NTSB FTW83LA327Accident · No injuriesLimited investigationFinal reportBell 212 · Eugene IslandAfter making an apch to an off-shore oil well heliport, the plt believed the tail rotor was too close to a stairwell, so he made a peddle turn to the right. During the turn, the tail rotor blades contacted a crane. The crane was located about 15 ft from the…NTSB LAX83FA277Accident · 2 fatalField investigationFinal reportBell 212 · Goleta, CAThe plt stated that as he approached the oil rig & reduced power to start his descent from 500 ft, the tail rotor (t/r) pedals began to vibrate. The vibrations became worse with a further reduction of power to reduce airspeed. The plt then planned a descent…NTSB FTW82DA076Accident · Serious injuriesFinal reportBell 12 · Mustang Blk A11While the helicopter was at flight idle waiting for the next load of passengers to board, a passenger, who had been trained in helicopter safety, walked into the rotor blades. The passenger was attempting to pass behind the tail rotor when he was struck in…NTSB ANC81FA098Accident · Serious injuriesClosedBell 212 · Kenai, AKNTSB LAX81FA007Accident · No injuriesClosedBell 212 · City Of Indust, CANTSB FTW80IA098Incident · No injuriesClosedBell 212 · Sabine Pass, TXNTSB FTW80FRD16Accident · No injuriesClosedBell 212 · Houma, LANTSB FTW79FA035Accident · 1 fatalClosedBell BH212 · Galveston, TXNTSB FTW78FA059Accident · Serious injuriesClosedBell 212 · Morgan City, LANTSB FTW78FA038Accident · 3 fatalClosedBell 212 · Galveston, TXNTSB ANC77DAG65Accident · Minor injuriesClosedBell 212 · Portage Glac., AKNTSB FTW76AF041Accident · 9 fatalClosedBell 212 · Gulf Of Mexico (Gulf of Mexico)NTSB FTW76OF001Accident · 1 fatalClosedBell 212 · Banjul (Atlantic Ocean)NTSB DEN75DQA11Accident · No injuriesClosedBell 212 · Red Hill, NM
Back to Bell 212