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 CEN21LA326Accident · Serious injuriesClass 3 · LimitedFinal reportGary James Lail Zenith CH 750 Cruzer · Blossom, TXThe improper swaging of the rudder control cable, which disconnected during flight and resulted in the loss of control.NTSB WPR21FA273Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Angwin, CAThe pilot's exceedance of the airplane’s critical angle of attack during an aborted landing after an unstabilized approach and hard landing, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing to the accident was the pilot’s…NTSB GAA21WA181Accident · 2 fatalClass 5 · ForeignCessna 150 · Marcos Paz, ArgentinaNTSB ERA21LA292Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Princeton, KYThe pilot’s inadequate preflight planning in that he failed to accurately determine the takeoff weight of the helicopter, which resulted in exceeding the helicopter’s maximum weight capability.NTSB ENG21WA047Accident · 1 fatalClass 5 · ForeignTecnam P2008 · Vardi, IndiaNTSB DCA21WA181IncidentClass 5 · ForeignBoeing 787 · Dublin, IrelandNTSB CEN21LA323Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Refugio, TXThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB ANC21LA061Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Skwentna, AKA partial loss of engine power due to detonation/preignition damage to the No. 2 cylinder. The reason for the detonation/preignition damage could not be determined based on the available evidence.NTSB ANC21LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Skwentna, AKThe pilot’s use of excessive braking which resulted in a nose-over.NTSB WPR21LA271Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV6 · Riverside, CAA total loss of engine power for reasons that could not be determined from available evidence.NTSB WPR21FA272Accident · 4 fatalClass 3 · FieldFinal reportMooney M20J · Dinsmore, CAThe airplane’s degraded engine performance due to wear to the intake cam lobes, which diminished the airplane’s takeoff and climb performance, resulting in a subsequent collision with trees.NTSB GAA21WA193AccidentClass 5 · ForeignSikorsky S92 · South Havra, United KingdomNTSB ERA21LA329Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Sterling, MAThe pilot’s failure to maintain the glider’s stability in the roll axis during the takeoff roll, which resulted in a dragged wingtip and ground loop.NTSB ERA21LA290Accident · 1 fatalClass 3 · LimitedFinal reportCameron 0-105 · Piermont, NHThe balloon pilot’s delay in relighting the burner, which resulted in a hard landing and his ejection from the balloon.NTSB ERA21LA289Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-23 · Easton, MDA total loss of left engine power and uncommanded feathering of the left propeller for reasons that could not be determined.NTSB ERA21LA288Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland Canada DHC-1 Chipmunk X · Lebanon, TNA total loss of engine power during the initial climb for reasons that could not be determined based on the available evidence.NTSB ENG21WA034AccidentClass 5 · ForeignCessna P206 · Kamarang, GuyanaNTSB CEN21LA324Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Rhinelander, WIThe pilot’s failure to maintain directional control during landing.NTSB CEN21LA322Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Edcouch, TXThe pilot’s inadequate compensation for a gusting wind during takeoff.NTSB GAA21WA259Accident · No injuriesClass 5 · ForeignCessna 208 · Eteringbang, GuyanaNTSB CEN21FA320Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Muscatine, IAThe noninstrument-rated pilot’s continued visual flight under a thunderstorm, where he encountered reduced visibility due to heavy precipitation, resulting in a loss of control due to spatial disorientation.NTSB WPR21FA270Accident · 2 fatalClass 3 · FieldFinal reportCessna 421C · Monterey, CAThe pilot’s failure to maintain airplane control due to spatial disorientation during an instrument departure procedure in instrument meteorological conditions which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of…NTSB ERA21LA291Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A150K · Brooksville, FLA total loss of engine power as a result of carburetor icing.NTSB CEN21LA319Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-401 · Carroll, IAThe wear-related failure of the airframe fuel boost pump, which resulted in fuel starvation and a loss of engine power.NTSB CEN21FA314Accident · 1 fatalClass 3 · FieldFinal reportPZL Mielec M18 · Seiling, OKThe pilot’s in-flight loss of control due to the structural failure of a wing fitting and separation of the outboard wing section. Also causal were the inadequate wing fitting inspections, which failed to detect the initial corrosion and crack before it…NTSB WPR21LA267Accident · No injuriesClass 4 · LimitedFinal reportJust JA30 Superstol · May, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground-loop and collision with terrain.NTSB GAA21WA171AccidentClass 5 · ForeignBell 412 · Ejea de los Caballeros, SpainNTSB ERA21LA284Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Elba, ALThe partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with trees during takeoff.NTSB ENG21WA032IncidentClass 4 · ForeignAirbus A220 · Copenhagen, DenmarkNTSB CEN21LA316Accident · No injuriesClass 3 · LimitedFinal reportCessna 172F · Eagle Butte, SDA total loss of engine power due to the fatigue failure of the No. 6 connecting rod.NTSB CEN21LA313Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT802 · Newell, IAThe pilot’s failure to maintain adequate clearance from crops during an agricultural flight.NTSB ANC21LA063Accident · No injuriesClass 4 · LimitedFinal reportBeech F35 · Yakutat, AKThe pilot’s failure to ensure adequate runway distance for landing.NTSB ANC21LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Rampart, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose over.NTSB WPR21LA287Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Chandler, AZThe pilot’s delayed decision to abort the takeoff due to insufficient airspeed.NTSB WPR21LA269Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Petaluma, CAThe pilot’s improper landing flare which resulted in a hard landing following a partial loss of electrical power. Contributing to the accident was the pilot’s distraction and hampered visual function.NTSB WPR21FA266Accident · 2 fatalClass 3 · FieldFinal reportBeech C90 · Wikieup, AZThe failure and separation of the left wing’s outboard section due to a fatigue crack in the lower spar cap. Contributing to the accident was the operator’s decision to repair the wing spar instead of replacing it as recommended by the aircraft manufacturer.…NTSB WPR21FA265Accident · 2 fatalClass 3 · FieldFinal reportNorth Wing Mustang · Albany, ORThe noncertificated pilot’s loss of aircraft control after a low-level turn with a bank angle that exceeded the manufacturer’s operating limitations.NTSB GAA21WA170Accident · 1 fatalClass 5 · ForeignJoplin Tundra · Athens, CanadaNTSB ERA21LA283Accident · 1 fatalClass 3 · LimitedFinal reportBailey N Moyes Dragonfly · Charlestown, NHThe passenger’s decision to continue an unstable approach while at low altitude and in proximity to a known obstacle, which resulted in a collision with power lines.NTSB CEN21LA315Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Longmont, COThe loss of performance for reasons that could not be determined.NTSB WPR21LA285Accident · No injuriesClass 4 · LimitedFinal reportCessna T210 · Missoula, MTThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.NTSB WPR21LA276Accident · No injuriesClass 4 · LimitedFinal reportPayne Steven R RV-8 · Hillsboro, ORThe second pilot’s diverted attention while taxing which, resulted in his failure to maintain clearance from another airplane holding short of the runway.NTSB GAA21WA252Incident · No injuriesClass 5 · ForeignDiamond HK36 · Locarno, SwitzerlandNTSB CEN21LA432Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Berlin, ILThe pilot’s failure to maintain control of the helicopter with a stuck skid, which resulted in a dynamic rollover.NTSB ANC21LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2-L-20 · Coffman Cove, AKThe pilot’s impact with a buoy on takeoff which resulted in a nose-over.NTSB GAA21WA210AccidentClass 5 · ForeignCessna 172 · Beirut, LebanonNTSB GAA21WA172Accident · 3 fatalClass 5 · ForeignDouglas DC3 · Restrepo, ColombiaNTSB GAA21WA169Accident · 9 fatalClass 5 · ForeignDe Havilland DHC2 · Örebro, SwedenNTSB WPR21LA274Accident · No injuriesClass 4 · LimitedFinal reportScott Mills CCX-2000 · Independence, ORThe pilot's loss of directional control while landing, which resulted in a runaway excursion and subsequent ground loop.NTSB WPR21LA268Accident · No injuriesClass 3 · LimitedFinal reportBell 212HP · Weed, CAThe pilot’s failure to maintain altitude during an approach to a lake. Contributing to the accident was the pilot’s failure to release the full water bucket as the helicopter was settling, which reduced the helicopter’s out-of-ground-effect performance.