NTSB investigations
145 cases where NTSB found Policy/procedure.
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\", '040210')) 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", '040210')) 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 ERA12LA294Accident · No injuriesLimited investigationFinal reportCessna 172R · Richmond, KYA total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight instructor’s failure to supervise the student’s preflight inspection, his inadequate fuel management and preflight and in-flight fuel planning, and the operator’s…NTSB ENG12IA024Incident · No injuriesIncident investigationFinal reportBeech 1900D · Hays, KSA failure of the nose landing gear end cap due to fatigue. Contributing to the failure were the ineffective inspection and the unknown effect of grain direction on fatigue life.NTSB ENG12IA014Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver International Airport, COA failure of the nose landing gear end cap due to fatigue. Contributing to the failure were the ineffective inspection and the unknown effect of grain direction on fatigue life.NTSB ANC12FA014Accident · Minor injuriesField investigationFinal reportCessna U206G · Nanwalek, AKThe pilot’s decision to takeoff from a contaminated runway with unfavorable wind conditions, and his failure to maintain airspeed during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the operator’s inadequate…NTSB DCA12MA020Accident · 5 fatalClass 1 · MajorFinal reportEurocopter France AS350B2 · Las Vegas, NVSundance Helicopters’ inadequate maintenance of the helicopter, including (1) the improper reuse of a degraded self-locking nut, (2) the improper or lack of installation of a split pin, and (3) inadequate postmaintenance inspections, which resulted in the…NTSB ENG12IA013Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver International Airport, COA failure of the nose landing gear end cap due to fatigue. Contributing to the failure were the ineffective inspection and the unknown effect of grain direction on fatigue life.NTSB ANC11LA061Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Anchorage, AKThe pilot’s decision to depart with minimal fuel and his improper fuel management and engine restart procedures, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the Pilot Operating Handbook did not provide the…NTSB CEN11LA368Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Ann Arbor, MIThe flight instructor’s failure to maintain clearance from the propeller when exiting the airplane. Contributing to the accident were the instructor’s decision not to shut down the engine before exiting the airplane and the operator’s lack of a policy…NTSB ANC11TA031Accident · Minor injuriesFinal reportBeech B200 · Atqasuk, AKThe pilot did not maintain sufficient airspeed during an instrument approach in icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident were the pilot’s fatigue, the operator’s decision to initiate the flight…NTSB CEN11IA270Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135KL · Dubuque, IAThe airport authorities' improper decision to deactivate the jet bridge braking system which created an unsafe condition by the gate agents not being able to stop the bridge from impacting the airplane during a wind gust.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 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 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 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 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 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 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 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 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 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 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…