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 IAD01FA006Accident · No injuriesField investigationFinal reportBritish Aerospace Jetstream 3201 · Dulles, VAThe manufacturer's lack of dimensional inspection and repair requirements for the gearbox forward and aft diaphragm, which caused the bull gear to shift and resulted in an uncontained separation of the bull gear during flightNTSB FTW01LA016Accident · Serious injuriesLimited investigationFinal reportSteven R. Jackson Harmon Rocket 2 · Houston, TXThe collapsing of the inner liner of the induction air hose, resulting in a restriction of airflow to the engine and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA028Accident · No injuriesLimited investigationFinal reportPiper PT-46 · Eden Prairie, MNthe pilot misjudging the landing flare, and his failure to recover from the bounced landing.NTSB NYC01LA025Accident · No injuriesLimited investigationFinal reportCessna 172M · Camp Springs, MDThe pilot's improper in-flight decision to operate close behind a large airplane at the same altitude, which resulted in a wake turbulence encounter.NTSB LAX01LA019Accident · Serious injuriesLimited investigationFinal reportBeech 300 · Concord, CAthe pilot's delayed decision to abort the takeoff and his failure to utilize the propeller's reverse pitch function.NTSB FTW01LA012Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Stanton, TXThe failure of the pilot to maintain clearance with the power lines, while maneuvering during an aerial application flight.NTSB CHI01LA018Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · New Ulm, MNThe engine failure for undetermined reasons, the pilot not attaining proper runway alignment, and the misjudged flare by the pilot. A factor was the runway light.NTSB CHI01FA017Accident · 2 fatalField investigationFinal reportBeech 95-C55 · Homer, NEThe inadequate remedial action the flightcrew had during the stall recovery maneuver and the flight instructor's inadequate supervision. A factor was the intentional stall the flightcrew was performing.NTSB MIA01LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Jesup, GAA total failure of the wheel braking system due to the pilot's improper use of braking in downwind, downhill conditions, resulting in overheated brakes, and subsequent encounter with a downslope and terrain collision.NTSB FTW01LA011Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Littlefield, TXthe pilot's failure to maintain clearance with a guy wire while maneuvering during an aerial application flight.NTSB SEA01LA006Accident · No injuriesLimited investigationFinal reportCessna 185F · Driggs, IDThe pilot's failure to maintain directional control. Factors include soft terrain adjacent to the runway.NTSB MIA01LA007Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Dellwood, FLthe pilot's failure to clear the area, and his attempted takeoff while the helicopter's right skid was entangled with vines, which resulted in inadvertent dynamic rollover and substantial damage to the aircraft.NTSB MIA01FA006Accident · 1 fatalField investigationFinal reportAerospatiale AS-355-F2 · Burlington, NCThe mechanics failure to comply with manufacturers instructions for correction of a illuminated main rotor gearbox oil pressure warning light resulting in the helicopter being dispatched on a ferry flight with a failed main rotor gearbox oil pump, failure of…NTSB LAX01FA018Accident · No injuriesField investigationFinal reportBeech C90 · Van Nuys, CAThe failure of the pilot of the other airplane to correctly set a new transponder code and an anomaly in ATC software that precluded the controller from manually overriding the resulting inhibition of displayed data. Factors in the accident were impaired…NTSB IAD01WA005Accident · Serious injuriesForeign investigationCessna 414 · Kiel-Holtenau, GermanyNTSB CHI01MA011Accident · 3 fatalClass 1 · MajorFinal reportCessna 335 · Hillsboro, MOThe pilot's failure to control the airplane while maneuvering because of spatial disorientation. Contributing to the accident were the failure of the airplane's primary attitude indicator and the adverse weather conditions, including turbulence.NTSB CHI01IA016Incident · No injuriesIncident investigationFinal reportBoeing B-727-61 · Wood Dale, ILInadequate overhaul of the flap segment that allowed for corrosion and debonding that resulted in the flap segment departing the airplane during the approach. Factors relating to this incident were insufficient information provided to the overhaul facility by…NTSB NYC01LA015Accident · Serious injuriesLimited investigationFinal reportMoore Starduster SA-300 · Erwinna, PAA total loss of engine power during initial climb for undetermined reasons.NTSB NYC01LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Southborough, MAA failed connecting rod assembly, with the initiating event undetermined.NTSB LAX01FA014Accident · 2 fatalField investigationFinal reportBeech 35-33 · Monterey, CAThe pilot's inadequate in-flight planning/decision by which he conducted visual flight into instrument meteorological conditions and his failure to maintain control of the airplane. Contributing factors were low ceiling, spatial disorientation and lack of…NTSB IAD01LA004Accident · No injuriesLimited investigationFinal reportYakovlev 52 · Berryville, VAThe pilot's improper flare, which resulted in a hard landing and separation of the nose landing gear.NTSB DEN01LA004Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Jensen, UTan undershoot due to misjudging distance/altitude during an emergency landing. Factors were: inadequate preflight, failure to refuel, fuel exhaustion, operating with an inoperative fuel gauge, and failure to attain a proper glide path during approach.NTSB CHI01LA010Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Tecumseh, MIThe pilot was unable to rotate the aircraft during takeoff for undetermined reasons. A factor associated with the accident was the soft terrain, which the airplane encountered during the aborted takeoff.NTSB ATL01FA008Accident · 1 fatalField investigationFinal reportPiper PA-32RT · Selmer, TNThe pilots inadequate preflight planning and preparation, that resulted in exceeding the designed weight and balance of the airplane. Factors were the pilot's use of inappropriate medications and the collision with trees.NTSB ANC01LA008Accident · Minor injuriesLimited investigationFinal reportWeste Avid · Chugiak, AKA total loss of engine power due to a piston failure. Factors in the accident were an out-of-rig flight control system, an inadvertent stall, and no suitable terrain for a forced landing.NTSB ANC01IA007Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Anchorage, AKRupture and disintegration of main landing gear tires during the takeoff roll, and subsequent damage to the right main gear hydraulic brake system.NTSB NYC01LA018Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Ridgeway, VAThe pilot's failure to maintain proper runway alignment during the landing roll. A factor in this accident was a slight bend in the runway.NTSB NYC01LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Poughkeepsie, NYThe student pilot's improper recovery from a bounced landing.NTSB NYC01LA014Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Steubenville, OHThe pilot's failure to maintain directional control while landing with a crosswind. Factors in the accident were the pilot's lack of familiarity in the make and model airplane, and the crosswind conditions.NTSB MIA01LA005Accident · Serious injuriesLimited investigationFinal reportArthur P. Matthews Acro Sport II · Huntersville, NCthe pilot's misjudgment of the distance/speed and failure to attain the proper touchdown point or affect a timely go-around which resulted in the aircraft overrunning the runway and incurring substantial damage when it ran into a streambed.NTSB MIA01FA004Accident · 2 fatalField investigationFinal reportRobinson R-22 · Pembroke Pines, FLThe pilot's failure to maintain rotor rpm and the proper rate of descent during a forced landing/autorotation resulting in an in-flight collision with terrain. Contributing to the accident was a loss of engine power due to the failure of the No. 3 exhaust…NTSB LAX01LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sedona, AZThe pilot's inadequate compensation for wind conditions while on short final landing approach. A factor was the unfavorable wind condition.NTSB LAX01LA013Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Grand Canyon, AZThe pilot's in-flight loss of control during liftoff due to his improper planning and decisions. Related factors were the high density altitude and helicopter weight condition, and the lack of a suitable takeoff area.NTSB FTW01RA008Accident · 6 fatalForeign investigationCessna 320E · Ensenada, MexicoNTSB DEN01LA023Accident · No injuriesLimited investigationFinal reportCessna 310N · Montrose, COthe pilot's inadequate airspeed on final approach which resulted in a hard landing. A contributing factor was wind shear.NTSB CHI01LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Manhattan, KSthe inadequate soft field takeoff procedure by the pilot and his failure to abort the takeoff. Factors were the high grass on the runway, the pilots disregard for the runway conditions, his lack of total experience in the aircraft, the trees, and the pilots…NTSB ATL01LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Homer, GAThe loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.NTSB SEA01WA005Accident · 3 fatalForeign investigationPiper PA 24-250 · Kelowna, CanadaNTSB LAX01LA016Accident · No injuriesLimited investigationFinal reportAerospatiale AS350-BH · Hilo, HIInadequate maintenance by the helicopter manufacturer during manufacture, which installed skins of inadequate thickness on the tail boom. A factor in the accident was the failure of the manufacturer's quality control system to detect the inadequate thickness.NTSB LAX01FA011Accident · 1 fatalField investigationFinal reportNavion G · Henderson, NVthe pilot's failure to maintain an adequate airspeed while maneuvering to return to the runway following a loss of engine power in the takeoff initial climb. The loss of power was probably due to the pilot's failure to ensure that an adequate fuel supply…NTSB IAD01LA003Accident · Minor injuriesLimited investigationFinal reportPitts S-1A · Mount Pocono, PAPilot's inadequate compensation for wind conditions during landing. A factor was the crosswind.NTSB ATL01LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172-B · Palatka, FLThe CFI's inadequate preflight planning which resulted in fuel exhaustion and the subsequent loss of engine power.NTSB NYC01LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-601P · S. Burlington, VTThe pilot's improper in-flight decision to perform a precautionary landing, and his failure to maintain airspeed after he experienced a partial loss of power on one engine. A factor was the partial loss of power on one engine due to an induction air leak.NTSB LAX01LA012Accident · Minor injuriesLimited investigationFinal reportTolle Venture Model 20 · Madera, CAThe mechanical failure of a fuel sump tank check valve, during takeoff initial climb, that resulted in fuel starvation.NTSB LAX01LA010Accident · No injuriesLimited investigationFinal reportCessna 170B · San Carlos, CAThe pilot's improper and excessive application of brakes resulting from his failure to maintain directional control during landing rollout.NTSB FTW01LA009Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30 · Waller, TXthe loss of engine power during climb to cruise due to the failure of the crankshaft counterweight. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01FA003Accident · 1 fatalField investigationFinal reportBeech B19 · Umbarger, TXThe pilot's loss of control due to spatial disorientation. Contributing factors were the low ceilings, the dark night illumination, the lack of visual cues, and the pilot's lack of instrument flight qualification or experience.NTSB CHI01LA013Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Baraboo, WIthe failure of the number five intake valve spring during initial climbout and that there was no suitable terrain during the forced landing. A factor was the corn crop.NTSB CHI01LA009Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lansing, MIthe pilot's inaccurate preflight planning. Factors were the fuel exhaustion, the trees, and the bright night condition.NTSB ANC01LA010Accident · No injuriesLimited investigationFinal reportBeech BE-A36 · Nondalton, AKThe pilot's inadvertent retraction of the landing gear during the landing roll.