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 CHI90LA037Accident · No injuriesLimited investigationFinal reportCessna 172G · Savoy, ILImproper planning/decision by the pilot, which resulted in his inability to maintain control of the aircraft. A factor related to the accident was: the adverse wind condition.NTSB MIA90FA033Accident · 2 fatalField investigationFinal reportPiper Aerostar 601P · Orlando, FLLoss of aircraft control during takeoff for an unknown reason which resulted in a collision with the ground.NTSB CHI90LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Millbury, OHFailure of the pilot to properly secure the aircraft and/or adequately brief the passenger (student pilot), and inadvertent bumping of the throttle by the passenger.NTSB CHI90DEP02Accident · Serious injuriesFinal reportRotec Panther 2+ · Holmen, WIInadvertent partial deployment of the emergency ballistic recovery parachute resulting in a loss of engine thrust and aerodynamic control of the aircraft.NTSB CHI90DEE02Accident · Serious injuriesFinal reportEdward Avid Flyer C · Lansing Arpt, ILPilot's failure to attain proper runway alignment prior to touchdown. A factor in the accident was the builder's improper modification of the carburetors.NTSB MKC90LA037Accident · No injuriesLimited investigationFinal reportSaint Louis YPT-15 · Creve Coeur, MOThe pilot's failure to maintain directional control of the airplane. Contribuiting to the accident was the sun glare.NTSB FTW90GA040Accident · Serious injuriesFinal reportAerospatiale AS-350B · Liberty Hill, TXUndetermined.NTSB CHI90LA035Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Barron, WIImproper use of the carburetor heat by the pilot and subsequent carburetor ice. Contributing factors were: carburetor icing conditions, slick (wet/snow covered) runway, and trees/brush near the departure end of the runway.NTSB ATL90LA036Accident · No injuriesLimited investigationFinal reportCessna 550 · Covington, KYFailure of the pilot-in-command (PIC) to extend the landing gear and inadequate monitoring by the check pilot, which resulted in a wheels-up landing.NTSB SEA90LA025Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Raymond, WALoss of engine power due to fatigue failure of the impeller. The helicopter was substantially damaged as a result of a roll-over on uneven terrain.NTSB SEA90LA024Accident · No injuriesLimited investigationFinal reportCessna A-185-F · Seattle, WAThe pilot did not maintain directional control of the airplane during the landing roll.NTSB SEA90LA023Accident · No injuriesLimited investigationFinal reportHughes 369D · Stayton, ORThe maintenance personnel failed to record the previous flight time for the overrunning clutch on airworthiness certification documents when the assembly was overhauled. Also, causal to the accident was the operation of the aircraft by the operator for 175…NTSB ATL90IA033Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Atlanta, GAInadequate maintenance and inspection by the operator.NTSB NYC90FA036Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Coventry, CTThe non-instrument rated pilot initiating VFR flight into IMC on a dark night which resulted in spatial disorientation and uncontrolled flight into the ground. Contributing factor(s) was: the adverse weather existing at the time of the accident and the…NTSB DEN90FA028Accident · 1 fatalField investigationFinal reportAerospatiale SA316B · Park City, UTFailure of the pilot to make a vertical takeoff, while departing with a cable attached, and his failure to insure the cable remained clear of the trailer. The trailer (vehicle) was a contributing factor.NTSB DCA90MA010Accident · 8 fatalMajor investigationFinal reportBritten-Norman BN-2 · Block Island, RIThe aircraft crashed for an undetermined reason, during an overwater flight on a dark (moonless) night under a cloud layer. A SIGMET was in effect warning of moderate to occasionally severe turbulence below 6000 feet and the potential of low level wind shear.NTSB BFO90LA014Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Chesapeake, VAThe pilot misjudged distance and altitude to the runway, while on final approach to land. The light condition at dusk was a related factor.NTSB NYC90LA035Accident · No injuriesLimited investigationFinal reportBeech B-23 · Tinton Falls, NJPrecautionary landing in unsuitable terrain following a partial power loss due to a failed exhaust valve.NTSB MIA90LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Cocoa, FLFailure of the pilot to maintain directional control during the landing roll, which resulted in an inadvertent ground swerve. Factors related to the accident were the crosswind condition and ditch.NTSB FTW90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Cresson, TXThe failure of the student pilot to maintain directional control of the airplane and the cfi's inability to regain control. Contributing to the accident was the lack of brakes on the cfi's side of the airplane.NTSB FTW90LA036Accident · No injuriesLimited investigationFinal reportCessna 150 · Fort Worth, TXFuel exhaustion due to the inadequate in-flight planning/decision by the plt. A factor in this was the improper initial training by the flight instructor.NTSB FTW90DRA01Accident · Minor injuriesFinal reportCessna A188B · Muldoon, TXA total power loss due to water contamination in the fuel. A factor was the pilot's inadequate preflight inspection.NTSB DEN90FA027Accident · Serious injuriesField investigationFinal reportPiper PA-46P-350 · Des Moines, IALoss of engine power for undetermined reason(s). The light conditions (dusk) and trees in in the emergency landing area were considered to be contributing factors.NTSB SEA90LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Boulder City, NVThe pilot did not attain proper alignment with the runway. Contributing to the accident was the ditch and the pilot's diverted attention.NTSB NYC90LA033Accident · No injuriesLimited investigationFinal reportCessna 150 · Westfield, MALoss of control during landing due to an improper flare and recovery from a bounced landing. A factor relating to the accident was the lack of total experience of the student pilot.NTSB MIA90IA036Incident · No injuriesIncident investigationFinal reportWaco UPF-7 · Key West, FLThe failure of the pilot to adequately watch for parked aircraft after becoming distracted.NTSB MIA90FA031Accident · 2 fatalField investigationFinal reportCessna 170A · Rogersville, TNContinued flight into instrument meteorological conditions by a non-instrument rated pilot resulting in spatial disorientation and a loss of aircraft control. Factors contributing to the accident were: the pilot's overconfidence in his ability to fly in…NTSB LAX90DUG02Accident · Serious injuriesFinal reportWittman Tailwind W-8 · Chino, CAA loss of engine power for undetermined reasons.NTSB CHI90LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIFailure of the student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the student's lack of total experience, his diversion of too much attention to…NTSB CHI90DEE03Accident · 1 fatalFinal reportNelsen-David Sonerai II/EV · Huntley, ILPilot-in-command's failure to maintain airspeed during a turn at low altitude, resulting in an inadvertent stall and impact with terrain, lack of recent total experience and lack of total experience in type of aircraft.NTSB ATL90LA032Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · New Bern, NCThe failure of the instructor pilot to ensure that the engine fuel selector valves were properly positioned prior to takeoff, which led to fuel starvation and a loss of engine power during takeoff.NTSB NYC90LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Dunkirk, NYPilot in command failed to maintain airspeed during a forced landing resulting in a stall and hard landing after a engine power failure due to carburetor ice and improper use of the carburetor heat control by the pilot.NTSB LAX90LA041Accident · Serious injuriesLimited investigationFinal reportBarnes AX-7 · Sun City, AZInadequate visual lookout by the student pilot (his failure to see & avoid). The transmission line and the student's lack of familiarity with the area were related factors.NTSB LAX90LA040Accident · No injuriesLimited investigationFinal reportCessna 150 · Santa Ynez, CAThe student pilot's loss of directional control during a go-around.NTSB FTW90LA035Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Crosbyton, TXImproper overhaul of the aircraft engine by maintenance personnel that led to the complete loss of engine oil due to an undertorqued oil cooler assembly. Factors in the accident were the failure of maintenance personnel to detect the condition during the…NTSB FTW90LA034Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Shawnee, OKFailure of the pilot to maintain adequate airspeed during the turn after takeoff, which resulted in a stall. The obstructions (trees) were a factor.NTSB FTW90DPJ02Accident · 1 fatalFinal reportLogan, B.A. Windrose · Norman, OKThe inadvertent stall and the pilot's improper emergency recovery procedures. A factor was the power loss for undetermined reasons.NTSB DEN90LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Steamboat Spgs, COContinued VFR flight by the pilot into instrument meteorological conditions (IMC) and his delay in diverting or reversing course. The terrain, weather conditions, wing ice, and trees were considered to be contributing factors.NTSB CHI90LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Freeport, ILThe pilot-in-command's failure to properly judge the clearance between his airplane and a parked vehicle.NTSB ATL90LA030Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B1 · Ewell, ALThe loss of engine power, for undetermined reasons, at low altitude during a practice autorotation. Contributing to the accident was the instructor's failure to properly plan the demonstrated autorotation so as to preclude an accident, in the event that power…NTSB ATL90FA031Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Helen, GAThe pilot's failure to properly preflight and plan en route refueling stops. The airplane collided with trees during the emergency descent.NTSB ANC90LA015Accident · No injuriesLimited investigationFinal reportCessna 170B · Chugiak, AKThe student pilot's improper planning/decision and his delay in initiating a go-around. Contributing factors were: the student's overconfidence in his personal abilities, his selection of the wrong runway, the resultant tailwind, and icy runway conditions.NTSB ANC90LA014Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Eek, AKThe pilot's inadequate preflight planning/preparation and his failure to assure the removal of ice or frost from the wings. The excess gross weight and uneven terrain were considered to be contributing factors.NTSB MKC90LA035Accident · No injuriesLimited investigationFinal reportCessna 180 · St. Louis, MOThe pilot's failure to adequately compensate for the wind. The gusty, crosswind condition is considered a contributing factor to the accident.NTSB MKC90LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Wichita, KSFuel exhaustion due to poor planning and the pilot's failure to refuel the aircraft.NTSB FTW90FA032Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Arlington, TXThe pilot-in-command's loss of control in flight because of spatial disorientation. A factor was the dark night.NTSB DEN90DTE02Accident · 2 fatalFinal reportBruce Mckinney VARI-EZE · Aspen, COThe pilot's failure to refuel the airplane, which resulted in fuel exhaustion. A related factor to the accident was: the mountainous terrain.NTSB DEN90DTE01Accident · 1 fatalFinal reportLanier Thorp T-18 · Colorado City, COLoss of engine power with carbon fouling of the spark plugs, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB SEA90FA021Accident · 2 fatalField investigationFinal reportBeech B35 · Bremerton, WAThe pilot's improper IFR procedure, his failure to maintain proper alignment on the ILS approach, and his failure to initiate a missed approached after reaching the lateral limits of the ILS system or decision height. Darkness and deteriorating weather were…NTSB NYC90LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Johnstown, PAFailure of the pilot to maintain proper airspeed and altitude on an ILS final approach, which allowed the aircraft to descend below the glide path and collide with approach lighting. Factors related to the accident were: darkness, adverse weather conditions,…