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 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB FTW98LA148Accident · No injuriesLimited investigationFinal reportBeech 58 · Taos, NMThe total failure of the landing gear retraction/extension assembly for reasons undetermined.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC98LA076Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Blue Ash, OHThe failure of a cooling fan blade and the pilot's improper flare.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB FTW98LA144Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Jeanerette, LAThe in-flight disconnect of the rotating scissors due to the separation of its hinge bolt.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB DCA98WA028Accident · 6 fatalForeign investigationBoeing 707-336 · Mombosa, KenyaNTSB 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.NTSB LAX98LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Santa Rosa, CAThe loss of engine power for undetermined reasons.NTSB DCA99RA055Accident · 1 fatalForeign investigationRobinson R22B · Amport, United KingdomNTSB 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.NTSB DCA99WA029Incident · No injuriesForeign investigationMcDonnell Douglas DC-10-30 · Manchester, United KingdomNTSB DCA98WA032Incident · No injuriesForeign investigationMcdonnell Douglas DC8-73 · Koln-Bonn, GermanyNTSB 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.NTSB MIA98WA098Accident · No injuriesForeign investigationPiper PA-28-161 · Cat Cay, BahamasNTSB 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.NTSB 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).NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB DCA98WA037Incident · No injuriesForeign investigationLearjet 36A · BahrainNTSB NYC98LA074Accident · No injuriesLimited investigationFinal reportBeech A36 · Lynchburgh, VAFailure of the number six connecting rod bolt due to improper maintenance.NTSB 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.NTSB 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…NTSB 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.NTSB 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."