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 DCA21WA129IncidentClass 5 · ForeignAirbus A330 · Karachi, PakistanNTSB WPR21LA182Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 175B · Royal City, WAThe pilot’s failure to maintain airplane control during a landing with a tailwind which resulted in excessive ground speed, runway over run and subsequent nose over.NTSB GAA21WA104Accident · 2 fatalClass 5 · ForeignRobinson R22 · Durban, South AfricaNTSB ERA21LA204Accident · Minor injuriesClass 4 · LimitedFinal reportJabiru Aircraft PTY J170-D · Winchester, VAThe pilot’s loss of directional control on landing. Contributing to the outcome was the pilot’s decision to continue the aborted landing after the airplane had departed the runway surface.NTSB ENG21WA030IncidentClass 5 · ForeignDe Havilland DHC6 · Wallis & Futuna, Wallis & FutunaNTSB WPR21LA191Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic S A N-500 · Phoenix, AZThe pilot’s inability to maintain control after the balloon's encounter with an unexpected wind gust, which resulted in a collision with a tree.NTSB WPR21LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Driggs, IDThe pilot’s failure to maintain directional control while landing with gusting wind conditions, which resulted in a ground loop.NTSB WPR21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cuba, NMThe pilot's failure to maintain lateral control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.NTSB GAA21WA213Accident · No injuriesClass 5 · ForeignPiper PA38 · El Carmen, Jujuy Province, ArgentinaNTSB GAA21WA103Accident · No injuriesClass 5 · ForeignPrecision Helicopters UH-1H · Rayón, MexicoNTSB GAA21WA100Accident · 4 fatalClass 5 · ForeignBell 206 · Rio Bravo, GuatemalaNTSB ERA21LA227Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Charleston, SCThe airplane's impact with a deer during takeoff.NTSB ERA21LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Williamson, GAThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion.NTSB ERA21LA202Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Martinsville, VAThe pilot’s improper pitch control during a go-around in gusting crosswind conditions, which resulted in a tail strike and a runway excursion.NTSB ERA21FA200Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Wingate, NCThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight, resulting in tail rotor impact with the power line, a loss of control, and subsequent impact with the ground.NTSB CEN21FA207Accident · 1 fatalClass 3 · FieldFinal reportCessna T210M · Oxford, IAThe pilot’s loss of directional control during landing in gusting crosswind conditions that exceeded the airplane’s capability and his decision to attempt to takeoff from a field, which resulted in collision with a power pole/line and terrain.NTSB GAA21WA106Accident · No injuriesClass 4 · ForeignEdge 540 · Tempsford, United KingdomNTSB ERA21LA201Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Lakeland, FLThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN21LA208Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 23 · Hutchinson, KSThe pilot’s failure to abort the takeoff and his high pitch attitude after takeoff, which resulted in an exceedance of the critical angle of attack and a subsequent aerodynamic stall.NTSB ANC21LA035Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172P · Lanai City, HIThe solo student pilot’s failure to maintain directional control during landing in crosswind conditions, which resulted in a runway excursion and a nose-over.NTSB ERA21LA205Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Columbia, KYThe pilot’s failure to obtain a proper touchdown point on the runway, which resulted in a runway excursion.NTSB WPR21LA179Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30B · Corvallis, ORThe pilot’s failure to maintain airplane control during a simulated engine out landing which resulted in impact with terrain.NTSB OPS21LA002Incident · No injuriesClass 3 · LimitedFinal reportAirbus A319-112 · St Petersburg-Clearwater, FLThe air traffic controller’s failure to properly scan the runway and local area, and their general loss of situational awareness, resulting in a near midair collision. Contributing to the incident was the Cessna 337 pilot's poor decision making when he failed…NTSB GAA21WA099Accident · 6 fatalClass 5 · ForeignPiper PA-32-260 · Monterrey, MexicoNTSB GAA21WA098Accident · No injuriesClass 5 · ForeignRobinson R44 · Región de Ñuble, ChileNTSB ERA21LA213Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · Okeechobee, FLA total loss of engine power for reasons that could not be determined based on available information.NTSB ERA21LA199Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20C · Warwick, NYA loose stand-off clamp which resulted in a throttle assembly malfunction, and the inability of the engine to produce full power during the attempted takeoff.NTSB GAA21WA102Incident · No injuriesClass 5 · ForeignCessna 150 · Fernandópolis - SP, BrazilNTSB ERA21LA210Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Friendly, MDThe pilot’s failure to attain a proper touchdown point on landing, which resulted in a collision with the runway lip.NTSB ERA21FA195Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 429 · Eden, NCThe impact of the main rotor blades with the tail boom during low-altitude maneuvers, which severed the tail rotor drive shaft and resulted in a loss of control and impact with terrain.NTSB ERA21FA194Accident · 3 fatalClass 3 · FieldFinal reportBeech C23 · Middleburg, FLThe pilot's decision to depart from a soft grass runway with a tailwind, which resulted in an increased takeoff distance and subsequent impact with trees during the initial climb.NTSB CEN21LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Madison, ARThe pilot’s improper fuel planning which led to fuel exhaustion, and a total loss of engine power.NTSB WPR21LA178Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 · Brigham City, UTThe student pilot's unintentional selection of raising the landing gear instead of the flaps during a touch-and-go landing, and the flight instructor's delayed remedial action, which resulted in the landing gear retracting during the landing roll.NTSB GAA21WA093Accident · No injuriesClass 5 · ForeignMooney M20M · Lübeck, GermanyNTSB GAA21WA101Accident · 4 fatalClass 5 · ForeignCessna 172 · Grasmere, South AfricaNTSB GAA21WA090Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Buckinghamshire, United KingdomNTSB ERA21LA196Accident · No injuriesClass 4 · LimitedFinal reportCessna 402C · Hyannis, MAThe flight instructor’s failure to confirm the position of the left engine’s auxiliary fuel boost pump switch during a simulated engine out procedure, which resulted in an excess amount of fuel in the engine and subsequent partial loss of power during a…NTSB ERA21LA193Accident · No injuriesClass 4 · LimitedFinal reportTextron 208B · Laceyville, PAThe pilot’s improper decision to conduct a low altitude flight and his failure to see and avoid powerlines. Contributing was the operator’s lack of safety guidance or a safety policy for low-altitude operations.NTSB CEN21LA204Accident · 1 fatalClass 3 · LimitedFinal reportPiper J3C-65 · Slaughter, LAA total loss of engine power for reasons that could not be determined from the available evidence.NTSB CEN21LA202Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75 · Denver, COThe pilot’s failure to maintain directional control during the landing roll with variable and gusty wind conditions.NTSB ANC21LA033Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Anchorage, AKThe pilot’s mismanagement of fuel which resulted in fuel starvation and total loss of engine power during a go-around. Contributing to the accident was the improperly marked fuel quantity gauges that failed to indicate a fuel quantity takeoff limitation.NTSB WPR21LA177Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182J · Sedona, AZThe pilot’s failure to maintain directional control during landing with a crosswind, which resulted in a collision with a fuel truck and a parked airplane.NTSB GAA21WA095Accident · 1 fatalClass 5 · ForeignCessna 182 · Fundo, VenezuelaNTSB GAA21WA094Accident · Serious injuriesClass 5 · ForeignCessna 182 · Chiguao, VenezuelaNTSB ERA21LA192Accident · Serious injuriesClass 3 · LimitedFinal reportMeyeres F L/Meyeres M M Skystar Ktfox Clsc 4 · Mountain Rest, SCA partial loss of engine power due to carburetor icing. Contributing to the accident was the engine’s lack of carburetor heat.NTSB CEN21LA200Accident · 1 fatalClass 3 · LimitedFinal reportAeropro CZ S R O A240 · Richmond, INThe noninstrument-rated pilot’s intentional flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of airplane control.NTSB ANC21LA034Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Palmer, AKThe pilot’s selection of unsuitable terrain for landing and his excessive braking which resulted in a nose-over.NTSB ERA21LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Fredericksburg, VAThe student pilot reported that, during the landing roll, he applied brakes and the airplane veered right. He was unable to correct back to the centerline or brake effectively; the airplane exited the runway and struck an embankment before coming to rest. The…NTSB DCA21WA139Incident · No injuriesClass 5 · ForeignBoeing 737 · Rotterdam, NetherlandsNTSB CEN21LA205Accident · No injuriesClass 4 · LimitedFinal reportCessna 310N · Carrollton, OHThe pilot’s failure to confirm the landing gear was down before landing due to distraction during the Before Landing checks, which resulted in a gear-up landing.