NTSB investigations
1,541 cases where the defining event was 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 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 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 CEN11WA695Accident · 6 fatalClass 5 · ForeignCessna 210K · (Atlantic Ocean)NTSB ERA11LA501Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Monmouth, MEOperation of the airplane by a non-certificated pilot and his failure to maintain airplane control.NTSB ANC11LA080Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Cape Yakataga, AKA collision into water during initial climb after takeoff for undetermined reasons.NTSB WPR11WA351Accident · 1 fatalForeign investigationRobinson R22 · Fitzroy Crossing, Australia, AustraliaOn July 27, 2011, at 0930 universal coordinated time, a Robinson R-22 Beta, VH-YOL, registered to and operated by a private owner, collided with terrain near Fitzoy Crossing, Australia. The helicopter was substantially damaged and the pilot, the sole…NTSB WPR11LA307Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Columbia, CAThe airplane’s failure to climb at a sufficient rate to clear trees and terrain beyond the end of the runway for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have…NTSB CEN11CA445Accident · Minor injuriesData collectionFinal reportSkytrails Lsa Predator · Coldspring, TXThe pilot's inadequate consideration of obstructions on his flight path and inability to maintain altitude following an unexplained loss of lift.NTSB WPR11LA272Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Hogeland, MTCollision with the ground while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN11WA382Accident · 1 fatalForeign investigationAir Tractor AT-502B · La Fora, Tiquisate, GuatemalaNTSB ERA11WA310Accident · 4 fatalForeign investigationPiper PA-34-200 · Sao Pedro, BrazilOn May 16, 2011, about 0130 universal coordinated time, a Piper PA-34-200, Brazilian registration PT-IFS, was destroyed when it impacted hilly terrain under unknown circumstances near Sao Pedro, Sao Paulo, Brazil. The Brazilian certificated pilot and three…NTSB ERA11WA305Accident · 3 fatalForeign investigationCessna 210M · Breu Branco, BrazilOn May 14, 2011, about 1430 universal coordinated time, a Cessna 210M, Brazilian registration PR-HSM, was substantially damaged when it impacted wooded terrain under unknown circumstances, in a remote, dense forest near Breu Branco, Brazil. The foreign…NTSB ERA11FA293Accident · Serious injuriesField investigationFinal reportBeech F33A · Tarentum, PAThe pilot's delay in aborting the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot's inadequate preflight planning and excessive loading of the airplane.NTSB ANC11WA028Accident · 1 fatalForeign investigationCessna 195A · Campbell River, CanadaNTSB CEN11LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Streetman, TXThe airplane’s inability to establish a climb for undetermined reasons, which resulted in a collision with trees.NTSB ERA11WA245Accident · 2 fatalForeign investigationBell 206B · Santo Andre City, BrazilOn April 8, 2011, at 2030 coordinated universal time (1730 local time), a Bell 206B, Brazilian registration PT-YMJ, was destroyed when it impacted terrain at the 5,000-foot level of the Serra do Mar mountain range in Santo André, São Paulo, Brazil. The pilot…NTSB ERA11WA251Accident · 3 fatalForeign investigationEurocopter AS-355-F2 · Alto Alegre, BrazilOn April 6, 2011, about 2225 coordinated universal time, a Eurocopter AS-355-F2, Brazilian registration PT-HNA, was destroyed when it impacted terrain near Alto Alegre, Brazil. The pilot and one passenger incurred minor injuries, and three passengers were…NTSB WPR11WA176Accident · 4 fatalForeign investigationPiper PA-32R · Moree, AustraliaThe accident is under the jurisdiction of and is being investigated by the Australian Transport Safety Bureau.NTSB ERA11FA214Accident · 1 fatalField investigationFinal reportAerostar S A YAK-52 · Palm Coast, FLThe pilot’s failure to recover from the nose-low descent during an aerobatic maneuver.NTSB WPR11FA173Accident · 3 fatalField investigationFinal reportCessna P210 · Daggett, CAThe pilot's decision to conduct the flight into a region of reported moderate to severe turbulence and icing conditions, followed by a loss of airplane control and an aerodynamic spin from which the pilot did not recover.NTSB ERA11WA189Accident · 1 fatalForeign investigationCessna 182 · Calamar, ColombiaOn March 14, 2011, about 0815 universal coordinated time, a Cessna, 182N, Colombian registration, HK1084, operated by Transportes Aereos del Ariari, crashed while returning to Aerodromo Jorge E. Gonzalez- San Jose Guaviare (SKSJ), Calamar, Colombia, shortly…NTSB DCA11WA024Accident · 7 fatalForeign investigationRaytheon Hawker · Sulaimanyia, IraqOn February 4, 2011 about 1449 UTC, OD-SKY, a Hawker Beechcraft HS-850XP, registered to Club Aviation S.A.L and operated by Sky Lounge services S.A.L., crashed during the initial takeoff climb at Suliamaniyah International Airport, Iraq. The 3 crew members…NTSB ERA11WA143Accident · 3 fatalForeign investigationBeech 58 · Patrimonio Regina City, BrazilOn January 28, 2011, at 2047 coordinated universal time (1847 local time), a Beech 58, Brazilian registration PT-BOR, was substantially damaged when it impacted terrain near Patrimônio Regina City, Paraná, Brazil. The two pilots and the passenger were fatally…NTSB CEN11WA151Accident · 1 fatalForeign investigationCirrus Design SR20 · Santiago Atitlán, GuatemalaNTSB DCA11WA069Accident · No injuriesForeign investigationBoeing 727 · Urmia, IranOn January 9, 2011, an Iran Air Boeing B727-200, registration EP-IRP, crashed during missed approach to Orumiyeh Airport (OITR), Urmia, Iran. Of the 105 passengers and crew onboard, 78 were fataly injured and 27 received serious injuries. The airplane was…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…NTSB ERA11FA094Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Spencer, MAThe in-flight collision with a tree while returning to land for undetermined reasons.NTSB 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…NTSB ERA11WA088Accident · 1 fatalForeign investigationPiper PA-32R-301T · Roma, ItalyNTSB 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…NTSB ERA11LA071Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bluffton, SCAn in-flight upset of undetermined origin resulting in a forced landing.NTSB 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…NTSB 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,…NTSB 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…NTSB 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…NTSB CEN12WA547Accident · 2 fatalForeign investigationBeech D55 · Cabo San Lucas, MexicoNTSB 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…NTSB 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.NTSB 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…NTSB ERA10LA408Accident · No injuriesLimited investigationFinal reportQuest Kodiak 100 · Naples, MEA loss of control during landing for undetermined reasons.NTSB 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…NTSB ANC10WA073Accident · 1 fatalForeign investigationBeech B36TC · Peace River, CanadaNTSB 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.NTSB 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.NTSB WPR10WA321Accident · 1 fatalForeign investigationErickson S64E · Borneo Island, IndonesiaNTSB ERA10WA327Accident · Serious injuriesForeign investigationCessna · Pavacachi, EcuadorOn June 22, 2010, about 1345 universal time, a Cessna TU-206F, HC-BYA, registered to and operated by Servicio Aero Quichua De Pasta, as a cargo flight, initiated a descent in the vicinity of Pavacachi, Ecuador. Visual meteorological conditions prevailed and a…NTSB 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.NTSB CEN10CA325Accident · No injuriesData collectionFinal reportCessna 172 · Traverse City, MIDamage to the firewall for undetermined reasons.NTSB CEN10LA274Accident · 1 fatalLimited investigationFinal reportHenney Michael A Vans RV-6A · Granbury, TXThe loss of control for undetermined reasons.NTSB CEN10LA236Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · DeWitt, ARThe pilot did not maintain clearance from terrain for undetermined reasons.NTSB ERA10LA251Accident · Serious injuriesLimited investigationFinal reportInterstate S1A · Lakeland, FLThe pilot’s failure to maintain clearance from terrain for undetermined reasons.NTSB CEN10FA181Accident · 1 fatalField investigationFinal reportCessna 172D · Hillsboro, OHImpact with the runway pavement for unknown reasons.