NTSB investigations, 2013
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WPR14CA067Accident · Serious injuriesData collectionFinal reportBeech 58P · Kalispell, MTThe pilot's failure to maintain airplane control during the landing sequence.NTSB WPR14CA064Accident · No injuriesData collectionFinal reportPiper PA 16 · San Carlos, CAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR14CA063Accident · No injuriesData collectionFinal reportBurkhart Grob G 103 Twin II · Bryon, CAThe pilot's failure to maintain adequate wing clearance from a runway sign while taxiing.NTSB ERA14FA068Accident · 3 fatalField investigationFinal reportCessna 310R · Jacksonville, FLThe pilot’s failure to maintain airplane control during a missed approach in night instrument meteorological conditions due to spatial disorientation and a lack of instrument proficiency.NTSB CEN14WA180Accident · No injuriesForeign investigationChristen Industries Pitts S-2B · Meaux-Esbly, FranceOn December 8, 2013, at 1607 coordinated universal time, a Pitts S-2B airplane, F-GEAL, experienced a loss of engine power and conducted a force landing near Meaux-Esbly, France. The pilot and passenger were not injured. The airplane was substantially…NTSB CEN14FA077Accident · 2 fatalField investigationFinal reportAviat A-1C-200 · Los Alamos, NMThe pilot’s loss of airplane control while maneuvering after takeoff in gusty wind conditions.NTSB CEN14LA080Accident · No injuriesLimited investigationFinal reportPiper PA46 500TP · Albuquerque, NMThe pilot’s loss of directional control during landing due to his inadequate compensation for the tailwind.NTSB CEN14CA078Accident · No injuriesData collectionFinal reportCessna 152 · Columbia Station, OHThe pilot's inadequate flight planning and decision to land on the soft grass/turf runway which resulted in a nose over.NTSB WPR14CA066Accident · No injuriesData collectionFinal reportMcdonnell Douglas Helicopter 369E · Monticello, UTThe passenger's accidental discharge of the net gun which resulted in the net going through a main rotor blade.NTSB ERA14FA066Accident · 1 fatalField investigationFinal reportTexas Helicopter M74L · Sebring, FLA partial loss of engine power as a result of contamination of the engine’s fuel supply, and the pilot’s impaired performance due to his use of diphenhydramine, which resulted in his inability to complete a forced or precautionary autorotative landing…NTSB WPR14LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Fair Oaks, CAThe loss of engine power during cruise flight for reasons that could not be determined because postaccident examinations of the airplane and engine did not reveal any anomalies that would have precluded normal operation.NTSB DCA14WA019Accident · No injuriesForeign investigationBoeing 767 - 300ER · Madrid, SpainNTSB CEN14CA082Accident · No injuriesData collectionFinal reportSikorsky S 76B · Port Fourchon, LAThe pilot's loss of control of the helicopter when it entered a settling with power condition during sudden gusty wind conditions on takeoff resulting in the helicopter subsequently impacting terrain.NTSB ERA14WA069Accident · 5 fatalForeign investigationBritten Norman BN2A - 2 · Novo Prgresso, BrazilOn December 4, 2013, about 1430 coordinated universal time (UTC), a Britten Norman Aircraft, model BN-2A, Brazilian registration PT-WMY, was substantially damaged when it impacted the ground shortly after takeoff from Novo Progresso Airport (SJNP), Novo…NTSB DCA14WA020Accident · No injuriesForeign investigationBoeing 747 · Abuja, NigeriaNTSB CEN14LA079Accident · Serious injuriesLimited investigationFinal reportThompson William A Sparrow II · Jeromesville, OHThe student pilot's in-flight loss of control while attempting to return to the runway following a loss of engine power. The cause of the loss of engine power could not be determined because the postaccident examination did not reveal any anomalies.NTSB ANC14CA010Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Soldotna, AKThe operation of the airplane by the uncertificated student pilot, his failure to recognize conditions conducive to structural icing, and subsequent decision to depart in conditions conducive to structural icing, resulting in a severe icing encounter and…NTSB ERA14MA060Accident · 2 fatalMajor investigationFinal reportFairchild SA227-AC · La Alianza, PRThe flight crew's excessive elevator input during a rapid descent under night lighting conditions, which resulted in the overstress and breakup of the airplane. Contributing to the accident was an initial loss of airplane control for reasons that could not be…NTSB ERA14FA058Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Dawsonville, GAThe pilot’s in-flight loss of airplane control due to spatial disorientation while operating in dark night instrument meteorological conditions, which resulted in the exceedance of the airplane’s design stress limitations and a subsequent in-flight breakup.…NTSB ERA14CA062Accident · Minor injuriesData collectionFinal reportAnderson Andreas Rans S-6S · Traveler's Rest, SCThe pilot's decision to continue visual flight into deteriorating weather, which resulted in an encounter with instrument meteorological conditions and subsequent inability to maintain clearance with terrain.NTSB ERA14CA061Accident · Minor injuriesData collectionFinal reportAero Commander 680E · Crescent City, FLThe pilot's failure to maintain directional control during takeoff.NTSB WPR14CA060Accident · No injuriesData collectionFinal reportBeech G35 · Placerville, CAThe airplane's collision with a deer on the runway during landing.NTSB ERA14LA059Accident · Minor injuriesLimited investigationFinal reportMoffitt Oscar/ Kit Prostar A/C PT2 · Trenton, SCThe airplane owner/pilot ‘s failure to follow the gascolator manufacturer’s recommendations for installing and safety wiring the gascolator strainer bowl, which resulted in the bowl separating and a total loss of engine power due to fuel starvation.NTSB CEN14LA075Accident · No injuriesLimited investigationFinal reportCessna 560 · Walton, INThe inflight separation of the upper and lower right engine cowlings for reasons that could not be determined based on available evidence.NTSB WPR14FA094Accident · 5 fatalField investigationFinal reportBeech B36TC · Yellow Pine, IDThe pilot’s continued flight into known light-to-moderate icing conditions over mountainous terrain. Contributing to the accident was the loss of engine power due to induction icing.NTSB WPR14CA092Accident · No injuriesData collectionFinal reportCessna 177RG · Richland, WAThe pilot's failure to extend the landing gear prior to landing. Contributing to the accident was the pilot's diverted attention and not using a checklist.NTSB CEN14LA074Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-181 · Rock Lake, NDThe noninstrument-rated pilot’s failure to obtain weather briefings immediately before and during the flight and his continued flight into icing conditions, which resulted in the airplane’s loss of performance and the subsequent controlled descent into trees…NTSB ERA14LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Elkmont, ALA stuck exhaust valve, which resulted in a total loss of engine power at low altitude. Contributing to the accident were the pilot’s decision to fly at a low altitude, which reduced his forced landing options when the loss of engine power occurred; and poor…NTSB ERA14CA065Accident · No injuriesData collectionFinal reportCessna 150D · Portland, METhe failure of the pilot to maintain directional control during landing.NTSB DCA14RA018Accident · 33 fatalForeign investigationEmbraer ERJ190 - Undesignat · Rundu, NamibiaThe Namibia Ministry of Works and Transport (MWT) has notified the NTSB of an accident involving an Embraer ERJ-190 that occurred on November 30, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the MWT investigation under the…NTSB ANC14MA008Accident · 5 fatalMajor investigationFinal reportCessna 208B · Saint Marys, AKThe pilot's decision to initiate a visual flight rules approach into an area of instrument meteorological conditions at night and the flight coordinators' release of the flight without discussing the risks with the pilot, which resulted in the pilot…NTSB WPR14LA059Accident · No injuriesLimited investigationFinal reportCessna 210 · Florence, ORThe failure of the hydraulic power pack, which prevented the extension of the landing gear and resulted in a partial gear-up landing.NTSB CEN14WA073Accident · 9 fatalForeign investigationEurocopter EC135 · Glasgow, United KingdomOn November 29, 2013, at 2222 universal coordinated time (UTC), a United Kingdom registered EC-135 T2 helicopter, G-SPAO, impacted a public house near Glasgow, United Kingdom. The crew of three in the helicopter and six other persons were fatally injured. The…NTSB CEN14FA071Accident · 1 fatalField investigationFinal reportCessna 182E · Delta, COThe student pilot’s decision to attempt flight into instrument meteorological conditions, which resulted in a loss of control and ground impact.NTSB ERA14LA052Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Trussville, ALThe failure of the No. 2 connecting rod due to oil starvation, which resulted in a total loss of engine power.NTSB ERA14LA051Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Montrose, PAThe pilot’s failure to check the fuel tanks for contaminants after fueling, which resulted in a total loss of engine power due to water contamination.NTSB ERA14CA055Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Tunica, MSThe student pilot's failure to maintain control of the helicopter during the attempted takeoff, and the flight instructor's inadequate supervision of the student pilot.NTSB ENG14RA004Incident · No injuriesForeign investigationSaab Saab 2000 · Lugano, SwitzerlandOn November 28, 2013, about 630 UTC, a SAAB 2000 airplane, HB-IZW, experienced an engine failure during climb out after takeoff in Switzerland. The location was not reported. The 2 pilots, 1 crew member and 25 passengers were not injured. Damage to the…NTSB CEN14LA076Accident · No injuriesLimited investigationFinal reportCessna T210L · Lake Providence, LAThe pilot's mismanagement of available fuel and incorrect use of the fuel boost pump which resulted in a total loss of engine power at a low altitude.NTSB CEN14FA072Accident · 1 fatalField investigationFinal reportBiesemeier David I Smyth Sidewinder · Boulder, COThe pilot’s abrupt maneuver, which exceeded the structural limits of the left wing and resulted in its in-flight separation.NTSB WPR14CA058Accident · No injuriesData collectionFinal reportQuad City Ultralight Acft Challenger II · Kalispell, MTA loss of engine power due to the spark plug coming out of the cylinder head.NTSB ERA14LA048Accident · No injuriesLimited investigationFinal reportCessna 150L · Hopewell, ALA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight inspection and preflight and inflight fuel planning that did not account for increased headwind.NTSB ERA14FA049Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Graniteville, SCThe pilot's improper maintenance of the airplane's fuel system, which resulted a loss of power in the left engine due to fuel starvation. Also causal was the pilot's failure to maintain minimum controllable airspeed following the loss of engine power, which…NTSB DCA14WA017Accident · No injuriesForeign investigationCessna C208B · Kamusi, Papua New GuineaOn November 25, 2013, about 0100 UTC, P2-SAH (previous US Reg N41149), a Cessna Grand Caravan (C208B) airplane, operated by Tropicair, reportedly had an engine failure and crashed during a forced landing near the Kamusi airport, Kamusi, Papua New Guinea. On…NTSB DCA14CA031Accident · No injuriesData collectionFinal reportDe Havilland DHC8 - 102 · Philadelphia, PAan inadvertent encounter with several birds during approach that resulted in substantial damage to the airplane.NTSB ANC14CA012Accident · No injuriesData collectionFinal reportDouglas DC-6 · Nuiqsut, AKA load shift during takeoff, which resulted in substantial damage to the aft bulkhead and associated structures.NTSB ERA14LA071Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Monroe, NCThe pilot’s operation of the airplane with underinflated tires, which resulted in the right tire’s failure during takeoff and a subsequent runway excursion.NTSB DCA14WA033Accident · No injuriesForeign investigationMcdonnell Douglas MD11 - F · Sao Paulo, BrazilThe Government of Brazil (CENIPA) has notified the NTSB of an accident involving a McDonnell Douglas MD11F, which occurred on November 24, 2013. The accident investigation has been delegated to the Bundesstelle für Flugunfalluntersuchung, German Federal…NTSB CEN14CA070Accident · No injuriesData collectionFinal reportCessna 172 · New Orleans, LAThe pilot's failure to maintain aircraft control after starting the engine, which resulted in a collision with a building.NTSB WPR14CA057Accident · No injuriesData collectionFinal reportNew Piper PA46 350P · Salt Lake City, UTThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the pilot's improper use of the checklist.