NTSB investigations
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 DCA24WA306Accident · Serious injuriesClass 3 · ForeignATR ATR42 · Serui, IndonesiaNTSB WPR24LA305Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20F · Cottonwood, AZThe pilot’s evasive maneuver to avoid birds while on final approach at a low altitude, which resulted in the airplane colliding with a tree.NTSB ERA24LA376Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Raleigh, NCDamage to the landing gear selector switch wire bundle which resulted in an inadvertent retraction of the landing gear during the takeoff roll.NTSB ERA24FA371Accident · 4 fatalClass 3 · FieldFinal reportPiper PA28R · Vergennes, VTThe flight instructor’s failure to maintain control of the airplane, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall. Contributing to the accident was the flight instructor's failure to properly…NTSB ENG24WA033IncidentClass 5 · ForeignAirbus A321 · La Paz, MexicoNTSB CEN24LA344Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCAA · Rifle, COA total loss of engine power for undetermined reasons.NTSB GAA24WA293Accident · 2 fatalClass 5 · ForeignCessna 172 · Soest, GermanyNTSB GAA24WA281Accident · 2 fatalClass 5 · ForeignCessna 172 · Soest, GermanyNTSB GAA24WA280Accident · 1 fatalClass 5 · ForeignGreat Lakes 2T-1A-2 · Gütersloh, GermanyNTSB ERA24LA373Accident · Minor injuriesClass 4 · LimitedFinal reportRaytheon 58 · Griffin, GAThe pilot’s failure to conduct a timely aborted landing, which resulted in a runway overrun.NTSB CEN24LA345Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Grand Island, NEThe pilot’s inadequate preflight planning/preparation that resulted in fuel exhaustion during cruise flight, a total loss of engine power, and an impact with terrain during a forced landing.NTSB CEN24LA341Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-D · Trojan, SDThe partial loss of engine power due to a loose magneto and subsequent impact with terrain.NTSB ANC24FA089Accident · 1 fatalClass 3 · FieldFinal reportBell 206B · King Salmon, AKThe pilot’s decision to initiate the visual flight into instrument meteorological conditions, which resulted in his spatial disorientation, failure to maintain helicopter control and subsequent impact with water.NTSB WPR24LA302Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORThe operator’s failure to maintain separation between two drones during dual simulated engine out recoveries, which resulted in a midair collision.NTSB WPR24FA298Accident · 1 fatalClass 3 · FieldFinal reportBoeing A75L3 · Yacolt, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude in mountainous terrain in moderately high density altitude conditions, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB WPR24FA295Accident · Serious injuriesClass 3 · FieldPreliminary reportPiper PA-24-250 · Hawthorne, CAOn September 6, 2024, at 0036 Pacific daylight time, a Piper PA-24-250, N588CP, was destroyed when it was involved in an accident near Hawthorne, California. The pilot and pilot rated passenger sustained serious injuries. The airplane was operated as a Title…NTSB ERA24LA377Accident · No injuriesClass 4 · LimitedFinal reportMooney M20 · Oxford, CTThe seizure of the right main landing gear extension rod bearing and subsequent buckling of the rod, resulting in a landing gear collapse.NTSB DCA24WA297AccidentClass 5 · ForeignBoeing 787-9 · Guangzhou, ChinaNTSB CEN24LA343Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Grand Forks, NDThe student pilot’s failure to maintain helicopter control which resulted in impact with the ground. Contributing to the outcome was the flight instructor’s delayed remedial action.NTSB CEN24FA340Accident · 4 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Anderson, INThe pilot’s inadequate airspeed management during the missed approach which resulted in an inadvertent aerodynamic stall and loss of control at low altitude.NTSB CEN24LA342Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R · Crystal, MNThe failure of the engine mount under normal operating loads due to the fracture of a vertical tube that was weakened by corrosion and fatigue of the internal surfaces.NTSB CEN24LA339Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Borger, TXThe pilot’s inadequate fuel management which led to fuel exhaustion.NTSB CEN24FA338Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Camden, COThe pilot’s failure to maintain adequate clearance from a power transformer that was mounted to a power pole during an aerial application flight.NTSB ERA24LA372Accident · No injuriesClass 4 · LimitedFinal reportTextron 208B · New York, NYThe pilot’s improper decision to rush his departure, which resulted in a rough water encounter and collision with the wake of a passing ferry boat.NTSB ERA24LA369Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Somerville, NJA total loss of engine power due to an undetermined fuel delivery issue.NTSB ERA24FA365Accident · 2 fatalClass 3 · FieldFinal reportGrumman American Avn. AA-5 · Rockmart, GAA total loss of engine power for undetermined reasons. Also causal was the flight instructor’s failure to maintain adequate airspeed during the forced landing attempt, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic…NTSB DCA24WA298Accident · Serious injuriesClass 5 · ForeignBoeing 787 · Tokyo, JapanNTSB ANC24LA090Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Denali, AKFailure to maintain clearance from terrain due to the airplane’s encounter with windshear during takeoff.NTSB WPR24LA306Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Yuma, AZThe flight instructor’s failure to maintain clearance from a fence during taxi operations.NTSB WPR24LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Amboy, CAThe pilot's failure to maintain clearance from a street sign during takeoff from a road.NTSB ENG24WA032IncidentClass 5 · ForeignAirbus A350 · Hong Kong, Hong Kong SAR ChinaNTSB CEN24LA337Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · East Troy, WIThe pilot/mechanic’s improper torquing of the fuel hose fitting while replacing the fuel pump, which allowed air to enter the fuel system and resulted in a loss of engine power during initial climb. Contributing to the accident was the pilot/mechanic’s…NTSB CEN24LA333Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac CH601 XL · Odessa, MOOverheating of the engine coolant for reasons that could not be determined, which resulted in a precautionary off-airport landing, during which the airplane sustained substantial damage.NTSB CEN24LA332Accident · 1 fatalClass 3 · LimitedFinal reportApex CROSS-5X · Columbus, NEThe non-certificated pilot’s failure to maintain control of the aircraft after takeoff.NTSB WPR24LA301Accident · No injuriesClass 4 · LimitedFinal reportThompson Ryan L Thompson Craft · Port Angeles, WAThe pilot’s failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB WPR24LA297Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Saint Johns, AZThe pilot’s improper landing flare that resulted in a hard landing.NTSB WPR24FA291Accident · 1 fatalClass 3 · FieldFinal reportAmerican Champion 8GCBC · Meeteetse, WYThe pilot’s decision to continue the flight over rising terrain at a low altitude in a high-elevation, high-density-altitude environment.NTSB GAA25WA020IncidentClass 5 · ForeignCessna U206F · Moora, AustraliaNTSB ERA24LA367Accident · Serious injuriesClass 4 · LimitedFinal reportRedfield Thomas C RV-6A · Trinity, VAThe pilots’ improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN24LA357Accident · No injuriesClass 3 · LimitedFinal reportDiamond DA42 · Mandan, NDThe pilot’s failure to perform a go-around following an unstable approach while landing with a tailwind, which resulted in the airplane touching down long on the runway with insufficient distance to stop. Contributing to the accident was the pilot’s selected…NTSB CEN24LA334Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Shell Knob, MOThe pilot’s failure to maintain aircraft control and airspeed during final approach, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN24LA331Accident · No injuriesClass 4 · LimitedFinal reportLet L 33 Solo · Kingman, KSThe pilot’s loss of control on short final.NTSB ANC24LA088Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB WPR24LA300Accident · No injuriesClass 4 · LimitedFinal reportPacific Aerospace 750XL · Mulino, ORThe skydiver’s unintentional parachute deployment and subsequent entanglement with the airplane’s horizontal stabilizer.NTSB WPR24FA290Accident · 1 fatalClass 3 · FieldFinal reportAero Commander 200D · Novato, CAThe pilot’s failure to abort takeoff or compensate for gusty crosswind conditions during takeoff, which resulted in a loss of control and subsequent runway excursion.NTSB WPR24FA289Accident · 3 fatalClass 3 · FieldPreliminary reportCessna 421C · Fairview, OROn August 31, 2024, about 1030 Pacific daylight time, a Cessna 421C, N421GP was destroyed when it was involved in an accident near Fairview, Oregon. The two pilots and one person on the ground were fatally injured. The airplane was operated as a Title 14 Code…NTSB GAA24WA274Accident · 1 fatalClass 5 · ForeignPiper 38 · Córdoba, SpainNTSB DCA24LA295Accident · No injuriesClass 4 · LimitedFinal reportAirbus A330-323 · Atlanta, GADelta Air Lines flight crew’s incorrect evaluation of the clearance between their airplane and the airplane directly ahead of them as they made a 90 degree right turn onto an adjacent taxiway.NTSB CEN24LA336AccidentClass 4 · LimitedFinal reportCessna 182D · Coopersville, MIThe loss of airplane control while landing.NTSB CEN24LA335Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Lawrence, KSThe pilot’s failure to maintain directional control during takeoff.