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 DCA21LA082Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320 · Fort Lauderdale, FLAn abrupt flight control input by the flight crew during descent that caused a flight attendant to fall and fracture their ankle.NTSB CEN21FA125Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Galt, MOThe pilot’s decision to takeoff into instrument meteorological conditions consisting of low ceilings and icing and his failure to remain clear of terrain while attempting to remain below the clouds, which resulted in impact with terrain.NTSB WPR21LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Redmond, ORFailure of the landing gear strut piston tube due to fatigue cracking from corrosion pitting.NTSB ERA21LA125Accident · Minor injuriesClass 3 · LimitedFinal reportTaylorcraft BC-65 · Columbia, SCA total loss of engine power due to carburetor icing, which resulted from the student pilot’s failure to use carburetor heat.NTSB ERA21LA124Accident · 2 fatalClass 3 · LimitedFinal reportCessna 441 · Belvidere, TNThe pilot’s failure to follow the published instrument approach procedure by prematurely descending the airplane below the final approach fix altitude to fly under the low ceiling conditions, which resulted in controlled flight into terrain.NTSB DCA21WA177Incident · No injuriesClass 5 · ForeignBoeing 777 · London, United KingdomNTSB CEN21LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Urbana, OHThe student pilot’s loss of directional control during landing which resulted in an impact with a snowbank. The slippery runway condition contributed to the accident.NTSB ENG21WA017IncidentClass 5 · ForeignBoeing 737 · Kinshasa, Congo - KinshasaNTSB WPR21LA107Accident · Serious injuriesClass 3 · LimitedFinal reportHughes OH-6A · Horseshoe Bend, IDA partial loss of engine power due to a leak in the fuel cell outlet valve.NTSB WPR21LA106Accident · No injuriesClass 4 · LimitedFinal reportJabiru SP 250 · Thermal, CAThe pilot’s loss of directional control during landing in gusting wind conditions, which resulted in a runway excursion and nose over.NTSB GAA21WA016Accident · 1 fatalClass 5 · ForeignCessna 182 · Sefferweich, GermanyNTSB CEN21LA129Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC42-550FG · Larned, KSThe pilot’s failure to allow sufficient time for the brakes to cool after a previous aborted takeoff, resulting in a runway excursion during a second aborted takeoff due to degraded braking performance. Contributing to the accident was the contact of the hot…NTSB WPR21LA104Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Riverside, CAFuel starvation due to the pilot’s inadequate weather and fuel planning, which resulted in a total loss of engine power.NTSB GAA21WA017AccidentClass 5 · ForeignAir Tractor AT502 · Letsatsi Game Lodge, South AfricaNTSB ERA21LA126Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Pahokee, FLA loss of main rotor rpm for reasons that could not be determined, which resulted in an autorotation and a subsequent hard landing and rollover.NTSB ANC21FA015Accident · 2 fatalClass 3 · FieldFinal reportCessna 185 · Chitina, AKAn in-flight breakup during cruise flight for reasons that could not be determined based on available evidence.NTSB GAA21WA264Incident · No injuriesClass 5 · ForeignRobinson 22 · Hamilton Island, AustraliaNTSB GAA21WA028Incident · No injuriesClass 5 · ForeignTextron 172S · Kitakyushu, JapanNTSB CEN21LA123Accident · No injuriesClass 4 · LimitedFinal reportPiper J3F-50 · Weidman, MIThe pilot’s failure to maintain clearance from terrain during a low approach over a snow-covered runway. Contributing to the accident was the loss of depth perception due to the bright sunlight and snow.NTSB GAA21WA039AccidentClass 5 · ForeignRobinson R22 · Bandelierkop, South AfricaNTSB GAA21WA026Accident · No injuriesClass 5 · ForeignCessna 340A · Toulouse, FranceNTSB GAA21WA012Accident · 1 fatalClass 5 · ForeignCessna 182 · Sao Felix do Xingu, BrazilNTSB ERA21LA122Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Leicester, MAThe pilot’s failure to maintain the minimum airspeed for flight in icing conditions, which resulted in a loss of elevator control during approach due to ice accumulation.NTSB CEN21LA121Accident · 2 fatalClass 3 · LimitedFinal reportCessna 182Q · Hackberry, LAThe flight instructor did not maintain control of the airplane during training maneuvers, which resulted in a rapid, steep descent and impact with terrain.NTSB GAA21WA069Accident · No injuriesClass 5 · ForeignRotorway Exec · Ledbury, Herefordshire, United KingdomNTSB GAA21WA014Accident · No injuriesClass 5 · ForeignCessna 188 · Viamao, BrazilNTSB DCA21WA080Accident · No injuriesClass 5 · ForeignBoeing 747 · Narita, JapanNTSB WPR21LA098Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T182T · Crescent City, CAThe partial loss of engine power due to the failure of both magneto capacitors.NTSB GAA21WA011Accident · 1 fatalClass 5 · ForeignCessna T188 · Ourilandia do Norte, BrazilNTSB CEN21LA119Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Silt, COThe pilot’s failure to avoid powerlines while flying at low altitude.NTSB GAA21WA073Accident · No injuriesClass 5 · ForeignCessna 525 · Antwerp, BelgiumNTSB ERA21LA121Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Knoxville, TNThe pilot’s failure to maintain directional control of the helicopter, which resulted in rear portion of the right skid contacting the ground and a subsequent dynamic rollover.NTSB ERA21LA120Accident · Serious injuriesClass 4 · LimitedFinal reportRivers Lindsey Lee Vans RV6A · O'Brien, FLThe flight instructor’s improper soft field landing technique while landing on a turf runway, which resulted in a nose over.NTSB ENG21LA013IncidentClass 3 · LimitedFinal reportBoeing 767-338 · Ontario, CAThe fatigue fracture and liberation of two airfoils from a low pressure turbine stage 5 nozzle segment that impacted and damaged the downstream low pressure stage 5 blades creating an initial imbalance load in the engine’s low pressure turbine rotor…NTSB CEN21LA120Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Clare, MIThe pilot’s failure to maintain directional control during landing that resulted in a runway excursion and impact with terrain.NTSB GAA21WA020Accident · No injuriesClass 5 · ForeignCessna 414 · Guerrero Negro, MexicoNTSB ERA21LA119Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lawrenceville, GAThe pilot's failure to maintain directional control during landing in a gusting crosswind, which resulted in a loss of control and runway excursion.NTSB CEN21LA118Accident · No injuriesClass 4 · LimitedFinal reportBeech 300 · Davenport, IAThe pilot’s failure to maintain directional control of the airplane, and the flight instructor’s inadequate oversight during a simulated engine out takeoff that resulted in a runway excursion and impact with a snowbank.NTSB WPR21LA097Accident · 1 fatalClass 3 · LimitedFinal reportCessna 170A · Port Angeles, WAThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate in-flight fuel planning.NTSB GAA21WA070Accident · Serious injuriesClass 3 · ForeignBell 212 · Región del Libertador Bernardo O´Higgins, ChileNTSB GAA21WA010Accident · Minor injuriesClass 5 · ForeignCessna 150 · Serra Azul, BrazilNTSB DCA21WA078Incident · No injuriesClass 5 · ForeignBoeing 737 · Sydney, AustraliaNTSB ERA21LA117Accident · No injuriesClass 4 · LimitedFinal reportRobinson R22 · West Palm Beach, FLThe examiner’s failure to arrest the helicopter descent during a simulated engine failure maneuver and the flight instructor’s inadequate remedial action, which resulted in a hard landing.NTSB DCA21WA103IncidentClass 5 · ForeignBoeing 737 · Buenos Aires, ArgentinaNTSB DCA21WA077Incident · No injuriesClass 5 · ForeignBoeing 747 · Karachi, PakistanNTSB CEN21LA117Accident · Serious injuriesClass 3 · LimitedFinal reportZenair Zodiac 601HDS · Waller, TXThe total loss of engine power due to a disconnected fuel line, which resulted in fuel starvation.NTSB GAA21WA266Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Sevelen, SwitzerlandNTSB ERA21LA111Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-161 · Boynton Beach, FLThe pilot’s controlled flight into the ocean at night due to his unrecognized spatial disorientation. Contributing to the accident was the pilot’s distraction with the tuning of his transponder while maneuvering over an area with reduced visual references.NTSB DCA21WA075IncidentClass 5 · ForeignBoeing 737 · Durban, South AfricaNTSB ANC21LA012Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-14 · Anchorage, AKThe instructor pilot’s selection of an unsuitable snow-covered runway for landing practice, and the pilot under instruction’s failure to maintain directional control during a landing roll, which resulted in a loss of control in unpacked snow and a subsequent…