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 DCA24WA333Incident · No injuriesClass 3 · ForeignATR ATR72 · Bhubaneswar, IndiaNTSB DCA24WA260IncidentClass 4 · ForeignBoeing 767-322 · Geneva, SwitzerlandNTSB CEN24LA324Accident · No injuriesClass 4 · LimitedFinal reportRans RV8 · Morris, ILThe student pilot’s failure to maintain directional control and the flight instructors delayed remedial action while landing with a gusty crosswind.NTSB WPR24LA283Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Fallbrook, CAThe pilot’s failure to maintain clearance from an obstacle during taxi operations.NTSB WPR24LA275Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Concord, CAThe failure of the main landing gear to extend and lock for reasons that could not be determined based on the available information. Contributing to the accident was a mechanical failure of the manual landing gear release mechanism due to inadequate clearance…NTSB WPR24LA274Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Minden, NVThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight and a subsequent collision with an obstacle during an off-field landing.NTSB GAA24WA277Incident · No injuriesClass 5 · ForeignCirrus SR22 · Dubai, United Arab EmiratesNTSB GAA24WA260Accident · 1 fatalClass 5 · ForeignCessna 152 · Santa Fe, ArgentinaNTSB GAA24WA254AccidentClass 5 · ForeignCessna P210 · Bartošovice village, CzechiaNTSB GAA24WA252Accident · 1 fatalClass 5 · ForeignCessna 337 · Deer Lake, CanadaNTSB GAA24WA251Accident · 7 fatalClass 5 · ForeignPiper PA31 · Cerro Castillo, ChileNTSB DCA24WA265OccurrenceClass 5 · ForeignCanadair CL600 · Montreal, CanadaNTSB CEN24LA313Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Dyess, ARThe improper overhaul of the carburetor and the malfunction of left magneto which resulted in a partial loss of engine power.NTSB WPR24LA272Accident · Minor injuriesClass 4 · LimitedFinal reportRenquist George GS-2 Sportsman · Hawthorne, CAThe flight crew’s failure to maintain airspeed during a short field landing and the instructor’s delayed remediation, which resulted in a hard landing.NTSB WPR24FA270Accident · 3 fatalClass 3 · FieldFinal reportCessna 182K · Augusta, MTThe non-instrument-rated pilot’s decision to continue a visual flight rules flight into a rugged mountain area in deteriorating weather conditions, which resulted in impact with terrain.NTSB DCA24LA255Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Waycross, GAThe aircraft’s encounter with convectively induced turbulence.NTSB ANC24LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fairbanks, AKThe pilot's failure to maintain directional control while landing at a short remote airstrip.NTSB GAA24WA259Accident · 1 fatalClass 5 · ForeignCessna 182 · Provincia de Neuquén, ArgentinaNTSB GAA24WA247Accident · 5 fatalClass 5 · ForeignAirbus Helicopters AS350 · NepalNTSB ERA24LA341Accident · No injuriesClass 3 · LimitedFinal reportBeech 23 · Jacksonville, FLThe pilot’s improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation while on final approach to land, and the subsequent hard landing, which resulted in separation of the airplane’s landing gear.NTSB DCA24WA270IncidentClass 5 · ForeignAirbus A320 · Purani, RomaniaNTSB DCA24LA256Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Severn, MDA passenger’s failure to comply with crew member instructions to remain seated with seatbelt fastened.NTSB CEN24LA380Accident · Serious injuriesClass 3 · LimitedFinal reportXag P100 PRO · Francesville, INThe remote pilot’s in-flight loss of control of the unmanned aircraft due to GPS signal fluctuations, which resulted in a collision with, and serious injury to, a person assisting the operation.NTSB CEN24FA312Accident · 1 fatalClass 3 · FieldFinal reportEngineering & Research Ercoupe 415-C · Elkhart, ILAn off-airport landing in a soybean field for reasons that could not be determined. Contributing to the severity of the pilot’s injuries and airplane damage was a fire that occurred at an unknown time.NTSB ANC24LA076Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 · Skwentna, AKThe pilot's failure to maintain directional control during the landing roll.NTSB WPR24LA276Accident · No injuriesClass 4 · LimitedFinal reportMaule M4 · Scappoose, ORThe pilot’s loss of directional control after an encounter with a wind gust.NTSB ERA24LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Medina, OHThe student pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun and subsequent noseover.NTSB DCA24WA263OccurrenceClass 5 · ForeignCanadair CL600 · Vancouver, CanadaNTSB CEN24LA310Accident · No injuriesClass 4 · LimitedFinal reportBeech E-55 · Crystal, MNThe pilot’s improper landing flare which resulted in a hard landing.NTSB CEN24LA309Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Salem, INThe pilot’s excessive airspeed during a landing, which resulted in a runway overrun and collision with terrain.NTSB CEN24LA307Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Kalamazoo, MIThe pilot’s failure to extend the landing gear before landing.NTSB CEN24FA305Accident · 1 fatalClass 3 · FieldFinal reportCessna 172F · Brazoria, TXThe pilot’s failure to attain adequate airspeed for takeoff, which led to the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident was the pilot’s failure to abort the takeoff after not maintaining directional…NTSB CEN24FA304Accident · 4 fatalClass 3 · FieldPreliminary reportBeech F33 · Oklahoma City, OKOn August 6, 2024, about 1326 central daylight time, a Beechcraft F33A airplane, N8095U, was destroyed when it was involved in an accident near Oklahoma City, Oklahoma. The private pilot and the three passengers sustained fatal injuries. The airplane was…NTSB WPR24LA268Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-34-220T · Minden, NVThe pilot’s improper preflight inspection of the stabilator trim position, which resulted in a porpoised landing. Contributing to the accident was the maintenance personnel’s improper maintenance of the stabilator trim shaft.NTSB ERA24FA338Accident · Serious injuriesClass 3 · FieldFinal reportCessna 750 · Jamestown, NYAn in-flight fire and electrical failure for reasons that could not be determined, which resulted in the flight crew’s inability to maintain stabilized flight and a subsequent loss of control during landing.NTSB DCA24WA259AccidentClass 5 · ForeignBoeing 737 · Nuremburg, GermanyNTSB ANC24LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA31 · Fairbanks, AKThe pilot's continuation of an unstabilized approach and his failure to monitor the aircraft's altitude and airspeed during the approach, resulting in a loss of control.NTSB WPR24LA267Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-201T · Sacramento, CAA loss of engine power during the initial climb due to the detachment of the turbocharger’s inlet sleeve as a result of the installation of an incorrect sleeve clamp.NTSB GAA24WA242AccidentClass 4 · ForeignCessna 150 · Argerich, ArgentinaNTSB GAA24WA240AccidentClass 5 · ForeignBRM Aero Sro Bristell S-LSA · Aboco, BahamasNTSB ENG24WA030OccurrenceClass 5 · ForeignBoeing 737-700 · Kigali, RwandaNTSB DCA24LA254Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Linneus, MOAn inadvertent encounter with convectively induced turbulence during cruise.NTSB CEN24FA298Accident · 1 fatalClass 3 · FieldFinal reportDeGraw DeBird · Napoleon, MISeparation of the gyroplane’s tail due to main rotor blade contact for reasons that could not be determined.NTSB WPR24LA269Accident · No injuriesClass 3 · LimitedFinal reportProtech PT2 · Lodi, CAA reported loss of engine power for reasons that could not be determined.NTSB WPR24LA265Accident · Minor injuriesClass 3 · LimitedFinal reportBell 407 · Raft River, IDThe pilot’s misdiagnosis of an erroneous engine instrument indication and his subsequent decision to enter an autorotation, which resulted in a hard landing due to degraded visual cues and low ambient light conditions. Contributing to the accident were the…NTSB GAA24WA250Accident · 3 fatalClass 5 · ForeignBeech 95A55 · Birigui, BrazilNTSB GAA24WA246Accident · 1 fatalClass 5 · ForeignZodiac CH601XL · Tambon Khok Kham, ThailandNTSB ERA24LA335Accident · Serious injuriesClass 3 · LimitedFinal reportHendrickson Glasair 3 · Oxford, MEA loss of engine power for reasons that could not be determined.NTSB CEN24LA308Incident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Tulsa, OKThe mechanic’s improper installation of the alternator wiring connections, which resulted in electrical arcing and thermal damage to the airplane.NTSB CEN24LA303Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Bryant, IAA loss of engine power during takeoff for reasons that could not be determined, resulting in impact with terrain.