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 NYC00LA075Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Kennedyville, MDThe pilot inadvertently stalling the airplane while turning final.NTSB MIA00LA137Accident · Minor injuriesLimited investigationFinal reportWalden A. Cooper Pitts S1S · Daytona Beach, FLCollapse of the tail wheel to the right during landing rollout when the forward attach bolt sheared for undetermined reasons. This resulted in the aircraft's rudder deflecting to the right, the pilot losing directional control, and the aircraft running off…NTSB LAX00LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeport, CAThe pilot's decision to continue with a high, steep, and fast approach, which resulted in a touchdown beyond the halfway point of the runway and the inability to stop on the remaining pavement, and, his delayed decision to initiate a landing abort. Also…NTSB LAX00LA150Accident · Minor injuriesLimited investigationFinal reportTaylor Smith Witman W-10 · Riverside, CAfailure of the pilot to recover from a bounced landing resulting in a loss of directional control and collision with a fence.NTSB LAX00LA149Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAThe student pilot's loss of directional control on takeoff that resulted in a collision with a taxiway surface.NTSB LAX00FA151Accident · 1 fatalField investigationFinal reportBeech B36TC · Fullerton, CAThe pilot's failure to maintain adequate airspeed while in the traffic pattern, which resulted in an inadvertent stall/spin. Contributing factor was the pilot's diverted attention with the loss of engine power from his inadvertent activation of the auxiliary…NTSB CHI00LA109Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Sherwood, NDcarburetor ice and the pilot's improper decisions when to use carburetor heat and to perform a soft field landing. Factors relating to this accident were the improper use of carburetor heat, the soft field landing attempt, and the snow covered field.NTSB SEA00LA065Accident · No injuriesLimited investigationFinal reportAero Design Eleven 12 · Spokane, WACracking of the weld between the tailwheel stinger housing and longitudinal cross tube, resulting in separation of the tube/tail wheel assembly from the airframe.NTSB LAX00LA142Accident · No injuriesLimited investigationFinal reportCessna 305A · Jackson, CAfailure of the pilot to adequately compensate for a crosswind condition, resulting in a loss of directional control and collision with a rock.NTSB LAX00FA148Accident · 2 fatalField investigationFinal reportFouga 6 CM 170 · San Joaquin, CAThe pilot's intentional performance of aerobatic maneuvers that resulted in the aircraft stalling and entering a spin from which he did not recover. A factor in the accident was the pilot's lack of experience in the aircraft.NTSB FTW00LA121Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fayetteville, ARThe failure of the inboard half of the right main landing gear wheel as a result of fatigue.NTSB DEN00LA071Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly F-15 · Anthony, NMFailure by the pilot to keep the burner operating until the balloon was secured. A factor was the passengers disregarding the instructions they had been given by the pilot.NTSB SEA00LA068Accident · No injuriesLimited investigationFinal reportPZL-Bielsko SZD-45A Ogar · Libby, MTA crack in the propeller blade that developed into a complete separation of the blade.NTSB SEA00LA066Accident · No injuriesLimited investigationFinal reportBeech A200 · Seattle, WAThe pilot's failure to properly follow pre-takeoff checklists (resulting in the engine starters remaining engaged after engine start, generators not being activated, discharge of the aircraft battery and consequent total electrical failure during flight with…NTSB DEN00LA072Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Rocky Ford, COA total loss of power due to an engine rocker arm failure and soft/unsuitable terrain during the subsequent forced landing.NTSB DEN00LA070Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Collins, COOn ground loss of control resulting in collision with airport markings due to inadequate compensation for wind conditions during landing roll. Factors were inaccurate in flight planning by landing with a tail wind component and lack of total pilot experience.NTSB DEN00IA076Incident · No injuriesIncident investigationFinal reportBeech A60 · Englewood, COThe failure of a number one cylinder connecting rod bolt due to under-torquing during engine major overhaul.NTSB CHI00FA110Accident · Minor injuriesField investigationFinal reportHughes 369D · Lemont, ILthe loss of engine power for undetermined reasons. A factor was the operation within the cross "hatched area" of the helicopter's height/velocity curve by the company.NTSB CHI00FA107Accident · 1 fatalField investigationFinal reportAeronca 7AC · Embarrass, MNthe inadvertent stall/spin the pilot encountered. A factor was the wind gusts.NTSB ATL00LA040Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Leesburg, FLThe pilot's failure to maintain clearance from objects during the final approach. A factor was downdraft on final approach.NTSB LAX00LA147Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Herlong, CAThe failure of the pilot to maintain directional control of the airplane during landing in gusting crosswind conditions.NTSB IAD00FA034Accident · No injuriesField investigationFinal reportTaylorcraft BC12D-4-85 · Dameron, MDThe failure of the float landing gear system due to non-standard repairs, improper modifications, and corrosion.NTSB FTW00LA119Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lubbock, TXThe pilot's incorrect positioning of the fuel selector which resulted in fuel starvation. Factors were the pilot's lack of familiarity with the fuel system due to an inadequate checkout by a flight instructor, and the lack of suitable terrain for the forced…NTSB CHI00LA106Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Saint Joseph, MOthe pilot's inadequate compensation for the wind condition. A factor to the accident was the high winds.NTSB NYC00LA109Accident · No injuriesLimited investigationFinal reportCessna 172 · North Adams, MAThe pilot's failure to obtain the proper touchdown point. A factor was a tailwind.NTSB LAX00LA173Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Chandler, AZThe inadequate maintenance inspection of the secondary shaft which resulted in its fatigue failure that emanated from a corroded circumferential score mark. A factor was the fence that the pilot flared to avoid, resulting in a hard landing.NTSB FTW00LA118Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Oak Grove, LAThe failure of a spur gear from the torque sensor gear assembly resulting in a loss of engine power. A factor was the muddy terrain encountered during the forced landing.NTSB MIA00FA129Accident · 3 fatalField investigationFinal reportLearjet 35A · Marianna, FLthe pilot's failure to maintain control of the airplane while on final approach resulting in the airplane striking trees. Factors in this accident were: improper planning of the approach, and not obtaining the proper alignment with the runway.NTSB LAX00LA143Accident · No injuriesLimited investigationFinal reportMuxlow Pitts S-1C · Phoenix, AZA loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and the rough/uneven terrain on which the airplane landed.NTSB FTW00LA122Accident · No injuriesLimited investigationFinal reportMooney M20A · Houston, TXThe pilot's delayed go-around and his failure to maintain the aircraft's clearance with trees.NTSB FTW00LA117Accident · 2 fatalLimited investigationFinal reportJohnson Zodiac CH-601-HDS · Orange, TXthe inadvertent stall while maneuvering. A contributing factor was the loss of engine power for an undetermined reason.NTSB ANC00LA042Accident · No injuriesLimited investigationFinal reportShort Brothers SC7 · Delta Junction, AKThe pilot's inadequate compensation for wind conditions during landing. Factors associated with the accident were an unfavorable wind, a crosswind, and an inadvertent swerve.NTSB SEA00LA072Accident · No injuriesLimited investigationFinal reportCessna A185F · Wallowa, ORThe pilot's failure to maintain proper runway alignment upon encountering a wind gust, and his subsequent failure or inability to maintain clearance with a tree during a go-around attempt. Factors included a short and narrow airstrip, gusty wind conditions,…NTSB SEA00LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Creswell, ORThe pilot's failure to maintain directional control. Factors include a drainage ditch and a crosswind.NTSB MIA00LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNA loss of engine power during takeoff climb for undetermined reasons resulting in an attempted emergency landing to unsuitable terrain and collision with a tree and transmission wires.NTSB MIA00IA128Incident · No injuriesIncident investigationFinal reportDassault DA-20 · Opa Locka, FLThe failure of the PIC to execute the complete procedure for emergency extension of the landing gear and the subsequent landing with the left main landing gear not locked fully down, resulting in an excursion off the runway and collision with a runway…NTSB NYC00IA116Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1125 · Pine Knot, KYThe partial failure of an inverter and the inadequate design of the electrical circuit breaker system.NTSB MIA00FA126Accident · 1 fatalField investigationFinal reportCessna 177RG · Chipley, FLThe failure of the pilot to maintain runway alignment during the initial climb from the grass airstrip. Also, the excessive pull-up by the pilot and inadvertent stall. Findings in the investigation were 1) in-flight collision with the tops of trees and 2) the…NTSB LAX00LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2G7 · Dallas, TXThe en route cruise encounter with forecast moderate turbulence.NTSB IAD00LA031Accident · No injuriesLimited investigationFinal reportBeech 23 · Selinsgrove, PAThe student pilot's inadequate correction for torque, which resulted in a loss of directional control of the airplane.NTSB FTW00FAMS1Accident · 1 fatalMissing aircraftFinal reportBeech M35 · Gulf Of Mexicothe pilot's continued flight of the airplane into known adverse weather conditions resulting in the pilot's loss of control of the aircraft. Contributing factors were the severe turbulence and windshear.NTSB SEA00LA060Accident · No injuriesLimited investigationFinal reportCessna 180K · Silverdale, WAThe pilot's inadequate compensation for winds. Factors include gusty, shifting winds, crosswinds, and an earthen berm near the edge of the runway.NTSB SEA00IA062Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Seattle, WAContaminated air being ducted into the aircraft's cabin from the engine exhaust of a nearby ground power cart.NTSB SEA00FA061Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Stanwood, WAThe disengagement of the oil jet fitting from its threaded receptacle at the forward end of the engine crankshaft. This resulted in excessive oil within the clutch assembly, the subsequent slipping of the clutch, and ultimately the disengagement of the rotor…NTSB LAX00LA153Accident · No injuriesLimited investigationFinal reportQuicksilver Sprint 2 · Fresno, CAThe overheating and seizure of the number 2 piston for undetermined reasons. Also causal was the pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing, which led to an inadvertent stall/mush.NTSB LAX00LA145Accident · No injuriesLimited investigationFinal reportOwens/Richburg Vans RV6-A · Sacramento, CAFailure to maintain sufficient altitude while on the base to final turn for landing subsequently striking the wing tip on the runway.NTSB FTW00LA114Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Brownfield, TXThe pilot inadvertently stalling the airplane. A factor was the pilot's diverted attention toward people on the ground.NTSB FTW00FA113Accident · 2 fatalField investigationFinal reportVans RV-6T · Pettigrew, ARthe pilot's continued flight into known adverse weather and his failure to maintain obstacle clearance. Contributing factors were adverse weather conditions, and the pilot's disregard for the forecasted adverse weather.NTSB DCA00WA035Incident · No injuriesForeign investigationBoeing 727 · Yap, MicronesiaNTSB DCA00RA036Accident · No injuriesForeign investigationBoeing 747-200F · Guayaquil, Ecuador