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 DCA16RA045Accident · 2 fatalForeign investigationBombardier CL600 2B19 · Kiruna, SwedenimportNTSB CEN16LA098Accident · No injuriesLimited investigationFinal reportCessna 441 · Fargo, NDThe pilot’s failure to cycle the surface deice boots during the instrument approach in icing conditions, which led to ice accumulation on the leading edges of the wings and empennage, and resulted in an aerodynamic stall and subsequent hard landing.NTSB ERA16WA088Accident · 2 fatalForeign investigationCessna T188 · Bom Jesus de Goiás, BrazilOn January 7, 2016, about 1900 coordinated universal time, a Cessna T188C, Brazilian registration PR-INS, operated by Blitz Comercio e Representacoes Ltda, was destroyed when it impacted terrain while spraying insecticides on a sugar cane plantation in Bom…NTSB ERA16FA084Accident · 1 fatalField investigationFinal reportEros 1600 · Lebanon, TNA failure of the front cylinder piston due to the pilot's improper maintenance, which resulted in a total loss of engine power after takeoff. Contributing to the accident was the pilot's decision to return to the runway at low altitude following the loss of…NTSB DCA16WA079Incident · No injuriesForeign investigationBoeing 737 · Gran Canaria, SpainThe Comisión de Investigación de Accidentes e Incidentes de Aviación Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on January 07, 2016. The NTSB has appointed a U.S. Accredited Representative to…NTSB DCA16WA042Incident · No injuriesForeign investigationBoeing 737 · Cluj-Napoca, RomaniaThe government of Romania has notified the NTSB of an incident involving a Boeing B737-400 airplane that occurred on January 07, 2016. The NTSB has appointed a U.S. Accreditd Representative to assist the government of Romania's investigation under the…NTSB ANC16IA013Incident · No injuriesIncident investigationFinal reportRobinson Helicopter R44 II · Anchorage, AKThe overhaul facility's improper and excessive use of an approved lubricant during overhaul of the fuel injection servo, which resulted in a disruption of fuel flow and a total loss of engine power.NTSB ERA16LA082Accident · Minor injuriesLimited investigationFinal reportPilatus PC-12 · Savannah, GAThe pilots’ failure to follow proper procedures in response to a crew alerting system warning for high engine torque values, which necessitated an off-runway emergency landing during which the airplane sustained substantial damage due to postimpact fire.…NTSB DCA16WA047Incident · No injuriesForeign investigationSwearingen SA226 · Saarbrucken, GermanyThe Bundesstelle für Flugunfalluntersuchung (BFU) of Germany has notified the NTSB of an incident involving a Swearingen SA226 airplane that occurred on January 06, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…NTSB WPR16LA048Accident · No injuriesLimited investigationFinal reportBeech 35 C33 · Henderson, NVA partial loss of engine power during final approach for reasons that could not be determined based on available information.NTSB GAA16CA097Accident · No injuriesData collectionFinal reportCessna 175 · Seeley Lake, MTThe pilot' failure to identify the plowed runway width in dusk and flat light conditions, which resulted in a touchdown left of the runway center, an impact with a snow berm, and a ground loop.NTSB CEN16LA092Accident · No injuriesLimited investigationFinal reportCessna 172R · Sulfur Springs, TXThe student pilot’s failure to maintain directional control during landing.NTSB WPR16FA046Accident · 2 fatalField investigationFinal reportAerostar S A YAK 52 · Alpine, WYThe pilot's failure to maintain clearance from snow-covered terrain in flat light conditions.NTSB ERA16CA080Accident · No injuriesData collectionFinal reportBeech 200 · Clearwater, FLThe pilot's failure to properly configure the airplane's landing gear prior to landing, which resulted in a gear-up landing.NTSB CEN16WA074Accident · 1 fatalForeign investigationCirrus SR20 · Egmond, NetherlandsOn January 4, 2016, about 1356 UTC, a Cirrus Design, Incorporated SR-20, United Kingdom registration G-ZOGT, owned by a private individual, was destroyed when it impacted into the North Sea near Egmond aan Zee, The Netherlands, under unknown circumstances.…NTSB CEN16FA073Accident · 1 fatalField investigationFinal reportCessna 172N · Wayne, NEThe noninstrument-rated pilot's improper decision to continue visual flight into instrument meteorological conditions, which resulted in a collision with terrain.NTSB ERA16WA083Accident · 2 fatalForeign investigationBeech C90 · Parati, BrazilOn January 3, 2016, about 1730 Coordinated Universal Time (UTC), a Beech C90GTi, PP-LMM, registered to Bradesco Leasing S.A., operated by Supermercado Shibata Ltda, experienced controlled flight into mountainous terrain near Parati Airport (SDTK), Parati,…NTSB DCA16CA041Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 170 100 SE · Raleigh, NCan encounter with turbulence resulting in a serious injury to a flight attendant.NTSB CEN16LA078Accident · No injuriesLimited investigationFinal reportCessna 170B · Ingleside, TXThe loss of engine power during takeoff due to carburetor icing, which resulted in a forced landing.NTSB WPR16LA049Accident · No injuriesLimited investigationFinal reportKai Engstad RV-8A · Salem, ORA total loss of engine power for undetermined reasons, because postaccident examination of the engine and fuel system did not reveal any anomalies that would have precluded normal operation.NTSB WPR16LA047Accident · No injuriesLimited investigationFinal reportKevin Metzler Velocity STD RG · Rosamond, CAA partial loss of engine power due to failure of the No. 1 connecting rod as a result of multiple fatigue cracks for reasons that could not be determined during on postaccident examination.NTSB GAA16CA098Accident · No injuriesData collectionFinal reportJohnson Glenn L Zodiac 601 XL · Chesapeake, VAThe pilot's failure to maintain pitch control during the landing, causing the airplane to bounce and the nose gear to collapse, resulting in substantial damage to the firewall and frame.NTSB GAA16CA093Accident · No injuriesData collectionFinal reportCessna 172 · Newton, IAThe pilot's failure to maintain airplane control during the takeoff, resulting in a runway excursion, and airplane nose over.NTSB ANC16LA012Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Anaktuvuk Pass, AKThe pilot’s continued flight into deteriorating, flat light weather conditions, which resulted in impact with mountainous, snow-covered terrain.NTSB WPR16WA052Accident · No injuriesForeign investigationPiper PA34 · Seletar Airport, Singapore, SingaporeOn January 1, 2016, at 1624 local time, a Piper PA-34, 9M-RBI, operated by a private operator under the pertinent civil regulations of the government of Singapore, was substantially damaged when the airplane landed at the Seletar Airport, Singapore, with the…NTSB WPR16LA045Accident · No injuriesLimited investigationFinal reportPiper PA18 · Newman Lake, WAA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB GAA16CA094Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Chesapeake, VAThe pilot's loss of directional control during takeoff which resulted in impact with the ground.NTSB ERA16WA081Accident · Serious injuriesForeign investigationBell 429 · Rostov-na-Dony, RussiaSubject: ERA16WA081 Bell 429, RA-01617, Rostov-na-Dony, Russia On January 1, 2016, about 0621 universal coordinated time, a Bell 429, Russian registration RA-01617, was substantially damaged by collision with terrain during an uncontrolled descent following a…NTSB DCA16WA040Incident · No injuriesForeign investigationBoeing 777-333ER · Calgary, CanadaThe NTSB was notified of an incident involving a Boeing B777-333 aircraft, registration C-FRAM, that occurred enroute from Shanghai, China to Toronto, Canada, which resulted in the flight being diverted to Calgary, Canada. The incident is being investigated…NTSB CEN16LA079Accident · Serious injuriesLimited investigationFinal reportPiper 28-140 · Republic, MOThe pilot's inadequate fuel management, which resulted in fuel starvation and a total loss of engine power during cruise flight.NTSB GAA16CA095Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Fort Worth, TXAn inadvertent collision with a bird while on downwind in the airport pattern.NTSB CEN16LA076Accident · No injuriesLimited investigationFinal reportBeech 200 · Gary, INThe pilot's failure to maintain the glidepath and appropriate airspeed during landing in icing conditions, which resulted in an aerodynamic stall and a hard landing.NTSB CEN16WA081Incident · No injuriesForeign investigationCessna 172RG · Cascais, PortugalNTSB ANC16LA011Accident · 1 fatalLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's intentional flight into a building.NTSB GAA16CA092Accident · No injuriesData collectionFinal reportPiper PA 46 · Stevensville, MDThe pilots failure to maintain glide path, descent rate and landing flare, in off shore wind conditions, resulting in a hard landing short of the runway.NTSB GAA16CA091Accident · No injuriesData collectionFinal reportCessna 177 · Grass Valley, CAThe pilot's loss of directional control during the touchdown and the subsequent attempted aborted landing which resulted in a runway excursion and impact with terrain.NTSB CEN16WA072Accident · 1 fatalForeign investigationMooney M20K · Mascouche, CanadaOn December 28, 2015, about 2227 universal coordinated time, a Canadian registered Mooney M20K, C-GUXC, impacted terrain while attempting to land at Mascouche (CSK3), Quebec, Canada. The pilot was fatally injured and the passenger was seriously injured. The…NTSB CEN16LA069Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Watertown, WIThe pilot’s improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to switch fuel tanks after the engine lost power, and his delayed decision to activate…NTSB WPR16LA043Accident · Serious injuriesClass 3 · LimitedFinal reportAerostar Acft Corp Of Texas M20F · Nogales, AZThe airplane’s impact with a hillside shortly after takeoff for reasons that could not be determined.NTSB GAA16CA096Accident · No injuriesData collectionFinal reportCessna 172 · Punta Gorda, FLThe student pilot's failure to maintain obstacle clearance while taxiing on the ramp, resulting in a collision with an object.NTSB DCA16CA052Accident · Serious injuriesData collectionFinal reportBoeing 737 76N · San Diego, CAAn inadvertent encounter with clear air turbulence.NTSB GAA16CA089Accident · No injuriesData collectionFinal reportWaco YMF · Fullerton, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA16LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-46 · Corinth, MSThe pilot's inadequate preflight inspection and his subsequent failure to maintain airplane control, which resulted in an access door opening after takeoff, and the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB CEN16WA071Accident · 2 fatalForeign investigationSocata TB9 · Malaga, SpainThe Comisión De Investigación De Accidentes E Incidentes De Aviación Civil (CIAIAC) of Spain has notified the NTSB of a fatal accident involving a Socata TB-9 airplane, EC-LIQ, that occurred on December 24, 2015. The NTSB has appointed a U.S. Accredited…NTSB DCA16WA048Incident · No injuriesForeign investigationBoeing 737 · Gwangju-Si, South KoreaThe government of Republic Of Korea has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Republic Of Korea's investigation…NTSB DCA16CA053Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Charlotte, NCAn inadvertent encounter with clear air turbulence.NTSB CEN16LA082Accident · No injuriesLimited investigationFinal reportBeech V35B · Tahlequah, OKA partial loss of engine power shortly after takeoff due to an inadequately tightened fuel line. Also causal was the pilot's failure to extend the landing gear once the airplane was in a position to safely land on the runway.NTSB CEN16LA067Accident · No injuriesLimited investigationFinal reportHawker 400 · Telluride, COThe limitations of the air traffic control equipment that prevented the controller's timely recognition of NOTAM information that was effective immediately and resulted in the issuance of an approach clearance to a closed runway. Also causal was the pilots'…NTSB WPR16WA051Accident · 10 fatalForeign investigationBeech 200 · New Delhi, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a Beech Super King Air B-200, registration VT-BSA, that occurred on December 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB WPR16FA042Accident · 1 fatalField investigationFinal reportPiper PA32R · Castro Valley, CAThe pilot's loss of control due to spatial disorientation while maneuvering during an instrument approach in instrument meteorological conditions.