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 ERA15LA293Accident · Serious injuriesLimited investigationFinal reportBeech C90B · Georgetown, KYUndetermined based on the available evidence.NTSB CEN15FA331Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Wilmot, ARThe pilot's inability to maintain control of the airplane as a result of incapacitation by drug effects or an acute cardiac event.NTSB CEN15LA329Accident · 1 fatalLimited investigationFinal reportO'Dell Aeromaster · Sulphur Springs, TXA total loss of engine power for reasons that could not be determined because postimpact damage precluded a thorough examination of the airplane. Contributing to the accident was the pilot's failure to maintain control following the loss of engine power,…NTSB CEN15LA326Accident · No injuriesLimited investigationFinal reportEagle Eagle DW 1 · Hector, MNThe intermittent partial loss of engine power, which resulted in a lower-than-expected approach glidepath and impact with terrain short of the runway. The reason for the intermittent partial loss of engine power could not be determined because postaccident…NTSB WPR15FA222Accident · 1 fatalField investigationFinal reportBeech F35 · Riverside, CAThe total loss of engine power for reasons that could not be determined during postaccident examination of the airplane and engine. Also causal to the accident was the pilot's decision to attempt to reach the farthest runway and land into the wind instead of…NTSB ERA15LA283Accident · Minor injuriesLimited investigationFinal reportCessna 195A · Iuka, MSA total loss of engine power for reasons that could not be determined because a postaccident examination of the engine and fuel system found no mechanical anomalies that would have precluded normal operation.NTSB ERA15LA279Accident · No injuriesLimited investigationFinal reportKinner Sportster B · Eagles Mere, PAThe total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN15LA319Accident · No injuriesLimited investigationFinal reportCessna 182E · Rozet, WYThe loss of engine power for reasons that could not be determined because an examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR15LA219Accident · Minor injuriesLimited investigationFinal reportGarlick UH1H · Walla Walla, WAThe helicopter’s reduction in aerodynamic lift while operating in variable wind conditions for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have…NTSB ERA15LA276Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA1B · Lititz, PAA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine found no mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN15FA307Accident · 4 fatalField investigationFinal reportCessna T310R · Cody, WYThe pilot's loss of airplane control following the loss of power in the left engine; the reason for the loss of power could not be determined during postaccident engine examination.NTSB CEN15LA309Accident · No injuriesLimited investigationFinal reportCessna 172RG · Anoka, MNFailure of the left landing gear actuator for reasons that could not be determined because the actuator was not made available for examination.NTSB CEN15LA308Accident · Serious injuriesLimited investigationFinal reportDevoe Clip Wing · Melbourne, ARThe loss of engine power for reasons that could not be determined based on the available evidence and the postaccident engine examination, which led to a forced landing on unsuitable terrain due to the pilot’s decision not to deploy the ballistic parachute…NTSB CEN15FA305Accident · 2 fatalField investigationFinal reportPiper PA 32-300 · Brazoria, TXThe student pilot's failure to arrest the descent in a timely manner and the flight instructor's failure to safely intervene in the routine training maneuver for reasons that could not be determined based on the information available.NTSB CEN15LA357Accident · Minor injuriesLimited investigationFinal reportPiper PA 30 · Clifton, TXThe pilot's failure to maintain control during a precautionary landing following a total loss of power to one engine. The reason for the loss of engine power could not be determined based on available information.NTSB ERA15LA270Accident · No injuriesLimited investigationFinal reportAyres S2R T34 · Climax, GAA loss of thrust on takeoff for reasons that could not be determined, because postaccident examination of the engine and propeller assembly did not reveal any mechanical anomalies that would have precluded normal operation.NTSB CEN15FA289Accident · 1 fatalField investigationFinal reportCessna 172P · Bartlett, ILThe pilot’s loss of airplane control for reasons that could not be determined because an examination of the airplane did not reveal any preimpact abnormalities.NTSB ANC15LA044Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe partial loss of engine power after takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR15FA206Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Carey, IDUndetermined because examination of the airplane wreckage did not reveal any anomalies that would have precluded normal operation.NTSB WPR15FA205Accident · 2 fatalField investigationFinal reportSchweizer 269C · Newberg, ORThe loss of translation/rotational power between the engine and the transmission due to the severe wear of the forward spline portion of the lower coupling drive shaft. The reason for the severe wear of the forward spline could not be definitively determined…NTSB CEN15LA294Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Louisburg, KSA partial loss of engine power for reasons that could not be determined during postaccident examinations.NTSB WPR15LA203Accident · No injuriesLimited investigationFinal reportBeech C 99 · Salt Lake City, UTThe airplane’s unmanageable right yaw during takeoff for reasons that could not be determined because postaccident examination of the rudder and rudder assembly did not reveal any anomalies that would have precluded normal operation.NTSB WPR15LA196Accident · No injuriesLimited investigationFinal reportPiper PA 32R-301 · Boulder City, NVA total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.NTSB CEN15LA285Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Danville, ARThe loss of engine power for reasons that could not be determined based on the available information.NTSB WPR15LA192Accident · Minor injuriesLimited investigationFinal reportRoberts Super Bear · La Grande, ORA total loss of engine power for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB WPR15LA191Accident · No injuriesLimited investigationFinal reportCessna 180A · Polson, MTA total loss of engine power during approach for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB CEN15FA278Accident · 1 fatalField investigationFinal reportCessna 172 · Shreveport, LAThe pilot's loss of airplane control during initial climb after takeoff for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact anomalies.NTSB ERA15LA248Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA15FA241Accident · Serious injuriesField investigationFinal reportPiper PA-22 · Laconia, NHA total loss of engine power for reasons that could not be determined because of insufficient evidence found during postaccident examination of the airframe and engine.NTSB CEN15FA277Accident · 1 fatalField investigationFinal reportNorthwing Design Apache Sport · Taos, NMThe powered-lift aircraft's departure from controlled flight for reasons that could not be determined from the available information.NTSB ERA15LA239Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Dushore, PAThe total loss of engine power during the initial climb for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.NTSB CEN15LA272Accident · Serious injuriesLimited investigationFinal reportWeatherly 620A · Van Horn, TXThe loss of engine power for reasons that could not be determined based on the available information.NTSB WPR15LA183Accident · No injuriesLimited investigationFinal reportBeech E33A · Tucson, AZA loss of left braking action for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal operation, which resulted in a loss of…NTSB GAA15CA161Accident · No injuriesData collectionFinal reportCessna 172S · Galesburg, ILFirewall damage reported by maintenance personnel that occurred during an unknown phase of flight, because the accident flight and pilot could not be determined.NTSB CEN15LA258Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Haskell, OKThe loss of engine power for reasons that could not be determined because a postaccident engine examination and test run did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB CEN15LA253Accident · 1 fatalLimited investigationFinal reportSchleicher ASW27 - 18E · Lamy, NMA loss of glider control for reasons that could not be determined based on the available evidence and the glider’s severe fragmentation.NTSB WPR15FA174Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Livermore, CAA loss of control for reasons that could not be determined, because examination of the airframe and engine revealed no anomalies that would have precluded normal operation.NTSB ERA15LA232Accident · No injuriesLimited investigationFinal reportBeech A23 24 · Grove Hill, ALA total loss of engine power for reasons that could not be determined because engine examination and testing did not reveal any anomalies that would have precluded normal operation.NTSB WPR15LA179Accident · No injuriesLimited investigationFinal reportBurr Express 2000 RG · Glendale, AZA collapse of the left main landing gear for reasons that could not be determined based on the available information.NTSB WPR15LA170Accident · Serious injuriesLimited investigationFinal reportDuenas Pulsar III · Hurricane, UTAn elevated oil temperature and subsequent total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR15LA168Accident · 1 fatalLimited investigationFinal reportHiller UH 12E · Wasco, CAAn in-flight impact with terrain for reasons that could not be determined based on available evidence.NTSB CEN15LA243Accident · No injuriesLimited investigationFinal reportCessna TR182 · Tulia, TXThe partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical anomalies that would have precluded normal operation.NTSB ERA15LA225Accident · No injuriesLimited investigationFinal reportPiper PA44 · Miami, FLThe failure of the nose landing gear upper drag link knee bolt due to reverse-bending fatigue, which was likely preceded by excessive bearing wear due to reasons that could not be determined based on the available evidence.NTSB CEN15LA237Accident · No injuriesLimited investigationFinal reportPiper PA-22 · St. Charles, MOA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN15LA231Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Columbia, ILA total loss of engine power while maneuvering at low altitude for reasons that could not be determined during postaccident examination.NTSB WPR15FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172S · Davenport, CAUndetermined because the airplane was not located.NTSB ERA15FA204Accident · 1 fatalField investigationFinal reportCessna 182 · Mulberry, TNThe pilot's failure to recover from a controlled descent for reasons that could not be determined during the postaccident investigation.NTSB CEN15LA217Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Neillsville, WIA partial loss of engine power 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 CEN15FA214Accident · Serious injuriesField investigationFinal reportBeech B35 · Orange, TXThe impact with power lines for reasons that could not be determined based on the available information.NTSB ERA15LA202Accident · No injuriesLimited investigationFinal reportBeech D95 · Jacksonville, FLThe pilot's failure to properly configure the airplane for landing. Contributing to the accident were pilot fatigue, distraction, and complacency and the failure of the landing gear warning horn to sound for reasons that could not be determined based on the…