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 DFW05CA220Accident · No injuriesData collectionFinal reportRobinson R-44 · Odessa, TXThe pilot's failure to maintain main rotor RPM and the improper landing flare which resulted in a hard landing.NTSB ATL05WA152Accident · 4 fatalForeign investigationCessna 172 · Simplon, SwitzerlandNTSB ANC05LA129Accident · Minor injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 MK.1 · Aleknagik, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control during the takeoff roll, and an encounter with high vegetation and a river bank. Factors associated with the accident are high vegetation and a riverbank.NTSB SEA05LA179Accident · No injuriesLimited investigationFinal reportAmerican Champion 7KCAB · Richland, WAThe oil pressure gauge line fitting coming loose from the engine, resulting in the loss of oil to the point where internal engine components were starved for oil, leading to extensive internal damage and seizing of the engine. Factors include a set of eight…NTSB MIA05CA153Accident · Minor injuriesData collectionFinal reportCessna 152 · Sanford, FLThe student pilot's loss of aircraft control during the landing flare and touchdown resulting in the wing contacting the runway and the airplane nosing over.NTSB LAX05CA276Accident · No injuriesData collectionFinal reportCessna 172N · Ramona, CAthe pilot's failure to maintain directional control during landing.NTSB IAD05FA125Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · West Chester, PAThe pilot's improper decision to abort the landing after the airplane contacted the runway. A factor in the accident was the pilot's failure to ensure the landing gear was extended during the landing.NTSB ATL05CA151Accident · Minor injuriesData collectionFinal reportPiper PA-18-105 · N. Myrtle Beach, SCThe loss of engine power due to the pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice.NTSB ANC05LA128Accident · No injuriesLimited investigationFinal reportGardner SR3500 · Anchorage, AKThe malfunction of the propeller reversing system during landing, which allowed the propeller to reverse pitch in-flight, resulting in an uncontrolled descent and impact with terrain.NTSB NYC05CA135Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Hancock, NYThe pilot's inadequate compensation for wind conditions, which resulted in the airplane impacting the ground. A factor in the accident was the downdraft wind condition, as reported by the pilot.NTSB LAX05CA274Accident · No injuriesData collectionFinal reportBeech A36 · Healdsburg, CAthe pilot's failure to maintain lateral aircraft control during takeoff.NTSB IAD05CA124Accident · No injuriesData collectionFinal reportCessna 421C · Readington, NJAn encounter with animals during the landing - flare/touchdown.NTSB DFW05CA219Accident · No injuriesData collectionFinal reportCessna 172R · Springtown, TXThe pilot's improper decision to shut down the engine. Contributing factors were the failure of the oil pressure switch and the lack of a suitable landing area.NTSB CHI05LA237Accident · 1 fatalLimited investigationFinal reportKircher RV-8 · Menomonie, WIThe pilot's decision to perform an aerobatic roll during takeoff, the low altitude, and his failure to maintain clearance from the crops and terrain.NTSB CHI05CA236Accident · No injuriesData collectionFinal reportYamokoski Glastar · Marcellus, MIThe in-flight loss of engine power during cruise for undetermined reasons and the unsuitable terrain the pilot encountered during the forced landing. A factor was the tall corn he encountered.NTSB ATL05LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Colquitt, GAThe pilot's failure to maintain visual lookout and clearance from obstacles while maneuvering at low altitude, which resulted in an in-flight collision with a tree and subsequent uncontrolled descent into the ground.NTSB ANC05LA125Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Skwentna, AKThe pilot's misjudged distance/altitude on final approach, which resulted in a noseover following an undershoot and in-flight collision with rough/uneven terrain. A factor associated with the accident was the rough/uneven terrain.NTSB SEA05WA178Accident · 2 fatalForeign investigationVans RV-6 · Nadrybie Dwor, PolandNTSB SEA05LA177Accident · Serious injuriesLimited investigationFinal reportTichacek N-3 Pup · Mead, WAThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB SEA05LA176Accident · Minor injuriesLimited investigationFinal reportAlon A-2A · Helena, MTThe loss of engine power for undetermined reasons, which resulted in a forced landing and nose over. A factor contributing to the accident was the ground bordering the runway pavement.NTSB SEA05CA175Accident · No injuriesData collectionFinal reportCessna 150J · Roseburg, ORThe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate in-flight planning and failure to refuel the airplane. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA05FA152Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Freeport, FLThe failure of the pilot to maintain airspeed resulting in inadvertent stall, uncontrolled descent, and in-flight collision with terrain.NTSB MIA05CA151Accident · No injuriesData collectionFinal reportCessna 177B · Olive Branch, MSThe failure of the pilot to maintain directional control during the landing roll resulting in an on ground collision with a runway light and subsequent collapse of the nose landing gear.NTSB LAX05LA273Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Palos Verdes, CAa loss of engine power due to the cyclic fatigue failure and separation of the number 4 piston.NTSB LAX05LA272Accident · 1 fatalLimited investigationFinal reportPatch Dan F Varieze · San Diego, CAa divergence from the final approach course and an in-flight collision with storage containers for undetermined reasons.NTSB DFW05CA218Accident · No injuriesData collectionFinal reportCessna 152 · Bridgeport, TXThe pilot's inadequate compensation for wind conditions, and the flight instructor's delayed remedial action during a crosswind landing resulting in a loss of directional control.NTSB CHI05LA238Accident · No injuriesLimited investigationFinal reportBoeing 757-33N · Chicago, ILThe flightcrew's failure to maintain clearance from a fence while taxiing.NTSB CHI05CA241Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Brodhead, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the vehicle the airplane contacted.NTSB CHI05CA240Accident · No injuriesData collectionFinal reportPiper PA-12 · Boscobel, WIThe separation of the right main landing gear attachment bracket bolt during the landing and the pilot's aircraft control not possible with the collapsed gear.NTSB CHI05CA239Accident · No injuriesData collectionFinal reportBeech 36 · Holland, MIThe failure of the pilot to extend the landing gear prior to landing. A factor to the accident was the pilot becoming distracted by his passengers during landing.NTSB ATL05CA150Accident · No injuriesData collectionFinal reportMaule M4-210C · OCRACOKE iSLAND, NCThe pilot's inadequate compensation for winds and his failure to maintain directional control during a crosswind landing, which resulted in an on-ground collision with trees. A factor was the crosswind condition.NTSB ANC05TA126Accident · No injuriesFinal reportPiper PA-18-150 · Cold Foot, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing down during the landing roll. A factor associated with the accident was the rough and uneven terrain.NTSB ANC05CA124Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Chickaloon, AKThe pilot's misjudged distance and altitude on final approach to land, which resulted in an undershoot and structural damage to the airplane. A factor associated with the accident was a downdraft.NTSB DFW05IA222Incident · No injuriesIncident investigationFinal reportAir Tractor AT-401 · Winnie, TXThe loss of engine power due to the failure of the second-stage turbine wheel as a result of low cycle fatigue.NTSB DFW05CA223Accident · Serious injuriesData collectionFinal reportAerostar International RX-8 · Denton, TXThe passenger's failure to follow landing instructions, which resulted in serious injury. A contributing factor was the high wind.NTSB DEN05FA128Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Vail, COthe pilot's improper in-flight planning and decision making and failure to maintain clearance from the terrain. Contributing factors include the pilot's attempt to takeoff from the highway, high density altitude, the downdrafts, and the sign.NTSB DCA08WA012Accident · No injuriesForeign investigationBoeing MD-82 · Jakarta, IndonesiaNTSB DCA05MA095Accident · Minor injuriesMajor investigationFinal reportBoeing 747-200 · Aganathe flight crews' failure to verify that the number of landing gear annunciations on the second officer’s panel was consistent with the number specified in the abnormal/emergency procedures checklist, which led to a landing with the nose gear retracted.NTSB LAX05FA271Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Pomona, CAA loss of engine power during the landing approach due to fuel starvation caused by debris and corrosion in the carburetor assembly. A factor contributing to the accident was the failure of the owner to comply with the manufacturer's service bulletin…NTSB IAD05LA123Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Smoketown, PAA loss of engine power during the climb for undetermined reasons, resulting in a forced landing.NTSB DFW05FA217Accident · 2 fatalField investigationFinal reportBell 206B · Gulf of MexicoThe loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel calculations.NTSB DFW05CA213Accident · No injuriesData collectionFinal reportBell 206L · Gulf of MexicoThe pilot's failure to maintain clearance with a stationary object while landing.NTSB DEN05LA127Accident · No injuriesLimited investigationFinal reportCessna 172N · Cedar City, UTthe loss of engine power for reasons undetermined. Contributing factors include the lack of suitable terrain for a forced landing, and the soft dirt.NTSB DEN05CA129Accident · No injuriesData collectionFinal reportPiper PA-18A-135 · Cedaredge, COthe pilot's failure to maintain aircraft control, and the pilot's improper in-flight planning. Contributing to the accident was the wind shift, resultant tailwind, and the inadvertent stall.NTSB ATL05FA148Accident · 2 fatalField investigationFinal reportBeech A36 · Jamestown, TNThe pilot's decision to continue flight into an area of known thunderstorm activity, which resulted in loss of aircraft control and collision with trees and the ground during the result uncontrolled descent.NTSB ATL05FA145Accident · 1 fatalField investigationFinal reportCessna 310R · Apopka, FLThe pilot's failure to maintain adequate visual lookout and object clearance, which resulted in the in-flight collision with trees.NTSB ATL05CA147Accident · Minor injuriesData collectionFinal reportCessna 172G · Ridgeland, SCThe loss of engine power for undertermined reasons which resulted in a collision with objects.NTSB SEA05LA172Accident · 2 fatalLimited investigationFinal reportMK II Legacy Sport · Madras, ORThe pilot's failure to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall/spin and subsequent collision with the ground.NTSB SEA05CA173Accident · No injuriesData collectionFinal reportHughes 369E · Donnelly, IDThe pilot's failure to maintain clearance of a tree during a landing attempt due to loss of visibility from a self induced brown-out condition. Contributing factors were the pilot's failure to identify a hazardous landing site, and the tree.NTSB DFW05CA231Accident · No injuriesData collectionFinal reportBell 47 · Monette, ARThe loss of control as result of a loss of hydraulic pressure for undetermined reasons.