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 WPR14CA002Accident · No injuriesData collectionFinal reportAir Tractor AT 401 · Waco, TXThe pilot’s failure to maintain directional control during the takeoff in gusting wind conditions.NTSB WPR14CA001Accident · No injuriesData collectionFinal reportUnknown Unknown · Mount Pleasant, UTThe pilot's failure to maintain aircraft control during landing.NTSB WPR13FA430Accident · 4 fatalField investigationFinal reportCessna 525A · Santa Monica, CAThe pilot’s failure to adequately decrease the airplane’s ground speed or maintain directional control during the landing roll, which resulted in a runway excursion and collision with an airport sign and structure and a subsequent postcrash fire.NTSB ERA13CA435Accident · Minor injuriesData collectionFinal reportAeronca 65 CA · Thomaston, GAThe pilot's inadequate pre-flight planning and in-flight monitoring of the fuel level which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN13LA581Accident · No injuriesLimited investigationFinal reportCessna 172 · Rio Vista, TXThe student pilot’s failure to maintain adequate airspeed during the initial climb after an excessive takeoff run from a grass airstrip, which resulted in the exceedance of the airplane's critical angle-of-attack and a subsequent aerodynamic stall and loss of…NTSB CEN13LA570Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Algona, IAFuel exhaustion as a result of the pilot's failure to ensure he had sufficient fuel on board to complete the planned flight. Contributing to the accident was the incomplete information provided by the airport's AWOS.NTSB ANC13CA107Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Wasilla, AKThe pilot's improper preflight inspection, and failure to remove heavy frost from the airplane prior to attempting a takeoff.NTSB WPR13WA433Accident · 5 fatalForeign investigationBell 212 - NO Series · Murbad, Thane District, India, IndiaOn September 29, 2013, at 0820 universal coordinated time, a Bell 212, VT-HGB, collided with terrain during cruise flight near Murbad (Thane District), India. The helicopter was destroyed and two flight crew and three passengers were fatally injured. The…NTSB WPR13LA431Accident · Serious injuriesLimited investigationFinal reportBombardier DHC-8-402 · Reno, NVThe airplane’s encounter with known moderate-to-severe turbulence, which resulted in a serious injury to a flight attendant.NTSB WPR13LA429Accident · Minor injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Santa Maria, CAThe pilot's inadequate monitoring of the environment and failure to maintain clearance from transmission wires during a low-altitude maneuver.NTSB ERA13LA437Accident · Serious injuriesLimited investigationFinal reportInnovator Technologies Mosquito XEL · Felda, FLThe pilot’s loss of helicopter control while hovering for reasons that could not be determined during postaccident examination of the helicopter, which was limited due to postcrash fire damage.NTSB ERA13LA434Accident · 1 fatalLimited investigationFinal reportTimothy J Cowper Pitts Special S-1E · Edinburg, NYThe pilot’s failure to maintain adequate airspeed during low-altitude maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB ERA13CA436Accident · No injuriesData collectionFinal reportBeech A23 24 · Lumberton, NJThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN13LA571Accident · No injuriesLimited investigationFinal reportCessna 182J · Santa Teresa, NMA loss of engine power for reasons that could not be determined because no anomalies were found during the postaccident engine examination.NTSB CEN13CA569Accident · No injuriesData collectionFinal reportRans RV 12 · Hatley, WIThe pilot did not maintain control of the airplane while landing with a crosswind.NTSB ANC13CA106Accident · No injuriesData collectionFinal reportCessna 185E · Pilot Point, AKThe pilot's decision to land the airplane on the ramp, in the vicinity of buildings, in gusty wind conditions.NTSB WPR13CA428Accident · Minor injuriesData collectionFinal reportCessna 182Q · Big Bear, CAThe pilot's failure to maintain a stabilized landing approach, which resulted in a collision with a fence short of the runway.NTSB WPR13CA427Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Dell, MTThe pilot's failure to maintain directional control while taxiing in gusting wind conditions.NTSB ERA13LA433Accident · 1 fatalLimited investigationFinal reportEnstrom F-28C · Bloomsburg, PAThe relieved pilot’s failure to maintain clearance from the rotating main rotor blades after he exited the helicopter.NTSB ERA13FA432Accident · 1 fatalField investigationFinal reportLowerre Bruce T S 12-E · Pahokee, FLUndetermined because the wreckage was not recovered.NTSB ENG13WA043Incident · No injuriesClass 5 · ForeignBoeing 737 - 53C · Cusco, PeruOn September 26, 2013, about 2042 EST, a BOEING 737 - 53C airplane, OB-2041-P, experienced an in-flight engine shutdown near Cusco, Peru. The pilot was not injured. The airplane was not damaged. The investigation is under the jurisdiction of the government of…NTSB CEN13CA564Accident · Serious injuriesData collectionFinal reportTreidel Mark/R F D Dominator · Watkins, COThe pilot's loss of control of the gyroplane during takeoff roll, following his inadvertent release of the cyclic control.NTSB WPR13CA424Accident · Minor injuriesData collectionFinal reportRobinson R44 - II · Flagstaff, AZThe pilot's failure to maintain rotor rpm while landing in a gusty wind at a high density altitude.NTSB CEN13LA565Accident · No injuriesLimited investigationFinal reportCessna 210-5(205) · Weatherford, OKThe pilot’s inadequate preflight inspection and fuel planning, which resulted in fuel exhaustion and a total loss of engine power during descent.NTSB CEN13LA561Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Ulysses, KSAn in-flight fire and subsequent loss of engine power for reasons that could not be determined due to extensive fire damage to the airplane and its fuel and electrical systems.NTSB CEN13FA558Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Bolingbrook, ILThe pilot’s failure to maintain control of the airplane during a go-around.NTSB WPR13LA420Accident · 1 fatalLimited investigationFinal reportMiller RV6 · Williams, CAThe pilot's improper decision to fly at a low altitude, which resulted in his failure to maintain clearance from power lines.NTSB CEN13WA566Accident · 4 fatalForeign investigationCessna 421 - C · Colombier-Saugnieu, FranceNTSB CEN13LA557Accident · Serious injuriesLimited investigationFinal reportBeech 35 B33 · Urbana, INThe failure of the crankshaft following several overheating events that had led to a stress crack and the subsequent fracture forward of the No. 6 rod journal.NTSB CEN13CA556Accident · Serious injuriesData collectionFinal reportCessna 152 · Wadsworth, OHThe pilot's failure to adequately maintain airspeed during a go-around.NTSB ANC13CA105Accident · No injuriesData collectionFinal reportPiper PA 18 · Big Lake, AKThe pilot's selection of unsuitable terrain for landing, resulting in abnormal contact with terrain.NTSB WPR13WA423Accident · 1 fatalForeign investigationCessna 182 - R · Hamilton Aerodrome, Australia, AustraliaOn September 23, 2013, at 1950 universal coordinated time, a Cessna 182R, VH-AUT, collided with terrain near Hamilton Aerodrome, Australia. The flight was being operated under the pertinent civil regulations of Australia. The solo student pilot was fatally…NTSB WPR13LA419Accident · No injuriesLimited investigationFinal reportPiper PA60 602P · Sandpoint, IDThe pilot's failure to fly the approach at the appropriate landing speed and attain the correct touchdown point, which resulted in a runway overrun.NTSB ERA13LA428Accident · No injuriesLimited investigationFinal reportBeech A36 · Wellington, FLA total loss of engine power due to an interruption in fuel flow, which was most likely due to fuel starvation. Contributing to the accident was the pilot’s failure to maintain control of the airplane while performing the subsequent forced landing to a wet…NTSB CEN13LA562Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Mack, COA total loss of engine power due to the failure of the engine crankshaft, which resulted from maintenance personnel’s application of insufficient torque on the engine case through bolts.NTSB CEN13LA555Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine · St. Joseph, MIThe pilot's failure to maintain control of the powered-parachute during takeoff.NTSB ERA13LA429Accident · No injuriesLimited investigationFinal reportDe Havilland DH 82A · Rhinebeck, NYThe total loss of engine power for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation, which resulted in a forced landing into trees.NTSB ERA13CA426Accident · Serious injuriesData collectionFinal reportMarconi Fred I JR Velocity XL/RG · Pahokee, FLThe pilot's failure to ensure that the landing gear were extended during the simulated forced landing attempt. Contributing to the outcome was the pilot's decision to continue the aborted landing after the propeller had contacted the runway.NTSB CEN13LA567Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12 D · Laguna Park, TXThe pilot’s inadequate flare during landing, which resulted in a hard landing and the subsequent collapse of the left main landing gear.NTSB CEN13CA559Accident · No injuriesData collectionFinal reportCessna 182Q · Goodhue, MNThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR13FA417Accident · 2 fatalField investigationFinal reportBell UH-1V · Cordes Lakes, AZThe pilot's improper maintenance on the helicopter’s main rotor blade pitch control system, which resulted in an in-flight loss of main rotor blade pitch control, mast bumping, and mast failure.NTSB WPR13CA426Accident · No injuriesData collectionFinal reportPiper PA28 - 161 · Lancaster, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB WPR13CA422Accident · No injuriesData collectionFinal reportBeech 35 - Undesignat · Seattle, WAThe pilot's distracted attention and failure to extend the landing gear, which resulted in a gear up landing.NTSB WPR13CA418Accident · No injuriesData collectionFinal reportGrob G 103 Twin II · Morgan, UTAn incorrect descent rate while on final approach as a result of the flight instructor's delayed remedial action, which lead to an off-field landing and impact with terrain.NTSB ERA13WA430Accident · 3 fatalForeign investigationCessna R172K · Morona Santiago, EcuadorNTSB ERA13CA427Accident · Minor injuriesData collectionFinal reportCessna 182E · Middletown Springs, VTThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA13CA425Accident · No injuriesData collectionFinal reportLennox Kenneth J Zodiac 601HDS · Salisbury, MDThe pilot's inadequate compensation for the wind conditions while landing.NTSB ERA13LA421Accident · Serious injuriesLimited investigationFinal reportAmerican Eurocopter AS350B2 · Canton, MSThe pilot’s improper decision to continue flight with a low engine oil pressure warning light instead of landing immediately in accordance with the flight manual emergency checklist. Contributing to the accident was the maintenance technician’s failure to…NTSB ERA13FA424Accident · 1 fatalField investigationFinal reportBrown Robert K RV7A · Hamilton Township, NJThe pilot's improper aerobatic maneuver that resulted in a loss of control, exceedance of the airplane's design limitations, and a subsequent in-flight breakup of the airplane.NTSB ERA13CA423Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Ridgely, MDThe flight instructor's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall and collision with terrain.