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 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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).NTSB 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.NTSB FTW92LA108Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Chromo, COEncounter with down draft.NTSB 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.NTSB 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.NTSB CHI92LA125Accident · No injuriesLimited investigationFinal reportBeech K35 · Valley City, NDFailure by airport personnel to remove the snow ridge.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB MIA92LA105Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Deland, FLThe pilot's inadequate compensation for wind conditions.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB FTW92LA105Accident · No injuriesLimited investigationFinal reportCessna 182A · Stanton, TXPower loss for undetermined reasons. A factor was soft terrain.NTSB FTW92IA104Incident · No injuriesIncident investigationFinal reportBeech 1900C · Lamar, COFailure of the pilot to maintain clearance. A factor was the bright sun.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB FTW92LA103Accident · No injuriesLimited investigationFinal reportSnow S2C · Roby, TXThe pilot's inadvertent stall of the airplane while maneuvering and subsequent loss of control.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB FTW92LA088Accident · No injuriesLimited investigationFinal reportCessna 172B · Scottsville, TXPilots' inadequate compensation for unfavorable windshift. A facator was the unfavorable wind.NTSB 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.