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 SEA08LA101Accident · Minor injuriesLimited investigationFinal reportJihlavan KP 5 ASA · Marana, AZThe pilot's failure to maintain an airspeed above stalling speed (Vs) during an emergency landing after takeoff. Contributing to the accident was an inadequate preflight inspection, and the airplane's canopy coming partially open shortly after takeoff.NTSB DCA08WA060Accident · 2 fatalClass 5 · ForeignNeiva NE-821 · Lencois, Bahia, BrazilOn March 31, 2008, a Neiva NE-821, Brazilian manufactured Piper PA31T/T1040, registration PT-VCI, operated by Abaeté Táxi Aéreo as a domestic cargo flight, crashed on approach to Lencois, Brazil. There were 2 fatalities and the airplane was destroyed. The…NTSB SEA08LA100Accident · No injuriesLimited investigationFinal reportCessna 182A · Buckeye, AZA loss of engine power for undetermined reasons. Contributing to the accident was the soft terrain.NTSB NYC08RA149Accident · 5 fatalClass 5 · ForeignCessna 500 · Farnborough, Ke, United KingdomOn March 30, 2008, at 1338 universal coordinated time, a Cessna Citation 500, Bermudian registration VP-BGE, was destroyed when it impacted a residence shortly after takeoff from the Biggin Hill Airport, Farnborough, Kent, United Kingdom. The two flight crew…NTSB LAX08LA089Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Redding, CAA loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel tank selector.NTSB LAX08CA111Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Grand Canyon, AZThe pilot's inadequate compensation for the wind conditions and delay in aborting the takeoff. Contributing to the accident were wind gusts and a crosswind.NTSB ENG08WA048Incident · No injuriesForeign investigationAirbus A321-231 · Lahore, PakistanThe accident is being investigated by the Pakistani Civil Aviation Authority. Further information pertaining to this incident may be obtained from: Headquarters, Civil Aviation Authority Terminal-1, JIAP Karachi-75200 Pakistan Tel.: (92) 21 924 8720 E-mail:…NTSB DFW08LA088Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 9 · Questa, NMThe balloon's encounter with a wind gust/downdraft during landing, which resulted in a hard landing.NTSB SEA08CA099Accident · No injuriesData collectionFinal reportBeechcraft 35-C33A · Prescott, AZFuel starvation due to the pilot's improper preflight and failure to select a tank containing fuel before takeoff.NTSB NYC08LA150Accident · Serious injuriesLimited investigationFinal reportHatle Rans S-12 · Rincon, GAThe pilot's failure to maintain airspeed during initial climb which led to an aerodynamic stall.NTSB MIA08CA085Accident · No injuriesData collectionFinal reportThomas J. Dorsey Searey · Mount Dora, FLThe pilot's failure to verify the position of the landing gear prior to making a water landing.NTSB MIA08CA084Accident · No injuriesData collectionFinal reportGrumman American AA5B · Marlboro, MAThe pilot's inadequate compensation for wind gusts while on final approach.NTSB ENG08WA049Incident · No injuriesForeign investigationBoeing 777-300ER · Azores, PortugalOn March 29, 2008, an Air France 777-300ER, registration number F-GSQT, equipped with two GE90-115B turbofan engines, experienced a self recovering stall during cruise. The engine was brought back to idle power but not shutdown and the airplane diverted to…NTSB DEN08LA069Accident · No injuriesLimited investigationFinal reportCessna P210N · Elizabeth, COthe loss of engine power due to the fatigue failure of the camshaft gear. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB SEA08CA097Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · Phoenix, AZThe pilot's failure to maintain directional control of the airplane during landing.NTSB MIA08LA083Accident · No injuriesLimited investigationFinal reportDouglas D. Turner Vans RV8 · DeLand, FLThe loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB LAX08LA088Accident · Minor injuriesLimited investigationFinal reportBeech F33A · San Diego, CAA loss of engine power due to fuel starvation as a result of the pilot's improper use of the mixture control.NTSB DFW08WA091Accident · No injuriesClass 5 · ForeignBritish Aerospace 800A · Monterrey, MexicoOn March 28, 2008, at 0808 central standard time N167DD, a British Aerospace BAE 125 model 800A was substantially damaged while landing on runway 02 at Aeropuerta de Norte, near Monterrey, Mexico. After landing the crew taxied the airplane to the hanger and…NTSB DFW08LA089Accident · No injuriesLimited investigationFinal reportPiper PA24-260 · Abbeville, LAThe failure of both pilots to see and avoid the other approaching airplane. A contributing factor was the close proximity between the two private airstrips.NTSB DEN08CA068Accident · No injuriesData collectionFinal reportPiper PA-28-150 · Mankato, KSthe student pilot's failure to maintain directional control during the takeoff roll. Contributing factors were the fence and trees.NTSB ANC08WA045Accident · 5 fatalClass 5 · ForeignPiper PA-46-350P · Wainwright, CanadaOn March 28, 2008, about 0815, mountain daylight time, a Piper PA-46-350P airplane, Canadian registration C-FKKH, operated by A.D. Williams Holdings Inc., broke up in-flight, and crashed about 12 kilometers northeast of Wainwright, Alberta, Canada. The…NTSB SEA08LA098Accident · No injuriesLimited investigationFinal reportKenney RV6 · Aurora, ORA propeller malfunction for undetermined reasons.NTSB DFW08IA087Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Houston, TXThe flight crew's improper landing technique for an inoperative anti-skid system resulting in locked brakes and four blown main landing gear tires.NTSB SEA08LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bridger, MTThe pilot failed to maintain situational awareness during the flight. Contributing to the accident were the dark night, the pilot's failure to follow approved navigational procedures for the flight, and the pilot's over reliance on the avionics in the…NTSB SEA08IA096Incident · No injuriesIncident investigationFinal reportRaytheon 1900D · Page, AZThe flight crew’s unprofessional behavior and deviation from standard operating procedures which resulted in an in-flight emergency.NTSB LAX08LA086Accident · No injuriesLimited investigationFinal reportCessna 402 · Henderson, NVThe failure of the left main landing gear torque link assembly for undetermined reasons.NTSB DFW08CA086Accident · No injuriesData collectionFinal reportAir Tractor At-301 · Plains, KSA loss of engine power as a result of a blocked carburetor. A factor was the lack of suitable terrain for the forced landing.NTSB CHI08LA096Accident · No injuriesLimited investigationFinal reportCessna 172R · Monroe, WIThe pilot's decision to land on the wrong runway for the existing wind conditions and his improper recovery from a bounced landing.NTSB CHI08CA098Accident · Minor injuriesData collectionFinal reportMcDonnell Douglas 600N · Waverly, OHThe pilot's improper flare.NTSB CHI08CA094Accident · No injuriesData collectionFinal reportCessna 182 · Traverse City, MIThe unstabalized approach performed by the student pilot and the go-around not performed by the student pilot. Additional causes were the inadequate recovery from a bounced landing and the directional control not obtained by the student pilot. Contributing…NTSB SEA08CA093Accident · Minor injuriesData collectionFinal reportGrumman G-164A · Dayton, WAThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed. A contributing factor was the sudden windshift.NTSB NYC08FA148Accident · 1 fatalField investigationFinal reportPiper PA 28-161 · Venice, FLThe pilot's inflight loss of control for undetermined reasons.NTSB LAX08CA085Accident · No injuriesData collectionFinal reportAyres S2R-600 · Blythe, CAThe pilot's failure to maintain terrain clearance. Contributing factors were the dusk light condition and the pressure the pilot felt to accomplish the flight.NTSB ENG08WA019Incident · No injuriesClass 5 · ForeignBoeing 747-400 · Dhaka, BangladeshOn March 25, 2008 at 0822 Zulu time, an Air Atlanta Icelandic Boeing 747-300, registration number TF-ARS, wet leased to Saudi Arabian Airlines, experienced a fire on the No. 3 engine pylon during the landing rollout at the Dhaka International Airport.…NTSB CHI08CA095Accident · No injuriesData collectionFinal reportPiper PA-34-200T · North Canton, OHThe bird strike during approach for landing.NTSB ANC08CA044Accident · No injuriesData collectionFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain directional control and inadequate compensation for wind conditions during a go-around. Contributing to the accident were wind gusts and a crosswind.NTSB NYC08LA144Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Covington, TNA fire of undetermined origin.NTSB NYC08IA145Incident · No injuriesIncident investigationFinal reportAerospatiale AS355F1 · New York, NYThe pilot's inadequate visual lookout and subsequent failure to maintain clearance from the other helicopter due to his focus on the engine instruments during the initial departure. Contributing to the accident was insufficient helipad spacing.NTSB LAX08LA083Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Genesee, IDThe in-flight failure of the rudder attachment point due to severe corrosion, which made directional control of the airplane not possible during landing.NTSB LAX08CA084Accident · No injuriesData collectionFinal reportPiper PA32-301FT · Honolulu, HIThe pilot's inadequate compensation for the wind conditions and his subsequent failure to maintain an adequate airspeed during landing. A contributing factor was the weather windshear condition.NTSB LAX08CA082Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilot's inadequate compensation for the wind conditions, failure to attain and maintain an adequate airspeed that resulted in a stall mush, and, the subsequent failure to maintain terrain and obstacle clearance during the takeoff initial climb.…NTSB LAX08CA081Accident · No injuriesData collectionFinal reportMaule M-8-235 · Grangeville, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop/swerve. A contributing factor was the pilot's lack of recent experience.NTSB DCA08IA048Incident · No injuriesIncident investigationFinal reportBoeing 757-200 · Richmond, VAThe installed wing panel clips failed due to fatigue, likely caused by the incorrect installation of the fasteners in response to SB 757-57-0027. Contributing to the incorrect installation was the SB's lack of clarity in the instructions and figures on the…NTSB NYC08FA143Accident · 2 fatalField investigationFinal reportBeech BE-76 · Rome, GAThe flight instructor's failure to maintain aircraft control while maneuvering during a simulated engine failure. Contributing to the accident was the flight instructor's lack of total experience as a multiengine flight instructor.NTSB NYC08CA190Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Inverness, FLThe student pilot's improper landing flare and the flight examiner's inadequate remedial action.NTSB NYC08CA147Accident · No injuriesData collectionFinal reportRans S12XL · Wauchula, FLThe malfunction of the fuel line, which resulted in a loss of engine power due to fuel starvation.NTSB DFW08CA085Accident · Minor injuriesData collectionFinal reportCessna 206 · Peyton, COThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning.NTSB DEN08CA067Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA 20-C1 · Pueblo, COthe failure of the student pilot, and then the flight instructor to maintain aircraft control during the landing. Contributing factors were the flight instructor's delayed remedial action, and the crosswind conditions.NTSB DCA08WA056Incident · No injuriesClass 5 · ForeignBoeing 737-800 · Limoges, FranceOn March 21, 2008, a Ryan Air B737-800 overran the runway at Limoges, France during landing. There were 181 people on board with no reported injuries. There was no visible damage to the airplane. The BEA-France is investigating. The NTSB has appointed a…NTSB CHI08CA097Accident · No injuriesData collectionFinal reportHughes 269A · Franklin Furnac, OHThe fuel exhaustion during cruise flight and the unsuitable terrain encountered by the pilot-in-command. A contributing factor was the trees.