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 CHI90LA205Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Hudson, IAImproper touchdown performed by the pilot in command.Jul 30, 1990 · N8140J · Substantial damageNTSB CHI90LA203Accident · Minor injuriesLimited investigationFinal reportForbing Longeze · Yutan, NEFuel exhaustion due to an inadequate supply of fuel and the pilot's lack of familiarity with this home-built aircraft. Factors related to the accident were: darkness and obstructions (vehicle & road sign) in the emergency landing area.Jul 30, 1990 · N252BJ · Substantial damageNTSB CHI90LA201Accident · No injuriesLimited investigationFinal reportBryant Rowland T-18 · Fisk, WIThe pilot-in-command of the thorp T-18'S failure to maintain a sufficient visual lookout to avoid a collision with the Cessna 170A. Contributing was the limited visibility forward and to the right in the thorp T-18.Jul 30, 1990 · N66BR · 2 aircraft · Substantial damageNTSB SEA90LA150Accident · No injuriesLimited investigationFinal reportGlasflugel H 301 Libelle · Thompson Falls, MTA disabled aircraft blocking the active runway.Jul 29, 1990 · N4166A · Substantial damageNTSB NYC90LA177Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Shirley, NYImproper use of the flight controls by the student pilot.Jul 29, 1990 · N9030Z · Substantial damageNTSB NYC90IA178Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-7-102 · New York, NYThe flight crew's failure to folllow the landing gear emergency checklist. Factors which contributed to the incident were: a jammed nose landing gear due to the installation of a bogus part by unknown person(s) and a dirty gear viewing window.Jul 29, 1990 · N175RA · Minor damageNTSB NYC90FA179Accident · 2 fatalField investigationFinal reportGrumman AA-1B · Springfield, NJThe pilot's failure to maintain airspeed and the inadvertent stall of the airplane at an altitude from which recovery was not possible.Jul 29, 1990 · N1429R · DestroyedNTSB NYC90FA176Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · North Andover, MAThe controller issued an unauthorized alternate missed approach procedure that did not provide adequate terrain clearance, and the pilot delayed obtaining a proper rate of climb during the missed approach. Factors related to the accident were: darkness and…Jul 29, 1990 · N333EP · DestroyedNTSB CHI90LA210Accident · No injuriesLimited investigationFinal reportPiper J-3 CUB · Clay Banks, WIPilot's failure to maintain an adequate visual lookout during the descent. Contributing factors are the pilot's poor weather evaluation, and continued VFR flight into IFR conditions.Jul 29, 1990 · N1455N · Substantial damageNTSB CHI90LA204Accident · No injuriesLimited investigationFinal reportWhittman W-8 · Toledo, IAWrong runway selected and aborted takeoff delayed by the pilot in command.Jul 29, 1990 · N6803D · Substantial damageNTSB ATL90LA152Accident · No injuriesLimited investigationFinal reportCessna 177 · Windsor, NCThe pilot's failure to maintain control of the airplane during the flare phase of the approach. Contributing to the accident was the gusty wind condition on final caused by thunderstorm activity in the vicinity of the landing area. The pilot did not…Jul 29, 1990 · N3184T · Substantial damageNTSB ATL90LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Midway, TNTotal failure of the number four exhaust valve, resulting in engine power loss and the subsequent forced landing of the airplane.Jul 29, 1990 · N8091X · Substantial damageNTSB ANC90LA127Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kustatan River, AKThe pilot selected unsuitable terrain for landing. The terrain was a contributing factor.Jul 29, 1990 · N98994 · Substantial damageNTSB ANC90LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Gulkana, AKThe pilot-in-command's failure to maintain flying speed during the go-around.Jul 29, 1990 · N2362A · Substantial damageNTSB SEA90LA148Accident · No injuriesLimited investigationFinal reportBell BH-214 · Thompson Falls, MTCrew's encounter with soft terrain while attempting an autorotation landing after the failure of the main rotor drive system.Jul 28, 1990 · N314RM · Substantial damageNTSB NYC90LA175Accident · No injuriesLimited investigationFinal reportCessna 172 · Edinburg, NYThe pilot did not maintain flying speed, the airplane stalled and descended into trees, at the departure end of the runway.Jul 28, 1990 · N6251D · Substantial damageNTSB MIA90LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Delray Beach, FLThe loss of directional control during the initial climb following the reported loss of power from the left engine for undetermined reasons.Jul 28, 1990 · N3R · Substantial damageNTSB FTW90LA148Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Carlisle, ARPilot's initiation of the abort with excess airspeed. A contributing factor was the engine tachometer overspeed.Jul 28, 1990 · N4609P · Substantial damageNTSB FTW90DPG06Accident · No injuriesFinal reportWSK PZL Mielec M18A · Hunter, ARLoss of part of the engine exhaust collector, as result of improper maintenance replacement/installation.Jul 28, 1990 · N81699 · DestroyedNTSB DEN90LA168Accident · Serious injuriesLimited investigationFinal reportGulfstream G-II · Cheyenne, WYAn unforeseen encounter with clear air turbulence.Jul 28, 1990 · N405MM · No damageNTSB ATL90FA150Accident · 1 fatalField investigationFinal reportPiper PA-18A · Conway, SCTowline interference with the rudder, and failure of the pilot to maintain adequate airspeed, which resulted in a stall/spinn. A factor that contributed to the accident was: failure of the company/operator management to adequately guard against such…Jul 28, 1990 · N2789P · DestroyedNTSB ANC90LA125Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · King Salmon, AKThe pilot-in-command's failure to maintain flying speed during climbout.Jul 28, 1990 · N1507L · Substantial damageNTSB ANC90LA124Accident · No injuriesLimited investigationFinal reportCessna 206G · Holy Cross, AKLoss of engine power for undetermined reasons.Jul 28, 1990 · N7235N · Substantial damageNTSB SEA90LA147Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Rawlins, WYPilot's improper planning/decision, and his misjudgement of the aircraft's climb capability in conditions of high density altitude and unanticipated atmospheric conditions. The high density altitude and rising terrain were related factors.Jul 27, 1990 · N14004 · Substantial damageNTSB NYC90DHA02Accident · 2 fatalFinal reportSnyder MA-5 Charger · Hamburg, PAFailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall/spin. The pilot's abrupt maneuver was a related factor.Jul 27, 1990 · N96CS · Substantial damageNTSB LAX90LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZThe failure of the pilot to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's improper use of the airplane brakes.Jul 27, 1990 · N94494 · Substantial damageNTSB DEN90FA166Accident · No injuriesField investigationFinal reportCessna 208A · Ruidoso, NMEngine failure due to failure of the gas producer and power turbine assemblies. A factor in the accident was the lack of suitable terrain for the forced landing.Jul 27, 1990 · N105YV · Substantial damageNTSB DCA90WA049Accident · Serious injuriesForeign investigationMcdonnell Douglas DC-10-30 · Bharu, MalaysiaJul 27, 1990 · N108WA · No damageNTSB CHI90LA206Accident · No injuriesLimited investigationFinal reportBeech D17S · Oelwein, IAInadequate visual outlook by the pilot in command.Jul 27, 1990 · N480 · Substantial damageNTSB CHI90LA202Accident · No injuriesLimited investigationFinal reportCessna C-152 · Troy, MIThe solo student's failure to maintain lineup with runway centerline during landing flare and touchdown. Factors in the accident were the pilot's lack of total experience and the crosswind conditions.Jul 27, 1990 · N48597 · Substantial damageNTSB CHI90DET04Accident · Serious injuriesFinal reportContinental Copters MK 5A Tomcat · Constantine, MIThe pilot's failure to see and avoid power lines in his area of operation.Jul 27, 1990 · N1442Z · Substantial damageNTSB CHI90DCD01Accident · No injuriesFinal reportFinn A. Arnold Glassaire/SH-2 · Shenandoah, IAThe failure of the pilot to maintain directional control of the airplane during the takeoff ground run. A factor in the accident is the pilot's lack of total experience in the type of aircraft involved in the accident.Jul 27, 1990 · N41FJ · Substantial damageNTSB BFO90LA065Accident · No injuriesLimited investigationFinal reportRobinson R22 · Paducah, KYThe loss of tail rotor thrust due to improper part installation.Jul 27, 1990 · N9017S · Substantial damageNTSB ATL90LA149Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Concord, NCThe pilot's inadequate preflight planning and preparation, in that he did not fully consider the effects of high obstructions and a poor runway surface condition.Jul 27, 1990 · N5278P · Substantial damageNTSB ATL90DKJ07Accident · Serious injuriesFinal reportBell-Continental Copters 47G · Clayhatchee, ALFailure of the engine magneto(s). The lack of suitable terrain (trees) in the emergency landing area was a related factor.Jul 27, 1990 · N7153 · Substantial damageNTSB NYC90LA174Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Hilltown, PAThe pilot receiving training misjudged the airplane's distance from the runway and altitude above the trees. In addition, the CFI failed to provide adequate supervision.Jul 26, 1990 · N1ZT · Substantial damageNTSB NYC90LA172Accident · Serious injuriesLimited investigationFinal reportCessna C-152A · Yellowsprings, OHLoss of control when the pilot stalled the airplane after prematurely becoming airborne. Contributing to the accident was a rough field and a hidden obstruction.Jul 26, 1990 · N4870A · Substantial damageNTSB MIA90LA161Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Ellenton, FLThe improper takeoff procedure by the pilot.Jul 26, 1990 · N7546N · Substantial damageNTSB LAX90DVA07Accident · 1 fatalFinal reportAir Tractor AT-401 · San Joaquin, CAThe failure of the no. 4 cylinder head.Jul 26, 1990 · N7315S · Substantial damageNTSB FTW90GA146Accident · 1 fatalFinal reportRobinson R22B · Tahlequah, OKThe pilot's failure to maintain adequate altitude.Jul 26, 1990 · N20K · DestroyedNTSB FTW90DPG05Accident · No injuriesFinal reportWSK PZL Mielec M18A · Hunter, ARThe pilot's continued operation with a known malfunctioning engine.Jul 26, 1990 · N8154V · DestroyedNTSB CHI90LA200Accident · No injuriesLimited investigationFinal reportBeech A36TC · Oshkosh, WIThe pilot's failure to recognize the deteriorating airspeed and imminent stall during the landing flare, which resulted in a hard landing.Jul 26, 1990 · N3738U · Substantial damageNTSB CHI90LA199Accident · No injuriesLimited investigationFinal reportFouga FOUGA-MAGISTER · Oshkosh, WIThe pilot-in-command's failure to maintain proper airspeed in turn from base to final.Jul 26, 1990 · N302FM · Substantial damageNTSB CHI90LA198Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Ozark, MOTotal loss of engine power due to #2 turbine shaft bearing failure. A factor related to the accident was: none suitable terrain.Jul 26, 1990 · N442FH · Substantial damageNTSB CHI90FA197Accident · 2 fatalField investigationFinal reportCustom Aerotech White Lightning · Oshkosh, WIThe pilot-in-command's failure to maintain airspeed to avoid loss of control of the aircraft.Jul 26, 1990 · N7147W · DestroyedNTSB SEA90FA146Accident · 3 fatalField investigationFinal reportWheeler Technology FT-210 · Linch, WYFailure of the pilot to maintain control of the aircraft and/or correct the stall/spin.Jul 25, 1990 · N210EX · DestroyedNTSB NYC90LA173Accident · No injuriesLimited investigationFinal reportCessna 182G · Cincinnati, OHThe pilot did not properly compensate for the gusty wind conditions, resulting in the airplane landing hard and porpoising.Jul 25, 1990 · N183D · Substantial damageNTSB NYC90FA171Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Gt. Barrington, MAThe pilot in command's failure to properly maintain the engine, the inadequate annual maintenance inspection, low compression, and improper magneto timing. A factor was the resultant deteriorated climb performance.Jul 25, 1990 · N8011M · DestroyedNTSB MIA90LA160Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Plymouth, FLThe pilots decision to depart for his destination airport in the path of approaching thunderstorms resulting in the encounter with wind gusts during landing which exceeded his limitations.Jul 25, 1990 · N32446 · Substantial damageNTSB MIA90IA159Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-100 · Panama City, FLFailure of seal in the hydraulic actuator for the right outboard wing spoiler panel for unknown reasons.Jul 25, 1990 · N800MX · No damage