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 WPR18FA251Accident · 1 fatalClass 2 · FieldFinal reportMooney M20J · Palo Alto, CAThe pilot’s failure to maintain aircraft control during a go-around due to his premature flap retraction, which resulted in an aerodynamic stall and subsequent loss of control.NTSB WPR18FA249Accident · 1 fatalField investigationFinal reportCessna 150L · Pacoima, CAA loss of engine power shortly after takeoff due to fuel exhaustion, and the exceedance of the airplane's critical angle of attack when the flight instructor made an abrupt turn back toward the runway, which resulted in an aerodynamic stall/spin at an…NTSB GAA18WA585Accident · No injuriesForeign investigationPiper PA28R · Cuatro Vientos, Spain, SpainThe government of Spain has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on September 04, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions…NTSB GAA18CA532Accident · No injuriesData collectionFinal reportCessna 206 · London, KYThe pilot’s failure to maintain directional control during takeoff with a tailwind.NTSB WPR18LA252Accident · No injuriesClass 3 · LimitedFinal reportGuimbal Cabri · Santa Ana, CAThe flight instructor's delayed application of power during a power recovery following an autorotation, which resulted in an unrecoverable low rotor rpm during the landing flare and subsequent loss of control.NTSB GAA18CA539Accident · No injuriesData collectionFinal reportSchweizer 269C · Delaware, OHThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA528Accident · No injuriesData collectionFinal reportBeech 200 · Burbank, CAThe flight instructor's and pilot receiving instruction's failure to maintain clearance from a tree while taxiing.NTSB CEN18WA403Accident · No injuriesForeign investigationRobin DR400 · Benodet, FranceOn September 3, 2018, about 1005 UTC, a Robin DR400 airplane, French registration F-GSBK, sustained a loss of engine power while in cruise flight near Benodet, France. The three occupants onboard sustained no injury. The airplane was destroyed. The accident…NTSB CEN18LA365Accident · Serious injuriesLimited investigationFinal reportMD Helicopters MD-369 · Orchard Lake, MIThe pilot's failure to maintain helicopter control and terrain clearance while in a hover after performing an evasive maneuver to avoid wildlife.NTSB ANC18LA069Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Wrangell, AKThe total loss of engine power due to oil starvation after an interruption of oil circulation for reasons that could not be determined based on the available evidence.NTSB WPR18FA247Accident · 2 fatalClass 3 · FieldFinal reportSchempp-Hirth Duo Discus T · New Washoe City, NVThe pilot’s delayed recovery from an inadvertent spin and/or spiral dive and an exceedance of the glider’s design limit load during recovery, which resulted in an overload failure of both wings.NTSB GAA18CA572Accident · No injuriesData collectionFinal reportCessna 180 · Yakutat, AKThe pilot’s failure to maintain lateral control of the airplane during a step-turn takeoff.NTSB GAA18CA536Accident · No injuriesData collectionFinal reportAeronca 11AC · Midland, TXThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA18CA531Accident · No injuriesData collectionFinal reportPiper PA44 · Centralia, ILThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended before landing. Contributing to the accident was the flight instructor’s delayed remedial action and…NTSB GAA18CA522Accident · No injuriesData collectionFinal reportPiper PA 12 · Rexburg, IDThe pilot's improper landing flare, which resulted in the airplane bouncing and a subsequent loss of directional control, a runway excursion, and impact with a fence.NTSB ERA18LA242Accident · Serious injuriesClass 3 · LimitedFinal reportStinson 108 · Indiana, PAA total loss of engine power as a result of debris contamination of the fuel, which resulted in fuel starvation.NTSB CEN18LA364Accident · Serious injuriesLimited investigationFinal reportLindstrand 77A · Brookfield, MOThe pilot's inability to maintain control of the balloon after encountering high wind conditions and windshear during the landing, which resulted in his ejection from the basket and serious injury to the passenger during the balloon’s subsequent impact with…NTSB WPR18WA254Accident · Serious injuriesForeign investigationCessna 182M · Leshiba Wilderness, South AfricaOn September 1, 2018, at 1247 universal coordinated time, a Cessna 182M, ZS-IAM, collided with trees while on final approach to land at Leshiba Wilderness, South Africa. The pilot and passenger were seriously injured. The airplane was substantially damaged.…NTSB GAA18CA557Accident · No injuriesData collectionFinal reportSchweizer SGS 1 35 · Burnet, TXThe pilot's failure to extend the landing gear before landing and to use the Before Landing checklist.NTSB GAA18CA551Accident · No injuriesData collectionFinal reportPiper PA28 · Cypress, TXThe student pilot’s improper approach path after the airplane encountered turbulence, which resulted in the airplane landing hard short of the runway.NTSB GAA18CA550Accident · No injuriesData collectionFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB GAA18CA527Accident · No injuriesData collectionFinal reportCessna 170 · Tulsa, OKThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB GAA18CA526Accident · No injuriesData collectionFinal reportCessna 172 · Karluk, AKThe pilot’s failure to maintain proper pitch for a soft-field landing, which resulted in a loss of airplane control.NTSB GAA18CA525Accident · No injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe pilot’s failure to maintain directional control during takeoff.NTSB GAA18CA523Accident · Minor injuriesData collectionFinal reportEggleston Daniel S-18 Thorp · Porterville, CAThe pilot’s failure to maintain directional control during the takeoff roll.NTSB ERA18WA247Accident · 1 fatalForeign investigationBeech 33 · Taquaraçu de Minas, BrazilThe government of Brazil has notified the NTSB of an accident involving a Beech 33 airplane that occurred on September 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB ERA18LA243Accident · No injuriesClass 3 · LimitedFinal reportPiper PA12 · Cochranton, PAA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA18LA241Accident · Minor injuriesLimited investigationFinal reportDiamond DA40 · Mount Pleasant, TNA total loss of engine power for reasons that could not be determined because postaccident examination of the airplane did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA18FA240Accident · 1 fatalField investigationFinal reportLance M Hooley Jetez · Covington, TNThe improper manufacture of the left wing, which resulted in a left wing flutter event and failure at low altitude and high speed.NTSB DCA18WA277Accident · Minor injuriesForeign investigationBoeing 737 · Sochi, RussiaThe Interstate Aviation Committee (MAK) of Russia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on September 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the MAK of Russia's investigation…NTSB CEN18TA374Accident · Minor injuriesFinal reportBeech 35 · Harrisville, MIThe pilot’s delayed decision to abort the takeoff, which resulted in the loss of lateral control of the airplane and collision with trees at the end of the runway. Contributing to the accident was the pilot’s decision to depart with a center of gravity…NTSB CEN18LA363Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Crete, NEThe stuck turbocharger wastegate in the closed position for reasons that could not be determined based on the available information. Also causal was the pilot's failure to reduce the throttle during takeoff when the manifold pressure and fuel flow exceeded…NTSB CEN18LA361Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 55 · Waupaca, WIThe total loss of engine power due to fuel exhaustion.NTSB CEN18FA368Accident · 1 fatalField investigationFinal reportPiper PA32RT · St Ignace, MIThe pilot's failure to maintain sufficient altitude after takeoff in dark night conditions which resulted in a collision with the water.NTSB WPR18LA246Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Tehachapi, CAThe pilot's inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power during the initial climb.NTSB GAA18CA579Accident · Minor injuriesData collectionFinal reportPiper PA28 · Porterville, CAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN18WA404Accident · No injuriesClass 5 · ForeignCessna 680 · Burgas, BulgariaNTSB CEN18WA396Accident · No injuriesForeign investigationAero Designs Pulsar · Heapham, United KingdomOn August 31, 2018, about 1700 coordinated universal time (UTC), an amateur-built Aero Designs Pulsar 1 airplane, United Kingdom registration G-LUED, serial number PFA 202-12122, was substantially damaged when it nosed-over after it overran the runway while…NTSB CEN18LA383Accident · No injuriesLimited investigationFinal reportPiper PA46 · Santa Teresa, NMThe pilot's decision to attempt to take off in an overweight airplane in high density altitude conditions, which resulted in the airplane’s inability to climb, an aborted takeoff, and a subsequent runway excursion.NTSB CEN18LA370Accident · No injuriesLimited investigationFinal reportCubcrafters CC11-160 · Lancaster, OHThe delayed application of carburetor heat by the pilot which led to accumulation of carburetor ice, eventual loss of engine power, and the subsequent forced landing in high vegetation.NTSB CEN18LA362Accident · Serious injuriesClass 3 · LimitedFinal reportLuscombe 8 · New Carlisle, OHA total loss of engine power shortly after takeoff due to carburetor ice.NTSB CEN18LA360Accident · No injuriesLimited investigationFinal reportStearman A75N1(PT17) · Kenosha, WIThe failed retaining bolt and cracked backing plate, which resulted in a shift of the brake lining to contact the brake drum and a subsequent wheel lock when the brakes were applied.NTSB CEN18FA359Accident · 2 fatalField investigationFinal reportPiper PA28R · Kaplan, LAThe pilot's failure to maintain clearance from a charted and illuminated television/radio tower.NTSB WPR18FA245Accident · 1 fatalClass 2 · FieldFinal reportCessna P210 · Prescott, AZThe pilot's misjudgment of distance and altitude from the runway and his subsequent failure to maintain an approach path that provided clearance from the terrain due to a visual illusion in dark night conditions.NTSB GAA18CA534Accident · No injuriesData collectionFinal reportRobinson R44 · Girdwood, AKThe fisherman's fishing rod striking the helicopter’s rotating main rotor disk during loading.NTSB ERA18LA239Accident · No injuriesClass 3 · LimitedFinal reportAvid MK-4 · Harnett, NCA total loss of engine power for reasons that could not be determined based on the available information.NTSB DCA18WA287Incident · No injuriesForeign investigationBoeing 747 · Hong Kong, Hong Kong SAR ChinaThe AAIA of Hong Kong has notified the NTSB of an accident involving a Boeing 747 airplane that occurred on August 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIA's investigation under the provisions of ICAO Annex 13 as…NTSB CEN18FA358Accident · 4 fatalField investigationFinal reportBeech B60 · Fort Walton Beach, FLThe pilot's controlled flight into terrain after misidentifying the destination airport during a period of restricted visibility due to weather.NTSB WPR18LA248Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Tat Momoli, AZA total loss of engine power due to a fatigue crack in the connecting rod bushing end.NTSB WPR18FA244Accident · 1 fatalField investigationFinal reportCessna 150 · Redding, CAThe pilot's exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's failure to properly configure the wing flaps for…