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 FTW95FA406Accident · 5 fatalField investigationFinal reportMartin B-26C · Odessa, TXthe failure of the pilot to maintain minimum airspeed for flight resulting in an inadvertent stall/spin. Factors were the loss of power for undetermined reasons, and the pilot's lack of recent flight experience in the aircraft.NTSB CHI95LA339Accident · 1 fatalLimited investigationFinal reportMcclintic-Piercie KR-1 · Scotts, MIthe pilot's failure to maintain airspeed.NTSB CHI95LA336Accident · No injuriesLimited investigationFinal reportCessna T210M · Dodge City, KSthe pilot's improper use of the auxiliary fuel boost pump during descent which led to fuel flooding and loss of combustion.NTSB CHI95LA335Accident · Minor injuriesLimited investigationFinal reportBell 206B · Indianapolis, INThe pilot not maintaining adequate terrain clearance during his maneuvering exercise and his abrupt lowering of the collective. A factor associated with the accident was the pilot's lack of experience.NTSB CHI95LA334Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Belleville, ILthe rupture of the oil pressure line which led to oil system exhaustion, the stuck intake valves, and the powerlines.NTSB CHI95FA337Accident · 1 fatalField investigationFinal reportCessna T210R · Iowa City, IAfuel exhaustion as a result of the pilot's inadequate preflight and lack of familiarity with the airplane. Factors involved were the bright night, trees and transmission wires.NTSB BFO95LA099Accident · No injuriesLimited investigationFinal reportDeangelo Kitfox Speedster · Youngstown, OHthe pilot's failure to maintain directional control of the airplane during the takeoff roll. A related factor was the pilot's lack of familiarity with the aircraft while carrying a passenger.NTSB ATL95LA175Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Hoover, ALThe pilot's failure to maintain directional control when he positioned the helicopter in a hover so as to induce a loss of tail rotor effectiveness.NTSB ATL95FA174Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Columbia, SCthe pilot's improper IFR procedure by allowing the airplane to descend below the ILS glideslope and by continued descent below the decision height. Factors relating to the accident were: darkness, low ceiling, and fog.NTSB SEA95LA225Accident · No injuriesLimited investigationFinal reportCessna TR182 · Richfield, IDThe instructor's failure to use carburetor heat during a simulated engine-out descent. Carburetor icing conditions was a factor.NTSB MIA95LA236Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Union Church, MSinadequate maintenance lubrication and inspection of the main rotor head which resulted in the separation of a rod end bearing.NTSB MIA95LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe failure of the pilot to maintain directional control during landing. Contributing to the accident was the crosswind.NTSB MIA95IA238Incident · Minor injuriesIncident investigationFinal reportBoeing 737-400 · Fort Lauderdale, FLInadequate written maintenance procedures addressing steps to be followed in the event of a component failure during an engine wash. The emergency slides failed to deploy due to improper installation by company maintenance personnel.NTSB FTW95LA404Accident · 1 fatalLimited investigationFinal reportFratus XP-23 Hawk · Joshua, TXthe pilot's failure to see and avoid the wires.NTSB CHI95LA331Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Poseyville, INthe pilot's poor judgement in making a night takeoff on an unlit runway and his failure to maintain proper runway alignment. Factors associated with the accident were the hay bale, the night conditions and the unlit runway.NTSB SEA95LA226Accident · No injuriesLimited investigationFinal reportCessna 340 · Riverton, WYa partial loss of hydraulic fluid in the left brake system rendering the left brake inoperative.NTSB MIA95LA237Accident · 1 fatalLimited investigationFinal reportAerotek Pitts - S2S · Clarksville, VAcontinued flight by the pilot into instrument meteorological conditions (IMC), which resulted in spatial disorientation and his inability to control the airplane. The weather condition and the lack of instruments in the airplane were related factors.NTSB FTW95FA402Accident · 5 fatalField investigationFinal reportPiper PA-24B-260 · Westcliffe, COVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors relating to the accident were: the light conditions at dusk, the adverse weather…NTSB FTW95FA401Accident · 1 fatalField investigationFinal reportCessna T210L · Groom, TXLoss of control for unknown reason(s).NTSB CHI95LA333Accident · Minor injuriesLimited investigationFinal reportFairchild FA-24 · Blountsville, INpartial loss of engine power for an undetermined reason, and the pilot's improper in-flight planing/decision. Factors relating to the accident were: the pilot's misuse of flaps, and his encounter with high obstruction during the forced landing.NTSB CHI95LA332Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Ludington, MIfuel exhaustion resulting from the pilot's inaccurate fuel calculations and the failure to refuel the airplane prior to takeoff. An additional cause was the stall/mush during the forced landing.NTSB ATL95LA170Accident · No injuriesLimited investigationFinal reportBeech A35 · Knoxville, TNThe pilot's failure to use the carburetor heat during the approach. The factors were: failure to obtain a weather briefing, and weather conditions favorable for the formation of carburetor icing.NTSB NYC95LA232Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Warwick, NYThe student pilot's misjudgement of distance and speed, and his failure to perform a go-around while there was still sufficient runway remaining.NTSB NYC95LA225Accident · 2 fatalLimited investigationFinal reportSnyded Pitts S1E · Somers, NYThe pilot's inadequate visual lookout, which resulted his failure to see-and-avoid the power line.NTSB NYC95FA224Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Marlborough, MAthe Stearman, N89X, pilot's inadequate visual lookout. A factor was the failure of the flight instructor of the Cessna 150, N1766Q, to announce his position in the traffic pattern in accordance with recommended procedures.NTSB MIA95LA234Accident · No injuriesLimited investigationFinal reportCessna 150 · Sarasota, FLThe failure of the pilot to perform fuel consumption calculations resulting in a loss of power due to fuel exhaustion.NTSB FTW95LA405Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Como, COThe pilot allowing the glider to develop an excessive descent rate. A factor was the premature and automatic disengagement of the winch-tow system.NTSB FTW95LA403Accident · No injuriesLimited investigationFinal reportCessna 195 · Moriarty, NMthe pilot's inadequate compensation for the winds. A factor was the crosswind.NTSB CHI95LA340Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235B · Highland, ILa communication misunderstanding between the tow pilot and the glider pilot. Factors related to the accident were: the tow rope becoming entangled, excessive taxispeed by the tow pilot, and the unavailability of a dispatcher.NTSB BFO95FA097Accident · 1 fatalField investigationFinal reportBeech F33A · Farmingdale, NYfailure of the pilot to maintain pitch control of the airplane during the initial climb after lift-off, which resulted in a steep climb, loss of airspeed, and a resultant stall/spin and subsequent crash. A factor relating to the accident was: failure of the…NTSB ATL95FA173Accident · 2 fatalField investigationFinal reportCessna 310P · Lexington, MSthe non-instrument rated pilot's intentional VFR flight into instrument meteorological conditions and his failure to maintain control of the aircraft. The weather was a factor.NTSB SEA95LA224Accident · 1 fatalLimited investigationFinal reportMacphee Vans RV-6 · Jacksonville, ORthe pilot-in-command's failure to maintain altitude and/or clearance from surrounding terrain after a low pass. The mountainous terrain was a factor.NTSB SEA95LA223Accident · 2 fatalLimited investigationFinal reportEurocopter AS350BA · Crater Lake, ORFailure of the pilot to maintain sufficient altitude/clearance above water, while performing low altitude flight. Factors relating to the accident were: the glassy water condition, and lack of visual cues concerning perception of altitude.NTSB NYC95LA226Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Auburn, NYthe loss of airplane control as a result of a jammed rudder for undetermined reasons.NTSB MIA95LA233Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Dyer, TNThe pilot-in-command's failure to properly manage the fuel required for the flight, resulting in a total loss of engine power due to fuel exhaustion and subsequent in flight collision with trees and terrain.NTSB MIA95LA231Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Augustine, FLFuel starvation for undetermined reasons resulting in the total loss of engine power. Contributing to the accident was unsuitable terrain encountered during the forced landing.NTSB LAX95LA343Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Kona, HIthe failure of the student pilot to properly execute a planned steep approach and long landing so as to avoid wake turbulence behind the preceding large aircraft.NTSB CHI95LA330Accident · No injuriesLimited investigationFinal reportHard Maxair Drifter · Mexico, MOfuel exhaustion as a result of excessive fuel flow, and failure of the pilot not properly monitoring fuel consumption. Rough/uneven terrain in the emergency landing area was a related factor.NTSB ANC95LA176Accident · No injuriesLimited investigationFinal reportCessna 180 · Craig, AKThe pilot's selection of an unsuitable taxi/takeoff area.NTSB ANC95LA175Accident · No injuriesLimited investigationFinal reportCessna 150 · Coldfoot, AKThe pilot's failure to maintain control of the airplane, while landing.NTSB MIA95TA230Accident · Serious injuriesFinal reportBell 206B · Culebra, PRthe failure of company maintenance personnel to insure the tail rotor gearbox attach bolts were properly torqued.NTSB CHI95LA329Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Hudson, WIthe pilot's improper decision to attempt a touch-and-go on a short airstrip.NTSB BFO95LA098Accident · No injuriesLimited investigationFinal reportCessna 182 · Annapolis, MDThe pilot's failure to maintain control of the airplane during the landing roll. Related factors were the sudden thunderstorm, the high gusty winds, and the sudden windshift to a tailwind during the touchdown/landing roll.NTSB ATL95LA172Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lynchburg, SCThe failure of the magneto mount pad, which resulted in a malfunction of the magneto timing and partial loss of engine power. A factor relating to the accident was: high vegetation in the emergency landing area.NTSB ANC95IA173Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Gustavus, AKfatigue failure of the propeller blade due to previous foreign object damage.NTSB SEA95LA222Accident · No injuriesLimited investigationFinal reportCessna 150M · College Place, WAthe pilot-in-command's inaccurate fuel consumption calculations which led to fuel exhaustion.NTSB MIA95LA229Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Lorida, FLMismanagement of the fuel by the pilot resulting in the total loss of engine power due to fuel exhaustion, and the pilot's poor decision to fly over water en route to the refueling airport.NTSB MIA95LA227Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · Vero Beach, FLFailure of company maintenance personnel to comply with a required airworthiness directive, resulting in an in-flight fire and emergency landing. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB MIA95FA226Accident · Serious injuriesField investigationFinal reportMitsubishi MU-2B-35 · Smyrna, TNFailure of the pilot to maintain a proper climb rate after takeoff, and his inadvertent entry in a descending spiral, which he failed to correct. Factors relating to the accident were: darkness, and the pilot becoming spatially disoriented during the initial…NTSB LAX95LA348Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Marana, AZthe pilot misjudged clearance from the power lines.