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 ANC10CA033Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fairbanks, AKThe pilot's failure to maintain directional control during takeoff.NTSB WPR10CA218Accident · No injuriesData collectionFinal reportCessna 172 · North Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions during taxi.NTSB OPS10IA132Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Houston, TXThe failure of the local controller to issue control instructions necessary to ensure positive control/standard separation of traffic operating within the Class B airspace.NTSB ERA10LA248Accident · Minor injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415-C · LaGrange, GAA loss of engine power due to the pilot's inadequate preflight inspection and his failure to ensure that the fuel tank shut-off valve was open resulting in fuel starvation.NTSB ERA10CA274Accident · No injuriesData collectionFinal reportCessna T210N · Fuquay-Varina, NCThe pilot's improper decision to land with a tailwind resulting in an overrun.NTSB ERA10CA249Accident · No injuriesData collectionFinal reportCessna 152 · Cross City, FLThe pilot's inadequate compensation for the crosswind condition resulting in the loss of directional control while landing.NTSB CEN10FA230Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Friendswood, TXThe airplane's impact with terrain for undetermined reasons.NTSB CEN10CA232Accident · No injuriesData collectionFinal reportHoac-Austria HK 36R Super Dimona · Highland, ILThe pilot's inadequate preflight planning and his delayed aborted takeoff.NTSB CEN10CA231Accident · No injuriesData collectionFinal reportBeech 35 · Boulder, COThe pilot's failure to maintain directional control while landing in a crosswind.NTSB WPR10FA217Accident · 1 fatalField investigationFinal reportPiper PA-30 · Merced, CAPilot incapacitation due to the combined effect of multiple unreported medical conditions.NTSB ERA10WA252Accident · 2 fatalForeign investigationAir Tractor AT802 · Resende, BrazilOn April 27, 2010, about 1845 Universal Coordinated Time (UTC), an Air Tractor AT-802, Brazilian registration PR-EBM, operated by Corpo de Bombeiros Militar do Rio de Janeiro, was destroyed following an in-flight loss of control and impact with terrain at…NTSB ERA10FA246Accident · 2 fatalField investigationFinal reportBeech 58 · Bear Branch, KYThe pilot's improper in-flight planning/decision, his continued flight into adverse weather (icing conditions), and failure to maintain an adequate airspeed during the emergency descent.NTSB WPR10CA215Accident · No injuriesData collectionFinal reportPZL-Swidnik PW-5 · Marana, AZThe pilot's inability to find thermal lift. Contributing to the accident was the failure of a computer that provided glide information and vertical speed instrumentation as a result of an improperly routed electrical cable that caused a short in the…NTSB ERA10CA243Accident · No injuriesData collectionFinal reportGlobe GC-1B · Carollton, GAThe pilot's improper recovery from the bounced landings, resulting in a loss of directional control.NTSB CEN10CA228Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Jamestown, NDThe pilot's failure to lower the landing gear, resulting in a gear-up landing.NTSB ANC10LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · King Cove, AKThe pilot's failure to maintain an appropriate descent rate during gusty winds while landing, resulting in a hard landing and damage to the airplane.NTSB WPR10WA265Accident · No injuriesForeign investigationBeech 200 · Nadi, FijiOn April 25, 2010, at 1406 coordinated universal time, a Beech 200, French registry F-OIAN, landed with the gear retracted following an electrical system anomaly at the Nadia Airport, island of Fiji. The airplane was operated by Air Alize as an international…NTSB ERA10IA254Incident · No injuriesIncident investigationFinal reportPiper PA 46-350P · Owensboro, KYA failure of the pilot's side window due to undetected cracking around the lower aft portion of the storm window cutout.NTSB CEN10CA229Accident · Minor injuriesData collectionFinal reportThomas Long Long's Paraglider · Amarillo, TXThe pilot’s failure to maintain control of the powered parachute, resulting in an unintentional departure and subsequent collision with power lines and the ground.NTSB CEN10CA224Accident · No injuriesData collectionFinal reportCessna 170-B · White Bear Lake, MNThe flight instructor's inadequate attempted recovery from a bounced landing and the student pilot's abrupt use of the brakes, which resulted in the airplane nosing over.NTSB ERA10LA247Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Clemson, SCThe airplane's inadvertent collision with deer during a night takeoff. Contributing to the accident was the lack of a deer barrier between the airport and an adjacent wooded area.NTSB ERA10CA245Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Hoensdale, PAThe pilot's improper final approach, resulting in a bounced landing and ground loop. Contributing to the accident was the pilot's lack of experience in tailwheel airplanes.NTSB ERA10CA244Accident · No injuriesData collectionFinal reportCessna 172N · Poughkeepsie, NYThe pilot's failure to maintain directional control on the landing rollout.NTSB ERA10CA241Accident · No injuriesData collectionFinal reportCessna 172P · Wurtsboro, NYThe student pilot's improper flare and recovery from a bounced landing.NTSB DCA10WA054Incident · No injuriesForeign investigationBoeing 737-300 · Riyadh, Saudi ArabiaOn April 24, 2010, a Mirage Aviation Boeing 737-300, registration N444HE, experienced a dual engine power loss shortly after rotation from runway 33R at King Khaled International Airport (OERK), Riyadh, Saudi Arabia. The airplane made an emergency return to…NTSB WPR10LA214Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Madera, CAA loss of engine power for undetermined reasons.NTSB ERA10CA242Accident · No injuriesData collectionFinal reportSeymour Robert M Rotorway 162F · Dallas, GAThe student pilot's failure to maintain control of the helicopter during landing resulting in a roll over.NTSB ERA10CA239Accident · No injuriesData collectionFinal reportNew Standard D-25 · Vidalia, GAThe pilot’s failure to maintain directional control during landing.NTSB CEN10WA292Accident · 1 fatalForeign investigationPiper PA28R · Emäsalo, FinlandOn April 23, 2010, at 1131 coordinated universal time, a Piper PA-28R-200, OH-PAM, was substantially damaged upon impact with terrain near Emäsalo, Finland. One crew member was fatally injured, another crew member was seriously injured, and a passenger was…NTSB CEN10LA222Accident · Serious injuriesLimited investigationFinal reportCross-Capps Breezy · Livingston, TXA loss of engine power for undetermined reasons.NTSB WPR10LA212Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Buckeye, AZA partial loss of engine power during the takeoff roll for undetermined reasons.NTSB OPS10IA155Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135KL · Chicago, ILThe air traffic controller's issuance of an improper takeoff clearance to the pilot of the Embraer. Contributing to the incident was the instructor’s inadequate monitoring of the trainee local controller.NTSB ERA10CA240Accident · No injuriesData collectionFinal reportGrumman G164 · Hampton, GAA total loss of engine power during a go-around due to fuel exhaustion as a result of the pilot's inadequate preflight planning.NTSB WPR10LA210Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Tooele, UTThe complete loss of power in one engine due to fuel starvation as a result of the pilot's failure to reposition the cross-feed valve prior to takeoff and the flight instructor's failure to monitor the pilot's actions. Contributing to the accident was the…NTSB WPR10FA211Accident · 2 fatalField investigationFinal reportAirBorne WindSport Edge XT-912-L · Captain Cook, HIThe pilot’s intentional in-flight maneuvers that exceeded the structural limits of the aircraft, which resulted in structural failure of the wings.NTSB ERA10LA238Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Newfane, VTThe pilot's inadvertent encounter with a rope while maneuvering during powerline operations for undetermined reasons.NTSB CEN10LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Alpine, TXA total loss of engine power for undetermined reasons.NTSB CEN10CA225Accident · Minor injuriesData collectionFinal reportSchweizer SGS1-34 · Waynesville, OHThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB CEN10CA215Accident · No injuriesData collectionFinal reportMurray Starlite · Shelbyville, ILThe corrosion of the left landing gear rotor and brake, which resulted in the loss of directional control during the landing rollout, and the pilot's inadequate preflight inspection.NTSB CEN10CA211Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · White Bear Lake, MNA total loss of engine power during takeoff due to fuel contamination as a result of the pilot's inadequate preflight inspection.NTSB WPR10TA213Accident · No injuriesFinal reportCessna T206H · Fullerton, CAThe pilot’s inadequate compensation for the wind conditions during the landing flare and failure to maintain directional control on the ground.NTSB WPR10CA226Accident · No injuriesData collectionFinal reportBeech B35 · Burbank, CAThe airplane's encounter with turbulence while at an airspeed above maneuvering airspeed, which exceeded the limit load of the stabilizers and ruddervators.NTSB WPR10CA224Accident · No injuriesData collectionFinal reportEvolution Trikes Revo · Eleele, HIA loss of engine power as a result of fuel exhaustion due to the pilot's improper decision to continue the flight after the low fuel warning. Contributing to the accident was the typographical error in the flight manual concerning the unusable fuel quantity.NTSB OPS10IA090Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Burbank, CAThe improper separation procedures by air traffic control.NTSB CEN10LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain control of the airplane. Contributing to the accident was the pilot’s decision to conduct the flight with known physiological impairment and his use of unapproved sedating medication, both of which likely impaired his ability…NTSB CEN10CA221Accident · No injuriesData collectionFinal reportPiper PA-24-250 · West Chicago, ILThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN10CA209Accident · No injuriesData collectionFinal reportTrue Flight Holdings AA-5B · Muskegon, MIThe inadvertent in-flight collision with a goose.NTSB ERA10LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Avon Park, FLThe operator's failure to correct known deficiencies with the carburetor, which resulted in a complete loss of engine power and subsequent forced landing by the pilot. Also causal was the operator's decision to rent the airplane in an unairworthy condition.NTSB ERA10FA232Accident · 1 fatalField investigationFinal reportMaule M5-235C · Zellwood, FLThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall, loss of aircraft control, and collision with trees.NTSB CEN10IA219Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2C10 · Kansas City, MOThe malfunction of the airplane’s aileron control system due to ice accumulation.