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 GAA19CA233Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Juneau, AKThe pilot's failure to maintain a proper approach to landing on a ridge and his failure to maintain clearance from snow-covered terrain, which resulted in a tail rotor strike.NTSB GAA19CA228Accident · No injuriesData collectionFinal reportBellanca 7GCAA · Lincoln, CAThe pilot receiving instruction's failure to maintain directional control during landing, which resulted in an attempted go-around and collision with a trench, and the flight instructor's delayed remedial action during the landing.NTSB ENG19WA023Incident · No injuriesForeign investigationBoeing 767 · Johannesburg, South AfricaThe Government of South Africa has notified the NTSB of an incident involving an Air Zimbabwe Boeing 767-2NOER with Pratt & Whitney PW4056 engines on April 28, 2019. The NTSB has appointed an Accredited Representative in accordance with the provisions of ICAO…NTSB CEN19TA131Accident · No injuriesClass 3Final reportAir Tractor AT 602 · Quanah, TXThe pilot's failure to maintain clearance from the power line during a low altitude aerial application maneuver.NTSB GAA19CA237Accident · No injuriesData collectionFinal reportVans RV 6 · Chandler, OKThe pilot's overapplication of the brakes during landing on a grass runway, which resulted in a nose-over.NTSB GAA19CA235Accident · No injuriesData collectionFinal reportBakeng Bakeng Deuce · Winston Salem, NCThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA19CA227Accident · No injuriesData collectionFinal reportMaule M7 · Roosevelt, UTThe pilot's failure to maintain directional control during landing in gusting wind conditions, which resulted in a runway excursion and collision with a culvert.NTSB ERA19LA159Accident · Minor injuriesClass 3 · LimitedFinal reportZenair Zodiac CH601 · Angier, NCA partial loss of engine power due to partial interruption of the fuel supply for undetermined reasons.NTSB CEN19LA129Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 23 · Sulphur Spring, TXThe pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…NTSB CEN19CA128Accident · Serious injuriesData collectionFinal reportUltramagic S90 · La Mesa, TXThe pilot's improper decision to launch the balloon in known high wind conditions, and his failure to fully vent the balloon upon landing, which resulted in the balloon landing hard several times, tipping over, being pushed along uneven ground, and a serious…NTSB WPR19LA122Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Oakridge, ORA total loss of engine power following the failure of a 3rd stage turbine blade due to low- and high-cycle fatigue.NTSB GAA19CA253Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · Gila Bend, AZThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA231Accident · No injuriesData collectionFinal reportBeech 76 · St Charles, MOThe pilot receiving instruction's failure to extend the landing gear. Contributing to the accident were the pilot receiving instruction's failure to complete the landing checklist and the flight instructor's inadequate monitoring of the pilot.NTSB GAA19CA226Accident · No injuriesData collectionFinal reportGuimbal Cabri · McMinnville, ORThe pilot's improper landing flare during a turning, full-down autorotation, which resulted in a lower-than-normal rotor rpm, a faster-than-normal ground run speed, and the subsequent loss of directional control, a runway excursion, and a roll-over.…NTSB ENG19WA022Accident · No injuriesForeign investigationBell 222 · Addis Ababa, EthiopiaOn April 26, 2019, a Trans Nation Airways, PLC, Bell 222UT helicopter, registered in Ethiopia as ET-AVF crashed near the Addis Ababa Bole International Airport, Addis Ababa, Ethiopia after both engines, Honeywell LTS101-750 turboshafts, lost power. The…NTSB DCA19WA145Incident · No injuriesForeign investigationBoeing 737 · Bogota, ColombiaThe GRIAA of Colombia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on April 26, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the GRIAA's investigation under the provisions of ICAO Annex 13 as…NTSB CEN19LA127Accident · No injuriesClass 3 · LimitedFinal reportBeech 50 · Sheldon, MOA partial loss of engine power on both engines due to detonation for undetermined reasons.NTSB WPR19FA121Accident · 2 fatalClass 3 · FieldFinal reportTL Ultralight Sro Stingsport · Madera, CAThe pilot's exceedance of the airplane's critical angle of attack during the simulated engine failure on initial climb after takeoff, which resulted in an aerodynamic stall and subsequent loss of control at too low of an altitude to recover.NTSB ERA19LA158Accident · Serious injuriesClass 3 · LimitedFinal reportAcro Super Acro Sport I · Elberton, GAThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA19CA219Accident · No injuriesData collectionFinal reportCessna 180 · Morgan, UTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and an attempted aborted landing and impact with bushes and terrain.NTSB WPR19LA120Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 225 DD · McCall, IDA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19CA220Accident · No injuriesData collectionFinal reportCessna 172 · Prescott, AZThe student pilot's failure to maintain clearance from a fence post during taxi operations.NTSB ERA19LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Key West, FLThe pilot's decision to attempt a takeoff in rough sea conditions, resulting in damage to the floats and the sinking of the seaplane.NTSB ERA19FA155Accident · 2 fatalClass 2 · FieldFinal reportBellanca 1730 · Henderson, KYThe student pilot's failure to maintain proper airspeed, which resulted in the exceedance of the airplane's critical angle of attack at a low altitude, in the airport traffic pattern, following a total loss of engine power due to fuel exhaustion. Contributing…NTSB DCA19WA225OccurrenceClass 5 · ForeignAirbus A380 · Si Sa Ket Priovince, ThailandNTSB WPR19LA130Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Prineville, ORThe pilot’s failure to maintain directional control during takeoff with a crosswind.NTSB WPR19FA118Accident · 1 fatalClass 2 · FieldFinal reportNorthrop N9M · Norco, CAThe pilot's loss of control for undetermined reasons.NTSB ERA19LA157Accident · Serious injuriesClass 3 · LimitedFinal reportBarrows Bearhawk LSA · Holly Springs, NCThe pilot's failure to maintain clearance from powerlines during the visual approach.NTSB ERA19FA154Accident · 1 fatalClass 3 · FieldFinal reportWheeler Express Series 2000 · Cleveland, NCA loss of control and impact with terrain while maneuvering.NTSB CEN19FA124Accident · 6 fatalClass 2 · FieldFinal reportBeech 58 · Kerrville, TXThe pilot's inadequate preflight fuel planning and fuel management, which resulted in a loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to follow the one-engine inoperative checklist and maintain the airplane's minimum…NTSB CEN19LA123Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R66 · St Jacob, ILThe pilot's in-flight collision with an unmarked wire during an aerial application flight; the wire lacked contrast with the surrounding environment.NTSB CEN19FA122Accident · 2 fatalClass 3 · FieldFinal reportRans S7 · Kingsland, TXThe exceedance of the airplane's critical angle of attack during a steep climb after takeoff, which resulted in an aerodynamic stall and spin into terrain.NTSB GAA19CA225Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe pilot's improper rudder inputs and failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with a runway sign.NTSB GAA19CA224Accident · No injuriesData collectionFinal reportLuscombe 8 · Bremen, ALThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun, impact with a fence, and a nose-over.NTSB GAA19CA218Accident · No injuriesData collectionFinal reportCessna 180 · Reedsburg, WIThe pilot's loss of directional control and subsequent improper brake application during the landing roll, which resulted in a nose-over.NTSB CEN19LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Cloud, MNThe pilot's failure to maintain directional control during a crosswind landing. Contributing to the accident was the pilot’s decision to land in crosswind conditions given his lack of recent experience in those conditions.NTSB WPR19LA117Accident · Minor injuriesClass 3 · LimitedFinal reportNanchang CJ 6 · Grass Valley, CAA loss of brake control due to fatigue fracture of the brake control cable, which resulted in the separation of the cable from the brake handle.NTSB WPR19FA115Accident · 1 fatalClass 3 · FieldFinal reportBeech 60 · Fullerton, CAThe pilot’s use of an unapproved elevator control lock device, and his failure to remove that device and correctly position the elevator before flight, which resulted in a loss of control during takeoff. Contributing to the accident was his failure to perform…NTSB GAA19CA268Accident · No injuriesData collectionFinal reportPiper PA32 · SaipanThe airplane’s collision with a bird during the initial climb, which resulted in the engine cowling separating and impacting the empennage.NTSB CEN19LA126Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Dwight, ILA partial loss of engine power due to a restriction in fuel flow for undetermined reasons.NTSB WPR19FA116Accident · 2 fatalClass 3 · FieldFinal reportVans RV8 · Brookings, ORThe pilot’s failure to maintain aircraft control during an aggressive maneuver that resulted in a nose down collision with terrain.NTSB ERA19WA203Incident · No injuriesForeign investigationCanadair CL600 1A11 · Rio de Janeiro, BrazilThe government of Brazil has notified the NTSB of an incident involving a Canadair CL600 1A11 airplane that occurred on April 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB GAA19CA216Accident · No injuriesData collectionFinal reportBell 47G · Donna, TXThe pilot's failure to maintain altitude during an agricultural application flight.NTSB GAA19CA212Accident · Minor injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe pilot's failure to maintain lateral control during landing and his exceedance of the airplane’s critical angle of attack during the subsequent aborted landing, which resulted in an aerodynamic stall.NTSB WPR19LA112Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Morganza, LAA loss of aircraft control due to the separation of the elevator pushrod attachment bolt.NTSB WPR19LA111Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopter 369 · Hauula, HIFuel exhaustion as a result of the pilot’s fuel burn miscalculation. Contributing to the accident was the inoperative caution light indicating low fuel level.NTSB WPR19FA109Accident · 2 fatalClass 3 · FieldFinal reportBell 206 · Fort McDowell, AZThe separation of the main rotor head from the mast as a result of a sudden displacement of the cyclic stick during a low-G maneuver, leading to mast bumping. Contributing to the accident were the unsecure positioning of the flight test engineer’s laptop…NTSB GAA19WA210Accident · 6 fatalForeign investigationBritten Norman BN2A · Marcel Marchant (SCPF), ChileThe government of Chile has notified the NTSB of an accident involving a BRITTEN NORMAN BN2A airplane that occurred on April 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the…NTSB GAA19CA211Accident · No injuriesData collectionFinal reportTubbs S/Performance Air PA-18-225 · Denver, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB CEN19LA121Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Omaha, NEA partial loss of engine power for reasons that could not be determined based on the available evidence.