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 LAX96LA142Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DC-65 · Fremont, CAthe in-flight separation of a portion of one wooden propeller blade due to undetected dry rot in the wood fibers.NTSB LAX96LA141Accident · Minor injuriesLimited investigationFinal reportScheperle Mustang II MOD · Merced, CAa loss of engine power due to a malfunctioning thermostat valve in the liquid cooling system.NTSB IAD96LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Roanoke, VAloss of engine power for undetermined reason(s). Darkness and the pilot's improper emergency procedures were related factors.NTSB FTW96LA157Accident · Serious injuriesLimited investigationFinal reportBoeing B-757-222 · Taos, NMan encounter with unforecasted clear air turbulence.NTSB FTW96LA153Accident · No injuriesLimited investigationFinal reportCessna 172N · Rockwall, TXthe pilot's inadequate compensation for the wind conditions. A factor was the gusty wind condition.NTSB CHI96LA115Accident · 1 fatalLimited investigationFinal reportCessna 182H · East Jordan, MIthe pilot's failure to maintain clearance with the terrain during the landing. Factors related to the accident were the snow covered ice pile at the end of the runway and the pilot's perception of the height of the pile.NTSB CHI96LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Lambertville, MIFailure of the student pilot to maintain directional control of the airplane during the takeoff roll. The snowbank was a related factor.NTSB ATL96LA069Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Nashville, TNthe failure of the pilot of the Piper PA-28, N26046, to visually clear the intended taxi course.NTSB ANC96LA037Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cantwell, AKThe undetermined loss of engine power and lack of suitable terrain to make a forced landing.NTSB MIA96LA105Accident · No injuriesLimited investigationFinal reportCessna 172N · New Smyrna Bch, FLThe student pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise, and subsequent overload failure of the nose gear.NTSB MIA96LA103Accident · No injuriesLimited investigationFinal reportRobinson R-22-BETA · Bunnell, FLthe flight instructor's failure to properly supervise the dual student and take corrective action before control was lost. Contributing to the accident was the dual student's overcontrol of the helicopter during hover.NTSB LAX96LA138Accident · Minor injuriesLimited investigationFinal reportBeech E33A · Mesquite, NVthe pilot's poor judgment in attempting to take off in the existing wind conditions.NTSB LAX96FA140Accident · 2 fatalField investigationFinal reportSchweizer 269C · Ontario, CAThe pilot's decision to attempt a VFR descent into instrument meteorological conditions resulting in spatial disorientation.NTSB LAX96FA139Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Moreno Valley, CAVFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC). The terrain and adverse weather conditions were related factors.NTSB FTW96LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Fredericksburg, TXfailure of the pilot to maintain adequate airspeed during the approach and go-around, which resulted in a stall and subsequent collision with the ground. Factors relating to the accident were: the high, gusty, crosswind conditions, and the pilot's lack of…NTSB CHI96FA133Accident · 1 fatalField investigationFinal reportBeech F-33A · Prairie City, SDthe pilot's failure to maintain control of the airplane. A factor was pilot fatigue.NTSB CHI96FA116Accident · 1 fatalField investigationFinal reportCirrus VK30 · Duluth, MNthe inadequate handling/performance design capabilities of the airplane which resulted in the inability to recover from an aft center of gravity spin. Factors were the lack of any antispin or deep stall recovery devices, and the aft center of gravity.NTSB ANC96LA036Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Chugiak, AKthe pilot's selection of an unsuitable area for landing.NTSB MIA96LA108Accident · No injuriesLimited investigationFinal reportBoeing 737-200 · Jacksonville, FLfailure of the nose gear taxi light support bracket due to in service damage, which resulted in debris being ingested by the engines. Contributing to the accident was the failure of company maintenance personnel to comply with a Grimes Service Bulletin and a…NTSB FTW96FA151Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · New Orleans, LAThe in-flight loss of a bolt in the elevator control system due to improper installation by unknown person(s), which resulted in a disconnection of the elevator control system that rendered the airplane uncontrollable.NTSB ATL96LA068Accident · No injuriesLimited investigationFinal reportBell 205A-1 · Grove Hill, ALfatigue failure of the vertical fin forward spar in an area that was not accessible to inspection. A factor relating to the accident was: guidance for inspection of the area (where the fatigue occurred) was insufficiently defined by the manufacturer.NTSB SEA96FA071Accident · Minor injuriesField investigationFinal reportCessna U206E · Renton, WAthe pilot's initiation of a flight with a known disqualifying heart condition, and his subsequent inflight incapacitation from a heart attack. A factor relating to the accident was: the inability of the non-rated passenger (unqualified person) to attain a…NTSB IAD96LA052Accident · No injuriesLimited investigationFinal reportDouglas DC-8-62 · Wilmington, OHThe pilot-in-command's inadequate visual lookout and the company/operator's inadequate crew/group coordination and communication during taxi and snow removal operations. Related factors were the snowy weather conditions affecting visibility and the snowplow…NTSB CHI96LA118Accident · No injuriesLimited investigationFinal reportCessna 310R · Marshfield, WIthe failure of the pilot of the PA-32R, N1030Q, to obtain identification of the Cessna 310R, N1835E, visually, and his inadequate visual outlook. A factor was the failure of both pilots to hear communications from each other.NTSB SEA96LA070Accident · Minor injuriesLimited investigationFinal reportBell 206B · La Grande, ORthe pilot's failure to maintain clearance with trees after pulling up from an aerial application spray run.NTSB IAD96FA050Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Marion, VAthe pilot's failure to maintain adequate altitude/clearance during the instrument approach (FAF/Outer Marker to Threshold IFR), which resulted in the in-flight collision with trees. A related factor was the foggy weather conditions.NTSB CHI96IA109Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Detroit, MIa defective diode in the number two stabilizer actuator that produced an intermittent loss of electrical motor power during transient, closed loop control of the actuator. A factor was the intermittent open circuit in the elevator servo controller…NTSB NYC96WA076Accident · Minor injuriesForeign investigationBritten-Norman BN2A-21 · IcelandNTSB MIA96LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLthe pilot misjudged the clearance between the fuel trucks.NTSB MIA96LA101Accident · No injuriesLimited investigationFinal reportSummerfeldt Thorp T-18 · Hampton, SCThe pilot's improper planning/decision and selection of unsuitable terrain for a precautionary landing. Factors relating to the accident were: the pilot's failure to use a preflight briefing service, the adverse weather conditions, and soft terrain in the…NTSB MIA96FA100Accident · 5 fatalField investigationFinal reportCessna U206G · Key West, FLThe pilot's improper decision to continue the flight rather than making an immediate water landing due to the low altitude of the airplane and obstructions ahead, which led to his intentional maneuver to avoid the obstructions and subsequent inadvertent stall…NTSB LAX96LA137Accident · 1 fatalLimited investigationFinal reportBumford GR-7 · Temecula, CAfailure of the pilot to maintain control of the airplane, while performing an aerobatic maneuver, which resulted in inadvertent entry into a spin. Factors relating to the accident were: the pilot's lack of recent experience in fixed wing aircraft, his lack of…NTSB IAD96LA051Accident · No injuriesLimited investigationFinal reportMulholland Witchawk · Celina, OHthe pilot's selection of unsuitable terrain for a precautionary landing.NTSB CHI96LA112Accident · No injuriesLimited investigationFinal reportCessna 150 · Howard, KSthe student pilot's failure to obtain timely assistance after encountering adverse weather during a cross-country flight which led to fuel exhaustion.NTSB ATL96LA067Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Kingston, TNThe pilot's inadequate pre-flight inspection, which resulted in fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB ANC96LA035Accident · No injuriesLimited investigationFinal reportCessna 206 · Willow, AKthe pilot's selection of unsuitable terrain for landing. Snow covered terrain that concealed uneven terrain was a factor in the accident.NTSB SEA96LA069Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Sunriver, ORthe pilot's failure to maintain directional control during the landing rollout. A factor contributing to the accident was the presence of a tree near the edge of the runway.NTSB FTW96LA150Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Salado, TXthe pilot's failure to maintain altitude/clearance from the power line.NTSB FTW96LA149Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Killeen, TXThe pilot's improper planning/decision, which resulted in fuel exhaustion and a loss of engine power, due to an inadequate supply of fuel. A factor relating to the accident was: lack of suitable terrain for an emergency landing (autorotation).NTSB CHI96LA110Accident · No injuriesLimited investigationFinal reportYakovlev YAK C-11 · North Vernon, INFailure of the pilot to maintain adequate airspeed during an aborted landing, which resulted in an inadvertent stall.NTSB ANC96LA034Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's improper use of the brakes during landing. The snow berm along the edge of the runway was a factor.NTSB MIA96FA099Accident · 1 fatalField investigationFinal reportBeech A23A · Sarasota, FLThe pilot's failure to maintain airspeed while maneuvering (VSO) resulting in an inadvertent in-flight loss of control (stall/spin) and subsequent in-flight collision with terrain.NTSB FTW96LA148Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Texarkana, ARa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96LA111Accident · No injuriesLimited investigationFinal reportCessna 140 · Ulysses, KSFailure of the pilot to maintain directional control of the airplane during the takeoff roll, and his improper use of brakes and elevator control, while aborting the takeoff. A factor relating to the accident was the gusty wind condition.NTSB CHI96LA108Accident · 1 fatalLimited investigationFinal reportBishop-Christian Eagle II · Cambridge, INthe pilot allowed the airplane to enter a flat spin, while performing an acrobatic maneuver, and was unable to recover before ground impact. Factors relating to the accident were: the pilot's overconfidence in his personal ability, and his lack of familiarity…NTSB CHI96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · St. Paul, MNthe pilot's failure to assure an adequate fuel supply for the flight which resulted in fuel exhaustion. A factor associated with the accident was the signs contacted by the airplane during the forced landing.NTSB ATL96FA066Accident · 1 fatalField investigationFinal reportCessna 310R · Winder, GAThe pilot's failure to maintain visual flight conditions which resulted in the loss of control and subsequent inflight breakup of the airplane when he exceeded the design stress limits of the airframe.NTSB LAX96LA135Accident · No injuriesLimited investigationFinal reportBurkhart Grob G102 · Minden, NVthe pilot's misjudgment of distance and altitude from the airport, which resulted in an off-airport forced landing.NTSB LAX96LA134Accident · No injuriesLimited investigationFinal reportCessna 172L · Napa, CAthe failure of both pilots to see and avoid the other aircraft, and the failure of the pilot of the Cessna 172L, N7668G, to follow VFR procedures by not yielding the right of way to the Cessna 172M, N20858, which was already established in the traffic pattern.NTSB IAD96LA049Accident · Minor injuriesLimited investigationFinal reportKitfox IV-1200 · Saluda, VAa partial loss of engine power due to spark plug failure, and the pilot's evasive maneuver to avoid lights at the end of the runway.