NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 LAX96LA269Accident · No injuriesLimited investigationFinal reportBowles/Irwin Questair Venture · Groveland, CAthe pilot's failure to maintain directional control while landing in a crosswind. A contributing factor was related to the airplane's steering/handling characteristics.NTSB LAX96LA267Accident · No injuriesLimited investigationFinal reportHughes 369D · Honolulu, HIthe failure of both pilots to maintain an adequate clearance from each other while in formation flight.NTSB FTW96LA294Accident · Minor injuriesLimited investigationFinal reportO'Day Sonerai II-LS · Friendswood, TXa loss of engine power for undetermined reasons, and the pilot's failure to attain the proper traffic pattern altitude on the downwind leg prior to turning the base leg.NTSB ATL96LA106Accident · Minor injuriesLimited investigationFinal reportBell 47G · Bartow, FLthe pilot's inadequate visual lookout, and his failure to maintain ground clearance, while maneuvering to avoid a collision with a utility line.NTSB ATL96FA103Accident · 2 fatalField investigationFinal reportGeorge Evenson Cuby · Hawkinsville, GAThe failure of the pilot-in-command to maintain airspeed.NTSB SEA96LA164Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Hillsboro, ORblockage of the vents to both wing fuel tanks, after unknown personnel failed to remove tape (protective covering) from the vents, which resulted in collapsed fuel tanks (and wing damage).NTSB SEA96LA150Accident · No injuriesLimited investigationFinal reportCessna 150 · Puyallup, WAimproper flare by the pilot during a touch-and-go landing.NTSB SEA96LA146Accident · 1 fatalLimited investigationFinal reportGrumman American AA-5B · St Maries, IDthe pilot's impairment of judgment and performance due to a drug (marijuana), and his failure to see-and-avoid power lines. The pilot's intentional low altitude flight was a related factor.NTSB NYC96LA146Accident · No injuriesLimited investigationFinal reportCessna 172H · Cherry Tree, PAthe pilot's failure to assure that adequate takeoff distance was available to clear an obstacle.NTSB NYC96LA145Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Carver, MAthe pilot's inadequate visual look out for obstacles, which resulted in a collision with wires and the ground.NTSB LAX96LA268Accident · No injuriesLimited investigationFinal reportMooney M20C · Payson, AZanimals on the runway. A factor was the dark night.NTSB IAD96FA107Accident · 5 fatalField investigationFinal reportBell 206B · Salem, OHThe pilot's impairment of judgment and performance due to alcohol and the pilot's improper handling of the helicopter resulting in a loss of tail rotor effectiveness. A related factor was the pilot's disregard for the aircraft's weight and balance while…NTSB FTW96LA296Accident · No injuriesLimited investigationFinal reportCessna 180J · Mountain Home, ARThe pilot's failure to maintain directional control during landing. A factor was the cross wind.NTSB CHI96LA231Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Plainwell, MIfailure of the pilot to attaining the proper touchdown point for landing, and his failure to abort the landing (while there was still sufficient runway remaining). The ditch was a related factor.NTSB ATL96FA101Accident · Serious injuriesField investigationFinal reportBoeing 737-200 · Nashville, TNthe captain's improper rejected takeoff, in that the takeoff was rejected after V1, and the flight attendants' improper use of the evacuation procedure, in that an evacuation was independently initiated without the captain's approval, and without assessing…NTSB ANC96LA097Accident · No injuriesLimited investigationFinal reportBell 206B · Juneau, AKThe pilot's failure to maintain proper alignment while lifting the helicopter to a hover and inducing a dynamic roll to avoid striking a passenger.NTSB NYC96LA144Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Pleasant Valley, NYfailure of the pilot to maintain obstacle clearance from trees during a precautionary landing. His becoming lost was a related factor.NTSB LAX96LA266Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Chino, CAFuel starvation due to the pilot's failure to monitor and correctly configure the fuel system for landing prior to entering the traffic pattern, and the pilot's premature lowering of full flaps which led to the runway undershoot. A factor in the accident was…NTSB LAX96LA265Accident · Minor injuriesLimited investigationFinal reportCessna 150L · California City, CAThe pilot's selection of an inadequate cruise altitude in an area of rising terrain and his failure to consider the effect of the high density altitude on the climb capability of the aircraft.NTSB LAX96LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lanai, HIFuel exhaustion due to the pilot's inadequate fuel planning and failure to refuel the aircraft prior to initiating a 280-mile over water nonstop leg of the flight.NTSB IAD96LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cambridge, MDthe pilot's failure to maintain control of the airplane during landing. The crosswind was a factor.NTSB IAD96LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Harrisburg, PAFailure of the right engine due to a fatigue fracture of the crankshaft resultant from heat cracks from an undetermined source.NTSB FTW96LA295Accident · No injuriesLimited investigationFinal reportCessna T210L · Terrell, TXthe mechanic's improper installation of the left main landing gear brake line, which resulted in chaffing and failure of the brake line, loss of hydraulic fluid, and inoperative brake(s).NTSB FTW96LA293Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Garfield, COa reported power loss for reasons undetermined.NTSB ATL96TA102Accident · Serious injuriesFinal reportHughes 269B · Tampa, FLThe failure of maintenance personnel to secure the engine oil screen housing during the 50-hour inspection.NTSB SEA96LA144Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Mcminnville, ORimproper maintenance (replacement) and inspection of the engine fuel governor by company maintenance personnel, the pilot's inadequate preflight inspection, and a subsequent disconnect of the adjustable governor lever control rod, which disabled the engine…NTSB LAX96LA263Accident · No injuriesLimited investigationFinal reportBell 47G3 · Wasco, CAthe pilot's failure to maintain adequate engine rpm during an aerial application flight.NTSB IAD96LA113Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75N1 · Goshen, OHthe pilot's failure to maintain adequate clearance from terrain during short final approach/landing flare. The hot temperature was a related factor.NTSB FTW96LA301Accident · No injuriesLimited investigationFinal reportMyers Smythe Sidewinder · El Dorado, ARthe pilot's failure to attain the correct touchdown point. Factors were: hydroplaning due to the wet runway, and the berm in the overrun area.NTSB DCA96MA068Accident · 2 fatalClass 1 · MajorFinal reportMcDonnell Douglas MD-88 · Pensacola, FLthe fracture of the left engine's front compressor fan hub, which resulted from the failure of Delta Air Lines' fluorescent penetrant inspection process to detect a detectable fatigue crack initiating from an area of altered microstructure that was created…NTSB ANC96LA096Accident · No injuriesLimited investigationFinal reportBeech 18 · Fairbanks, AKThe malfunction of the propeller control unit on the right engine.NTSB SEA96LA147Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW-19 · Salem, UTThe pilot's failure to attain a proper touchdown point during an off-airport landing. Factors relating to the accident were: loss of thermal lift, high obstructions (transmission wires) near the edge of the field that the pilot chose to land, and a bale of…NTSB SEA96LA143Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Sun Valley, IDthe pilot's inadequate compensation for wind conditions and failure to obtain/maintain adequate airspeed for the go-around. The crosswind, downdraft, and high density altitude were related factors.NTSB SEA96LA142Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Newport, ORthe passenger's inadvertent activation of the aircraft's rudder, which resulted in a loss of directional control and collision with a tree during an attempted go-around (aborted landing).NTSB NYC96LA143Accident · No injuriesLimited investigationFinal reportAerospatiale AS-332L · Lakewood, NJa number two system module hydraulic oil leak, which was ignited by an undetermined source and resulted in a hydraulic fluid fire.NTSB NYC96LA142Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenwood Lake, NJfailure of the pilot to maintain adequate airspeed, during the approach/go-around, which resulted in an inadvertent stall and collision with the terrain.NTSB NYC96LA141Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Boston, MAa fracture failure of the crankcase, which resulted in separation of the number five cylinder, loss of engine power, and a ditched landing.NTSB NYC96LA140Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26E · Marston Mills, MAfailure of the pilot to maintain control of the glider while being towed during takeoff, which resulted in a pitch oscillation, failure of the tow cable, loss of airspeed, an inadvertent stall/spin, and an uncontrolled collision with the ground.NTSB LAX96LA262Accident · 2 fatalLimited investigationFinal reportRyan ST3KR · Santa Paula, CAa partial loss of engine power for undetermined reasons and the pilot's failure to maintain control of the airplane while maneuvering toward the runway following the power loss.NTSB FTW96LA303Accident · No injuriesLimited investigationFinal reportRaven Ralley RX7 · Gunnison, COthe pilot's inadequate weather evaluation. A factor was the high wind.NTSB FTW96LA292Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Gunnison, COThe pilot's improper planning/decision. The weather condition (sudden high wind) was a related factor.NTSB CHI96LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Valparaiso, INthe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CHI96LA228Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Kenmare, NDthe pilot's improper refueling procedure, inadequate preflight and the inadvertent stall. A factor related to the accident was the low altitude at which the loss of power occurred.NTSB ATL96LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsborough, NCThe failure of the magneto impulse coupling spring. A factor was the power line at the approach end of the forced landing site.NTSB MIA96LA177Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Canton, MSfailure of the pilot to maintain sufficient altitude and/or clearance from the tower.NTSB MIA96LA176Accident · Minor injuriesLimited investigationFinal reportHiller OH-23C · Marathon, FLImproper repair of a previous crack in the blue main rotor blade by unknown persons; improper inspection of the main rotor blades by maintenance personnel, following a reported vibration problem; and subsequent failure of the main rotor blade, which resulted…NTSB IAD96LA104Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Mitchellville, MDthe pilot's failure to maintain directional control of the aircraft during the landing roll. Related factors were the gusty crosswind conditions.NTSB FTW96LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Corsicana, TXThe pilot's failure to maintain adequate airspeed. A factor was the high wind.NTSB FTW96LA300Accident · No injuriesLimited investigationFinal reportCessna 172P · Owasso, OKInadequate maintenance by maintenance personnel resulting in inoperative brake system during an aborted takeoff. A factor was the downhill runway condition.NTSB CHI96LA229Accident · Minor injuriesLimited investigationFinal reportHewitt Cassutt 3M · Vermillion, SDthe failure of the unapproved fuel pump.