NTSB investigations
243 cases where NTSB found Support/oversight/monitoring.
Cases, newest first
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_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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0403')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0403')) 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 ERA19LA253Accident · Serious injuriesClass 3 · LimitedFinal reportVelocity XL-5 · St. Cloud, FLThe pilot’s failure to properly secure the airplane electrical system’s positive/negative leads to the 24v battery, which resulted in a total loss of electrical and engine power in flight.NTSB DCA19CA192Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · SFO International Airport, CAthe ramp controller directing a Boeing 737 to hold in a location that was marked for a regional jet.NTSB WPR19MA177Accident · 11 fatalClass 2 · MajorFinal reportBeech 65-A90 · Mokuleia, HIThe pilot’s aggressive takeoff maneuver, which resulted in an accelerated stall and subsequent loss of control at an altitude that was too low for recovery. Contributing to the accident were (1) the operation of the airplane near its aft center of gravity…NTSB ANC19FA019Accident · 2 fatalClass 2 · FieldFinal reportDe Havilland DHC 2 · Metlakatla, AKThe pilot’s inadequate compensation for a quartering tailwind during a water landing, which resulted in a loss of control and subsequent nose-over. Contributing to the accident was the company’s inadequate operational control of the flight release process,…NTSB CEN19MA141Accident · 6 fatalClass 1 · MajorFinal reportDe Havilland DHC-2 · Ketchikan, AKThe inherent limitations of the see-and-avoid concept, which prevented the two pilots from seeing the other airplane before the collision, and the absence of visual and aural alerts from both airplanes’ traffic display systems, while operating in a geographic…NTSB DCA19MA086Accident · 3 fatalClass 1 · MajorFinal reportBoeing 767 · Trinity Bay, TXThe inappropriate response by the first officer as the pilot flying to an inadvertent activation of the go-around mode, which led to his spatial disorientation and nose-down control inputs that placed the airplane in a steep descent from which the crew did…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 DCA19IA036Incident · No injuriesClass 3 · IncidentFinal reportBoeing 737 · Burbank, CA(1) The flight crewmembers’ decision, due to plan continuation bias, to continue the approach despite indications of windshear and a higher-than-expected tailwind and (2) the flight crew’s misperception of the airplane’s touchdown point, which was farther…NTSB WPR19IA030Incident · Minor injuriesClass 3 · IncidentFinal reportCessna 208 · Bakersfield, CAThe pilot's loss of consciousness while taxiing due to an accumulation of toxic levels of carbon dioxide gas inside the airplane as a result of dry ice sublimation. Also causal was the pilot's decision to fly the airplane in an unventilated configuration, the…NTSB WPR19LA010Accident · Serious injuriesLimited investigationFinal reportPiper PA46 · Hurricane, UTThe mechanic’s failure to properly align the engine exhaust crossover pipe during replacement, and his supervisor’s failure to properly inspect the installation, which resulted in an in-flight fire and the loss of engine power.NTSB GAA18CA571Accident · No injuriesData collectionFinal reportEurocopter AS350 · Ruidoso, NMThe pilot's failure to maintain the proper descent rate during landing. Contributing to the accident were the pilot’s failure to conduct preflight performance calculations, which resulted in his operating the helicopter in high-density altitude conditions,…NTSB ERA18FA264Accident · 2 fatalField investigationFinal reportDassault Falcon 50 · Greenville, SCThe operator's decision to allow a flight in an airplane with known, unresolved maintenance discrepancies, and the flight crew's failure to properly configure the airplane in a way that would have allowed the emergency or parking brake systems to stop the…NTSB DCA18IA269Incident · Minor injuriesIncident investigationFinal reportDJI Phantom · Blacksburg, VAthe drone pilot's incorrect control inputs due to insufficient knowledge of the aircraft flight manual procedures. Contributing to the incident was the close proximity of the observers, and the decision to conduct a demonstration near the observers in a…NTSB ANC18FA053Accident · Serious injuriesField investigationFinal reportDe Havilland DHC 3 · Hydaburg, AKThe pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB CEN18FA259Accident · Serious injuriesField investigationFinal reportEurocopter Deutschland EC135 P1 · Chicago, ILThe pilot's inadvertent disabling of the No. 1 and No. 2 engines' electronic engine control systems, which resulted in engine and rotor overspeed conditions, a subsequent autorotation, and a hard landing. Contributing to the accident were the pilot's…NTSB WPR18FA143Accident · 1 fatalField investigationFinal reportI.C.A.-Brasov IS 29D · Avenal, CAThe pilot's improper installation of the wings onto the glider, which resulted in an in-flight wing separation. Contributing to the accident were the pilot's limited familiarity with the design and a lack of reliable assembly guidance.NTSB ERA18MA099Accident · 5 fatalClass 1 · MajorFinal reportAmerican Eurocopter AS350B2 · New York, NYLiberty Helicopters Inc.'s use of a NYONair-provided passenger harness/tether system, which caught on and activated the floor-mounted engine fuel shutoff lever and resulted in the in-flight loss of engine power and the subsequent ditching. Contributing to…NTSB DCA18IA092Incident · No injuriesIncident investigationFinal reportBoeing 777 222 · Honolulu, HIthe fracture of a fan blade due to P&W's continued classification of the TAI inspection process as a new and emerging technology that permitted them to continue accomplishing the inspection without having to develop a formal, defined initial and recurrent…NTSB ANC18LA018Accident · No injuriesClass 2 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2006 · Lynchburg, VAThe failure of the left main landing gear assembly due to a fatigue fracture along the inside circumferential weld on the trailing arm’s attachment flange, which resulted from the manufacturer’s inadequate welding of the trailing arm connecting the lower arm…NTSB CEN18FA063Accident · 12 fatalField investigationFinal reportCessna 208 · Punta Islita, Costa RicaThe flight crew's failure to maintain airspeed while maneuvering to exit an area of rising terrain, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. Contributing to the accident was the flight crew's…NTSB WPR18FA013Accident · 2 fatalField investigationFinal reportFlugzeugproduktions-und Vertri EA 300/L · Four Corners, CACollision with terrain after the pilot was unable to regain airplane control during an aerobatic maneuver. Contributing to the accident was the operator's failure to provide effective internal oversight to identify and prohibit exceedance of the airplanes'…NTSB DCA18CA001Accident · No injuriesData collectionFinal reportBoeing 737 7H4 · Chicago, ILthe mechanical failure of the tugs fuel governor, which made it difficult for the ramp agent to stop the tug. Contributing to the accident was the lack of guidance on how ground personnel were to handle vehicle malfunctions.NTSB CEN17LA350Accident · No injuriesLimited investigationFinal reportEmbraer EMB 120ER · Greeley, COThe bus driver's failure to maintain clearance from the standing airplane during dark night conditions. Contributing to the accident was the airport's lack of an escort for the bus.NTSB ANC17LA051Accident · No injuriesClass 3 · LimitedFinal reportLeonardo AW139 · Tujunga, CAA yaw excursion and uncontrolled descent due to loss of tail rotor effectiveness during aerial firefighting operations resulting in an impact with trees. A contributing factor was the pilot’s failure to maintain sufficient airspeed, coupled with a quartering…NTSB WPR17LA180Accident · No injuriesLimited investigationFinal reportLockheed P2V 5F · Pocatello, IDMaintenance personnel's failure to secure hardware, which resulted in an uncommanded upward deflection of the left elevator and aft movement of the control yoke and inhibited the flight crew from adjusting the airplane's pitch attitude in flight. Contributing…NTSB ANC17FA039Accident · 1 fatalClass 2 · FieldFinal reportCessna U206 · Port Alsworth, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident was (1) the inadequate preflight…NTSB WPR17FA146Accident · 1 fatalField investigationFinal reportChicco Miguel E Quicksilver Sport II · Point Mugu, CAA partial loss of engine power for reasons that could not be determined during postaccident examination in combination with the low cruise altitude selected by the pilots, which resulted in an ocean ditching. The lack of personal flotation devices likely…NTSB CEN17MA183Accident · 2 fatalClass 1 · MajorFinal reportLearjet 35A · Teterboro, NJThe pilot-in-command's (PIC) attempt to salvage an unstabilized visual approach, which resulted in an aerodynamic stall at low altitude. Contributing to the accident was the PIC's decision to allow an unapproved second-in-command to act as pilot flying, the…NTSB DCA17FA109Accident · 2 fatalField investigationFinal reportShort Bros. & Harland SD3 30 · Charleston, WVthe flight crew's improper decision to conduct a circling approach contrary to the operator's standard operating procedures (SOP) and the captain's excessive descent rate and maneuvering during the approach, which led to inadvertent, uncontrolled contact with…NTSB CEN17LA176Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Gypsum, KSA total loss of engine power during a low-altitude agricultural application flight for reasons that could not be determined during detailed examinations. Contributing to the accident was the pilot’s failure to follow the airplane manufacturer's emergency…NTSB ANC17FA021Accident · 1 fatalField investigationFinal reportCessna 208B · Chignik Lake, AKThe pilot's continued visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in controlled flight into terrain (CFIT). Contributing to the accident was the company's failure to provide the pilot…NTSB CEN17LA156Accident · No injuriesLimited investigationFinal reportLoomis Xenon 4 · Knoxville, IAA partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.NTSB WPR17LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA226 · Boise, IDCompany maintenance personnel's failure to remove a screwdriver that was left lodged in the windshield wiper area of the forward fuselage during maintenance and subsequently became dislodged on takeoff/initial climb and collided with a left propeller blade.NTSB WPR17LA075Accident · Serious injuriesLimited investigationFinal reportHughes 369A · (Pacific Ocean)The pilot's failure to detect the presence of water in the helicopter fuel system before the flight, which resulted in a total loss of engine power during cruise. Contributing to the accident was the pilot's delayed recognition of the power loss and late…NTSB CEN17LA078Accident · Serious injuriesLimited investigationFinal reportTextron 525C · Howell, MIThe pilot's attempted landing on the ice-covered runway, which resulted in a runway excursion and impact with terrain. Contributing to the accident was airport personnel's lack of training regarding issuance of NOTAMsNTSB CEN17LA029Accident · No injuriesLimited investigationFinal reportBeech 100 · Jeffersonville, INThe pilot’s inadequate preflight planning, his decision to take off knowing the airplane was over its gross takeoff weight, and his failure to abort the takeoff after he realized that the airplane was not accelerating as expected, which resulted in a runway…NTSB DCA17FA021Accident · Serious injuriesClass 1 · FieldFinal reportBoeing 767 · Chicago, ILThe failure of the high-pressure turbine (HPT) stage 2 disk, which severed the main engine fuel feed line and breached the right main wing fuel tank, releasing fuel that resulted in a fire on the right side of the airplane during the takeoff roll. The HPT…NTSB DCA17IA020Incident · No injuriesIncident investigationFinal reportBoeing 737 7L9 · New York, NYThe first officer's failure to attain the proper touchdown point and the flight crew's failure to call for a go-around, which resulted in the airplane landing more than halfway down the runway. Contributing to the incident were, the first officer's initiation…NTSB CEN17FA026Accident · 1 fatalField investigationFinal reportRoe Cleo Wittman Tailwind W10 · Pearland, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a climbing turn after takeoff, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's inadequate training…NTSB WPR17IA007Incident · No injuriesIncident investigationFinal reportShort Bros SD3 60 Sherpa · Missoula, MTThe failure of the nose landing gear down-lock piston to engage due to paint accumulation, which resulted in a nose landing gear collapse during landing. Also causal was the failure of the facility that performed the painting to comply with manufacturer…NTSB ANC17MA001Accident · 3 fatalClass 1 · MajorFinal reportCessna 208B · Togiak, AKThe flight crew's decision to continue the visual flight rules flight into deteriorating visibility and their failure to perform an immediate escape maneuver after entry into instrument meteorological conditions, which resulted in controlled flight into…NTSB GAA16CA512Accident · No injuriesData collectionFinal reportAir Tractor AT802 · Wilson, ARThe pilot’s failure to adequately survey the area of operation and his subsequent failure to maintain clearance from power lines during an agricultural application flight.NTSB WPR16FA158Accident · 1 fatalField investigationFinal reportPiper PA 34-200T · Flagstaff, AZA departure flight path that consisted of several unexplained turns during the initial climbout, and terminated in a high-speed descent and ground impact. The reason(s) for the turns and descent could not be determined due to lack of definitive evidence.NTSB DCA16MA204Accident · 16 fatalClass 1 · MajorFinal reportKubicek BB85 · Lockhart, TXThe pilot's pattern of poor decision-making that led to the initial launch, continued flight in fog and above clouds, and descent near or through clouds that decreased the pilot's ability to see and avoid obstacles. Contributing to the accident were (1) the…NTSB ERA16LA209Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M 18A · Brunswick, NCThe failure of the right wing due to a fatigue fracture of the right outboard wing forward spar lower fitting. Contributing to the accident was the routine operation of the airplane over its certificated maximum gross weight and the operator's improper or…NTSB ANC16FA023Accident · 1 fatalField investigationFinal reportAirbus AS350 · Skagway, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in the pilot experiencing a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident were the…NTSB ERA16FA140Accident · 4 fatalField investigationFinal reportEurocopter AS 350 B2 · Enterprise, ALThe pilot's decision to perform visual flight rules flight into night instrument meteorological conditions, which resulted in loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete the…NTSB WPR16FA072Accident · 1 fatalField investigationFinal reportBell 206B · Honolulu, HIThe in-flight failure of the engine-to-transmission drive shaft due to improper maintenance, which resulted in low main rotor rpm and a subsequent hard landing to water.NTSB ERA16FA100Accident · 2 fatalField investigationFinal reportCessna 182 · Mobile, ALThe pilot's loss of airplane control during a missed approach in instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot's inadequate preflight and inflight weather planning which resulted the pilot's…NTSB CEN16MA036Accident · 9 fatalClass 1 · MajorFinal reportBritish Aerospace HS 125 700A · Akron, OHThe flight crew's mismanagement of the approach and multiple deviations from company standard operating procedures, which placed the airplane in an unsafe situation and led to an unstabilized approach, a descent below minimum descent altitude without visual…