NTSB investigations, 2017
135 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 150 |
|---|---|
| 2009 | 199 |
| 2010 | 195 |
| 2011 | 156 |
| 2012 | 171 |
| 2013 | 128 |
| 2014 | 150 |
| 2015 | 163 |
| 2016 | 137 |
| 2017 | 135 |
| 2018 | 143 |
| 2019 | 118 |
| 2020 | 86 |
| 2021 | 98 |
| 2022 | 76 |
| 2023 | 68 |
| 2024 | 37 |
| 2025 | 29 |
| 2026 | 9 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2017
AND 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 year(c."eventDate") = 2017 AND 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 WPR18LA049Accident · Serious injuriesLimited investigationFinal reportNorth American Navion · El Cajon, CAA 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 ERA18LA062Accident · No injuriesLimited investigationFinal reportPiper PA32 · Oakland Park, FLThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR18FA046Accident · 2 fatalField investigationFinal reportBeech A36 · San Diego, CAA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN18FA050Accident · 1 fatalField investigationFinal reportSmith Aerostar 601 · Miami, FLThe pilot's loss of control while returning to the airport after takeoff for reasons that could not be determined based on the available information.NTSB WPR18LA047Accident · No injuriesClass 3 · LimitedFinal reportCessna 172D · Auburn, WAThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB CEN18LA048Accident · No injuriesLimited investigationFinal reportPiper PA 31-310 · Jeffersonville, INThe right main landing gear’s failure to fully extend for reasons that could not be determined because postaccident testing revealed no mechanical anomalies that would have precluded normal operation.NTSB ERA18LA039Accident · 2 fatalLimited investigationFinal reportKevin Leue Sparrow Hawk · Hernando, MSImpact with trees and terrain for reasons that could not be determined based on available evidence.NTSB ANC18LA013Accident · No injuriesLimited investigationFinal reportCessna 172R · Huntingdon, TNA total loss of engine power for reasons that could not be determined because a postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA18LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA46 · Clearwater, FLA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ANC18LA010Accident · No injuriesLimited investigationFinal reportRockwell International 112A · Clearwater, FLA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA18LA027Accident · No injuriesClass 3 · LimitedFinal reportHomer Autogyro Cavalon · Oak Island, NCA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA18LA021Accident · No injuriesClass 2 · LimitedFinal reportSocata TB200 · Annapolis, MDA loss of engine power for undetermined reasons after the disconnection of the propeller governor control due to inadequate securenment during maintenance.NTSB WPR18LA029Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Rolling Fork, MSAn uncommanded yaw and subsequent loss of main rotor rpm for reasons that could not be determined.NTSB WPR18LA020Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 140 · Port Townsend, WAA total loss of engine power for undetermined reasons.NTSB WPR18LA010Accident · 2 fatalLimited investigationFinal reportRobinson Helicopter R44 · Molokai, HIA descent and subsequent impact with open ocean waters for reasons that could not be determined based on the available information.NTSB GAA18CA013Accident · No injuriesData collectionFinal reportCessna 172RG · Auburn, WAThe failure of the right main landing gear for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR18LA004Accident · No injuriesClass 3 · LimitedFinal reportWestern International Avia UH 1H · Arbuckle, CAA collective control malfunction for reasons that could not be determined.NTSB CEN18FA004Accident · 1 fatalField investigationFinal reportAero Vodochody L39C · Vernon, TXAn in-flight loss of control and collision with terrain for reasons that could not be determined based on the available information.NTSB ERA18FA006Accident · 1 fatalField investigationFinal reportPiper PA 25-235 · Front Royal, VAThe tow plane pilot's loss of airplane control for reasons that could not be determined based on the available evidence. Contributing to the accident was the glider instructor's diversion of attention away from the tow airplane which resulted in his delay in…NTSB CEN18LA010Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sweetwater, TXThe loss of engine power during a precautionary approach for landing for reasons that could not be determined based on the available information.NTSB CEN18LA008Accident · No injuriesLimited investigationFinal reportPiper PA 34-220T · Sugar Grove, ILA partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18LA007Accident · No injuriesClass 3 · LimitedFinal reportThomas Stephen Glasair Super II RG · Santa Ynez, CAA partial loss of engine power for reasons that were not determined.NTSB CEN18FA003Accident · 1 fatalField investigationFinal reportSchaffer Fisher Horizon 2 · Eden Prairie, MNAn inflight loss of control and collision with terrain for undetermined reasons after a thorough examination of the airplane's flight controls was unable to confirm control continuity. Contributing to the accident was the pilot's lack of experience in the…NTSB GAA17CA563Accident · No injuriesData collectionFinal reportPiper PA 22 · Orangeburg, SCA failed main landing gear tire for reasons that could not be determined due to postcrash fire damage.NTSB CEN17LA366Accident · No injuriesLimited investigationFinal reportEmerson Kitfox · Waller, TXA partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR17LA210Accident · No injuriesLimited investigationFinal reportCessna 210 · Sacramento, CAPartial retraction of the main landing gear during the landing roll for reasons that could not be determined because postaccident examination and functional testing of the gear revealed no anomalies.NTSB ERA17LA347Accident · No injuriesLimited investigationFinal reportBeech 35 · Marathon, FLA total loss of engine power for reasons that could not be determined because saltwater corrosion precluded a complete examination.NTSB CEN17LA365Accident · No injuriesLimited investigationFinal reportGaddis Michael Exec 162 F · Plymouth, INA failure of the drive belt for reasons that could not be determined based on the available information.NTSB CEN17LA357Accident · Minor injuriesLimited investigationFinal reportBeech A36 · McAlester, OKA total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR17LA202Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Ogden, UTThe airplane's inability to maintain an initial takeoff climb for reasons that could not be determined based on available information.NTSB ERA17LA314Accident · No injuriesClass 3 · LimitedFinal reportRudder Dwight K Kitfox IV 1200 Spdst · Raymond, MSA total loss of engine power during initial climb for undetermined reasons.NTSB WPR17LA197Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Santa Paula, CAA partial loss of engine power during initial climb for reasons that could not be determined based on the available information.NTSB CEN17LA338Accident · No injuriesLimited investigationFinal reportGolden Eagle Chief · Mt. Zion, ILA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN17LA340Accident · No injuriesLimited investigationFinal reportCessna 310G · Broomfield, COA collapse of the right main landing gear due to a bent pushrod, which precluded the gear from fully extending. The reason for the bent pushrod could not be determined based on the available information.NTSB WPR17LA191Accident · No injuriesLimited investigationFinal reportNorth American Navion A · Fortuna, CAA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have that would have precluded normal operation.NTSB WPR17LA194Accident · No injuriesClass 3 · LimitedFinal reportPaul Gaywood E CH 601 HD · Goldendale, WAA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA17LA301Accident · No injuriesLimited investigationFinal reportPiper PA28R · Monroe, NCA hard landing at an unknown time.NTSB WPR17LA187Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 310I · Salt Lake City, UTA loss of engine power for reasons that could not be determined based on the available information.NTSB CEN17LA329Accident · No injuriesLimited investigationFinal reportJames M Raulerson CH 750 · Manila, ARA loss of engine power for reasons that could not be determined because the airplane was not available for examination.NTSB ANC17FA047Accident · 1 fatalField investigationFinal reportRockwell International S 2R · Calipatria, CAA loss of control for reasons that could not be determined because of the extensive thermal damage from the postcrash fire.NTSB ERA17LA300Accident · Minor injuriesLimited investigationFinal reportPiper PA 28R-200 · St. Augustine, FLA total loss of engine power for reasons that could not be determined because examination of the airplane and engine did not reveal evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation and because the amount…NTSB ERA17LA282Accident · Minor injuriesLimited investigationFinal reportBellanca 7ACA · Fairhope, ALA total loss of engine power for reasons that could not be determined because postaccident examination and a test run of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA17LA276Accident · Minor injuriesLimited investigationFinal reportBradley Roderick W Murphy Renegade · Guilford, CTA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN17LA318Accident · Minor injuriesLimited investigationFinal reportKnapp Easy Raider · Rochester, INA partial 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 ERA17LA268Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Mount Sterling, KYA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR17FA179Accident · 1 fatalField investigationFinal reportMichaelian Lancair IV-TP · Rio Linda, CAA loss of engine power for reasons that could not be determined based on available evidence.NTSB WPR17FA170Accident · 4 fatalField investigationFinal reportBeech 19A · Waipi'o, HIThe pilot's controlled flight into terrain for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot's decision to fly at low altitude in close proximity to the rising terrain.NTSB ERA17LA264Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA 4 · Orlando, FLA loss of directional control during taxi operations for reasons that could not be determined based on the available information, which resulted in the airplane rolling into a ditch.NTSB WPR17FA166Accident · 4 fatalField investigationFinal reportBeech A36TC · Ogden, UTA loss of control during takeoff for reasons that could not be determined.NTSB CEN17LA285Accident · Serious injuriesLimited investigationFinal reportHillard Charlie R Hawker FB60 · Breckenridge, TXA total loss of engine power for reasons that could not be determined because postaccident engine examination and testing did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.