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 DEN08LA057Accident · No injuriesLimited investigationFinal reportBeech A45 · Englewood, COThe pilot's improper decision to fly the airplane with a discharged battery, which resulted in a total electrical failure during takeoff climb. Contributing factors were the pilot's inability to verify the landing gear position, and the impact with the runway…NTSB LAX08WA104Incident · No injuriesClass 5 · ForeignBeech 1900D · Jabiru, AustraliaOn February 11, 2008, about 0712 local time, a Beech 1900, Australia registry VH-VAZ, experienced a loss of power in one engine and returned to the departure airport at Jabiru, NT, Australia, for landing. The two flight crewmembers and passengers were not…NTSB CHI08FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310N · Keflavík, IcelandThe reported loss of both engines' power during cruise for undetermined reasons.NTSB SEA08LA079Accident · No injuriesLimited investigationFinal reportCessna P210N · Carefree, AZThe collapse of the landing gear during landing rollout for undetermined reasons.NTSB SEA08CA074Accident · No injuriesData collectionFinal reportMaule M-7-235 · Red Lodge, MTThe pilot's inadequate compensation for the crosswind and failure to maintain directional control during the landing roll.NTSB NYC08CA098Accident · No injuriesData collectionFinal reportBeech 23 · Pineland, FLThe pilot's failure to maintain directional control of the airplane during the landing. Contributing was the gusting wind conditions.NTSB NYC08CA096Accident · No injuriesData collectionFinal reportMaule M-7-260C · Cumming, GAThe pilot's failure to maintain directional control during an aborted landing. Contributing to the accident were the gusty crosswind conditions.NTSB ENG08WA013Incident · No injuriesClass 5 · ForeignBoeing 737-217 · Cusco, PeruOn February 10, 2008, at 12:48 local, an AeroCondor Boeing 737-217, registered in Peru as OB-1843-P, had a rejected takeoff at Aeropuerto Velasco Astete, Cusco, Peru. According to the Peruvian CIAA's report, the pilots rejected the takeoff at around 95 knots…NTSB DFW08LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Spring, TXFailure of the pilot to ensure that the fuel system was purged of water prior to flight. Contributing to the severity of injuries was the lack of shoulder restraints.NTSB DFW08CA069Accident · No injuriesData collectionFinal reportPiper J3C-65 · Shallowater, TXFailure of the pilot to maintain a safe clearance from the terrain while manuevering for the landing surface.NTSB DCA08WA069Accident · Serious injuriesForeign investigationBoeing B737-300 · Kansai, JapanOn February 10, 2008, about 1915 local time, a Boeing 737-300, registration B2906, operating as Air China flight 161, encountered turbulence while en cruise flight about 70 nautical miles north west of Osaka-Kansai Airport, Osaka, Japan, while on a flight…NTSB SEA08LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Piru, CAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and dark night conditions.NTSB SEA08CA075Accident · No injuriesData collectionFinal reportCessna 140 · Logan, UTThe dual-student's excessive brake application, and the flight instructor's inadequate supervision of the flight.NTSB NYC08CA097Accident · Minor injuriesData collectionFinal reportChristen Industries Eagle II · Boone, NCThe pilot's failure to maintain clearance/altitude while on the final leg of the traffic pattern. Contributing to the accident were the proximity of the trees to the threshold, and the lack of a displaced threshold.NTSB MIA08CA054Accident · Serious injuriesData collectionFinal reportCessna 177RG · Tallahassee, FLPilot's inaccurate fuel management resulting in fuel exhaustion.NTSB DFW08CA067Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Dallas, TXThe pilot's delay in aborting the landing.NTSB DEN08LA065Accident · No injuriesLimited investigationFinal reportPlocher SHA-Glasair · Telluride, COThe pilot's improper flare and his failure to maintain aircraft control, resulting in the design stress limits of the nose gear being exceeded. Contributing factors in this accident was the excessive airspeed, the pilot-induced porpoise of the airplane, and…NTSB DEN08CA056Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Alamogordo, NMThe unsuitable terrain for landing. Contributing to the accident were the pilot's encounter with turbulence and the loss of visual contact with the tow plane.NTSB SEA08LA072Accident · 3 fatalLimited investigationFinal reportWooters Lancair ES · Albany, ORThe pilot-in-command's failure to maintain aircraft control while in cruise flight. Contributing to the accident were inadequate planning/decision, icing conditions, and continued flight into known icing conditions.NTSB SEA08FA071Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas 369E · Hilo, HIA leak in the fuel filter pressure differential switch that resulted in a loss of engine power. Contributing to the accident was uneven terrain that hindered a successful emergency landing.NTSB SEA08CA077Accident · No injuriesData collectionFinal reportCessna 172SP · Mesa, AZan in-flight collision with a bird.NTSB NYC08CA095Accident · No injuriesData collectionFinal reportSonex Waiex · New Smyrna Bch., FLThe pilot's failure to maintain directional control during the takeoff. Contributing was the crosswind.NTSB MIA08CA055Accident · Minor injuriesData collectionFinal reportWilliam P. Crowell Genesis · Warm Springs, GAThe failure of the pilot to maintain directional control of the airplane during final approach.NTSB DFW08TA066Accident · Minor injuriesFinal reportHughes OH-6 · Valentine, TXThe contract mechanic's failure to properly secure the castellated nut that attached the governor lever control rod to the idler bell crank. Contributing to the accident was the lack of maintenance oversight by the operator.NTSB DFW08LA065Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Antonio, TXSeparation of the turbocharger exhaust stack, which resulted in a loss of engine power.NTSB DFW08CA093Accident · No injuriesData collectionFinal reportCessna 152 · Arlington, TXThe student pilot's improper landing flare resulting in a hard landing. Contributing to the accident were the gusty surface winds and the student pilot's inadequate preflight planning.NTSB DFW08CA064Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Houston, TXThe student pilot's improper use of the collective and the flight instructor's delayed remedial action, which resulted in a dynamic rollover.NTSB DEN08WA062Accident · 2 fatalClass 5 · ForeignBell 206B · Totes Gebirge, AustriaOn February 8, 2008, at 0830 UTC, a Bell 206B, Austrian registration OE-XRH, serial number 2795, was destroyed when the helicopter struck a cableway cable while maneuvering in mountainous terrain, and subsequently impacted terrain in the vicinity of Totes…NTSB CHI08LA080Accident · 1 fatalLimited investigationFinal reportCessna 140 · Grand Meadow, MNThe pilot's continued visual flight into an area of known instrument meteorological conditions in an airplane not equipped for instrument flight, and his failure to maintain control of the airplane while maneuvering at low altitude.NTSB CHI08CA079Accident · No injuriesData collectionFinal reportCessna 172RG · Litchfield, ILThe pilot's intentional low altitude flight and his failure to maintain clearance from the static wire. Contributing to the accident were the static wire, the partial loss of engine power due to propeller vibration, and the muddy field in which the forced…NTSB CHI08CA078Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Cahokia, ILThe flight instructor's failure to correct for proper runway alignment during final approach and his failure to maintain aircraft control during his subsequent go-around. Contributing to the accident was the dual-student's failure to properly align with the…NTSB OPS08IA006Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · St. Augustine, FLThe pilot's failure to adhere to the controller's takeoff instruction. Contributing to the incident was the controller's failure to properly monitor the flight, and the controller's decision to perform lesser duty priorities during the takeoff roll.NTSB MIA08LA053Accident · No injuriesLimited investigationFinal reportCessna C-172RG · Chamblee, GAA cracked nose gear actuator o-ring resulting in hydraulic fluid exhaustion, and collapse of the main gear.NTSB ANC08CA036Accident · No injuriesData collectionFinal reportCessna 207 · Chefornak, AKThe pilot's failure to maintain control of the airplane during the landing flare/touchdown.NTSB DFW08FA062Accident · 3 fatalField investigationFinal reportEurocopter France AS350B2 · S. Padre Island, TXThe pilot's failure to maintain aircraft control resulting in the helicopter impacting the water. Factors contributing to the accident were the pilot's inadvertent flight into instrument meteorological conditions, the low ceiling, dark night conditions, and…NTSB DFW08CA071Incident · No injuriesData collectionFinal reportCessna 172S · Austin, TXThe pilot's failure to maintain control of the airplane while parked on the ramp with the engine running.NTSB CHI08CA076Accident · No injuriesData collectionFinal reportAmerican AA-1A · Grantsburg, WIThe seizure of the left brake due to a buildup of ice between the rotor and brake pad. Contributing to the accident was the snow and slush covered runway, and the snowbank.NTSB DFW08FA061Accident · 1 fatalField investigationFinal reportCessna 210 · Baytown, TXThe pilot's failure to maintain aircraft control after flying into clouds.NTSB CHI08CA074Accident · No injuriesData collectionFinal reportSwearingen SA-226AT · Ankeny, IAThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the snow on the runway and the snowbank.NTSB ANC08CA034Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · McGrath, AKThe pilot's failure to maintain directional control of the airplane during an aborted takeoff.NTSB SEA08LA069Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Parowan, UTThe pilot's improper in-flight decision not to over fly/inspect the snow covered runway prior to landing, and his failure to align the airplane over the centerline of the runway. Contributing to the accident was the snow covered runway, the airport operator's…NTSB NYC08CA092Accident · Minor injuriesData collectionFinal reportKral Series 5 Kitfox · Fruitland Park, FLThe pilot's failure to maintain adequate clearance from obstructions during the landing approach. Contributing to the accident was the reduced visibility due to sunglare and haze.NTSB MIA08FA052Accident · 1 fatalField investigationFinal reportKaylor J E/Strahlmann R L RV-4 · Elkin, NCThe pilot's decision to attempt an aerobatic maneuver in close proximity to the ground.NTSB LAX08CA057Accident · No injuriesData collectionFinal reportRobinson R44 II · Bullhead City, AZThe pilot's misjudged landing flare, inadequate bounced landing recovery, and failure to maintain directional control during a bounced landing that resulted in the tail rotor blades colliding with a hangar. Contributing to the accident was the burned out…NTSB ENG08WA014IncidentForeign investigationBoeing 737 · Nurnberg, GermanyOn February 3, 2008, at 13:30 UTC, a SAS Boeing 737-600, LN-RRR, reported three hydraulic pumps failed during cruise flight. The aircraft diverted to Nurnberg, Germany. There were no injuries, and no damage to the aircraft. The accident is being investigated…NTSB DFW08CA070Accident · No injuriesData collectionFinal reportCessna 172S · Jenks, OKThe owner of the parking surface's failure to ensure that the parking surface was clear of hazards to taxiing airplanes and the pilot's failure to ensure a safe taxi route in unfamiliar surroundings.NTSB DEN08LA055Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-8-202 · Denver, COThe encounter with severe turbulence causing serious injury to the flight attendant.NTSB CHI08CA073Accident · Serious injuriesData collectionFinal reportSquier Pauper II · Stockbridge, WIThe pilot's spatial disorientation while maneuvering after takeoff and his subsequent failure to maintain clearance from the terrain. Contributing factors were the snow-covered lake and overcast clouds, which resulted in the pilot's spatial disorientation due…NTSB SEA08LA070Accident · 1 fatalLimited investigationFinal reportKidd Chris Harmon ROC · Maricopa, CAThe pilot's failure to maintain an adequate terrain clearance altitude while maneuvering in mountainous, hilly terrain. Contributing to the accident were hilly terrain, a low ceiling and gusty winds.NTSB SEA08LA068Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Mukilteo, WALoss of engine power while on final approach for undetermined reasons. Contributing to the accident was a power line.