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 LAX98FA112Accident · 2 fatalField investigationFinal reportGough-Herrman Christen Eagle II · Lake Berryessa, CAwas the pilot-in-command's failure to maintain control of the aircraft. Contributing to the accident was the improper altitude.Mar 14, 1998 · N331GH · DestroyedNTSB FTW98LA146Accident · No injuriesLimited investigationFinal reportCessna 182A · Jacksonville, TXThe partial loss of engine power for undetermined reasons. Factors were the poor braking conditions due to the grassy wet runway.Mar 14, 1998 · N2130G · Substantial damageNTSB ATL98LA055Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Marianna, FLThe failure of maintenance personnel to secure the magneto cover that resulted in water contamination and the subsequent loss of engine power. A factor was rough and uneven terrain.Mar 14, 1998 · N8626H · Substantial damageNTSB ATL98FA056Accident · 1 fatalField investigationFinal reportJohn S. Hickey Swearingen SX 300 · Thomson, GAThe pilot's inadequate preflight planning of the fuel supply required for the flight that resulted in fuel exhaustion and the loss of engine power.Mar 14, 1998 · N83JH · Substantial damageNTSB SEA98LA054Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Bickleton, WAThe pilot's mismanagement of the fuel which led to fuel exhaustion. A related factor was unsuitable terrain.Mar 13, 1998 · N1640S · DestroyedNTSB SEA98LA045Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402A · Moreland, IDThe pilot's failure to maintain aircraft control resulting in an inadvertent stall/spin. A factor was his lack of familiarity in the make/model.Mar 13, 1998 · N50963 · DestroyedNTSB FTW98LA148Accident · No injuriesLimited investigationFinal reportBeech 58 · Taos, NMThe total failure of the landing gear retraction/extension assembly for reasons undetermined.Mar 13, 1998 · N9239Q · Substantial damageNTSB FTW98LA147Accident · No injuriesLimited investigationFinal reportCessna 150L · Conway, ARThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.Mar 13, 1998 · N21915 · Substantial damageNTSB CHI98LA105Accident · Minor injuriesLimited investigationFinal reportAero Commander 680FLP · Fond Du Lac, WIthe pilot's misjudged weather evaluation . Factors were turbulence, the pilot's inability to attain a proper climb rate, unsuitable terrain encountered in the landing area, and crops.Mar 13, 1998 · N777MX · Substantial damageNTSB ATL98TA054Accident · No injuriesFinal reportCessna 172 · Arcadia, FLThe pilot's inadequate pre-flight and in-flight planning, which resulted in fuel exhaustion and the loss of power. Trees and rough/uneven terrain are contributing factors.Mar 13, 1998 · N54634 · Substantial damageNTSB SEA98IA044Incident · No injuriesIncident investigationFinal reportMooney M20K · Klamath Falls, ORThe pilot's inadequate preflight which failed to detect water contaminated fuel that subsequently led to fuel icing at altitude, blockage of fuel lines which resulted in fuel starvation. A related factor was the dark night conditions.Mar 12, 1998 · N3556H · Minor damageNTSB NYC98LA076Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Blue Ash, OHThe failure of a cooling fan blade and the pilot's improper flare.Mar 12, 1998 · N4884 · Substantial damageNTSB NYC98LA075Accident · Serious injuriesLimited investigationFinal reportFokker F-100 · Philadelphia, PAThe driver's failure to maintain clearance from the parked airplane. Related factors were night conditions and the driver's diverted attention.Mar 12, 1998 · N863US · Substantial damageNTSB MIA98FA101Accident · 1 fatalField investigationFinal reportPiper PA-28-180D · Advance, NCThe pilot's improper planned visual approach and glide path in diminished visual conditions due to sun-glare and his delayed go-around resulting in the aircraft colliding with trees on final approach.Mar 12, 1998 · N7826N · Substantial damageNTSB IAD98GA039Accident · No injuriesFinal reportBell 412 · Quantico, VAthe pilot's failure to maintain adequate altitude/clearance above the terrain and the lack of management oversight of aircrews and equipment.Mar 12, 1998 · N82628 · Substantial damageNTSB FTW98LA150Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Ogden, UTthe student pilot not understanding the crew briefing, his premature retraction of the landing gear, and the flight instructor's inadequate supervision of the flight. A factor relating to the accident was: the exchange of unclear information due to the…Mar 12, 1998 · N83DA · Substantial damageNTSB FTW98LA149Accident · No injuriesLimited investigationFinal reportFairchild SA227-AC · Tyler, TXThe failure of the golf cart's driver to shutdown the engine and set the parking brake before exiting, which resulted in an unmanned runaway cart.Mar 12, 1998 · N730C · Substantial damageNTSB CHI98LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · Mc Cordsville, INThe pilot's failure to maintain airspeed and control of the airplane. Factors were his self-induced pressure.Mar 12, 1998 · N55059 · Substantial damageNTSB ANC98LA029Accident · No injuriesLimited investigationFinal reportCessna 185 · Mcgrath, AKThe pilot's failure to maintain directional control after landing. Factors associated with the accident are the presence of snow covered terrain, a tree, and the pilot's selection of an unsuitable landing area.Mar 12, 1998 · N21546 · Substantial damageNTSB SEA98LA043Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Dubois, IDThe student pilot's misjudgment of altitude/clearance and overloading of the nose gear. A contributing factor was the snow-covered turf runway.Mar 11, 1998 · N2438L · Substantial damageNTSB MIA98LA099Accident · Minor injuriesLimited investigationFinal reportPitts S1-S · Zephyrhills, FLthe pilot's improper use of flight controls (ailerons) during a touch-and-go landing with a crosswind, resulting in a loss of directional control and subsequent nose over of the airplane. A factor relating to the accident was: the pilot's lack of total…Mar 11, 1998 · N99PF · Substantial damageNTSB LAX98GA110Accident · 1 fatalFinal reportChristen Industries A-1 · Lebec, CAThe trainee-pilot's failure to maintain altitude during a low level turn. Contributing factors were the pilot-in-command's diverted attention inside the airplane, his failure to report the trainee's deficient airplane handling abilities, and the shoulder…Mar 11, 1998 · N9615G · DestroyedNTSB FTW98LA144Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Jeanerette, LAThe in-flight disconnect of the rotating scissors due to the separation of its hinge bolt.Mar 11, 1998 · N13012 · Substantial damageNTSB ANC98IA026Incident · No injuriesIncident investigationFinal reportBoeing 737-205 · Anchorage, AKThe dynamic imbalance in the yaw rate gyro, which provided input to the yaw damper and rudder. A factor was the deteriorated grease in the gyro bearings.Mar 11, 1998 · N733AR · No damageNTSB MIA98IA100Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Fort Myers, FLThe failure of the No. 1 generator field excitation return wire terminal lug due to improper installation of the field excitation return wire by maintenance personnel; the subsequent failure of the No. 2 generator due to overvoltage, caused by the momentary…Mar 10, 1998 · N275BC · No damageNTSB LAX98LA111Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lone Pine, CAThe failure of maintenance personnel to properly tighten the magneto clamps during installation of the engine on the aircraft following engine overhaul.Mar 10, 1998 · N1659E · Substantial damageNTSB IAD98LA036Accident · Minor injuriesLimited investigationFinal reportCanadair CL600-2B19 · Covington, KYThe driver's operation of a ground vehicle at night with an inoperative windshield wiper and an obscured windscreen against company regulations which resulted in a collision with a parked aircraft.Mar 10, 1998 · N937CA · Substantial damageNTSB DCA98WA028Accident · 6 fatalForeign investigationBoeing 707-336 · Mombosa, KenyaMar 10, 1998 · U-PBA · DestroyedNTSB CHI98LA104Accident · No injuriesLimited investigationFinal reportMooney M20C · White River, SDthe pilot's delay in applying carburetor heat. A factor associated with the accident was the low altitude at which the pilot was flying which limited his landing site selections when the loss of power occurred.Mar 10, 1998 · N6235U · Substantial damageNTSB LAX98LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Santa Rosa, CAThe loss of engine power for undetermined reasons.Mar 9, 1998 · N5704B · Substantial damageNTSB DCA99RA055Accident · 1 fatalForeign investigationRobinson R22B · Amport, United KingdomMar 9, 1998 · GBUTWNTSB FTW98FA145Accident · 1 fatalField investigationFinal reportDuci'S Vans RV-3 · Elbert, COin-flight failure of the right wing spar (for an undetermined reason) as the pilot was performing aerobatic flight. The airplane's excessive gross weight (for aerobatics) was a related factor.Mar 8, 1998 · N99HV · DestroyedNTSB DCA99WA029Incident · No injuriesForeign investigationMcDonnell Douglas DC-10-30 · Manchester, United KingdomMar 8, 1998 · N68065 · Minor damageNTSB DCA98WA032Incident · No injuriesForeign investigationMcdonnell Douglas DC8-73 · Koln-Bonn, GermanyMar 8, 1998 · N812UP · No damageNTSB CHI98LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Edgeley, NDThe pilot's inadequate in-flight planning/decision making which resulted in a delayed go-around and his not maintaining aircraft control. A factor was the crosswind.Mar 8, 1998 · N9882K · Substantial damageNTSB MIA98WA098Accident · No injuriesForeign investigationPiper PA-28-161 · Cat Cay, BahamasMar 7, 1998 · N2728M · DestroyedNTSB LAX98LA108Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Hollister, CAThe failure of the maintenance personnel to recognize and repair the chafed area of the tail rotor driveshaft, which resulted in an in-flight separation of the tail fin and hub assembly.Mar 7, 1998 · N204DR · DestroyedNTSB IAD98LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fogelsville, PAThe pilot's failure to maintain control of the aircraft upon glider release. A contributing factor was the high vegetation (corn).Mar 7, 1998 · N9977B · Substantial damageNTSB MIA98LA096Accident · Serious injuriesLimited investigationFinal reportDouglas DC-10-30F · Memphis, TNground personnel (an equipment loader) failed to follow established written procedures (ramp safety policy), resulting in a pressurized entry door being opened before it was fully depressurized, subsequently injurying the equipment loader. The malfunctioning…Mar 6, 1998 · N303FE · No damageNTSB MIA98LA095Accident · No injuriesLimited investigationFinal reportCessna 172P · Destin, FLthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.Mar 6, 1998 · N53456 · Substantial damageNTSB MIA98LA094Accident · 1 fatalLimited investigationFinal reportNickelson Martin Coot · New Port Richey, FLfailure of the pilot to obtain/maintain adequate airspeed, while maneuvering after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain.Mar 6, 1998 · N84MN · DestroyedNTSB LAX98LA107Accident · No injuriesLimited investigationFinal reportCessna 182 · Pioche, NVThe total loss of engine power due to carburetor icing. An additional factor in this accident was the pilot's decision to make the flight under known icing conditions.Mar 6, 1998 · N6799M · Substantial damageNTSB LAX98FA106Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Novato, CAthe pilot's failure to maintain adequate terrain clearance after initiating a descent over mountainous terrain at night and under marginal VFR conditions. The pilot's self-induced pressure to arrive at class with enough time remaining to take the final…Mar 6, 1998 · N257NW · DestroyedNTSB FTW98LA142Accident · No injuriesLimited investigationFinal reportMooney M20C · Broomfield, COfailure of the pilot to extend the landing gear before landing. A factor relating to the accident was: his attention being diverted, when his daughter got air sick.Mar 6, 1998 · N5653Q · Substantial damageNTSB DCA98WA037Incident · No injuriesForeign investigationLearjet 36A · BahrainMar 6, 1998 · UNK · Minor damageNTSB NYC98LA074Accident · No injuriesLimited investigationFinal reportBeech A36 · Lynchburgh, VAFailure of the number six connecting rod bolt due to improper maintenance.Mar 5, 1998 · N1559X · Substantial damageNTSB MIA98LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Titusville, FLloss of engine power for undetermined reason(s), which resulted in a forced landing. Factors relating to the accident were: the lack of suitable terrain and obstructions in the emergency landing area.Mar 5, 1998 · N8342E · Substantial damageNTSB MIA98FA091Accident · 1 fatalField investigationFinal reportCessna 208B · Clarksville, TNthe pilot did not maintain control of the airplane due to undetected airframe ice, resulting in an inadvertent stall, and subsequent impact with the ground. Factors in this accident were; flight into clouds, below freezing temperatures, and the inability of…Mar 5, 1998 · N840FE · DestroyedNTSB CHI98FA099Accident · 1 fatalField investigationFinal reportCessna T210L · Orleans, INThe pilot's attempted VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance with trees. Contributing factors were the pilot's impairment from prescription drugs, low ceilings, fog, trees, and hilly terrain.Mar 5, 1998 · N2546S · DestroyedNTSB NYC98FA073Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Somerville, NJin-flight separation of the empennage for undetermined reasons. "This case was modified August 2, 2006."Mar 4, 1998 · N3374P · Destroyed