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 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.NTSB 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…NTSB 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.NTSB IAD00LA045Accident · No injuriesLimited investigationFinal reportBeech A-36 · Bedford, MAthe pilot's improper fuel management which resulted in fuel starvation.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB MIA00LA179Accident · No injuriesLimited investigationFinal reportAerostar S57-A · Windermere, FLan in-flight collision with a tree. A factor in this accident was high wind conditions.NTSB LAX00FA206Accident · 2 fatalField investigationFinal reportBeech F33A · Columbia, CAThe pilot's failure to abort the downwind takeoff and his failure to attain flying speed.NTSB IAD00FA044Accident · 1 fatalField investigationFinal reportKurzenburger Stuka JU-87 · Urbana, MDThe pilot's failure to obtain/maintain aircraft control after takeoff.NTSB FTW00WA173Accident · Minor injuriesForeign investigationCessna A185F · Mixcolaja, GuatemalaNTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB SEA00LA091Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Wolf Point, MTIn flight collision with birds.NTSB 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.NTSB 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.NTSB 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.NTSB FTW00FA154Accident · 2 fatalField investigationFinal reportCessna 152 · Noble, OKthe failure of both pilots to maintain visual lookout.NTSB 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.NTSB DCA00WA054Accident · No injuriesForeign investigationMcDonnell Douglas MD-80 · Paris, FranceNTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB LAX00LA203Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Pacific Ocean (Pacific Ocean)Physical incapacitation of the pilot from improper handling of a pesticide.NTSB FTW00LA169Accident · 1 fatalLimited investigationFinal reportCecil Thorp T-18 · West, TXThe loss of control for an undetermined reason.NTSB 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.NTSB CHI00LA143Accident · Minor injuriesLimited investigationFinal reportCessna T207A · Green Bay, WIthe improper compensation for the wind conditions. A factor in the accident was the wind shear.NTSB NYC00LA142Accident · No injuriesLimited investigationFinal reportHeli-Eagle Ultrasport 496 · Newport News, VAThe pilot's failure to maintain control of the helicopter.NTSB MIA00FA166Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Aliceville, ALThe in-flight collision with trees then terrain while descending for undetermined reasons.NTSB 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.NTSB CHI00LA141Accident · No injuriesLimited investigationFinal reportCessna C310R · Hibbing, MNthe deer incursion on the landing runway.NTSB 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.NTSB 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.NTSB FTW00WA172Accident · No injuriesForeign investigationFairchild F-27E · Coca, EcuadorNTSB FTW00LA152Accident · Serious injuriesLimited investigationFinal reportCameron V-90 · Frisco, TXThe pilot's inadequate passenger briefing for a high wind landing. A factor was the wind.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ANC00LA061Accident · No injuriesLimited investigationFinal reportCessna 402C · Cordova, AKAn in-flight collision with a bird.NTSB 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.NTSB 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.NTSB 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.