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 ERA14FA396Accident · 2 fatalField investigationFinal reportMcdonnell Douglas Helicopter 369E · Northport, ALAn inadvertent collision with a utility wire for reasons that could not be determined from recorded data and examination of the helicopter and accident site.NTSB CEN14LA445Accident · Serious injuriesLimited investigationFinal reportFranke Roland SKY Raider · Bethel, OHThe pilot's inadvertent aerodynamic stall while maneuvering after a loss of engine power during initial climb. Contributing to the accident was the total loss of engine power for reasons that could not be determined because the investigation could not…NTSB WPR14FA348Accident · 1 fatalField investigationFinal reportCliff Starduster II SA300 · Placerville, CAThe pilot's failure to maintain control of the airplane during a go-around in gusting wind conditions following a partial loss of engine power for reasons that could not be determined, because postaccident examination of the airframe and engine did not reveal…NTSB CEN14FA434Accident · 1 fatalField investigationFinal reportPiper PA 32-300 · Ardmore, OKThe partial loss of engine power for reasons that could not be determined because thermal damage to the engine prevented a complete examination.NTSB ERA14LA388Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Buffalo, NYA total loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine test run revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR14LA341Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Idaho Falls, IDThe pilot’s loss of helicopter control for reasons that could not be determined because postaccident examination of the helicopter did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR14LA338Accident · No injuriesClass 3 · LimitedFinal reportNelson RV 3M · North Plains, ORA partial loss of engine power for undetermined reasons which resulted in a landing gear collapse during the precautionary landing to a field.NTSB WPR14LA337Accident · No injuriesLimited investigationFinal reportRyan Navion · Fresno, CAA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR14LA336Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-300 · West Jordan, UTA partial loss of engine power during initial climb for reasons that could not be determined due to the severity of the damage to the engine.NTSB WPR14LA335Accident · No injuriesLimited investigationFinal reportCessna 180A · Salmon, IDA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA14LA382Accident · Minor injuriesLimited investigationFinal reportJackson Jeremiah D Vans RV6A · West Palm Beach, FLThe pilot’s excessive landing speed, which resulted in a runway excursion and noseover. Contributing to the accident was a partial loss of engine power during an attempted go-around for reasons that could not be determined because no anomalies were identified…NTSB ERA14LA378Accident · Minor injuriesLimited investigationFinal reportBirchler Boyd Eagle 540 · Standish, METhe total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA14CA375Accident · Minor injuriesData collectionFinal reportCessna 172N · Valkaria, FLThe pilot's misjudgment of speed and distance on final approach during a precautionary landing, resulting in a touchdown off the departure end of the runway and collision with terrain. A factor in the accident was a partial loss of engine power for reasons…NTSB WPR14LA327Accident · Serious injuriesLimited investigationFinal reportDavid L Thompson Challenger II · Winterhaven, CAA total loss of engine power during cruise for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s loss of control during the forced landing.NTSB ERA14LA374Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Apalachicola, FLA total loss of engine power for reasons that could not be determined during postaccident examination and testing.NTSB CEN14FA400Accident · 1 fatalField investigationFinal reportLarry Ketterling FEW P-51 Mustang · Lisbon, NDThe partial loss of engine power for a reason that could not be determined because of extensive impact and postcrash fire damage, and the pilot's failure to maintain adequate airspeed, which resulted in the airplane's wing exceeding its critical…NTSB ERA14LA369Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Helena, ALA total loss of engine power for reasons that could not be determined due to postcrash fire damage.NTSB ERA14IA370Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Jacksonville, FLThe nose landing gear collapse for reasons that could not be determined because examination of the airplane revealed no anomalies.NTSB ERA14LA362Accident · 2 fatalLimited investigationFinal reportPiper PA28 · Venice, FLA 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. Contributing to the accident was the pilot’s…NTSB CEN14LA474Accident · No injuriesLimited investigationFinal reportPiper PA 28RT-201T · Houston, TXThe landing gear’s failure to extend for reasons that could not be determined based on the available evidence.NTSB CEN14FA389Accident · 2 fatalField investigationFinal reportFedersen Walter Lancair IVP · Findlay, OHAn in-flight fire for reasons that could not be determined due to the extent of impact and fire damage.NTSB WPR14LA312Accident · Minor injuriesLimited investigationFinal reportRoscher Frederick Thunder Mustang · Spanish Springs, NVA complete loss of engine power during climb for reasons that could not be determined due to the severity of postcrash fire damage to the airplane.NTSB ERA14LA361Accident · No injuriesLimited investigationFinal reportHiller UH 12E · Wadesboro, NCA partial loss of engine power due to the failure of the No. 2 engine accessory gearbox bearing for reasons that could not be determined based on the available information.NTSB ERA14LA360Accident · Serious injuriesLimited investigationFinal reportRyan Aeronautical ST3KR · Newnan, GAA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA14LA358Accident · Serious injuriesLimited investigationFinal reportWinder Robert S VP1 · Grove City, PAA collision with terrain during the landing approach for reasons that could not be determined based on available information.NTSB ERA14LA351Accident · Serious injuriesLimited investigationFinal reportSiler Ronald E Ultrastar · Halifax, PAA total loss of engine power for reasons that could not be determined because the engine was not recovered. Contributing to the accident was the pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during…NTSB WPR14LA309Accident · 2 fatalLimited investigationFinal reportBeech A36 · Pago Pago, AntarcticaA loss of airplane control during the initial climb in gusting wind conditions for reasons that could not be determined because the wreckage was not recovered from the ocean.NTSB WPR14LA307Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Auburn, WAA collapse of the nose landing gear for reasons that could not be determined based on the available information.NTSB ERA14LA346Accident · 1 fatalLimited investigationFinal reportCessna 172N · Elliott Key, FLThe airplane’s vertical descent into water for reasons that could not be determined because postaccident airplane examinations revealed no mechanical anomalies.NTSB CEN14FA377Accident · 1 fatalField investigationFinal reportOden Weldon Pat Kitfox IV Speedster · Blackwell, TXThe pilot's loss of airplane control following a loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR14LA300Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Rancho Cucamonga, CAThe loss of engine power during cruise flight for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB CEN14LA385Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Wichita Falls, TXA partial loss of engine power, which resulted in a forced landing on unsuitable terrain. The reason for the loss of engine power could not be determined during postaccident examination.NTSB CEN14LA375Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Fairview, KSThe backfire of the engine and its loss of power for reasons that could not be determined based on the available evidence.NTSB WPR14LA298Accident · No injuriesLimited investigationFinal reportPiper PA 30 · Othello, WAThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB CEN14LA373Accident · Serious injuriesLimited investigationFinal reportGarramone Mike A Vixen · Columbus, NMA total loss of engine power during initial climb for reasons that could not be determined because postaccident engine examination did not reveal any preimpact failures or malfunctions that would have precluded normal operation.NTSB ERA14FA339Accident · 2 fatalField investigationFinal reportAllen Steen Skybolt · Carrollton, GAAn in-flight loss of airplane control for reasons that could not be determined during postaccident examinations or based on the available evidence.NTSB CEN14LA443Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-181 · Waukesha, WIThe loss of engine power for reasons that could not be determined because no anomalies were identified during postaccident examination.NTSB CEN14LA372Accident · 1 fatalLimited investigationFinal reportJonker Sailplanes JS1-C · Wallis, TXThe pilot’s loss of glider control and its subsequent impact with terrain for reasons that could not be determined due to a lack of available information.NTSB ERA14LA344Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Melbourne, FLA total loss of engine power during cruise flight for reasons that could not be determined based on the available information.NTSB CEN14LA346Accident · 1 fatalLimited investigationFinal reportBuckeye Dream Machine · Ansley, NEThe powered parachute's reduced takeoff performance in tailwind conditions for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any preimpact anomalies that would have precluded normal…NTSB ERA14LA332Accident · Minor injuriesLimited investigationFinal reportAeronca 7CCM · Prentiss, MSA total loss of engine power for reasons that could not be determined because postaccident engine examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA14LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Monroeville, ALA loss of engine power for reasons that could not be determined because postaccident examination of the engine and fuel system revealed no anomalies.NTSB CEN14LA333Accident · No injuriesLimited investigationFinal reportCessna 172R · Joplin, MOThe partial loss of engine power for reasons that could not be determined because an operational test run of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA14LA319Accident · Minor injuriesLimited investigationFinal reportWaco UPF 7 · Warrenton, VAA total loss of engine power during a low pass for reasons that could not be determined during postaccident examination of the engine.NTSB CEN14LA324Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Maryland Heights, MOThe loss of left engine power for reasons that could not be determined due to impact and fire damage.NTSB WPR14LA267Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502B · Sacramento, CAThe total loss of engine power for reasons that could not be determined because the airplane was not available for postaccident examination.NTSB CEN14WA321Accident · 2 fatalForeign investigationLearjet 35 - A · Olsberg, GermanyThe accident investigation is under the jurisdiction and control of the German government. This report is for information purposes only and contains only information released by or obtained from the German government or German Federal Bureau of Aircraft…NTSB WPR14FA258Accident · 1 fatalField investigationFinal reportParker Loehle Mustang T5151 · Livermore, CAAn in-flight fire of unknown origin for reasons that could not be determined because of impact damage and postimpact fire damage.NTSB CEN14LA305Accident · 1 fatalLimited investigationFinal reportBollinger Robert L BD 4 · Fairfield, IAThe pilot’s loss of airplane control due to the in-flight separation of the propeller blades for reasons that could not be determined based on the available evidence.NTSB CEN14FA306Accident · 2 fatalField investigationFinal reportBrumwell RV-6 · Sauk Rapids, MNThe pilot’s loss of pitch control due to the in-flight opening of the canopy during cruise flight for reasons that could not be determined because fire damage precluded examination of the airplane’s canopy and systems.