Fatal NTSB investigations, 2010

32 cases where the sequence of events included Unknown or undetermined.

Cases per year

20082026
Fatal NTSB investigations, 2010 per year, 2008–2026: 1,013 cases
200813
200916
201032
201131
201227
201332
201446
201559
201672
201763
201880
201956
202047
202143
202258
202354
202455
202580
2026149

Latest 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\") = 2010
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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 CEN11FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Milaca, MNThe pilot did not recover from an unusual attitude while operating in instrument meteorological conditions following a disconnect of the autopilot system for undetermined reasons. Contributing to the accident were the pilot’s lack of recent flight experience…Dec 30, 2010 · N9103N · Substantial damageNTSB CEN11FA130Accident · 1 fatalField investigationFinal reportCessna 210B · Loveland, COThe pilot's intentional flight into terrain.Dec 27, 2010 · N200EP · Substantial damageNTSB ERA11FA094Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Spencer, MAThe in-flight collision with a tree while returning to land for undetermined reasons.Dec 22, 2010 · N30ZZ · Substantial damageNTSB ERA11WA090Accident · 2 fatalForeign investigationHawker Beechcraft TC-45J · Nassau, BahamasOn December 14, 2010, about 1442 eastern standard time, a Hawker Beechcraft TC-45J, N38L, registered to and operated by Monarch Air Group, impacted ocean waters about 7 miles southwest of Lynden Pindling International Airport (MYNN), Nassau, Bahamas. The…Dec 14, 2010 · N38L · DestroyedNTSB ERA11WA088Accident · 1 fatalForeign investigationPiper PA-32R-301T · Roma, ItalyDec 8, 2010 · N58SE · DestroyedNTSB CEN11WA094Accident · 1 fatalForeign investigationCessna F150 · Linköping, SwedenOn December 1, 2010, at 1711 coordinate universal time, a Cessna F150H, SE-IGU, was substantially damaged upon impact with terrain after initial takeoff from the Linköping Airport (ESSL), Linköping, Sweden. The pilot was fatally injured. The airplane was…Dec 1, 2010 · SE-IGU · Substantial damageNTSB DCA11WA114Accident · 1 fatalForeign investigationPiper PA32 - 301 · Vipingo Ridge, KenyaOn October 23, 2010, about 0653 UTC, 5Y-NAM, a Piper PA-32R-301, a personal flight, had an inflight breakup during cruise flight and crashed in an open field at Vipingo Ridge, Kenya. The pilot, the sole occupant, was fatally injured. The aircraft was…Oct 23, 2010 · 5Y-NAM · Substantial damageNTSB ERA11WA031Accident · 5 fatalForeign investigationCessna TU206G · Medellin, ColombiaOn October 20, 2010, about 1300 Universal Coordinated Time (UTC), a Cessna TU206G, Columbian registration HK2933, was destroyed by fire after crashing in Path Shipyards, Medellin, Columbia. The flight was en route from Medellin, (SKMD), to Fort Vigia,…Oct 20, 2010 · HK2933 · DestroyedNTSB DCA11WA003Accident · 8 fatalForeign investigationLockheed L-100 · Kabul, AfghanistanOn October 12, 2010, about 1505 UTC, a Trans Afrique Airlines (under contract to National Air Cargo) Lockheed L-100, registration 5X-TUC, impacted terrain while maneuvering to land at Kabul International Airport (OAKB), Kabul Afghanistan. The two flight crew…Oct 12, 2010 · 5X-TUC · DestroyedNTSB CEN11LA012Accident · 1 fatalLimited investigationFinal reportNewmann Edward W Challenger II · Easton, KSThe pilot’s failure to maintain control of the airplane for undetermined reasons.Oct 8, 2010 · N61328 · Substantial damageNTSB ERA11WA041Accident · 2 fatalForeign investigationPiper PA38 · Buenos Aires, ArgentinaOn October 3, 2010, about 1920 Universal Coordinated Time (UTC), a Piper PA-A-38-112, Argentinean registration LV-MNO, crashed into terrain during an instructional flight near Marcos Paz, Argentina. The local training flight originated from San Fernando…Oct 3, 2010 · LV-MNO · Substantial damageNTSB CEN12WA547Accident · 2 fatalForeign investigationBeech D55 · Cabo San Lucas, MexicoSep 25, 2010 · N91HV · Substantial damageNTSB ERA10WA507Accident · 2 fatalForeign investigationRobinson R44 · Itanhaem, BrazilOn September 10, 2010, about 1445 Universal Coordinated Time (UTC), a Robinson Helicopters R44, Brazilian registration PT-YON, operated by AM Transportes Ltda ME, crashed into mountainous terrain near Itanhaem, State of Sao Paulo, Brazil. The flight was en…Sep 10, 2010 · PT-YON · Substantial damageNTSB ERA10FA464Accident · 2 fatalField investigationFinal reportCessna 150H · DeLand, FLThe pilot's failure to maintain adequate airspeed and airplane control during the initial climb, which resulted in an aerodynamic stall, wire strike, and subsequent impact with the ground.Sep 4, 2010 · N23471 · Substantial damageNTSB CEN10FA509Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L-1 · Walnut Grove, ARThe pilot’s loss of aircraft control, due to spatial disorientation, resulting in the in-flight separation of the main rotor and tail boom.Aug 31, 2010 · N62AE · Substantial damageNTSB CEN10RA579Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540 · Toledo, SpainimportAug 17, 2010 · N540WC · DestroyedNTSB WPR10FA388Accident · 1 fatalField investigationFinal reportDiamond HK36 · Bend, ORAn condition, which could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation, that prompted the pilot to discontinue the flight. Contributing to the accident…Aug 8, 2010 · N40440 · Substantial damageNTSB CEN10WA585Accident · 2 fatalForeign investigationSchweizer 269C · Saint Gondon, FranceOn July 25, 2010, at 0800 coordinated universal time, a Schweizer 269C, French registered F-GJGQ, was destroyed when it impacted trees in a wooded area under unknown circumstances near Saint-Gondon, France. Visual meteorological conditions prevailed at the…Jul 25, 2010 · F-GJGQ · DestroyedNTSB ANC10WA073Accident · 1 fatalForeign investigationBeech B36TC · Peace River, CanadaJul 24, 2010 · N64631 · Substantial damageNTSB CEN10LA409Accident · 1 fatalLimited investigationFinal reportDavis John TR-4 · Denton, TXA loss of engine power and the pilot’s subsequent loss of control for undetermined reasons.Jul 19, 2010 · N767GW · Substantial damageNTSB ERA10FA346Accident · 1 fatalField investigationFinal reportCessna 172P · Chesapeake, VAThe airplane's impact with terrain for undetermined reasons following the pilot's report of a flight control malfunction.Jul 5, 2010 · N52614 · Substantial damageNTSB WPR10WA321Accident · 1 fatalForeign investigationErickson S64E · Borneo Island, IndonesiaJun 25, 2010 · N229AC · Substantial damageNTSB WPR10FA295Accident · 1 fatalField investigationFinal reportKaman Aerospace K-1200 · Donnelly, IDThe collision of two counter-rotating main rotor blades for undetermined reasons, which resulted in a loss of control.Jun 16, 2010 · N134WC · Substantial damageNTSB CEN10LA274Accident · 1 fatalLimited investigationFinal reportHenney Michael A Vans RV-6A · Granbury, TXThe loss of control for undetermined reasons.May 28, 2010 · N226MH · Substantial damageNTSB CEN10LA236Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · DeWitt, ARThe pilot did not maintain clearance from terrain for undetermined reasons.May 3, 2010 · N5531X · Substantial damageNTSB CEN10LA234Accident · 1 fatalLimited investigationFinal reportCGS Hawk · Haysville, KSThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and loss of control of the airplane, for undetermined reasons.May 2, 2010 · UNREG · Substantial damageNTSB ERA10FA232Accident · 1 fatalField investigationFinal reportMaule M5-235C · Zellwood, FLThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall, loss of aircraft control, and collision with trees.Apr 18, 2010 · N9196E · Substantial damageNTSB CEN10FA181Accident · 1 fatalField investigationFinal reportCessna 172D · Hillsboro, OHImpact with the runway pavement for unknown reasons.Apr 2, 2010 · N2190Y · DestroyedNTSB ERA10WA171Accident · 2 fatalForeign investigationRobinson R44 · Karelia, RussiaOn March 10, 2010, about 0900 Universal Coordinated Time (UTC), a Robinson R-44 helicopter, Russian registration RA-04163, operated by a private individual, was involved in an accident under unknown circumstances near Karelia, Russia. The helicopter departed…Mar 10, 2010 · RA-04163 · Substantial damageNTSB ERA10WA153Accident · 7 fatalForeign investigationCessna U206F · Nazca, PeruOn February 25, 2010, about 1630 universal coordinated time (1130 local time), a Cessna U206F, Peruvian registration OB-1117, operated by Nazca Airlines, was destroyed when it impacted terrain near Nazca, Ica Province, Peru. The Peruvian commercial pilot and…Feb 25, 2010 · OB-1117 · DestroyedNTSB ERA10WA157Accident · 4 fatalForeign investigationBell 206 · Carayaca, VenezuelaOn February 19, 2010, about 1950 Universal Coordinated Time, a Bell 206B helicopter, Venezuelan registration YV2191, operated by Aeromedic 2005, was lost from contact with Maiquetia approach control. The helicopter departed from Generalisimo Francisco de…Feb 19, 2010 · YV2191 · Substantial damageNTSB ERA10WA130Accident · 2 fatalForeign investigationPiper PA-34 · Ipero, BrazilOn January 27, 2010, at 0918 EST, a Piper PA-34, PR-UGO, of Brazilian registration, registered to and operated by an individual, crashed 10 minutes after takeoff. The pilot and passenger were killed and the airplane was substantially damaged. The weather at…Jan 27, 2010 · PR-UGO · Substantial damage