NTSB investigations, 2013
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WHERE year(c.\"eventDate\") = 2013 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 WHERE year(c."eventDate") = 2013 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 CEN13WA560Accident · No injuriesForeign investigationBeech 76 - NO Series · Dublin, IrelandOn September 20, 2013, at 1703 hours universal coordinated time, a Beech model 76 Duchess, Ireland registration EI-BUN, was involved in a runway excursion after landing at the Weston Airfield (EIWT), Dublin, Ireland. The flight instructor and pilot receiving…NTSB WPR13LA416Accident · Serious injuriesLimited investigationFinal reportBeech C90 - A · Idaho Falls, IDThe pilot's inadequate preflight fuel planning, which resulted in departure with insufficient fuel to complete the flight, and consequent inflight power loss due to fuel exhaustion.NTSB ERA13CA422Accident · No injuriesData collectionFinal reportUniversal Stinson 108 1 · Lawrenceville, GAThe pilot's failure to maintain directional control during the landing, resulting in a ground loop, runway excursion, and structural damage to the right wing.NTSB DCA13WA158Incident · No injuriesForeign investigationBoeing 757 223 · San Andreas, ColombiaThe CAA of Colombia has notified the NTSB of an incident involving a Boeing 757-223 airplane that occurred on September 19, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of Colombia's investigation under the provisions of…NTSB ANC13CA104Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Delta Junction, AKThe pilot's inadequate takeoff planning and judgment that did not consider the reduced acceleration due to snow-covered terrain, which resulted in an aborted takeoff and collision with terrain.NTSB ERA13CA438Accident · No injuriesData collectionFinal reportCessna 182P · Newport News, VAThe pilot's failure to maintain directional control during landing resulting in a runway excursion.NTSB ENG13RA041Incident · No injuriesForeign investigationATR 72-500 · Makassar, Indonesia, IndonesiaNTSB DCA13WA159Incident · No injuriesForeign investigationBoeing 787 - 8QQ · Warsaw, PolandOn September 18, 2013, a LOT Polish Airlines, Boeing 787-8, registration number SP-LRB, powered by two Rolls-Royce Trent 100-67B turbofan engines experienced a maintenance status message “ENG FUEL FULTER R” during cruise from Beijing Capital International…NTSB CEN13LA552Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Frankenmuth, MIAn intermittent loss of engine power for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation.NTSB WPR13WA415Accident · 2 fatalForeign investigationLancair 360 - NO Series · Shenyang, ChinaOn September 17, 2013 about 0523 Universal Time, an experimental amateur-built Lancair, Canadian registration C-FXCK, collided with terrain while maneuvering near Shenyang, Liaoning Province, China. The airplane was participating in an aerobatic exhibition…NTSB WPR13LA414Accident · No injuriesLimited investigationFinal reportCessna 180 - B · Redmond, ORThe pilot's inability to counter an unexpected wind gust after touchdown, which resulted in a loss of directional control.NTSB WPR13FA411Accident · 1 fatalField investigationFinal reportBell UH 1B · Detroit, ORThe fatigue failure of the upper two tailboom attachment points, which resulted in the tailboom separating from the fuselage during logging operations. Contributing to the accident was poor maintenance throughout the helicopter’s operational life.NTSB WPR13CA413Accident · No injuriesData collectionFinal reportCessna T310R · San Luis Obispo, CAThe pilot's inadvertent action of retracting the landing gear instead of the flaps during the landing roll, which resulted in the right main landing gear collapsing.NTSB WPR13CA412Accident · Minor injuriesData collectionFinal reportPiper PA 11 · Bozeman, MTThe pilot's failure to maintain aircraft control and inadequate compensation for the high gusty wind conditions during taxi.NTSB WPR13WA410Accident · 2 fatalForeign investigationCessna U206 - G · Croydon, AustraliaOn September 15, 2013, about 1530 Eastern standard time, an Australian registered Cessna 206, VH-WAV, impacted terrain about 95 miles Southeast of Croydon, Queensland, Australia. The airplane was destroyed and the pilot and passenger were fatally injured. The…NTSB WPR13LA407Accident · No injuriesLimited investigationFinal reportMooney M20J · Lund, NVThe pilot’s failure to monitor the environment, which led to a collision with power lines during climbout. Contributing to the accident was the loss of engine power during low-altitude flight for reasons that could not be determined because postaccident…NTSB ERA14CA088Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot's failure to maintain directional control during the landing roll.NTSB CEN13WA574Incident · No injuriesForeign investigationPiper PA32R - 301T · Lille Lesquin, FranceOn September 15, 2013, about 1235 local time, a Piper, PA-32-301T, single engine airplane, F-GGBD, sustained minor damage during landing at Lille Lesquin airport (LFQQ), Lesquin, France. The solo pilot was not injured. The airplane was operated by a private…NTSB WPR13LA408Accident · No injuriesLimited investigationFinal reportCessna 182A · Casa Grande, AZA loss of engine power during final approach for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB WPR13CA409Accident · No injuriesData collectionFinal reportCessna 195A · Meadow Creek, MTThe pilot's failure to maintain directional control during the takeoff roll on a rough turf runway.NTSB ERA13CA417Accident · Serious injuriesData collectionFinal reportMiller/Culpepper Christen Eagle II · Blythe, GAThe pilot's failure to maintain aircraft control during takeoff which resulted in a stall and collision with terrain.NTSB ANC13CA101Accident · No injuriesData collectionFinal reportCessna 170B · Iliamna, AKThe pilot's inadvertent encounter with a mound while landing on a remote airstrip.NTSB ANC13CA098Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC 2 · Akhiok, AKThe pilot's failure to maintain directional control during takeoff in a gusty tailwind.NTSB ERA13CA420Accident · Minor injuriesData collectionFinal reportRolladen-Schneider LS 6 · Sussex, NJThe pilot's improper selection of an off-airport landing site, and his subsequent failure to maintain clearance from trees during a crosswind landing in gusty wind conditions.NTSB ERA13CA419Accident · No injuriesData collectionFinal reportPiper PA28 151 · Abingdon, VAThe failure of the pilot to maintain directional control during a crosswind landing resulting in collision with terrain and aft displacement of the nose landing gear.NTSB CEN13WA548Accident · 3 fatalForeign investigationRobinson R44 · Wygonin, PolandOn September 13, 2013, about 0750 coordinated universal time, a Robinson R44 II helicopter, SP-WNP, impacted terrain near Wygonin, Poland. A postimpact fire ensued. The pilot and two passengers were fatally injured and the helicopter was destroyed. The flight…NTSB CEN13CA550Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Princeton, MNAn in-flight collision with a bald eagle.NTSB CEN13CA549Accident · No injuriesData collectionFinal reportJabiru USA Sport J230-SP · Conway, ARThe pilot's failure to attain the proper landing approach speed and touchdown point, which resulted in a runway excursion after touchdown and collision with a blast fence.NTSB ANC13LA100Accident · Serious injuriesLimited investigationFinal reportCessna U206F · Kotzebue, AKThe pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB WPR13CA425Accident · No injuriesData collectionFinal reportCessna M337B · Spanish Fork, UTThe pilot's failure to properly manage fuel which resulted in fuel exhaustion and subsequent loss of power to the forward engine.NTSB WPR13CA406Accident · Minor injuriesData collectionFinal reportHughes 369D · Kalalau, HIThe entanglement of a tarp in the helicopter's main rotor from a nearby trash bundle.NTSB CEN13IA563Incident · Minor injuriesIncident investigationFinal reportPilatus PC-12/47E · Austin, TXThe pilot’s improper weight and balance calculations, which resulted in the airplane exceeding its weight and center-of-gravity limits and led to a loss of pitch control during takeoff, and the operator’s failure to obtain required weight information and to…NTSB WPR13LA404Accident · No injuriesLimited investigationFinal reportBell 47G5 · King City, CAThe failure of the helicopter’s center frame tube due to a fatigue crack and corrosion originating from a welded surface. Contributing to the accident was maintenance personnel’s inadequate inspection of the helicopter during its most recent 100-hour…NTSB WPR13FA405Accident · 2 fatalField investigationFinal reportKamtz RV-7A · Jackson Hole, WYA loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation. Also causal was the pilot’s failure to adequately compensate for the…NTSB ERA13FA412Accident · Serious injuriesField investigationFinal reportJoseph Bender Mustang II · Smoketown, PAThe pilot/owner/builder's failure to abort the takeoff and his subsequent failure to maintain airplane control. Contributing to the accident were the pilot's total lack of experience in the accident airplane and his lack of flying experience in the 3 1/2…NTSB CEN13CA544Accident · No injuriesData collectionFinal reportCessna 170A · Victoria, TXThe student pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB CEN13CA545Accident · No injuriesData collectionFinal reportSwedener Rans S-6ES · Mullen, NEThe gopher holes and soft terrain the airplane encountered, which resulted in the airplane nosing over.NTSB ANC13WA097Accident · 3 fatalForeign investigationMesserschmitt-Bolkow-Blohm BO 105-S · McClure Strait, CanadaOn September 9, 2013, about 1845 Mountain standard time, a Canadian Coast Guard Messerschmitt-Bolkow-Blohm (MBB) BO105-S helicopter, Canadian registration C-GCFU, crashed into ocean waters near McClure Strait, Canada. The three crew members on board were…NTSB WPR13LA432Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA 1C · Hemet, CAThe airplane’s hard landing due to the pilot’s failure to maintain sufficient airspeed while on approach after shutting down the engine because of the smoke in the cockpit from a burnt wire that originated from the alternator field terminal and extended to…NTSB WPR13LA402Accident · No injuriesLimited investigationFinal reportCessna 172N · Long Beach, CAThe total loss of engine power during initial climb due to debris within the carburetor mixture metering sleeve.NTSB ERA13WA411Accident · 2 fatalForeign investigationDornier 228 · Valparaiso, ChileOn September 9, 2013, about 0940 universal coordinated time (UTC), a Dornier 228-202K CC-CNW impacted terrain while on approach for landing at Viña del Mar Airfield/NAS Base Aeronaval Viña del Mar in Chile. The airplane was destroyed, and the commercial pilot…NTSB ANC13FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-260 · Yakutat, AKUndetermined because the pilot and airplane were not found.NTSB ANC13FA095Accident · 1 fatalField investigationFinal reportZenith 701 · Big Lake, AKThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in a stall and subsequent spin from which he could not recover.NTSB WPR13FA400Accident · 1 fatalField investigationFinal reportCantrell LW Challenger II SP · Prineville, ORThe in-flight failure of the left elevator control torque tube. Contributing to the accident was the improper assembly of the elevator control torque tubes.NTSB WPR13CA421Accident · No injuriesData collectionFinal reportCessna E162 · Eugene, ORThe pilot's improper flare that resulted in a bounced landing.NTSB WPR13CA403Accident · No injuriesData collectionFinal reportMaule M-7-260C · Nashua, MTThe pilot's failure to maintain clearance from a berm during the takeoff, which resulted in a loss of directional control.NTSB ERA13LA409Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Doylestown, PAA leaking parking brake valve, which allowed air to enter the left brake line and resulted in the eventual failure of the left wheel brake during the landing roll.NTSB ERA13LA408Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Woodstock, CTThe pilot’s improper preflight inspection, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA13LA407Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Guntersville, ALThe improper installation of the engine magneto by unknown maintenance personnel, which resulted in the magneto separating from the engine and a subsequent total loss of engine power. Contributing to the accident was the pilot's delay in proceeding directly…NTSB ERA13CA415Accident · No injuriesData collectionFinal reportHawker Beechcraft G36 · Edgartown, MAThe pilot's failure to achieve a proper takeoff profile prior to raising the landing gear resulting in a collision with terrain.