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 DCA26WA118Incident · No injuriesClass 5 · ForeignAirbus A320 · Dublin, IrelandNTSB DCA24WA186Accident · Serious injuriesClass 4 · ForeignBoeing 787 · Tbd, TürkiyeNTSB CEN24LA198Accident · No injuriesClass 4 · LimitedFinal reportBrant T Phillips Super Cub EXP · Franktown, COThe pilot’s failure to maintain aircraft control during final approach and attempted go-around after encountering a sudden windshear.NTSB WPR24LA163Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Livermore, CAThe flight instructor’s delayed remedial action, which resulted in an aerodynamic stall and abnormal contact with the runway. Contributing to the accident was the student pilot’s improper landing flare and go-around.NTSB GAA24WA321Accident · No injuriesClass 5 · ForeignCessna TR-182 · Trieben, AustriaNTSB GAA24WA182Accident · 2 fatalClass 5 · ForeignMurphy Rebel · Squamish, CanadaNTSB GAA24WA177AccidentClass 5 · ForeignCessna 310 · Tegucigalpa, HondurasNTSB GAA24WA175Accident · 1 fatalClass 5 · ForeignCessna 182 · Kerestinec, CroatiaNTSB ERA24LA228Accident · Serious injuriesClass 3 · LimitedFinal reportSchleicher ASH 31 MI · Winter Haven, FLThe pilot’s failure to ensure that a suitable landing area was available in case the restart of the motor glider’s engine was unsuccessful. Contributing, was insufficient battery charge to extend the motor glider’s pylon assembly.NTSB ENG24WA018IncidentClass 5 · ForeignBoeing 737 · Ciudad Juarez, MexicoNTSB DCA24LA206Incident · No injuriesClass 3 · LimitedPreliminary reportBoeing 737-8 · Oakland, CAOn May 25, 2024, about 0744 Pacific daylight time, Southwest Airlines (SWA) flight 746, a Boeing 737-8, N8825Q, experienced a rudder control system anomaly while operating as a Title 14 Code of Federal Regulations Part 121 scheduled domestic passenger flight…NTSB CEN24LA203Accident · No injuriesClass 3 · LimitedFinal reportPulsar Super Pulsar · Rochelle, ILA partial loss of engine power for undetermined reasons.NTSB CEN24LA197Accident · Serious injuriesClass 4 · LimitedFinal reportCessna U206 · Butler, MOThe jumper’s unintentional deployment of his emergency parachute and subsequent impact with the airplane’s horizontal stabilizer.NTSB DCA24LA200Accident · No injuriesClass 4 · LimitedFinal reportAergility Atlis 1 · Dunnellon, FLAn intermittent electrical failure that switched two motor controllers off, resulting in a loss of hover capability and impact with the ground.NTSB GAA24WA176Accident · 1 fatalClass 5 · ForeignZenair Unknown · Caceres, SpainNTSB WPR24LA296Accident · No injuriesClass 3 · LimitedFinal reportCessna 182C · Vernal, UTThe pilot’s improper in-flight fuel management and delay in configuring the fuel selector for landing as recommended by the manufacturer, which resulted in fuel starvation and a total loss of engine power during the final approach to land.NTSB ERA24LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Vero Beach, FLAn in-flight collision with a bird while on approach.NTSB CEN24LA211Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Chandeleur Island, LAA fatigue failure of the engine oil pressure line, which resulted in the loss of engine oil during the flight and subsequent damage to the nose landing gear support structure during the precautionary landing.NTSB WPR24LA159Accident · No injuriesClass 3 · LimitedFinal reportNanchang China CJ-6A · Peoria, AZThe partial loss of engine power during cruise flight due to the improper installation of the master connecting rod main bushing set screws, which backed off and allowed the main bushing to shift, resulting in scoring damage on the crankshaft that led to the…NTSB WPR24LA158Accident · Serious injuriesClass 3 · LimitedFinal reportEngineering & Research Ercoupe 415-C · Ontario, ORThe non-certificated pilot’s unstable approach to landing, which resulted in a collision with approach lighting, hard landing, and postimpact fire.NTSB DCA24WA185Accident · 1 fatalClass 3 · ForeignBoeing 777 · Payagyi, Myanmar (Burma)NTSB GAA24WA314Accident · No injuriesClass 5 · ForeignRobinson R22 · Municipio de Berazategui, ArgentinaNTSB ERA24LA225Accident · Minor injuriesClass 4 · LimitedFinal reportNickle C R Acro II · Milford, NJThe pilot’s lack of familiarity with the airplane’s fuel system, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA24LA223Accident · No injuriesClass 3 · LimitedFinal reportBeechcraft TC-12B · Lehigh Acres, FLThe asymmetric reverse thrust during the landing roll for reasons that could not be determined, resulting in the flightcrew’s inability to maintain directional control and a subsequent runway excursion.NTSB ERA24FA221Accident · 1 fatalClass 3 · FieldFinal reportRadley Vincent Quicksilver Sport 2S · Cleveland, GAThe pilot’s failure to maintain control of the airplane during the takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin at low altitude. Contributing to the accident was the pilot’s lack of…NTSB CEN24LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Midland, TXThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s failure to take remedial action.NTSB WPR24LA192Accident · No injuriesClass 4 · LimitedFinal reportSIAI Marchetti SM. 1019 · Twin Bridges, MTThe binding of the parking brake cable, which resulted in un-commanded brake application during the landing roll and subsequent nose over.NTSB WPR24FA156Accident · 1 fatalClass 3 · FieldFinal reportExtra Flugzeugbau EA 300/L · Bandera, WAThe pilot’s decision to continue flight into icing conditions and inclement weather, which likely led to spatial disorientation when he attempted to divert from the planned course to the destination airport.NTSB ERA24LA222Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177 · Selma, ALInsufficient lubrication of the engine’s internal components, which resulted in a total loss of engine power.NTSB CEN24LA193Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502 · Covert, KSThe improper maintenance of the fuel control unit, which resulted in air leakage and a loss of control of fuel flow to the engine.NTSB WPR24LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Prescott, AZThe student pilot’s failure to maintain directional control during landing following an aborted takeoff which resulted in a runway excursion and impact with a ditch.NTSB GAA24WA181Incident · No injuriesClass 3 · ForeignCessna 550 · Basseterre, St. Kitts & NevisNTSB ERA24LA220Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · New Washington, OHThe pilot’s failure to maintain clearance from powerlines during an aerial application flight.NTSB DCA24WA194Incident · No injuriesClass 5 · ForeignAirbus A320 · Bengaluru, IndiaNTSB DCA24LA195Incident · Minor injuriesClass 4 · LimitedInvestigation openAirbus A330 · Orlando, FLNTSB CEN24LA191Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Dell City, TXThe pilot’s failure to switch fuel tanks while en route which resulted in the loss of engine power due to fuel starvation.NTSB ANC24LA034Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Wellsville, UTThe pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a nose over.NTSB GAA24WA174Accident · Minor injuriesClass 5 · ForeignPiper PA25 · Lorenzo de Garaicoa, EcuadorNTSB ERA24LA398Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · St. Augustine, FLThe pilot’s improper landing flare resulting in a hard, bounced landing.NTSB ERA24LA224Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Lagrangeville, NYThe pilot’s failure to maintain control of the airplane during the landing and subsequent go-around attempt. Also causal was the flight instructor’s delayed remedial action.NTSB ERA24FA219Accident · 1 fatalClass 3 · FieldPreliminary reportM-Squared Breese 2 · Culpeper, VAOn May 17, 2024, about 1430 eastern daylight time, an M-Squared Aircraft Inc. Breese 2 airplane, N99VY, was involved in an accident near the Culpeper Regional Airport (CJR), Culpeper, Virginia. The commercial pilot was fatally injured. The airplane was…NTSB ANC24LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 190 · San Luis Obispo, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a failure of the right main landing gear and subsequent ground loop.NTSB ANC24LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Afton, WYThe commercial pilot’s failure to maintain directional control of the airplane during takeoff. Contributing was the student pilot’s application of brakes during the takeoff roll and the failure of both pilots to maintain a positive transfer of controls.NTSB ANC24FA032Accident · 2 fatalClass 3 · FieldFinal reportTaylorcraft BC12-D · Nondalton, AKThe non-certificated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into the water.NTSB WPR24LA157Accident · No injuriesClass 3 · LimitedFinal reportCessna P210 · Daggett, CAThe pilot’s failure to detect the tripped alternator circuit breaker in flight, which resulted in a drained battery that prevented the landing gear from fully extending to the down-and-locked position. Contributing to the accident was the improperly installed…NTSB WPR24LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 172G · Lakeport, CAThe pilot’s inadequate use of carburetor heat, which resulted in a total loss of engine power shortly after takeoff due to fuel starvation as a result of carburetor ice.NTSB GAA24WA216AccidentClass 5 · ForeignBell 505 · Minsk, PolandNTSB GAA24WA171Accident · 2 fatalClass 5 · ForeignCessna 182 · Macas, EcuadorNTSB ENG24WA019IncidentClass 5 · ForeignBoeing 737-852 · Merida, MexicoNTSB CEN24FA188Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Godley, TXThe student pilot’s failure to maintain airplane control while practicing a power-on stall, which resulted in an inadvertent spin at an altitude from which he was unable to recover.