NTSB investigations, 2013
32 cases where the defining event was Unknown or undetermined.
Cases per year
| 2008 | 13 |
|---|---|
| 2009 | 20 |
| 2010 | 34 |
| 2011 | 34 |
| 2012 | 36 |
| 2013 | 32 |
| 2014 | 56 |
| 2015 | 72 |
| 2016 | 92 |
| 2017 | 78 |
| 2018 | 94 |
| 2019 | 68 |
| 2020 | 73 |
| 2021 | 89 |
| 2022 | 106 |
| 2023 | 134 |
| 2024 | 115 |
| 2025 | 118 |
| 2026 | 273 |
Where
Open the mapLatest cases
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
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '000')
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 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '000') 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 CEN14WA093Accident · 4 fatalForeign investigationRobinson Helicopter R 44 · Bordeaux, FranceOn December 20, 2013, about 1715 central European time, a Robinson R44 helicopter, French registered F-GPJG, owned and piloted by the accident pilot, was destroyed when it impacted the Dordogne River under unknown circumstances near Bordeaux, France. Visual…NTSB WPR14WA072Accident · 1 fatalForeign investigationHughes 369E · Lake Ross, New Zealand, New ZealandOn December 15, 2013, at 0400 universal coordinated time, a Hughes 369E, ZK-HNA, collided with terrain under unknown circumstances near Lake Ross, South Island, New Zealand. The flight was operated by Milford Helicopters under the pertinent civil regulations…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 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 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 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 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 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 DCA14WA007Accident · 10 fatalForeign investigationSwearingen SA227 · Riberalta, BoliviaThe government of Bolivia has notified the NTSB of an accident involving a SWEARINGEN SA227 airplane that occurred on November 03, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the…NTSB CEN14WA038Accident · 3 fatalClass 5 · ForeignPiper PA-34 · Coburg, GermanyOn November 11, 2013, at 1020 coordinated universal time, a Piper PA-34, German registration D-GRCP, impacted trees while on approach to land at the Coburg/Brandensteinsebene Airport (EDQC), Coburg, Germany. The pilot and two passengers were fatally injured.…NTSB CEN14FA034Accident · 3 fatalField investigationFinal reportPiper PA 23-250 · Caledonia, MNThe pilot's loss of control for reasons that could not be determined because the postaccident airplane examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN14WA012Accident · 1 fatalForeign investigationCessna 172R · Krems, AustriaOn October 20, 2013, about 0825 coordinated universal time, a Cessna 172R, OE-KRP, impacted terrain shortly after takeoff from the Krems Langenlois Airport, Krems, Austria. The private pilot was fatally injured and the passenger sustained serious injuries.…NTSB ERA14WA038Accident · 5 fatalForeign investigationPiper PA-28R-200 · Corumbá, Mato Grosso do Sul, BrazilOn October 19, 2013, about 1105 universal coordinated time, a Piper PA-28R-200, Brazilian registration PT-NKO, was destroyed when it impacted terrain under unknown circumstances, near Corumba Municipality, Brazil. The foreign certificated pilot and four…NTSB CEN14WA029Accident · 14 fatalForeign investigationCessna 208B · Loreto, BCS, MexicoOn October 14, 2013, about 1401 universal time coordinated, a Cessna 208B, XA-TXM, was destroyed when it impacted terrain near Loreto, Baja California Sur, Mexico. The pilot and thirteen passengers on board were fatally injured. The flight originated from the…NTSB CEN14WA536Accident · No injuriesForeign investigationSikorsky S92 · Stavanger, NorwayOn October 4, 2013, at 1435 coordinated universal time (UTC), a Sikorsky S-92A helicopter, Norwegian registration LN-ONW, made an emergency landing on the unmanned and decommissioned Yme oil rig. The two crew members and 12 passengers were uninjured. The…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 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 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 CEN13WA527Accident · 2 fatalForeign investigationCessna T303 · JerseyNTSB CEN13WA516Accident · 7 fatalForeign investigationPiper PA-32T · Wickede, GermanyOn August 27, 2013, at 1521 coordinated universal time, a Piper PA-32T, German registered D-EERB, was destroyed when it impacted terrain under unknown circumstances near Wickede, Germany. Visual meteorological conditions prevailed at the time of the accident.…NTSB CEN13WA505Accident · 4 fatalForeign investigationCessna T210F · Culiacan, MexicoOn August 25, 2013, a Mexican registered Cessna T210F, XB-MYI, impacted terrain near Culiacan, Mexico. The pilot and three passengers received fatal injuries. The airplane was destroyed by post impact fire. The flight originated from La Noria, Mexico, but the…NTSB CEN14WA225Accident · 4 fatalForeign investigationAirbus Helicopters 332L2 · Shetland Islands, United KingdomOn August 23, 2013, about 1717 UTC, an Airbus Helicopters AS332 L2, G-WNSB (s/n 2582) ditched into the North Sea near the Shetland Islands. The helicopter was destroyed and four passengers were fatally injured. This investigation is under the jurisdiction and…NTSB ERA13LA360Accident · Minor injuriesLimited investigationFinal reportQuest Kodiak 100 · Westport, MAA failure to achieve a positive climb rate after takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB WPR13CA348Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZA substantially damaged firewall that occurred during an unknown phase of flight for reasons that could not be determined.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 DCA13WA107Incident · No injuriesForeign investigationBoeing 737-800 · Sydney, AustraliaThe Australian Transport Safety Bureau (ATSB), has notified the NTSB of an incident involving a Boeing 737-800 that occurred on June 10, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of…NTSB WPR13WA157Accident · 4 fatalForeign investigationRobinson R44 · Bulli Tops, Australia, AustraliaOn March 21, 2013, about 1207 local time, a Robinson Helicopter R44, VH-HWQ, collided with terrain near Bulli Tops, Australia. The pilot was operating the helicopter under the provisions of the Australian Civil Aviation Regulations. The pilot and three…NTSB ERA13WA178Accident · 10 fatalForeign investigationEmbraer EMB-820C · Almeirim Municipality, BrazilOn March 12, 2013, about 2330 UTC, an Embraer Aircraft EMB-820C, PT-VAQ, operated by Fretax Taxi Aereo Ltda, crashed during approach to Monte Dourado Airport (SBMD), Almeirim, Brazil. Visual meteorological conditions prevailed at the time and flight plan…NTSB WPR13FA116Accident · 1 fatalField investigationFinal reportCessna 172S · Minden, NVThe pilot’s failure to maintain airplane control while maneuvering over mountainous terrain.NTSB ERA13WA128Accident · 5 fatalForeign investigationBeech C90 · Candido Mota, BrazilOn February 3, 2013, about 2230 coordinated universal time, a Beech C90A, Brazilian registration PP-AVG, was destroyed when it impacted terrain near Cândido Mota, Brazil. The pilot and four passengers were fatally injured. The flight originated from Regional…NTSB ERA13WA124Accident · 2 fatalForeign investigationBell 206B · Sao Paulo, BrazilOn January 21, 2013, at 1448 universal coordinated time, a Bell Helicopter 206B, Brazilian registration PR-JBN, sustained substantial damage when it impacted a dwelling. One crewmember and one passenger received fatal injuries and the two other passengers…NTSB ERA13FA109Accident · 2 fatalField investigationFinal reportBenton Fred D Seawind 3000 · Sarasota, FLThe pilot's inability to establish a normal climb rate after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.