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 ANC13WA097Accident · 3 fatalForeign investigationMesserschmitt-Bolkow-Blohm BO 105-S · McClure Strait, CanadaOn September 9, 2013, about 1845 Mountain standard time, a Canadian Coast Guard Messerschmitt-Bolkow-Blohm (MBB) BO105-S helicopter, Canadian registration C-GCFU, crashed into ocean waters near McClure Strait, Canada. The three crew members on board were…NTSB CEN13WA527Accident · 2 fatalForeign investigationCessna T303 · JerseyNTSB CEN13WA516Accident · 7 fatalForeign investigationPiper PA-32T · Wickede, GermanyOn August 27, 2013, at 1521 coordinated universal time, a Piper PA-32T, German registered D-EERB, was destroyed when it impacted terrain under unknown circumstances near Wickede, Germany. Visual meteorological conditions prevailed at the time of the accident.…NTSB CEN13WA505Accident · 4 fatalForeign investigationCessna T210F · Culiacan, MexicoOn August 25, 2013, a Mexican registered Cessna T210F, XB-MYI, impacted terrain near Culiacan, Mexico. The pilot and three passengers received fatal injuries. The airplane was destroyed by post impact fire. The flight originated from La Noria, Mexico, but the…NTSB CEN14WA225Accident · 4 fatalForeign investigationAirbus Helicopters 332L2 · Shetland Islands, United KingdomOn August 23, 2013, about 1717 UTC, an Airbus Helicopters AS332 L2, G-WNSB (s/n 2582) ditched into the North Sea near the Shetland Islands. The helicopter was destroyed and four passengers were fatally injured. This investigation is under the jurisdiction and…NTSB ERA13LA360Accident · Minor injuriesLimited investigationFinal reportQuest Kodiak 100 · Westport, MAA failure to achieve a positive climb rate after takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB ERA13FA349Accident · 2 fatalField investigationFinal reportBeech A36 · Alma, GADescent from cruise flight until impact with trees and the ground for reasons that could not be determined because postaccident examination of the wreckage did not reveal any anomalies that would have precluded normal operation and the pilot's autopsy and…NTSB WPR13CA348Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZA substantially damaged firewall that occurred during an unknown phase of flight for reasons that could not be determined.NTSB CEN13LA361Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Dayton, OHThe pilot’s loss of control of the airplane for reasons that could not be undetermined because a postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB DCA13WA107Incident · No injuriesForeign investigationBoeing 737-800 · Sydney, AustraliaThe Australian Transport Safety Bureau (ATSB), has notified the NTSB of an incident involving a Boeing 737-800 that occurred on June 10, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of…NTSB CEN13LA287Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Oskaloosa, IAThe loss of engine power for reasons that could not be determined because the engine examination did not reveal any malfunctions or failures that would have precluded normal operation.NTSB CEN13LA245Accident · No injuriesLimited investigationFinal reportRaytheon G36 · Hoxie, KSThe loss of engine power due to fuel starvation 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 CEN13FA221Accident · 2 fatalField investigationFinal reportMooney M20J · Collinsville, OKThe pilot’s loss of control of the airplane for reasons that could not be determined because an examination of the airplane did not find an abnormality that would have precluded normal operations.NTSB WPR13WA157Accident · 4 fatalForeign investigationRobinson R44 · Bulli Tops, Australia, AustraliaOn March 21, 2013, about 1207 local time, a Robinson Helicopter R44, VH-HWQ, collided with terrain near Bulli Tops, Australia. The pilot was operating the helicopter under the provisions of the Australian Civil Aviation Regulations. The pilot and three…NTSB ERA13FA168Accident · 3 fatalField investigationFinal reportPiper PA-31T · Fort Lauderdale, FLThe pilot's failure to maintain airplane control following an emergency, the nature of which could not be determined because of crash and fire damage, which resulted in an aerodynamic stall.NTSB ERA13WA178Accident · 10 fatalForeign investigationEmbraer EMB-820C · Almeirim Municipality, BrazilOn March 12, 2013, about 2330 UTC, an Embraer Aircraft EMB-820C, PT-VAQ, operated by Fretax Taxi Aereo Ltda, crashed during approach to Monte Dourado Airport (SBMD), Almeirim, Brazil. Visual meteorological conditions prevailed at the time and flight plan…NTSB WPR13FA116Accident · 1 fatalField investigationFinal reportCessna 172S · Minden, NVThe pilot’s failure to maintain airplane control while maneuvering over mountainous terrain.NTSB ERA13WA128Accident · 5 fatalForeign investigationBeech C90 · Candido Mota, BrazilOn February 3, 2013, about 2230 coordinated universal time, a Beech C90A, Brazilian registration PP-AVG, was destroyed when it impacted terrain near Cândido Mota, Brazil. The pilot and four passengers were fatally injured. The flight originated from Regional…NTSB ERA13WA124Accident · 2 fatalForeign investigationBell 206B · Sao Paulo, BrazilOn January 21, 2013, at 1448 universal coordinated time, a Bell Helicopter 206B, Brazilian registration PR-JBN, sustained substantial damage when it impacted a dwelling. One crewmember and one passenger received fatal injuries and the two other passengers…NTSB CEN13FA137Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T42A) · Mangum, OKThe airplane's aerodynamic stall/spin at low altitude and subsequent impact with terrain for reasons that could not be determined during postaccident examinations. Contributing to the accident was the pilot's lack of currency/proficiency.NTSB ERA13FA109Accident · 2 fatalField investigationFinal reportBenton Fred D Seawind 3000 · Sarasota, FLThe pilot's inability to establish a normal climb rate after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN13FA100Accident · 2 fatalField investigationFinal reportAerovodochody L-29 Delfin · Combine, TXThe airplane's impact with terrain for reasons that could not be determined during examination of the available evidence because of extensive impact damage and postimpact fire.NTSB ERA13FA071Accident · 1 fatalField investigationFinal reportGreen Gary E Thorp T-18 · Pahokee, FLThe descent and overstress of the airplane during the descent, which resulted in the in-flight breakup of the airplane.NTSB ERA13WA080Accident · 1 fatalForeign investigationPiper PA-25-260 · El Viento, ColombiaOn November 22, 2012, at 1705 Universal Coordinated Time (UTC), a Piper PA-25-260, Colombian registration HK588,operated by Fuminorte Ltda. Fumigaciones Aereas Norte, was substantially damaged when it collided with terrain during an agriculture spraying…NTSB WPR13FA037Accident · 2 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAThe pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…NTSB ERA13LA045Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 · Alexander City, ALThe pilot’s delayed decision to initiate an autorotation and her subsequent improper conduct of the autorotation, which resulted in a hard landing, after the helicopter started vibrating for reasons that could not be determined because postaccident…NTSB CEN13FA025Accident · Serious injuriesField investigationFinal reportAgusta AW139 · Houma, LAThe helicopter’s sudden and severe vertical vibrations during landing, which resulted in a collision with terrain. The reason for the helicopter’s sudden and severe vertical vibrations could not be determined during postaccident examinations.NTSB ERA13FA032Accident · 2 fatalField investigationFinal reportSwift Museum Foundation GC-1A · East Moriches, NYThe failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…NTSB ANC13FA004Accident · 1 fatalField investigationFinal reportGrumman Aircraft ENG C-1A · Willow, AKThe pilot’s loss of control of the airplane for reasons that could not be determined because the wreckage was not recovered from the accident site.NTSB CEN12LA669Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 · Nocona, TXThe noncertificated pilot’s operation of the helicopter, which resulted in impact with the water.NTSB WPR12LA417Accident · Minor injuriesLimited investigationFinal reportSeymour Skyranger · Perris, CAA loss of aircraft control during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12FA628Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Bullard, TXThe pilot's maneuver, which exceeded the airplane's structural limit and resulted in an in-flight breakup.NTSB WPR12LA411Accident · No injuriesLimited investigationFinal reportCessna A185F · Cambria, CAA partial loss of engine power during cruise flight for reasons that could not be determined because the airplane sank in the ocean and was not recovered.NTSB ERA12WA577Accident · 1 fatalForeign investigationCessna 172R · Macapá, BrazilOn September 12, 2012, about 2112 universal coordinated time, a Cessna 172R, Brazilian registration PT-WYK, was destroyed when it collided with terrain under unknown circumstances near Macapa ´, Brazil. The non-certificated pilot was fatally injured. The…NTSB WPR12LA383Accident · No injuriesLimited investigationFinal reportCessna 177RG · Olympia, WAA loss of directional control during landing for reasons that could not be determined because postaccident examination of the nose gear steering mechanism did not reveal any anomalies that would have precluded normal operation.NTSB CEN12WA562Accident · 2 fatalForeign investigationPiper PA-38-112 · Bruera, Cheshire, United KingdomOn August 16, 2012, about 1940 universal coordinated time, a Piper PA-38-112 airplane, United Kingdom registration G-BODP, impacted terrain during an instructional flight near Bruera, Cheshire, United Kingdom. The flight instructor and student pilot were…NTSB WPR12FA349Accident · 1 fatalField investigationFinal reportCessna P210N · Santa Monica, CAThe pilot's failure to maintain altitude during a return to the airport following an unspecified emergency; the nature of the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would…NTSB DCA12CA122Accident · No injuriesData collectionFinal reportAirbus A330 · Dulles, VAthe A330 flightcrew's failure to maintain a safe clearance between his wing and the tail of the DHC-8-400 that was stopped on the lead in line of the gate.NTSB CEN12WA528Accident · Serious injuriesForeign investigationCessna 180G · Kenora, CanadaNTSB CEN12LA495Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lakeview, ARThe pilot’s loss of control during the takeoff roll for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB DCA12WA135Accident · 3 fatalForeign investigationAgusta A109 · Jiquipilco, MexicoThe Mexican Dirección General de Aeronáutica Civil (DGAC) has notified the NTSB of an accident involving a AgustaWestland 109SP helicopter that occurred on July 28, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation…NTSB WPR12FAMS1Accident · 1 fatalMissing aircraftFinal reportJeffko Glasair · Tonasket, WAThe cause of the accident is undetermined as the airplane has not been located and remains missing.NTSB ERA12CA466Accident · No injuriesData collectionFinal reportCessna 172P · St. Augustine, FLUndetermined due to a lack of information about when the damage to the airplane occurred.NTSB CEN12LA455Accident · No injuriesLimited investigationFinal reportCessna 175A · Shelby, ILThe loss of engine power due to oil starvation for reasons that could not be determined because engine examinations revealed no malfunctions or failures that would have led to oil starvation.NTSB ERA12FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 150F · Atlantic Ocean (Atlantic Ocean)Undetermined (airplane and pilot missing).NTSB CEN12FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-31-325 · Duluth, MNUndetermined because the airplane was not found.NTSB CEN12LA352Accident · No injuriesLimited investigationFinal reportGrumman G164 · Higginson, ARThe partial loss of engine power for reasons that could not be determined due to impact and fire damage.NTSB WPR12LA314Accident · No injuriesLimited investigationFinal reportCessna 182R · Hilo, HIThe damage to the engine firewall for a reason that was undetermined because the damage was not reported when it occurred.NTSB ERA12WA383Accident · 1 fatalForeign investigationPiper PA-28R-200 · São Paulo, BrazilNTSB ERA12LA364Accident · 1 fatalLimited investigationFinal reportMoyes B/Bailey B Dragonfly · Trenton, GAThe airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation and it could not be determined whether the…