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 CEN21LA289Accident · No injuriesClass 4 · LimitedFinal reportBeech H35 · Watkins, COThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and a subsequent impact with an obstacle.NTSB WPR21LA237Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182P · Warren, IDThe pilot's decision to continue the approach for landing with excess airspeed, which resulted in an aborted landing and subsequent collision with trees.NTSB GAA21WA182Accident · Minor injuriesClass 5 · ForeignPiper PA34 · San Pedro Sula, HondurasNTSB ERA21FA263Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Mercer, TNA partial loss of engine power due to foreign object debris contamination of the left turbocharger wastegate. Contributing to the accident was the pilot’s failure to divert to the nearest airport.NTSB DCA21WA165IncidentClass 5 · ForeignBoeing 787-9 · Sydney, AustraliaNTSB CEN21LA286Accident · Minor injuriesClass 3 · LimitedFinal reportAyres S2R-T34 · Leoti, KSThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in his inability to maintain airplane control during low-level flight and an impact with terrain. Contributing to the accident was the…NTSB WPR21LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Moose Creek Ranger Station, IDThe pilot’s improper landing flare which resulted in a bounced hard landing and subsequent nose over.NTSB WPR21LA239Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · West Glacier, MTThe pilot’s inadequate performance planning and decision to continue the takeoff which, resulted in a runway overrun and collision with terrain.NTSB WPR21LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Twisp, WAAn in-flight separation of the control stick from the torque tube assembly, which resulted in a loss of directional control during the landing roll and subsequent on-ground collision.NTSB WPR21LA235Accident · Minor injuriesClass 4 · LimitedFinal reportHPH Glasflugel · Winthrop, WAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB WPR21FA233Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-22-135 · White City, ORThe pilot’s failure to maintain control of the airplane during a go-around, which resulted in a collision with trees. Contributing to the accident was the pilot’s impairment due to his medical conditions and the effects of his medications.NTSB WPR21FA232Accident · 1 fatalClass 3 · FieldFinal reportKitfox Series 6 · Likely, CAThe pilot’s poor decision making in attempting a takeoff from a field with high vegetation and a high-density altitude, which resulted in decreased takeoff performance and impact with terrain.NTSB GAA21WA147Accident · 2 fatalClass 5 · ForeignNorth American T28 · Jickovice, CzechiaNTSB ERA21LA259Accident · No injuriesClass 4 · LimitedFinal reportMaule M5 · Annapolis, MDThe pilot’s failure to maintain directional control during landing.NTSB CEN21LA301Accident · No injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Wilmington, OHThe pilot’s failure to maintain directional control during takeoff with gusting winds, which resulted in an inflight collision with a fence.NTSB CEN21LA287Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Sedgwick, ARThe total loss of engine power due to the failure and disengagement of the torque sensor assembly front spur gear from its splined shouldered shaft due to a loose self-locking nut.NTSB CEN21LA283Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Edwardsburg, MIThe pilot’s failure to identify rising terrain and to maintain terrain clearance from trees during an aerial application pass that resulted in an in-flight collision with trees and terrain.NTSB CEN21LA281Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-35 · Wellington, COThe glider pilot’s loss of visual references during the landing approach resulting in an off-airport landing on rough sloping terrain.NTSB GAA21WA161Accident · 1 fatalClass 4 · ForeignBeech V35 · Padua, ItalyNTSB CEN21LA279Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Portland, INThe airplane’s collision with a deer on the runway during landing.NTSB WPR21FA231Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Rush Valley, UTThe pilot’s misidentification of a mountain pass at night, which resulted in controlled flight into terrain. Contributing to the accident were the pilot’s overconfidence based on her previous aviation experience and fatigue due to both the time of the flight…NTSB GAA21WA151Accident · No injuriesClass 5 · ForeignCessna 188 · Bataypora, BrazilNTSB ERA21LA262Accident · Serious injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Swan Lake, NYThe pilot's failure to maintain adequate clearance from the power transmission tower structure during powerline maintenance work, which resulted in the helicopter's main rotor striking the lifeline support bracket for the tower catwalk and the subsequent loss…NTSB ERA21LA261Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jupiter, FLThe flight instructor’s failure to obtain the proper touchdown point during a forced landing. Contributing to the accident was the improper service and subsequent inadequate inspection of the single-drive, dual magneto, which resulted in a total loss of…NTSB ERA21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Yulee, FLThe flight instructor’s decision to conduct slow flight training at an altitude below the flight school’s minimum recovery altitude and his delayed remedial action when an aerodynamic stall occurred.NTSB ERA21FA257Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-402B · Kinston, NCThe pilot’s decision to conduct low-level aerobatic maneuvers in an airplane not approved for aerobatic flight, which resulted in an aerodynamic stall and spin, a loss of control, and an impact with terrain.NTSB ENG21WA028Accident · Minor injuriesClass 5 · ForeignBoeing 787 · London, United KingdomNTSB CEN21LA280Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Hayward, WIThe pilot's failure to maintain directional control during landing with gusting wind.NTSB CEN21FA277Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR20 · Conway, ARThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and spin. Contributing to the accident was the failure of the pilot to perform an adequate preflight inspection, to include removal of the pitot tube cover.NTSB GAA21WA145Accident · 1 fatalClass 5 · ForeignRobinson R44 · Eidanger, NorwayNTSB ERA21LA314Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Clarksville, TNThe flight instructor’s inadequate remedial action during takeoff, which resulted in a runway excursion.NTSB ERA21LA276Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26E · Willimantic, CTThe failure of the student to achieve the proper touchdown point resulting in landing undershoot.NTSB ERA21LA260Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 8KCAB · Argyle, NYThe pilot’s failure to maintain adequate airspeed during landing, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB ERA21LA256Accident · No injuriesClass 4 · LimitedFinal reportWare Jerry L Aventura II · DeLand, FLA landing gear collapse after the airplane struck a hole during an off-runway precautionary landing.NTSB CEN21LA278Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Bridgeport, TXThe pilot’s inaccurate estimate of the fuel level during his preflight inspection, which resulted in fuel exhaustion during cruise flight and a total loss of engine power.NTSB CEN21LA274Accident · Minor injuriesClass 3 · LimitedFinal reportBeech U-8F · Goodland, KSMaintenance personnel’s inadequate inspection of the airplane, which failed to detect and correct chafed electrical wiring and a degraded fuel bladder with holes, which resulted in ignition of fuel vapor and a right wing explosion.NTSB ERA21LA254Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Ozark, ALThe pilot's failure to maintain directional control during a crosswind landing, which resulted in a runway excursion.NTSB DCA21WA159Accident · No injuriesClass 5 · ForeignBoeing 737 · Derbyshire, United KingdomNTSB CEN21LA276Accident · No injuriesClass 3 · LimitedFinal reportAutogyro Cavalon · Collinsville, TXThe total loss of engine power due to the failure of both fuel pumps, which resulted in fuel starvation. The reason for the failure of both fuel pumps could not be determined based on available evidence.NTSB CEN21LA275Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 11AC · Baltimore, OHThe pilot’s loss of directional control during landing.NTSB CEN21LA273Accident · No injuriesClass 3 · LimitedFinal reportTony Dubeansky RV10 · Fort Worth, TXA partial loss of engine power due to a separated electronic ignition system connector. Contributing to the accident was the location of the ignition boxes, which provided limited access to the connectors for visual inspection.NTSB CEN21FA272Accident · 2 fatalClass 3 · FieldFinal reportAntenor Velazco Lancair Evolution · Parker, COThe pilot’s diversion of attention following an asymmetric flap deployment, which resulted in a descent and collision with powerlines. Contributing to the accident was maintenance personnel’s failure to properly secure the flap control rod attachment bolts,…NTSB WPR21LA236Accident · No injuriesClass 4 · LimitedFinal reportBell UH-1H · Townsend, MTThe pilot’s failure to maintain helicopter control after an encounter with settling with power during approach at an altitude that was too low for recovery, which resulted in a hard landing.NTSB WPR21FA228Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR20 · Truckee, CAThe student pilot’s exceedance of the airplane’s critical angle of attack during a turn and the flight instructor’s delayed remedial action, resulting in an aerodynamic stall and a subsequent impact with terrain.NTSB WPR21FA227Accident · 1 fatalClass 3 · FieldFinal reportCovey Tri Quickie · Gila Bend, AZThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the reduced airplane performance due to high density…NTSB ERA21FA253Accident · 1 fatalClass 3 · FieldFinal reportVans RV6 · Buckingham, PAAn exhaust system leak that resulted in failure of the oil quick drain, a loss of oil lubrication, an in-flight fire, and the pilot’s subsequent loss of airplane control.NTSB CEN21FA270Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor 502B · Paragould, ARAn inflight loss of control and subsequent impact with terrain during an aerial application flight for reasons that could not be determined based on the available evidence.NTSB ERA21LA252Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Sylva, NCThe pilot’s intentional departure from the procedures published in the manufacturer’s flight training guide, and his subsequent loss of engine rpm, rotor rpm, and aircraft control.NTSB ERA21LA250Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA20 · Matthews, VAThe mechanic’s failure to properly secure the oil sump drain plug during a 100-hour maintenance inspection, which resulted in a total loss of engine power due to oil starvation.NTSB CEN21LA271Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210L · Buena Vista, COThe partial loss of engine power due to a vane failure in the engine-driven fuel pump.