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 MIA89LA107Accident · No injuriesLimited investigationFinal reportCessna 402A · Miami, FLThe overload failure of the bellcrank for the left main gear retraction linkage assembly for an unknown reason.Mar 13, 1989 · N2882F · Substantial damageNTSB DEN89LA087Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Broomfield, COPilot's failure to properly control the aircraft while conducting a crosswind takeoff.Mar 13, 1989 · N735VE · Substantial damageNTSB DEN89LA085Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Roy, UTThe pilot allowed himself to become distracted by a landing gear problem, which resulted in fuel exhaustion, when he had insufficient fuel to delay his landing. Factors related to the accident were: the landing gear problem and trees in the emergency landing…Mar 13, 1989 · N26RS · Substantial damageNTSB ATL89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tiffin, OHThe pilots improper recovery from a bounced landing which led to inadvertent porpoising and loss of directional control.Mar 13, 1989 · N2122J · Substantial damageNTSB ATL89LA100Accident · No injuriesLimited investigationFinal reportHughes 269C · Bexley, OHThe inadequate maintenance inspection of the engine following evidence of previous damage which led to the failure of the no. 1 cylinder exhaust valve.Mar 13, 1989 · N300PP · Substantial damageNTSB SEA89LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Seabeck, WAA fatigue failure of the engine crankshaft. Contributing to the accident was the lack of suitable landing area.Mar 12, 1989 · N3576W · Substantial damageNTSB NYC89FA099Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Southbridge, MAPoor judgement of the pilot by flying while physically impaired by alcohol, and his continued VFR flight into instrument meteorological conditions (IMC). Related factors were: the pilot's inadequate preflight planning/preparation, dark night, adverse weather…Mar 12, 1989 · N301WA · DestroyedNTSB MIA89LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe pilot's failure to maintain directional control which resulted in an inadvertent ground swerve. The crosswind and ditch were contributing factors.Mar 12, 1989 · N4948H · Substantial damageNTSB MIA89LA105Accident · No injuriesLimited investigationFinal reportCessna 150 · Arcadia, FLThe pilot's delayed to go around after landing long with excessive speed.Mar 12, 1989 · N66374 · Substantial damageNTSB MIA89LA104Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · St Augustine, FLInadvertently retraction of the landing gear, and failure of the instructor pilot (CFI) to note that the gear had been retracted. A factor related to the accident was: improper flare by the student pilot.Mar 12, 1989 · N8417H · Substantial damageNTSB LAX89LA123Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Watsonville, CAThe pilot's improperly planned approach, and his failure to maintain clearance from the wind sock pole. The proximity of the wind sock (arpt facility) was considered to be a related factor.Mar 12, 1989 · N42005 · Substantial damageNTSB FTW89FA065Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · New Orleans, LAThe pilot diverting his attention from flying the aircraft while complying with the departure control instructions, and allowing the aircraft to descend into the water.Mar 12, 1989 · N8369K · DestroyedNTSB CHI89LA060Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · West Chicago, ILImproper flare by the pilot. The crosswind (quartering headwind) was considered to be a factor.Mar 12, 1989 · N3045M · Substantial damageNTSB BFO89LA021Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gingerville, MDThe pilot's improper planning and decision making en route that resulted in his failure to stop and refuel the airplane and fuel exhaustion.Mar 12, 1989 · N9378T · Substantial damageNTSB SEA89LA055Accident · Minor injuriesLimited investigationFinal reportCessna TU206-G · Reno, NVThe pilot's failure to adequately compensate for crosswinds. Contributing to the accident was the pilot's decision to land the amphibious aircraft in strong crosswind conditions.Mar 11, 1989 · N4957Z · Substantial damageNTSB NYC89IA101Incident · No injuriesIncident investigationFinal reportStinson 108-3 · Blairstown, NJThe pilot's misjudgement of the clearance between the airplanes.Mar 11, 1989 · N6093M · Minor damageNTSB MKC89LA079Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARFailure of the engine blower assembly drive shaft, while maneuvering at low altitude, and failure of the pilot to maintain adequate airspeed, which resulted in a stall before he could land.Mar 11, 1989 · N9874 · Substantial damageNTSB MKC89LA078Accident · No injuriesLimited investigationFinal reportCessna 175 · Murray, NEWater contamination of the fuel and the pilot's inadequate preflight of the aircraft. A factor related to the accident was: the ditch in the emergency landing area.Mar 11, 1989 · N175RP · Substantial damageNTSB MKC89LA077Accident · No injuriesLimited investigationFinal reportJennings Pietenpol Aircamper · Lincoln, NEFailure of the pilot in command to adequately preflight the aircraft resulting in a front cockpit seat cushion interfering with the rudder pedals and brakes.Mar 11, 1989 · N81GJ · Substantial damageNTSB MKC89LA076Accident · No injuriesLimited investigationFinal reportCessna 150 · Monroe City, MOFuel contamination and the pilot's failure to comply with a maintenance AD. Contributing to the accident was the pilot's operation of the airplane with a known deficiency.Mar 11, 1989 · N8079S · Substantial damageNTSB MIA89LA103Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Jacksonville, FLFailure of the pilot to use the carburetor heat, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions and obstructions (power lines & vehicles) in the emergency landing area.Mar 11, 1989 · N182BH · Substantial damageNTSB MIA89LA102Accident · Serious injuriesLimited investigationFinal reportAdams AX-9 · Jacksonville, FLThe failure of a passenger to follow pre-briefed instructions during landing.Mar 11, 1989 · N4033J · No damageNTSB CHI89LA056Accident · No injuriesLimited investigationFinal reportCessna TR182 II · Sandwich, ILThe pilot's poor handling of the aircraft, improper flare and inadequate recovery from a bounced landing.Mar 11, 1989 · N2096S · Substantial damageNTSB CHI89DEC03Accident · Minor injuriesFinal reportPiper PA-28 · Birmingham, MIAn undetermined fuel system blockage. Contributing to the accident was the lack of a suitable forced landing area.Mar 11, 1989 · N4379X · DestroyedNTSB BFO89FA022Accident · 5 fatalField investigationFinal reportBeech A60 · Manassas, VAA loss of aircraft control due to the pilot's failure to maintain minimum engine control speed after a partial loss of power of the left engine for undetermined reasons. The pilot's inexperience in type of aircraft and an over maximum gross weight aircraft…Mar 11, 1989 · N98DS · DestroyedNTSB ATL89LA103Accident · No injuriesLimited investigationFinal reportCessna 172M · Sanford, NCCarburetor ice due to the failure of the pilot to properly use the carburetor heat control during descent and flight in the traffic patterns at reduced power. Underlying this is inadequate training in the proper understanding of carburetor icing and the…Mar 11, 1989 · N13188 · Substantial damageNTSB ATL89LA102Accident · No injuriesLimited investigationFinal reportCessna 172G · Coolidge, GAFuel contamination of an unknown origin, failure of company maintenance personnel to locate and remove all contamination, continued operation of the aircraft by the pilot after the cause of a known engine problem was not determined, and subsequent fuel…Mar 11, 1989 · N1365F · Substantial damageNTSB ATL89LA101Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Steubenville, OHThe rudder control cable failed which rendered the control surface inoperative. The loss of rudder precluded the pilot from maintaining directional control after landing.Mar 11, 1989 · N12208 · Substantial damageNTSB ATL89DEK02Accident · 2 fatalFinal reportAlexander RV-4 · Delaware, OHPilot inadvertently lost control of the aircraft which resulted in a stall spin and collision with the ground.Mar 11, 1989 · N443JA · DestroyedNTSB NYC89LA098Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Bethel, NYImproper planning/decision by the pilot concerning his fuel management, which resulted in fuel exhaustion due to an inadequate supply of fuel. The false indication from the fuel quantity gage(s), dark night, and trees were considered to be factors.Mar 10, 1989 · N2265X · DestroyedNTSB MKC89LA075Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wynne, ARAn engine fire during engine start for undetermined reasons.Mar 10, 1989 · N6602Q · DestroyedNTSB MIA89FA101Accident · 1 fatalField investigationFinal reportNorth American T-28C · Titusville, FLThe pilot's improper execution of an aerobatic maneuver resulting in inadequate airspeed and loss of control.Mar 10, 1989 · N775CH · DestroyedNTSB LAX89LA118Accident · No injuriesLimited investigationFinal reportCessna 310 · Long Beach, CAThe failure of the landing gear strut on the right main gear due to improper maintenance.Mar 10, 1989 · N4899B · Substantial damageNTSB NYC89FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna P210N · Atlantic Ocean (Atlantic Ocean)A power loss for undetermined reasons resulting in a ditching in the north Atlantic Ocean. High seas may have prevented the pilot from getting into his survival suit.Mar 9, 1989 · N734QR · DestroyedNTSB MIA89LA198Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Fort Myers, FLThe pilot's failure to see and avoid obstructions as he taxied from the ramp area. Contributing to the accident was the dark light conditions which degraded the pilot's visual perception.Mar 9, 1989 · N1032U · Substantial damageNTSB MIA89FA100Accident · 2 fatalField investigationFinal reportBeech S35 · Daytona Beach, FLThe pilot's improper IFR procedure and his failure to maintain proper altitude. Contributing factors were: his improper use of the navigation receiver, his delay in making a missed apch, his lack of experience in the type of aircraft, his lack of recent…Mar 9, 1989 · N6852Q · DestroyedNTSB DEN89LA086Accident · No injuriesLimited investigationFinal reportCessna 182 · Tooele, UTInadequate compensation for wind conditions by the pilot which resulted in loss of directional control and inadvertent ground swerve. The quartering crosswind, gusts, and lack of pilot experience were contributing factors.Mar 9, 1989 · N3613U · Substantial damageNTSB DEN89LA084Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Golden, COImproper in-flight planning/decision by the CFI which resulted in loss of tail rotor effectiveness and loss of directional control. Contributing factors were high density altitude, tailwind, and rough/uneven terrain.Mar 9, 1989 · N7411N · Substantial damageNTSB ATL89IA099Incident · No injuriesIncident investigationFinal reportBoeing 737-201 · Dayton, OHAn excessively worn outflow valve in the cabin evironmental/pressurization system that resulted in a rapid cabin depressurization.Mar 9, 1989 · N217US · No damageNTSB ATL89FA098Accident · 1 fatalField investigationFinal reportBeech BE-18 · Covington, KYPilot attempted a takeoff with coating of frost on the airframe which resulted in a loss of lift during climbout.Mar 9, 1989 · N3281T · DestroyedNTSB ANC89LA052Accident · No injuriesLimited investigationFinal reportCessna 185E · Alexander Lake, AKThe pilot's improper in-flight planning, decisions which resulted in exceeding the amount of fuel available which resulted in fuel exhaustion.Mar 9, 1989 · N70122 · Substantial damageNTSB ANC89LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kasigluk, AKThe pilot's inadequate visual lookout which resulted in the collision with a snowbank.Mar 9, 1989 · N4257T · Substantial damageNTSB NYC89LA094Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJImproper decision and planning by the check pilot (f/e) which resulted in loss of proper alignment and collision with a snowbank at the edge of the runway. Contributing factors were: inadequate preflight by the f/e, f/e's unsecured shoulder harness, premature…Mar 8, 1989 · N94252 · Substantial damageNTSB NYC89FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-300 · Missing (Atlantic Ocean)Loss of engine power for an unknown reason.Mar 8, 1989 · N5899F · DestroyedNTSB LAX89DVD03Accident · 2 fatalFinal reportStearns BD-4 · Leggett, CAThe pilot's continuation of VFR flight into instrument meteorological conditions (IMC), and his failure maintain proper altitude. Factors related to the accident were the adverse weather conditions, high terrain, and trees.Mar 8, 1989 · N277MB · DestroyedNTSB DEN89FA083Accident · 4 fatalField investigationFinal reportCraven'S Quickie Q2 · Watkins, COFailure of both pilot's to maintain visual lookout.Mar 8, 1989 · N3278C · 2 aircraft · DestroyedNTSB CHI89IA054Incident · No injuriesIncident investigationFinal reportShort Brothers SD360 · Chicago, ILThe PIC followed a clearance intended for another airplane.Mar 8, 1989 · N366MQ · No damageNTSB MIA89LA099Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Ocala, FLFailure of the vehicle driver to see and yield to the acft that was landing on rwy 27. Contributing factors were: vehicle on the runway and inadequate visual lookout by the pilot.Mar 7, 1989 · N8350V · Substantial damageNTSB DEN89LA082Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Custer, SDThe improper maintenance by the pilot in command/owner in that the magneto drive gear retaining nuts were not safetied which resulted in them backing off, disconnecting the magnetoes and one of the gears falling into the engine.Mar 7, 1989 · N150C · Substantial damageNTSB ANC89LA050Accident · No injuriesLimited investigationFinal reportCessna 185 · Shell Lake, AKThe pilot's improper inflight decision in selecting unsuitable terrain on which to land. Contributing to the accident was the rough/uneven terrain and the snowbank.Mar 7, 1989 · N9824X · Substantial damage