NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 WPR10LA149Accident · Minor injuriesLimited investigationFinal reportSchafer Starduster SA-300 · North Bend, ORThe complete loss of engine power during cruise for undetermined reasons.NTSB CEN10WA134Accident · 2 fatalForeign investigationCessna 150 · Waldzell, AustriaThis accident is under the jurisdiction and control of the Austrian government.NTSB CEN10FA130Accident · 2 fatalField investigationFinal reportBeech C24R · Bristow, OKThe pilot’s loss of control for undetermined reasons while maneuvering at low altitude.NTSB CEN10CA132Accident · No injuriesData collectionFinal reportCessna 172 · Davis, OKThe flight instructor’s improper recovery from a bounced landing.NTSB ERA10FA154Accident · 1 fatalField investigationFinal reportBeech P35 · Edgewater, MDThe pilot's failure to maintain adequate airspeed while on approach, which resulted in an inadvertent stall. Contributing to the accident was the pilot's likely impairment due to back pain, symptoms of opiate withdrawal, or both.NTSB ERA10CA231Accident · Minor injuriesData collectionFinal reportCessna 340A · Grove City, PAThe pilot's failure to maintain directional control after electing to land on a snow-covered runway.NTSB CEN10LA129Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Gatesville, TXThe pilot’s incapacitation as a result of one or more pre-existing medical conditions.NTSB CEN10CA154Accident · No injuriesData collectionFinal reportGrumman American AA-5 · Maple Lake, MNThe pilot's failure to maintain a proper glide path during a simulated forced landing and the flight instructor's delayed remedial action to execute a go-around.NTSB WPR10LA155Accident · No injuriesLimited investigationFinal reportKeller FK1 Stol · Dixie, IDThe failure of the experimental FK1 pilot to maintain clearance from a parked airplane while landing.NTSB ERA10WA160Accident · 2 fatalForeign investigationCessna 310R · Nova Lima, BrazilOn Feburary 26, 2010, about 1119 UTC, a Cessna 310R, Brazilian registration PT-OID, was destroyed when it collided with mountainous terrain near Nova Lima, Brazil. The pilot and one passenger were killed. The flight originated from Leopoldina, Brazil (SNDN)…NTSB CEN10RA133Accident · 5 fatalForeign investigationCessna 206 · San Pedro, BelizeNTSB ERA10WA153Accident · 7 fatalForeign investigationCessna U206F · Nazca, PeruOn February 25, 2010, about 1630 universal coordinated time (1130 local time), a Cessna U206F, Peruvian registration OB-1117, operated by Nazca Airlines, was destroyed when it impacted terrain near Nazca, Ica Province, Peru. The Peruvian commercial pilot and…NTSB ERA10FA150Accident · 2 fatalField investigationFinal reportBeech C23 · Winter Haven, FLThe pilot’s improper placement of the fuel selector valve during takeoff, and his failure to maintain adequate airspeed following a total loss of engine power resulting in an inadvertent stall. Contributing to the accident was the failure of maintenance…NTSB ERA10CA152Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Patillas, PRThe student pilot’s decision to abort the takeoff with insufficient runway remaining.NTSB ENG10RA039Incident · No injuriesForeign investigationDe Havilland DHC6 · Manston, UK, United KingdomOn February 24, 2010 during a ferry flight from Calgary, Canada to the Maldives, a De Havilland DHC-6 300 Twin Otter C-FAKB experienced an electrical fire in the power distribution and generator control box located in the roof of the passenger cabin. The crew…NTSB CEN10LA142Accident · No injuriesLimited investigationFinal reportBombardier BD-100-1A10 · Wheeling, ILThe deicing vehicle operator's not adhering to company procedures and not maintaining clearance between the vehicle's boom and the airplane's empennage during the airplane's deicing operation.NTSB CEN10LA127Accident · No injuriesLimited investigationFinal reportHawker Beechcraft 65-B80 · Minneapolis, MNThe pilot of the other airplane not setting the parking brake adequately while holding for departure. Contributing to the accident was the pilot of the other airplane being distracted while doing his paperwork.NTSB WPR10LA125Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Byron, CAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB WPR10CA146Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Delta, UTThe student pilot's incorrect use of the flaps and failure to attain and maintain an adequate airspeed during the attempted go-around procedure, which led to a stall/mush condition. Contributing to the accident was the student pilot's lack of familiarity with…NTSB ERA10FA148Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Springfield, KYThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…NTSB ERA10CA213Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot’s improper flare and recovery from a bounced landing.NTSB CEN10LA198Accident · No injuriesLimited investigationFinal reportAmerican Champion 7KCAB · Greeley, COAn in-flight failure of the wing fabric for undetermined reasons.NTSB WPR10CA145Accident · No injuriesData collectionFinal reportTerrell Caragol RV-7 · Oregon City, ORThe pilot’s failure to attain a proper touchdown point.NTSB WPR10CA144Accident · No injuriesData collectionFinal reportCessna 172 · Sparks, NVA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the correct fuel selector position.NTSB CEN10FA125Accident · 2 fatalField investigationFinal reportPiper PA 46-350P · Belleville, ILThe pilot’s spatial disorientation and subsequent failure to maintain airplane control during the instrument approach.NTSB ANC10CA018Accident · No injuriesData collectionFinal reportCessna 180B · Kodiak, AKThe pilot's selection of unsuitable terrain for landing, and his excessive use of brakes during the landing roll.NTSB ERA10LA151Accident · Serious injuriesLimited investigationFinal reportCotter Stits Playmate · Williston, FLA loss of engine power during approach due to fuel exhaustion as a result of the pilot's fuel mismanagement.NTSB ERA10IA147Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Nashville, TNA loss of engine power due to the mechanic’s failure to properly secure the fuel control unit fuel lines after replacement of the starter adapter.NTSB DCA10WA043Incident · No injuriesForeign investigationBoeing 757 - 236 · Bacelona, SpainThe UK Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a B757-236 that occurred on February 21, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of…NTSB DCA10WA040Incident · No injuriesForeign investigationBoeing 727 · Torino, ItalyOn February 21, 2010, a Thomas Cook Boeing 757-200, registration G-TCBA, experienced an uncommanded fuel dump during initial climb after takeoff from Turin International Airport (LIMF), Torino, Italy. There were no injuries to the 8 crew members and 231…NTSB CEN10LA128Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lockhart, TXThe flight instructor’s failure to use the emergency checklist, and his failure to extend the landing gear manually. Contributing to the accident was the electrical failure/malfunction for reasons undetermined.NTSB WPR10FA142Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Groveland, CAThe pilot's continued flight into night instrument meteorological conditions during the landing approach, which resulted in an in-flight loss of aircraft control due to spatial disorientation.NTSB WPR10CA143Accident · No injuriesData collectionFinal reportNorth American AT-6C · Mesa, AZThe pilot's inadequate compensation for the crosswind and failure to maintain directional control of the airplane during landing.NTSB WPR10LA141Accident · No injuriesLimited investigationFinal reportCessna 208B · Sacramento, CAAn in-flight collision with a bird while on final approach.NTSB ERA10WA157Accident · 4 fatalForeign investigationBell 206 · Carayaca, VenezuelaOn February 19, 2010, about 1950 Universal Coordinated Time, a Bell 206B helicopter, Venezuelan registration YV2191, operated by Aeromedic 2005, was lost from contact with Maiquetia approach control. The helicopter departed from Generalisimo Francisco de…NTSB DCA10CA032Accident · Serious injuriesData collectionFinal reportBoeing 747 · Anchorage, AKan inadvertent encounter with clear air turbulence.NTSB WPR10LA140Accident · No injuriesLimited investigationFinal reportCessna 210L · Aurora, ORThe failure of the landing gear to properly function for undetermined reasons, resulting in the right main landing gear collapsing during landing. Contributing to the accident was the pilot's failure to follow the emergency gear extension procedure.NTSB WPR10LA139Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Colfax, WAA partial loss of engine power due to carburetor ice as a result of the pilot's failure to use carburetor heat.NTSB ERA10LA146Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carthage, NCA total loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB CEN10LA126Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Albany, OHThe pilot’s decision to initiate and continue the flight into known icing conditions with an airplane not properly equipped for flight into icing conditions which exceeded the capabilities of the airplane.NTSB CEN10FA124Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Austin, TXThe pilot’s intentional flight into a building.NTSB WPR10LA138Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Parlier, CAThe pilot inadvertently entered a low-G condition during cruise flight, which resulted in a momentary loss of control of the helicopter and mast bumping.NTSB WPR10LA137Accident · No injuriesLimited investigationFinal reportFouga CM 170 Magister · Imperial, CAThe pilot's inadequate preflight inspection and his failure to ensure that the speed brakes were retracted, which resulted in a loss of control during takeoff.NTSB WPR10FA136Accident · 3 fatalField investigationFinal reportCessna 310R · Palo Alto, CAThe pilot’s failure follow the standard instrument departure as instructed, and his failure to attain a sufficient altitude to maintain clearance from power lines during takeoff in instrument meteorological conditions.NTSB DCA10WA095Incident · No injuriesForeign investigationBoeing 757 · Las Palmas, SpainOn February 17, 2010, at 1555 UTC, a Thompson Airways Boeing 757 experienced pilot and first officer airspeed indicator anomalies during climbout from Gran Canaria Airport (LPA), Las Palmas, Canary Islands, Spain. The event occurred during a period of…NTSB CEN10FA122Accident · 2 fatalField investigationFinal reportPiper PA-30 · Amarillo, TXThe pilot’s failure to detect water contaminated fuel, which resulted in a loss of engine power shortly after takeoff. Contributing to the accident were the worn and loose fuel caps, which allowed water to enter the fuel tanks.NTSB ANC10LA019Accident · No injuriesLimited investigationFinal reportCessna 208B · Kwigillingok, AKThe pilot's decision to take off with ice-contaminated wings in freezing rain and mist, which resulted in an aerodynamic stall.NTSB WPR10IA135Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Los Angeles, CAThe flight crew’s failure to maintain clearance from the jet bridge during taxi. Contributing to the incident was the ramp marshaller's diverted attention and failure to signal the flight crew to stop at the correct position.NTSB ERA10FA140Accident · 5 fatalField investigationFinal reportCessna T337G · Farmingdale, NJThe pilots’ failure to adhere to the airplane’s operating limitations, which resulted in overload failure of the right wing. Findings of the investigation were the adverse effects of multiple supplemental type certificates (STC) to the airframe wing structure…NTSB WPR10FA133Accident · 5 fatalField investigationFinal reportEurocopter EC135 · Cave Creek, AZThe sudden and inadvertent lowering of the collective to near the lower stop, followed by a simultaneous movement of the collective back up and the cyclic control to a nearly full-aft position, which resulted in the main rotor disc diverging from its normal…