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 DEN91LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Fountain, COThe pilot's selection of unsuitable terrain on which to make a landing. Factors were: the pilot's inadequate preflight planning, and weather conditions that included low ceiling, obscuration, fog, and drizzle.NTSB DEN91FA113Accident · 1 fatalField investigationFinal reportCessna 182P · Redstone, COAn inflight collision with terrain after the pilot continued the flight into an area of clouds and rain.NTSB CHI91LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INEngine failure due to fuel exhaustion and refueling not performed by the cfi/pic.NTSB CHI91FA228Accident · 2 fatalField investigationFinal reportRobinson R 22B · Carmel, INThe pilot's delaying remedial action. Factors in the accident were the pilot's failure to attain adequate rotor RPM for takeoff, failure to abort takeoff and lack of total experience in helicopters.NTSB BFO91FA068Accident · 4 fatalField investigationFinal reportBeech V35A · Jonesville, VAFailure of the pilot-in-command (PIC) to assure that the instrument departure procedure was followed and that the aircraft remained clear of mountainous terrain.NTSB ATL91LA141Accident · Serious injuriesLimited investigationFinal reportMaridon Starduster TOO · Locust Grove, GAFuel exhaustion which resulted from the failure of the pilots to refuel the airplane. A factor was the local pilot's having become lost.NTSB ANC91LA106Accident · No injuriesLimited investigationFinal reportCessna 206 · Cube Cove, AKA complete failure of the brake system due to a crack in the brake lines. Contributing to the accident was that the brakes were not adequately maintained by company maintenance personnel.NTSB ANC91FA107Accident · 1 fatalField investigationFinal reportCessna 182 · Takotna, AKThe pilot's loss of control in flight due to spatial disorientation while attempting to operate under visual flight rules while in instrument meteorological conditions. Contributing to the accident was the mountainous terrain.NTSB SEA91LA187Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Kemmerer, WYThe pilot's poor planning/decision. Factors include selecting the wrong runway under the high density altitude conditions.NTSB SEA91FA186Accident · 5 fatalField investigationFinal reportCessna 206 · Salmon, IDImproper inflight planning and decisions and failure to maintain airspeed.NTSB NYC91LA187Accident · No injuriesLimited investigationFinal reportMeyers MAC-145 · Elyria, OHThe failure of the pilot to maintain directional control during landing. Factors related to the accident were a strong wind shear during landing; unavailability of wheel brakes for the co-pilot; and inadequate supervision of the co-pilot during landing.NTSB LAX91FA324Accident · 3 fatalField investigationFinal reportBeech 95-C55 · Granada Hills, CAA loss of directional control following an undetermined autopilot failure, during which the pilot failed to perform the emergency procedure to correct a mis-trim condition. Contributing to the accident was a perceived elevator control problem; the inability…NTSB CHI91MA224Accident · 3 fatalMajor investigationFinal reportLearjet 23 · Detroit, MIImproper preflight by the pilot, his failure to abort the takeoff while there was sufficient runway remaining, and his failure to assure that the aircraft attained sufficient airspeed for lift-off and climb. Factors related to the accident were: the pilot's…NTSB CHI91LA225Accident · No injuriesLimited investigationFinal reportCessna 305A · Keokuk, IADiverted attention by the pilot resulting in directional control not being maintained. A factor related to the accident was crosswind.NTSB CHI91DEM07Accident · No injuriesFinal reportCessna 188B · Munger, MIA premature liftoff by the pilot. A factor contributing to this accident was the soft runway surface and a stall/mush.NTSB ATL91LA140Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Boone, NCThe pilot's failure to follow the manufacturer's procedures related to takeoff performance. Factors in the accident were: the high density altitude, the high obstructions, and the pilot's lack of expereince with takeoff operations at high density altitude.NTSB ANC91LA108Accident · No injuriesLimited investigationFinal reportCessna 185 · Clarks Point, AKThe loss of directional control on the ground caused by the failure of the left brake disc. Contributing to the accident was the pilot-in-command's intentional ground loop of the airplane.NTSB SEA91FA184Accident · 1 fatalField investigationFinal reportBell 206B · Toutle, WAFailure of the pilot to maintain airspeed and correct for the right yawing condition. Factors to the accident were: inadequate compensation for wind conditions, diverted attention, and lack of total expereince in type of aircraft.NTSB SEA91FA183Accident · 4 fatalField investigationFinal reportCessna 177RG · Salmon, IDImproper inflight planning and decision by the pilot, and his failure to maintain sufficient altitude and clearance from mountainous/hilly terrain.NTSB NYC91LA185Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Templeton, MAFuel starvation induced power loss on first the left engine due to a failed fuel fitting and then the right engine due to a worn fuel fitting. A factor was the lack of suitable terrain for the forced landing.NTSB LAX91LA320Accident · No injuriesLimited investigationFinal reportSikorsky SK-58 · Daggett, CAThe failure of an engine connecting rod causing a reduction of engine power to the point where level flight could not be maintained. A factor in the accident was the dark night conditions which restricted the pilot's ability to select the best landing site.NTSB FTW91LA125Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Slidell, LAThe pilot performing a touchdown autorotation to unsuitable terrain. Factors were the soft terrain and the inadequate supervision by the FAA inspector.NTSB DEN91LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Watkins, COThe pilot selected the wrong runway and landed with a tailwind.NTSB CHI91LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Winona, MNImproper flare performed by the pilot. A factor related to the accident was lack of total experience by the pilot.NTSB CHI91LA221Accident · No injuriesLimited investigationFinal reportCessna 150M · Merrillville, INImproper pre-flight planning and preparation by the pilot-in-command. Factors related to this accident were the pilot-in-commands's inattentiveness concerning the refueling of his airplane, and inadequate fuel supply, inattentive ground personnel, and…NTSB CHI91IA223Incident · No injuriesIncident investigationFinal reportBeech B200 · Greenbay, WIInadequate airframe design, which resulted in the in-flight separation of the left engine's outboard aft upper cowl door.NTSB ATL91LA139Accident · No injuriesLimited investigationFinal reportCessna 172P · Sylva, NCThe pilot's improper in-flight planning, and his failure to maintain a proper altitude while maneuvering in the canyon. Factor(s) in this accident were: the mountainous, box canyon conditions, the high density altitude, and the downdraft conditions at the…NTSB ANC91LA105Accident · No injuriesLimited investigationFinal reportCessna 182 · Girdwood, AKImproper in flight planning, fuel starvation and fuel supply not understood by the pilot. Contributing to the accident was rough and uneven terrain.NTSB SEA91LA182Accident · 2 fatalLimited investigationFinal reportPiper PA-20 · Ione, WAInadequate clearance. A factor to the accident was: poor inflight planning.NTSB NYC91LA173Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Vernon, OHThe pilot rotated the airplane prematurely and continued the climb at a deck angle that eventually resulted in a stall. Factors related to the accident were: the pilot's complacency, failure to determine the airplane's performance capabilities prior to take…NTSB MIA91LA190Accident · No injuriesLimited investigationFinal reportCessna 150M · Tunica, MSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. The quartering crosswind and soft terrain were related factors.NTSB LAX91LA322Accident · Serious injuriesLimited investigationFinal reportExperimental Brown 2 · San Carlos, CAThe failure of the pilot to maintain control of the aircraft during the attempted go around.NTSB LAX91LA321Accident · No injuriesLimited investigationFinal reportPiper PA 18-135 · Gerlach, NVThe failure of the pilot to maintain adequate terrain clearance by the selection of an inappropriate cruise altitude resulting in an in flight collision with terrain.NTSB LAX91LA285Accident · Minor injuriesLimited investigationFinal reportCessna 172RG/A · Vacaville, CAThe private pilot PIC failed to maintain directional control during landing rollout. The CFI pilot failed to take remedial action.NTSB FTW91DRG04Accident · Serious injuriesFinal reportAir Tractor AT-402 · Taft, TXThe pilot's failure to maintain proper terrain clearance.NTSB ANC91FA104Accident · Serious injuriesField investigationFinal reportCessna 152 · Anchorage, AKA loss of power due to undetermined causes. Factors include objects in the flight path encountered during the emergency descent.NTSB SEA91LA192Accident · No injuriesLimited investigationFinal reportCessna 172M · Little Rock, WAA delayed go-around, and airspeed not being maintained. Factors include the pilot's overconfidence in the aircraft's ability, the pilot's lack of total experience in this type of operation, misjudged clearance, and the use of improper procedure.NTSB SEA91LA190Accident · Minor injuriesLimited investigationFinal reportFleet FL-80 · Havre, MTThe engine driven fuel injection pump metering valve shaft was loose. A factor to the accident was: inadequate annual inspection.NTSB SEA91LA189Accident · No injuriesLimited investigationFinal reportBeech V35A · Weiser, IDThe pilot did not refuel the airplane resulting in fuel exhaustion.NTSB SEA91LA185Accident · No injuriesLimited investigationFinal reportCessna 180 · Cody, WYPilot's failure to maintain proper runway alignment. Factors were diverted attention, and gusty crosswinds.NTSB NYC91LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Eagle Lake, METhe pilot's misjudgment of his altitude during a landing on glassy water, which resulted in a loss of airplane control.NTSB NYC91LA183Accident · Serious injuriesLimited investigationFinal reportBeech B90 · Waynesville, OHThe shroud lines from the parachute cutting through the left horizontal stabilizer and deforming the left elevator after the jumper had an uncommanded deployment of his reserve parachute and was pulled from the airplane.NTSB MIA91LA189Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hilliard, FLLoss of engine power due to undetermined reasons, failure of the pilot to maintain vso, and inadvertent stall mush. Contributing to the accident was lack of total experience in the type of operation.NTSB LAX91LA323Accident · No injuriesLimited investigationFinal reportCessna C-172P · Hesperia, CAA stuck engine throttle due to improper maintenance procedures.NTSB DEN91LA102Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Albuquerque, NMThe failure of the right main landing gear tire.NTSB CHI91LA240Accident · No injuriesLimited investigationFinal reportPiper J-3 · Saint Leo, MNPerformance data was misjudged resulting in a positive climb not being attained by the pilot. A factor related to the accident was high density altitude.NTSB CHI91LA222Accident · No injuriesLimited investigationFinal reportCessna 172 · West Chicago, ILDirectional control was not maintained by the cfi/pic. Factors related to the accident were a gusty cross wind and an airport facility, VASI light.NTSB CHI91DTG06Accident · No injuriesFinal reportAyres S2R · Drayton, NDThat the pilot did not perform any preflight planning, and did not use the aircraft performance data.NTSB BFO91LA070Accident · Serious injuriesLimited investigationFinal reportGrumman AA5 · Oakland, MDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB ATL91LA137Accident · No injuriesLimited investigationFinal reportCessna 182 · Jenkinsburg, GAThe separation of the nose wheel, during the landing roll, for undetermined reasons.