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 DCA17WA094Accident · No injuriesForeign investigationCanadair CL604 · Arabian Sea, A1The German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an accident involving a Canadair CL-604, which occurred on January 7, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of…NTSB CEN17LA073Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Meeker, COA partial loss of engine power due to fuel contamination from an undetermined source.NTSB GAA17CA119Accident · No injuriesData collectionFinal reportCessna 175 · Lakeport, CAThe pilot’s failure to secure the airplane before pulling the propeller through, which resulted in the airplane rolling and subsequently colliding with a parked airplane.NTSB DCA17WA055Incident · No injuriesForeign investigationBoeing 737 · Brisbane, AustraliaThe Australian Transport Safety Bureau has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on January 06, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…NTSB CEN17LA082Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hobart, INThe pilot's failure to abort the landing when he recognized the airplane was traveling too fast, which resulted in impact with trees off the end of the runway.NTSB WPR17FA047Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · San Pedro, CAThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a loss of engine power due to carburetor icing. Also causal was the pilot's failure to maintain rotor rpm following the loss of engine…NTSB ERA17WA086Accident · 2 fatalForeign investigationCessna 172 · Tangara da Serra, BrazilOn January 5, 2017, at 1420 universal time coordinated, a Cessna 172S airplane, Brazilian registration PR-GRS, sustained substantial damage when it struck high-tension power-lines while attempting to land at the Tangara da Serra Airport (TGQ), State of Mato…NTSB ERA17LA078Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Development CH 2000 · Atlanta, GAThe pilot's exceedance of the airplane's critical angle of attack while attempting a short-field takeoff, which resulted in an aerodynamic stall.NTSB CEN17FA071Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · Gurdon, ARThe loss of control in flight for reasons that could not be determined because of the severe impact and postcrash fire damage to the airplane and the lack of information about the airplane emergency that the pilot was experiencing.NTSB WPR17LA048Accident · No injuriesLimited investigationFinal reportSchosanski John H Cozy MK IV R · Napa, CAA partial loss of power due to missing apex seals.NTSB CEN17LA068Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Nacogdoches, TXThe loss of engine power for reasons that could not be determined because postaccident examination and testing of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN17FA067Accident · 1 fatalField investigationFinal reportDemmer BD-4 · Brookfield, WIThe pilot's failure to abort the takeoff when he was not able to maintain directional control in the strong crosswind conditions.NTSB WPR17LA046Accident · Serious injuriesLimited investigationFinal reportSoftex Invest V-24L · Paradise, MTA partial loss of power during cruise flight for reasons that could not be determined because postaccident examination of the engines did not reveal evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR17FA045Accident · 4 fatalField investigationFinal reportCessna T210K · Payson, AZThe non-instrument-rated pilot's improper decisions to begin and to continue a flight under visual flight rules into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB GAA17CA108Accident · No injuriesData collectionFinal reportLarson Roger H RV-7 · Casa Grande, AZThe pilot’s inadvertent application of the autopilot during short final, which resulted in an aerodynamic stall and hard landing.NTSB CEN17LA079Accident · No injuriesLimited investigationFinal reportQuicksilver GT-400 R503 · New Braunfels, TXThe partial loss of engine power due to a loose spark plug. Contributing to the accident was the pilot's improper preflight inspection of the airplane.NTSB WPR17FAMS2Accident · 3 fatalMissing aircraftFinal reportCessna 172M · Open water, HIUndetermined because the airplane was not located.NTSB GAA17CA106Accident · Minor injuriesData collectionFinal reportMaule M7 · Palouse, WAThe pilot’s failure to maintain directional control on an ice- and snow-covered runway during taxi with a crosswind, which resulted in a runway excursion.NTSB CEN17LA066Accident · Serious injuriesLimited investigationFinal reportGosselin Charles Glastar · Lee's Summit, MOPartial failure of the electric system due to a battery short, which resulted in a total loss of engine power.NTSB CEN17FA064Accident · 4 fatalField investigationFinal reportPiper PA 28R-200 · Vienna, ILThe non-instrument rated pilot's decision to descend through an overcast layer of weather during dark night conditions, which resulted in the airplane impacting trees.NTSB CEN17FA063Accident · 3 fatalField investigationFinal reportPiper PA28R · McKinney, TXThe other pilot's use of an alternate traffic pattern entry procedure, which resulted in his inability to see and avoid the airplane, which was flying the preferred traffic pattern, and the subsequent midair collision.NTSB WPR17FA044Accident · 4 fatalField investigationFinal reportCessna 182 · Dabob, WAThe non-instrument-rated pilot's decision to continue a night visual flight rules into instrument flight rules conditions, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot's failure to obtain…NTSB ERA17LA077Accident · No injuriesLimited investigationFinal reportBeech 76 · Dunnellon, FLAn inadequate 100-hour maintenance inspection that failed to detect and correct loose nuts on a single-drive dual magneto, which led to the subsequent separation of the magneto from the engine during initial climb and the total loss of engine power.NTSB DCA17WA056Incident · No injuriesForeign investigationBoeing 737 · Paris, FranceThe Bureau d'Enquêtes et d'Analyses (BEA) of France has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on December 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's…NTSB CEN17FA072Accident · 6 fatalField investigationFinal reportCessna 525 · Cleveland, OHControlled flight into terrain due to pilot spatial disorientation. Contributing to the accident was pilot fatigue, mode confusion related to the status of the autopilot, and negative learning transfer due to flight guidance panel and attitude indicator…NTSB WPR17LA050Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Kingman, AZThe loss of engine oil pressure during cruise flight, which resulted in partial loss of engine power and necessitated a forced landing. The loss of oil pressure was the result of a failed engine piston, likely initiated by foreign object damage, which…NTSB WPR17LA043Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mt. Baldy, CAThe pilot's failure to maintain main rotor speed during a low orbiting approach over a confined mountainous area. Contributing to the accident was the pilot's decision to attempt to land in an area that did not allow for a safe exit path under conditions near…NTSB GAA17CA105Accident · No injuriesData collectionFinal reportPiper PA 46 · Nashville, TNThe pilot’s loss of directional control during the aborted landing in gusting crosswind conditions, which resulted in a runway excursion.NTSB DCA17WA086Incident · No injuriesForeign investigationBoeing 737 · Bucharest, RomaniaThe Romania Civil Aviation Safety Investigation and Analysis Center has notified the NTSB of an incident involving a Boeing 737, which occurred on December 29, 2016. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…NTSB ERA17WA076Accident · 1 fatalForeign investigationAir Tractor AT802 · Santa Juana, ChileNTSB CEN17WA069Incident · No injuriesForeign investigationSikorsky S92 · North Sea, UK, United KingdomOn December 28, 2016, G-WNSR, a Sikorsky S-92A helicopter had a heavy landing on the deck of an offshore platform in the North Sea. The 11 persons on-board were not injured. This accident/incident investigation is under the jurisdiction and control of the…NTSB CEN17LA090Accident · No injuriesLimited investigationFinal reportCessna 172B · Prairie Du Sac, WIThe pilot's decision to taxi the airplane from the roadway and his subsequent failure to maintain clearance from signs and a fence after a successful emergency landing following a total loss of engine power.NTSB CEN17LA062Accident · No injuriesLimited investigationFinal reportPiper PA22 · Piedmont, MOThe pilot’s descent below glidepath, which resulted in the airplane’s impact with power lines.NTSB WPR17LA042Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Willows, CAThe decision of the maintenance facility mechanic to conduct maintenance without reference to the applicable manufacturer’s guidance, which resulted in the improper reassembly and subsequent failure of the engine compressor bleed valve, which in turn…NTSB ERA17LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Bridgeport, ALThe pilot's decision to make steep turns to the right while operating on the right fuel tank with low fuel quantity, which led to a loss of engine power due to unporting of the right fuel tank and fuel starvation.NTSB ERA17FA074Accident · 2 fatalField investigationFinal reportIndependent Technologies Epic LT · Port Orange, FLThe pilot's loss of airplane control due to spatial disorientation, which resulted in the exceedance of the airplane's critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's failure to fly a stabilized approach…NTSB DCA17WA047Accident · Minor injuriesForeign investigationBoeing 737 · Dabolim, Goa, IndiaThe India Air Accident Investigation Bureau (AAIB) has notified the NTSB of an accident involving a Boeing 737-800 airplane that occurred on December 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under…NTSB CEN17LA061Accident · Minor injuriesLimited investigationFinal reportMead RV 8A · Farmington, MOThe pilot's failure to maintain airplane control during takeoff in crosswind conditions.NTSB WPR17FA041Accident · 2 fatalField investigationFinal reportPetrus David Wayne S90 · Fresno, CAThe pilot's abnormally steep takeoff climb followed by a loss of control and rapid descent to ground impact, for undetermined reasons.NTSB ERA17FA073Accident · 3 fatalField investigationFinal reportCessna 182 · Gatlinburg, TNThe non-instrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's established anti-authority attitude.NTSB DCA17WA048Incident · No injuriesForeign investigationBoeing 737 · Addis Ababa, EthiopiaThe Ethiopia Accident Investigation Bureau (AIB) has notified the NTSB of an incident involving a Boeing 737-800 airplane that occurred on December 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist AIB's investigation under the…NTSB GAA17CA104Accident · No injuriesData collectionFinal reportCessna 172 · Palm Coast, FLThe student pilot’s improper landing flare, which resulted in a hard landing and porpoise.NTSB GAA17CA100Accident · No injuriesData collectionFinal reportCessna 150 · Warren, MNThe noncertificated pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion.NTSB GAA17CA099Accident · Minor injuriesData collectionFinal reportPiper PA38 · Hartford, CTThe student pilot’s improper landing flare, which resulted in a bounced hard landing.NTSB ERA17WA085Accident · 3 fatalForeign investigationBeech 58 · Tabatinga, BrazilOn December 23, 2016, about 1830 universal coordinated time, a Beech 58, Brazilian registration PT-ICU, was destroyed when it impacted wooded terrain while on approach to Tabatinga International Airport (SBTT), Tabatinga, State of Amazonas, Brazil. The two…NTSB ERA17FA072Accident · 1 fatalField investigationFinal reportPiper PA28 · Middlebury, VTThe pilot's improper decision to return to the airport following a partial or complete loss of engine power during takeoff initial climb and his failure to maintain sufficient airspeed while maneuvering, which resulted in exceedance of the critical angle of…NTSB CEN17LA070Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Pontiac, MIThe improper installation of the left wheel brake torque plate by maintenance personnel, which resulted in the separation of the torque plate from the axle endplate and a loss of directional control during landing.NTSB CEN17LA065Accident · No injuriesLimited investigationFinal reportLueck Kitfox 7 · Cody, WYImproper maintenance of the fuel pressure regulator, which resulted in an excessive fuel and airbox pressure differential and subsequent loss of engine power.NTSB GAA17CA103Accident · Minor injuriesData collectionFinal reportPiper PA28 · Shreveport, LAThe pilot’s inadequate compensation for crosswind conditions during the go-around, which resulted in a loss of airplane control.NTSB ENG17WA007Incident · No injuriesForeign investigationBoeing 767 · Toronto, CanadaOn Dec. 21, 2016, an ElAl Boeing 767-300ER, powered by Pratt & Whitney PW4000 turbofan engines, registration number 4X-EAM, while climbing through 13,000 ft. from Pearson International Airport (YYZ), Toronto, Canada, experienced a loss of power of the right…