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 FTW02IA061Incident · No injuriesIncident investigationFinal reportBoeing 747-228F · Houston, TXStress corrosion cracking (SCC) of the aft trunnion outer cylinder. A factor was the inadequate inspection criteria of the Airworthiness Directive to detect pre-existing SCC.NTSB CHI02LA057Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lake Leelanau, MIThe improper planning/decision in runway selection. The soft runway condition and wet snow were contributing factors.NTSB ATL02LA029Accident · No injuriesLimited investigationFinal reportBoeing 727-200 · Greenville, SCThe tug driver's failure to maintain control of the airplane during pushback resulting in the tug colliding with the airplane. A factor was ice on the ramp.NTSB SEA02FA023Accident · No injuriesField investigationFinal reportBeech 58P · Boise, IDImproper clearance between an alternator wire and a pneumatic line and fuel fumes. The alternator wire chafe and arcing were factors.NTSB NYC02LA046Accident · No injuriesLimited investigationFinal reportLet L-23 · Sterling, MAThe student pilots inadequate compensation for wind conditions which resulted in an off-field landing, and the CFI's improper decision to allow the student to fly solo. Factors related to the accident were the gusting wind conditions, and the students lack of…NTSB MIA02IA047Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Miami, FLThe failure of the first officer to fly a stabilized approach at the correct airspeed and his failure to execute a missed approach resulting in touchdown about 5,000 feet past the runway threshold at an excessive airspeed and over run of the runway prior to…NTSB MIA02FA048Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hollywood, FLThe pilot's inadequate planning for a Title 14 CFR Part 135 on-demand air taxi flight, and his failure to refuel the airplane, which resulted in fuel exhaustion while en route over the Atlantic Ocean, a power off glide, and ditching in the ocean.NTSB NYC02LA045Accident · No injuriesLimited investigationFinal reportCessna 182 · Danbury, CTThe student pilot's improper flare and recovery from a bounced landing.NTSB NYC02FA044Accident · 1 fatalField investigationFinal reportRaytheon BE-23-B24R · Armonk, NYThe pilot's failure to maintain aircraft control.NTSB IAD02LA023Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Martinsville, VAThe pilot's premature rotation and his failure to maintain directional control during the takeoff roll.NTSB IAD02LA022Accident · No injuriesLimited investigationFinal reportCessna 310H · Tappahannock, VAThe pilot's inadequate compensation for the gusty wind conditions. Factors in the accident were the gusty wind conditions and the total loss of left engine power due to the alternate air valve becoming disconnected and embedded in the fuel injector servo.NTSB IAD02FA024Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Milford, CTThe pilot's failure to follow the published IFR approach procedure, which resulted in a premature descent and subsequent impact with water. A factor was the night, overwater visual conditions.NTSB SEA02LA029Accident · No injuriesLimited investigationFinal reportPilatus PC-12 · Sunriver, ORThe pilot's failure to maintain directional control during the landing roll. An icy runway and a snow bank were factors.NTSB SEA02LA021Accident · No injuriesLimited investigationFinal reportKing Kitfox IV · Ashland, ORThe pilot's excessive use of brakes. A factor was the pilot's lack of recent experience in type of aircraft.NTSB LAX02LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Long Beach, CAThe student pilot's inadequate compensation for wind, and his failure to maintain directional control of the aircraft during the landing roll.NTSB ATL02LA028Accident · Minor injuriesLimited investigationFinal reportPioneer 85 · Lajas, PRThe pilot's decision to attempt a go-around after a hard landing that resulted in the overload failure of the flight control brackets and the loss of flight control. The airplane collided with a building during the attempted go-around.NTSB ATL02LA027Accident · No injuriesLimited investigationFinal reportFlugzeugbau DG-200 · Benton, TNThe pilot's inadvertent encounter with a downdraft while maneuvering in a ridge lift during a turn resulting in an in-flight collision with trees.NTSB ATL02FA026Accident · 1 fatalField investigationFinal reportMooney M20C · Gainesville, GAThe loss of engine power due to fuel starvation, resulting from fuel system blockage and improper maintenance by maintenance personnel. A factor was the unsuitable terrain.NTSB ATL02FA025Accident · 1 fatalField investigationFinal reportCessna C-210N · Lilburn, GAThe pilot's failure to maintain aircraft control.NTSB CHI02IA058Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Chicago, ILThe wake turbulence encounter.NTSB CHI02FA059Accident · 2 fatalField investigationFinal reportBorgman Smyth Sidewinder · Independence, KSThe pilot's failure to maintain control of the airplane and the subsequent inadvertant stall during the base to final turn. A factor associated with the accident was that an unqualified person was piloting the airplane.NTSB ATL02LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Trenton, FLThe pilot's improper in-flight decision to make a precautionary landing after sustaining a total loss of electrical power with sufficient fuel remaining to reach his destination airport. This resulted in an off field landing to an off site location in a…NTSB ANC02LA008Accident · No injuriesLimited investigationFinal reportBoeing 747-128 · Anchorage, AKThe flight crew's inadequate preflight planning, and failure to calculate the airplane weight and balance prior to departure.NTSB NYC02LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Falmouth, KYThe pilot's continued flight into known adverse weather. A factor was the snow.NTSB FTW02TA060Accident · No injuriesFinal reportBell OH-58A · El Paso, TXThe loss of engine power for an undetermined reason, which resulted in a forced landing. A contributing factor was the moving ground vehicle.NTSB DEN02GA016Accident · 3 fatalFinal reportHughes 369E · Park City, UTthe pilot's inadequate visual lookout, resulting in an inflight collision with powerlines. Contributing factors were the fog and the powerlines.NTSB ATL02LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Kennesaw, GAThe pilot's improper in-flight planning/decision resulting in a total loss of engine power due to fuel exhaustion,which resulted in a forced landing, and subsequent in-flight collision with transmission wires.NTSB LAX02LA058Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Winters, CAThe failure of the pilot to retard the engine throttle to idle while hand-propping the engine, which resulted in the engine starting at full (takeoff) power and the airplane taking off with no one aboard.NTSB LAX02LA055Accident · No injuriesLimited investigationFinal reportCessna T210M · Santa Rosa, CAThe pilot's inadequate preflight and in-flight planning/decision resulting in miscalculation of fuel consumption, fuel exhaustion and loss of engine power. Factors were rough terrain in a vineyard, power lines in the landing area, and night time.NTSB LAX02FA056Accident · 2 fatalField investigationFinal reportCessna 172N · San Clemente, CAa loss of engine power due to a loss of magneto to engine timing resulting from stress corrosion crack induced fracture, and separation of the magneto impulse coupling spring.NTSB CHI02LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Olathe, KSThe pilot's failure to maintain directional control during landing resulting in the overload of the nose gear fork. The overload failure of the nose landing gear fork, the embankment, and the remedial action not possible were contributing factors.NTSB LAX02LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Prescott, AZThe pilot's inadequate removal of snow and ice from the surfaces of the airplane before takeoff.NTSB WAS02WA014Accident · 3 fatalForeign investigationCessna 337D · Piura, PeruNTSB ATL02WA022Accident · No injuriesForeign investigationCessna C205 · Bimini, BahamasNTSB NYC02LA042Accident · Serious injuriesLimited investigationFinal reportRaytheon BE-1900D · Boston, MAThe passengers misjudged step, which resulted in a loss of balance and subsequent fall.NTSB IAD02LA021Accident · No injuriesLimited investigationFinal reportCessna 208B · Lewiston, METhe pilot's failure to adequately ensure the wings were free of contamination prior to departure. Factors included the operator's inadequate de-icing procedures and the snowy weather conditions.NTSB CHI02LA055Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Elkhart, INThe pilot allowed the airplane's altitude to get too low while on final approach. A factor associated with the accident was the pickup truck which the airplane struck.NTSB ATL02TA021Accident · No injuriesFinal reportBell 206 · Awendaw, SCThe pilot's failure to maintain clearance from the bambi bucket suspension assembly during dip operation.NTSB ATL02LA019Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Vero Beach, FLThe pilot's inadequate preflight fuel requirements for the flight, resulting in fuel exhaustion and the subsequent loss of engine power.NTSB LAX02LA057Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Show Low, AZThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Contributing factors were a crosswind and wind gusts.NTSB LAX02LA053Accident · No injuriesLimited investigationFinal reportCessna T210N · San Diego, CAThe pilot's failure to land on the runway with sufficient runway remaining as a result of his improper IFR procedure by his failure to maintain visual contact with the runway environment, and to execute a missed approach.NTSB ATL02WA020Accident · 2 fatalForeign investigationCessna CE-560 · Zurich, SwitzerlandNTSB MIA02LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172M · New Smyrna Bch, FLthe failure of the pilot to maintain airspeed, during initial climb out, which resulted in an inadvertent stall, and subsequent impact with the terrain.NTSB ATL02LA018Accident · No injuriesLimited investigationFinal reportPitts S-1S · Sanford, FLThe pilot's failure to maintain control of the airplane during landing roll in a tailwind, which resulted in a nose-over on the runway.NTSB WAS02WA012Accident · Serious injuriesForeign investigationBell 412EP · Rio Frio, MexicoNTSB LAX02LA052Accident · No injuriesLimited investigationFinal reportCessna 185F · Reno, NVWear on the tail wheel thrust plate spacers resulted in the compression springs binding on the thrust plates and the tail wheel sticking, so that the pilot could not maintain directional control.NTSB FTW02LA059Accident · Serious injuriesLimited investigationFinal reportCameron Balloons Z-90 · Mcintosh, NMinadvertent flight into adverse (high wind) weather conditions, which resulted in a hard landing. A contributing factor was the high wind weather condition.NTSB DEN02LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Crested Butte, COa wet brake that later froze resulting in a loss of directional control on landing. A contributing factor was the snow bank.NTSB CHI02LA054Accident · No injuriesLimited investigationFinal reportCessna 182K · Nashville, MIthe pilot exceeding the proper touchdown point on the runway during the landing and his improper in-flight planning and decision. Factors relating to the accident were the pilot misjudging his speed and distance during the landing and the ditch.NTSB NYC02LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Cross Keys, NJThe pilot's delayed decision to abort the landing.