NTSB investigations
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 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 WPR19LA137Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Sutter, CAA loss of engine power due to the in-flight separation of the fuel control unit interconnect rod for reasons that could not be determined due to lack of available evidence.NTSB GAA19CA246Accident · Minor injuriesData collectionFinal reportCessna 182 · Marion, INThe pilot's improper trim setting and his exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall.NTSB GAA19CA242Accident · No injuriesData collectionFinal reportFlight Design Ctls · Sandy Valley, NVThe pilot's steep bank turn at low altitude, which resulted in a rapid descent and hard landing.NTSB DCA19WA148Accident · 41 fatalForeign investigationSukhoi RRJ95 · Moscow, RussiaThe MAK of Russia has notified the NTSB of an accident involving a Sukhoi RRJ95 airplane that occurred on May 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the MAK's investigation under the provisions of ICAO Annex 13 as State of…NTSB CEN19WA137Accident · 14 fatalForeign investigationCanadair CL 600 2B16 · Coahuila, MexicoOn May 5, 2019, a Challenger Ltd CL-600-2B16 airplane, N601VH, impacted terrain near Coahuila, Mexico. The two pilots and fourteen passengers were fatally injured, and the airplane was substantially damaged. This investigation is under the jurisdiction and…NTSB CEN19FA135Accident · Serious injuriesClass 2 · FieldFinal reportPiper PA34 · Anderson, INThe loss of left engine power due to an incorrectly adjusted fuel servo and the airplane's nose up trim which resulted in the airplane steep climb, loss of airspeed, and aerodynamic stall and subsequent impact with terrain.NTSB ANC19FA018Accident · 2 fatalField investigationFinal reportBeech A60 · Santa Rosa, NMThe pilot's loss of airplane control due to his failure to maintain appropriate control inputs and airspeed after shutting down an engine because of a progressive failure of the pressure relief valve in the fuel pump, which resulted in variable fuel pressure…NTSB WPR19LA136Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Winter Haven, FLA partial loss of engine power due to worn fuel valve O-rings, which allowed air into the fuel system and resulted in a forced landing to unsuitable terrain.NTSB WPR19LA135Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206 · Oxnard, CAThe pilot’s inability to maintain control of the helicopter while maneuvering at a low altitude due to reasons that could not be determined based on available evidence.NTSB WPR19LA134Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Kalispell, MTThe loss of directional control during landing for reasons that could not be determined based on available evidence.NTSB GAA19WA265Accident · No injuriesForeign investigationLearjet 45 · Edinburgh, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a LEARJET 45 airplane that occurred on May 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB GAA19WA254Accident · No injuriesForeign investigationRobinson R44 · Guatape-Antioquia, ColombiaNTSB GAA19CA251Accident · No injuriesData collectionFinal reportDe Havilland DHC2 · McCarthy, AKThe pilot's failure to maintain a proper approach path in gusting wind conditions, which resulted in the airplane landing short of the airstrip and bouncing.NTSB GAA19CA244Accident · No injuriesData collectionFinal reportCessna A185 · Valparaiso, INThe pilot's improper throttle application and subsequent failure to maintain directional control during the takeoff roll in gusting left crosswind conditions, which resulted in a ground loop.NTSB GAA19CA243Accident · No injuriesData collectionFinal reportHanson Parakeet A4 Replica · Faribault, MNThe pilot's improper landing flare with a left crosswind, which resulted in a hard landing, collapsed landing gear, runway excursion, and nose-over.NTSB ERA19FA163Accident · 2 fatalClass 2 · FieldFinal reportGuimbal Cabri · Kent Island, MDThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in an inadvertent descent into the water. Contributing to the accident was the pilot's decision to conduct the flight at a low altitude without…NTSB DCA19MA143Accident · Minor injuriesClass 2 · MajorFinal reportBoeing 737 · Jacksonville, FLAn extreme loss of braking friction due to heavy rain and the water depth on the ungrooved runway, which resulted in viscous hydroplaning. Contributing to the accident was the operator’s inadequate guidance for evaluating runway braking conditions and…NTSB CEN19FA134Accident · 1 fatalClass 2 · FieldFinal reportAlliant Destiny 2000 · New Era, MIThe pilot's failure to maintain aircraft control while maneuvering that resulted in collapse of the canopy and an uncontrolled descent into terrain.NTSB ANC19WA023Accident · 3 fatalForeign investigationCessna 182 · Smithers, CanadaThe government of Canada has notified the NTSB of an accident involving a Cessna 182E airplane that occurred on May 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB WPR19LA171Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Deer Park, WAAn empennage flutter event for reasons that could not be determined based on the available information.NTSB GAA19WA274Accident · 1 fatalForeign investigationCessna T210 · Atizapán de Zaragoza, Mexico (jjc airport), MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA T210 airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB GAA19WA249Accident · Minor injuriesForeign investigationGrumman AA1 · Grena, Denmark, DenmarkThe government of Denmark has notified the NTSB of an accident involving a GRUMMAN AA1 airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the provisions of…NTSB GAA19CA281Accident · No injuriesData collectionFinal reportCessna 340 · Carvers, NVThe pilot’s failure to accurately assess the available runway for the takeoff, which resulted in impact with a gravel berm.NTSB GAA19CA241Accident · Minor injuriesData collectionFinal reportStemme S 10 · Sonoma, CAThe pilot's improper decision to land with a tailwind and his failure to maintain a proper approach, which resulted in a long landing, a runway overrun, and impact with a tree.NTSB GAA19CA240Accident · No injuriesData collectionFinal reportLuscombe 8 · Orofino, IDThe pilot's improper brake application during the landing roll, which resulted in a nose-over. Contributing to the accident was the pilot's lack of recent experience using heel brakes.NTSB ERA19WA168Accident · Serious injuriesForeign investigationAyres S2R · Isla Bejucal, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a AYRES S2R airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions of…NTSB ERA19WA165Accident · 1 fatalForeign investigationRobinson R22 · Pegognaga, ItalyThe government of Italy has notified the NTSB of an accident involving a Robinson R22 Beta helicopter that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions…NTSB WPR19TA131Accident · No injuriesClass 3Final reportRobinson R22 · Lincoln Park, NJThe flight instructor's failure to maintain control of the helicopter while transitioning from a hover to forward flight, which resulted in a loss of control.NTSB GAA19CA239Accident · No injuriesData collectionFinal reportGippsland GA8 · Bethel, AKThe pilot's failure to maintain adequate clearance from a shipping container while taxiing.NTSB DCA19WA222Accident · Serious injuriesForeign investigationBoeing 737 · Narita, JapanThe government of Japan has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of ICAO…NTSB CEN19LA133Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR20 · Mineral Wells, TXThe in-flight separation of the right aileron when the inboard hinge bolt disengaged from its nut plate due to excessively twisted safety wire, which resulted in a torsional overstress fracture that caused the inboard hinge bolt to become unsecured.NTSB WPR19LA132Accident · No injuriesClass 3 · LimitedFinal reportOtterback Lightning · Woodland, WAA complete loss of engine power due to carburetor icing.NTSB WPR19LA129Accident · Serious injuriesClass 3 · LimitedFinal reportStorch FL-156C · Upland, CAThe pilot’s improper installation of the No. 3 cylinder valve cover, which resulted in an oil leak, oil starvation, and a subsequent total loss of engine power.NTSB WPR19LA128Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Sedona, AZThe partial loss of engine power due to deteriorated O-rings in the throttle metering assembly. Contributing to the accident was non-compliance with the manufacturer's recommended throttle metering assembly overhaul schedule.NTSB WPR19FA126Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Mill Creek, CAA total loss of engine power due to oil starvation as a result of the failure of a gasket on the oil filter adapter and the pilot’s inability to clear power lines during the emergency landing.NTSB GAA19WA248Accident · 1 fatalForeign investigationPiper PA46 · Rigolet, NL, CanadaNTSB GAA19CA236Accident · No injuriesData collectionFinal reportCessna 172 · Wasilla, AKThe flight instructor's failure to verify the fuel level, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing and collision with a power line pole. Contributing to the accident was the student pilot's…NTSB ERA19FA161Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Tyrone, PAThe pilot’s continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into trees and terrain.NTSB WPR19TA142Accident · No injuriesClass 3Final reportZenair Zenith CH 701 · Marion, VAThe noncertificated pilot's failure to maintain control following a bounced landing and his decision to fly the airplane without proper training.NTSB GAA19CA238Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Sula, MTThe pilot's failure to maintain adequate clearance from ground equipment, which resulted in a tail rotor blade impact.NTSB GAA19CA232Accident · No injuriesData collectionFinal reportPavel Vagner TANGO2 · Cobden, ILThe pilot's failure to maintain the proper airspeed during the approach, which resulted in a hard landing.NTSB ERA19WA167Accident · No injuriesForeign investigationBell 206 · Sabanalarga, ColombiaThe government of Colombia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on April 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…NTSB ERA19TA166Accident · Minor injuriesClass 3Final reportCessna 172 · New Bern, NCThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB WPR19FA124Accident · 2 fatalClass 3 · FieldFinal reportVans RV 6 · Ridgefield, WAThe pilots' inadvertent exceedance of the airplane's critical angle of attack following an inflight collision with a bird.NTSB WPR19FA123Accident · 3 fatalClass 3 · FieldFinal reportRobinson R44 · Kailua, HIThe helicopter’s encounter with a strong downdraft or outflow boundary while operating at a higher than recommended airspeed in turbulence which resulted in a low-G condition, excessive main rotor flapping, and an in-flight breakup when the main rotor…NTSB GAA19CA372Accident · No injuriesData collectionFinal reportCessna T206 · Porterville, CAThe pilot's failure to verify that the rear cargo portion of the right cabin door was adequately secured before flight, which resulted in both portions of the door opening in flight and substantial damage to the fuselage.NTSB ERA19LA162Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Melbourne, FLA partial loss of engine power due to carburetor icing, and the flight instructor’s failure to effectively use carburetor heat while operating at an idle engine power setting in conditions conducive to carburetor icing.NTSB ENG19WA024Incident · No injuriesForeign investigationBoeing 767 · London, United KingdomThe United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Boeing 767-322, which occurred on April 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB WPR19LA125Accident · Minor injuriesClass 3 · LimitedFinal reportStearman A75N1(PT17) · Sequim, WAThe total loss of engine power due to the fatigue failure of the crankshaft.NTSB GAA19CA282Accident · No injuriesData collectionFinal reportCessna 172 · Edwards Air Force Base, CAAn undetermined event, which resulted in substantial damage to the airplane for reasons that could not be determined based on the available evidence.