NTSB investigations, 2017
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WHERE year(c.\"eventDate\") = 2017 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 WHERE year(c."eventDate") = 2017 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 DCA17WA113Incident · No injuriesForeign investigationBoeing 737 · Palma de Mallorca, SpainThe Comision de Investigacion de Accidenties E Incidentes de Aviacion Civil of Spain has notified the NTSB of an incident involving a CESSNA 510 airplane that occurred on April 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB CEN17LA162Accident · No injuriesLimited investigationFinal reportCessna 210 · Salida, COThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA17CA349Accident · No injuriesData collectionFinal reportPiper PA44 · Tulsa, OKThe pilot receiving instruction’s failure to maintain directional control during landing in gusting wind conditions.NTSB GAA17CA239Accident · No injuriesData collectionFinal reportBeech C23 · Fallon, NVThe pilot's inaccurate takeoff performance calculations and failure to maintain directional control during an aborted takeoff.NTSB GAA17CA237Accident · No injuriesData collectionFinal reportBrantly B 2B · Earl Park, INThe pilot’s failure to recognize that he was operating in the weathercock stability flight regime of loss of tail rotor effectiveness, which resulted in a loss of directional control during the execution of a right pedal turn.NTSB ERA17LA158Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Euharlee, GAThe NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.NTSB ERA17FA156Accident · 2 fatalField investigationFinal reportLuscombe 8 · East Windsor, CTThe flying pilot's excessive maneuvering of the airplane at a slow airspeed, which resulted in exceedance of the critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilots' operation of the airplane over its maximum…NTSB WPR17FA105Accident · 2 fatalField investigationFinal reportSocata TB 20 Trinidad · Sierraville, CAThe pilot's decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.NTSB GAA17CA238Accident · No injuriesData collectionFinal reportCheung David S Vans RV6 · Indianola, IAThe pilot’s failure to maintain an adequate approach path, which resulted in a long landing and subsequent runway overrun.NTSB DCA17WA107Incident · No injuriesForeign investigationAirbus A320 · New Delhi, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's…NTSB DCA17WA097Incident · No injuriesForeign investigationBoeing 777 · Amsterdam, NetherlandsThe government of Netherlands has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on April 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Netherlands's investigation under the…NTSB CEN17RA158Accident · 5 fatalForeign investigationPiper PA31T · Cascais, PortugalOn April 17, 2017, about 1104 hours universal coordinated time, a Piper PA-31T, serial number 31T-8020091, Swiss registration HB-LTI, was destroyed during impact and a postimpact fire following a loss of control during initial climb from runway 17 at the…NTSB CEN17LA163Accident · No injuriesLimited investigationFinal reportGrumman Schweizer G-164 · Palmer, KSA crack in the cylinder of the radial engine, which resulted in a loss of engine power and a forced landing on unsuitable terrain.NTSB CEN17LA156Accident · No injuriesLimited investigationFinal reportLoomis Xenon 4 · Knoxville, IAA partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.NTSB ANC17LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Willow, AKThe partial loss of engine power for reasons that could not be determined based on the available information, which resulted in the forced landing attempt and impact with power lines.NTSB GAA17CA236Accident · Minor injuriesData collectionFinal reportZeiler Bakeng Duce 1976 CZ · Oliver Springs, TNThe pilot’s unstabilized approach and failure to go around, which resulted in impact with trees.NTSB GAA17CA235Accident · No injuriesData collectionFinal reportRaytheon B200 · Richfield, UTThe pilot’s failure to maintain separation from a fence post during taxi at night.NTSB ERA17FA155Accident · 4 fatalField investigationFinal reportCessna 170 · Williston, FLThe pilot's failure to maintain adequate airspeed during initial climb in gusty wind conditions, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall/spin.NTSB ERA17CA157Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Kingsland, GAThe pilot's improper landing flare, which resulted in a hard landing and subsequent nose-over.NTSB ENG17WA020Incident · No injuriesForeign investigationBAE JETSTREAM3100 · Monteria, ColombiaOn April 15, 2017, a Colombian-registered BAE Jetstream J32, HK4820, operated by Aerolinea de Antioquia ADA experienced a loss of power from the No. 2 engine, a Honeywell TPE331 turbopropeller. The engine was shutdown in flight and the airplane diverted to…NTSB CEN17LA157Accident · No injuriesLimited investigationFinal reportCessna 210 · Minden, LAThe pilot's inadequate fuel planning and in-flight fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA17WA159Accident · 2 fatalForeign investigationCessna 172 · Cassilandia, BrazilOn April 14, 2017, about 2045 coordinated universal time, a privately owned and operated Cessna 172N, Brazilian registration PR-LPW, was substantially damaged after it struck a tree about 400 meters from the threshold of runway 13 at the Aeroporto de…NTSB DCA17CA101Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 190 100 IGW · Orlando, FLan inadvertent encounter with convective turbulence, which resulted in a serious injury to a flight attendant.NTSB CEN17WA161Accident · 1 fatalForeign investigationChampion 8KCAB · Cancun, MexicoThe accident investigation is under the jurisdiction and control of the Mexican government. This report is for informational purposes only and contains only information released by or obtained from the Mexican government. Further information pertaining to…NTSB WPR17LA087Accident · Serious injuriesLimited investigationFinal reportTitan Tornado I · Spanaway, WAMaintenance personnel’s improper attachment of the aileron system components, which resulted in the pilot's inability to maintain flight control.NTSB WPR17WA123Accident · 1 fatalForeign investigationCessna 208 · Anem Mountain, Oksibil, IndonesiaOn April 12, 2017, about 0340 universal coordinated time, a Cessna 208C, PK-FSO, operated by PT. Spirit Avia Sentosa as an unscheduled cargo flight under the pertinent civil regulations of the government of Indonesia, collided with mountainous terrain 7…NTSB GAA17CA233Accident · No injuriesData collectionFinal reportPiper PA 34 · Llano, TXThe pilot’s complacency during the en route phase of flight, which resulted in fuel mismanagement and a subsequent gear-up landing.NTSB GAA17CA231Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot’s failure to maintain directional control during the landing roll with crosswind conditions.NTSB GAA17CA230Accident · No injuriesData collectionFinal reportCessna 180 · Manchester, CAThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the total loss of engine power.NTSB GAA17CA228Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Willow, AKThe airplane's left main ski's collision with a submerged frozen sand berm.NTSB ERA17FA153Accident · 1 fatalField investigationFinal reportHoward DGA 15P · Monongahela, PAThe pilot's failure to maintain airplane control during an attempted go-around in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB CEN17LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · La Porte, TXA total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection that did not detect water contamination.NTSB CEN17FA152Accident · 1 fatalField investigationFinal reportTemco GC 1B · Hartsville, INThe pilot's loss of control after exceeding the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB GAA17CA232Accident · No injuriesData collectionFinal reportCessna 172 · Houston, TXThe pilot’s delayed attempt to abort the takeoff with a tailwind, which resulted in a runway overrun.NTSB ERA17CA152Accident · Minor injuriesData collectionFinal reportLazear John T Zenair Stol CH 701 · Windsor Twp, PAThe pilot's improper pretakeoff planning, his failure to maintain adequate airspeed, and his exceedance of the airplane's critical angle of attack during a short-field takeoff with a tailwind, which resulted in an aerodynamic stall.NTSB DCA17WA098Incident · No injuriesForeign investigationBoeing 737 · Dublin, IrelandThe Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's…NTSB CEN17WA159Accident · No injuriesForeign investigationGulfstream Aerospace GIV X (G450) · Salzburg, AustriaOn April 11, 2017, about 0830 hours universal coordinated time, a Gulfstream Aerospace GIV-X (G450) airplane, United States registration N667HS, was substantially damaged when the nose landing gear collapsed after landing at the Salzburg Airport (LOWS),…NTSB WPR17IA086Incident · No injuriesClass 3 · IncidentFinal reportBeech A36TC · Livermore, CAA mistrim condition while the autopilot was engaged for reasons that could not be determined based on available evidence, and the pilot’s subsequent failure to confirm the command bar status before disengaging the autopilot. Contributing to the accident were…NTSB GAA17CA225Accident · No injuriesData collectionFinal reportWeatherly 620B · Lewistown, MTThe pilot’s failure to maintain altitude during low-altitude maneuvers in flat light conditions.NTSB GAA17CA241Accident · Minor injuriesData collectionFinal reportAmerican AA 1 · New Market, VAThe pilot’s failure to maintain a proper approach path, which resulted in an impact with trees.NTSB GAA17CA234Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Stafford, KSThe pilot's failure to maintain directional control during the takeoff roll.NTSB GAA17CA222Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Avalon, CAThe pilot’s failure to maintain the runway heading and the improper landing flare during landing.NTSB CEN17WA160Accident · Minor injuriesForeign investigationCessna U206 · Seine-Maritime, FranceOn April 9, 2017, about 1430 universal coordinated time (UTC), a Cessna U206-F airplane, F-HNCM, flipped on it back during a forced landing near Seine-Maritime, France, following a loss of engine power. The pilot and four passengers received minor injuries…NTSB CEN17LA150Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201 · Pontiac, MIMaintenance personnel’s improper securing of an unused instrument lamp socket during recent maintenance, which resulted in an electrical short of the landing gear controls and stopped the landing gear while it was transitioning to the down position and led to…NTSB GAA17CA226Accident · Minor injuriesData collectionFinal reportCessna 210 · Santa Teresa, NMThe pilot’s improper landing flare, which resulted in a hard, porpoised landing and subsequent nose-over.NTSB GAA17CA223Accident · No injuriesData collectionFinal reportPiper J3C · New Carlisle, OHThe other pilot’s decision to land on an occupied runway and his failure to see and avoid the airplane.NTSB ERA17LA150Accident · No injuriesLimited investigationFinal reportCessna 310R · South Lakeland, FLThe failure of the left main landing gear on landing for reasons that could not be determined due to the extent of damage sustained during the accident.NTSB ERA17FA148Accident · 1 fatalField investigationFinal reportPiper PA 12 · Sanford, FLThe incorrect rigging of the elevator control cables, which resulted in a reversal of elevator control inputs applied by the pilot during the takeoff, an excessive nose-high pitch, and subsequent aerodynamic stall after takeoff. Also causal was the inadequate…NTSB ERA17CA149Accident · Serious injuriesData collectionFinal reportNorth American T 6G · Culpepper, VAThe pilot's failure to maintain airplane and directional control during the landing roll and subsequent go-around in gusting wind conditions.NTSB DCA17WA105Accident · No injuriesForeign investigationBoeing 737 · Sibu Warawak, MalaysiaThe Malaysian Department of Civil Aviation (DCA) has notified the NTSB of an accident involving a Boeing 737, which occurred on April 8, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DCA investigation under the provisions of ICAO…