NTSB investigations, 2015
82 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 31 |
| 2010 | 52 |
| 2011 | 44 |
| 2012 | 47 |
| 2013 | 43 |
| 2014 | 65 |
| 2015 | 82 |
| 2016 | 100 |
| 2017 | 83 |
| 2018 | 98 |
| 2019 | 83 |
| 2020 | 87 |
| 2021 | 95 |
| 2022 | 124 |
| 2023 | 152 |
| 2024 | 122 |
| 2025 | 120 |
| 2026 | 263 |
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\") = 2015
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2015 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN16WA071Accident · 2 fatalForeign investigationSocata TB9 · Malaga, SpainThe Comisión De Investigación De Accidentes E Incidentes De Aviación Civil (CIAIAC) of Spain has notified the NTSB of a fatal accident involving a Socata TB-9 airplane, EC-LIQ, that occurred on December 24, 2015. The NTSB has appointed a U.S. Accredited…NTSB DCA16WA048Incident · No injuriesForeign investigationBoeing 737 · Gwangju-Si, South KoreaThe government of Republic Of Korea has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Republic Of Korea's investigation…NTSB WPR16WA051Accident · 10 fatalForeign investigationBeech 200 · New Delhi, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a Beech Super King Air B-200, registration VT-BSA, that occurred on December 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB ANC16WA007Accident · 2 fatalForeign investigationBell 206 · New Taipei City, TaiwanOn November 22, 2015, about 0302 Coordinated Universal Time, a Bell 206 helicopter, Taiwan Island registration number B-31127, operated by Emerald Pacific Airlines, was destroyed following an impact with terrain about 7 nautical miles southwest of Taipei…NTSB CEN16WA044Accident · 3 fatalForeign investigationBell 206 · San Carlos, NicaraguaOn November 17, 2015, about 1140 coordinated universal time, a Bell 206L4 helicopter, Nicaraguan registered YN-ISA, impacted the San Juan River near San Carlos, Rio San Juan, Nicaragua. The pilot and three passengers were fatally injured and the helicopter…NTSB CEN16WA045Accident · 4 fatalForeign investigationPiper PA 46 350P · Taunton, United KingdomNTSB ERA16WA038Accident · 1 fatalForeign investigationAir Tractor AT-502B · Balsas, BrazilOn November 11, 2015, about 1930 universal coordinated time, an Air Tractor AT502B, Brazilian registration PR-RSA, was destroyed when it impacted terrain shortly after takeoff from Balsas Airport, Balsas Brazil. The pilot was fatally injured. The flight was…NTSB DCA16WA016Incident · No injuriesForeign investigationBoeing 737 · Nicosia, CyprusThe Accident Investigation Board of Turkey (AAIB) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on November 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB DCA16WA015Accident · 224 fatalForeign investigationAirbus A321 · Sinai Peninsula, EgyptThe Egyptian Ministry of Civil Aviation has notified the NTSB of an accident involving a AIRBUS A321 airplane, with IAE V2533 engines, that occurred on October 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Egyptian's…NTSB ANC16WA002Accident · 1 fatalForeign investigationBell 206B · Asquinth, CanadaOn October 27, 2015, about 2043 central daylight time, a Bell 206B helicopter, C-GIFY, impacted terrain near Asquinth, Saskatchewan, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of Canada is…NTSB ERA16WA050Accident · 2 fatalForeign investigationCessna 150H · Rondonopolis Municipality, BrazilOn October 22, 2015, about 1130 coordinated universal time , a Cessna 150H, Brazilian registration PR-DMT, was destroyed when it impacted terrain while on approach to land at Rondonopolis Airport, Rondonopolis, Mato Grosso, Brazil. The two occupants were…NTSB CEN16WA020Accident · 4 fatalForeign investigationLearjet 31 · La Tinaja, MexicoThe Direccion General de Aeronutica Civil (DGAC) of Mexico has notified the NTSB of an fatal accident involving a LearJet 31A, XB-GYB, that occurred on October 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC under the…NTSB ERA16LA058Accident · No injuriesLimited investigationFinal reportCessna R182 · Sanford, FLA collapse of the nose landing gear due to a separation of the drag attachment fitting from the airframe. The separation was likely due to preexisting damage from an undetermined event.NTSB ANC16WA004Accident · 2 fatalForeign investigationCessna 207 · Taylor, CanadaOn October 16, 2015, about 2330 Coordinated Universal Time, a Cessna 207 airplane, C-GNVZ, impacted terrain near Taylor, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The Transportation Safety Board…NTSB ERA16WA013Accident · 3 fatalForeign investigationCessna 208B · Yumbillo, ColombiaOn October 14, 2016, about 1645 coordinated universal time, a Cessna 208B, Brazilian registration PR-MIC, operated by Microsurvey Aerogeofisica E Consultoria Cientifica of Brazil, was destroyed when it impacted mountainous terrain during a survey flight near…NTSB CEN16WA009Accident · 2 fatalForeign investigationBell 430 · Xalapa, MexicoOn October 6, 2015, at 2355 coordinated universal time (UTC), a Bell 430 helicopter, Mexican registration XC-VER, collided with terrain after departure from the El Lencero Airport, Xalapa, Mexico. A postimpact fire ensued. The pilot and co-pilot were fatally…NTSB WPR16LA003Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Fall City, WAThe airplane’s collision with the ground short of the runway for reasons that could not be determined based on the available evidence.NTSB ERA16WA002Accident · 2 fatalForeign investigationPiper PA-31-325 · Chia, ColombiaOn October 3, 2015, about 1715 UTC, a Piper PA-31-325, Colombian registration HK3909G, registered to and operated by El Caminante Air S.A., collided with a structure then rolled inverted during a forced landing in a field near Hipodromo de los Andes, Chia,…NTSB CEN16WA002Accident · 2 fatalForeign investigationBeech 200 · Chigwell, United KingdomThe Air Accidents Investigation Branch (AAIB) United Kingdom has notified the NTSB of an incident involving a Beech B200 that occurred on October 3, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB DCA15WA204Accident · No injuriesForeign investigationDe Havilland DHC8 · Saarbrucken, GermanyThe government of Germany has notified the NTSB of an accident involving a DE HAVILLAND DHC8 airplane that occurred on September 30, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the…NTSB ERA15WA370Accident · 4 fatalForeign investigationBell 206 · Maceio, BrazilOn September 23, 2015, at 1350 universal coordinated time, a Bell 206L-3, Brazilian registration PP-ELA, was destroyed when it impacted terrain in Maceio, Brazil. The four occupants were fatally injured. The local police patrol flight originated at Zumbi dos…NTSB ANC15LA073Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Fort Glenn, AKThe separation of the tail rotor gearbox from the tailboom attachment point due to overstress loads imposed by a tail rotor blade imbalance as the result of impact with an undetermined object during low-level flight operations.NTSB GAA15LA281Accident · No injuriesLimited investigationFinal reportDehavilland DHC 2 MK.I · Nikolai, AKA loss of directional control during a water takeoff for reasons that could not be determined because the airplane was not examined due to the remote accident location.NTSB DCA15WA197Incident · No injuriesForeign investigationBoeing 737 · Frankfort, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800 that occurred on September 14, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…NTSB WPR15WA271Accident · 4 fatalForeign investigationBell 407 · Chong Qing, China, ChinaOn September 13, 2015, at 0600 local time, a Bell 407 GX, B-7702, operated by Chong Qing General Aviation Corporation, collided with terrain during an aerial photo operation near Chong Qing, P. R. China. The helicopter was being operated under the pertinent…NTSB DCA15WA203Incident · No injuriesForeign investigationAirbus A320 · Perth, AustraliaThe Australian Transport Safety Board (ATSB) has notified the NTSB of an incident involving a AIRBUS A320 airplane, which occurred on September 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB ERA15WA355Accident · 2 fatalForeign investigationSmith AEROSTAR600 · Santa Fé de Antioquia, ColombiaNTSB ERA15FA351Accident · 1 fatalField investigationFinal reportCessna 172 · Riegelwood, NCThe noncertificated pilot’s failure to maintain adequate clearance from terrain for reasons that could not be determined based on the available evidence.NTSB CEN15WA406Accident · 1 fatalForeign investigationBeech Beech C 24R · Könnern, GermanyOn September 10, 2015 about 0830 UTC, a Beech C24R Sierra airplane, German registration D-EHZK, crashed into a field under unknown circumstances near Könnern, Germany. The pilot, who was the sole occupant, was fatally injured. The flight departed from the…NTSB CEN15WA454Accident · 2 fatalForeign investigationRobinson R44 · Foleyet, CanadaOn September 9, 2015, about 0015 Universal Time Coordinated, a Robinson R-44, C-GZFX, owned and operated by Apex Helicopters Inc. was found in a heavily wooded area about 17 nautical miles south of Foleyet, Ontario. The pilot and one passenger were fatally…NTSB WPR15WA259Accident · 1 fatalForeign investigationCessna 172 · Ballarat, Australia, AustraliaOn September 8, 2015, at 1542 local time, a Cessna 172S, VH-ZEW, collided with terrain near Ballarat, Australia. The airplane was being operated under the pertinent civil regulations of the Government of Australia. The airplane was destroyed and the pilot,…NTSB WPR15FA258Accident · 2 fatalField investigationFinal reportSilvaire Luscombe 8A · Creswell, ORThe pilot's decision to return to the runway shortly after takeoff, and his failure to maintain adequate airspeed during the turn, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall and spin.NTSB DCA15WA188Accident · 7 fatalForeign investigationBoeing 737 · Tambacounda, SenegalNTSB CEN15LA391Accident · Minor injuriesLimited investigationFinal reportFerence John W Thatcher CX4A · Hebron, OHThe loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN15WA380Accident · 6 fatalForeign investigationDehavilland DHC-2 MK. I · Lac Long, CanadaOn August 23, 2015, about 1530 coordinated universal time, a De Havilland DHC-2 MK. I airplane, collided with wooded mountainous terrain near Lac Long, Quebec, Canada. The pilot and 5 passengers were fatally injured. The accident investigation is under the…NTSB CEN15WA397Accident · Minor injuriesForeign investigationRobinson R44 · Natolin village, PolandOn August 22, 2015 about 1515 UTC, a Robinson R44 helicopter, Poland registration SP-TVN, made a hard landing, during a precautionary landing, following an engine issue near Natolin village, Radom-Sadkow airport, Poland. The pilot was not injured and the…NTSB WPR15LA242Accident · 1 fatalLimited investigationFinal reportBartels Lancair · Pacific Ocean (Pacific Ocean)The pilot's incapacitation for reasons that could not be determined because the airplane was not recovered from the ocean.NTSB DCA15RA171Accident · No injuriesForeign investigationSikorsky S76 - C · Lagos, NigeriaThe Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving a SIKORSKY S76 - C helicopter that occurred on August 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the NAIB investigation under the…NTSB CEN15WA420Accident · 4 fatalForeign investigationEmbraer EMB505 · Blackbushe Airport, United KingdomOn July 31, 2015, at 1408 universal coordinated time (UTC), a Embraer EMB-505, Phenom 300, airplane, registered HZ-IBN, impacted a terrain during landing at the Blackbushe Airport (EGLK), United Kingdom. The pilot and three passengers were fatally injured.…NTSB ANC15WA061Accident · 1 fatalForeign investigationCessna 182 · Seibert Lake, CanadaOn July 26, 2015, about 1738 mountain daylight time, a Cessna 182 airplane, C-FWVQ, impacted terrain shortly after takeoff from Seibert Lake, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board…NTSB ANC15WA060Accident · 3 fatalForeign investigationPiper PA46 - 350P · Tokyo, JapanOn July 26, 2015, at 0200 coordinated universal time, a Japanese registered Piper PA46-350P airplane, JA4060, operated by a private individual, impacted a residential area shortly after takeoff from Chofu Airfield, Tokyo, Japan. The pilot, one passenger, and…NTSB CEN15LA319Accident · No injuriesLimited investigationFinal reportCessna 182E · Rozet, WYThe loss of engine power for reasons that could not be determined because an examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR15WA224Accident · 1 fatalForeign investigationGlasair SH-2FT · Wedderburn, AustraliaOn July 19, 2015 about 1700 local time, an amateur built Glasair SH-2FT, Australian registration VH-HRG, collided with terrain near Wedderburn, Victoria, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The investigation…NTSB WPR15WA213Accident · 2 fatalForeign investigationBell 407 - NO Series · Zhejiang Province, P.R. China, ChinaOn July 9, 2015 at 0225 Universal Coordinated Time, a Bell 407, B-7723, was substantially damaged when it crashed at the Qiandao Lake General Aviation airport, Zhejiang Province P. R. China, while conducting a post-repair hovering test. A total of seven…NTSB WPR15WA211Accident · 1 fatalForeign investigationAmature Built Pitts · Maitland, Australia, AustraliaOn July 8, 2015, at 1641 local time, an amateur built Pitts 12, VH-JDZ, collided with terrain near Maitland, Australia and was destroyed by postimpact fire. The pilot, the sole occupant, was fatally injured. The airplane was being operated under the pertinent…NTSB CEN15FA289Accident · 1 fatalField investigationFinal reportCessna 172P · Bartlett, ILThe pilot’s loss of airplane control for reasons that could not be determined because an examination of the airplane did not reveal any preimpact abnormalities.NTSB WPR15FA206Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Carey, IDUndetermined because examination of the airplane wreckage did not reveal any anomalies that would have precluded normal operation.NTSB GAA15CA187Accident · No injuriesData collectionFinal reportHier James A Long EZ · Show Low, AZThe right main landing gear leg fracture, which resulted in the landing gear wheel separation and a runway excursion.NTSB CEN15WA283Accident · 2 fatalForeign investigationLake LA4 - 200 · Split, CroatiaOn June 25, 2015, at 1735 universal coordinated time (UTC), a Lake Aircraft LA4-200, Croatian Registration 9A-DLA, was destroyed when it contacted the sea near the Split Airport (LDSP), Resnik, Croatia. One pilot and the sole passenger were fatally injured.…NTSB CEN15LA285Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Danville, ARThe loss of engine power for reasons that could not be determined based on the available information.