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 DCA22WA054IncidentClass 5 · ForeignBoeing 777 · Dubai, United Arab EmiratesNTSB GAA22WA180Accident · Minor injuriesClass 5 · ForeignBell 206 · Santa Ana Mountain, ColombiaNTSB GAA22WA063Accident · 4 fatalClass 4 · ForeignRockwell 114 · Redcliffe, AustraliaNTSB GAA22WA055Accident · Minor injuriesClass 5 · ForeignMcdonnell Douglas 500 · Unteriberg, SwitzerlandNTSB GAA22WA052Accident · 1 fatalClass 5 · ForeignPiper 25-260 · Vereda Aparco, Ibague, ColombiaNTSB DCA22WA083AccidentClass 5 · ForeignDouglas DC9 · Diffa, NigerNTSB CEN22FA080Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Bloomington, INThe pilot’s failure to follow the instrument landing system (ILS) course guidance, which resulted in the pilot’s loss of airplane control during the instrument approach. Contributing to the accident was the presence of turbulence and low-level wind shear.NTSB GAA22WA051Accident · No injuriesClass 3 · ForeignRobinson R66 · Boca de Yuma, Dominican RepublicNTSB ERA22LA090Accident · 2 fatalClass 3 · LimitedFinal reportAerofab Lake LA-4-250 · Auburndale, FLA bird strike, which resulted in a loss of control while flying at low altitude over a lake.NTSB WPR22LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Ivanhoe, CAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB ERA22LA089Accident · 1 fatalClass 3 · LimitedFinal reportCirrus Design SR22 · Knoxville, TNThe pilot’s encounter with a wake vortex from a preceding airplane, which resulted in a roll upset at an altitude too low for recovery. Contributing to the accident was the failure of ATC to issue a wake turbulence cautionary advisory.NTSB CEN22LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Houston, TXThe instructed pilot and the flight instructor’s failure to extend the landing gear before landing resulting in a wheels up landing.NTSB GAA22WA076Accident · No injuriesClass 5 · ForeignCessna 172 · Pallisa-KAGWARA, UgandaNTSB GAA22WA050Accident · 9 fatalClass 5 · ForeignGulfstream GIV · Santo Domingo, Dominican RepublicNTSB ANC22LA011Accident · No injuriesClass 3 · LimitedFinal reportLarry Bingham LB-1 · Haines, AKA partial loss of engine power for reasons that could not be determined based on available information, which resulted in a precautionary landing and impact with snow.NTSB ENG22WA048Accident · No injuriesClass 4 · ForeignEmbraer EMB500 · Santa Rosa, BrazilNTSB CEN22LA078Accident · Minor injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Bridgeport, TXThe pilot’s failure to maintain adequate main rotor RPM during an autorotation which resulted in a hard landing. Contributing to the accident was the pilot’s improper placement of the throttle during the initial practice power-on recovery autorotation.NTSB CEN22LA077Accident · No injuriesClass 4 · LimitedFinal reportHughes 269A · Crowley, TXThe student pilot’s encounter with a loss of tail rotor effectiveness during hover, and the flight instructor’s delayed remedial action that resulted in an emergency landing and impact with terrain.NTSB CEN22FA073Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · LaPlace, LAThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the pilot’s decision to fly in instrument conditions.NTSB ERA22LA091Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 429 · Manhattan, NYThe pilots overapplication of flight controls during landing, which resulted in the rotor blades contacting the wire strike protection system and subsequent hard landing.NTSB DCA22WA051Incident · No injuriesClass 5 · ForeignBoeing 737 · West Sumatera, IndonesiaNTSB DCA22LA044Accident · No injuriesClass 4 · LimitedFinal reportAirbus A320-251N · Paradise, NVThe captain’s failure to maintain proper pitch attitude during landing, likely caused by improper seat position.NTSB CEN22LA079Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Ellinwood, KSThe pilot's improper brake application during the landing roll, which resulted in a nose-over.NTSB CEN22LA074Accident · No injuriesClass 4 · LimitedFinal reportMini-MAX 1600R Sport · South Bend, INThe pilot’s low-level flight and poor visual lookout which resulted in collision with a light pole on final approach and the pilot’s improper decision to operate an airplane under the influence of alcohol.NTSB GAA22WA049Accident · 1 fatalClass 5 · ForeignRans S12 · Szadek, PolandNTSB ERA22LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Hazleton, PAThe pilot’s failure to maintain proper airspeed on approach in tailwind conditions, which resulted in an extended touchdown, bounced landing, and runway excursion.NTSB CEN22LA072Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL18 · Abbeville, LAAn electrical fire for reasons that could not be determined.NTSB CEN22FA070Accident · 1 fatalClass 3 · FieldFinal reportCessna 310J · Inola, OKThe loss of airplane control for reasons that could not be determined based on the available evidence.NTSB WPR22LA062Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Temecula, CAThe total loss of engine power for reasons that could not be determined from the available evidence.NTSB WPR22LA061Accident · 1 fatalClass 3 · LimitedFinal reportMoul Willis RV-3 · Bermuda Dunes, CAThe pilot’s improper positioning of the fuel shutoff valve, which resulted in a loss of engine power, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.NTSB GAA22WA046Accident · No injuriesClass 5 · ForeignSchweizer 269C · Silesian, PolandNTSB GAA22WA044Accident · No injuriesClass 5 · ForeignBell 206 · Midrand, South AfricaNTSB ERA22LA108Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Lake City, FLThe pilot’s loss of control during the landing flare, which resulted in a runway excursion.NTSB ERA22FA086Accident · 1 fatalClass 3 · FieldFinal reportSwearingen SA226 · Bedford, NHThe pilot’s failure to secure and feather the left engine and increase power on the right engine after a perceived loss of engine power in the left engine, which resulted in a loss of control and impact with terrain just short of the runway. Contributing to…NTSB DCA22WA050AccidentClass 5 · ForeignBoeing 737 · Dublin, IrelandNTSB CEN22FA069Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Steamboat Springs, COThe pilot’s failure to adhere to the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB GAA22WA045Accident · Minor injuriesClass 5 · ForeignCessna 172 · Trinidad, BoliviaNTSB GAA22WA043Accident · 1 fatalClass 5 · ForeignRobinson R66 · Mrassu, RussiaNTSB ERA22FA085Accident · 2 fatalClass 3 · FieldFinal reportBeech V35 · Crab Orchard, KYThe noninstrument-rated pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control and collision with terrain. Contributing to the accident was…NTSB DCA22WA079IncidentClass 5 · ForeignBeech 1900 · Lorraine, FranceNTSB DCA22WA049AccidentClass 5 · ForeignBoeing 737 · Santiago de Compostela, SpainNTSB WPR22LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Hillsboro, ORThe on-ground collision with a tree during an off airport precautionary landing. Contributing was the partial loss of engine power for undetermined reasons.NTSB CEN22LA076Accident · Serious injuriesClass 3 · LimitedFinal reportAviat A-1A · St. Jo, TXThe total loss of engine power due to carburetor icing during cruise flight, which resulted in a forced landing and impact with terrain.NTSB CEN22LA075Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Rockwall, TXThe pilot’s failure to go-around during the unstable visual approach, which resulted in a bounced touchdown near the end of the runway and the subsequent runway excursion.NTSB CEN22LA068Accident · Serious injuriesClass 4 · LimitedFinal reportCHR International Safari 400 · McKinney, TXThe pilot did not remove the cyclic control lock during preflight, which resulted in a loss of control during the initial hover.NTSB CEN22FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 28-140 · Houston, TXThe student pilot’s decision to depart into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB GAA22WA047Accident · No injuriesClass 5 · ForeignMooney M20B · La Aurora, GuatemalaNTSB ERA22FA083Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Statesboro, GAThe pilot’s decision to initiate a visual flight rules flight into dark night instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control shortly after takeoff.NTSB CEN22LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Delta, COFuel starvation resulting in a loss of engine power.NTSB CEN22FA064Accident · 1 fatalClass 3 · FieldFinal reportVans RV-4 · Walsenburg, COThe pilot’s failure to maintain clearance from terrain while intentionally maneuvering in a canyon at low altitude. Contributing to the accident was the pilot’s decision to enter a canyon environment at a low altitude, and the sudden change in wind conditions…