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 LAX90LA241Accident · No injuriesLimited investigationFinal reportCessna 152 · Fullerton, CAThe warped condition of the engine valves and valve seats due to excessive and repeated thermal shock cycles.NTSB LAX90FA235Accident · 3 fatalField investigationFinal reportCessna 177 · Lake Havasu, AZThe pilot's inflight loss of control due to failure to maintain adequate airspeed. Contributing to the accident was the high density altitude, overweight airplane, and the pilot's alcohol level.NTSB FTW90LA130Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · San Antonio, TXPilot's failure to maintain adequate speed. Contributing to the accident was the momentary power loss.NTSB FTW90DRG04Accident · No injuriesFinal reportAir Tractor AT-301 · Mission, TXThe pilot's failure to maintain proper clearance above the crops he was spraying. A factor was the tree induced mechanical turbulence encountered during the descending turn.NTSB DEN90LA151Accident · No injuriesLimited investigationFinal reportCessna 172XP · Tooele, UTThe flights encounter with turblence on final which resulted in a loss of control and a subsequent collision with the ground.NTSB CHI90DEC03Accident · Serious injuriesFinal reportMaxair MU532 · Troy, MIThe pilot's improper remedial action to regain directional control during the landing.NTSB ANC90LA108Accident · No injuriesLimited investigationFinal reportCessna 185 · King Salmon, AKTotal loss of engine power caused by the failure of the piston rod assemblies.NTSB ANC90FA105Accident · 2 fatalField investigationFinal reportCessna 185 · Iliamna, AKThe pilot's failure to follow proper procedures and directives (excessive flaps); failure to operate the airplane within the allowable gross weight limitations; improper compensation for wind conditions and failure to maintain minimum safe flying speed,…NTSB SEA90LA117Accident · No injuriesLimited investigationFinal reportDickey E-RACER · Jackpot, NVAn undetermined failure or anomaly of the exhaust system, which resulted in an in-flight fire of the fiberglass structure of the aircraft and failure of the aircraft braking system.NTSB NYC90LA142Accident · 1 fatalLimited investigationFinal reportNorth American AT-6 · Buffalo, NYLoss of control in flight due to physical impairment. Factors related to the accident were: the pilots use of an over the counter antihistamine.NTSB MKC90LA143Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Marshalltown, IAInadequate visual lookout and clearance not obtained.NTSB MKC90FA142Accident · Serious injuriesField investigationFinal reportCessna T210M · Kiowa, KSThe pilot's failure to maintain control of the airplane during takeoff.NTSB LAX90LA255Accident · No injuriesLimited investigationFinal reportPiper PA28-236 · S. Lake Tahoe, CAThe pilot's failure to maintain clearance between the aircraft and an obstruction along his ground taxi route. Obstructions along the route and a fence constructed near the ramp are factors in the accident.NTSB LAX90LA242Accident · No injuriesLimited investigationFinal reportCessna 340 · Salinas, CAThe failure of maintenance personnel to reinstall the landing gear retract/extension linkage and the failure of inspection personnel to detect the improper installation.NTSB LAX90LA239Accident · No injuriesLimited investigationFinal reportCessna 152 · Upland, CAThe student pilot not flaring for the touchdown.NTSB CHI90LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Millington, MIInadequate planning-decision, failure to obtain lift-off airspeed, and failure to perform an aborted takeoff. Factors related to the accident are the uphill sloping runway, soft turf, high grass, and complacency.NTSB CHI90DEM05Accident · 1 fatalFinal reportOo-Culley Osprey · Iron Mountain, MIJamming of the rudder cable between the pulley and the pulley support bracket and the pilot's continued operation of the airplane with a known deficiency.NTSB ATL90FA139Accident · 4 fatalField investigationFinal reportPiper PA-38-112 · Florence, ALFailure of the pilot-in-command of N2409K to maintain safe separation from N2437K during unauthorized formation maneuvering. Overconfidence in personal ability and the execution of unauthorized formation flight on the part of both pilots-in-command were…NTSB ANC90LA107Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Eielson Afb, AKThe cfi's failure to take timely action when the dual student did not attain a proper touch down point.NTSB ANC90LA106Accident · No injuriesLimited investigationFinal reportCessna 180K · Homer, AKThe pilot loss of directional control.NTSB SEA90FA115Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Glacier, WAPassenger did not follow the procedures associated with the operations in the vicinity of the helicopter.NTSB NYC90LA143Accident · 1 fatalLimited investigationFinal reportBoeing A75L3 · Groton, CTAn impact with the ground following an improperly executed roll with insufficient altitude for recovery. Factors related to the accident were improper use of the flight controls by the pilot.NTSB MIA90LA147Accident · No injuriesLimited investigationFinal reportCessna 150F · Pensacola, FLInstructor pilots failure to assure that the flaps were in the proper position for takeoff resulting in reduced climb performance. This resulted in the forced landing, during which, the airplane collided with a power line, stalled, then crashed to the ground.NTSB LAX90LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · El Cajon, CAThe pilot-in-command's failure to abort the landing after touchdown past the touchdown zone.NTSB LAX90DVG11Accident · Serious injuriesFinal reportGary Williams Avid Flyer · Redding, CAThe failure of the pilot to select the correct position of the fuel selector. Contributing to the accident was operation with a known dead battery.NTSB FTW90LA129Accident · No injuriesLimited investigationFinal reportPiper PA24-180 · Arlington, TXThe loss of engine power due to fuel starvation caused by the pilot in commands failure to select a tank with fuel and the improper lowering of flaps while performing a forced landing resulting in the aircraft landing short and colliding with a fence.NTSB FTW90FA126Accident · Minor injuriesField investigationFinal reportCessna C172 · Fort Worth, TXFailure of the pilot to follow published procedures when he elected to take-off with full flaps.NTSB DEN90FA149Accident · 2 fatalField investigationFinal reportTaylorcraft BC 12-D · Homedale, IDThe failure of the pilot to maintain adequate airspeed during maneuvers (buzzing) which resulted in an inadvertent stall of the aircraft. A factor was the intentional buzzing of family members.NTSB CHI90LA164Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Cornell, WIThe pilot's inadequate preflight resulted in a loss of engine power due to contamination in the fuel system.NTSB BFO90LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · S. Charleston, WVPilot's failure to maintain directional control of the airplane. A related factor crosswind conditions.NTSB ANC90LA104Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKA power loss due to a fatigue failure of the #5 exhaust rocker arm.NTSB ANC90LA103Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-3 · Beaver Village, AKMechanical failure of an exhaust rocker arm.NTSB ANC90LA102Accident · Minor injuriesLimited investigationFinal reportGrumman G21 · King Salmon, AKThe pilot failed to adequately compensate for the prevailing wind conditions and his failure to maintain directional control. A contributing factor was the strong crosswind component.NTSB SEA90LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Las Vegas, NVFuel exhaustion, due to the pilot's improper check of the fuel with a dipstick before takeoff, which resulted in an inadequate supply of fuel.NTSB NYC90LA141Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Lawrence, MAThe failure of the pilot to maintain control of the airplane with an open door. Factors related to the accident was the failure of the pilot to maintain airspeed and the door opening at liftoff.NTSB LAX90LA234Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Carlsbad, CAFailure of the pilot to maintain directional control at a hover.NTSB LAX90LA218Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82A · Sonoma, CAThe pilot failed to maintain airspeed causing the airplane to inadvertently enter into a stall/mush condition.NTSB FTW90LA128Accident · No injuriesLimited investigationFinal reportMooney M-20E · Luling, TXLoss of control in-flight due to the pilot's failure to maintain adequate airspeed. Factors would be the high density altitude and the tree that he hit.NTSB FTW90LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, TXFailure to maintain directional control.NTSB DEN90LA148Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Broomfield, COThe failure of the pilot to extend the landing gear for landing. Contributing factors were the pilot diverting his attention from the task at hand and failure to use a checklist.NTSB DEN90LA147Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Center, COThe pilot's failure to maintain flying speed, which resulted in a stall and collsion with the ground.NTSB CHI90IA166Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Chicago, ILThe pilot-in-command's inadequate weather evaluation. Factors in the incident were the weather and artcc's failure to issue a weather advisory.NTSB ANC90LA099Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control on landing. The pilot's lack of familiarity with this type airplane (large tires/tail wheel combination), and his lack of total experience were contributing factors.NTSB SEA90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Sitka, AKFailure of the pilot to maintain directional control of the airplane during the landing roll. The crosswind condition was a factor related to the accident.NTSB LAX90WA265Accident · No injuriesForeign investigationPiper PA-11 · Belize City, BelizeNTSB LAX90LA232Accident · No injuriesLimited investigationFinal reportCessna 172N · Van Nuys, CAThe pilot's failure to maintain directional control of the aircraft during the attempted go around. A factor in the accident was the failure of the pilot to follow the go around procedures specified in the aircraft flight manual.NTSB LAX90FA233Accident · Minor injuriesField investigationFinal reportBellanca 17-30A · Ojai, CAStructural damage sustained by the Bellanca, N39843, as a result of encountering wake turbulence during a near-collision with a navy F-14A.NTSB LAX90DUA01Accident · Minor injuriesFinal reportHomebuilt JP-350-1 · Torrance, CAThe aircraft collision with the ground after the pilot experienced a loss of engine thrust due to propeller overspeed condition. Contributing to the accident was the pilot's improper servicing of the propeller hub that allowed the overspeed to occur.NTSB DEN90LA150Accident · No injuriesLimited investigationFinal reportCessna T 188C · Wray, COThe failure of the pilot to maintain proper alignment proper alignment during landing.NTSB DEN90LA146Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Edgeley, NDA momentary power interruption during initial climb for unknown reasons.