NTSB investigations, 2013
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 ANC14CA009Accident · No injuriesData collectionFinal reportCessna A185F · Nenana, AKThe pilot's failure to maintain directional control of the airplane, which resulted in a collision with terrain.NTSB DCA14IA016Incident · No injuriesIncident investigationFinal reportBoeing 747 - 409LCF · Wichita, KSthe flight crew's failure to properly identify the airport and runway of intended landing. Contributing to the incident was the flight crew's failure to follow company procedures for crosschecking navigational information and visual cues to verify the airport…NTSB ANC14LA007Accident · No injuriesLimited investigationFinal reportBeech 1900C · Deadhorse, AKThe captain’s decision to initiate a visual flight rules approach and attempted landing into an area of instrument meteorological conditions, which resulted in the airplane touching down short of the runway. Contributing to the accident was the operator’s…NTSB ERA14WA047Accident · 1 fatalForeign investigationRobinson R66 · Rio de Janeiro, BrazilNTSB ERA14FA045Accident · 4 fatalField investigationFinal reportLearjet 35 · Fort Lauderdale, FLThe pilot's failure to maintain control of the airplane following an inflight deployment of the left engine thrust reverser. Contributing to the accident was the flight crew's failure to perform the appropriate emergency procedures, the copilot's lack of…NTSB CEN14FA064Accident · 1 fatalField investigationFinal reportCessna T210 · Cedaredge, COThe pilot's spatial disorientation while operating in dark night conditions in snow showers and his subsequent failure to maintain airplane control, which resulted in overstress of the airplane and an in-flight breakup. Contributing to the loss of control was…NTSB CEN14WA067Accident · 2 fatalForeign investigationRobinson R44 - II · Neuhausen ob Eck, GermanyOn November 19, 2013, at 1134 coordinated universal time, a Robinson R44 II, Germany-registered D-HOMI, was substantially damaged when it impacted forested terrain near Neuhausen ob Eck, Germany. Instrument meteorological conditions prevailed at the time of…NTSB CEN14WA062Accident · 6 fatalForeign investigationSocata TBM 700 · Mouffy, FranceNTSB CEN14FA057Accident · 2 fatalField investigationFinal reportCessna 152 · Spring, TXThe flight instructor's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and subsequent loss of airplane control.NTSB CEN14CA063Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Burwell, NEAn inadvertent collision with a deer during landing.NTSB WPR14LA056Accident · No injuriesLimited investigationFinal reportCessna T210 - F · Oceanside, CAThe pilot's failure to determine the actual onboard fuel quantity before beginning the flight, which resulted in a complete loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's habitual reliance solely on the cockpit fuel…NTSB WPR14LA055Accident · Serious injuriesLimited investigationFinal reportRichard S Duncan Avid Flyer · Lakeside, ORThe pilot/owner’s failure to comply with the engine manufacturer’s maintenance guidance, which resulted in the total loss of engine power due to the fracture failure of the plastic drive gear for the engine lubricating oil pump.NTSB ERA14FA044Accident · 1 fatalField investigationFinal reportFocke-Wulf FWP 149D · Kenansville, NCThe pilot’s loss of control in instrument meteorological conditions for reasons that could not be determined because examination of the airframe and engine revealed no anomalies that would have precluded normal operation. Contributing to the accident was the…NTSB DCA14RA012Accident · 50 fatalForeign investigationBoeing 737 - 500 · Kazan, RussiaThe Russian Interstate Aviation Committee, Accident Investigation Commission (IAC) has notified the NTSB of an accident involving a Boeing 737-500 that occurred on November 17, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the IAC…NTSB CEN14WA111Accident · 1 fatalForeign investigationJohnson Bekas 1A · Stalowa Wola, PolandOn Novenber 11, 2013, at 1245 coordinated universal time (1345 LMT), a BEKAS 1-A glider, registered SP-8017, owned and piloted by the accident pilot, was destroyed when it impacted terrain during a tow operation near Airfield Turbia (EPST), Stalowa Wola,…NTSB ERA14CA106Accident · No injuriesData collectionFinal reportCessna 172S · St. Augustine, FLThe student pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB CEN14WA068Accident · No injuriesForeign investigationBell 407 · Rio Ablajo, HondurasOn November 16, 2013, approximately 1030 central standard time, a Bell 407 helicopter, HR-AXO, sustained substantial damage during a hard landing for undetermined reasons near Rio Ablajo, Honduras. The pilot and six passengers were not injured. Visual…NTSB CEN14LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · San Antonio, TXA partial loss of engine power after departure due to the collapse of the carburetor air inlet duct, which restricted the airflow to the engine. Contributing to the accident was the overdue annual inspection and the installation of the improper air inlet duct.NTSB CEN14LA056Accident · 1 fatalLimited investigationFinal reportPearson Jon M Dragonfly · Anahuac, TXThe incorrect installation by the pilot, who was not a certificated mechanic or repairman, of the main rotor head bearing block, which resulted in the in-flight separation of the rotor head.NTSB ANC14WA020Incident · No injuriesForeign investigationCessna TU206 - G · Akita City, JapanOn November 16, 2013, at 0246 coordinated universal time, a Japanese registered Cessna 206 airplane, JA4000, operated by Honda Airways, experienced a total loss of engine power near Arayamachi, Akita City, Japan. The pilot made a successful emergency landing,…NTSB ANC14WA006Accident · 2 fatalForeign investigationSikorsky S76-C++ · Seoul, South KoreaOn November 16, 2013, about 2354 Coordinated Universal Time, a Sikorsky S76 C++ helicopter, Korean registration HL9294, operated by LG Electronics Co. Ltd., sustained substantial damage after colliding with a 26-story apartment building in Seoul, Korea. Both…NTSB ERA14LA043Accident · Serious injuriesLimited investigationFinal reportMaule M-5-180C · Marshfield, MAA partial loss of engine power for reasons that could not be determined in postaccident examinations because fire damage precluded testing of the fuel and several engine accessories.NTSB DCA14WA013Accident · No injuriesForeign investigationEmbraer ERJ190 - Undesignat · Buenos Aires, ArgentinaThe Junta de Investigaciones de Accidentes de Aviacion Civil (JIAAC) of the Republic of Argentina has notified the NTSB of an accident involving an Embraer E-190, which occurred on November 15, 2013. The NTSB has appointed a U.S. Accredited Representative to…NTSB CEN14CA061Accident · No injuriesData collectionFinal reportAviat A 1B · Cypress, TXThe pilot's failure to maintain control during landing which resulted in an impact with the runway surface.NTSB CEN14LA054Accident · No injuriesLimited investigationFinal reportQuicksilver Mxii Sport · Erie, COA loss of engine power due to a crankshaft failure, which resulted in a forced landing.NTSB WPR14CA053Accident · No injuriesData collectionFinal reportCessna 152 · Livermore, CAThe student pilot's failure to maintain directional control during the landing roll.NTSB CEN14LA066Accident · No injuriesLimited investigationFinal reportQuad City Challenger I · Winsted, MNThe pilot’s failure to maintain airspeed while maneuvering for a precautionary landing after the light sport airplane started vibrating, which led to an inadvertent aerodynamic stall.NTSB CEN14FA051Accident · 2 fatalField investigationFinal reportCessna T310R · Junction, TXThe noninstrument-rated private pilot's decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in the loss of airplane control. Contributing to the accident was the pilot’s failure to obtain a weather…NTSB ANC14CA005Accident · No injuriesData collectionFinal reportCessna 172 · Juneau, AKThe pilot's decision to land on an unsuitable surface, which resulted in a nose over.NTSB WPR14CA048Accident · No injuriesData collectionFinal reportMaule MX 7-235 · San Ynez, CAThe pilot's failure to maintain terrain clearance while maneuvering at low altitude in hilly terrain.NTSB ERA15WA034Accident · No injuriesForeign investigationBombardier CL 600 2B16 · Charallave, VenezuelaNTSB ERA14LA042Accident · No injuriesLimited investigationFinal reportPiper PA28 · Homestead, FLA total loss of engine power due to the in-flight separation of the No. 3 cylinder because of the fatigue cracking of its respective mounting studs and through bolts, which resulted from inadequate maintenance by unknown personnel.NTSB ERA14CA046Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Clewiston, FLThe student pilot's failure to maintain directional control during takeoff.NTSB CEN14FA047Accident · 3 fatalField investigationFinal reportBeechcraft B36TC · Amarillo, TXThe noninstrument-rated pilot’s improper decision to fly a night instrument approach in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane during an attempted missed approach.NTSB ERA14WA063Accident · 3 fatalForeign investigationPiper PA-34-220T · Parati, Brazil, BrazilOn November 10, 2013 about 1600 universal coordinated time, a Piper PA-34-220T, Brazilian registration PR-EAG, was destroyed when it collided during a climb with the peak of Corisco Mountain, located in the Serra do Mar mountain range, near Parati…NTSB ERA14WA041Accident · 4 fatalForeign investigationCirrus Design SR22 · Freeport, BahamasNTSB DCA14WA015Incident · No injuriesForeign investigationBoeing 737-400 · Zurich, SwitzerlandThe Swiss Accident Investigation Board (SAIB) has notified the NTSB of an incident involving a Boeing 737-400 that occurred on November 10, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the SAIB investigation under the provisions of…NTSB DCA14RA009Accident · 5 fatalForeign investigationSwearingen SA227 - AC · Red Lake, CanadaThe Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving a Swearingen SA227 that occurred on November 10, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the provisions…NTSB CEN14FA046Accident · 1 fatalField investigationFinal reportMitsubishi MU 2B-25 · Owasso, OKThe pilot's loss of airplane control during a known one-engine-inoperative condition. The reasons for the loss of control and engine shutdown could not be determined because the airplane was not equipped with a crash-resistant recorder and postaccident…NTSB CEN14CA059Accident · No injuriesData collectionFinal reportGroen Sparrowhawk II · Lubbock, TXThe pilot's failure to attain a proper glidepath for landing which resulted in a hard landing.NTSB WPR14LA049Accident · Serious injuriesLimited investigationFinal reportFirefly Balloons Firefly 10 · Temecula, CAThe pilot's failure to follow the Landing checklist and his inadvertent contact with the blast valve after landing, which released propane that was then ignited by an undetermined source.NTSB WPR14CA047Accident · Minor injuriesData collectionFinal reportAviat A 1B · LaGrange, WYThe pilot's decision to land on a rough surface with hidden obstructions (holes).NTSB CEN14LA050Accident · No injuriesLimited investigationFinal reportPiper PA 28-150 · Concordia, KSThe flight instructor’s improper decision to attempt a climb with an excessive pitch attitude for the tailwind condition and flap setting, which resulted in an approach to stall and subsequent off-field landing.NTSB CEN14LA048Accident · Minor injuriesLimited investigationFinal reportEurocopter Deutschland EC135P1 · Shreveport, LAThe mechanic's improper installation of the antitorque pedals, which resulted in an in-flight loss of helicopter control.NTSB DCA14WA070Incident · No injuriesForeign investigationBoeing 737 · Seville Airport, SpainThe government of Spain has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 08, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…NTSB WPR14LA050Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Carefree, AZThe failure of the left brake master cylinder seal, which rendered the left brake inoperative during landing.NTSB WPR14LA045Accident · Minor injuriesLimited investigationFinal reportCessna Ector 305A · Mokuleia, HIA landing gear brake malfunction during the landing for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB DCA14WA010Incident · No injuriesForeign investigationBoeing 737 · Buenas Aires, ArgentinaThe Junta de Investigaciones de Accidentes de Aviacion Civil (JIAAC) of the Republic of Argentina has notified the NTSB of an accident involving a Boeing 757-700 and an Embraer E-190, which occurred on November 7, 2013. The NTSB has appointed a U.S.…NTSB CEN14CA049Accident · No injuriesData collectionFinal reportMooney M20R · Fort Collins, COThe pilot did not maintain control of the airplane during the go around.NTSB WPR14FA044Accident · 3 fatalField investigationFinal reportCessna U206F · Donnelly, IDThe pilot's failure to maintain clearance from terrain while maneuvering in likely low-ceiling and low-visibility conditions in mountainous terrain.