NTSB investigations, 2015

82 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 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.

NTSB ERA15WA247Accident · 1 fatalForeign investigationCessna T303 · Vaupes, ColombiaJun 20, 2015 · HK4677G · DestroyedNTSB ERA15WA261Accident · 2 fatalForeign investigationIlyushin IL-103 · Brest, BelarusJun 14, 2015 · EW-041LL · DestroyedNTSB 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.Jun 10, 2015 · N740SP · Substantial damageNTSB 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…Jun 6, 2015 · G-RAMY · Substantial damageNTSB 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.Jun 2, 2015 · N1348C · DestroyedNTSB 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…Jun 2, 2015 · XA-UKP · DestroyedNTSB 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.May 27, 2015 · N138HA · Substantial damageNTSB 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…May 22, 2015 · C-FDHV · Substantial damageNTSB 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…May 18, 2015 · OH-HNR · DestroyedNTSB 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…May 9, 2015 · PT-CND · DestroyedNTSB 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.May 3, 2015 · N6579M · DestroyedNTSB 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…May 3, 2015 · G-RICKNTSB 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.Apr 15, 2015 · N7951 · Substantial damageNTSB 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…Apr 13, 2015 · C-GSKC · DestroyedNTSB 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…Apr 11, 2015 · PR-APG · DestroyedNTSB DCA15WA113Accident · 6 fatalForeign investigationEurocopter AS365N3 · Jalan Sungai Lalang, Kampung Pasir baru, Semenyih, MalaysiaApr 4, 2015 · 9M-IGB · DestroyedNTSB 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…Mar 28, 2015 · F-JUKE · DestroyedNTSB 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.Mar 28, 2015 · N556DG · Substantial damageNTSB GAA15CA018Accident · No injuriesData collectionFinal reportCessna 172S · Camarillo, CAThe pilot involved and the phase of flight when the damage occurred were not determined.Mar 23, 2015 · N2104H · Substantial damageNTSB ERA15WA159Accident · 1 fatalForeign investigationPiper PA-34-200T · Macas, EcuadorOn March 15, 2015, at an unknown time, a Piper PA-34, Ecuadorian registration HC-CNC, impacted terrain under unknown circumstances shortly after takeoff from Edmundo Carvajal Airport, Macas, Ecuador. The pilot, the sole occupant, was fatally injured. The…Mar 15, 2015 · HC-CNC · DestroyedNTSB CEN15WA173Accident · 1 fatalForeign investigationEipper Quicksilver - GT500 · Illes Balears, SpainThis is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On March 14, 2015, about 1145 UTC, an Eipper Quicksilver GT-500 airplane, EC-DK6, (s/n 0085) impacted terrain after an…Mar 14, 2015 · EC-DK6 · Substantial damageNTSB CEN15WA176Accident · No injuriesForeign investigationBeech 390 · Lancashire, United KingdomOn March 12, 2015, at 1148 universal coordinated time (UTC), a United Kingdom registered Beech 390 airplane, G-OOMC, overran the runway end, at the Blackpool Airport, Lancashire, United Kingdom. The two crewmembers and two passengers were not injured. The…Mar 12, 2015 · G-OOMC · Substantial damageNTSB CEN15WA152Accident · 2 fatalForeign investigationAvions Robin Robin DR 400/140 B · Yverdon LSGY, SwitzerlandFeb 23, 2015 · HB-KDD · DestroyedNTSB WPR15WA108Accident · 2 fatalForeign investigationRobinson R44 II · Queenstown, New Zealand, New ZealandOn February 19, 2015, at 0244 universal coordinated time, a Robinson R44 II, ZK-IPY, operated by Over the Top Limited, collided with terrain under unknown circumstances near Queenstown, New Zealand. The two occupants on board were fatally injured and the…Feb 19, 2015 · ZK-IPY · Substantial damageNTSB CEN15FA141Accident · 2 fatalField investigationFinal reportRichard Lacourse Wheeler Express · Kersey, COThe pilot's failure to maintain airplane control during an off-airport forced landing following a total loss of engine power for reasons that could not be determined during postaccident examination of the engine. Contributing to the accident was the pilots'…Feb 11, 2015 · N564ER · DestroyedNTSB CEN15WA133Accident · 1 fatalForeign investigationPiper PA 46 350P · Meyrin, SwitzerlandJan 30, 2015 · N246PR · DestroyedNTSB CEN15FA127Accident · 1 fatalField investigationFinal reportEagleston John H Vans RV9A · Kingston, OKThe pilot’s continuation of a banked turn following the loss of engine power, which resulted in his failure to maintain adequate airspeed and the airplane exceeding its critical angle of attack and entering an accelerated stall at low altitude. Contributing…Jan 28, 2015 · N708JE · Substantial damageNTSB CEN15WA124Accident · 1 fatalForeign investigationPiper PA-30 · Rockenhausen, GermanyOn January 26, 2015, about 1032 coordinated universal time, a Piper PA-30 airplane, D-GHFW, crashed under unknown circumstances near Rockenhausen, Germany. The airplane was substantially damaged, and the pilot fatally injured. The airplane departed Annemasse…Jan 26, 2015 · D-GHFW · Substantial damageNTSB CEN15WA148Accident · 2 fatalForeign investigationPiper PA-24-260 · Rechberghausen, GermanyOn January 18, 2015, about 1455 coordinated universal time, a Piper PA-24-260 airplane, German registration D-EERZ, collided with a house near Rechberghausen, Germany. The pilot and passenger were both fatally injured. The airplane was destroyed. The accident…Jan 18, 2015 · D-EERZ · Substantial damageNTSB CEN15WA120Accident · Minor injuriesForeign investigationBell 206 - L1 · Santa Catarina Ixtahuacan, GuatemalaOn January 17, 2015, about 1545 coordinated universal time (UTC), a Bell 206L-1 helicopter, TG-GOL, was destroyed after impacting terrain near Santa Catarina Ixtahuacán, Sololá, Guatemala. The pilot and three passengers received minor injuries. The accident…Jan 17, 2015 · TG-TOL · DestroyedNTSB CEN15WA145Accident · 2 fatalForeign investigationPioneer 400 · Blackwood Forest, Hampshire, U.K., United KingdomOn January 3, 2015, about 1530 UTC, a Pioneer 400 airplane, G-CVGO (s/n LAA 364-15006) impacted terrain near Blackwood Forest, Hampshire. Two persons on board were fatally injured and one was seriously injured. The airplane was destroyed. This investigation…Jan 3, 2015 · G-CVGO · DestroyedNTSB CEN15WA455Accident · Serious injuriesForeign investigationRans S6 · Beja, PortugalOn January 1, 2015, about 1700 local time, a Rans S-6 Coyote II, Portuguese registration CS-UJF, impacted terrain after departure from the Beja Civil Aerodrome (LPBE), Beja, Portugal. The pilot and passenger were seriously injured and the airplane was…Jan 1, 2015 · CS-UJF · Destroyed