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 DCA16WA098Incident · No injuriesForeign investigationBoeing 737 · Iquitos, PeruThe Peru Comisión de Investigación de Accidentes de Aviación (CIAA) has notified the NTSB of an incident involving a BOEING 737-300 that occurred on February 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA investigation…NTSB DCA16WA087Incident · No injuriesForeign investigationBoeing 777 · Punta Cana, Dominican RepublicThe Dominican Republic Comisión Investigadora de Accidentes de Aviación (CIAA) has notified the NTSB of an incident involving a BOEING 777-200 that occurred on February 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…NTSB CEN16WA104Accident · 1 fatalForeign investigationCessna 172 · Jaen, SpainNTSB WPR16LA066Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Santa Barbara, CAA total loss of engine power during initial climbout for reasons that could not be determined because postaccident examination and testing of the engine did not reveal any mechanical anomalies that would have precluded normal operation.NTSB ERA16CA105Accident · No injuriesData collectionFinal reportPiper PA34 · Williamsport, PAThe pilot's failure to maintain altitude in cruise flight due to his diverted attention, which resulted in controlled flight into terrain.NTSB DCA16WA099Incident · No injuriesForeign investigationBombardier DHC8 · Calgary, Alberta, CanadaThe Transportation Safety Board (TSB) of Canada has notified the NTSB of an incident involving a Bombardier DHC8-402 that occurred on February 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the…NTSB CEN16IA103Incident · No injuriesIncident investigationFinal reportCessna 560 · Dallas, TXThe loss of aileron trim due to the lack of separation between the cannon head on the back of autopilot cannon plug and the aileron trim tab control gear. Contributing to the incident was the lack of guidance in the airplane maintenance manual to verify…NTSB WPR16LA073Accident · Minor injuriesLimited investigationFinal reportCessna T206H · Billings, MTThe pilot’s failure to attain a proper flare during landing in gusting wind conditions and low-level wind shear, which resulted in a hard landing and a subsequent loss of directional control.NTSB GAA16CA122Accident · No injuriesData collectionFinal reportCessna 175 · Gold Beach, ORThe pilot's failure to maintain an approach angle of descent to avoid obstacles, resulting in the airplane striking the airport perimeter fence.NTSB GAA16CA136Accident · No injuriesData collectionFinal reportFox AL KIT FOX Model · Slate Creek, IDThe left main landing gear forward gear tube collapsed during the landing roll.NTSB ERA16WA107Accident · 1 fatalForeign investigationBell 206 · Bejucal, VenezuelaOn February 6, 2016, about 1710 universal coordinated time, a Bell 206 L-3 helicopter, Venezuelan registration YV250T, was destroyed when it collided with terrain after a loss of control in flight. The flight originated at the Aerópuerto De San Juan De Los…NTSB ERA16LA104Accident · Serious injuriesLimited investigationFinal reportBell 206 · Linden, NJThe pilot receiving instruction's failure to maintain helicopter control during the initial takeoff, which resulted in a dynamic rollover. Contributing to the accident was the flight instructor's inadequate remedial action due to his distraction by looking…NTSB WPR16LA081Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 600N · Ashland, ORFatigue cracking of a main rotor blade for reasons that could not be determined based on the available information.NTSB WPR16FA065Accident · 3 fatalField investigationFinal reportBeech M35 · San Pedro, CAThe failure of the pilots of both airplanes to see and avoid each other as they converged nearly head-on, which resulted in a midair collision. Contributing to the accident was sun glare on the pilot.NTSB WPR16FA064Accident · 2 fatalField investigationFinal reportNorth American F51 · Maricopa, AZThe pilot’s failure to maintain airplane control while performing an acrobatic maneuver and his subsequent failure to recover from an inadvertent spin due to insufficient altitude.NTSB GAA16CA530Accident · No injuriesData collectionFinal reportRobinson R22 · Taylor, TXThe flight instructor's improper collective input during a simulated engine failure autorotation with a power recovery, which resulted in a hard, bounced landing and the main rotor blade striking the tailboom.NTSB GAA16CA126Accident · No injuriesData collectionFinal reportPiper PA31 · Newport, RIAn inadvertent collision with birds during final approach at night.NTSB WPR16LA063Accident · No injuriesLimited investigationFinal reportCessna 172S · San Diego, CAThe failure of the flight instructor of the other airplane to maintain awareness while parked on the ramp with the engine operating, which resulted in impact with the parked airplane.NTSB GAA16CA133Accident · Minor injuriesData collectionFinal reportNorth American P 51 · Dallas, TXThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing.NTSB DCA16WA085Incident · No injuriesForeign investigationSikorsky S76 · Lagos, NigeriaThe Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving a Sikorsky S76C helicopter that occurred on February 03, 2016. The NTSB has appointed a U.S. Accredited Representative to assist NAIB's investigation under the…NTSB GAA16CA120Accident · Minor injuriesData collectionFinal reportCessna 210 · Park Valley, UTThe pilot's decision to drag the left main landing gear on a snow covered dry lake bed, which resulted in a loss of directional control and a nose over during an aborted landing.NTSB ERA16WA101Accident · Serious injuriesForeign investigationRobinson R66 · Aviatornyi, RussiaOn February 2, 2016, about 0730 Coordinated Universal Time (UTC), a Robinson R66, RA-06239, registered to Southeast Agricultural Group, LLC, collided with terrain near Aviatornyi Township, Kirsanov District, Tambov Region, Russia. Visual meteorological…NTSB ERA16LA103Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Miami, FLA partial loss of engine power for reasons that could not be determined because postaccident examination of the airplane revealed no mechanical anomalies that would have contributed to the power loss.NTSB ERA16FA100Accident · 2 fatalField investigationFinal reportCessna 182 · Mobile, ALThe pilot's loss of airplane control during a missed approach in instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot's inadequate preflight and inflight weather planning which resulted the pilot's…NTSB GAA16CA123Accident · No injuriesData collectionFinal reportCessna 150 · Lapeer, MIThe student pilot's failure to achieve an adequate climb rate while turning to avoid obstacles during an aborted landing, resulting in an uncontrolled descent, collision with terrain, and a nose over.NTSB CEN16LA097Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Sturtevant, WIThe pilot's failure to maintain a proper glidepath during a landing at dusk, which resulted in impact with a moving ground vehicle. Contributing to the accident was the inoperative precision approach path indicator.NTSB CEN16LA096Accident · 1 fatalLimited investigationFinal reportRaymond Z Brown Condor · Centralia, ILThe failure of the prerotator belt, which impeded the engine's timing belt and resulted in a loss of engine power at low altitude.NTSB CEN16FA094Accident · 1 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P92 Echo Super · Arcola, TXThe student pilot's loss of control after exceeding the airplane's critical angle-of-attack, which lead to a power-on, aerodynamic departure stall. Contributing to the accident was the flight instructor's inadequate oversight of the student pilot.NTSB WPR16LA060Accident · No injuriesLimited investigationFinal reportPiper PA46 · Burns, ORThe total loss of engine power for reasons that could not be determined because postaccident examination revealed no evidence of an anomaly that would have precluded normal operation. Contributing to the accident was a preexisting landing gear anomaly that…NTSB GAA16CA150Accident · No injuriesData collectionFinal reportCessna 172 · La Junta, COThe pilot's decision to take off with a tailwind, and exceed the critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.NTSB GAA16CA119Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Everglades, FLThe pilot's failure to maintain adequate wing clearance while taxiing, which resulted in a collision with two unoccupied airplanes.NTSB GAA16CA114Accident · No injuriesData collectionFinal reportCessna 172 · Merritt Island, FLThe student pilot's improper flare which resulted in a porpoise, runway excursion, and nose over.NTSB CEN16LA101Accident · No injuriesLimited investigationFinal reportAeronca O-58B · Bulverde, TXThe failure of the left main landing gear wheel casting due to fatigue, which resulted in a loss of directional control during the landing roll.NTSB GAA16LA117Accident · No injuriesLimited investigationFinal reportHelicopteres Guimbal Cabri · Beaumont, TXThe pilot's inadequate compensation for wind during a hover-taxi and his failure to maintain helicopter control due to a loss of tail rotor effectiveness.NTSB GAA16CA115Accident · No injuriesData collectionFinal reportAmerican Legend AL11C 100 · Las Animas, COThe pilot's selection of unsuitable terrain for landing, resulting in a nose over.NTSB ERA16FA097Accident · 3 fatalField investigationFinal reportBrook Aaron D Lancair IV P · Albany, GAThe pilots' failure to maintain control during a takeoff attempt in a high-performance airplane. Contributing to the accident were the pilots' decision to operate the airplane above its maximum gross weight and with an aft center of gravity and their lack of…NTSB DCA16WA084Incident · No injuriesForeign investigationBoeing 747 · London, United KingdomThe Air Accidents Investigation Branch of the United Kingdom has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on January 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB WPR16WA062Accident · 4 fatalForeign investigationPiper PA28 · Barwon Heads, Australia, AustraliaOn January 29, 2016, at 1155 local time, a Piper PA 28-235, VH-PXD, was ditched in the waters near Barwon Heads, Australia. The airplane was operated by a private individual under the pertinent regulations of the Government of Australia. The airplane was…NTSB WPR16FA059Accident · 2 fatalField investigationFinal reportPiper PA 24-260 · Santa Rosa, CAThe pilot’s failure to maintain airplane control during an instrument approach in night instrument meteorological conditions, which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of recent experience in night…NTSB OPS16IA004Incident · No injuriesIncident investigationFinal reportAirbus A321 231 · Fort Lauderdale, FLThe air traffic controller's failure to ensure the runway surface area was clear of vehicles before clearing an aircraft for takeoff. Also causal was the flight crew's decision to initiate a takeoff while the Runway Status Lights (RWSL) Takeoff Hold Lights…NTSB GAA16CA116Accident · No injuriesData collectionFinal reportCessna 152 · Durant, OKThe pilot's failure to maintain pitch control during the landing, resulting in a porpoise.NTSB ERA16LA098Accident · No injuriesLimited investigationFinal reportEurocopter France EC 130 B4 · Shoals, WVThe improper locking of the rear passenger door by the specialty nurse, which resulted in the door separating from the helicopter in flight.NTSB DCA16WA080Accident · 3 fatalForeign investigationCessna 425 · Windhoek, NamibiaThe Namibia Directorate of Aircraft Accident and Incident Investigation (DAAII) has notified the NTSB of an accident involving a Cessna 425 airplane that occurred on January 29, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB CEN16LA100Accident · No injuriesLimited investigationFinal reportMaule M 7-235C · Macon, MOThe failure of the right main landing gear assembly for reasons that could not be determined based on the available information.NTSB DCA16WA076Accident · Minor injuriesForeign investigationMcdonnell Douglas MD80 · Mashad, IranThe government of Iran has notified the NTSB of an accident involving a McDonnell Douglas MD80 airplane that occurred on January 28, 2016. The NTSB has appointed a U.S. Accredited Representative in accordance with the provisions of ICAO Annex 13 as the State…NTSB DCA16CA077Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Titusville, FLan inadvertent encounter with clear air turbulence.NTSB WPR16LA058Accident · No injuriesLimited investigationFinal reportCessna 340A · Bakersfield, CAMaintenance personnel’s repeated failure to re-rig the main landing gear (MLG) in accordance with the airplane manufacturer's service manual requirements, which resulted in the collapse of the right MLG.NTSB OPS16IA002Incident · No injuriesIncident investigationFinal reportBombardier CL600 2D24 · Detroit, MIThe local controller's failure to visually scan and ensure that the runway surface was not occupied by a vehicle or other aircraft before issuing a takeoff clearance to the pilot. Contributing to this incident was the relieved controller's failure to monitor…NTSB GAA16CA129Accident · No injuriesData collectionFinal reportPilatus PC12 · Lawrenceville, GAAn unintentional collision with a white-tailed deer during the takeoff roll in night visual conditions.NTSB ERA16WA096Accident · 5 fatalForeign investigationMcdonnell Douglas MD-600 · Taldykorgan, KazakhstanOn January 27, 2016, about 1747 local time, a McDonnell-Douglas MD-600N helicopter, Kazakhstan registration UP-MD004, registered to LLP Svinestroy and operated by JSC Aspan, impacted terrain under unknown circumstances after requesting to air traffic control…