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 LAX97LA071Accident · 2 fatalLimited investigationFinal reportFarhat RV6A · Julian, CAflight by the pilot into known adverse weather conditions, which resulted in the accumulation of airframe ice and an inability to maintain clearance (proper altitude) from mountainous terrain. Moderate to severe icing conditions in clouds, turbulence, and…NTSB LAX97FA070Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Lucerne Valley, CAthe pilot's failure to maintain an adequate airspeed after encountering turbulence, low level wind shear, and an open door.NTSB IAD97LA037Accident · No injuriesLimited investigationFinal reportRobinson R22 HP · Islip, NYThe students pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight.NTSB FTW97LA069Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Rio Rancho, NMThe pilot's inadvertent flight into high wind.NTSB DCA97MA016Accident · 6 fatalClass 1 · MajorFinal reportDouglas DC-8-63F · Narrows, VAthe inappropriate control inputs applied by the flying pilot during a stall recovery attempt, the failure of the nonflying pilot-in-command to recognize, address, and correct these inappropriate control inputs, and the failure of ABX to establish a formal…NTSB ANC97LA015Accident · Serious injuriesLimited investigationFinal reportBoeing 737-400 · Yakutat, AKan in-flight encounter with unforecast severe clear air turbulence.NTSB SEA97IA040Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Seattle, WAThe failure of the left wing walker to verify the clearance between the left wing and the fuel truck during taxi, and his delay in signaling the lead marshaller to alert the pilot to stop the aircraft prior to impact. Factors contributing to the incident…NTSB NYC97LA035Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Lexington, KYfailure of #5 exhaust valve and/or #5 exhaust valve guide, which resulted in a progressive engine failure (debris puncturing the #5 piston crown, exhaust gasses entering the crankcase, loss of oil through the breather system, oil exhaustion, and subsequent…NTSB NYC97LA034Accident · No injuriesLimited investigationFinal reportMaule M-5 · Levant, MEthe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance from tree(s) during an attempted go-around. The crosswind and proximity of tree(s) were related factors.NTSB NYC97LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Stamford, CTinadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate fuel supply of fuel. Darkness and trees in the emergency landing area were related factors.NTSB LAX97LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise and subsequent overload failure of the nose gear.NTSB IAD97LA034Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Beverly, MAloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and subsequent in-flight collision with terrain.NTSB FTW97LA070Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace BAE 146-200A · Denver, COan inflight encounter with unreported and unanticipated clear air turbulence during landing descent.NTSB FTW97LA068Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Rio Rancho, NMThe passenger's failure to follow recommended procedures to properly brace for a high wind landing. A factor was the windshear.NTSB FTW97FA067Accident · 6 fatalField investigationFinal reportBeech A36 · Chacon, NMThe pilot's failure to maintain altitude and clearance from the high, mountainous terrain. Factors were; high wind, turbulence, and mountain wave conditions.NTSB SEA97LA039Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Friday Harbor, WAfailure of the engine (powerplant) for undetermined reason(s). A factor relating to the accident include: being over water at the time of power failure.NTSB FTW97LA066Accident · No injuriesLimited investigationFinal reportCessna 210N · Kerrville, TXthe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB CHI97LA050Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Red Oak, IAthe pilot's inadequate preflight and failure to make a precautionary landing. Additional factors included oil starvation and the failed connecting rod and rod bearing.NTSB SEA97LA038Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Spokane, WAThe failure of the pilots of both airplanes to see and avoid each other. A factor contributing to the accident was the Cessna's pilot diverted attention.NTSB FTW97LA064Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Muskogee, OKthe pilot's improper planning/decision and inaccurate fuel consumption calculations, which resulted in an inadequate supply of fuel, fuel exhaustion, and a subsequent forced landing at night. Darkness was a related factor.NTSB FTW97LA065Accident · No injuriesLimited investigationFinal reportCessna A188 · La Porte, TXloss of engine power for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB NYC97FA030Accident · 3 fatalField investigationFinal reportCessna 425 · Bohemia, NYthe pilot's early descent to decision height and his failure to perform the missed approach procedure. A factor was the failure of air traffic control to issue a safety advisory.NTSB MIA97FA040Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Birmingham, ALfailure of the pilot to follow emergency procedures and feather the malfunctioning engine, which led to a forced landing and subsequent collision with a chimney (residence) and the terrain. His lack of recent experience in make/model of aircraft was a related…NTSB LAX97FA069Accident · No injuriesField investigationFinal reportde Havilland DHC-8 · Honolulu, HIA failure of the normal landing gear extension system due to a hydraulic leak, and the failure of the airplane's emergency landing gear extension system due to inadequate servicing by company maintenance personnel. Factors were the emergency landing gear…NTSB IAD97LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Charleston, WVimproper planning/decision by the pilot, and his mismanagement of the fuel supply, which resulted in fuel exhaustion, loss of engine power, and a forced landing into wooded terrain.NTSB DCA97WA014Accident · 3 fatalForeign investigationBell 206B · Madrid, SpainNTSB SEA97LA054Accident · No injuriesLimited investigationFinal reportCessna 182M · Vancouver, WAThe pilot-in-command's touchdown with an excessive rate of descent. Factors included gusty crossiwnds.NTSB NYC97LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Baltimore, MDthe student pilot's premature rotation and inadequate supervision by the flight instructor (CFI), which resulted in failure of the flight crew to obtain adequate airspeed during takeoff for a proper rate of climb. Trees at the departure end of the runway were…NTSB MIA97LA039Accident · No injuriesLimited investigationFinal reportWiedemann KIT FOX · Montgomery, ALimproper installation of a throttle cable clamp by an unknown person, resulting in a loose throttle cable housing and an inability to control the throttle position; and failure of the pilot to maintain adequate airspeed during an approach for an emergency…NTSB MIA97LA038Accident · Minor injuriesLimited investigationFinal reportBell 47G · Lantana, FLan undetermined throttle problem, which resulted in a stuck (binding) throttle; and inadequate remedial action by the pilot, which led to a hard landing and subsequent nose over.NTSB LAX97LA068Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Lakeport, CAinadequate supervision by the flight instructor (CFI), and his delayed corrective action to the student pilot's abrupt control inputs, thereby allowing the main rotor blades to strike the ground. Factors relating to the accident were: the CFI's lack of…NTSB CHI97LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Jeffersonville, INthe pilot's misjudgment of the landing flare and inadequate airspeed, which resulted in a hard landing.NTSB SEA97FA037Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Eagle Point, ORThe failure of the first pilot (flight instructor) to initiate proper aircraft control, and his failure to perform the adequate remedial action to recover from an intentional inverted spin.NTSB NYC97LA029Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Charlottesville, VAThe pilot's miscalculation of fuel consumption and his inadequate in-flight decision making, which resulted in fuel exhaustion and the loss of engine power.NTSB FTW97LA063Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Amarillo, TXfailure of the #1 exhaust valve, which resulted in loss of engine power and a forced landing on rough/uneven terrain. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB CHI97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Savoy, ILthe student pilot's failure to maintain directional control. Factors relating to this accident were the student pilot's failure to request another runway and the crosswind.NTSB IAD97FA032Accident · 3 fatalField investigationFinal reportMbb BO-105CBS · Penn Yan, NYthe pilot's failure to maintain altitude/clearance from the terrain. Factors relating to the accident were: the pilot's diverted attention to the GPS, darkness, low ceiling, rising terrain, and high wind condition.NTSB CHI97LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Garnett, KSthe pilot's improper in-flight planning/decision, including a delay in proceeding to an alternate airport after encountering fog during a night approach, which resulted in loss of engine power due to fuel exhaustion.NTSB DCA97WA068Accident · 1 fatalForeign investigationSikorsky S-76B · Omeath Ireland, IrelandNTSB ANC97LA014Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-2 · Ketchikan, AKthe pilot's inadequate compensation for wind conditions, and failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with terrain (water). A factor associated with the accident was the gusty wind condition.NTSB NYC97LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane veering into a snowbank. The proximity of the snowbank was a related factor.NTSB MIA97LA036Accident · 1 fatalLimited investigationFinal reportBeech 18G · Roosevelt Roads, PRThe pilot's improper planning/decision concerning separation of the left engine cowling. Factors relating to the accident were: the pilot's failure to perform weight and balance calculations, and/or to ensure the airplane was loaded in accordance with company…NTSB IAD97LA031Accident · 2 fatalLimited investigationFinal reportMooney M20F · Wellsville, NYDescent below the published minimum descent altitude followed by collision with the surrounding terrain.NTSB FTW97LA062Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Ardmore, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the pilot to execute the forced landing.NTSB FTW97LA060Accident · Minor injuriesLimited investigationFinal reportMooney M-20G · Saginaw, TXThe driver of the vehicle's failure to maintain clearance from the taxiing airplane. A factor was the dark night light condition which resulted in the driver's delayed visual identification of the airplane.NTSB FTW97LA059Accident · No injuriesLimited investigationFinal reportCessna 340 · El Dorado, TXthe pilot's inadequate compensation for wind conditions. The gusty wind was a related factor.NTSB CHI97IA041Incident · No injuriesIncident investigationFinal reportBoeing 757-225 · Terre Haute, INinadequate installation of electrical wiring for an audio entertainment system associated with Supplemental Type Certificate (STC) SA5537NM, and a subsequent short in the wiring. Factors relating to the accident were: inadequate design (installation…NTSB ATL97LA025Accident · No injuriesLimited investigationFinal reportBeech BE-24R · Doraville, GAThe loss of engine power for undetermined reasons.NTSB SEA97LA035Accident · 2 fatalLimited investigationFinal reportBell 47G · Pendleton, ORThe pilot-in-command's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with hilly terrain. A contributing factor in the accident was the presence of fog.NTSB SEA97FA034Accident · 2 fatalField investigationFinal reportDouglas DC-3C · Boise, IDA fire within the right engine compartment of undetermined cause and the pilot-in-command's failure to maintain airspeed above the aircraft's minimum control speed. A factor contributing to the accident was the dark night environmental conditions.