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 LAX05CA181Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Tucson, AZthe improper flare by an undetermined crewmember, which resulted in a hard landing.NTSB DFW05CA124Accident · No injuriesData collectionFinal reportCessna 210L · Houston, TXThe pilot's failure to maintain directional control during landing roll. A contributing factor was reported partial loss of brake control.NTSB ANC05CA077Accident · No injuriesData collectionFinal reportPiper PA-18 · Dillingham, AKThe instructor pilot's inadequate supervision, and the dual student's failure to maintain directional control. Factors associated with the accident were a crosswind, and an inadvertent ground loop.NTSB SEA05LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Puyallup, WAThe fatigue cracking of the upper torque link attach lugs on the right main landing gear strut, which resulted in separation of the right main landing gear.NTSB SEA05LA099Accident · No injuriesLimited investigationFinal reportHorvath Pitts S-1C · Creswell, ORLoss of engine power as a result of a carburetor float drop restriction during cruise flight. Tall grass in the landing area was a factor in the accident.NTSB SEA05LA098Accident · 1 fatalLimited investigationFinal reportCessna 150M · Elk River, IDThe pilot's inability to control the airplane during initial climb due to the restricted movement of the control yoke and rudder control by the passenger, which resulted in a loss of control and impact with trees.NTSB NYC05LA084Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Saluda, VAA loss of engine power due to an unsecured mixture control cable, which was not properly secured by maintenance personnel during a recent annual inspection. Also causal was the airplane owner's continued operation of the airplane with known deficiencies.NTSB LAX05LA173Accident · Minor injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Sonoma, CAa partial loss of engine power, which resulted from the fuel servo leaking and generating an excessively rich fuel/air mixture. A factor was the owner's failure to comply with a service bulletin.NTSB LAX05LA172Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Geyserville, CAA loss of engine power due to failure of the number 1 connecting rod bearing due to a probable oil starvation.NTSB LAX05LA171Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Jean, NVthe pilot's in-flight decision to continue a flight with weak thermal lift activity, and his delayed recognition of a loss of altitude while attempting to find a thermal in which to soar. A factor in the accident was the lack of suitable terrain for the…NTSB LAX05LA170Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Glendale, AZthe pilot's misjudged landing flare that resulted in a stall and hard landing.NTSB LAX05LA168Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Seligman, AZthe pilot's fuel system mismanagement that led to a fuel starvation induced loss of power in the left engine. Also causal was the pilot's improper use of the emergency landing gear extension system.NTSB LAX05CA169Accident · No injuriesData collectionFinal reportBeech C23 Sundowner · San Martin, CAthe pilot's improper landing flare that resulted in a porpoise and a hard landing.NTSB IAD05LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Dover, DEThe separated baffle which blocked the tailpipe resulting in a subsequent total loss of engine power.NTSB DFW05CA120Accident · No injuriesData collectionFinal reportMayfield Sparrowhawk · Hondo, TXThe pilot's failure to maintain control of the gyrocraft during takeoff. A contributing factor was the failure of the pre-rotator cable.NTSB DEN05LA077Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Denver, COthe failure of the nose gear actuator resulted in penetration of the forward pressure bulkhead and a loss of pressurization.NTSB DEN05LA075Accident · No injuriesLimited investigationFinal reportCessna T188C · Fowler, COthe pilot's failure to maintain visual lookout and clearance, resulting in an in-flight collision with transmission lines.NTSB CHI05LA114Accident · 1 fatalLimited investigationFinal reportCessna A188B · Ludell, KSThe pilot's failure to maintain clearance from trees during an aerial application maneuver. The trees and the sun glare were contributing factors.NTSB ATL05LA091Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Newnan, GAThe improper repair to the main landing gear assembly resulted in the actuator bracket failure and the right main gear collapse. A factor was the inadequate inspection of the right main landing gear.NTSB ANC05LA076Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control during the landing roll. Factors associated with the accident are a crosswind, and an inadvertent ground loop/swerve.NTSB NYC05MA083Incident · No injuriesMajor investigationFinal reportBoeing 717-200 · Union Star, MOA loss of reliable airspeed indication due to an accumulation of ice on the air data/pitot sensors. Contributing to the incident was the flight crew's improper response to the erroneous airspeed indications, their lack of coordination during the initial…NTSB IAD05LA063Accident · 2 fatalLimited investigationFinal reportAeronca 65-TAC · Harrisonburg, VAA total loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with the ground.NTSB IAD05LA062Accident · Minor injuriesLimited investigationFinal reportAeronca 65 · Sanborn, NYThe pilot's inadequate preflight preparation, which resulted in fuel exhaustion, and subsequent loss of engine power during cruise flight.NTSB DFW05IA119Incident · No injuriesIncident investigationFinal reportEurocopter France EC120B · S.Timbalier 265The loss of engine power as result of the failure of the oil pump assembly.NTSB SEA05LA100Accident · No injuriesLimited investigationFinal reportCessna 152TW · Missoula, MTThe pilot's failure to maintain clearance from a taxiway identification sign as he attempted to turn off the runway onto the taxiway during the last part of the landing roll. Factors include a taxiway identification sign in the vicinity of the intersection of…NTSB MIA05LA103Accident · No injuriesLimited investigationFinal reportAmerican General AG-5B · St. Augustine, FLThe separation of the throttle control for undetermined reasons, and the unsuitable terrain encountered by the pilot during the forced landing, resulting in a nose-over after touchdown.NTSB LAX05LA166Accident · No injuriesLimited investigationFinal reportBeech C35 · Rancho Santa Fe, CAfailure of the engine driven fuel pump due to the improper overhaul procedure of the fuel pump by an overhaul facility, and the use of parts that did not meet hardness specification.NTSB LAX05FA167Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Elko, NVThe pilot's continued VFR cruise flight into instrument meteorological conditions in mountainous terrain, and his failure to maintain clearance from terrain. A contributing factor was mountain obscuration and clouds.NTSB ENG05RA020Incident · No injuriesForeign investigationMcDonnell Douglas MD-82 · Rome, ItalyimportNTSB DCA05WA078Incident · No injuriesForeign investigationBoeing 757 · Manchester, United KingdomNTSB SEA05CA096Accident · No injuriesData collectionFinal reportPiper PA-12 · Snohomish, WAThe pilot's failure to maintain aircraft control during the landing roll on a sandbar which resulted in the aircraft nosing over.NTSB NYC05LA081Accident · No injuriesLimited investigationFinal reportZeidman RV-6A · Kennett Square, PAA fuel pump malfunction, as reported by the pilot, which resulted in a loss of engine power due to fuel starvation.NTSB NYC05CA082Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's improper flare and recovery from a bounced landing.NTSB LAX05LA164Accident · No injuriesLimited investigationFinal reportRobinson R44 · Gustine, CAthe improper installation of the nut/bolt assembly connecting the left cyclic push-pull tube to the non-rotating swashplate by maintenance personnel, which led to a loss of roll control during takeoff.NTSB DEN05FA074Accident · 4 fatalField investigationFinal reportCessna T210G · Ouray, COthe pilot's inadvertent flight into adverse weather conditions, loss of control, and resulting exceedence of the design stress limits of the aircraft. which led to an in-flight structural failure. Factors in the accident included the pilot's inadequate…NTSB CHI05MA111Accident · Serious injuriesMajor investigationFinal reportMcDonnell Douglas DC-9-51 · Minneapolis, MNthe Captain of the other aircraft's decision to shutdown the left engine during taxi with no hydraulic pressure on the right side hydraulic system to effectively operate the brakes, steering, or thrust reversers. A factor was the fatigue fracture of the…NTSB DEN05CA073Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Fort Collins, COthe pilot's inadequate preflight planning/preparation which failed to assure adequate takeoff performance to clear obstacles. Contributing factors included the miscalculated weight and balance and the high density altitude.NTSB CHI05LA113Accident · No injuriesLimited investigationFinal reportMattson Zenith 601XL · Dike, IAA loss of engine power for undetermined reasons and the pilot misjudged the forced landing approach. Factors associated with the accident were the fence and the ditch which the airplane contacted.NTSB CHI05CA115Accident · No injuriesData collectionFinal reportCessna 172H · Plattsmouth, NEThe student pilot's inadequate compensation for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusting crosswind.NTSB ANC05LA075Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Elim, AKAn improper installation of a fuel line fitting by company maintenance personnel, which resulted in a fuel leak and subsequent in-flight engine compartment fire during cruise flight that was discovered during the landing roll.NTSB ANC05LA074Accident · No injuriesLimited investigationFinal reportCessna 170B · Homer, AKThe flight instructor's inadequate supervision of the flight during the landing roll, which resulted in a loss of control, and collision with a ditch. A factor associated with the accident was the student pilot's failure to maintain directional control.NTSB SEA05FA097Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · Lowell, IDThe number four exhaust valve sticking in the open position during cruise flight. Factors include the pilot's failure to have an Airframe and Powerplant mechanic look at the engine after it had run rough immediately after start-up prior to this and a number…NTSB NYC05CA080Accident · No injuriesData collectionFinal reportPalen Sopwith Camel · Rhinebeck, NYThe pilot's failure to maintain aircraft control during the takeoff roll. A factor in the accident was the uneven runway, and the pilot's lack of total experience in make and model.NTSB LAX05LA162Accident · Serious injuriesLimited investigationFinal reportUltramagic N-250 · Del Mar, CAThe pilot's failure to arrest the high rate of descent and an inadequate bounced landing recovery technique. a factor in the accident was the rough, uneven terrain.NTSB LAX05CA161Accident · No injuriesData collectionFinal reportSchempp-Hirth Discus 2b · Peoria, AZthe glider pilot encountered a downdraft that forced him to land in rough terrain.NTSB DFW05LA117Accident · No injuriesLimited investigationFinal reportRockwell International NA-265-80 · Brownwood, TXThe loss of engine power due to damage to the first stage compressor by a foreign object (bird).NTSB ATL05FA079Accident · 2 fatalField investigationFinal reportNorth American SNJ-6 · Kissimmee, FLThe failure of the outboard right-wing lower attachment bracket due to fatigue cracking and the subsequent in-flight separation of the right wing assembly.NTSB SEA05WA095Accident · 4 fatalForeign investigationCessna 207 · Tanauan City, PhilippinesNTSB MIA05WA101Accident · 6 fatalForeign investigationPiper PA-31-350 · Cordoba, ArgentinaNTSB LAX05LA165Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Willows, CAthe loss of engine power due to the fractured piston pin boss on the number 5 cylinder.