NTSB investigations
1,713 cases where the sequence of events included Unknown or undetermined.
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 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 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 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.NTSB ERA15WA247Accident · 1 fatalForeign investigationCessna T303 · Vaupes, ColombiaNTSB ERA15WA261Accident · 2 fatalForeign investigationIlyushin IL-103 · Brest, BelarusNTSB GAA15CA161Accident · No injuriesData collectionFinal reportCessna 172S · Galesburg, ILFirewall damage reported by maintenance personnel that occurred during an unknown phase of flight, because the accident flight and pilot could not be determined.NTSB CEN15WA262Accident · 1 fatalForeign investigationBell Helicopter 206B · Baldwin, United KingdomOn June 6, 2015, about 0810 coordinated universal time, a Bell 206B helicopter, G-RAMY, impacted mountainous terrain near Baldwin, Isle of Man, United Kingdom. The pilot, the sole occupant, was fatally injured.The accident investigation is under the…NTSB WPR15FA174Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Livermore, CAA loss of control for reasons that could not be determined, because examination of the airframe and engine revealed no anomalies that would have precluded normal operation.NTSB CEN15WA251Accident · 5 fatalForeign investigationM7 Aerospace SA226 - TC · Queretaro, MexicoOn June 2, 2015, about 1425 central daylight time, an M7 Aerospace LLC SA226-TC airplane, XA-UKP, impacted terrain near Queretaro, Mexico. A postimpact ground fire occurred. The pilot, co-pilot, and three passengers were fatally injured and the airplane was…NTSB WPR15LA168Accident · 1 fatalLimited investigationFinal reportHiller UH 12E · Wasco, CAAn in-flight impact with terrain for reasons that could not be determined based on available evidence.NTSB ANC15WA029Accident · 1 fatalForeign investigationAir Tractor AT802-A · Cold Lake, CanadaOn May 22, 2015, at 1630 mountain daylight time, a Canadian registered Air Tractor, AT-802A airplane, C-FDHV, operated by the Conair Group Inc., was destroyed when it collided with terrain under unknown circumstances during firefighting operations near Cold…NTSB CEN15WA234Accident · Serious injuriesForeign investigationHughes 369 · Bocognano, Corse-du-Sud, France, FranceOn May 18, 2015, about 0810 hours universal coordinated time, a Hughes model 369 helicopter, Finland registration OH-HNR, impacted terrain near Bocognano, Corse-du-Sud, France. The two crew members were seriously injured. The flight itinerary and purpose of…NTSB ERA15WA223Accident · 1 fatalForeign investigationCessna 182J · Novo Progresso, BrazilOn May 9, 2015, about 1430 local time, a Cessna 182J, Brazilian registration PT-CND, was destroyed when it impacted the Baú River, near Novo Progresso, Pará State, Brazil. The Brazilian pilot was fatally injured. The flight, which originated at Novo Progresso…NTSB ERA15FA204Accident · 1 fatalField investigationFinal reportCessna 182 · Mulberry, TNThe pilot's failure to recover from a controlled descent for reasons that could not be determined during the postaccident investigation.NTSB CEN15WA221Accident · 2 fatalForeign investigationBeech Beech 95-B55 · Dundee, United KingdomOn May 3, 2015, at 1113 coordinated universal time, a Beech 95-B55 airplane, G-RICK, impacted terrain while on approach to the Dundee Airport (EGPN), Dundee, Scotland. The pilot and one passenger were fatally injured and the airplane was destroyed. Instrument…NTSB CEN15LA204Accident · Minor injuriesLimited investigationFinal reportGrumman G 164A · Maysville, OKThe 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 ERA15RA199Accident · 2 fatalForeign investigationSwearingen SA226-TC · North Vancouver, CanadaOn April 13, 2015, at 0709 Pacific daylight time, a Swearingen SA226-TC, Canadian registration C-GSKC, operating as Carson Air flight 66, was destroyed in an area of mountainous terrain about 10 nautical miles north of North Vancouver, British Columbia. The…NTSB ERA15WA193Accident · 1 fatalForeign investigationCessna 210L · Assuncao do Piaui, BrazilOn April 11, 2015, at 2200 coordinated universal time, a privately owned Cessna 201L, Brazilian registered PR-APG, was destroyed when it impacted terrain under unknown circumstances near Assuncao do Piaui Municipality, State of Piaui, Brazil. The pilot was…NTSB DCA15WA113Accident · 6 fatalForeign investigationEurocopter AS365N3 · Jalan Sungai Lalang, Kampung Pasir baru, Semenyih, MalaysiaNTSB ERA15WA185Accident · 1 fatalForeign investigationAerospool Dynamic WT-9 · Cotopaxi Volcano, EcuadorOn March 28, 2015, about 1300 local time, an Aerospool Dynamic WT9, French registration F-JUKE, was destroyed when it impacted terrain on Cotopaxi Volcano, Cotopaxi Province, Ecuador. The Swiss pilot was fatally injured. The flight, which originated at…NTSB CEN15LA185Accident · No injuriesLimited investigationFinal reportGiackino Donald W Rotorway 162F · Marquette, MIThe loss of helicopter control for reasons that could not be determined based on the available evidence.NTSB GAA15CA018Accident · No injuriesData collectionFinal reportCessna 172S · Camarillo, CAThe pilot involved and the phase of flight when the damage occurred were not determined.