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 ENG08IA025IncidentIncident investigationFinal reportBoeing MD-11 · Singapore, SingaporeThe Center Landing gear (CLG) strut failed due to intergranular (IG) cracking resulted from a contamination of the surface from the chemical used to clean that area prior to painting.NTSB DFW08CA120Accident · No injuriesData collectionFinal reportHughes 269A · Lincoln, NEThe pilot's failure to properly execute a steep approach, which resulted in a tail strike and a loss of control.NTSB CHI08CA117Accident · No injuriesData collectionFinal reportCessna 182D · Madison, INThe inadequate preflight inspection of the landing gear tires by the pilot, which did not identify a worn tire and resulted in a flat tire during landing touchdown. An additional cause was the directional control not possible during the landing rollout, and…NTSB CHI08CA116Accident · Minor injuriesData collectionFinal reportMooney M20J · Howell, MIThe inadvertent stall and low airspeed while maneuvering back to the departure airport after the baggage door opened in flight. An additional cause was the plot's diverted attention to the opening of the baggage door.NTSB SEA08LA114Accident · No injuriesLimited investigationFinal reportCanup Titan Tornado S · Council, IDThe failure of the tip of the wood propeller due to damage caused by a foreign object.NTSB SEA08CA112Accident · No injuriesData collectionFinal reportCessna 185E · Bend, ORThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control. Contributing to the accident was an unexpected crosswind gust.NTSB LAX08CA123Accident · Minor injuriesData collectionFinal reportErvin SHA Glasair · Elk Creek, CAThe pilot's misjudged landing flare, inadequate bounced landing recovery technique, and failure to attain and maintain an adquate airspeed during an aborted landing. Contributing to the accident was the short runway.NTSB DFW08LA118Accident · No injuriesLimited investigationFinal reportVickers Spitfire · Galveston, TXThe Hurricane pilot's failure to maintain directional control during roll-out. Contributing factors were the restricted forward visibility of the tail-wheel equipped Spitfire, the lack of communication to the other aircraft following the Hurricane, and the…NTSB DCA08WA091Accident · 2 fatalForeign investigationRobinson R-44 · Germiston, South AfricaOn April 26, 2008, about 0753 UTC, a Robinson R44, ZS-PWG, an aerial observation flight operated by National Airways Corporation, struck a hangar and collided with the ground during takeoff from Rand Aerodrome, Germiston, South Africa. The pilot and passenger…NTSB ANC08LA058Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Tetlin, AKThe instructor pilot's inadequate supervision of the student, resulting in a loss of control while landing.NTSB LAX08CA096Accident · No injuriesData collectionFinal reportCessna T210N · Coaldale, NVThe pilot's failure to maintain directional control after encountering an unknown object on the dirt runway.NTSB DFW08WA119Accident · 2 fatalClass 5 · ForeignCessna U206 · Ciudad Real, SpainOn April 25, 2008, at approximately 1010 Universal Time Coordinated (UTC), a single-engine Cessna U206, F-GSGT, collided with terrain during landing and was destroyed. The pilot and passenger were fatally injured. The airplane was landing at a private…NTSB DFW08TA128Accident · No injuriesFinal reportBeech C90 · Baton Rouge, LAStructural failure of the right main landing gear torque knee. A contributing factor was the failure to inspect the torque knee at the designated interval.NTSB DFW08CA116Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Carlsbad, NMThe pilot's improper decision to takeoff uphill with full fuel and fuel chemical load. A factor was the pilot's failure to calculate performance data.NTSB SEA08LA110Accident · No injuriesLimited investigationFinal reportCessna 180 · Blanding, UTThe fatigue failure of the right main landing gear leg during the landing roll.NTSB SEA08CA111Accident · Minor injuriesData collectionFinal reportAviat A-1C-200 · Bluff, UTThe pilot's inadequate short-field landing procedure and excessive airspeed that resulted in a landing overrun. Contributing to the accident were gusting unfavorable winds, the short runway, and rocks off the departure end of the strip.NTSB DFW08LA115Accident · No injuriesLimited investigationFinal reportCessna 421C · Sterling, COFailure and separation of the upper and lower right main gear torque links links, which resulted in a loss of directional control on landing roll-out.NTSB CHI08LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Romeo, MIThe misjudged landing flare by the pilot, and the inadequate landing gear inspection/repair procedure used by other maintenance personnel, resulting in the failure of the main landing gear strut during landing.NTSB CHI08IA119Incident · No injuriesIncident investigationFinal reportBombardier CL600-2D24 · Minneapolis, MNThe flying pilot's incorrect use of the thrust lever leading to the dual engine shutdown during taxi. Contributing to the incident was the flying pilot's lack of total experience in the make and model of airplane.NTSB ANC08CA056Accident · No injuriesData collectionFinal reportAeronca 15AC · Anchorage, AKThe pilot's excessive use of brakes during the landing roll. A factor was an excessive taxispeed.NTSB NYC08WA171Accident · 3 fatalForeign investigationPiper PA-46-350P · Parma, ItalyNTSB NYC08LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ellijay, GAA loss of engine power for undetermined reasons.NTSB MIA08CA095Accident · No injuriesData collectionFinal reportChampion 7KCAB · Alexander City, ALThe separation of the right tail wheel spring on landing roll out for undetermined reasons, resulting in a loss of directional control and collision with a ditch.NTSB LAX08FA122Accident · 3 fatalField investigationFinal reportCarlton M. Cadwell Lancair IV-P · Mesa, AZThe pilot's failure to maintain an adequate airspeed during climb out resulting in an aerodynamic stall/spin.NTSB DFW08CA114Accident · No injuriesData collectionFinal reportHughes 269A · Killeen, TXThe pilot's failure to maintain main rotor RPM and a safe rate of descent during the autorotation. A contributing factor was the gusty winds.NTSB DFW08CA113Accident · No injuriesData collectionFinal reportPiper PA-18 · Santa Teresa, NMThe pilot's failure to maintain aircraft control. Contributing to the accident was the strong gusty crosswinds.NTSB NYC08WA262Accident · Minor injuriesForeign investigationSchweizer 269C · Athens, GreeceOn April 22, 2008, about 1500 local time, a Schweizer 269C helicopter, SX-HNB, was substantially damaged during a forced landing near Athens, Greece. The 2 flight crew members sustained minor injuries. Meteorological conditions at the time of the local flight…NTSB NYC08CA169Accident · No injuriesData collectionFinal reportPiper PA-46-350P · Chapel Hill, NCThe pilot's improper recovery from a bounced landing. Contributing to the accident was the gusty wind conditions.NTSB DFW08FA111Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Hemphill, TXA loss of control for undetermined reasons.NTSB NYC08LA165Accident · 1 fatalLimited investigationFinal reportDragon Fly GT-500 · Paris, TNA fuel system configuration that was not in accordance with the engine manufacturer's published guidance, which resulted in a complete loss of engine power due to fuel starvation.NTSB DCA08WA101AccidentForeign investigationCoari, BrazilOn April 21, 2008, an Embraer 110 PT-OCV, operated by Rico Airlines, departed the runway after an emergency landing at Coari, Brazil. In cruise flight the right engine failed, and the pilot secured the left engine. Following the emergency landing, the…NTSB CHI08LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Fairfax, IAFuel exhaustion as a result of the pilot's inadequate preflight inspection and inaccurate fuel calculations.NTSB ANC08LA055Accident · No injuriesLimited investigationFinal reportCessna 180 · Kodiak, AKA loss of control during the landing roll due to a failure or malfunction of the brake system, resulting in a loss of control, and structural damage to the airplane.NTSB NYC08LA164Accident · No injuriesLimited investigationFinal reportBeech G35 · New Smyrna Beach, FLThe pilot's inadvertent encounter with turbulence that was not forcast.NTSB MIA08CA092Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe student pilot's improper recovery from a bounced landing.NTSB LAX08LA118Accident · Serious injuriesLimited investigationFinal reportCessna C175A · Groveland, CAA total loss of engine power due to fuel starvation as a result of a blocked fuel line that was improperly fabricated by the pilot. Also causal was the pilot's excessive ground speed during the taxi tests that resulted in an inadvertent takeoff.NTSB ENG08IA022Incident · No injuriesIncident investigationFinal reportBoeing 747 · Newark, NJAn engine fire in the No. 3 engine due to the failure of, and subsequent flammable fluid leak from, one of three fuel or hydraulic lines located in the engine's accessory raceway that ignited when the fluid came in contact with the hot engine cases.…NTSB DFW08LA108Accident · Serious injuriesLimited investigationFinal reportWoods Challenger II · Corning, ARThe pilot's failure to maintain clearance from transmission lines. A contributing factor was the low altitude selected by the pilot.NTSB DFW08CA124Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Rifle, COThe pilot's failure to maintain control of the airplane on landing. A factor was the crosswind and wind gusts.NTSB DFW08CA109Accident · No injuriesData collectionFinal reportBeech C23 · Santa Fe, NMThe pilot's improper recovery from a bounced landing.NTSB DFW08CA104Accident · Serious injuriesData collectionFinal reportAir Tractor AT-602 · Paragould, ARThe pilot's failure to maintain clearance from electrical wires while maneuvering. Contributing to the accident were binding of the elevator control, inadvertent stall and trees.NTSB DFW08CA103Accident · No injuriesData collectionFinal reportBeech C-23 · De Queen, ARThe pilot's failure to maintain control of the airplane during an aborted landing. Contributing to the accident were the crosswind and the pilot's inadequate compensation for the wind conditions.NTSB CHI08CA112Accident · No injuriesData collectionFinal reportPierson RV-6 · Newark, ILThe partial loss of engine power due to the fracture of the number 4 exhaust valve, and the pilot's decision to shut-down the engine without sufficient altitude to ensure a safe glide path to the runway. Contributing to the accident was the barbed wire fence…NTSB CHI08CA107Accident · No injuriesData collectionFinal reportCessna 182T · Zionsville, INThe pilot's failure to maintain directional control during the crosswind landing. Contributing to the accident were the gusting crosswind and the runway light.NTSB NYC08LA168Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Dansville, NYThe pilot's failure to attain the proper glide path and the flight instructor's delayed remedial action. Contributing to the accident was the encountered headwind.NTSB MIA08CA093Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Ellington, CTThe pilot's failure to perform a go-around when the airplane floated during landing.NTSB LAX08LA121Accident · No injuriesLimited investigationFinal reportCessna 172R · S. Lake Tahoe, CAThe pilot's improper flare and subsequent hard landing. Contributing to the accident were the gusty winds and the high density altitude.NTSB LAX08FA117Accident · No injuriesField investigationFinal reportCessna 510 · Carlsbad, CAThe pilot's misjudgment of speed and distance, resulting in an overshoot of the runway. Contributing to the accident was the pilot's failure to follow the Autopilot Preflight Test Fail checklist and his distraction with a flickering primary flight display…NTSB LAX08CA119Accident · No injuriesData collectionFinal reportCarlson Quickie Q2 · Casper, WYA loss of directional control on landing due to the separation of the wing leveler trim knob and resulting reduced aileron control.NTSB DFW08LA106Accident · Serious injuriesLimited investigationFinal reportTomblingson-Leathers Breezy RLU-1 · Groveton, TXThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed during the forced landing. Contributing factors were the non-suitable terrain for the forced landing and the pilot's lack of experience in the airplane.