NTSB investigations
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 GAA24WA244AccidentClass 5 · ForeignViking DH 6 - 300 · Miriandhoo, Baa Atoll, MaldivesNTSB GAA24WA184Accident · No injuriesClass 5 · ForeignCessna 172 · Kagoshima, JapanNTSB GAA24WA183Accident · No injuriesClass 5 · ForeignRobinson R44 · Aioi City, JapanNTSB ENG24WA040Incident · No injuriesClass 4 · ForeignAirbus A320 · Grafendorf bei Hartberg, AustriaNTSB CEN24LA214Accident · Minor injuriesClass 4 · LimitedFinal reportStinson Vultee V-77 · Slaton, TXThe pilot’s failure to maintain directional control after landing in gusting wind conditions which resulted in a runway excursion and the airplane nosing over. Contributing was the pilot’s decision to conduct the flight in very strong, gusting wind conditions.NTSB WPR24LA189Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Italia S R L Alpha Trainer · Paso Robles, CAThe pilot’s exceedance of the airplane’s critical angle of attack that resulted in an aerodynamic stall and subsequent loss of control on final approach. Contributing to the accident was the pilot’s decision to land with a tailwind.NTSB WPR24LA188Accident · Serious injuriesClass 3 · LimitedFinal reportDavid Fisher Murphy Moose · Ocean Shores, WAThe pilot’s hard, bounced landing, subsequent failure to maintain adequate airspeed, and his exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR24LA186Accident · No injuriesClass 4 · LimitedFinal reportGrumman/Schweizer G-164D · Richvale, CAThe pilot’s decision to take off with a tailwind and their failure to maintain clearance from terrain.NTSB WPR24FA185Accident · 1 fatalClass 3 · FieldFinal reportRans S-12XL Airaile · Picacho Peak, AZThe pilot’s decision to conduct a low-altitude flight in mountainous terrain and his subsequent loss of airplane control after encountering mechanical turbulence, which resulted in an impact with the terrain.NTSB GAA24WA190Accident · Minor injuriesClass 5 · ForeignCessna 152 · Juquitiba, BrazilNTSB ERA24LA280Accident · No injuriesClass 4 · LimitedFinal reportLancair LC42-550FG · Beaufort, NCThe pilot's failure to attain a proper touchdown point during landing, which resulted in a runway overrun.NTSB ERA24LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Zephyrhills, FLA partial loss of engine power during initial climb due to fuel contamination that resulted from corrosion and loose corrosion debris in the carburetor, which restricted fuel flow to the engine.NTSB ERA24LA256Accident · Minor injuriesClass 3 · LimitedFinal reportZenith 701 · Ocala, FLThe pilot’s failure to maintain aircraft control and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin during an attempted go-around.NTSB ERA24LA255Accident · Minor injuriesClass 3 · LimitedFinal reportTitan T51 · Madisonville, TNThe failure of the right main landing gear weldment due to fatigue cracking.NTSB ERA24LA254Accident · Minor injuriesClass 3 · LimitedFinal reportNorth American Navion · Tullahoma, TNA total loss of engine power during takeoff as a result of fuel starvation.NTSB ERA24LA253Accident · No injuriesClass 4 · LimitedFinal reportDavis Lightning · Jamestown, TNThe non-certificated pilot’s failure to maintain control of the airplane during landing, which resulted in an aerodynamic stall and subsequent hard landing.NTSB ERA24LA252Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182 · Telford, TNThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an inflight collision with trees.NTSB ERA24LA251Accident · Minor injuriesClass 4 · LimitedFinal reportWilliam Loren Noggle JA30 Superstol · Tennille, GAThe loss of elevator control during flight due to the elevator control rod and its hardware disconnecting from its installation area, which resulted in an uncontrolled descent into trees and terrain. Contributing to the accident was the pilot’s inadequate…NTSB ENG25WA006IncidentClass 5 · ForeignDe Havilland DHC6 · Kikori, Papua New GuineaNTSB CEN24LA219Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-23H-15 · Chouteau, OKThe student pilot’s failure to maintain control of the glider while landing. Contributing to the accident was the unclear communications between the student pilot and instructor.NTSB ANC24LA046Accident · No injuriesClass 4 · LimitedFinal reportCessna 206 · Fairbanks, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions.NTSB WPR24LA187Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Garrett, WYThe pilot’s failure to maintain clearance from terrain while conducting low-level altitude operations, following an encounter with wake turbulence.NTSB WPR24FA184Accident · 1 fatalClass 3 · FieldFinal reportBeech A45 · Deer Harbor, WAThe pilot’s decision to perform an aerobatic maneuver at low level, and his misjudged entry altitude for the maneuver, which resulted in impact with water.NTSB GAA24WA186Accident · 2 fatalClass 5 · ForeignPiper PA46 · Sorriso, BrazilNTSB ERA24LA250Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Vero Beach, FLExcessive side loading of the vertical stabilizer.NTSB CEN24LA213Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Shuteston, LAThe pilot failure to maintain directional control while landing on a wet grass strip.NTSB CEN24FA212Accident · 1 fatalClass 3 · FieldFinal reportBeech V35A · Arvada, COA total loss of engine power due to oil starvation as a result of loose turbocharger oil line fittings.NTSB ANC24LA045Accident · No injuriesClass 3 · LimitedFinal reportCessna 206 · King Salmon, AKA partial loss of engine power due to detonation/preignition of the No. 1 cylinder for reasons that could not be determined.NTSB WPR24LA183Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Maricopa, AZThe flight instructor’s unstabilized approach during an autorotation that resulted in hard landing.NTSB WPR24FA182Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Auburn, WAThe pilot’s improper installation of the control stick pushrod assemblies, which resulted in separation of the left pushrod and a total loss of roll control during flight. Contributing to the accident was the failure to detect the installation error during…NTSB CEN24LA216Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402 · Perryton, TXThe pilot’s exceedance of the airplane’s critical angle of attack during a low-level turn, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB ANC24LA047Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Nenana, AKThe pilot providing instruction’s delayed remedial action, resulting in a loss of control during landing roll.NTSB WPR24LA181Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172P · Santa Ynez, CAThe pilot’s failure to maintain airspeed which resulted in exceedance of the critical angle of attack and an aerodynamic stall/spin, with insufficient altitude for recovery. The student pilot’s exceedance of the critical angle of attack which resulted in a…NTSB WPR24LA180Accident · No injuriesClass 4 · LimitedFinal reportRepublic RC-3 · Butte, MTThe pilot’s failure to maintain control of the airplane during the takeoff with a gusty left quartering crosswind.NTSB ERA24LA248Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-25-235 · Colquitt, GAThe failure of the fuel shutoff valve from corrosion, which allowed the valve stem to obstruct the internal fuel port, resulting in a restriction of fuel flow to the engine.NTSB ERA24LA247Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Southampton Township, NJThe flight instructor’s failure to maintain control of the airplane during a low approach and subsequent go-around in turbulent wind conditions.NTSB CEN24LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Gypsum, COThe failure of the flight instructor and the pilot to visually confirm the airplane’s fuel quantity during preflight, which resulted in a loss of engine power due to fuel exhaustion and an off-airport forced landing in rough terrain.NTSB WPR24LA175Accident · Minor injuriesClass 4 · LimitedFinal reportDennis T Kirby/Michael B Kirby Murphy Rebel · Edgewood, NMThe pilot’s improper installation of the aileron and flap control systems, which resulted in a loss of directional control during the takeoff roll and subsequent runway excursion.NTSB DCA24WA201Incident · No injuriesClass 3 · ForeignBoeing 777FZB · Narita, JapanNTSB WPR24LA173Accident · No injuriesClass 4 · LimitedFinal reportSikorsky S-55QT · Benton City, WAThe pilot’s failure to maintain clearance from power lines during a low altitude operation.NTSB GAA24WA214Accident · 2 fatalClass 5 · ForeignBeech 55 · Santa Catarina, BrazilNTSB ERA24LA241Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Terryville, CTA total loss of engine power for undetermined reasons.NTSB ANC24LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 207A · Bethel, AKThe pilot’s improper short-field takeoff procedure, which resulted in an aerodynamic stall and subsequent hard landing.NTSB WPR24LA167Accident · Minor injuriesClass 4 · LimitedFinal reportCanadian Car & Foundry Harvard MK IV · Modesto, CAThe pilot’s improper fuel tank selection, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was a malfunctioning fuel selector at low fuel levels.NTSB ERA24LA291Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Benton, NHAn encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in collision with trees.NTSB ERA24LA243Accident · Minor injuriesClass 4 · LimitedFinal reportEide Turner T-40A · Middleburg, FLThe pilot’s loss of control during climb out, which resulted in a collision with a tree.NTSB ERA24LA236Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Gilbertsville, KYThe pilot's failure to maintain control of the helicopter while attempting to take off from sloping terrain.NTSB DCA24WA282IncidentClass 5 · ForeignMcdonnell Douglas MD 83 · Santa Clara, CubaNTSB CEN24LA209Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 90A · Hebron, INThe pilot’s failure to maintain clearance from powerlines while landing in a field.NTSB ANC24LA051Accident · No injuriesClass 4 · LimitedFinal reportMorgan Edward L Edge X 582 · Fairbanks, AKThe pilot’s selection of an unsuitable landing site, resulting in a collision with a hole during landing rollout.