NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 OPS06IA008Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILThe failure of the ORD tower south local controller to monitor Atlas Air flight 6972 on arrival to runway 14R and subsequently clearing United Airlines flight 1015 for takeoff on intersecting runway 27L causing a loss of separation between the two aircraft.NTSB NYC06LA191Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135LR · Newark, NJThe captain's failure to follow company procedures, which resulted in pushback with the parking brake set. A factor was the larger than preferred tug.NTSB ENG06WA033Incident · No injuriesForeign investigationAirbus Industrie A320 · Islamabad, PakistanNTSB DCA06WA056Incident · Minor injuriesForeign investigationBoeing B767-200 · Cancun, MexicoNTSB CHI06WA231Accident · No injuriesForeign investigationCirrus Design SR-22 · Mantena, BrazilNTSB CHI06LA211Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · New Market, MNA loss of engine power due to the fatigue fracture of the crankshaft and camshaft gear teeth during cruise flight and the unsuitable landing area encountered by the pilot during the forced landing.NTSB CHI06FA184Accident · 1 fatalField investigationFinal reportCessna 172F · Brookville, INThe in-flight loss of engine power during cruise flight due to restricted fuel flow and the inadequate preflight the pilot performed. An additional cause was the trees.NTSB ATL06LA111Accident · 1 fatalLimited investigationFinal reportCanadair F86 · Hickory, NCThe pilot's improper assembly of the airplanes brakes, exceeding the authorized gross weight of the airplane at takeoff, and the pilot's failure to abort the takeoff in sufficient time to avoid an on-ground collision with fixed objects. A factor in the…NTSB ATL06LA110Accident · 1 fatalLimited investigationFinal reportArter RV6 · Hartselle, ALThe pilot's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and collision with trees and the ground. Factor in the accident were the pilot's ostentatious display and impairment due to alcohol.NTSB ATL06CA112Accident · No injuriesData collectionFinal reportCessna 170B · Griffin, GAAn in-flight encounter with weather on initial take off climb resulting in a loss of directional control and collision with the ground.NTSB ANC06CA097Accident · No injuriesData collectionFinal reportCessna 180 · Anchor Point, AKThe pilot's inadequate compensation for wind conditions, which resulted in a collision with high brush during the landing flare. A factor contributing to the accident was wind gusts.NTSB SEA06CA145Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Lamont, WAThe pilot's failure to maintain terrain clearance while maneuvering.NTSB NYC06LA180Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Vineland, NJA loss of engine power due to foreign object damage for undetermined reasons. Contributing to the accident was the furrowed field.NTSB LAX06LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grass Valley, CAThe loss of available engine power due to vapor lock. A contributing factor was the high temperature.NTSB LAX06LA242Accident · No injuriesLimited investigationFinal reportCessna 182P · Hemet, CAthe shaking and backfiring of the engine for undetermined reasons.NTSB LAX06FA243Accident · 2 fatalField investigationFinal reportRaytheon G36 · Bullhead City, AZThe pilot's misjudged distance and speed that led to a long landing, and his inadequate recovery from a bounced landing, all due to the effects of impairment from alcohol consumption, which resulted in an in-flight collision with terrain during an aborted…NTSB DFW06CA192Accident · No injuriesData collectionFinal reportBeech BE23 · Bowie, TXThe student pilot's failure to maintain clearance from trees. Contributing factors were the prevailing crosswind and improper supervision of the flight by the flight instructor.NTSB CHI06FA196Accident · 2 fatalField investigationFinal reportShaw Europa XS · Oshkosh, WIThe pilot's failure to maintain adequate airspeed on final approach which resulted in a stall.NTSB CHI06CA214Accident · No injuriesData collectionFinal reportRobinson R-44 · Wadsworth, ILThe pilot inadvertently pulled back on the cyclic when birds flew into the windscreen. A factor associated with the accident were the birds.NTSB CHI06CA199Accident · Minor injuriesData collectionFinal reportPorter Mustang II · Ainsworth, NEThe delay in initiating the aborted landing which resulted in inadequate altitude to clear high vegetation off the end of the runway. Factors associated with the accident were the gusty crosswind, inadequate compensation for the wind conditions, and the high…NTSB ANC06LA098Accident · No injuriesLimited investigationFinal reportCessna 402B · Ft. Lauderdale, FLThe pilot's continued flight into adverse weather, and his failure to maintain directional control of the airplane during the landing roll, which resulted in a collision with an airport runway sign, and subsequent collapse of the nose gear. A factor…NTSB ANC06LA095Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Big Lake, AKThe pilot's failure to maintain control of the airplane while step taxiing a float-equipped airplane, which resulted in a collision with an embankment. A factor contributing to the accident was an unfavorable wind.NTSB ANC06CA096Accident · No injuriesData collectionFinal reportPiper PA-12 · Anchorage, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway and colliding with a runway light and the ground. Factors contributing to the accident were an inadvertent ground loop, and the…NTSB MIA06LA130Accident · No injuriesLimited investigationFinal reportCessna 550 · Marathon, FLThe separation for undetermined reasons of the stud (P/N 6541204-5) which secures the main landing gear actuator assembly side brace to the main landing gear outer cylinder, allowing partial collapse of the right main landing gear while taxiing after landing.NTSB LAX06CA248Accident · No injuriesData collectionFinal reportCessna T210N · Truckee, CAthe pilot's inadequate compensation for the existing wind conditions and failure to maintain an adequate airspeed.NTSB DFW06CA190Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Woodworth, LAThe pilot's failure to maintain clearance from a tree. Contributing factors were the sudden wind shift and the gusty wind conditions.NTSB DFW06CA189Accident · Serious injuriesData collectionFinal reportPiper PA19/L-18C · Katy, TXThe pilot's failure to maintain adequate airspeed while maneuvering resulting in an inadvertent stall/spin.NTSB DEN06LA103Accident · 1 fatalLimited investigationFinal reportAyres S2R-G10 · Dexter, NMThe pilot's failure to remain clear of the airplane's propeller resulting in the propeller contacting the pilot and causing fatal injuries to the pilot.NTSB CHI06CA198Accident · Minor injuriesData collectionFinal reportSargent Bushby Mustang II · Troy, MIThe pilot's delayed decision to go-around leading to the impact with the fence during the go-around. A factor was the fence.NTSB CHI06CA197Accident · No injuriesData collectionFinal reportCessna 206H · Lutsen, MNThe unsuitable terrain the pilot encountered during takeoff in rough water. A factor was the wave in the rough water.NTSB ATL06CA109Accident · No injuriesData collectionFinal reportCessna 182L · Eatonton, GAThe CFI's failure to initiate a go-around when he noticed the flight was high during approach resulting in the flight landing long, overrunning the runway , and colliding with trees. Factors in the accident were a wet runway and a tailwind for landing.NTSB NYC06WA182Accident · No injuriesForeign investigationPiper PA-46T · Debrecen, HungaryNTSB CHI06LA208Accident · Serious injuriesLimited investigationFinal reportAerostar International RX 8 · Claremont, MNThe procedure not followed by the passenger during landing and the inadequate supervision of the passenger by the pilot during landing. A contributing factors were the barbed wire fence.NTSB CHI06LA207Accident · Serious injuriesLimited investigationFinal reportSchlei Avid Flyer Speed Win · Fergus Falls, MNthe fractured aileron bell crank and elevator clevis rod end.NTSB ATL06CA106Accident · Serious injuriesData collectionFinal reportCessna 172F · Rome, GAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent impact with the ground.NTSB LAX06LA240Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Show Low, AZthe pilot's failure to maintain directional control during landing.NTSB LAX06CA241Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Greenfield, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the airplane during landing.NTSB CHI06CA195Accident · No injuriesData collectionFinal reportGrumman G-164A · Lakeview, MIA loss of engine power for undetermined reasons. A factor associated with the accident was the low altitude at which the airplane was being operated when the loss of engine power occurred.NTSB CHI06CA194Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Marine City, MIA loss of engine power due to the partial blocked carburetor fuel screen which resulted in partial fuel starvation and the pilot's failure to maintain adequate airspeed during the forced landing which resulted in an inadvertent stall. A factor associated with…NTSB ANC06LA094Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Willow, AKThe pilot's misjudged distance/altitude during landing, which resulted in an undershoot and an in-flight collision with trees.NTSB MIA06LA125Accident · Minor injuriesLimited investigationFinal reportDouglas DC-3 · St. ThomasThe airplane's inability to maintain altitude for undetermined reasons, following a loss of power from the left engine.NTSB LAX06LA236Accident · Serious injuriesLimited investigationFinal reportHammack Air Command Elite · Hilo, HIan in-flight separation of a control rod joint assembly, which resulted in the pilot's loss of control. The underlying reason for the separation could not be determined.NTSB LAX06CA239Accident · No injuriesData collectionFinal reportCessna 177RG · Camarillo, CAthe pilot's failure to extended the landing gear and verify the proper landing gear configuration prior to landing, resulting in a gear-up landing.NTSB LAX06CA237Accident · No injuriesData collectionFinal reportBeech A36 · Bakersfield, CAthe pilot's improper flare, which resulted in a hard landing.NTSB DFW06LA188Accident · 1 fatalLimited investigationFinal reportCessna P210N · Amarillo, TXThe loss of engine power as result of the failure by maintenance personnel to install oil pump support bushings, which resulted in the fracture of the driven-gear and subsequent loss of oil pressure. Contributing factors were the lack of suitable terrain for…NTSB DFW06FA187Accident · 2 fatalField investigationFinal reportCessna 172N · Petal, MSThe pilot's improper use of flaps, which resulted in an impact with trees during takeoff-initial climb.NTSB CHI06FA193Accident · 2 fatalField investigationFinal reportCessna 560 · Cresco, IAThe flight crew's inadequate aeronautical decision-making and poor crew resource management (CRM), including the inadequate use of the on-board sources (such as the flight management system and navigation charts), to get critical information about Ellen…NTSB ANC06LA092Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Deland, FLThe flight instructor's inadequate supervision of the dual student during final approach to land, and his delayed remedial action following a partial loss of engine power on one of the two engines. Factors associated with the accident are the dual student's…NTSB DFW06FA186Accident · 3 fatalField investigationFinal reportBeech BE58P · Jeanerette, LAThe pilot's continued flight into adverse weather condition and his delayed attempt to abort the landing. A contributing factor was the prevailing thunderstorm.NTSB CHI06CA203Accident · No injuriesData collectionFinal reportCessna 182 · Napoleon, MIThe pilot failed to perform a go-around which resulted in landing long on the airstrip. Factors associated with the accident were the tailwind, the pilot's selection of runway direction, the fence posts, the fence, and the trees which were contacted.