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 MIA07LA072Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Lakeland, FLThe pilot's inadequate preflight. Contributing to the pilot's injuries was his failure to wear the installed shoulder harness.NTSB MIA07LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Canal Point, FLThe pilot-in-command's incorrect leaning of the fuel/air ratio resulting in the total loss of engine power during cruise flight.NTSB SEA07LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lincoln, CAAn in-flight fire occurred during the initial climb as a result of the aviation maintenance technician's failure to sufficiently tighten the b-nut that was found disconnected post-accident. A contributing factor was the engine manufacturer's failure to…NTSB ATL07CA068Accident · No injuriesData collectionFinal reportBeech D50E · Decatur, ALThe pilot's improper fuel management resulting in failure of both engines due to fuel starvation.NTSB ANC07LA028Accident · No injuriesLimited investigationFinal reportCessna 150 · Willow, AKThe student pilot's failure to maintain directional control while taxiing, which resulted in the airplane contacting a snow berm and nosing down. Factors associated with the accident were the snow and ice covered runway, and excessive taxispeed.NTSB SEA07LA093Accident · No injuriesLimited investigationFinal reportChampion 7ECA · East Wenatchee, WASeparation of the left main landing gear shock absorbing strut during takeoff. A missing screw was a factor.NTSB CHI07LA097Accident · No injuriesLimited investigationFinal reportCessna 150F · Grain Valley, MOThe pilot's failure to assure an adequate fuel supply which resulted in fuel exhaustion. Factors associated with the accident were the street sign which was contacted, the pilot's inability to maintain directional control of the airplane and the ditch which…NTSB SEA07LA098Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Ocala, FLThe failure of the left main axle during the landing roll, which resulted in the collapse of the left main landing gear. A crosswind on the landing runway was a factor.NTSB SEA07LA090Accident · 1 fatalLimited investigationFinal reportBurton Fly Baby · Arlington, AZThe pilot exceeding the design stress limits of the aircraft while maneuvering in intentional aerobatics.NTSB NYC07FA091Accident · 3 fatalField investigationFinal reportPiper PA-30 · Trappe, MDThe pilot's improper decision to fly into an area of thunderstorms, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the thunderstorm.NTSB LAX07CA124Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Stuart, FLThe pilot's failure to maintain directional control during takeoff.NTSB ATL07CA070Accident · No injuriesData collectionFinal reportCessna 152 · Hinesville, GAThe pilots improper preflight planning with resulted in a loss of engine power due to fuel exhaustion.NTSB SEA07CA091Accident · No injuriesData collectionFinal reportAC Mfg & Dev't CH 2000 · Madera, CAThe improper flare which resulted in a hard landing and porpoise.NTSB LAX07CA120Accident · No injuriesData collectionFinal reportCarpenter Lancair 320 · Los Angeles, CAcontamination of the number 2 fuel injector nozzle that lead to a partial loss of engine power.NTSB ENG07RA021Incident · No injuriesForeign investigationBoeing 747-400 Cargo · Chengdu, ChinaNTSB CHI07CA130Accident · No injuriesData collectionFinal reportBoeing E75N1 · Fostoria, OHThe pilot's inadequate compensation for wind conditions and his subsequent failure to maintain directional control during landing. The crosswind and wind gusts were contributing factors.NTSB ENG07WA031Accident · No injuriesForeign investigationIsrael Aircraft Industries 1124 · Darwin, AustraliaNTSB DFW07LA090Accident · 1 fatalLimited investigationFinal reportSchilleci RV-6 · Sinton, TXThe pilot's loss of control while performing an instrument approach. A contributing factor was the prevailing fog.NTSB ATL07LA067Accident · 1 fatalLimited investigationFinal reportPiper PA28-181 · New Tazewell, TNThe pilot's failure to maintain aircraft control. Contributing to the accident was the non-instrument rated pilot's continued flight from visual meteorological conditions into instrument meteorological conditions, and a low cloud ceiling.NTSB SEA07LA145Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · McCall, IDThe nosewheel steering system's uncommanded turn during the landing roll, making it impossible for the pilot to maintain directional control. Factors include a snow bank running parallel to the side of the runway.NTSB SEA07LA088Accident · No injuriesLimited investigationFinal reportJohnson Zodiac CH601 · Arlington, WAThe pilot's failure to apply carburetor heat when the engine lost power while being operated at a reduced power setting. Factors include carburetor icing condition, the pilot's failure to acquire the temperature/dew point information, and soft terrain in the…NTSB MIA07CA070Accident · Minor injuriesData collectionFinal reportCessna 206G · Fort Lauderdale, FLThe pilot's improper fuel management during the landing approach, resulting in a loss of engine power due to fuel starvation, and a forced off-airport landing.NTSB LAX07LA136Accident · No injuriesLimited investigationFinal reportCessna T210N · Oakland, CACollapse of the landing gear for undetermined reasons.NTSB LAX07LA119Accident · No injuriesLimited investigationFinal reportCessna 320E · Stockton, CAThe landing gear collapsed during taxi as a result of incorrect rigging of the landing gear by other maintenance personnel that prevented the landing gear downlock from functioning as designed.NTSB DEN07WA081Accident · 2 fatalForeign investigationPiper PA-34-200T · Klagenfurt, AustriaNTSB ANC07LA027Accident · Serious injuriesLimited investigationFinal reportCarris Avid Aircraft · Delray, FLThe loss of engine power during cruise flight for an undetermined reason, and the pilot's failure to maintain adequate airspeed during an emergency descent, which resulted in an inadvertent stall and in-flight collision with terrain. A factor associated with…NTSB SEA07LA087Accident · Serious injuriesLimited investigationFinal reportBurdette RV-3 · Bountiful, UTThe pilot's failure to maintain directional control during the landing roll. Factors include an earthen berm near the point where the aircraft departed the side of the runway.NTSB SEA07CA089Accident · No injuriesData collectionFinal reportCessna T206H · Boise, IDThe pilot's failure to maintain aircraft control which resulted in the aircraft porpoising during the landing. A factor was the wind gusts.NTSB NYC07CA090Accident · Serious injuriesData collectionFinal reportNavion A · Marlboro, MAThe pilot's failure to maintain a proper glidepath to the runway.NTSB MIA07IA080Incident · No injuriesIncident investigationFinal reportBeech E-55 · Key West, FLFailure of the nose landing gear drag brace due to overload during landing rollout for undetermined reasons. Contributing to the accident was the airplane had not been modified with an improved nose landing gear drag brace.NTSB MIA07CA069Accident · No injuriesData collectionFinal reportAeroprakt A-22 · Keenansville, FLThe pilot's failure to maintain directional control during the landing roll on a wet grass runway. A factor associated with the accident was the wet runway.NTSB ENG07IA018Incident · No injuriesIncident investigationFinal reportLearjet · Palm Springs, CAThe fatigue fracture of the fan blade due to the blade vendor's improper setup of the forging dies, which resulted in fan blades with airfoils that were below the minimum thickness in the highest stressed area of the airfoil and resulted in operating stresses…NTSB ATL07LA066Accident · 1 fatalLimited investigationFinal reportSzybowcowy Zaklad Do SZD-36A · Sylacauga, ALThe pilot's improper installation of the left wing attachment pin, which allowed it to disengage during cruise flight, resulting in wing separation.NTSB ANC07LA026Accident · No injuriesLimited investigationFinal reportCessna 175 · Bunnell, FLThe loss of engine power during cruise due to the separation of an engine piston, which resulted in a forced landing in a swamp and a collision with trees.NTSB SEA07CA086Accident · No injuriesData collectionFinal reportPiper PA-22 · Enumclaw, WAThe pilot's failure to apply carburetor heat during cruise flight. Factors include ambient weather conditions that were conducive to carburetor icing, and soft, muddy terrain at the location where the pilot attempted the power-off forced landing.NTSB LAX07LA118Accident · 2 fatalLimited investigationFinal reportRyan Navion A · Los Banos, CAthe pilot's intentional performance of aerobatic maneuvers that exceeded the design stress limits of the airplane structure. Also causal was the pilot's impairment due to the effects of alcohol consumption. Contributory was the pilot's impairment due to the…NTSB LAX07CA117Accident · No injuriesData collectionFinal reportEdwards Wag-A-Bond · Jean, NVthe separation of the tail wheel and rudder assembly compression springs that resulted in a loss of directional control during the landing rollout.NTSB NYC07FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Howell, NJThe pilot's improper decision to attempt a flight with known serious medical conditions, which resulted in impairment during cruise flight, likely due to a stroke or transient ischemic attack. A factor was the pilot providing false information on his medical…NTSB MIA07LA068Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-83 (MD-83) · Sanford, FLThe flight crew's failure to complete the checklist and adhere to airplane placards. Contributing to the accident was a separation of a B-nut on the rudder power hydraulic shut off valve for undetermined reasons.NTSB LAX07CA116Accident · No injuriesData collectionFinal reportCessna 180D · Winslow, AZthe pilot's failure to maintain directional control during landing.NTSB DFW07TA089Accident · Minor injuriesFinal reportPiper PA-18 · Sweetwater, TXThe loss of engine power due to the failure of the throttle lever/linkage. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL07LA065Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Woolsey, GAIn-flight fire of the right wing for undetermined reasons.NTSB ATL07LA063Accident · No injuriesLimited investigationFinal reportRandy Stanley Rotoway Exc 162F · Foley, ALLoss of engine power due to failure of the No. 4 engine exhaust valve.NTSB LAX07IA115Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 BA · Kahului, HIThe loss of tail rotor control due to wear damage to the pitch control input rod that resulted ultimately in the fatigue failure of the upper support yoke arm. Contributing factors were the improper maintenance inspection of the expansion pin assembly and the…NTSB ENG07WA022Incident · No injuriesForeign investigationPiper PA28-181 · Amman, JordanNTSB CHI07LA096Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Ravenna, OHThe pilot's failure to use carburetor heat in cruise flight. Carburetor icing conditions and a ditch were factors.NTSB LAX07WA235Accident · No injuriesForeign investigationEmbraer E-170 · Riyadh, Saudi ArabiaNTSB DEN07FA079Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ponte Vedra Bch, FLthe mechanic's improper installation of the attachment hardware for the servo to swashplate push-pull tube joint which resulted in a disconnection, subsequent loss of control, and impact with terrain. Contributing factors were the company management's…NTSB NYC07LA087Accident · No injuriesLimited investigationFinal reportGates Learjet 36A · Newport News, VAThe failure of the landing gear tires due to foreign object damage (FOD) on the runway. Contributing to the accident was the failure of the drag chute.NTSB MIA07IA067Incident · No injuriesIncident investigationFinal reportCessna 172S · Moore Haven, FLA loss of engine power due to foreign object damage to the oil pump.