NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 DEN00LA038Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Rock Springs, WYA forced landing on rough, unsuitable terrain. Factors were: Inadequate preflight planning, flight into known adverse weather conditions containing snow, high gusting winds, low temperatures, and a total loss of power for non mechanical reasons due to…NTSB ATL00FA023Accident · 2 fatalField investigationFinal reportBeech 23 · Macon, GAThe loss of engine power for undetermined reasons. A factor was conditions favorable for the formation of carburetor ice.NTSB SEA00FA037Accident · 1 fatalField investigationFinal reportCessna 150G · Marysville, WAFuel exhaustion due to the non-certificated 'pilot's' failure to determine the fuel quantity prior to takeoff. Factors include a dark night, and a non-iluminated electrical transmission wire strung across the highway upon which the pilot was attempting to…NTSB NYC00FA063Accident · 2 fatalField investigationFinal reportCessna 310N · Old Forge, PABoth pilots' failure to adequately manage the fuel supply, which resulted in fuel starvation.NTSB MIA00FA064Accident · 1 fatalField investigationFinal reportCessna 172R · Atlantic Ocean (Atlantic Ocean)The pilot's lack of total experience in instrument flight, simulated instrument flight, and night flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with water. Contributing to the accident was the dark night with…NTSB CHI00FA057Accident · 1 fatalField investigationFinal reportBeech D-95A Travelair · Dunbar, WIthe pilot failed to maintain a proper glidepath and obstacle clearance during an instrument approach. Additional factors to the accident included the dark night, icing conditions, flight into known adverse weather, and conditions conducive to pilot fatigue.NTSB IAD00LA015Accident · No injuriesLimited investigationFinal reportBell 206A · Brutus, NYWas the pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness.NTSB DEN00LA036Accident · No injuriesLimited investigationFinal reportBeech B200 · Jackson, WYThe pilot misreading the visual approach lighting system, resulting in his failure to maintain proper alignment with the runway and his selection of an improper touchdown point. Factors were the low ceiling weather conditions and the snow covered runway.NTSB MIA00LA061Accident · No injuriesLimited investigationFinal reportEaa Chapter 229 Zenair 601 · Kissimmee, FLThe pilot's failure to maintain directional control on landing resulting in the airplane going off the side of the runway and colliding with a barricade.NTSB LAX00LA071Accident · No injuriesLimited investigationFinal reportRotorway Exec 90 · Chandler, AZthe fatigue fracture and separation of the secondary drive shaft, which resulted from the manufacturer's inadequate quality control process.NTSB ATL00FA021Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Cordesville, SCThe pilot's inadequate inflight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB MIA00FA060Accident · No injuriesField investigationFinal reportRobinson R44 · Cayey, PRThe pilot's failure to use carburetor heat as required by the Pilot's Operating Handbook resulting in a loss of engine and rotor rpm, forced landing to none suitable terrain (residence), and subsequent roll over.NTSB LAX00LA063Accident · No injuriesLimited investigationFinal reportCessna 172G · Victorville, CAThe failure of the pilot to maintain positional awareness, which resulted in his becoming lost and disoriented. Contributing factors were the pilot's delay requesting assistance from air traffic control and the failure of the airplane's electrical generator.NTSB FTW00LA067Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Corning, ARThe loss of engine power for an undetermined reason. A factor was the dark night light condition.NTSB FTW00LA058Accident · No injuriesLimited investigationFinal reportCessna A185F · Houston, TXthe loss of engine power during climb as a result of fatigue cracking of the #4 cylinder head and its subsequent separation from its barrel.NTSB LAX00LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Dos Palos, CAA partial loss of engine power due to the failure of maintenance personnel to properly install and safety the throttle arm to the carburetor throttle shaft.NTSB FTW00LA057Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Odessa, TXThe separation of the #1 piston pin due to fatigue, which resulted in a total loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00FA037Accident · 1 fatalField investigationFinal reportCessna 421B · Telluride, COThe non-instrument rated pilot's intentional flight into IMC, and his subsequent spatial disorientation that resulted in an inadvertent stall. A factor was the snow showers weather condition.NTSB DCA00WA018Incident · No injuriesForeign investigationBoeing 737-3K2 · Amsterdam, NetherlandsNTSB MIA00LA063Accident · No injuriesLimited investigationFinal reportCessna 550 · Homestead, FLAn inadvertent in-flight collision with a bird in cruise flight resulting in substantial damage to the airplane.NTSB ATL00FA019Accident · 2 fatalField investigationFinal reportBellanca BL-17-30A · Monteagle, TNThe pilot's failure to adequately evaluate weather conditions that resulted in the continuation of visual flight into instrument weather conditions and the subsequent collision with trees.NTSB MIA00WA062Accident · No injuriesForeign investigationBeech 99A · St. Barthelemy, WNNTSB LAX00LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fallbrook, CAthe pilot's misjudged altitude and distance during a night landing approach, which resulted in an undershoot.NTSB DEN00LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Brighton, COThe pilot's not following preflight procedures, the starvation of fuel to the engine, and the lack of suitable terrain for a forced landing.NTSB CHI00LA054Accident · Minor injuriesLimited investigationFinal reportAerostar S49A · Flandreau, SDThe pilot's inadequate compensation for wind conditions, and the burner becoming disconnected from the balloon's frame. A contributing factor was the high wind condition.NTSB SEA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182S · Kennewick, WAThe pilot's decision to continue flight into known icing conditions, and his subsequent failure to maintain adequate airspeed on final approach, resulting in a hard landing. Factors included: icing conditions; the pilot's improper decision to continue to his…NTSB LAX00LA066Accident · No injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The pilot's decision to takeoff downwind and the subsequent failure to achieve translational lift before contact with the water.NTSB DEN00LA034Accident · Minor injuriesLimited investigationFinal reportPrice Glasair 1-RG · Ruidoso, NMThe failure of the pilot to perform an adequate preflight, and the subsequent partial power loss as a result of water contamination in the fuel. A factor was the lack of suitable terrain for a forced landing.NTSB NYC00LA060Accident · No injuriesLimited investigationFinal reportBeech C-23 · Manassas, VAThe pilot's inadequate remedial action to recover the airplane from porpoising during the landing roll out.NTSB ATL00LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Oakland, ALThe pilot's failure to verify that his seat was locked prior to takeoff. The subsequent bounce on takeoff enabled the seat to shift aft thereby reducing the pilot's access to controls leading to the inadvertent loss of control and ground impact with trees.…NTSB LAX00FA061Accident · Serious injuriesField investigationFinal reportAerospatiale AS-350D · Avalon, CAA loose pneumatic fitting caused the engine to go to flight idle power at a low altitude, which resulted in a forced landing in hilly terrain.NTSB FTW00LA055Accident · No injuriesLimited investigationFinal reportCessna 172L · New Orleans, LAThe pilot's inadvertent starting of the engine. Factors were the pilot's failure to set the mixture control to the off position, and the intermittent short in the starter switch.NTSB CHI00LA052Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Indianola, IAloss of engine power for undetermined reason. A factor relating to this accident was the tree.NTSB SEA00LA035Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jordan Valley, ORInadequate preflight planning/preparation. Unsuitable terrain was selected for landing and a road sign were factors.NTSB FTW00LA054Accident · No injuriesLimited investigationFinal reportCessna 150H · Sinton, TXThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00FA053Accident · 1 fatalField investigationFinal reportMooney M20K · Mcalester, OKThe pilot's failure to maintain aircraft control. Factors were the pilot's impairment (drugs), the deployed right speed brake, and the night conditions.NTSB LAX00LA064Accident · No injuriesLimited investigationFinal reportBeech 65-80 · Mesa, AZThe collapse of a main landing gear due to damage from a hard landing at an undetermined time.NTSB LAX00LA059Accident · Minor injuriesLimited investigationFinal reportQuest II Walsh Aventura II · Antioch, CAThe pilot's inattention to the fact that he had failed to retract the landing gear wheels prior to performing a water landing.NTSB LAX00LA058Accident · No injuriesLimited investigationFinal reportO'Hara Bob Bakeng Duce · Carson City, NVThe pilot's misjudged distance/altitude during final approach to landing, which led to an undershoot and subsequent collision with obstacles.NTSB LAX00LA057Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Gualala, CAThe student pilot's failure to attain and maintain an adequate airspeed, which resulted in a stall/mush and a collision with the ground.NTSB LAX00LA056Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Oxnard, CAThe pilot's inadequate compensation for the variable crosswind condition and subsequent failure to maintain directional control of the airplane.NTSB IAD00LA014Accident · Minor injuriesLimited investigationFinal reportPrudhomme Velocity RG 173 · Richmond, VAthe improper installation of the oil supply line to the propeller governor which resulted in a loss of lubrication, overtemperature, and a loss of engine power.NTSB CHI00FA050Accident · No injuriesField investigationFinal reportIsrael Aircraft Industries 1124A · Milwaukee, WIThe failure of the first stage pressure reducer in the oxygen regulator assembly.NTSB NYC00LA061Accident · Minor injuriesLimited investigationFinal reportZielke RV-4 · Florence, NJFailure of one of the propeller blades. A factor was the necessity land across, rather than in alignment with, the furrowed terrain due to the nature of the emergency.NTSB DEN00LA031Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · San Luis, COThe pilot's inadequate in-flight decision, and the subsequent inadvertent stall/mush. Factors were the pilot's lack of total experience in mountain flying, the high density altitude, and downdraft weather conditions.NTSB CHI00LA056Accident · No injuriesLimited investigationFinal reportCessna 210 · South Lyon, MIthe failure of the throttle and the unsuitable terrain encountered by the pilot in the taxi area. Factors were the collapsed nose gear and the rough terrain,NTSB CHI00LA051Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Orleans, NEthe pilot's failure to maintain adequate clearance from the power line. The power line was a factor.NTSB DEN00IA032Incident · No injuriesIncident investigationFinal reportBoeing 737-347 · Salt Lake City, UTImproper assembly of the wheel during build up in the operator's maintenance facilities.NTSB CHI00LA055Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Mokane, MOfuel starvation due to the pilot's failure to make accurate fuel consumption calculations and the pilot's improper emergency procedures for engine re-start. A factor was the ditch.NTSB ANC00LA021Accident · Minor injuriesLimited investigationFinal reportCessna T207A · Bethel, AKThe pilot's failure to remove frost from the airplane prior to flight, and an inadvertent stall/mush.