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 CHI91LA285Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Creve Coeur, MOA premature liftoff and improper remedial action by the pilot during a takeoff ground run.Sep 1, 1991 · N11793 · Substantial damageNTSB CHI91LA279Accident · No injuriesLimited investigationFinal reportVarga 2180 · Decatur, ILInadequate preflight planning and preparation and airplane performance data not understood by the pilot. Factors associated with the accident are the pilot's lack of total experience in type of operation, delayed remedial action, and the operator's…Sep 1, 1991 · N686EE · DestroyedNTSB ATL91LA167Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Calhoun, GAThe pilot's failure to maintain directional control during the go-around attempt. Factor(s) in this accident were: the excessive airspeed at touchdown, and the pilot's lack of experience in this model of airplane.Sep 1, 1991 · N43LT · Substantial damageNTSB ATL91LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tullahoma, TNAn engine power loss for undetermined reasons.Sep 1, 1991 · N5568U · DestroyedNTSB SEA91LA228Accident · No injuriesLimited investigationFinal reportCessna 172N · Butte, MTUnfavorable winds. Factors to the accident were: inadequate weather evaluation and lack of total flight experience.Aug 31, 1991 · N2396E · Substantial damageNTSB NYC91LA226Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Nantucket, MAThe pilot's descent below the ILS glide path and his delay in initiating a missed approach which resulted in collision with the terrain.Aug 31, 1991 · N296TH · DestroyedNTSB MIA91LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lake City, FLThe pilot in command's failure to maintain airspeed during a demonstrated downwind soft field takeoff. This resulted in an in flight loss of control, stall, and collision with terrain.Aug 31, 1991 · N737VK · Substantial damageNTSB LAX91LA378Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Mojave, CAThe glider pilot's inadequate altitude to clear terrain. Factors which related to the pilot being low could not be established because the pilot had no memory of the accident, and no witnesses were identified who observed the glider other than during its…Aug 31, 1991 · N901DH · DestroyedNTSB LAX91LA377Accident · 1 fatalLimited investigationFinal reportKaman HH43 B/F · Coleville, CAThe failure of the pilot to adequately calculate the helicopter performance. Contributing to the accident was a delay in jettisoning the external load; the pilot's overconfidence in his abilities; and exceeding of the helicopter's hover ability during high…Aug 31, 1991 · N53RH · DestroyedNTSB DEN91LA128Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe student pilot misjudged his landing flare. A factor was: the pilot's lack of experience.Aug 31, 1991 · N2417E · Substantial damageNTSB CHI91LA286Accident · No injuriesLimited investigationFinal reportCessna 170B · Frankfort, ILThe pilot in command's failure to maintain directional control. A contributing factor was a crosswind.Aug 31, 1991 · N8244A · Substantial damageNTSB CHI91LA283Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Burlington, WIThe pilot's exceeding the airplane's licensed gross weight and the pilot's improper preflight planning and preparation.Aug 31, 1991 · N9514R · Substantial damageNTSB CHI91DEV04Accident · Minor injuriesFinal reportPitts Special S-1 · Lincoln, ILLoss of engine power for undetermined reasons.Aug 31, 1991 · N237V · Substantial damageNTSB CHI91DCD03Accident · 2 fatalFinal reportTullis Tierra II · Ottumwa, IAFailure of the pilot to maintain control of the airplane during maneuvering flight.Aug 31, 1991 · N2162S · DestroyedNTSB BFO91FA078Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Sod, WVThe improper level off which resulted in a hard landing. Contributing was fuel starvation resulting in partial loss of engine power.Aug 31, 1991 · N5435Y · DestroyedNTSB ATL91LA165Accident · Serious injuriesLimited investigationFinal reportIcard, Claude M. Sonerai II LT · Morganton, NCThe pilot's failure to maintain directional control of the airplane on the runway, and the inadvertent rotation of the airplane, resulting in an unplanned flight.Aug 31, 1991 · N9QC · Substantial damageNTSB ATL91LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Stockbridge, GAThe pilot's failure to maintain flying speed after experiencing a partial loss of engine power. Factors in this accident were, loose carburetors, annual inspection not performed, and pilot's lack of recent experience.Aug 31, 1991 · N44PG · Substantial damageNTSB ANC91LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gold King, AKThe pilot's failure to maintain a proper descent rate. Contributing to the accident was the rising terrain and the tailwind condition.Aug 31, 1991 · N2664A · Substantial damageNTSB ANC91LA138Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Cube Cove, AKThe encounter with windshear.Aug 31, 1991 · N2738G · Substantial damageNTSB MIA91WA212Accident · No injuriesForeign investigationCessna 402 · Andros Island, BahamasAug 30, 1991 · N64PB · Substantial damageNTSB MIA91GA211Accident · 1 fatalFinal reportRobinson R-22 Beta · Lake City, FLThe pilot's failure to maintain a visual lookout due to his diverted attention to observe and enter the location of an illegal marijuana patch into the on board loran unit.Aug 30, 1991 · N4022D · DestroyedNTSB CHI91LA281Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Newark, ILThe pilot's poor inflight planning/decision making. A related factor was: the wet, slippery condition of the grass runway.Aug 30, 1991 · N3704T · Substantial damageNTSB CHI91DEV03Accident · 1 fatalFinal reportHocker Dragonfly · Metropolis, ILPilot's failure to maintain airspeed above stall.Aug 30, 1991 · N28P · DestroyedNTSB ANC91LA139Accident · No injuriesLimited investigationFinal reportCessna 206 · Kelly River, AKThe pilot's inadequate judgment in deciding to land a tricycle gear airplane on a sandbar.Aug 30, 1991 · N2070K · Substantial damageNTSB SEA91FA223Accident · 3 fatalField investigationFinal reportAerospatiale 350 B1 · Walton, ORThe pilot's failure to maintain clearance from terrain.Aug 29, 1991 · N64SF · DestroyedNTSB MIA91FA210Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Miami, FLThe failure of the pilot to adequately drain the fuel system of water. A contributing factor was the pilot's decision to continue the takeoff with a known deficiency. The pilot's selection of a forced landing area was poor in that a better landing area was…Aug 29, 1991 · N41431 · DestroyedNTSB MIA91FA208Accident · Serious injuriesField investigationFinal reportPiper PA28-151 · Miami, FLThe failure of the airport agent to exercise caution while driving in reduced visibility due to rain resulting in the collision between the agent's truck and the aircraft she was searching for which had stopped on the taxiway to await assistance. Contributing…Aug 29, 1991 · N41306 · Substantial damageNTSB LAX91IA376Incident · No injuriesIncident investigationFinal reportBoeing 767-232 · Los Angeles, CAThe fracture of the number 1 high pressure turbine wheel due to fatigue, from an undetermined origin.Aug 29, 1991 · N115DA · Minor damageNTSB DEN91LA121Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Parker, COPartial failure of the aircraft powerplant for undetermined reasons. A related factor was: the soft terrain.Aug 29, 1991 · N2628C · Substantial damageNTSB DEN91LA120Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Tyler, TXAn inadvertent stall during initial climb. A factor was: improper rotation speed for takeoff.Aug 29, 1991 · N29341 · Substantial damageNTSB CHI91LA277Accident · No injuriesLimited investigationFinal reportClassic YMF5 · Hart, MIFailure of the pilot to maintain directional control of the airplane during a takeoff ground run.Aug 29, 1991 · N64JE · Substantial damageNTSB BFO91LA077Accident · No injuriesLimited investigationFinal reportCessna 150 · Atlantic Ocean (Atlantic Ocean)The pilot became lost over the Atlantic Ocean and flew until the fuel supply was exhausted.Aug 29, 1991 · N3303V · DestroyedNTSB ANC91LA137Accident · No injuriesLimited investigationFinal reportCessna 185-F · Cordova, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.Aug 29, 1991 · N1296F · Substantial damageNTSB SEA91LA225Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Joseph, ORA deer that ran onto the runway.Aug 28, 1991 · N555TK · Substantial damageNTSB SEA91LA224Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Corbett, ORThe pilot's improper in-flight planning/decision, his delay in taking remedial action, and his failure to maintain clearance from trees on rising terrain. The weather and terrain conditions were related factors.Aug 28, 1991 · N6LG · Substantial damageNTSB NYC91LA217Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Jamestown, RIThe pilot's improper use of carburetor heat, resulting in carburetor ice formation and subsequent loss of engine power and a forced landing in trees.Aug 28, 1991 · N44JS · Substantial damageNTSB MIA91IA207Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-600R · Atlantic Ocean (Atlantic Ocean)The in flight encounter with turbulence, and the failure of the passengers to comply with instructions to return to their seats and utilize their seatbelts.Aug 28, 1991 · N18066 · No damageNTSB MIA91FA209Accident · 2 fatalField investigationFinal reportAeronca 7AC · Dawson, GAThe pilot in command's failure to maintain altitude while maneuvering.Aug 28, 1991 · N84216 · DestroyedNTSB FTW91LA159Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Benton, ARA loss of engine power for unknown reasons.Aug 28, 1991 · N8482J · Substantial damageNTSB DEN91LA119Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Smyer, TXDirectional control not maintained. Factors were: crosswind, soft ground, and high vegetation.Aug 28, 1991 · N928X · Substantial damageNTSB CHI91LA275Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Jenison, MIFailure of the pilot to perform remedial action during fuel system carburetor icing.Aug 28, 1991 · N2389L · Substantial damageNTSB NYC91LA224Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Urbana, OHThe pilot's failure to follow procedures and directives which resulted in the failure of the pilot to recognize the stoppage of the rear engine prior to take off. Additionally the lack of total engine power resulted in the inability of the pilot to maintain…Aug 27, 1991 · N6304F · Substantial damageNTSB MIA91LA206Accident · Serious injuriesLimited investigationFinal reportFriling Amtr · Land O' Lakes, FLThe poor in flight decision of the pilot to fly near thunderstorms and their associated turbulence resulting in an uncontrolled descent and in flight collision with terrain.Aug 27, 1991 · N12JF · DestroyedNTSB LAX91LA374Accident · No injuriesLimited investigationFinal reportPiper PA32R · San Diego, CAThe pilot operating the aircraft with a known engine discrepancy that would cause the engine to lose power due to restriction to the exhaust system.Aug 27, 1991 · N9222K · Substantial damageNTSB CHI91LA274Accident · No injuriesLimited investigationFinal reportCessna 150 · Camden, MIPartial power loss due to improper use of the carburetor heat control by the pilot. Factors related to the accident were inadequate visual lookout by the pilot and presence of static power lines.Aug 27, 1991 · N4400U · Substantial damageNTSB SEA91LA222Accident · No injuriesLimited investigationFinal reportCessna 170B · Heber City, UTThe pilot's failure to maintain directional control during landing ground roll. A factor relating to the accident was the crosswind weather conditions.Aug 26, 1991 · N4653C · Substantial damageNTSB MIA91LA205Accident · Serious injuriesLimited investigationFinal reportMaxair ARV-582 · Jacksonville, FLThe unqualified pilot's failure to maintain airspeed (vso) while maneuvering to land, which resulted in an in flight loss of control, stall spin, and collision with terrain.Aug 26, 1991 · UNREG · Substantial damageNTSB FTW91LA157Accident · No injuriesLimited investigationFinal reportCessna 172K · Fisher, ARThe pilot's failure to use the aircraft performance data to compute the takeoff distance. A factor was the high density altitude.Aug 26, 1991 · N7043G · Substantial damageNTSB FTW91FA155Accident · 1 fatalField investigationFinal reportBell 412 · Garden BanksOverheating and subsequent failure of the number one tail rotor hanger bearing for an undeterined reason, and failure of the tail rotor drive shaft.Aug 26, 1991 · N3909F · Substantial damageNTSB BFO91LA076Accident · No injuriesLimited investigationFinal reportCessna A188B · New Market, MDInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the inoperative fuel quantity gages.Aug 26, 1991 · N8284G · Substantial damage