NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 ERA24LA027Accident · No injuriesClass 4 · LimitedFinal reportMustang II · Asheville, ALThe pilot’s failure to maintain control of the airplane during initial climb after an aborted landing, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA24LA025Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 305 · Williamston, NCLoss of directional control to avoid a deer during landing, which resulted in a runway excursion and collision with a culvert.NTSB CEN24LA029Accident · No injuriesClass 4 · LimitedFinal reportAg-Cat G-164B · Abbeville, LAThe pilot’s failure to maintain clearance from a power line during an aerial application flight.NTSB WPR24FA024Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Orangeville, UTThe pilot's controlled flight into mountainous terrain for reasons that could not be determined.NTSB OPS24LA004IncidentClass 4 · LimitedFinal reportAirbus A321-271N · Long Beach, CAThe local controller’s poor judgment in prioritization of their ground traffic ahead of their airborne traffic, that became a distraction and led to a loss of situational awareness resulting in a near midair collision. Contributing to the incident was the…NTSB ERA24LA024Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Rangeley, METhe pilot’s failure to maintain directional control during the landing roll with a crosswind, after the right tailwheel spring separated.NTSB WPR24LA025Accident · Serious injuriesClass 4 · LimitedFinal reportGulfstream Aerospace Commander 690C · Reno, NVThe pilot applicant’s excessive nose down pitch, and the check pilot’s delayed remedial action, which resulted in an impact with terrain.NTSB WPR24LA023Accident · No injuriesClass 3 · LimitedFinal reportVans RV-12 · Novato, CAA partial loss of engine power during initial climb for undetermined reasons.NTSB GAA24WA055AccidentClass 5 · ForeignRobinson R44 · Groenvlei, South AfricaNTSB GAA24WA023Accident · 2 fatalClass 5 · ForeignRobinson R66 · Williamtown, AustraliaNTSB ERA24LA022Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20E · Pembroke Pines, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB DCA24WA044OccurrenceClass 5 · ForeignDe Havilland Dash 8 · Val-d'Or, CanadaNTSB CEN24LA027Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Rowlett, TXA malfunction of the helicopter’s Engine Monitoring Unit (EMU)/Governor Controller for undetermined reasons. Contributing to the accident was the flight instructor’s failure to turn off the EMU/Governor Controller per the emergency checklist when the…NTSB ERA24LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Atlanta, GAThe flight instructor’s inadequate remedial action and the student pilot’s failure to relinquish the flight controls as directed by the flight instructor, resulting in a loss of control and nose over.NTSB CEN24FA024Accident · 1 fatalClass 3 · FieldFinal reportLancair 320 · Manitowoc, WIThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from trees and terrain during an unapproved instrument approach. Contributing to the accident was the pilot’s…NTSB GAA24WA125Accident · No injuriesClass 5 · Foreignreims F406 · Farm Erindi, NamibiaNTSB ENG24WA005Accident · No injuriesClass 5 · ForeignSikorsky S76 · Sidney, CanadaNTSB DCA24FA017Accident · No injuriesClass 2 · FieldFinal reportTextron 510 · Houston, TXThe takeoff by the flight crew of N269AA, without a takeoff clearance, which resulted in a collision with N510HM that was landing on an intersecting runway. Contributing to the accident was the N269AA crew’s expectation bias and distraction.NTSB CEN24LA026Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Savoy, ILThe pilot’s failure to extend the landing gear before landing and the flight instructor’s inadequate supervision to ensure that the landing gear was extended.NTSB CEN24FA021Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · Vidalia, LAThe pilot’s failure to maintain clearance from power lines during an aerial application flight. Contributing to the accident was the pilot’s cell phone use and the position of the sun, which reduced the pilot’s ability to perceive the location of the power…NTSB DCA23WA480IncidentClass 5 · ForeignBoeing 737 · Stuttgart, GermanyNTSB CEN24LA020Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA 46-350P · Pierre, SDThe total loss of engine power due to fuel starvation as a result of the pilot’s improper configuration of the automatic fuel transfer system. Contributing to the accident was the pilot’s failure to adequately monitor the header tank’s fuel quantity.NTSB GAA24WA029Accident · Minor injuriesClass 3 · ForeignTecnam P2008 · Baramati, IndiaNTSB ERA24LA086Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Morganton, NCThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and an impact with the runway’s precision approach path indicator (PAPI) lights.NTSB ERA24LA018Accident · No injuriesClass 3 · LimitedFinal reportRoth Frank Ronald Avid Aircraft · Knoxville, TNA total loss of engine power due to a seized piston in the power take-off cylinder.NTSB ERA24LA014Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Ottawa, OHA total loss of engine power due to the formation of carburetor ice..NTSB CEN24LA023Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-201T · Mount Pleasant, MIThe airplane’s collision with a deer on the runway during landing.NTSB CEN24LA022Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Iola, KSThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR24FA018Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Covelo, CAThe pilot’s failure to maintain clearance from trees after entering a steep banked turn for unknown reasons. Contributing to the accident was the pilot’s decision to take off toward rising terrain.NTSB GAA24WA042Accident · 1 fatalClass 5 · ForeignBeech C23 · Bram Fischer International Airpor, South AfricaNTSB GAA24WA020Accident · 1 fatalClass 5 · ForeignBeech C23 · Pretoria, South AfricaNTSB ERA24LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Orangeburg, SCThe student pilot’s failure to maintain adequate clearance from a fuel truck while taxiing. Also contributing was the flight instructor’s inadequate monitoring of the student pilot.NTSB ERA24LA016Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · Richmond, VAThe loss of engine power due to a restriction of fuel flow as a result of a fractured float bracket in the carburetor.NTSB CEN24LA031Accident · Serious injuriesClass 3 · LimitedFinal reportPowrachute Pegasus · Manhattan, KSThe pilot’s improper modification of the engine cooling system that resulted in an engine overheat and total loss of power. Contributing to the accident was the pilot’s decision to continue the flight after the engine overheat light illuminated instead of…NTSB WPR24LA021Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · The Dalles, ORThe pilot’s encounter with severe turbulence at night which resulted in an extended downwind and collision with wires during the base turn.NTSB ERA24LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Jackson, TNThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a runway excursion.NTSB ERA24LA017Accident · No injuriesClass 4 · LimitedFinal reportAviat A1 · Tellico Plains, TNThe pilot's overapplication of brakes after landing long on a constrained runway and with a tailwind, which resulted in a nose-over.NTSB CEN24LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 172C · Wichita, KSThe pilot’s inadequate preflight inspection and fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA24WA030Accident · Minor injuriesClass 3 · ForeignTecnam P2008 · Baramati, IndiaNTSB GAA24WA019Accident · Serious injuriesClass 5 · ForeignCessna 208 · Barwon Heads Geelong, AustraliaNTSB GAA24WA014Accident · 1 fatalClass 4 · ForeignCessna 172 · Barrancabermeja, ColombiaNTSB DCA24LA043Incident · No injuriesClass 4 · LimitedFinal reportBoeing 787 · Chicago, ILThe flight crew’s misperception of the distance required to safely pass the hangar and failure to request additional ground handling support while taxiing, which resulted in a collision with a hangar. Contributing to the accident was United Airlines…NTSB WPR24LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Bandera, WAThe pilot’s decision to land at a closed water-soaked grass runway, which resulted in a runway excursion.NTSB ERA24LA012Accident · No injuriesClass 3 · LimitedFinal reportBeech 300 · Atlanta, GAThe pilot’s failure to maintain a proper approach speed, which resulted in a runway overrun. Contributing to the runway overrun were the pilot’s application of full reverse at an airspeed higher than that allowed by the system, which added power and forward…NTSB ENG24FA003Incident · No injuriesClass 3 · FieldFinal reportBoeing 767-300F · Memphis, TNA high-pressure fuel leak from a gap in the bolted flange interface between the main fuel pump’s fuel crossover supply tube and the hydromechanical unit idler adapter pad, which resulted in the crossover tube flange bolts partially pulling out and allowing…NTSB DCA24WA018Incident · No injuriesClass 5 · ForeignBoeing 737-800 · Frankfurt am Main, GermanyNTSB DCA24WA014Incident · No injuriesClass 5 · ForeignBoeing 737 · Belfast, United KingdomNTSB CEN24LA018Accident · No injuriesClass 3 · LimitedFinal reportCessna 210B · Pueblo, COThe fatigue failure of the right main landing gear hydraulic actuator, which resulted in a loss of hydraulic fluid that prevented the pilot from lowering the landing gear to the fully extended position.NTSB WPR24FA014Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Williams, AZThe pilot’s failure to maintain sufficient airspeed and exceedance of the airplane’s critical angle of attack during initial climb after takeoff, resulting in an aerodynamic stall. Contributing was the pilot’s inadequate preflight airplane performance…NTSB ERA24LA011Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P2010 · Ocala, FLA total loss of engine power for reasons that could not be determined. Contributing to the accident was the flight instructor’s failure to maintain adequate airspeed and exceedance of the airplane’s critical angle of attack during the forced landing, which…