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 MIA00LA173Accident · No injuriesLimited investigationFinal reportRawdon T1 · North Miami Bch, FLThe failure of the pilot to change the fuel selector position after experiencing surging of the engine. Contributing to the accident was the partial loss of engine power due to fuel starvation and the incorrect reading of the left fuel gauge.May 27, 2000 · N2706D · Substantial damageNTSB MIA00FA172Accident · 2 fatalField investigationFinal reportAvions Mudry ET Cie CAP 10B · Bunnell, FLA midair collision due to the failure of the wingman to maintain proper clearance between his aircraft and the lead aircraft while conducting formation aerobatics and the subsequent loss of control of both aircraft resulting in an uncontrolled descent and…May 27, 2000 · N82BW · 2 aircraft · DestroyedNTSB LAX00FA207Accident · 2 fatalField investigationFinal reportCessna 172RG · Prescott, AZThe flight instructor's delayed remedial action, and his failure to correct an inappropriate descent during maneuvering flight, while engaged in commercial flight training maneuvers.May 27, 2000 · N5207U · DestroyedNTSB IAD00LA045Accident · No injuriesLimited investigationFinal reportBeech A-36 · Bedford, MAthe pilot's improper fuel management which resulted in fuel starvation.May 27, 2000 · N66SB · Substantial damageNTSB DEN00LA096Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Hurricane, UTThe complete loss of power due to the separation of the magneto ground lead and the rough and unsuitable terrain during the forced landing.May 27, 2000 · N35LP · Substantial damageNTSB CHI00FA145Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Taylor, MOflight into known adverse weather conditions and the altitude/clearance not maintained by the pilot. An additional cause was the improper in-flight planning/decision by the pilot. Contributing factors were the weather below approach/landing minimums, night…May 27, 2000 · N136EL · DestroyedNTSB NYC00LA145Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Hammonton, NJThe pilot's failure to maintain directional control during landing. A factor in this accident was the crosswind condition.May 26, 2000 · N16FJ · Substantial damageNTSB NYC00LA143Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Pittsfield, METhe pilot's improper use of unsuitable terrain for landing. A factor in the accident was the soft terrain.May 26, 2000 · N8872 · Substantial damageNTSB MIA00LA183Accident · No injuriesLimited investigationFinal reportHayes LONG-EZ · Collegedale, TNThe pilot's failure to maintain the proper glide path on final approach to insure arrival at the proper runway touchdown point. A factor in the accident is the pilot's unfamiliarity with the cockpit spoiler control's location and operation.May 26, 2000 · N9JZ · Substantial damageNTSB MIA00LA179Accident · No injuriesLimited investigationFinal reportAerostar S57-A · Windermere, FLan in-flight collision with a tree. A factor in this accident was high wind conditions.May 26, 2000 · N6341V · Substantial damageNTSB LAX00FA206Accident · 2 fatalField investigationFinal reportBeech F33A · Columbia, CAThe pilot's failure to abort the downwind takeoff and his failure to attain flying speed.May 26, 2000 · N2RM · DestroyedNTSB IAD00FA044Accident · 1 fatalField investigationFinal reportKurzenburger Stuka JU-87 · Urbana, MDThe pilot's failure to obtain/maintain aircraft control after takeoff.May 26, 2000 · N87DK · DestroyedNTSB FTW00WA173Accident · Minor injuriesForeign investigationCessna A185F · Mixcolaja, GuatemalaMay 26, 2000 · N4871Q · Substantial damageNTSB DEN00FA095Accident · 3 fatalField investigationFinal reportCessna T210K · Buena Vista, COthe pilot's disregard of the weather forecast, and his VFR flight into IMC. Contributing factors were snow showers, fog, and the mountainous terrain.May 26, 2000 · N9457M · DestroyedNTSB CHI00LA147Accident · No injuriesLimited investigationFinal reportCessna A188B · Sublette, KSthe failure of the pilot to attain aircraft control. Factors to the accident were the uneven terrain, the failure of the pilot to maintain directional control on the ground, and the crop.May 26, 2000 · N9076R · Substantial damageNTSB ATL00LA057Accident · No injuriesLimited investigationFinal reportJohn Thomas Cloud Dancer 2 · Franklin, NCThe pilot's failure to maintain directional control of the gyroplane during takeoff roll, resulting in a roll over.May 26, 2000 · N6314T · Substantial damageNTSB ANC00LA065Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Nenana, AKThe pilot's inadequate compensation for wind conditions during landing. A factor in this accident was the tailwind.May 26, 2000 · N43863 · Substantial damageNTSB SEA00LA094Accident · No injuriesLimited investigationFinal reportBoeing 767-200 · Seattle, WAThe failure of the B-767 flight crew to ensure their aircraft's jet blast was not a hazard to the Cessna. A factor for the Cessna was the B-767 moving on the taxiway. A factor for the B-767 was the Cessna standing in the runup area. A factor for both aircraft…May 25, 2000 · N767AX · 2 aircraft · No damageNTSB SEA00LA092Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58 · Buhl, IDThe pilot's inadequate visual lookout, and his failure to maintain adequate clearance from the power lines. The pilot's diverted attention, a dirty windshield, power lines, and light rain were factors.May 25, 2000 · N2253A · DestroyedNTSB SEA00LA091Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Wolf Point, MTIn flight collision with birds.May 25, 2000 · N30RA · DestroyedNTSB SEA00LA090Accident · No injuriesLimited investigationFinal reportCessna T210M · Boise, IDThe deterioration and subsequent leakage of a hydraulic line which resulted in the total loss of hydraulic fluid and the inability of the pilot to extend the landing gear into the locked position.May 25, 2000 · N761VZ · Substantial damageNTSB NYC00LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Toms River, NJThe failure of the number 9 cylinder connecting rod, due to a primer leak initiation of a partial hydraulic lock. A factor in the accident was the unsuitable terrain, to which the forced landing had to be made.May 25, 2000 · N910X · Substantial damageNTSB MIA00LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Chapel Hill, NCThe failure of the CFI to delay his landing until the approaching line of thunderstorms passed, causing the flight to encounter severely gusting wind conditions resulting in the loss of altitude control and collision with the terrain.May 25, 2000 · N47561 · DestroyedNTSB FTW00FA154Accident · 2 fatalField investigationFinal reportCessna 152 · Noble, OKthe failure of both pilots to maintain visual lookout.May 25, 2000 · N45973 · 2 aircraft · DestroyedNTSB DEN00LA098Accident · No injuriesLimited investigationFinal reportRosenvall Avid MK IV · Salina, UTThe pilot's failure to maintain aircraft control during landing roll. A factor was gusting winds from nearby thunderstorms.May 25, 2000 · N63827 · Substantial damageNTSB DCA00WA054Accident · No injuriesForeign investigationMcDonnell Douglas MD-80 · Paris, FranceMay 25, 2000 · FGHED · Substantial damageNTSB NYC00LA147Accident · No injuriesLimited investigationFinal reportLet L 33 Solo · Waynesville, OHThe pilot's failure to maintain aircraft control. Factors were gusty winds, and the pilot's lack of experience in the make and model accident glider.May 24, 2000 · N5711 · Substantial damageNTSB NYC00LA141Accident · 1 fatalLimited investigationFinal reportCarlson Criquet · East Palestine, OHThe failure of the powerplant to produce adequate power for undetermined reasons, and the pilot's continued operation of the airplane with known deficiencies.May 24, 2000 · N22CA · DestroyedNTSB MIA00LA170Accident · No injuriesLimited investigationFinal reportSouthwest Florida SW204 · Fort Pierce, FLAn in-flight separation of a tail rotor blade tip weight resulting in tail rotor assembly imbalance and separation due to the installation of an unapproved rotor blade by company maintenance personnel, and the subsequent collision with trees during an…May 24, 2000 · N37BA · Substantial damageNTSB LAX00LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Tonopah, NVThe pilot's failure to attain the proper rotation airspeed during initial takeoff and his improper aborted takeoff procedures.May 24, 2000 · N3700T · Substantial damageNTSB LAX00LA203Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Pacific Ocean (Pacific Ocean)Physical incapacitation of the pilot from improper handling of a pesticide.May 24, 2000 · N24CV · DestroyedNTSB FTW00LA169Accident · 1 fatalLimited investigationFinal reportCecil Thorp T-18 · West, TXThe loss of control for an undetermined reason.May 24, 2000 · N856CW · DestroyedNTSB FTW00LA153Accident · Minor injuriesLimited investigationFinal reportEurocopter AS350B2 · Patterson, LAthe failure of the tail rotor spider bearing, the pilot's failure to follow the proper emergency procedures as stated in the helicopter's checklist by not performing a run-on landing, and the inadvertent deactivation of the hydraulic system.May 24, 2000 · N350JG · Substantial damageNTSB CHI00LA143Accident · Minor injuriesLimited investigationFinal reportCessna T207A · Green Bay, WIthe improper compensation for the wind conditions. A factor in the accident was the wind shear.May 24, 2000 · N774EA · Substantial damageNTSB NYC00LA142Accident · No injuriesLimited investigationFinal reportHeli-Eagle Ultrasport 496 · Newport News, VAThe pilot's failure to maintain control of the helicopter.May 23, 2000 · N9258H · Substantial damageNTSB MIA00FA166Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Aliceville, ALThe in-flight collision with trees then terrain while descending for undetermined reasons.May 23, 2000 · N711MS · DestroyedNTSB CHI00LA142Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Sandstone, MNthe pilot not attaining an airspeed necessary for the go-around and not maintaining clearance from terrain. Factors were the crosswind, gust, and the collapsed nose gear.May 23, 2000 · N5712L · Substantial damageNTSB CHI00LA141Accident · No injuriesLimited investigationFinal reportCessna C310R · Hibbing, MNthe deer incursion on the landing runway.May 23, 2000 · N87430 · Substantial damageNTSB MIA00LA168Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Monticello, MSThe failure of the pilot to maintain directional control during takeoff into crosswind conditions resulting in the collision with trees. A factor in the accident was the pilot's lack of familiarity with the aircraft.May 22, 2000 · N6744K · Substantial damageNTSB MIA00LA165Accident · No injuriesLimited investigationFinal reportLet L-13 · Pensacola, FLThe student's failure to maintain the proper landing pattern altitude resulting in an undershoot during landing and collision with a fence. A factor in the accident was the pilot's failure to realize the spoilers were still deployed during the undershoot.May 22, 2000 · N90867 · Substantial damageNTSB FTW00WA172Accident · No injuriesForeign investigationFairchild F-27E · Coca, EcuadorMay 22, 2000 · HCAYM · Substantial damageNTSB FTW00LA152Accident · Serious injuriesLimited investigationFinal reportCameron V-90 · Frisco, TXThe pilot's inadequate passenger briefing for a high wind landing. A factor was the wind.May 22, 2000 · N6012C · No damageNTSB FTW00LA149Accident · Serious injuriesLimited investigationFinal reportPZL-Mielec M-18A · Kilbourne, LAThe corrosion and fatigue cracking of the right wing attachment fitting, which resulted in the right wing separating in flight.May 22, 2000 · N2296C · DestroyedNTSB DEN00IA093Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Erie, COImproper installation of cylinders by unknown maintenance personnel who failed to torque the cylinder stud nuts sufficiently.May 22, 2000 · N424TP · Minor damageNTSB CHI00LA144Accident · No injuriesLimited investigationFinal reportCessna C-T188C · Elgin, NDthe failure of the pilot in command to maintain clearance with the ground during an aerial application.May 22, 2000 · N2075J · Substantial damageNTSB CHI00LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Goshen, INthe failure of the student pilot to maintain directional control on the takeoff roll. Factors to the accident were the lack of experience of the student pilot and the improper use of the throttle.May 22, 2000 · N68182 · Substantial damageNTSB ANC00LA061Accident · No injuriesLimited investigationFinal reportCessna 402C · Cordova, AKAn in-flight collision with a bird.May 22, 2000 · N402ET · Substantial damageNTSB MIA00LA169Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Nashville, TNThe passenger's onboard disturbance and self-evacuation from the parked aircraft, resulting in injuries. A factor in the accident was the lack of backup electrical power to the terminal which necessitated a lengthy ground hold.May 21, 2000 · N522SW · No damageNTSB LAX00LA202Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Boulder City, NVThe fracture and separation of the oil pressure line fitting, which resulted in a loss of oil and an oil starvation failure of the engine.May 21, 2000 · N9591Y · Substantial damageNTSB LAX00LA201Accident · 1 fatalLimited investigationFinal reportIssoire-Aviation PIK-30 · Minden, NVThe pilot's inadequate in-flight planning/decision to attempt to make it back to the runway for landing after experiencing a loss of lift and not maintaining a proper descent rate.May 21, 2000 · N30PK · Substantial damage