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 MIA89LAMS1Accident · 1 fatalFinal reportPiper PA-28-151 · Missing Acft (Atlantic Ocean)The pilot's decision to commit suicide. Contributing to the accident was the pilot's interpersonal relations and his psychological condition.NTSB MIA89IA080Incident · Minor injuriesIncident investigationFinal reportWaco UPF-7 · Marathon, FLFuel starvation due to a corroded carburetor.NTSB LAX89LA104Accident · Serious injuriesLimited investigationFinal reportCameron A-140 · Phoenix, AZThe pilot displayed poor preflight planning and preparation by not properly evaluating the weather conditions.NTSB DEN89LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDThe failure of the pilot to correct a ground loop swerve. A lack of total flight experience is considered to be a contributing factor.NTSB DEN89LA072Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mayville, NDThe pilot's failure to maintain control of the airplane after touchdown on an icy runway. Contributing to the accident was improper alignment with the runway for touchdown.NTSB ANC89LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe pilot's failure to compensate for the gusty wind conditions and to maintain control of the airplane. Contributing to the accident was the gusty winds.NTSB SEA89LA047Accident · No injuriesLimited investigationFinal reportCessna 180 · Wrangell, AKThe plt's failure to properly compensate for the wind during takeoff on unsuitable terrain. Contributing to the accident were the terrain conditions and gusting winds.NTSB NYC89LA081Accident · No injuriesLimited investigationFinal reportCessna 402B · Hyannis, MAInadequate preflight planning and preparation by the pilot which resulted in improper weight and balance (aft CG). The aft CG also contributed to the uncommanded altitude deviation after takeoff.NTSB NYC89LA079Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Hammonton, NJA bird strike shortly after takeoff.NTSB MIA89LA079Accident · No injuriesLimited investigationFinal reportStolp-Adams SA100 · Indian Rocks, FLThe pilot's attempt to perform aerobatic maneuvers in an aircraft that was not equipped with fuel and oil systems that would continue to operate in inverted positions. This action resulted in a loss of power and the pilot having to ditch the aircraft.NTSB MIA89LA077Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLThe failure of the instructor to maintain the proper airspeed during a simulated engine failure on initial climb. The instructor, after taking control of the aircraft, also failed to properly flare the aircraft resulting in a hard landing during which the…NTSB MIA89FA078Accident · Serious injuriesField investigationFinal reportBeech A23-24 · Clearwater, FLFuel starvation due to the CFI depleting the fuel supply from one of two tanks and failing to select the fullest tank for landing. Contributing to the accident was the cfi's improper decision to turn back to the airport when insufficient altitude was…NTSB LAX89LA102Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Ynez, CAThe failure of the pilot to obtain an adequate preflight weather briefing or to obtain inflight weather advisory information, and the failure of the pilot to maintain flying speed while descending in a downdraft.NTSB LAX89DVD02Accident · 1 fatalFinal reportWar Replicas P-51 · Tracy, CAThe improper installation of the aileron controls of this homebuilt acft by the pilot/manufacturer which led to the inflight loss of control of the airplane. Contributing to the accident was the pilot's inexperience in the airplane.NTSB MIA89LA076Accident · Minor injuriesLimited investigationFinal reportWaco YMF · Key West, FLThe inability of the plt to maintain control after encountering his own wake turbulence at a low altitude during a steep turning maneuver.NTSB LAX89DVG04Accident · No injuriesFinal reportSchweizer G-164C · Bayless, CAThe deparation of a turbine blade followed by a forced landing during which the landing gear collapsed due to overload forces.NTSB FTW89LA057Accident · Minor injuriesLimited investigationFinal reportCessna U206 · San Angelo, TXFailure of the pilot to maintain adequate altitude during continued flight into known adverse weather. The weather conditions and dark night were contributing factors.NTSB FTW89LA045Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Richards, TXThe pilot's inadequate preflight planning/preparation in disregarding wind information. Contributing to the accident were the gusting crosswind conditions and the pilot's overconfidence in personal ability.NTSB SEA89LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-31 · Sparks, NVThe pilot's misjudgement of the forced landing profile. Contributing to the accident was the failure of the right turbocharger and the pilot's improper handling of the landing gear system.NTSB NYC89LA078Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Kennebunk, METhe pilot's failure to assure the fuel selector was properly positioned which resulted in fuel starvation and the subsequent forced landing.NTSB LAX89DVA03Accident · Serious injuriesFinal reportBell 47G-3B2 · Strathmore, CAImproper compensation for wind conditions by the pilot, and his failure to maintain clearance from the service truck. Factors relating to the accident were: the unfavorable (variable) and gusty wind conditions and close proximity of the service vehicle.NTSB ATL89LA084Accident · No injuriesLimited investigationFinal reportCessna 172 · Galion, OHThe pilot's failure to retract the flaps prior to adding power for takeoff resulting in a premature lift-off, and the pilot's failure to maintian control of the airplane after lift-off which resulted in a stall/mush.NTSB SEA89LA044Accident · No injuriesLimited investigationFinal reportCessna 182 · N. Bonneville, WASome form of carburetor malfunction or failure which resulted in a loss of engine power. Contributing to the accident was the planned forced landing approach by the plt which resulted in the airplane landing short of the desired landing site.NTSB LAX89LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Novato, CAFire in the engine compartment area for undetermined reasons.NTSB FTW89LA046Accident · No injuriesLimited investigationFinal reportCessna 180B · Nocona, TXThe pilot's disregard of the aircraft performance data/operational limitations by landing in excess of the crosswind capability of the aircraft, and the resultant loss of directional control during the landing roll.NTSB FTW89LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Ore City, TXSlippage of the center crankshaft bearing, which resulted in oil starvation and subsequent failure of the #3 connecting rod. Contributing factors were: the aircraft owner's continued operation of the engine beyond the manufacturer's recommended overhaul…NTSB DEN89IA071Incident · No injuriesIncident investigationFinal reportBeech E90 · Lander, WYDeer on the runway.NTSB BFO89LA017Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Bruceton Mills, WVThe power loss occurred because of carburetor ice which obstructed airflow to the induction system. Contributing to the accident was the carburetor icing conditions, the highway and the ditch which was contacted.NTSB SEA89LA046Accident · No injuriesLimited investigationFinal reportCessna 180J · Elk City, IDThe pilot's failure to maintain a proper runway alignment on touchdown. Contributing to the accident were the soft snow conditions on the ranch airstrip.NTSB LAX89LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · San Martin, CAEngine failure due to a loose spark plug with the reminaing plugs fouled with carbon deposits.NTSB DEN89FA070Accident · No injuriesField investigationFinal reportSwearingen SA-227-AC · Salt Lake City, UTThe failure of captain of N169SW to maintain a visual lookout while taxiing his aircraft allowing his aircraf to creep into the stationary aircraft in front of him.NTSB SEA89LA043Accident · No injuriesLimited investigationFinal reportGulfstream 112TCA · Reno, NVThe failure of the pilot to maintain control of the airplane and the cfi's inadequate supervision of the pilot.NTSB SEA89FA041Accident · 2 fatalField investigationFinal reportAeronca O-58B · Minden, NVThe failure of the pilot to maintain adequate airspeed and airplane control. Contributing to the accident was the mountainous terrain and mountain wave conditions.NTSB NYC89LA077Accident · No injuriesLimited investigationFinal reportCessna 150 · Craley, PAThe loss of control during takeoff due to a pilot induced stall. Contributing to the accident was the wrong runway selected by the pilot which put the aircraft in a downwind takeoff situation and the pilots misjudgement of the distance it would take the…NTSB NYC89LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Seneca Falls, NYFailure of the pilot of the C-150, N17109, to maintain proper separation from other aircraft during landing at an uncontrolled airport.NTSB MKC89LA056Accident · No injuriesLimited investigationFinal reportCessna 172 · Ainsworth, NEThe loss of power from undetermined reasons during an attempted go-around. Contributing to the accident was the pilot's failure to maintain directional control of the airplane and the crosswind conditions.NTSB LAX89FA099Accident · 1 fatalField investigationFinal reportSilvaire 8F · Lake Elsinore, CALoss of aircraft control due to improper and/or unapproved modifications to the aircraft's aileron control system by the pilot/owner. A contributing factor was the pilot/owner's overconfidence in his ability to modify the aileron control system without…NTSB NYC89LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Fire Island, NYThe improper installation of an unauthorized sealant used on the oil ressure screen housing gasket contaminated the oil and restricted the flow of oil through the main bearings causing oil starvation and connecting rod, bearing, and bolt failure.NTSB NYC89FA074Accident · 1 fatalField investigationFinal reportCessna 305A · Blairstown, NJDelays by both pilots in releasing the glider tow line after the glider pilot allowed the glider to maneuver excessively above the tow aircraft. The weather conditions were factors.NTSB MIA89LA075Accident · No injuriesLimited investigationFinal reportCessna T310R · Pensacola, FLFailure of the pilot to maintain the proper airspeed during the approach resulting in landing short of the runway and failure to maintain directional control during the landing roll.NTSB LAX89LA097Accident · No injuriesLimited investigationFinal reportBeech E33 · Parlier, CAThe pilot's improper in-flight planning/decision to continue to the destination airport after encountering a restrictionof fuel flow from the right tank and subsequent fuel starvation when the left tank emptied. Contributing factors were the blocked fuel vent…NTSB LAX89DVG03Accident · Minor injuriesFinal reportEaa WAG-AERO Sport · Placerville, CAThe student's improper application of brakes during the touchdown/flare phase of the landing causing the aircraft to nose over.NTSB DEN89LA069Accident · No injuriesLimited investigationFinal reportCessna P210N · Durango, COFailure of the pilot to maintain runway alignment during takeoff. That the pilot attempted flight into known adverse conditions from an airport that was not approved for IMC operations is considered to be a contributing factor.NTSB SEA89FA040Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Carson City, NVLoss of power on the left engine due to a foreign object which obstructed the fuel flow, and the pilot's failure to maintain airspeed above VMC during his attempted return to the airfield. Contributing to the accident was the lack of recent flight time by the…NTSB MKC89LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Goodland, KSThe loss of engine power resulting from an exhaust valve failure. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB MIA89LA074Accident · Minor injuriesLimited investigationFinal reportBeech G-35 · Panacea, FLPilots loss of control when entering the fog bank during the takeoff, due to spatial disorientation.NTSB MIA89LA073Accident · No injuriesLimited investigationFinal reportBeech A36 · Daytona Beach, FLFailure of the driver of the automobile to maintain an adequate visual lookout and to yield the right of way to the aircraft.NTSB LAX89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gualala, CAPilot misjudged the altitude and distance to the runway and subsequently did not attain the proper touchdown point.NTSB ATL89LA083Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Cumming, GAThe pilot's decision to attempt VFR flight in adverse meteorological conditions at night with an inoperative attitude indicator and insufficient fuel reserve for the intended flight.NTSB SEA89LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Puyallup, WAFailure on the part of the student pilot to maintain directional control of the aircraft. Contributing to the accident were poor approach and flare technique and lack of recent experience.