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 WPR13FA017Accident · 1 fatalField investigationFinal reportCessna 182P · Yucca, AZThe pilot’s failure to take corrective action to avoid terrain during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA13LA024Accident · Serious injuriesLimited investigationFinal reportCashmer Philip M Sonex · Crossville, TNThe pilot’s failure to maintain control of the airplane, which resulted in a low-altitude aerodynamic stall/spin. Contributing to the accident was a loss of engine power for reasons that could not be determined during postaccident examination and the pilot’s…NTSB ANC13FA004Accident · 1 fatalField investigationFinal reportGrumman Aircraft ENG C-1A · Willow, AKThe pilot’s loss of control of the airplane for reasons that could not be determined because the wreckage was not recovered from the accident site.NTSB ERA13TA021Accident · Minor injuriesFinal reportBell OH-58A · Jackson, TNA loss of engine power for undetermined reasons because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ANC13FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-18-150 · Kenai, AKUndetermined. The airplane and pilot were not found.NTSB ERA13LA015Accident · Serious injuriesLimited investigationFinal reportVelline'S Breezy RLU-1 · Madison, GAThe pilot’s failure to maintain airspeed following a loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and the airplane’s…NTSB WPR13LA005Accident · Minor injuriesLimited investigationFinal reportCessna 180H · St Maries, IDThe 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 ERA13LA013Accident · Serious injuriesLimited investigationFinal reportBeaudry Phillip Aventura II · Minneola, FLA 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 ERA13LA005Accident · No injuriesLimited investigationFinal reportCessna 310I · Burlington, VTThe collapse of the left main landing gear due to a failure of the left main gear bellcrank pin for reasons that could not be determined because the pieces of the fractured bellcrank pin were not located.NTSB CEN12FA670Accident · Serious injuriesField investigationFinal reportAgusta A109E · Eastland, TXThe loss of helicopter control after an in-flight upset, which occurred when the pilot selected the autopilot’s altitude hold mode; the reason for the reported in-flight control anomaly could not be determined during postaccident helicopter examinations.…NTSB WPR12LA439Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eugene, ORA total loss of engine power due to fuel exhaustion during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have resulted in the loss of engine power.NTSB ERA12IA582Incident · No injuriesIncident investigationFinal reportLearjet 60 · Teterboro, NJFailure of the nosewheel steering computer strut servo for reasons that could not be determined or replicated during postincident testing.NTSB CEN12LA661Accident · No injuriesLimited investigationFinal reportLake LA4 · Kenosha, WIThe loss of engine power for reasons that could not be determined because examination and test run of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA675Accident · No injuriesLimited investigationFinal reportBeech E33 · Greeley, COThe loss of engine power for reasons that could not be determined during postaccident examinations and testing.NTSB WPR12LA434Accident · No injuriesLimited investigationFinal reportNavion Navion · Lompoc, CAA total loss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA659Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 210S · Albuquerque, NMThe failure of the balloon envelope parachute vent to properly seat, which resulted in the uncontrolled descent of the balloon. The reason the vent did not properly seat during the accident flight could not be determined because the vent operated properly…NTSB CEN12LA652Accident · Minor injuriesLimited investigationFinal reportBeech 95-C55 · (Gulf of Mexico)An in-flight fire, which resulted in the airplane’s forced landing in water. The source of the fire could not be determined because the airplane wreckage was not recovered.NTSB WPR12LA417Accident · Minor injuriesLimited investigationFinal reportSeymour Skyranger · Perris, CAA loss of aircraft control during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA632Accident · No injuriesLimited investigationFinal reportBruce M Barrett Stolp Starlet SA500 · Shelbyville, ILAn abrupt, complete loss of engine power during cruise flight 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 CEN12LA651Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Boonville, INA total loss of engine power during initial climb due to fuel starvation for reasons that could not be determined because postaccident examination could not verify whether the fuel selector was properly positioned before takeoff.NTSB CEN12FA621Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Houston, TXThe pilot's failure to maintain control of the helicopter after a loss of engine power. The reason for the loss of engine power could not be determined because examination did not reveal any anomalies that would have precluded operation.NTSB WPR12LA411Accident · No injuriesLimited investigationFinal reportCessna A185F · Cambria, CAA partial loss of engine power during cruise flight for reasons that could not be determined because the airplane sank in the ocean and was not recovered.NTSB WPR12LA408Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZA total loss of engine power during descent for reasons that could not be determined because postaccident engine examinations and testing revealed no evidence of an anomaly that would have precluded normal operation.NTSB CEN12FA617Accident · 1 fatalField investigationFinal reportBeech A36 · Kansasville, WIIn-flight loss of control for reasons that could not be determined because postaccident examination of the pilot and testing of the airplane did not reveal any anomalies that would have led to the loss of control.NTSB WPR12LA409Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Monroe, WAA loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA406Accident · Minor injuriesLimited investigationFinal reportAviat A-1B · Durham, CAA loss of engine power during takeoff 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 ANC12LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Homer, AKThe total loss of engine power for reasons that could not be determined because the engine could not be examined because of the extent of time in salt water.NTSB ERA12LA545Accident · Minor injuriesLimited investigationFinal reportCessna 172E · East Bend, NCA total loss of engine power during the initial climb after takeoff for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA383Accident · No injuriesLimited investigationFinal reportCessna 177RG · Olympia, WAA loss of directional control during landing for reasons that could not be determined because postaccident examination of the nose gear steering mechanism did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA382Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Chelan, WAA loss of engine power during climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12FA369Accident · 5 fatalField investigationFinal reportPiper PA-32-301T · South Lake Tahoe, CAA partial loss of engine power for reasons that could not be determined because examinations revealed no evidence of mechanical anomalies with the airframe or engine that would have precluded normal operation and the pilots’ decision to continue the departure…NTSB ERA12LA532Accident · Serious injuriesLimited investigationFinal reportMooney M20C · East Hampton, NYA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any failures or malfunctions that would have precluded normal operation.NTSB ANC12LA093Accident · No injuriesLimited investigationFinal reportCessna U206D · Nikolai, AKThe total loss of engine power for reasons that could not be determined because the engine was not made available for examination.NTSB WPR12LA366Accident · No injuriesLimited investigationFinal reportPiper PA-30 B · Scappoose, ORThe failure of the landing gear to fully extend as a result of a failure of the landing gear transmission assembly for reasons that could not be determined based on the available evidence.NTSB CEN12WA560Accident · 2 fatalForeign investigationPaulistinha 56-C1 56-C1 · Braga, PortugalThis report is under the jurisdiction and control of the Portuguese Government.NTSB WPR12LA414Accident · No injuriesLimited investigationFinal reportCessna T210N · Bakersfield, CAA partial loss of engine power during the initial climb due to an in-flight fire of undetermined origin.NTSB ERA12FA508Accident · 2 fatalField investigationFinal reportBeech A36TC · Clifton Park, NYA total loss of engine power for reasons that could not be determined during the postaccident investigation and testing.NTSB ANC12WA087Accident · 1 fatalForeign investigationPiper PA-30 · Kelowna, CanadaOn August 13, 2012, about 1729 Pacific daylight time, a Piper PA-30 airplane, (Canadian Registration C-GLGJ) was on a VFR flight plan from Penticton to Boundary Bay, British Columbia. The Canadian Joint Rescue Coordination Centre received an ELT signal, and a…NTSB ERA12LA505Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Bay Minette, ALThe separation of the tailwheel linkage for reasons that could not be determined because the linkage was not located, which resulted in a loss of directional control during landing.NTSB WPR12FA349Accident · 1 fatalField investigationFinal reportCessna P210N · Santa Monica, CAThe pilot's failure to maintain altitude during a return to the airport following an unspecified emergency; the nature of the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would…NTSB ERA12LA500Accident · No injuriesLimited investigationFinal reportBeech V35B · Effingham, SCThe pilot's failure to avoid an encounter with known adverse weather conditions, which resulted in an in-flight upset, temporary loss of control, and loading of the airframe, engine, and propeller that led to the in-flight separation of the propeller and the…NTSB CEN12LA637Accident · No injuriesLimited investigationFinal reportSackman Sackman Special · Ste. Genevieve, MOThe loss of engine power during a low level maneuver due to oil starvation for reasons that could not be determined during postaccident examination.NTSB WPR12LA347Accident · Minor injuriesLimited investigationFinal reportHiller UH-12D · Deer Island, ORA loss of helicopter control while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA507Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Clifford, PAPartial 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 CEN12FA520Accident · No injuriesField investigationFinal reportPiper PA-38-112 · Fate, TXA 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 CEN12LA516Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDThe loss of directional control during landing roll, which resulted in a runway excursion. The reason for the loss of directional control could not be determined because postaccident examination did not reveal any malfunctions or anomalies that would have…NTSB ERA12FA491Accident · 1 fatalField investigationFinal reportSilvaire Luscombe 8A · St. Petersburg, FLThe flight instructor’s and the pilot’s failure to maintain airspeed after a partial loss of engine power after takeoff for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane…NTSB CEN12LA495Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lakeview, ARThe pilot’s loss of control during the takeoff roll for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA494Accident · No injuriesLimited investigationFinal reportLee Oscar D III RV7 · Columbus, INThe failure of the right main landing gear attach bolt for undetermined reasons because the bolt was not received for examination.NTSB CEN12FA487Accident · No injuriesField investigationFinal reportMooney M20TN · Adrian, MIAn initial nose-pitch-up event and out-of-trim condition, the reason for which could not be determined because the examinations of the airplane did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the…