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.

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.Sep 28, 1995 · N5546N · DestroyedNTSB CHI95LA339Accident · 1 fatalLimited investigationFinal reportMcclintic-Piercie KR-1 · Scotts, MIthe pilot's failure to maintain airspeed.Sep 28, 1995 · N9975A · DestroyedNTSB 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.Sep 28, 1995 · N7660E · Substantial damageNTSB 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.Sep 28, 1995 · N28SJ · Substantial damageNTSB 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.Sep 28, 1995 · N89331 · Substantial damageNTSB 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.Sep 28, 1995 · N650GM · DestroyedNTSB 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.Sep 28, 1995 · N122DP · Substantial damageNTSB 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.Sep 27, 1995 · N267RW · Substantial damageNTSB 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.Sep 27, 1995 · N2160E · DestroyedNTSB 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.Sep 26, 1995 · N736LT · Substantial damageNTSB 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.Sep 26, 1995 · N92HA · Substantial damageNTSB 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.Sep 26, 1995 · N607FT · Substantial damageNTSB 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.Sep 26, 1995 · N404KW · No damageNTSB FTW95LA404Accident · 1 fatalLimited investigationFinal reportFratus XP-23 Hawk · Joshua, TXthe pilot's failure to see and avoid the wires.Sep 26, 1995 · N3990U · DestroyedNTSB 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.Sep 26, 1995 · N39999 · Substantial damageNTSB SEA95LA226Accident · No injuriesLimited investigationFinal reportCessna 340 · Riverton, WYa partial loss of hydraulic fluid in the left brake system rendering the left brake inoperative.Sep 25, 1995 · N10DF · Substantial damageNTSB 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.Sep 25, 1995 · N260HP · DestroyedNTSB 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…Sep 25, 1995 · N9121P · DestroyedNTSB FTW95FA401Accident · 1 fatalField investigationFinal reportCessna T210L · Groom, TXLoss of control for unknown reason(s).Sep 25, 1995 · N2599S · DestroyedNTSB 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.Sep 25, 1995 · N22036 · DestroyedNTSB 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.Sep 25, 1995 · N6725P · Substantial damageNTSB 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.Sep 25, 1995 · N8500A · Substantial damageNTSB 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.Sep 24, 1995 · N2418R · Substantial damageNTSB 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.Sep 24, 1995 · N27920 · Substantial damageNTSB 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.Sep 24, 1995 · N89X · 2 aircraft · Minor damageNTSB 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.Sep 24, 1995 · N6080T · Substantial damageNTSB 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.Sep 24, 1995 · N38924 · Substantial damageNTSB FTW95LA403Accident · No injuriesLimited investigationFinal reportCessna 195 · Moriarty, NMthe pilot's inadequate compensation for the winds. A factor was the crosswind.Sep 24, 1995 · N4494C · Substantial damageNTSB 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.Sep 24, 1995 · N7753Z · No damageNTSB 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…Sep 24, 1995 · N3176G · DestroyedNTSB 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.Sep 24, 1995 · N5926M · DestroyedNTSB 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.Sep 23, 1995 · N726WM · DestroyedNTSB 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.Sep 23, 1995 · N6099Z · DestroyedNTSB NYC95LA226Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Auburn, NYthe loss of airplane control as a result of a jammed rudder for undetermined reasons.Sep 23, 1995 · N6304N · DestroyedNTSB 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.Sep 23, 1995 · N5095S · Substantial damageNTSB 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.Sep 23, 1995 · N40971 · Substantial damageNTSB 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.Sep 23, 1995 · N10637 · Substantial damageNTSB 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.Sep 23, 1995 · N4255Q · Substantial damageNTSB ANC95LA176Accident · No injuriesLimited investigationFinal reportCessna 180 · Craig, AKThe pilot's selection of an unsuitable taxi/takeoff area.Sep 23, 1995 · N9208C · Substantial damageNTSB ANC95LA175Accident · No injuriesLimited investigationFinal reportCessna 150 · Coldfoot, AKThe pilot's failure to maintain control of the airplane, while landing.Sep 23, 1995 · N4430U · Substantial damageNTSB MIA95TA230Accident · Serious injuriesFinal reportBell 206B · Culebra, PRthe failure of company maintenance personnel to insure the tail rotor gearbox attach bolts were properly torqued.Sep 22, 1995 · N2280N · DestroyedNTSB CHI95LA329Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Hudson, WIthe pilot's improper decision to attempt a touch-and-go on a short airstrip.Sep 22, 1995 · N4666E · Substantial damageNTSB 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.Sep 22, 1995 · N1960X · Substantial damageNTSB 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.Sep 22, 1995 · N9700 · Substantial damageNTSB ANC95IA173Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Gustavus, AKfatigue failure of the propeller blade due to previous foreign object damage.Sep 22, 1995 · N38293 · No damageNTSB SEA95LA222Accident · No injuriesLimited investigationFinal reportCessna 150M · College Place, WAthe pilot-in-command's inaccurate fuel consumption calculations which led to fuel exhaustion.Sep 21, 1995 · N714NW · DestroyedNTSB 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.Sep 21, 1995 · N1529E · Substantial damageNTSB 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.Sep 21, 1995 · N7304C · DestroyedNTSB 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…Sep 21, 1995 · N309MA · DestroyedNTSB LAX95LA348Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Marana, AZthe pilot misjudged clearance from the power lines.Sep 21, 1995 · N8551L · Substantial damage