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 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.NTSB DEN89LA087Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Broomfield, COPilot's failure to properly control the aircraft while conducting a crosswind takeoff.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB MIA89LA105Accident · No injuriesLimited investigationFinal reportCessna 150 · Arcadia, FLThe pilot's delayed to go around after landing long with excessive speed.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC89IA101Incident · No injuriesIncident investigationFinal reportStinson 108-3 · Blairstown, NJThe pilot's misjudgement of the clearance between the airplanes.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB MIA89LA102Accident · Serious injuriesLimited investigationFinal reportAdams AX-9 · Jacksonville, FLThe failure of a passenger to follow pre-briefed instructions during landing.NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB MKC89LA075Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wynne, ARAn engine fire during engine start for undetermined reasons.NTSB 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.NTSB LAX89LA118Accident · No injuriesLimited investigationFinal reportCessna 310 · Long Beach, CAThe failure of the landing gear strut on the right main gear due to improper maintenance.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ANC89LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kasigluk, AKThe pilot's inadequate visual lookout which resulted in the collision with a snowbank.NTSB 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…NTSB NYC89FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-300 · Missing (Atlantic Ocean)Loss of engine power for an unknown reason.NTSB 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.NTSB DEN89FA083Accident · 4 fatalField investigationFinal reportCraven'S Quickie Q2 · Watkins, COFailure of both pilot's to maintain visual lookout.NTSB CHI89IA054Incident · No injuriesIncident investigationFinal reportShort Brothers SD360 · Chicago, ILThe PIC followed a clearance intended for another airplane.NTSB 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.NTSB 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.NTSB 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.