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 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.NTSB ERA17FA248Accident · 1 fatalField investigationFinal reportAircraft Mfg & Dvlpmt CH601XLi Slsa · Towanda, PAA partial loss of engine power for reasons that could not be determined based on the available information, and the pilot's exceedance of the airplane's critical angle of attack during an attempted return to the airport, which resulted in an aerodynamic stall…NTSB CEN17FA270Accident · 2 fatalField investigationFinal reportNorth American/Aero Classics P 51 · Cummings, KSThe loss of airplane control while maneuvering at low altitude for reasons that could not be determined.NTSB WPR17LA153Accident · Minor injuriesClass 3 · LimitedFinal reportClark James T Vans RV8 · Spokane, WAAn inflight engine fire for reasons that could not be determined based on the available information, which melted the air filter element and obstructed the engine's air intakes, resulting in a total loss of engine power.NTSB WPR17FA151Accident · 2 fatalField investigationFinal reportPiper PA 44-180 · Marineland, FLA loss of control in flight for reasons that could not be determined based on the available information, which resulted in an in-flight breakup.NTSB CEN17FA266Accident · 2 fatalField investigationFinal reportPiper PA31T · Tyler, TXThe loss of engine power and the subsequent pilot's loss of control for reasons that could not be determined because post-accident engine examination revealed no anomalies.NTSB ERA17LA266Accident · No injuriesLimited investigationFinal reportPiper PA28R · Pembroke Pines, FLThe loss of engine power for reasons that could not be determined postaccident engine test-runs revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR17LA148Accident · No injuriesLimited investigationFinal reportCharles J Norris Arion Lightning · New River, AZA partial loss of engine power for reasons that could not be determined due to a lack of available evidence.NTSB CEN17LA265Accident · Minor injuriesLimited investigationFinal reportCubcrafters CC11-160 · Milesville, SDFuel starvation and a subsequent loss of engine power for reasons that could not be determined because a postaccident examination and a test run of the engine did not reveal any anomalies. Contributing to the accident was the pilot’s failure to maintain…NTSB CEN17LA263Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Corydon, IAA total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.NTSB WPR17FA146Accident · 1 fatalField investigationFinal reportChicco Miguel E Quicksilver Sport II · Point Mugu, CAA partial loss of engine power for reasons that could not be determined during postaccident examination in combination with the low cruise altitude selected by the pilots, which resulted in an ocean ditching. The lack of personal flotation devices likely…NTSB ERA17LA237Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Bartow, FLA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airplane revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR17LA142Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Vacaville, CAThe total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine revealed no mechanical failure or malfunction that would have precluded normal operation.NTSB CEN17LA322Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Hamilton, OHThe pilot's loss of directional control after landing for reasons that could not be determined because an examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB ERA17LA227Accident · No injuriesLimited investigationFinal reportPiper PA28 · San Juan, PRA partial loss of engine power during initial climb for reasons that could not be determined and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN17LA255Accident · No injuriesLimited investigationFinal reportBeech A36 · El Paso, TXA partial loss of engine power for reasons that could not be determined because a postaccident examination did not reveal any anomalies that would have precluded normal engine operation.NTSB WPR17LA140Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Bella Vista, CAA partial loss of engine power during low-altitude maneuvering for reasons that could not be determined because postaccident examinations of the engine and airframe revealed no evidence of any preaccident mechanical malfunctions or failures that would have…NTSB ERA17LA253Accident · No injuriesLimited investigationFinal reportWaco UPF 7 · Brunswick, GAThe failure of the right main landing gear strut brace for reasons that could not be determined based on the available evidence.NTSB CEN17LA250Accident · 1 fatalLimited investigationFinal reportNorth American T-28A · Moorhead, MNControlled descent into terrain due to engine issues, the reason for which could not be determined because examination of the engine revealed no evidence of malfunctions or failures that would have precluded normal operation.NTSB CEN17FA248Accident · 6 fatalField investigationFinal reportCessna 421C · Catawba, WIA loss of control and subsequent in-flight breakup for reasons that could not be determined based on the available information.NTSB WPR17LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Honolulu, HIA total loss of engine power during initial climb for reasons that could not be determined due to impact and fire damage.NTSB WPR17LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Dixon, CAA total loss of engine power for reasons that could not be determined due to extensive damage.NTSB ERA17LA220Accident · Serious injuriesLimited investigationFinal reportNunley KR2 · Baker, FLA partial 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 precluded normal operation.NTSB CEN17LA247Accident · No injuriesLimited investigationFinal reportCessna P210N · Eagle, COThe loss of engine power due to fuel starvation for reasons that could not be determined because an examination of the airplane and engine did not reveal any malfunctions or failures that would have precluded normal operation.NTSB ERA17FA210Accident · 1 fatalField investigationFinal reportPiper PA28 · Fort Myers, FLA partial loss of engine power during initial climb for reasons that could not be determined because extensive fire damage precluded thorough examination of the engine and its associated systems.NTSB WPR17LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna 421B · Carlsbad, CAThe right main landing gear collapse for undetermined reasons.NTSB CEN17LA238Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Mahnomen, MNThe pilot’s failure to abort the takeoff after recognizing a partial loss of engine power during the takeoff roll and his subsequent inability to maintain adequate airspeed during a turn to avoid power lines, which resulted in an aerodynamic stall. The…NTSB CEN17LA235Accident · No injuriesLimited investigationFinal reportCessna 182A · Buffalo, OKThe separation of the nose wheel axle bolt and the nose wheel during the landing roll for reasons that could not be determined because the bolt was not recovered.NTSB CEN17LA232Accident · Serious injuriesLimited investigationFinal reportBell-Tellijohn 47G · Hastings, MNThe pilot's failure to maintain helicopter control for reasons that could not be determined because postaccident examination of the helicopter did not reveal any preimpact mechanical malfunctions or anomalies that would have precluded normal operation.NTSB CEN17LA239Accident · No injuriesLimited investigationFinal reportLevy Adam V Legacy 2000 · Georgetown, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR17LA122Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Rexberg, IDA loss of engine power for reasons that could not be determined based on the available information which resulted in a landing short of the runway.NTSB CEN17FA208Accident · 1 fatalField investigationFinal reportMichael S. Logan Kitfox · New Berlin, TXA total loss of engine power for reasons that could not be determined based on the available information, and the pilot's subsequent failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and experiencing…NTSB WPR17FA117Accident · 1 fatalField investigationFinal reportCessna 180 · Ventura, CAThe pilot's abrupt and substantial pullup maneuver while flying the airplane above the maneuvering speed, which resulted in an in-flight breakup. The reason for the pilot's maneuver could not be determined based on the available evidence.NTSB ERA17LA194Accident · No injuriesLimited investigationFinal reportAvions Mudry Cie CAP 231 · Lebanon, PAThe partial separation of one counterweight and the subsequent seizure of the engine due to mechanical interference. Contributing to the partial separation of the counterweight was the overstress fracture of a retaining ring and the fatigue fracture of the…NTSB WPR17LA110Accident · Minor injuriesLimited investigationFinal reportJohnson Glastar · Concord, CAA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ANC17LA024Accident · No injuriesLimited investigationFinal reportCessna U206F · Noatak, AKA fire in the airplane's cabin, which initiated for reasons that could not be determined due to extensive thermal damage.NTSB ERA17LA185Accident · No injuriesLimited investigationFinal reportCessna 182 · West Chester, PAAn engine crankcase overpressurization and the subsequent loss of engine oil for reasons that could not be determined, which resulted in the failure of the No. 6 cylinder connecting rod due to a lack of lubrication.