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 ('1182206')
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 ('1182206')
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 CEN26LA185Accident · No injuriesClass 3 · LimitedFinal reportBell 407 · Dallas, TXThe pilot’s failure to maintain situational awareness and clearance from the helipad surveillance camera during liftoff.NTSB WPR26LA172Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Young, AZThe pilot’s failure to maintain clearance from a tree stump during landing in mountainous terrain.NTSB ERA26LA170Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Jacksonville, FLThe pilot’s improper recovery from a practice autorotation, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving the instruction.NTSB WPR26FA098Accident · 2 fatalClass 3 · FieldPreliminary reportBell 407 · Flagstaff, AZOn February 4, 2026, at 2216 mountain standard time, a Bell 407 helicopter, N56AZ, was substantially damaged when it was involved in an accident near Flagstaff, Arizona. The pilot and tactical flight officer (TFO) were fatally injured. The helicopter was…NTSB WPR26LA062Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Las Vegas, NVTail rotor blade impact from an unidentified object at an undetermined time.NTSB CEN25LA380Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Decatur, TXThe instructor candidate’s erroneous operation of the throttle during an autorotation from altitude with power recovery, which resulted in a hard landing.NTSB WPR25LA173Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Bountiful, UTThe pilot’s improper decision to depart with inadequate clearance from a hangar door.NTSB WPR24LA265Accident · Minor injuriesClass 3 · LimitedFinal reportBell 407 · Raft River, IDThe pilot’s misdiagnosis of an erroneous engine instrument indication and his subsequent decision to enter an autorotation, which resulted in a hard landing due to degraded visual cues and low ambient light conditions. Contributing to the accident were the…NTSB ENG24LA028Incident · No injuriesClass 3 · LimitedFinal reportBell 407 · Oktaha, OKThe loss of engine power due to high cycle fatigue failure of a power turbine stage 3 turbine wheel blade. The resulting engine imbalance caused a decoupling of the gas producer stage 1 and stage 2 turbine wheels leading to a stage 1 turbine overspeed and…NTSB WPR24LA247Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Stanley, IDA sudden wind shift which resulted in a rapid descent and subsequent dynamic rollover and collision into water.NTSB ERA24LA045Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Chesterfield, VAA hard landing, which resulted in a main rotor strike of the left vertical stablizer.NTSB ENG23LA045IncidentClass 3 · LimitedFinal reportBell 407 · Linden, NJThe fracture of the upper-left tail boom attachment bolt due to abnormal loading of the bolt caused by a gap and misalignment between the upper-left longeron and the tail boom. Contributing to this incident was the lack of a check to verify the absence of…NTSB WPR23FA302Accident · 3 fatalClass 3 · FieldFinal reportBell 407 · Cabazon, CAThe Skycrane flight crew’s decision to enter the Fire Traffic Area’s 7-nm NOCOM ring at an altitude significantly above their maximum cleared altitude, which resulted in their need for an aggressive descent into congested airspace and subsequent failure to…NTSB CEN23FA071Accident · 4 fatalClass 3 · FieldFinal reportBell 407 · Galliano, LAThe pilot’s failure to ensure the helicopter was clear of obstacles before takeoff from the helideck, which resulted in the helicopter’s right landing skid pivoting about a helideck perimeter light during takeoff and a dynamic rollover. Additionally, the…NTSB CEN23LA053Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Searcy, ARThe pilot’s failure to maintain clearance from the electrical box while repositioning.NTSB CEN23FA019Accident · 1 fatalClass 3 · FieldFinal reportBell 407 · Morgan City, LAThe pilot’s loss of consciousness due to a cardiovascular event.NTSB WPR22LA333Accident · Serious injuriesClass 3 · LimitedFinal reportBell 407 · Mount Baldy, CAThe pilot’s failure to ensure the throttle was properly positioned before commencing an approach to land, which resulted in a low rotor rpm condition and impact with terrain. Contributing to the accident was a worn throttle detent.NTSB ANC22FA041Accident · Serious injuriesClass 3 · FieldFinal reportBell 407 · Kalea, HIThe in-flight separation of the tail boom as a result of abnormal loading and fracture of the upper-left tail boom attachment bolt due to a gap between the upper-left longeron and aft fuselage bulkhead.NTSB CEN22FA100Accident · 2 fatalClass 3 · FieldFinal reportBell 407 · Houma, LAThe pilot’s sudden loss of consciousness for undetermined reasons during cruise flight, which resulted in a loss of control and impact with terrain.NTSB CEN21LA456Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Patterson, LAThe pilot’s failure to maintain adequate clearance from a parked helicopter while hovering to reposition for takeoff.NTSB ERA21LA264Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Tampa, FLThe pilot’s improper landing flare while making a power off practice autorotative landing. Contributing was the decreased visual cues provided by the recently paved runway during the night landing conducted with the aid of night vision goggles.NTSB CEN20CA395Accident · No injuriesClass 4 · Data collectionFinal reportBell 407 · Fort Worth, TXThe flight instructor’s delay in rolling the throttle to the fly position during a practice autorotation maneuver that resulted in a hard landing.NTSB CEN20WA246Accident · No injuriesForeign investigationBell 407 · Long Marston, United KingdomThe government of the United Kingdom has notified the NTSB of an accident involving a Bell 407 helicopter that occurred on June 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of the United Kingdom's investigation…NTSB CEN20LA068Accident · No injuriesClass 3 · LimitedFinal reportBell 407 · Minot, NDThe pilot's failure to maintain clearance from fencing around the landing pad during landing, which resulted in the tail rotor contacting the fence.NTSB ERA20FA056Accident · 1 fatalClass 3 · FieldFinal reportBell 407 · Headland, ALPilot incapacitation by a sudden cardiac event related to severe coronary artery disease, which resulted in a loss of helicopter control.NTSB CEN20FA035Accident · 2 fatalClass 3 · FieldFinal reportBell 407 · Gulf of Mexico (Gulf of Mexico)A total loss of engine power due to the failure of the engine’s Nos. 3 and 4 bearings and the power turbine pinion gear, and subsequent loss of main rotor rpm, which resulted in a loss of control and impact with the water.NTSB CEN19FA095Accident · 2 fatalClass 2 · FieldFinal reportBell 407 · Galliano, LAThe pilot's loss of control during cruise flight as a result of spatial disorientation while operating the helicopter in close proximity to terrain in marginal meteorological conditions.NTSB CEN19FA072Accident · 3 fatalClass 1 · FieldFinal reportBell 407 · Zaleski, OHThe NTSB determines that the probable cause of this accident was Survival Flight's inadequate management of safety, which normalized pilots' and operations control specialists' noncompliance with risk analysis procedures and resulted in the initiation of the…NTSB ERA17FA274Accident · 2 fatalField investigationFinal reportBell 407 · Charlottesville, VAThe pilot's loss of helicopter control after entry into vortex ring state, leading to a high rate of descent to the ground with a right spin. Contributing to the accident was the pilot's lack of recent and recurrent training in vortex ring state recognition…NTSB CEN17LA174Accident · No injuriesLimited investigationFinal reportBell 407 · Venice, LAAn in-flight separation of the tip block from the tail rotor blade due to an inadequate blade repair, which resulted in a rotor imbalance sufficient to crack the gearbox attachment studs and gearbox support assembly, and inadequate postrepair test procedures,…NTSB CEN17FA112Accident · 1 fatalField investigationFinal reportBell 407 · Chauvin, LAThe pilot's failure to maintain proper altitude resulting in a collision with water for reasons that could not be determined based on the available information.NTSB CEN17LA188Accident · No injuriesLimited investigationFinal reportBell 407 · Fort Worth, TXThe flight instructor's failure to prevent the engine/rotor overspeed condition during the demonstration maneuver and the excessive descent rate during the emergency landing, which resulted in a hard landing. Contributing to the engine/rotor overspeed…NTSB CEN16LA386Accident · Serious injuriesLimited investigationFinal reportBell 407 · Lawton, OKThe pilot's loss of helicopter control during landing, which resulted in a hard landing and collision with a wall.NTSB WPR16FA037Accident · 4 fatalField investigationFinal reportBell 407 · McFarland, CAThe pilot's loss of control and collision with terrain while attempting a course reversal after inadvertently entering an area of reduced visibility weather conditions. Contributing to the accident was the pilot's lack of recent experience with night time…NTSB CEN16LA027Accident · No injuriesLimited investigationFinal reportBell 407 · San Antonio, TXThe failure of the No. 3 tail rotor adapter and shaft due to a loss of torque on the retaining nut. Contributing to the accident was the lack of a requirement to inspect the tail rotor assembly for security in the helicopter manufacturer's maintenance manual…NTSB GAA16CA039Accident · No injuriesData collectionFinal reportBell 407 · Cameron, LAThe pilot's failure to remove a main rotor blade tiedown, which resulted in substantial damage to a main rotor blade when the engine was started.NTSB CEN15LA288Accident · Serious injuriesLimited investigationFinal reportBell 407 - NO Series · South Timbalier 127The pilot's lack of awareness of the severity of the gusting winds, which led to the helicopter being pushed off of the oil platform by a wind gust during engine start. Contributing to the accident was the unavailability of a nearby weather monitoring system.NTSB CEN15LA265Accident · No injuriesLimited investigationFinal reportBell 407 · Pecan Island, LAThe fatigue fracture of the tail rotor gearbox attachment studs, which resulted in a loss of tail rotor control and a subsequent hard landing.NTSB GAA15CA002Accident · No injuriesData collectionFinal reportBell 407 · Justin, TXAbnormal ground contact during an autorotation demonstration, resulting in a severed tailrotor driveshaft.NTSB CEN15IA046Incident · No injuriesIncident investigationFinal reportBell 407 · Viosca Knoll 989Engine power surges during takeoff for reasons that could not be determined during postaccident testing of the engine and the engine control unit.NTSB WPR14CA373Accident · Minor injuriesData collectionFinal reportBell 407 · Moab, UTThe pilot's failure to ensure adequate clearance from terrain while landing on sloped terrain.NTSB CEN14IA270Incident · No injuriesIncident investigationFinal reportBell 407 · Eugene Island 182AThe improper repair of the outer combustion case, which led to its ultimate failure due to the continued progression of a fatigue crack and resulted in a partial loss of engine power during takeoff.NTSB CEN14FA232Accident · No injuriesField investigationFinal reportBell 407 · Telluride, COThe failure of the power turbine thrust (No. 5) bearing due to overheating as a result of oil starvation, which led to the engine failure. Also causal to the accident was an undocumented repair to the gearbox cover oil delivery tube port during which an…NTSB CEN13FA491Accident · Minor injuriesField investigationFinal reportBell 407 · Ship Shoal 208H (Gulf of Mexico)The ingestion of vented methane gas into the helicopter’s engine during takeoff, which caused an engine compressor surge that led to a total loss of engine power.NTSB WPR13TA205Accident · No injuriesFinal reportBell BHT407 · Big Fork, MTThe pilot’s failure to maintain helicopter control while maneuvering over mountainous terrain in strong up/downdrafts and possible mountain wave activity, which resulted in a loss of tail rotor effectiveness.NTSB WPR13IA059Incident · No injuriesIncident investigationFinal reportBell 407 · Riverton, WYThe pilot’s failure to maintain sufficient altitude to clear power lines while maneuvering at low altitude. Contributing to the accident was the pilot’s failure to follow company operating specifications for minimum altitude.NTSB ERA13FA014Accident · 2 fatalField investigationFinal reportBell 407 · Coolbaugh Township, PAThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions due to self-imposed pressure to complete the trip, which resulted in impact with trees and terrain.NTSB CEN13FA003Accident · 1 fatalField investigationFinal reportBell 407 · Intracoastal City, LAThe pilot’s decision to attempt a local flight in marginal visual meteorological conditions and his subsequent loss of control following an inadvertent encounter with instrument metrological conditions shortly after takeoff.NTSB ERA12TA538Accident · Minor injuriesFinal reportBell 407 · Bath, NYThe pilot's improper recovery from an in-flight upset, which resulted in the main rotor striking and separating the tail boom. Contributing to the accident was the helicopter manufacturer's failure to warn pilots of unanticipated and unequal aft cyclic…NTSB ERA12FA527Accident · 1 fatalField investigationFinal reportBell 407 · Abingdon, VAThe pilot's improper decision to make a low-level departure over water in dark night conditions without lights, which resulted in controlled flight into the water. Contributing to the accident was the pilot's likely spatial disorientation due to a vestibular…
Back to Bell 407