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 LAX89LA222Accident · 2 fatalLimited investigationFinal reportAmerican AA-1C · Kalaupapa, HIThe pilot's failure to maintain sufficient airspeed to prevent a stall from which there was insufficient altitude to recover.Jun 19, 1989 · N88ME · DestroyedNTSB LAX89LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · El Cajon, CAThe inadequate maintenance of the airplane & inadequate preflight inspection which resulted in the undetection of contaminated fuel.Jun 19, 1989 · N8836D · Substantial damageNTSB DEN89FA141Accident · 1 fatalField investigationFinal reportBeech A36 · South Lake Taho, CAThe pilot's falure to maintain adequate airspeed after takeoff due to diverted attention toward an open acft door.Jun 19, 1989 · N1778W · DestroyedNTSB CHI89DEM03Accident · 2 fatalFinal reportBeneteau Steen Skybolt · Elk Rapids, MIThe pilot's failure to maintain aircraft control while attempting an aerobatic maneuver. Factors related to the were: inadequate altitude and lack of total experience in type of aircraft.Jun 19, 1989 · N199BP · DestroyedNTSB BFO89LA046Accident · No injuriesLimited investigationFinal reportCessna 210A · Ocean City, MDFailure of the pilot to go around after landing long & recovering from a bounced landing. Contributing factors were: the pilot's excessive airspeed on the apch, his improper flare for the landing, his failure to attain the proper touchdown point, and the…Jun 19, 1989 · N9520X · Substantial damageNTSB ANC89LA101Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Alder Creek, AKSelection of unsuitable terrain (unimproved strip) by the pilot. Soft/uneven terrain & low bushes on the strip, as well as alders beside the strip, were contributing factors.Jun 19, 1989 · N4912Z · Substantial damageNTSB ANC89LA097Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Sheshalik, AKPilot-in-command's failure to perform an adequate preflight inspection of the airplane's brakes.Jun 19, 1989 · N7735K · Substantial damageNTSB ANC89LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Rainbow Lake, AKPilot in command's failure to maintain an airspeed (angle of attack) that would preclude a stall.Jun 19, 1989 · N5087Y · Substantial damageNTSB NYC89LA150Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Niagara Falls, NYEngine failure due to oil starvation and collision with terrain during the forced landing. The oil starvation was caused by the oil leaking out of the drain because maintenance personnel failed to install the drain plug.Jun 18, 1989 · N52HR · Substantial damageNTSB MKC89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Clayton, KSThe failure of the pilot to compensate for the unfavorable wind conditions.Jun 18, 1989 · N8846L · Substantial damageNTSB MIA89FA177Accident · 1 fatalField investigationFinal reportUhley-Mason R.A.F. VARI-EZE · Lantana, FLPilots inadvertent turning off of the engine ignition switches resulting in engine failure.Jun 18, 1989 · N2UM · DestroyedNTSB LAX89LA221Accident · No injuriesLimited investigationFinal reportCessna 172E · Grass Valley, CAFailure to perform maintenance inspections prescribed by the magneto, engine and aircraft manufacturers. The high density altitude and terrain conditions were contributing factors.Jun 18, 1989 · N3618S · Substantial damageNTSB DEN89LA140Accident · No injuriesLimited investigationFinal reportSchweizer 1-26E · Elbert, COThe pilot's improper inflight planning which placed the aircraft too FAR from the runway to complete a normal landing.Jun 18, 1989 · N65910 · Substantial damageNTSB CHI89LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Port Huron, MIImproper in-flight planning/decision by the student pilot and his inadvertent encounter with wake turbulence from the transport aircraft. The student's lack of total experience was considered a contributing factor.Jun 18, 1989 · N8752S · DestroyedNTSB CHI89LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Michigan City, INFailure of the pilot to obtain and/or maintain adequate airspeed during takeoff, which resulted in an inadvertent stall & collision with the ground. Related factors were: failure of the pilot to follow procedures/directives and his operation of the aircraft…Jun 18, 1989 · N8824D · DestroyedNTSB CHI89FA113Accident · 1 fatalField investigationFinal reportCessna 150L · Wisc Rapids, WIThe pilot's failure to assure that the flaps were in the up position during takeoff. A factor related to the accident was the pilot's lack of familiarity with aircraft.Jun 18, 1989 · N6878G · DestroyedNTSB CHI89FA112Accident · Minor injuriesField investigationFinal reportHughes 269C · Lockport, ILImproper flight technique by the PIC during a takeoff from a confined area.Jun 18, 1989 · N26628 · DestroyedNTSB CHI89DEK01Accident · Serious injuriesFinal reportPiper PA-28 · Albany, OHSeizure of the #4 exhaust valve and bending of its respective push rod, which resulted in a significant loss of engine power. Contributing factors were: lack of a suitable emergency landing area, trees, and the fence.Jun 18, 1989 · N40973 · Substantial damageNTSB CHI89DEI01Accident · No injuriesFinal reportCox/Pitts Special S-1S · Alliance, OHFailure of the pilot to maintain proper runway alignment. The soft terrain was a related factor.Jun 18, 1989 · N49JC · Substantial damageNTSB MKC89FA136Accident · 1 fatalField investigationFinal reportNorth American AT-6D · Earle, ARThe pilot's improper planning/decision and over confidence in his flying ability, which resulted in a loss of control, while maneuvering at low altitude. The pilot's inadequate altitude and airpeed were considered to be contributing factors.Jun 17, 1989 · N3931S · DestroyedNTSB LAX89LA220Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Sacramento, CAFuel exhaustion due to the pilot's failure to accurately determine the fuel load prior to departure.Jun 17, 1989 · N92827 · Substantial damageNTSB LAX89LA219Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Banning, CAInadequate preflight planning/preparation by the pilot.Jun 17, 1989 · N29339 · DestroyedNTSB LAX89LA218Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Trinity Center, CAAn interruption of fuel to the engine for undetermined reasons.Jun 17, 1989 · N1215 · Substantial damageNTSB LAX89LA217Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Picacho, AZFailure of the number three exhaust valve on the left engine. A major factor was the high density altitude where the airplane would not operate on single engine.Jun 17, 1989 · N421S · DestroyedNTSB LAX89LA216Accident · No injuriesLimited investigationFinal reportCessna 175K · Bagdad, AZTotal loss of engine power due to undetermined reasons.Jun 17, 1989 · N9729V · DestroyedNTSB LAX89LA215Accident · No injuriesLimited investigationFinal reportCessna 182P · Fallbrook, CAPilot did not follow procedures/directives in as much as he pushed the throttle forward too fast and the engine was not able to respond.Jun 17, 1989 · N6084P · DestroyedNTSB DEN89LA139Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Bullfrog, UTThe pilot failed to compensate for wind conditions during the landing roll. The crosswind was considered as a contributing factor. An underlying factor to the accident was the pilot's lack of experience in performing crosswind landings in the Cessna 180.Jun 17, 1989 · N1846Z · Substantial damageNTSB CHI89LA111Accident · No injuriesLimited investigationFinal reportBoeing E75 · Shelbyville, INThe pilot allowed his attention to be devaited, misjudged altitude and distance to the runway while on final approach, and failed to maintain clearance above the power lines. Contributing factors were: the power lines and parked aircraft.Jun 17, 1989 · N43YP · Substantial damageNTSB CHI89LA110Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Indianapolis, INImproper compensation for wind conditions by the pilot, his failure to maintain runway alignment, and his misjudgement of wingtip clearance above the ground as he was maneuvering to avoid the runway & VASI lights. The crosswind and runway/vasi lights were…Jun 17, 1989 · N12VR · Substantial damageNTSB CHI89FA114Accident · 2 fatalField investigationFinal reportMcculloch J-2 · Oxford, OHThe failure of the pilot operator to replace the main rotor thrust bearing. The expired service life of the main rotor thrust bearing is a factor in the accident.Jun 17, 1989 · N4354G · DestroyedNTSB BFO89LA045Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Moundsville, WVThe pilot failed to maintian directional control and obstacle clearance while hovering at low altitude. A tail rotor blade struck an obstacle causing an overload separation failure of the blade.Jun 17, 1989 · N2487B · DestroyedNTSB ATL89LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNThe pilot's failure to recognize that the engine was not developing full power and the delay in performing remedial action until it was too late to stop the airplane on the runway.Jun 17, 1989 · N714SR · Substantial damageNTSB ATL89FA163Accident · 1 fatalField investigationFinal reportCessna 172F · Vernon, ALImproper maintenance of the spark plugs by the pilot/mechanic which resulted in a partial loss of engine power, and the pilot's failure to clear trees during an emergency landing in an open field resulting in an inadvertent stall.Jun 17, 1989 · N7939U · Substantial damageNTSB MIA89LA175Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Miramar, FLInadequate planning/decision by the pilot, which resulted in loss of engine power due to fuel exhaustion. A contributing factor was the faulty reading from the fuel quantity indicator.Jun 16, 1989 · N732AG · Substantial damageNTSB LAX89LA223Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Herlong, CAFuel starvation, after the pilot diverted his attention to an electrical problem, and his failure to reposition the fuel selector switch, either before the engine lost power or during emergency procedures. Factors related to the accident were: the tripped…Jun 16, 1989 · N4857C · Substantial damageNTSB LAX89LA214Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Diego, CAFuel starvation due to the pilot's inadvertent selection of the off position on the fuel selector.Jun 16, 1989 · N5432P · Substantial damageNTSB FTW89DRD08Accident · Minor injuriesFinal reportSchweizer G-164B · Kaplan, LALoss of engine power due to a cracked cylinder.Jun 16, 1989 · N48592 · DestroyedNTSB DEN89LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Las Cruces, NMFailure of the left main landing gear trunnion. A contributing factor was: inadequate inspection procedure in Piper service bulletin #787A.Jun 16, 1989 · N36345 · Substantial damageNTSB CHI89FA109Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Saint Charles, ILThe failure of the mechanic to properly inspect the alternate air door during annual inspection. This failure led to air starvation, loss of power, and a forced landing by the pilot onto rough terrain.Jun 16, 1989 · N5242T · Substantial damageNTSB ATL89LA170Accident · No injuriesLimited investigationFinal reportCessna R172E · Birmingham, ALImproper flare by the pilot, which resulted in a hard landing. The fact that the pilot was asked twice to expedite the landing created pressure on the pilot and was considered to be a factor.Jun 16, 1989 · N48257 · Substantial damageNTSB ATL89FA161Accident · Serious injuriesField investigationFinal reportLockheed L1011-385-1 · Jacks Creek, TNFailure of the passengers to remain seated with their seat belts fastened as the airplane encountered unforecast severe clear air turbulence.Jun 16, 1989 · N721DA · No damageNTSB ANC89LA093Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Eek, AKFailure of the center torque link bolt on the right main gear.Jun 16, 1989 · N32062 · Substantial damageNTSB ANC89FA094Accident · 4 fatalField investigationFinal reportPiper PA-22 · Kenai, AKInadequate preflight by the pilot and fuel exhaustion.Jun 16, 1989 · N6908D · Substantial damageNTSB MKC89LA134Accident · No injuriesLimited investigationFinal reportGrumman G164 · Brinkley, ARThe failure of the aircraft engine due to water contamination. The pilot executed a landing in a flooded rice field which did not permit a successful landing.Jun 15, 1989 · N8367K · Substantial damageNTSB MKC89FA135Accident · 1 fatalField investigationFinal reportCessna A185F · Ely, MNLoss of engine power for an undetermined reason. A factor related to the accident was: the presence of trees in the emergency landing area.Jun 15, 1989 · N70466 · Substantial damageNTSB MIA89FA176Accident · 1 fatalField investigationFinal reportBoeing A-75 · Daytona Beach, FLThe biplane pilot failed to see and avoid the collision with the banner being towed by the other airplane.Jun 15, 1989 · N57946 · DestroyedNTSB FTW89DRD07Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Morse, LALoss of engine power for an undetermined reason. The soft terrain was a contributing factor.Jun 15, 1989 · N8916H · Substantial damageNTSB DEN89LA163Accident · No injuriesLimited investigationFinal reportCessna A188B · Fort Benton, MTFailure of the tailwheel assembly attaching bolts.Jun 15, 1989 · N4971Q · Substantial damageNTSB ATL89FA160Accident · Minor injuriesField investigationFinal reportGrumman American AA-5 · Columbus, OHThe student pilot's improperly planned approach, and inadequate supervision by the instructor pilot (CFI), which led to an encounter with wake turbulence and a loss of aircraft control.Jun 15, 1989 · N6506L · DestroyedNTSB ANC89FA092Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Puntilla Lake, AKThe pilot continued VFR flight into instrument meteorological conditions (IMC) and failed to maintain sufficient altitude to clear the mountainous terrain. The weather and terrain conditions were contributing factors.Jun 15, 1989 · N160EH · Destroyed