NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 CEN13LA414Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T41 · Coy, ARThe propeller’s uncommanded reverse thrust during the landing flare due to improper rigging of the propeller’s governor linkage.NTSB CEN13LA409Accident · 1 fatalLimited investigationFinal reportFlight Design Ctsw · Taos, NMThe airplane's unexpected encounter with a dust devil, which resulted in the loss of airplane control.NTSB CEN13LA408Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXThe pilot’s failure to use the proper taxi procedure, which resulted in a brake system fire.NTSB WPR13LA317Accident · No injuriesLimited investigationFinal reportCessna 182H · Hesperia, CAThe loss of engine power during cruise flight due to the detachment of the mixture control cable from its mounting clamp.NTSB WPR13LA315Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Alta, UTThe flight instructor's decision to follow a route over mountainous terrain in conditions that exceeded the helicopter’s ability to maintain terrain clearance.NTSB ERA13LA318Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Beaufort, NCA failure of the right brake for reasons that could not be determined because a postaccident examination of the brake could not be performed.NTSB ERA13CA317Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Bronston, KYThe pilot’s failure to maintain airspeed during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s reduced climb performance due to density altitude, as well as the pilot’s decision to initiate the takeoff from…NTSB CEN13CA400Accident · No injuriesData collectionFinal reportCessna 120 · Lakeville, MNThe student pilot's excessive application of the brakes during the landing roll and the flight instructor's delayed remedial action, which resulted in a nose-over.NTSB WPR13LA322Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Albany, ORThe loss of hydraulic fluid, which rendered the brakes ineffective. The reason for the loss of hydraulic fluid could not be determined based on the available evidence.NTSB WPR13LA314Accident · Serious injuriesLimited investigationFinal reportLuy Wayman Lockwood Aircam · Groveland, CAThe pilot’s inadequate compensation for a crosswind and failure to maintain airplane control during a go-around.NTSB WPR13LA313Accident · 1 fatalLimited investigationFinal reportNorth Wing Uum Sport X2 · Parker Dam, CAThe student pilot’s abrupt maneuver to avoid transmission wires, which resulted in his loss of airplane control. Contributing to the accident were the pilot’s decision to perform a low-altitude flight, his distracted attention, and his failure to monitor the…NTSB DCA13MA121Accident · 10 fatalMajor investigationFinal reportDehavilland DHC-3 · Soldotna, AKThe operator's failure to determine the actual cargo weight, leading to the loading and operation of the airplane outside of the weight and center of gravity limits contained in the airplane flight manual, which resulted in an aerodynamic stall. Contributing…NTSB CEN13LA398Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Sandwich, ILThe pilot’s failure to recognize the formation of carburetor ice during cruise descent and apply carburetor heat, which resulted in the total loss of engine power.NTSB WPR13LA310Accident · No injuriesLimited investigationFinal reportRockwell NA-265-65 · Las Vegas, NVThe pilots’ failure to follow the airplane manufacturer’s emergency procedures for a hydraulic system failure and emergency braking, which resulted in the loss of braking action upon landing and the subsequent loss of directional control while turning off the…NTSB WPR13CA311Accident · Minor injuriesData collectionFinal reportBellanca 8GCBC · Long Beach, CAThe pilot did not maintain adequate airspeed which resulted in an inadvertent stall and loss of aircraft control. Contributing to the accident was the pilot's improper use of flaps.NTSB DCA13MA120Accident · 3 fatalClass 1 · MajorFinal reportBoeing 777-200ER · San Francisco, CAThe flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…NTSB CEN13LA401Accident · 1 fatalLimited investigationFinal reportJDT 1600R · Chesaning, MIThe failure of the propeller reduction gearbox and the pilot’s subsequent failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall and spin. Contributing to the accident were…NTSB CEN13LA395Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Plover, WIThe pilot’s failure to maintain proper engine rpm, which resulted in a high rate of descent and ground impact.NTSB ANC13CA062Accident · No injuriesData collectionFinal reportAeronca 11AC · Kodiak, AKThe loss of engine power due to carburetor icing and the pilot's failure to continue the use of carburetor heat after experiencing carburetor ice.NTSB WPR13CA316Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Casa Grande, AZThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the pilot's and the flight examiner's distracted attention.NTSB WPR13CA309Accident · Minor injuriesData collectionFinal reportCessna 172S · Monroe, WAThe student pilot's failure to maintain directional control during the landing roll, and the flight instructor's delayed remedial action that resulted in a runway excursion.NTSB OPS13IA071Incident · No injuriesIncident investigationFinal reportGulfstream GIV - Undesignat · Las Vegas, NVThe Federal Aviation Administration's (FAA) inadequate procedures, which did not require specific separation between aircraft operating on nonintersecting runways where flightpaths may intersect and led to an airborne conflict between two aircraft.…NTSB ERA13CA316Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Blairstown, NJThe flight's encounter with a downdraft from a ridge shortly after takeoff resulting in a loss of lift and collision with terrain during an uncontrolled descent.NTSB CEN13LA397Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Nappanee, INThe failure of the No. 6 piston due to detonation and the subsequent interruption of the engine oil flow that resulted from the piston fragments.NTSB WPR13LA319Accident · No injuriesLimited investigationFinal reportCessna T210K · Phoenix, AZThe collapse of the left main landing gear due to a broken gear tooth in the landing gear actuator.NTSB WPR13CA324Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Canby, ORThe pilot's failure to maintain directional control during the landing rollout in gusting wind conditions.NTSB ERA13CA315Accident · Minor injuriesData collectionFinal reportBeech A23-19 · Easton, PAThe pilot's improper touchdown point during landing, which resulted in a runway overrun. Contributing to the accident was the pilot’s decision to land with a tailwind condition and his lack of recent experience.NTSB CEN13LA394Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Colfax, LAThe pilot’s failure to maintain clearance from a tree.NTSB WPR13LA308Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18B · Caldwell, IDThe pilot’s improper decision to continue the takeoff with a tailwind after he recognized a performance problem with the airplane and his delayed action to dump the chemical load.NTSB WPR13LA307Accident · Serious injuriesLimited investigationFinal reportBoson RV-4 · Hurricane, UTThe pilot’s incorrect approach/descent path with a tailwind, which resulted in a long landing at an excessive groundspeed and a subsequent runway excursion.NTSB WPR13CA361Accident · Minor injuriesData collectionFinal reportBuckeye Dream Machine · Fruitland, WAThe operation of a powered parachute by a non-certificated pilot, and the pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with a vehicle.NTSB ERA13LA314Accident · Serious injuriesLimited investigationFinal reportSikorsky 269C · Burnham, METhe pilot's failure to maintain yaw control while operating out of ground effect at a low airspeed, which resulted in the loss of tail rotor effectiveness, an uncontrolled descent, and an in-flight collision with trees and terrain. Contributing to the…NTSB CEN13LA406Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCBC · Lufkin, TXThe restricted movement of the carburetor’s forked needle valve within its seat due to the mechanic’s misadjustment of the valve clip forks, which resulted in fuel starvation.NTSB CEN13LA402Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Tillar, ARThe loss of engine throttle control during takeoff due to an unsecured cockpit throttle control pin, which resulted in a runway overrun.NTSB ANC13LA063Accident · No injuriesLimited investigationFinal reportCurtiss Wright C-46F · Fairbanks, AKThe failure of the right main landing gear side brace due to fatigue, which resulted in a collapse of the right main landing gear.NTSB WPR13LA304Accident · No injuriesLimited investigationFinal reportDorman Bakeng · Garden Valley, IDA mechanical failure of the oil cooler, which resulted in a complete loss of oil and engine power.NTSB WPR13CA213Accident · Serious injuriesData collectionFinal reportAviat A-1B · Fort Smith, MTThe pilot's improper decision to land on rough terrain at a high density altitude.NTSB ENG13IA033Incident · No injuriesIncident investigationFinal reportBoeing 777 · Ugolny Airport, RussiaThe failure of the transfer gearbox resulting from the fracture and separation of the radial gearshaft from fatigue cracking as a result of a combination of high residual tensile stresses produced by local decarburization during the manufacturing process…NTSB CEN13LA391Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402B · Ipswich, SDThe pilot’s failure to obtain adequate airspeed during the takeoff roll, which resulted in an aerodynamic stall.NTSB CEN13CA399Accident · Minor injuriesData collectionFinal reportCessna 140 · Vernon, TXThe pilot’s excessive use of wheel brakes during the takeoff roll, which resulted in a nose-over.NTSB CEN13CA389Accident · Minor injuriesData collectionFinal reportBeech P35 · Bridgeport, TXThe failure of both the flight instructor and the pilot to monitor and manage the fuel on board, which resulted in an engine failure due to fuel starvation.NTSB WPR13LA302Accident · No injuriesLimited investigationFinal reportS.N.I.A.S. AS-350B Ecureuil · Hamilton, MTThe loss of engine power during cruise flight due to the fatigue failure of a pneumatic fuel controller pipe. Also causal was maintenance personnel’s failure to adequately maintain the pipe and replace it with a thicker type.NTSB ANC13CA060Accident · No injuriesData collectionFinal reportPiper PA-12 · Talkeetna, AKThe pilot's loss of situational awareness, which resulted in a wrong turn into a box canyon, and an in flight collision with terrain.NTSB WPR13CA306Accident · No injuriesData collectionFinal reportMaule MX7-180A · Elko, NVA flat main landing gear tire during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR13CA301Accident · No injuriesData collectionFinal reportCessna 170B · Fallbrook, CAThe pilot’s failure to maintain adequate airspeed during the takeoff, and his loss of aircraft control during the subsequent stall recovery.NTSB ERA13IA313Incident · No injuriesIncident investigationFinal reportBell Helicopter Textron Canada 206 · New York, NYThe improper maintenance decision to adjust the engine oil pressure regulator valve in response to high oil pressure indications rather than to properly troubleshoot the anomaly, which then allowed an existing oil supply path blockage to increase and led to…NTSB ERA13FA309Accident · 2 fatalField investigationFinal reportNanchang China CJ-6A · Ocean City, MDThe pilot's failure to terminate the intentional aerobatic spin at an altitude adequate to prevent impacting the water. Contributing to the accident was the pilot's loss of situational awareness due to target fixation during the prolonged aerobatic maneuver.NTSB CEN13WA382Accident · 1 fatalForeign investigationGulfstream GA-7 · Veberod, SwedenOn June 30 2013, at 0920 coordinated universal time a Gulfstream GA-7, Swedish registration SE-MBO, owned and piloted by the private individual, was destroyed when it impacted terrain under unknown circumstances near Veberod, Sweden. The pilot was fatally…NTSB CEN13LA520Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Boonville, MOThe pilot’s failure to maintain directional control of the airplane during landing on a gravel road.NTSB CEN13LA383Accident · Serious injuriesLimited investigationFinal reportVink Robert D Youngster · Grand Haven, MIThe loss of engine power due to carburetor icing.