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 ANC10LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · South Naknek, AKThe loss of engine power during cruise flight for an undetermined reason, resulting in an emergency landing and collision with terrain.NTSB ANC10CA092Accident · Minor injuriesData collectionFinal reportPiper J5A · Chickaloon, AKThe pilot's excessive use of brakes during a rejected takeoff, resulting in a nose over.NTSB ANC10CA086Accident · No injuriesData collectionFinal reportRoberts Alan W Kitfox II · Fairbanks, AKThe pilot's failure to maintain proper aircraft control during landing and the subsequent go-around, resulting in a hard landing, and a collision with a signpost.NTSB ANC10CA085Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Coldfoot, AKThe pilot's selection of an unsuitable (short) off-airport site for takeoff.NTSB WPR10LA457Accident · No injuriesLimited investigationFinal reportMyers THORP-18 · Jerome, IDThe pilot's failure to maintain directional control during the landing roll in gusty crosswinds.NTSB ERA10WA507Accident · 2 fatalForeign investigationRobinson R44 · Itanhaem, BrazilOn September 10, 2010, about 1445 Universal Coordinated Time (UTC), a Robinson Helicopters R44, Brazilian registration PT-YON, operated by AM Transportes Ltda ME, crashed into mountainous terrain near Itanhaem, State of Sao Paulo, Brazil. The flight was en…NTSB ERA10LA475Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fayetteville, WVA loss of engine power due to the failure of the left magneto system’s distributor gear as a result of the improper maintenance of the magnetos by maintenance personnel.NTSB ERA10LA474Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Doerun, GAA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select an adequate forced landing site and his excess speed during the landing.NTSB CEN10IA535Incident · No injuriesIncident investigationFinal reportEmbraer 500 · Brenham, TXThe pilots’ decision to depart with a known failed brake control unit.NTSB ERA10CA473Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's inadequate compensation for crosswind conditions which resulted in a hard landing and loss of directional control.NTSB ERA10CA472Accident · Minor injuriesData collectionFinal reportCessna 180 · Huron, NYThe pilot's inadequate preflight planning and preparation, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN10LA531Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Buchanan, MIA failure of the engine's No. 3 and No. 4 cylinder valve lifters for undetermined reasons, which resulted in a total loss of engine power.NTSB CEN10CA532Accident · Minor injuriesData collectionFinal reportRobertson Velocity · Wooster, OHA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB ANC10CA096Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chicken, AKThe pilot's decision to fly at a low altitude in terrain and weather conditions conducive to turbulence and downdrafts.NTSB ERA10FA471Accident · 1 fatalField investigationFinal reportCessna 182T · Helena, GAThe pilot’s continuance of the GPS approach below the minimum descent altitude while landing in instrument meteorological conditions.NTSB CEN10LA526Accident · 1 fatalLimited investigationFinal reportThompson Kolb Twinstar Mark · Elkhart, INThe pilot's failure to maintain control of the airplane during the landing approach.NTSB CEN10CA527Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1-34R · Hampshire, ILThe pilot’s failure to attain the proper touchdown point, resulting in a runway overrun.NTSB WPR10LA452Accident · No injuriesLimited investigationFinal reportAerospatiale SA315 · Winters, CAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR10CA451Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Paradise Lakes Estates, CAThe pilot's failure to maintain clearance from a fence during taxi.NTSB ENG10WA057Accident · No injuriesForeign investigationTupolev TU154 · Izhma, RussiaOn September 7, 2010, an Alrosa Mirny Air Enterprise Tupolev Tu-154M, registration RA-85684, overran the runway at an abandoned air strip near the town of Izhma, Russia. This accident is being investigated by the Russian Interstate Aviation Committee (MAK).…NTSB CEN10FA520Accident · 2 fatalField investigationFinal reportCessna T210 · Mountain Home, ARThe pilot’s decision to continue flight into a known area of heavy rain and his subsequent failure to maintain aircraft control.NTSB WPR10FA449Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Las Vegas, NVThe pilot's inability to maintain a positive rate of climb after takeoff for undetermined reasons.NTSB WPR10CA480Accident · No injuriesData collectionFinal reportCessna A185 · Santa Ynez, CAThe pilot's failure to maintain directional control, likely due to the inadvertent control interference by a passenger. A finding in the accident was the pilot's improper pre flight briefing.NTSB WPR10CA425Accident · No injuriesData collectionFinal reportChris W Kleen RV-6 · Coeur D'Alene, IDThe pilot’s inadequate compensation for the crosswind that resulted in a loss of directional control.NTSB ERA10CA470Accident · Minor injuriesData collectionFinal reportNorth Wing Uum Sport X2 · Winterville, NCThe pilot's loss of directional control while landing during an encounter with a wind gust.NTSB ERA10CA469Accident · Serious injuriesData collectionFinal reportCessna 140 · Levant, METhe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB CEN10FA521Accident · No injuriesField investigationFinal reportCessna P210N · Caledonia, MIA loss of engine power as a result of a fatigue failure of the crankshaft due to the loss of engine case through-bolt torque. Contributing to the accident was a mechanic's use of incorrect hardware.NTSB CEN10CA536Accident · No injuriesData collectionFinal reportCessna A188B · Hondo, TXThe pilot’s delayed action to arrest the airplane’s descent, which resulted in a collision with terrain.NTSB CEN10CA522Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Berrien Springs, MIThe flight instructor's delayed remedial action, which resulted in a hard landing.NTSB ANC10CA088Accident · No injuriesData collectionFinal reportPiper PA-18-160 · Arctic Village, AKThe pilot's failure to maintain control of the airplane during an off-airport landing.NTSB CEN10WA534Accident · Minor injuriesForeign investigationCessna 208 · Pointe a Pitre, GuadeloupeOn September 5, 2010, at 1919 coordinated universal time, a Cessna 208B, French registered F-OIXZ, operated by Tropic Airlines, was substantially damaged during a forced landing near Pointe a Pitre, Guadeloupe. Visual meteorological conditions prevailed at…NTSB CEN10CA542Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Standard Cirrus · Moriarty, NMThe inadvertent opening of the cockpit canopy for undetermined reasons.NTSB CEN10CA540Accident · No injuriesData collectionFinal reportBeech E-90 · Colorado Springs, COThe pilot’s failure to ensure that the airplane’s parking brake was properly set before diverting his attention to other tasks.NTSB CEN10CA530Accident · No injuriesData collectionFinal reportCullis Ultracruiser Sport · Defiance, OHThe pilot's failure to maintain aircraft control during the landing roll.NTSB CEN10CA525Accident · Minor injuriesData collectionFinal reportWeber Acro Sport II · Plum City, WIThe pilot’s improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB OPS10IA538Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Los Angeles, CAFailure of the air traffic controller to exercise positive control of the situation by issuing clear and timely control instructions to the helicopter pilot. Contributing to the incident was delay by the helicopter pilot in responding to instructions issued…NTSB ERA10LA466Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Virginia Beach, VAA total loss of power due to water contamination in the fuel. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB ERA10FA464Accident · 2 fatalField investigationFinal reportCessna 150H · DeLand, FLThe pilot's failure to maintain adequate airspeed and airplane control during the initial climb, which resulted in an aerodynamic stall, wire strike, and subsequent impact with the ground.NTSB ERA10CA465Accident · No injuriesData collectionFinal reportStearman E75 · Jackson, GAThe pilot's diverted attention toward an unsecured engine cowl door after takeoff which resulted in his failure to maintain airspeed and altitude. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.NTSB CEN10WA538Accident · 2 fatalForeign investigationMooney M20J · Ryde, United KingdomOn September 4, 2010, approximately 1600 Universal Coordinated Time (UTC), a Mooney M20J single-engine airplane, G-JAST, and a Vans RV-4 single-engine airplane, G-MARX, collided in midair while maneuvering near Ryde, Isle of Wight, United Kingdom. G-JAST was…NTSB ANC10LA083Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Tuluksak, AKThe pilot's delayed application of full power during a soft/wet field takeoff, resulting in a collision with trees during takeoff.NTSB WPR10LA472Accident · No injuriesLimited investigationFinal reportCessna T188C · Craigmont, IDThe pilot's failure to maintain directional control during the landing roll.NTSB WPR10LA446Accident · Serious injuriesLimited investigationFinal reportBell 47G · Salinas, CAThe pilot's visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and loss of helicopter control.NTSB WPR10CA453Accident · No injuriesData collectionFinal reportCessna 150C · Fields, ORThe pilot's misjudged landing flare, resulting in a bounced landing and loss of directional control. Contributing to the accident was the pilot's inaccurate perception of the airplane’s proximity to the ground as a result of the featureless white landing area.NTSB WPR10CA447Accident · Serious injuriesData collectionFinal reportChampion 7EC · Aurora, ORThe pilot’s failure to maintain directional control during an attempted go around after landing, resulting in a runway excursion.NTSB DCA10RA092Accident · 2 fatalClass 5 · ForeignBoeing 747-44AF · Dubai, United Arab EmiratesNTSB CEN10WA574Accident · 2 fatalForeign investigationBell OH-58 · Tuxtlas, MexicoOn September 3, 2010, at an unknown time, a Bell OH-58, Mexican registration XY-KYY, was substantially damaged when it impacted terrain while conducting crop dusting operations near Tuxtlas, Mexico. Visual meteorological conditions prevailed at the time of…NTSB CEN10FA519Accident · Serious injuriesField investigationFinal reportKwech Glasair RG Super 11S · Lake Elmo, MNThe pilot's failure to maintain control of the airplane during takeoff with gusty wind conditions, which resulted in a collision with terrain.NTSB CEN10CA565Accident · No injuriesData collectionFinal reportNorth American AT-6 · Blakesburg, IAThe pilot's excessive airspeed during the landing, which resulted in his decision to perform an intentional ground loop to avoid a runway overrun.NTSB WPR10LA445Accident · Serious injuriesLimited investigationFinal reportMorehead KR-2 · Rancho Murieta, CAThe pilot’s improper flare and recovery from a bounced landing.