NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 ERA15LA135Accident · No injuriesLimited investigationFinal reportCessna 208 · Baltimore, MDThe ground service vehicle operator's failure to yield right of way to the airplane due to distraction, which necessitated the pilot's use of reverse thrust and braking to avoid a collision and resulted in the airplane's empennage striking the ground.NTSB DCA15FA073Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD 11F · St. Louis, MOa partial inflation of the 1L escape slide/raft due to undetermined reasons resulting in insufficient capability to support the weight of the crewmember.NTSB CEN15WA152Accident · 2 fatalForeign investigationAvions Robin Robin DR 400/140 B · Yverdon LSGY, SwitzerlandNTSB WPR15LA111Accident · 1 fatalLimited investigationFinal reportPiper PA46 - 350P · Spokane, WAA total loss of engine power due to the refueler’s incorrect refueling of the airplane. Contributing to the accident was the fixed-base operator’s improper fueling nozzle, which facilitated the use of an incorrect fuel, and the pilot’s inadequate preflight…NTSB WPR15CA114Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Camarillo, CAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN15CA151Accident · No injuriesData collectionFinal reportCessna 172P · Kankakee, ILThe student pilot's improper flight control inputs resulting in the loss of control during the landing flare.NTSB CEN15LA156Accident · No injuriesLimited investigationFinal reportAgusta Aerospace AW119 Mkii · Gulf of MexicoThe fracture of the tail rotor pitch change link due to excessive bearing rotational friction, which resulted from the bearings being installed in exceedance of the maximum allowable torque during the last overhaul of the pitch change link.NTSB CEN15LA149Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Lubbock, TXThe pilot's delayed decision to abort the takeoff after the airplane did not lift off as expected due to an inaccurate airspeed indication and tailwind condition, which resulted in a subsequent runway overrun.NTSB WPR15WA108Accident · 2 fatalForeign investigationRobinson R44 II · Queenstown, New Zealand, New ZealandOn February 19, 2015, at 0244 universal coordinated time, a Robinson R44 II, ZK-IPY, operated by Over the Top Limited, collided with terrain under unknown circumstances near Queenstown, New Zealand. The two occupants on board were fatally injured and the…NTSB WPR15LA109Accident · No injuriesLimited investigationFinal reportBell/Garlick UH 1H · Shelton, WAThe fatigue failure of the engine-to-transmission driveshaft adapter attachment bolt due to the application of inadequate torque on the bolt during assembly.NTSB ERA15WA137Accident · 4 fatalForeign investigationCessna 182P · Bueno Brandao, BrazilOn February 19, 2015, about 1340 Universal Coordinated Time (UTC), a Cessna 182P, Brazilian registration PT-KBV, was destroyed when it broke up inflight and impacted terrain near the Bueno Brandao Municipality, in the State of Minas Gerais, Brazil. The pilot,…NTSB ERA15LA134Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lexington, KYMaintenance personnel's failure to properly inspect and clean the engine ignition harness spark plug terminals, which resulted in a partial loss of engine power during an attempted takeoff.NTSB ERA15LA133Accident · 1 fatalLimited investigationFinal reportJohnson Joel H Rans S-6ES Coyote II · Rincon, PRThe inadequate maintenance and inspection of the fuel system, which resulted in partial blockage of a fuel filter, a partial loss of engine power, and subsequent ditching.NTSB WPR15LA106Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Alfalfa, ORA total loss of engine power after takeoff for reasons that could not be determined, because examination of the engine did not reveal any mechanical anomalies that would have precluded normal operation.NTSB OPS15IA011Incident · No injuriesIncident investigationFinal reportEmbraer EMB 145LR · Chicago, ILThe flight crew's failure to manage cockpit tasks during taxi resulting in a loss of situation awareness and subsequently taxiing past a required turn point and onto an active runway without clearance. Contributing to the runway incursion was the ground…NTSB ENG15RA015Incident · No injuriesForeign investigationBoeing 767 - 204ER · Islamabad, Pakistan, PakistanOn February 15, 2015, a Jordan Air Boeing 767-204ER, leased by Shaheen Air International (SAI), experienced a failure of the No. 1 engine, a General Electric CF6-80A2 turbofan engine, during the takeoff roll from the Islamabad International Airport (ISB),…NTSB WPR15CA112Accident · No injuriesData collectionFinal reportCessna T210 - L · The Dalles, ORThe pilot's failure to extend the landing gear prior to touch down. Contributing to the accident was the pilot's failure to utilize the pre-landing checklist.NTSB CEN15LA147Accident · No injuriesLimited investigationFinal reportPiper PA 31-350 · Chicago, ILThe collapse of the nose and right main landing gears during landing for reasons that could not be determined because examination of the landing gear system revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN15LA144Accident · No injuriesLimited investigationFinal reportBeech 58 · Denver, COThe pilot’s failure to maintain airplane control during a rejected takeoff from a slush-covered runway at night.NTSB WPR15WA124Accident · No injuriesForeign investigationBell 206 - L4 · Wabo, Papua New Guinea, Papua New GuineaOn February 15, 2015, at 1020 local time, a Bell 206 L4, P2-HFZ, experienced a loss of engine power while maneuvering with an external load and subsequently landed hard near Wabo, Papua New Guinea. The helicopter was operated by Helifax Operations Limited…NTSB WPR15LA104Accident · No injuriesLimited investigationFinal reportScottish Bulldog - 120 121 · Hayward, CAA total loss of engine power during the initial climb due to fuel contamination. Contributing to the accident was the pilot’s inadequate preflight inspection of the fuel system.NTSB WPR15IA105Incident · No injuriesIncident investigationFinal reportEvo13 Lancair Evolution · San Carlos, CAThe collapse of the nose landing gear (NLG) due to the separation of the right trunnion pin from the NLG strut as a result of reverse-bending fatigue.NTSB WPR15CA107Accident · No injuriesData collectionFinal reportPiper PA28 - 180 · Garfield, WAThe pilot did not maintain clearance from a power line while maneuvering at a low altitude.NTSB GAA15CA039Accident · Serious injuriesData collectionFinal reportCameron Z90 - NO Series · Bernalillo, NMThe pilot's failure to maintain the descent rate, resulting in abnormal runway/ground contact.NTSB ERA15LA138Accident · No injuriesLimited investigationFinal reportBell 206 · Sevierville, TNAn uncontained engine failure, which resulted from insufficient lubrication of the No. 4 bearing due to carbon buildup on the filter screen of the bearing's oil supply nozzle.NTSB ENG15WA034Incident · No injuriesForeign investigationAirbus A320 · Tehran, IranThe Civil Aviation Organization of the Islamic Republic of Iran (CAO.IRI) has notified the NTSB of an incident involving an Airbus A320-200, which occurred on February 15, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CAO…NTSB DCA15LA067Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Honolulu (Pacific Ocean)an encounter with convective turbulence associated with a forecasted area of thunderstorms.NTSB CEN15WA150Accident · Minor injuriesForeign investigationPiper PA46 500TP · Björnön, SwedenNTSB CEN15CA153Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Asherton, TXThe pilot did not maintain adequate clearance from the trees.NTSB WPR15LA113Accident · No injuriesLimited investigationFinal reportMooney M20E - NO Series · Bakersfield, CAThe collapse of all three landing gear during the takeoff roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR15LA103Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Layton, UTThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight and in-flight fuel planning, which did not account for the increased headwind.NTSB CEN15LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA 28R-180 · Haviland, KSThe loss of torque on the No. 4 cylinder through bolts, which led to the subsequent failure of the piston, the liberation of the connecting rod, the separation of the No. 4 cylinder from the crankcase in cruise flight, and the airplane’s subsequent impact…NTSB ERA15LA130Accident · Serious injuriesLimited investigationFinal reportRobertson James F Velocity STD/RG E · Sebastian, FLThe pilot’s loss of airplane control after takeoff, which resulted in collision with terrain. Contributing to the accident was the pilot’s failure to properly secure the cabin door and trim the airplane for takeoff, which resulted in the cabin door opening…NTSB ENG15RA011Incident · No injuriesForeign investigationBell 206 - L4 · Remote Location, South AfricaOn February 12, 2015, a Bell 206L-4 powered by a Rolls-Royce 250-C30P turboshaft engine experienced an uncontained engine failure followed by a successful force landing. This incident is being investigated by the South Africa Civil Aviation Authority (CAA)…NTSB CEN15WA143Accident · 1 fatalForeign investigationJudr Zdenek Prazdny Rotorway · Bohušovice nad Ohrí, CzechiaNTSB CEN15CA188Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Akron, OHThe pilot's failure to maintain directional control during a crosswind landing in gusting crosswind conditions.NTSB WPR15CA102Accident · No injuriesData collectionFinal reportCessna 185 - E · Carson City, NVThe pilot's failure to maintain directional control during landing with a crosswind which resulted in a ground loop.NTSB ERA15FA129Accident · 4 fatalField investigationFinal reportBeech 1900 · Miami, FLThe left engine propeller's uncommanded travel to the feathered position during takeoff for reasons that could not be determined due to impact damage. Contributing to the accident was the flight crew's failure to establish a coordinated climb once the left…NTSB ERA15FA128Accident · 1 fatalField investigationFinal reportPiper PA28 · Greensboro, NCA total loss of engine power after takeoff due to fuel starvation as a result of excessive wear of the fuel selector valve. Also causal was the owner/operator and maintenance personnel's inadequate maintenance, and inadequate postmaintenance inspection.NTSB CEN15FA141Accident · 2 fatalField investigationFinal reportRichard Lacourse Wheeler Express · Kersey, COThe pilot's failure to maintain airplane control during an off-airport forced landing following a total loss of engine power for reasons that could not be determined during postaccident examination of the engine. Contributing to the accident was the pilots'…NTSB WPR15LA101Accident · Minor injuriesLimited investigationFinal reportVans RV7 - Undesignat · Belfair, WAA total loss of engine power during cruise flight due to the fatigue failure of the engine crankshaft. Contributing to the accident was the unapproved repair and improper inspection of the engine crankshaft.NTSB WPR15CA110Accident · No injuriesData collectionFinal reportRaytheon B300 · Mammoth Lakes, CAThe airplane encountered extreme turbulence during descent.NTSB ERA15LA125Accident · No injuriesLimited investigationFinal reportCessna 402C · Isla de Vieques, PRThe pilot's failure to maintain directional control during the landing roll with a strong crosswind, which resulted in a runway excursion.NTSB CEN15LA140Accident · Minor injuriesClass 3 · LimitedFinal reportEmbraer ERJ 190 100 IGW · Houston, TXAn undetermined malfunction of the nosewheel steering control module, which resulted in the nose landing gear being jammed in the gear bay. Contributing to the accident was the improper rigging of the nosewheel steering feedback sensors during installation.NTSB WPR15CA100Accident · Minor injuriesData collectionFinal reportCessna U206 - G · Kernville, CAThe pilot's inadequate flare and failure to maintain airplane control during the landing with a tailwind which resulted in a bounce, long landing, and subsequent runway excursion.NTSB ERA15LA124Accident · No injuriesLimited investigationFinal reportDehavilland DHC 6 Twin Otter · Sebastian, FLThe pilot's failure to conduct all of the required items on the Before Starting Engines checklist, which resulted in her failure to detect an open hydraulic circuit breaker and led to insufficient hydraulic pressure to operate the airplane's brakes, her…NTSB ANC15LA011Accident · No injuriesLimited investigationFinal reportCessna 180 · Glennallen, AKAn in-flight fire and a partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA15LA123Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Fort Meade, MDThe mechanic’s failure to detect the incorrect dry valve tappet clearances while troubleshooting ongoing engine issues, which resulted in partial loss of engine power during takeoff. Contributing to the partial loss of engine power was the mechanic's failure…NTSB CEN15WA453Accident · Minor injuriesForeign investigationMooney M20F · Avignon, FranceOn February 8, 2015, about 0845 UTC, a Mooney M20F, French registration F-BOLV, owned and operated by Chateau Avia Aero Club and piloted by a private individual, was substantially damaged when the landing gear collapsed during landing at the Avignon-Provence…NTSB CEN15IA139Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G IV · Eagle, COThe pilot's rejected takeoff due to perceived flight control system anomalies, which led to excessive brake temperatures and resulted in a right main landing gear brake fire.