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 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…NTSB CEN17LA151Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Nome, TXAn in-flight fire for reasons that could not be determined based on available information.NTSB WPR17FA085Accident · 4 fatalField investigationFinal reportPiper PA 46-310P · Harrisburg, ORAn encounter with a downburst during an instrument approach, which resulted in a loss of control at low altitude. Contributing to the accident was the air traffic controller's failure to solicit and disseminate pilot reports from arriving and departing…NTSB GAA17CA224Accident · No injuriesData collectionFinal reportStinson 108 · Woodruff, WIThe pilot receiving instruction's incorrect brake usage and failure to maintain directional control during the landing roll.NTSB GAA17CA220Accident · No injuriesData collectionFinal reportShilt Jerry C F-1 Rocket · Bessimer, ALThe pilot’s failure to maintain directional control during the landing rollout in gusting crosswind conditions.NTSB ERA17LA151Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Atlanta, GAThe pilot's diverted attention during the landing approach, which resulted in his failure to configure the landing gear and a subsequent a gear-up landing.NTSB DCA17WA095Incident · No injuriesForeign investigationBoeing 747 · Kong Kong, ChinaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 747, which occurred on April 7, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State of…NTSB CEN17LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Greensburg, INThe pilot's failure to maintain control during landing, which resulted in an impact with terrain.NTSB CEN17FA147Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Oxford, IAThe failure of the pilot receiving instruction to recover from the practice stall before the airplane entered a spin and the flight instructor's inadequate monitoring of the pilot receiving instruction and delayed remedial action to recover the airplane.NTSB GAA17CA229Accident · No injuriesData collectionFinal reportCessna 172 · San Marcos, TXThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA17CA221Accident · No injuriesData collectionFinal reportCessna P210 · Granby, COThe pilot's failure to extend the landing gear before landing.NTSB GAA17CA218Accident · No injuriesData collectionFinal reportBell 206 · La Verne, CAThe pilot’s early increased application of the collective during a simulated hovering autorotation, which resulted in a loss of rotor rpm and subsequent main rotor blade strike of the tailboom.NTSB GAA17CA217Accident · Minor injuriesData collectionFinal reportFunk B85C · Cedar City, UTThe pilot’s failure to maintain directional control of the airplane during the takeoff roll.NTSB CEN17LA148Accident · No injuriesLimited investigationFinal reportCessna T210M · Detroit Lakes, MNThe malfunction of the right main landing gear actuator for reasons that could not be determined because postaccident examination revealed no mechanical anomalies that would have precluded normal operation. Contributing to the accident was the improper…NTSB WPR17LA092Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Whittier, CAThe pilot's impaired decision-making due to alcohol intoxication and his improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA17CA199Accident · No injuriesData collectionFinal reportPiper PA 22 · Scappoose, ORThe student pilot’s loss of directional control during the landing roll and his subsequent inadvertent brake application, which resulted in a nose-over.NTSB ERA17FA145Accident · 1 fatalField investigationFinal reportPipistrel Virus SW · Micanopy, FLThe pilot's intentional flight into an area of known convective thunderstorm activity, which resulted in an in-flight breakup.NTSB CEN17LA149Accident · Serious injuriesLimited investigationFinal reportAero Adventure Aventura UL · Garden Ridge, TXThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA17CA216Accident · No injuriesData collectionFinal reportCessna 172 · Twisp, WAThe pilot’s failure to maintain crosswind correction during landing, which resulted in the airplane cartwheeling.NTSB GAA17CA215Accident · Minor injuriesData collectionFinal reportCessna 182 · Blue Earth, MNThe pilot's decision to continue the night, visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain while on final approach. Contributing to the accident was the pilot's improper use of an electronic flight…