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 SEA92LA069Accident · No injuriesLimited investigationFinal reportCessna 150J · Tumwater, WAThe (student) pilot's improper recovery from a bounced landing. Factors contributing to the accident were excessive airspeed and the pilot's lack of total experience.Apr 8, 1992 · N60850 · DestroyedNTSB SEA92LA065Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Ione, WAAn inadvertent stall as a result of the pilot's failure to raise the flaps during a go-around.Apr 8, 1992 · N5294Q · DestroyedNTSB LAX92LA170Accident · No injuriesLimited investigationFinal reportCessna 182 · Delano, CAA loss of engine power for undetermined reasons. A factor in this accident was the lack of suitable terrain to land the airplane and the soft soil condition which caused the airplane to nose over.Apr 8, 1992 · N5195D · Substantial damageNTSB CHI92LA124Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Garnavillo, IAThe pilot's failure to maintain aircraft control. A factor in the accident was the pilot's lack of experience in aircraft type.Apr 8, 1992 · N92088 · Substantial damageNTSB ATL92LA084Accident · No injuriesLimited investigationFinal reportPZL-Okecie PZL-104 Wilga 80 · Mt. Pleasant, SCThe improper flare during the touchdown phase of the approach by the pilot which exceeded the design limits of the airframe and the right landing gear assembly.Apr 8, 1992 · N3141W · Substantial damageNTSB ANC92LA059Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Mccarthy, AKThe pilot's failure to maintain directional control of the airplane. Contributing to the accident were the snow berm and the pilot's lack of total experience in the type of operation (ski equipped airplanes).Apr 8, 1992 · N97421 · Substantial damageNTSB MIA92LA106Accident · No injuriesLimited investigationFinal reportTomlinson Long EZ · Lakeland, FLThe pilot-in-command's failure to perform pretakeoff procedures and assure the fuel selector was on prior to takeoff. Contributing to the accident was the pilot's complacency.Apr 7, 1992 · N83BT · Substantial damageNTSB FTW92LA108Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Chromo, COEncounter with down draft.Apr 7, 1992 · N3358T · Substantial damageNTSB CHI92DEE01Accident · No injuriesFinal reportBoeing E75 · Leland, ILThe pilot's excessive application of brakes. A factor in the accident was the pilot's lack of experience in this model aircraft.Apr 7, 1992 · N64955 · Substantial damageNTSB FTW92LA122Accident · No injuriesLimited investigationFinal reportCessna A188B · Washita, OKThe failure of the main landing gear during the forced landing due to corrosion and fatigue. A factor was the power loss due to a fractured crankshaft.Apr 6, 1992 · N70321 · Substantial damageNTSB CHI92LA125Accident · No injuriesLimited investigationFinal reportBeech K35 · Valley City, NDFailure by airport personnel to remove the snow ridge.Apr 6, 1992 · N441B · Substantial damageNTSB ATL92LA074Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Elizabeth City, NCInadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the soft terrain at the forced landing site.Apr 6, 1992 · N23380 · Substantial damageNTSB SEA92LA068Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Scappoose, ORThe loss of engine power, cause undetermined. A factor relating to the accident was the lack of suitable terrain for a forced landing.Apr 5, 1992 · N52638 · DestroyedNTSB NYC92LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Moneta, VAThe student pilot's failure to properly compensate for the crosswind condition and to maintain directional control of the airplane after landing. Contributing to the accident was the crosswind.Apr 5, 1992 · N67658 · Substantial damageNTSB NYC92FA073Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Paris, OHThe failure of the pilot to maintain directional control which resulted in the airplane flying over higher terrain with a climb rate that was insufficient to clear the obstacles. Factors related to the accident were the pilot's lack of total experience and…Apr 5, 1992 · N9741W · Substantial damageNTSB NYC92DGT01Accident · Serious injuriesFinal reportSchempp-Hirth Discus BT · Julian, PAThe pilot's inadvertent use of the speed brakes, which resulted in an excessive rate of descent. A factor related to the accident was the pilot's inadequate preflight.Apr 5, 1992 · N224WT · DestroyedNTSB LAX92LA166Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Cucamonga, CAThe pilot's failure to maintain an adequate altitude to avoid colliding into the rising terrain of the box canyon. A factor in the accident was the pilot having been distracted by an engine gage.Apr 5, 1992 · N3319K · DestroyedNTSB LAX92LA165Accident · No injuriesLimited investigationFinal reportRobinson R22B · Palm Springs, CAThe pilot's failure to maintain a proper cruise altitude upon entering a mountain pass area, and his failure to maintain control of the helicopter. Factors which contributed to the pilot's loss of control were related to his encountering turbulence and…Apr 5, 1992 · N40433 · Substantial damageNTSB LAX92FA169Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Cucamonga, CAThe pilot's failure to maintain an adequate altitude to avoid the rising terrain of the box canyon, and, his failure to maintain an adequate airspeed margin above stall while maneuvering in an attempt to reverse course. A factor in the accident was the pilot…Apr 5, 1992 · N302CB · DestroyedNTSB LAX92FA164Accident · Serious injuriesField investigationFinal reportCessna 172N · Claremont, CAThe pilots improper preflight and inflight planning/decisions, his continued VFR flight into IMC conditions, and his failure to initiate timely remedial actions.Apr 5, 1992 · N1333E · Substantial damageNTSB CHI92LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Brookfield, WIFailure of the pilot (CFI) to attain the proper touchdown point for landing. Factors related to the accident were: the unfavorable wind condition, the excessive descent rate that developed on final approach, and the cfi's delay in taking remedial action to…Apr 5, 1992 · N6350A · Substantial damageNTSB NYC92LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Ravenna, OHThe failure of the pilot to maintain directional control during a touch and go which resulted in the airplane departing the runway and striking a ditch. Factors related to the accident were the improper use of the flight controls by the pilot and his lack of…Apr 4, 1992 · N47109 · Substantial damageNTSB MIA92LA105Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Deland, FLThe pilot's inadequate compensation for wind conditions.Apr 4, 1992 · N50072 · Substantial damageNTSB MIA92LA104Accident · No injuriesLimited investigationFinal reportWaco U1-C · St. Petersburg, FLPilot-in-command's failure to maintain control of the airplane on landing. Contributing to the accident were the gusty crosswinds.Apr 4, 1992 · N13562 · Substantial damageNTSB MIA92LA103Accident · 1 fatalLimited investigationFinal reportDouglas AD4-DW · Titusville, FLThe pilot in commands approach at higher than normal airspeed and his landing the aircraft at higher than normal airspeed at a point one half to three quarters down the runway resulting in the aircraft overrunning the runway and nosing over.Apr 4, 1992 · N91945 · Substantial damageNTSB LAX92LA168Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Carlsbad, CAThe pilot's inadequate compensation for wind conditions, his failure to arrest the descent rate in a timely fashion, and the selection of unsuitable terrain on which to practice autorotations.Apr 4, 1992 · N4071J · Substantial damageNTSB LAX92LA167Accident · 1 fatalLimited investigationFinal reportBede BD-5 · Compton, CA1) A total loss of engine power for undetermined reasons, 2) the pilot's failure to maintain an adequate airspeed, and 3) the inadvertent entry into a stall spin. Factors in this accident were: 1) the pilot's lack of familiarity with the airplane, and 2) the…Apr 4, 1992 · N3DW · DestroyedNTSB FTW92LA106Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Weatherford, TXThe pilot's failure to maintain directional control during the landing rollout, and the ensuing inadvertent stall during the aborted landing due to the jammed elevator. A factor was the crosswind.Apr 4, 1992 · N9153L · Substantial damageNTSB FTW92LA105Accident · No injuriesLimited investigationFinal reportCessna 182A · Stanton, TXPower loss for undetermined reasons. A factor was soft terrain.Apr 4, 1992 · N2171G · Substantial damageNTSB FTW92IA104Incident · No injuriesIncident investigationFinal reportBeech 1900C · Lamar, COFailure of the pilot to maintain clearance. A factor was the bright sun.Apr 4, 1992 · N137YV · Minor damageNTSB CHI92LA122Accident · No injuriesLimited investigationFinal reportCessna 150F · Centralia, ILThe pilot's failure to maintain the proper altitude during the final approach to landing. A factor in the accident was the pilot's delayed remedial action.Apr 4, 1992 · N6878F · Substantial damageNTSB CHI92LA121Accident · No injuriesLimited investigationFinal reportCessna 172M · Osage Beach, MOThe pilot-in-command's failure to use all th eavailable runway and his misjudgment of the proper touchdown point during landing.Apr 4, 1992 · N9568V · Substantial damageNTSB ANC92LA058Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Kotzebue, AKPilot factor in that the proper glidepath and altitude was not maintained. Factors to the accident were: inattentiveness and snow.Apr 4, 1992 · N3555C · Substantial damageNTSB LAX92LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Yucca Valley, CAWas the loss of engine power for undetermined reasons. A factor in the accident was the mountainous and rough nature of the terrain.Apr 3, 1992 · N24977 · DestroyedNTSB LAX92LA162Accident · No injuriesLimited investigationFinal reportRobinson R22B · Simi Valley, CAThe instructor pilot's delayed flare from the autorotation landing. A contributing factor was the soft nature of the terrain.Apr 3, 1992 · N504RS · Substantial damageNTSB LAX92FA161Accident · 1 fatalField investigationFinal reportBeech A33 · Paradise, CAThe student pilot's inadvertent use of the mixture control instead of the cowl flaps at a critical phase of flight, his misuse of the flight controls after the engine failure and the instructor's inadequate supervision of the student. Contributing factors in…Apr 3, 1992 · N9367Y · DestroyedNTSB FTW92LA110Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Denver, COThe loss of hydraulic fluid due to a ruptured hydraulic line in the landing gear system.Apr 3, 1992 · N6460Y · Substantial damageNTSB FTW92LA103Accident · No injuriesLimited investigationFinal reportSnow S2C · Roby, TXThe pilot's inadvertent stall of the airplane while maneuvering and subsequent loss of control.Apr 3, 1992 · N1619S · Substantial damageNTSB ATL92LA073Accident · No injuriesLimited investigationFinal reportCessna 210 · Florence, SCThe improper installation of the engine counterweight retention rings which resulted in the separation of the retention pin, allowing the leading edge of the counterweight to strike the crankcase. Factors in the accident were the subseqent loss of power and…Apr 3, 1992 · N7320E · Substantial damageNTSB SEA92LA067Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Miltonfreewater, ORThe inadequate prelight preparation by the pilot in his failure to ensure the filler hose was removed before attempting to takeoff.Apr 2, 1992 · N7920S · Substantial damageNTSB MIA92LA102Accident · Minor injuriesLimited investigationFinal reportBell 47-D-1 · Fayette, MSThe pilot in commands failure to insure the proper fuel quantity for the flight was placed on the aircraft and his failure to monitor fuel quantity during flight resulting in fuel exhaustion.Apr 2, 1992 · N322A · Substantial damageNTSB LAX92FA160Accident · 2 fatalField investigationFinal reportCessna 182P · Arcata, CAThe pilot's descent below decision height, and his alcoholic impairment of efficiency and judgement. Factors contributing to the accident were: the adverse weather conditions and the dark night light conditions.Apr 2, 1992 · N1362M · DestroyedNTSB FTW92LA102Accident · No injuriesLimited investigationFinal reportR. W. Switzer RV-4 · Rogers, ARLoss of engine due to fuel starvation and unsuitable terrain. Factors were the pilot's failure to follow published procedures.Apr 2, 1992 · N94BS · Substantial damageNTSB ANC92LA057Accident · No injuriesLimited investigationFinal reportCessna U206G · Kotzebue, AKThe pilot's failure to remove all the frost from the airplane and exceeding the gross weight limit of the airplane.Apr 2, 1992 · N9909Z · Substantial damageNTSB SEA92LA066Accident · No injuriesLimited investigationFinal reportAvid Mark IV · Soldier Summit, UTThe fuel pump delivering too low fuel pressure. A factor contributing to the accident was the snow covered terrain.Apr 1, 1992 · N582MK · Substantial damageNTSB NYC92LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Coatsville, PAThe failure of the student pilot to compensate for adverse winds during landing, which resulted in a loss of airspeed and subsequent stall and loss of control. A factor related to the accident was the student pilot's lack of total flight experience.Apr 1, 1992 · N49436 · Substantial damageNTSB LAX92LA159Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kaaawa, HIAn engine flame out due to the pilot's intentional flight through an irrigation sprinkler system water stream in order to wash the helicopter.Apr 1, 1992 · N3200N · Substantial damageNTSB LAX92LA158Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Douglas, AZAn encounter with an unforecasted high velocity wind gust which caused the airplane to nose over to an inverted position.Apr 1, 1992 · N28723 · Substantial damageNTSB FTW92LA088Accident · No injuriesLimited investigationFinal reportCessna 172B · Scottsville, TXPilots' inadequate compensation for unfavorable windshift. A facator was the unfavorable wind.Apr 1, 1992 · N7492X · Substantial damageNTSB CHI92FA120Accident · 2 fatalField investigationFinal reportCessna 182 · Port Washington, WIThe continuation of VFR flight into IMC conditions, by a (pilot) unknown, and not maintaining aircraft control by a (pilot) unknown.Apr 1, 1992 · N1230D · Destroyed