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 CEN10CA267Accident · No injuriesData collectionFinal reportCessna R172E · Alamogordo, NMAn unknown event that resulted in damage to the airplane's firewall.NTSB 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…NTSB DCA12WA015Incident · No injuriesForeign investigationBoeing 737 · Brussels, BelgiumThe Irish Air Accident Investigation Unit (AAIU) has notified the NTSB of an incident involving a Boeing 737-800 that occurred on March 1, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions of…NTSB 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…NTSB DCA10WA043Incident · No injuriesForeign investigationBoeing 757 - 236 · Bacelona, SpainThe UK Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a B757-236 that occurred on February 21, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of…NTSB 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…NTSB DCA10WA035Incident · No injuriesForeign investigationBoeing 737 · Surabaya, IndonesiaOn February 12, 2010, a Metro Batavia Boeing 737-200, registration PK-YTR, aborted the takeoff from runway 10 at Juanda Airport, Surabaya, Indonesia. There were no injuries to the 5 crew members and 120 passengers onboard and the airplane received minor…NTSB 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…NTSB WPR10WA070Accident · 4 fatalForeign investigationRobinson R44 · Netanya, Israel, IsraelThe accident is under the jurisdiction of, and is being investigated, by the State of Israel, Ministry of Transport, Aviation Incidents and Accidents Investigation (AIAI).NTSB ERA10FA052Accident · 1 fatalField investigationFinal reportAero Commander 100 · Weston, FLThe flight's descent for undetermined reasons, resulting in the in-flight collision with terrain.NTSB ERA10WA035Accident · 5 fatalForeign investigationHawker BAe-125-800B · Minsk, BelarusOn October 26, 2009, at 1934 universal coordinated time (2134 local standard time), a Hawker-Beech BAe-125-800, Russian registration RA-02807, operated by S-Air, was destroyed when it impacted forested terrain during a go-around attempt at Minsk-2…NTSB ERA10LA026Accident · 2 fatalLimited investigationFinal reportFuji LM1 · Athens, GAAn aerodynamic stall shortly after takeoff for undetermined reasons.NTSB ERA10FA024Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Summerville, SCFlight into terrain for undetermined reasons.NTSB ERA09WA519Accident · 2 fatalForeign investigationRobinson R44 · Perm, RussiaOn September 14, 2009, at 0700 Universal Time Coordinated, a Robinson R44-II, Russian registration RA-04289, operated by Geliks Airline, crashed 6.2 miles from the Perm Airport, Perm, Russia. The pilot and passenger were killed, and the helicopter sustained…NTSB CEN09CA563Accident · Minor injuriesData collectionFinal reportHalbert James H Rans S-7 · Short, OKA partial loss of engine power for undetermined reasons.NTSB CEN09LA558Accident · No injuriesLimited investigationFinal reportHughes 269C · Arapahoe, NEA sudden vibration for undetermined reasons.NTSB WPR09LA413Accident · Serious injuriesLimited investigationFinal reportAntares US MA-34R · San Jose, CAThe pilot's failure to maintain aircraft control during engine startup, which resulted in a collision with parked aircraft. Contributing to the accident was the engine's inadvertent increase to high power for undetermined reasons.NTSB ANC09WA071Accident · 2 fatalForeign investigationPiper PA-46-31P · Kamsack, CanadaOn July 19, 2009, about 2100 central standard time, a Piper PA-46-31P airplane, Canadian registration C-GUZZ, crashed on takeoff from Kamsack, Saskatchewan, Canada. Two people aboard received fatal injuries, and the remaining two people aboard received…NTSB ERA09LA413Accident · 1 fatalLimited investigationFinal reportCessna 152 · Ponce, PRThe airplane’s impact with water for undetermined reasons.NTSB ERA09LA410Accident · No injuriesLimited investigationFinal reportRobinson R44 · Silver Spring, PAThe student pilot's inability to fully control the helicopter, during cruise and the resultant off-field hard landing.NTSB ERA09WA291Accident · 2 fatalForeign investigationPiper PA-30 · Port Sudan, SudanOn May 10, 2009, at 0530 universal coordinated time (0830 local time), a Piper PA-30, N502TC, was destroyed when it impacted mountainous terrain about 26 nautical miles northwest of Port Sudan, Sudan. The two Yemani pilots onboard were fatally injured. The…NTSB DCA09WA060Accident · 7 fatalForeign investigationBoeing 737 · Kwilu, Bandundu, Congo - KinshasaOn April 29, 2009, about 0800 UTC, TL-ADM, a Boeing 737-200, operated by Bako Air of the Central African Republic, a ferry flight, crashed at the locality of Massamba, District of Kwilu, province of Bandundu, Democratic Republic of Congo. All seven occupants…NTSB CEN09IA254Incident · No injuriesIncident investigationFinal reportBell 206 · Vick, TXUndetermined.NTSB CEN09IA234Incident · No injuriesIncident investigationFinal reportBell 206L-3 · Abilene, TXThe formation and propagation of a fatigue crack in the trailing edge of the main rotor blade due to interconnected porosity and resultant corrosion. The area of interconnected porosity was due to a manufacturing defect which was not detected during the…NTSB ERA09WA223Accident · 1 fatalForeign investigationBeech A36 · Querencia, BrazilNoneNTSB CEN09FA193Accident · 1 fatalField investigationFinal reportBell 206-L4 · Moundridge, KSInflight collision with terrain for undetermined reasons.NTSB WPR09LA149Accident · 1 fatalLimited investigationFinal reportCessna 172N · Oceanside, CAA loss of aircraft control for undetermined reasons.NTSB ERA09WA166Accident · 24 fatalForeign investigationEmbraer EMB110 · Coari, BrazilOn February 7, 2009, at 1810 universal time coordinates, an Embraer EMB 110P1, Brazilian registry PT-SEA, operated by Manaus Aerotaxi as a commuter flight, experienced an unknown problem after take-off from the Coari, Amazonas Airport (SWKO) in Coari, Brazil,…NTSB ERA09WA113Accident · 12 fatalForeign investigationBritten Norman BN-2A MK III · Turks and Caicos, Turks & Caicos IslandsNTSB ERA09WA037Accident · 3 fatalForeign investigationBeech 65A90 · Timehri, GuyanaNTSB ERA09WA028Accident · 1 fatalClass 5 · ForeignHawker-Beechcraft 100 · Bauru, BrazilNTSB NYC08WA308Accident · 2 fatalForeign investigationRobinson R-44 · Muzino Village, RussiaNTSB DFW08LA220Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20B · Cleburne, TXLoss of control inflight for undetermined reason.NTSB DFW08WA240Accident · 1 fatalForeign investigationCessna 501 · Las Americas, Dominican RepublicNTSB DCA08WA086AccidentForeign investigationBoeing 767 - 200 · Budapest, HungaryOn July 29, 2008, at 1607 local Budapest time, a Krasnojarsky Airlines Boeing 767-200, EI-GBA, experienced an inadvertent deployment of an emergency escape slide after takeoff from Budapest, Hungary. The flight continued to its destination of Domodedovo…NTSB NYC08FA238Accident · 1 fatalField investigationFinal reportCessna 152 · Rossville, TNUndetermined.NTSB DCA08WA074AccidentForeign investigationFairchild SA226 · Bergen, NorwayOn June 20, 2008, at 1032 local Norwegian time, a Helitrans AS Fairchild Aircraft Corporation SA226-T(B), registration LN-SFT, crashing into the North Sea approximately 15 NM West of Bergen Airport (ENBR), Bergen, Norway. The aircraft was on a training flight…NTSB DCA08WA073Accident · 4 fatalForeign investigationCessna 210 · Nairegi Enkera, KenyaOn June 10, 2008, about 1200 UTC, a Cessna 210, registration 5Y-BE, a chartered flight, was en route when it collided with high terrain near Nairegi Enkera, Kenya. The airplane was on a visual flight; instrument meteorological conditions prevailed due to low…NTSB SEA08LA137Accident · 1 fatalLimited investigationFinal reportNolan RV-4 · Tolani Lake, AZAn in-flight collision with terrain for undetermined reasons.NTSB CHI08CA088Accident · No injuriesData collectionFinal reportShaffer KR-2 · Fremont, OHThe loss of engine power for undetermined reasons during takeoff.NTSB CHI08FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310N · Keflavík, IcelandThe reported loss of both engines' power during cruise for undetermined reasons.