NTSB investigations
2,248 cases where NTSB found Not determined, general.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05000000')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05000000')) 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 WPR16FA158Accident · 1 fatalField investigationFinal reportPiper PA 34-200T · Flagstaff, AZA departure flight path that consisted of several unexplained turns during the initial climbout, and terminated in a high-speed descent and ground impact. The reason(s) for the turns and descent could not be determined due to lack of definitive evidence.NTSB CEN16LA302Accident · Serious injuriesLimited investigationFinal reportSonex Waiex · Fond du Lac, WIA partial loss of engine for reasons that could not be determined during an examination of the engine.NTSB CEN16LA300Accident · Serious injuriesLimited investigationFinal reportWings AN Things Avid Flyer · Bluffton, INThe loss of roll control during climb for reasons that could not be determined because postaccident examination of the airframe revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA16LA276Accident · Minor injuriesLimited investigationFinal reportPiper PA28R · Panama City, FLA total loss of engine power during approach for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR16FA152Accident · 4 fatalField investigationFinal reportCessna 310B · Columbia, CAThe pilot's failure to maintain control during takeoff initial climb 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 GAA16CA393Accident · No injuriesData collectionFinal reportCessna 188 · What Cheer, IAThe loss of engine power for undetermined reasons due to the pilot not making the airplane or engine available for examination, which resulted in a forced landing and an impact with terrain.NTSB CEN16FA282Accident · 2 fatalField investigationFinal reportBeech 95 B55 (T42A) · Leshara, NEThe pilot's loss of airplane control during a practice stall maneuver, which resulted in a spin that continued to ground impact.NTSB ERA16LA271Accident · No injuriesLimited investigationFinal reportCessna 310L · Linden, NJThe overtravel of the main landing gear (MLG) actuator, which resulted in the MLG partially collapsing upon landing. The reasons for the overtravel of the MLG actuator could not be determined due to the unavailability of the wreckage.NTSB CEN16LA275Accident · Minor injuriesClass 3 · LimitedFinal reportMeyers 200 · Huron, SDThe partial loss of engine power due an unsecured throttle cable. The reason for the unsecured throttle cable could not be determined.NTSB CEN16LA271Accident · Serious injuriesLimited investigationFinal reportGerald Nelson Nelson Woody · Hope, ARThe loss of control upon landing for reasons that could not be determined.NTSB CEN16LA266Accident · 1 fatalLimited investigationFinal reportToevs Titanium Explorer · Whitewater, KSThe loss of aircraft control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR16LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA 23-150 · Kona, HIThe total loss of power in both engines during cruise flight for reasons that could not be determined because the airplane was not recovered from the ocean.NTSB ERA16LA251Accident · Serious injuriesLimited investigationFinal reportTumbling Goose 12S · Zellwood, FLA total loss of engine power during descent for reasons that could not be determined because impact damage precluded a complete examination of the fuel servo.NTSB ERA16LA254Accident · Serious injuriesLimited investigationFinal reportBuckeye Dream Machine · Hartford, KYA partial loss of engine power for reasons that could not be determined and the pilot’s failure to maintain directional control during the aborted takeoff.NTSB CEN16LA264Accident · No injuriesLimited investigationFinal reportAlonso CH 701 · Dexter, MIThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA16LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA32 · Windermere, FLA total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA16LA272Accident · No injuriesLimited investigationFinal reportHarrity William V Glasair (SH2F) · Maynardville, TNThe in-flight failure of the No. 3 cylinder connecting rod for reasons that could not be determined during postaccident examination.NTSB ERA16LA244Accident · No injuriesLimited investigationFinal reportCessna 305 · Narragansett, RIA total loss of engine power for reasons that could not be determined during a postaccident examination of the airframe and engine.NTSB CEN16FA241Accident · 1 fatalField investigationFinal reportBoeve Earl Seawind · Buena Vista, COThe pilot's failure to maintain control of the airplane during a forced landing following a partial loss of engine power, which resulted in a hard landing and nose over. The reason for the loss of engine power could not be determined due to the severity of…NTSB ERA16FA238Accident · 1 fatalField investigationFinal reportGerdts Mark E RV7A · Weston, FLThe pilot's loss of airplane control for reasons that could not be determined based on the available evidence.NTSB CEN16LA244Accident · No injuriesLimited investigationFinal reportPollack Quicksilver SPRINT2S · Bullard, TXA loss of airplane control during landing for reasons that could not be determined, because the airplane sank and was not recovered.NTSB CEN16FA240Accident · 2 fatalField investigationFinal reportAeronca 11AC · Frankenmuth, MIThe pilot's loss of control for undetermined reasons based on available information.NTSB CEN16LA254Accident · Minor injuriesLimited investigationFinal reportWaco YMF-F5C · Austin, TXA total loss of engine power for undetermined reasons.NTSB WPR16LA137Accident · No injuriesLimited investigationFinal reportRockwell International S 2R · Brawley, CAThe airplane’s inability to climb and subsequent impact with terrain for reasons that could not be determined based on the available information.NTSB GAA16LA352Accident · No injuriesLimited investigationFinal reportPiper PA 28 · Merritt Island, FLA total loss of engine power during the landing roll, and an engine fire during a subsequent engine restart attempt. Neither the cause for the loss of engine power nor the source of the fire could be determined because the airplane was not made available for…NTSB WPR16LA132Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · El Centro, CAA loss of main rotor rpm and airframe vibration for reasons that could not be determined based on the available information, which resulted in a forced landing to sloping terrain and the helicopter rolling over.NTSB WPR16LA171Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Schafer Meadows, MTA loss of directional control while landing, which resulted in a runway excursion and landing gear collapse for reasons that could not be determined.NTSB ERA16LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Hollywood, FLA partial loss of engine power during the initial climb for undetermined reasons.NTSB ANC16LA035Accident · Minor injuriesLimited investigationFinal reportUniversal Stinson 108 · Big Lake, AKA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN16LA229Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Humansville, MOA partial loss of engine power for reasons that could not determined, because an examination and test run of the engine did not reveal any anomalies that would have contributed to the loss of engine power.NTSB CEN16LA223Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Colorado Springs, COA hard landing on rough terrain due to a faulty deployment of the airplane’s airframe parachute system following a partial loss of engine power for reasons that could not be determined, because postaccident examination revealed no malfunctions or anomalies…NTSB CEN16FA224Accident · 3 fatalField investigationFinal reportCessna 320E · Creede, COThe pilot's loss of airplane control during descent following a loss of engine power for reasons that could not be determined because postaccident examinations and engine test-runs of both engines revealed no evidence of any mechanical malfunctions or…NTSB ERA16LA212Accident · Serious injuriesLimited investigationFinal reportPiper PA28RT · Taylorsville, KYThe pilot's improper decision to continue a takeoff with a partial loss of engine power that occurred early in the takeoff roll. The reason for the partial loss of engine power could not be determined because postaccident fire damage to the engine precluded…NTSB CEN16FA210Accident · 1 fatalField investigationFinal reportCessna 175 · Pine Bluff, ARA loss of engine power during cruise flight for reasons that could not be determined because a test run of the engine did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation. Contributing to the accident were the…NTSB ERA16LA199Accident · No injuriesLimited investigationFinal reportAmerican Legend AL3 · Elberta, ALA total loss of engine power for reasons that could not be determined because the engine ran normally during a postaccident engine test run with no anomalies noted.NTSB ERA16LA201Accident · 1 fatalLimited investigationFinal reportCriquet Aviation Bogota Columb Storch FI-156 · Fordsville, KYThe steep descent to ground impact for reasons that could not be determined based on the available evidence.NTSB WPR16FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Avalon, CAUndetermined because the airplane was not located.NTSB ERA16LA195Accident · 1 fatalLimited investigationFinal reportRepublic P 47D · New York, NYA catastrophic engine failure of undetermined origin, which resulted in a total loss of engine power and subsequent ditching. Contributing to the accident was the pilot's failure to jettison the canopy before ditching, which resulted in his inability to…NTSB WPR16FA116Accident · 5 fatalField investigationFinal reportCessna 182 · Hanapepe, HIThe pilot's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic…NTSB WPR16FA112Accident · 2 fatalField investigationFinal reportNorth American AT 6 · Mesa, AZThe pilot's inability to return to the departure airport due to an unspecified in-flight emergency for reasons that could not be determined during a postaccident examination of the airplane.NTSB ERA16FA189Accident · 1 fatalField investigationFinal reportCessna 210 · Wantage, NJA collision with terrain for reasons that could not be determined as the investigation did not reveal any postaccident anomalies with the airplane or pilot.NTSB WPR16FA111Accident · 1 fatalField investigationFinal reportCessna R182 · Altadena, CAThe pilot's failure to maintain clearance from rising mountainous terrain while flying in instrument meteorological conditions. Contributing to the accident was the loss of radio communications for a reason that could not be determined because of the…NTSB WPR16LA110Accident · Minor injuriesLimited investigationFinal reportSeguin Quickie · Mojave, CAA loss of engine power for reasons that could not be determined based on the available information.NTSB WPR16LA106Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Winslow, AZThe partial loss of engine power during takeoff initial climb in high-density altitude conditions for reasons that could not be determined because a postaccident examination of the airplane and engine revealed no anomalies.NTSB ERA16LA172Accident · No injuriesLimited investigationFinal reportChampion 7BCM · Tyrone, GAA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.NTSB CEN16LA170Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine 582 · Fortville, INThe collapse of the powered parachute's canopy for a reason that could not be determined, because postaccident examination revealed no anomalies with the parachute.NTSB CEN16LA177Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Osage City, KSA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA16FA168Accident · 1 fatalField investigationFinal reportRyskamp Bruce A Acroduster · Belton, SCA loss of engine power for reasons that could not be determined due to extensive postcrash fire damage. Also causal was the pilot's loss of airplane control, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB CEN16FA169Accident · 1 fatalField investigationFinal reportCessna 182L · Carrollton, OHAn in-flight collision with trees and terrain for reasons that could not be determined because no anomalies consistent with a preimpact failure or malfunction were observed during the examination.NTSB CEN16LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brimfield, ILA loss of engine power for reasons that could not be determined, as postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.