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 WPR13CA280Accident · Minor injuriesData collectionFinal reportAviat A-1A · McCall, IDThe pilot’s failure to maintain adequate airspeed while on approach for landing, which resulted in a loss of airplane control and a hard landing.NTSB ERA13LA297Accident · Minor injuriesLimited investigationFinal reportBeech G-36 · Pompano Beach, FLThe pilot’s premature rotation during takeoff with a tailwind and his delayed retraction of the landing gear, which reduced the airplane’s climb performance and subsequently led to the collision with power lines.NTSB CEN13LA367Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · De Smet, SDA loss of engine power for reasons that could not be determined because postaccident examinations of the airplane and engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN13FA364Accident · 4 fatalField investigationFinal reportCessna 172M · Waterford, MIThe pilot's failure to retract the wing flaps before attempting to take off, due to his lack of familiarity with the airplane make and model, which prevented the airplane from maintaining adequate altitude for takeoff.NTSB WPR13CA279Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Cashmere, WAThe pilot’s improper application of the brakes during the landing ground roll, which resulted in a nose over.NTSB ERA13IA294Incident · No injuriesIncident investigationFinal reportIai GULFSTREAM200 · Jamestown, NYThe pilots’ failure to effectively use the airplane's primary (brakes), secondary (thrust reversers), and emergency braking systems to decelerate the airplane, which resulted in a runway excursion. Contributing to the accident was the pilots’ failure to…NTSB ERA13FA295Accident · 2 fatalField investigationFinal reportRockwell International 690B · McClellanville, SCThe pilot’s loss of airplane control during high-altitude maneuvering and his subsequent failure to recover airplane control. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot and his failure to perform remedial…NTSB ERA13CA298Accident · No injuriesData collectionFinal reportBellanca 7KCAB · East Aurora, NYThe pilot's failure to maintain aircraft control during a rejected takeoff on a soft turf runway with a gusty wind, resulting in the airplane nosing over.NTSB CEN13LA363Accident · No injuriesLimited investigationFinal reportThomsen Avid Flyer MK IV · Hibbing, MNA total loss of engine power for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA361Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Dayton, OHThe pilot’s loss of control of the airplane for reasons that could not be undetermined because a postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB ERA13LA311Accident · No injuriesLimited investigationFinal reportCessna 172M · Burlington, VTThe pilot's improper turn down an airport access road while attempting to taxi to a runway. Contributing to the accident was the airport management's failure to install proper signage indicating that an airport access road was prohibited to aircraft.NTSB ERA13LA299Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2B · Cleveland, GAThe taxiing pilot's inadequate visual lookout, which resulted in his airplane's collision with a stopped airplane.NTSB ERA13LA291Accident · No injuriesLimited investigationFinal reportCessna 172S · Clearwater, FLA total loss of engine power for reasons that could not be determined because neither postaccident visual examinations nor test runs of the engine revealed any anomalies that would have precluded normal operation.NTSB CEN13LA365Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Lansing, MIThe pilot’s failure to follow the airplane checklist, which resulted in the parking brake not being released before taxi and a subsequent brake fire.NTSB CEN13LA360Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Danbury, TXThe total loss of engine power due to the failure of a connecting rod for reasons that could not be determined during postaccident examination.NTSB CEN13LA359Accident · No injuriesLimited investigationFinal reportBell 206 - L4 · Lake City, ARA partial 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 CEN13FA357Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Maplewood, MNThe loss of helicopter control for reasons that could not be determined because an examination of the helicopter and its systems revealed no malfunctions or failures that would have precluded normal operation.NTSB ANC13CA056Accident · No injuriesData collectionFinal reportCub Crafters CC11-100 · Dillingham, AKA loss of engine power due to carburetor icing.NTSB ERA13WA293Accident · 2 fatalForeign investigationPiper PA-28-161 · Barcis, ItalyOn June 18, 2013 at 1655 Universal Coordinated Time (UTC), a Piper PA-28, French registration F-GHLY, privately operated, was substantially damaged when it impacted with the slope of a mountain near Barcis, Italy during a cross-country flight from Locarno…NTSB CEN13LA366Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124 · Cincinnati, OHLoss of control due to insufficient airspeed on takeoff and premature landing gear retraction, which resulted in the collapse of the left landing gear as the airplane impacted the runway.NTSB CEN13LA358Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Durango, COThe pilot's improper decision to take off with a tailwind at a high-density altitude, which resulted in the airplane’s failure to maintain the initial climb rate.NTSB WPR13LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waihee-Waiehu, HIThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies due to saltwater immersion.NTSB WPR13CA276Accident · No injuriesData collectionFinal reportGary W Bettis Harmon Rocket II · South Lake Tahoe, CAThe pilot's failure to maintain directional control during landing with a crosswind.NTSB CEN13LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Carrizo Springs, TXThe pilot’s failure to identify the water contamination of the fuel system during his preflight inspection, which resulted in a total loss of engine power during the airplane’s initial climb.NTSB WPR13LA274Accident · No injuriesLimited investigationFinal reportCessna T210L · Fresno, CAA hydraulic fluid leak in the nose landing gear actuator rod seal, which prevented the hydraulic system from building up sufficient pressure to fully retract or extend the main landing gear.NTSB WPR13LA272Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Needles, CAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning. Contributing to the severity of the front passenger’s injuries was the pilot’s decision to depart with more passengers than available seats, which resulted in…NTSB WPR13CA273Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Coolin, IDThe pilot’s failure to maintain an adequate glide path, which led to a runway excursion and collision with objects.NTSB ERA13WA290Accident · 1 fatalForeign investigationBeech 58 · Albenga, ItalyNTSB CEN13LA579Accident · Minor injuriesLimited investigationFinal reportBeech 58P · St Paul, MNThe pilot's failure to maintain directional control during a rejected landing, which resulted in a collision with an airport sign off the right side of the runway during the transition to the initial climb.NTSB CEN13LA353Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-802A · Minot, NDThe pilot’s failure to maintain adequate clearance from trees during an aerial application flight.NTSB CEN13CA410Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Elbert, COThe pilot's failure to maintain aircraft control while landing in gusting crosswind conditions. Contributing to the accident was the pilot's delayed return to the airport.NTSB ERA13LA288Accident · Serious injuriesLimited investigationFinal reportHagerty RV-7A · Altoona, PAThe pilot's improper recovery from an encounter with a wind gust during landing, which resulted in a hard landing on, and displacement of, the nose landing gear and a subsequent runway excursion and noseover.NTSB DCA13WA109Incident · No injuriesForeign investigationBoeing 737-800 · Thessaloniki, GreeceThe Air Accident Investigation and Aviation Safety Board (AAIASB) of Greece, has notified the NTSB of an incident involving a Boeing 737-800 that occurred on June 15, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIASB…NTSB CEN13FA352Accident · Serious injuriesField investigationFinal reportAero Commander 685 · Victoria, TXMaintenance personnel's failure to secure the left engine idler pin during overhaul, which resulted in a catastrophic engine failure and subsequent forced landing.NTSB CEN13FA351Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · La Pointe, WIThe pilot’s failure to maintain airplane control after deciding to go around after a gear-up landing, resulting in an aerodynamic stall.NTSB WPR13LA270Accident · No injuriesLimited investigationFinal reportAero Vodochody L39C · Reno, NVThe other pilot’s failure to see and avoid the airplane during an air race training session, which resulted in a midair collision.NTSB WPR13CA271Accident · No injuriesData collectionFinal reportCessna T210N · Salmon, IDThe pilot's decision to land on a wet grass airstrip, which resulted in a main landing gear collapse after a collision with rough terrain.NTSB ERA13WA289Accident · 2 fatalForeign investigationBell 212 · Tefe, BrazilOn June 14, 2013, about 0810 universal coordinated time, a Bell 212 helicopter, Brazilian registration PR-HRZ, operated by an oil and gas exploration and production company, was destroyed when it impacted terrain shortly after takeoff from a support base…NTSB ERA13WA287Accident · 4 fatalForeign investigationPiper PA22 · Taisha, EcuadorOn June 13, 2013, at 2028 coordinated universal time (1528 local time), a Piper PA-22-135, Ecuadorian registration HC-CMX, was destroyed when it impacted terrain shortly after taking off from Taisha Airport (SETH), Taisha, Morona-Santiago, Ecuador, en route…NTSB ERA13LA285Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Oxford, NCThe failure to comply with an airworthiness directive by maintenance personnel and incorrect reinstallation of the fuel selector handle by unknown personnel, which resulted in fuel starvation.NTSB ERA13CA286Accident · No injuriesData collectionFinal reportLuscombe 8A · Orangeburg, SCThe inadvertent slippage of the pilot's foot off the right rudder pedal, resulting in a loss of directional control on the ground, and the pilot's overly aggressive application of wheel brakes, resulting in a nose over.NTSB DCA13WA110Accident · No injuriesForeign investigationSaab 340 · Mangrove Cay, BahamasThe Air Accident Investigation and Prevention Unit (AAIPU) of the Bahamas, has notified the NTSB of an accident involving a SAAB 340 that occurred on June 13, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIPU investigation…NTSB DCA13CA106Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD-88 · Nashville, TNThe flight crews failure to maintain clearance from the light pole while taxiing.NTSB CEN13LA348Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Grand Forks, NDThe student pilot’s inadequate recovery from a bounced landing, which resulted in an aerodynamic stall during the go-around.NTSB ANC13WA057Accident · No injuriesForeign investigationAir Tractor AT-502 · Seosan, South KoreaOn June 13, 2013, about 0749 Korea standard time, a Air Tractor AT-502 airplane, Korea registration HL5105, was destroyed during a forced landing following a loss of engine control near, Seosan, Republic of Korea. The pilot was not injured. The airplane was…NTSB WPR13FA269Accident · 2 fatalField investigationFinal reportGraves SH-2F · Montague, CAThe pilot’s failure to maintain airplane control while maneuvering for reasons that could not be determined during postaccident testing and examination, which resulted in a stall and subsequent spin.NTSB ERA13LA281Accident · 1 fatalLimited investigationFinal reportCessna 172K · Newton, MSThe student pilot's failure to increase engine power during the descent for landing when instructed to do so by the flight instructor and the flight instructor's delayed remedial action, which resulted in collision with a static wire. Contributing to the…NTSB ERA13LA279Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Louisville, KYThe pilot's failure to set the correct flap position before takeoff and his inadequate preflight planning, which resulted in the operation of the airplane over the maximum allowable gross weight, both of which led to an aerodynamic stall at too low an…NTSB ERA13CA283Accident · No injuriesData collectionFinal reportHughes TH-55A · Morgantown, WVThe pilot’s inadequate planning which resulted in an encounter with settling with power and descent into terrain during takeoff.NTSB CEN13LA390Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Boise City, OKThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine and fuel system revealed no anomalies.