NTSB investigations
198 cases where NTSB found Management.
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\", '0402')) 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", '0402')) 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 DCA11MA076Accident · 4 fatalClass 1 · MajorFinal reportGulfstream GVI · Roswell, NMThe National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…NTSB OPS11IA401Incident · No injuriesIncident investigationFinal reportArlington, VAThe tower controller's loss of consciousness induced by lack of sleep, fatigue resulting from working successive midnight shifts, and air traffic control scheduling practices.NTSB WPR11LA058Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Salt Lake City, UTThe tug driver’s loss of airplane control during pushback due to a loss of traction in slippery conditions on the ramp. Contributing to the accident was the ground crews’ and airline operators’ inadequate guidance with regard to pushback procedures during low…NTSB WPR11FA052Accident · No injuriesField investigationFinal reportGates Lear Jet 25B · Portland, ORThe failure of the flight crew to stop the airplane on the runway due to the flying pilot’s failure to attain the proper touchdown point. Contributing to the accident was an anti-skid system that was not performing optimally, which allowed the airplane to…NTSB WPR11FA050Accident · 2 fatalField investigationFinal reportDiamond Aircraft Ind DA20-C1 · Payson, UTThe pilots' failure to maintain adequate airspeed during a slow flight maneuver that resulted in a stall and spin, and the flight instructor’s delayed or improper remedial actions to recover from the spin. Contributing to the accident was the flight school’s…NTSB OPS10IA574Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-214 · Minneapolis, MNThe Local North Controller's issuance of a left-turn heading to the Airbus without establishing the position and heading of the Beech. Contributing to the incident was the Local South Controller's distraction with a ground movement operation and lack of…NTSB ERA10IA384Incident · No injuriesIncident investigationFinal reportCessna 402C · San Juan, PRThe airplane manufacturer’s inadequate inspection procedures, resulting in the undetected fatigue cracking of the right upper barrel and trunnion assembly.NTSB ERA10GA320Accident · 3 fatalFinal reportCessna T210L · Lock Haven, PAThe total loss of engine power resulting from the fatigue failure of the engine's number 2 cylinder exhaust valve. The fatigue failure was due to valve guide wear that led to excessive clearance between the valve and valve guide. Contributing to the accident…NTSB ERA10FA283Accident · 1 fatalField investigationFinal reportSchweizer 269C-1 · Boxborough, MAThe FAA inspector's rapid reduction of power which resulted in a loss of engine power and his decision to initiate a turn during the autorotation without sufficient altitude to clear obstacles. Contributing to the accident was the FAA’s lack of comprehensive…NTSB ENG10IA029Incident · No injuriesIncident investigationFinal reportBoeing 757 · Chantilly, VAThe ignition of the J5 power terminal located on the captain’s No. 1 windshield due to a loose electrical connection between the terminal connector lug and its respective terminal block. The loose connection resulted from a missing lock washer that allowed…NTSB ERA10LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Avon Park, FLThe operator's failure to correct known deficiencies with the carburetor, which resulted in a complete loss of engine power and subsequent forced landing by the pilot. Also causal was the operator's decision to rent the airplane in an unairworthy condition.NTSB ERA10LA221Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Millbrook, NYThe pilot's failure to maintain aircraft control after takeoff while he was distracted by trying to hold shut the unlocked cockpit canopy. Contributing to the accident was the pilot's failure to lock the canopy prior to takeoff, and the inadequate guidance in…NTSB OPS10IA020Incident · No injuriesIncident investigationFinal reportBoeing 777-222 · San Francisco, CAThe local controller's issuance of a takeoff clearance to the Boeing 777 without ensuring that approved separation would exist with the Cessna 182. Contributing to the incident were tower procedures that permitted transitioning aircraft to cross the runway 28…NTSB CEN10LA105Accident · No injuriesLimited investigationFinal reportBeech B200 · Sioux City, IAThe flight crew's decision to attempt a flight that was below takeoff, landing, and alternate airport weather minimums, which led to a touchdown off the runway surface by the pilot-in-command.NTSB ERA10LA118Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · New York, NYThe failure of maintenance personnel to properly secure one tail rotor pitch change link to its respective tail rotor blade resulting in an in-flight separation of the link from the blade. Contributing to the accident was the lack of an adequate…NTSB ERA10IA094Incident · No injuriesIncident investigationFinal reportCessna 208B · Rome, NYThe operator's inadequate engine wash intervals, which resulted in compressor turbine blade sulphidation and subsequent turbine blade failure.NTSB DCA10IA006Incident · No injuriesIncident investigationFinal reportBoeing 767 · Dulles International Airport, VAThe failure of the lead and left side marshallers to identify the B40 jetway obstacle and stop the airplane's taxi before the wingtip contacted the jetway. Contributing to the cause of this incident were inadequate marshalling procedures used by the ground…NTSB ERA09CA485Accident · No injuriesData collectionFinal reportBell 206L-3 · White Plains, NYThe pilot's failure to disconnect the ground power unit prior to takeoff.NTSB ERA09CA482Accident · No injuriesData collectionFinal reportBell 206 · Gumboro Township, DEThe pilot’s failure to secure the flight controls before exiting the running helicopter. Contributing to the accident was the operator’s practice of exiting the helicopter while it was still running.NTSB ERA09LA469Accident · 1 fatalLimited investigationFinal reportRaytheon 58 · Teterboro, NJThe complete loss of thrust due to the second-in-command’s (SIC) inadvertent feathering of both propellers during a high-speed, low-altitude approach. Contributing to the accident was the pilot-in-command’s inadequate monitoring of the SIC’s performance.…NTSB CEN09LA525Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caddo Mills, TXThe failure of the operator to ensure that the airplane engine was shutdown during passenger unloading and the lack of adequate supervision of the passenger by the pilot and ground crewmember.NTSB ERA09MA447Accident · 9 fatalClass 1 · MajorFinal reportPiper PA-32R-300 · Hoboken, NJ(1) the inherent limitations of the see-and-avoid concept, which made it difficult for the airplane pilot to see the helicopter until the final seconds before the collision, and (2) the Teterboro Airport local controller’s nonpertinent telephone conversation,…NTSB ERA09LA384Accident · No injuriesLimited investigationFinal reportLancair LC42-550FG · Ocean City, NJAn in-flight collision with birds during landing. Contributing to the accident was the airport's lack of a wildlife mitigation program.NTSB ERA09LA358Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe CFI's inadequate preflight planning and delay to abort the takeoff from the soft takeoff area.NTSB CEN09PA348Accident · 2 fatalClass 1Final reportAgusta A109E · Santa Fe, NMThe pilot's decision to take off from a remote, mountainous landing site in dark (moonless) night, windy, instrument meteorological conditions. Contributing to the accident were an organizational culture that prioritized mission execution over aviation safety…NTSB OPS09IA004Incident · No injuriesIncident investigationFinal reportBE20 · Camp Springs, MDThe failure of the ground controller to coordinate the runway crossings with the local controller and her failure to scan the runway prior to issuing the crossing instructions. Contributing to the incident was the combination of the front line manager/tower…NTSB ERA09LA224Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD88 · Atlanta, GAThe flight attendant’s failure to properly restrain herself after taking her jumpseat.NTSB DCA09MA027Accident · 50 fatalClass 1 · MajorFinal reportBombardier DHC-8-402 · Clarence Center, NYThe captain’s inappropriate response to the activation of the stick shaker, which led to an aerodynamic stall from which the airplane did not recover. Contributing to the accident were (1) the flight crew's failure to monitor airspeed in relation to the…NTSB CEN09MA142Accident · Serious injuriesClass 1 · MajorFinal reportAerospatiale Alenia ATR 42-320 · Lubbock, TXThe flight crew's failure to monitor and maintain a minimum safe airspeed while executing an instrument approach in icing conditions, which resulted in an aerodynamic stall at low altitude. Contributing to the accident were 1) the flight crew's failure to…NTSB DCA09MA026Accident · Serious injuriesClass 1 · MajorFinal reportAirbus A320 · Weehawken, NJThe ingestion of large birds into each engine, which resulted in an almost total loss of thrust in both engines and the subsequent ditching on the Hudson River. Contributing to the fuselage damage and resulting unavailability of the aft slide/rafts were (1)…NTSB WPR09IA065Incident · No injuriesIncident investigationFinal reportBoeing 737-890 · Seattle, WAThe failure of the deicing crew to follow company procedures by not receiving confirmation from the flight crew before beginning to deice the airplane.NTSB DCA09MA021Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 737-524 · Denver, COThe captain’s cessation of right rudder input, which was needed to maintain directional control of the airplane, about 4 seconds before the excursion, when the airplane encountered a strong and gusty crosswind that exceeded the captain’s training and…NTSB MIA08MA203Accident · 4 fatalClass 1 · MajorFinal reportAerospatiale SA365N-1 D · District Heights, MDThe pilot's attempt to regain visual conditions by performing a rapid descent and his failure to arrest the descent at the minimum descent altitude during a nonprecision approach. Contributing to the accident were (1) the pilot’s limited recent instrument…NTSB NYC08LA323Accident · No injuriesLimited investigationFinal reportBeech A200 · Bridgewater, VAThe pilot's decision to land with a tailwind on a short, wet runway, resulting in landing long and runway overrun. Contributing to the accident was the operator’s lack of standard operating procedures for test flights.NTSB CHI08IA292Incident · No injuriesIncident investigationFinal reportBoeing 757-223 · Chicago, ILThe failure of an electrical relay due to eroded contacts and the flight crew's decision to continue a flight that was operating on battery power.NTSB CHI08FA282Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Woodruff, WIThe pilot’s failure to maintain airspeed during a missed approach leading to the inadvertent stall. Contributing to the accident were the pilot’s lack of experience in the type of operation conducted, the certificate holder’s loss of operational control, and…NTSB DEN08LA151Accident · No injuriesLimited investigationFinal reportBeech 1900D · St. Louis, MOThe ground crew's failure to ensure airplane clearance from the building while parking the airplane. Contributing to the accident was the flight crew's unprofessional behavior and the lack of marshaling procedures for the ground crew.NTSB MIA08LA180Accident · No injuriesLimited investigationFinal reportCessna 182A · Elizabethtown, KYA loss of engine power due to fuel exhaustion. Contributing to the accident was pressure from the company for the pilot to fly the second load of skydivers without refueling.NTSB LAX08LA274Accident · 3 fatalLimited investigationFinal reportKillgore Velocity · North Las Vegas, NVA partial loss of engine power during initial climb due to the detachment of the engine supercharger drive belt. The detachment resulted from the owner/builder's inadequate installation of the supercharger system and belt-tensioning adjustment.NTSB LAX08PA259Accident · 9 fatalClass 1Final reportSikorsky S-61N · Weaverville, CAThe following actions by Carson Helicopters: 1) the intentional understatement of the helicopter's empty weight, 2) the alteration of the power available chart to exaggerate the helicopter's lift capability, and 3) the practice of using unapproved…NTSB DCA08MA085Accident · 8 fatalClass 1 · MajorFinal reportRaytheon Corporate Jets BAE 125-800A · Owatonna, MNThe captain’s decision to attempt a go-around late in the landing roll with insufficient runway remaining. Contributing to the accident were (1) the pilots’ poor crew coordination and lack of cockpit discipline; (2) fatigue, which likely impaired both pilots’…NTSB DCA08MA076Accident · No injuriesClass 1 · MajorFinal reportBoeing 767 · San Francisco, CAThe design of the supplemental oxygen system hoses and the lack of positive separation between electrical wiring and electrically conductive oxygen system components. The lack of positive separation allowed a short circuit to breach a combustible oxygen hose,…NTSB ENG08IA022Incident · No injuriesIncident investigationFinal reportBoeing 747 · Newark, NJAn engine fire in the No. 3 engine due to the failure of, and subsequent flammable fluid leak from, one of three fuel or hydraulic lines located in the engine's accessory raceway that ignited when the fluid came in contact with the hot engine cases.…NTSB SEA08IA096Incident · No injuriesIncident investigationFinal reportRaytheon 1900D · Page, AZThe flight crew’s unprofessional behavior and deviation from standard operating procedures which resulted in an in-flight emergency.NTSB DFW08MA076Accident · 5 fatalClass 1 · MajorFinal reportCessna 500 · Oklahoma City, OKAirplane wing-structure damage sustained during impact with one or more large birds (American white pelicans), which resulted in a loss of control of the airplane.NTSB NYC08LA112Accident · No injuriesLimited investigationFinal reportBeech A36 · Athens, GAThe loss of propeller thrust due to the unseating of an internal propeller hub bushing. Contributing to the accident was the manufacturer's inadequate procedure to secure the bushing.NTSB SEA08LA061Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · San Francisco, CAThe company tug operator's failure to maintain clearance with another aircraft during the pushback process. Also causal was the ground controller's failure to alert the pilot of the other aircraft and tug operator of this airplane of the simultaneous pushback…NTSB ANC08MA038Accident · 6 fatalMajor investigationFinal reportPiper PA-31-350 · Kodiak, AKThe failure of company maintenance personnel to ensure that the airplane's nose baggage door latching mechanism was properly configured and maintained, resulting in an inadvertent opening of the nose baggage door in flight. Contributing to the accident were…