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.

NTSB BFO89LA072Accident · No injuriesLimited investigationFinal reportBeech B55 · Orange, VAThe takeoff was rejected when the pilot was startled by the sound from the emergency window exit which was inadvertently opened by a passenger. The pilot was unable to stop the aircraft in time to avoid overrunning the runway.Aug 16, 1989 · N816FW · Substantial damageNTSB ATL89FA198Accident · Serious injuriesField investigationFinal reportCessna 182J · Bethel, OHFailure of the pilot to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an inadvertent stall. The pilot's lack of total experience was considered to be a related factor.Aug 16, 1989 · N3542F · Substantial damageNTSB ATL89DKJ09Accident · 1 fatalFinal reportCessna 188B · Prattville, ALFailure of the pilot to maintain clearance from obstructions (trees).Aug 16, 1989 · N9318G · DestroyedNTSB ANC89LA141Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe pilot allowed the aircraft to lift-off prematurely, then inadvertently enter a stall/mush. The gusty/crosswind conditions were contributing factors.Aug 16, 1989 · N6327Z · Substantial damageNTSB SEA89LA150Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20BL · Minden, NVMisunderstood emergency procedures, the glider pilot released from the tow which resulted in a hard landing. The pilot's preflight of the glider and radio communications were inadequate before and during the flight.Aug 15, 1989 · N300Y · Substantial damageNTSB MKC89LA182Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Russell, ARAn engine failure, because of a valve which stuck in the open position, over terrain that was unsuitable for a forced landing.Aug 15, 1989 · N3763D · Substantial damageNTSB MKC89LA181Accident · Minor injuriesLimited investigationFinal reportBell 47G-B3 · Waseca, MNInadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. The tailwind, high obstruction (power line), and crop (beans) were contributing factors.Aug 15, 1989 · N8471E · Substantial damageNTSB MIA89LA223Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Fort Pierce, FLImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. The terrain (rough/uneven) in the emergency landing area was a related factor.Aug 15, 1989 · N60847 · Substantial damageNTSB LAX89FA280Accident · 1 fatalField investigationFinal reportCessna 152 · Castaic, CAFailure of the instructor pilot to adequately supervise the conduct of the flight, failure of the instructor pilot to ensure adequate terrain clearance prior to initiating the maneuver, and failure of the instructor pilot to take timely and proper and proper…Aug 15, 1989 · N152DM · DestroyedNTSB LAX89DUQ04Accident · No injuriesFinal reportAir Tractor AT-300 · New Cuyama, CAThe pilot's mismanagement of the fuel supply which led to an engine power loss due to fuel exhaustion and subsequent collision with the ground by allowing the aircraft to stall.Aug 15, 1989 · N4324S · DestroyedNTSB FTW89LA149Accident · No injuriesLimited investigationFinal reportMooney M20F · Davis, OKThe pilot's failure to maintian directional control and properly flare the airplane during landing.Aug 15, 1989 · N6814V · Substantial damageNTSB CHI89LA171Accident · No injuriesLimited investigationFinal reportCessna 172H · Lake Village, INWater contamination in the fuel/fuel system and inadequate preflight by the pilot. Soft terrain in the emergency landing area was a contributing factor.Aug 15, 1989 · N2484L · Substantial damageNTSB ANC89LA140Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Rainy Pass, AKPilot-in-command's failure to maintain control of the airplane during landing, due to misjudgement of airspeed and distance to the landing touch-down point.Aug 15, 1989 · N3669N · Substantial damageNTSB NYC89FA190Accident · 1 fatalField investigationFinal reportCessna 182Q · Edison Twshp, NJFailure of the pilot to follow the IFR procedure and maintain the minimum descent altitude (mda) for that segment of the approach. Factors related to the accident were: minimum safe altitude warning (msaw) radar not enabled, and failure of the approach…Aug 14, 1989 · N759MN · DestroyedNTSB MKC89LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · St. Clair, MOThe pilot's inability to establish a positive rate of climb due to the misjudged weight and balance calculations.Aug 14, 1989 · N7136B · Substantial damageNTSB MIA89WA222Accident · No injuriesForeign investigationCessna 172M · Grand Turk Isl., Turks & Caicos IslandsAug 14, 1989 · N12634 · DestroyedNTSB MIA89LA221Accident · Serious injuriesLimited investigationFinal reportContinental Copters Tomcat MK6C · Quitman, MSFailure of the tail boom attachment.Aug 14, 1989 · N9085T · DestroyedNTSB MIA89FA219Accident · 2 fatalField investigationFinal reportCessna 177RG · Janice, MSThe in flight loss of control by the non instrument rated pilot after encountering instrument meteorological conditions resulting in the airplane spiraling into a wooded area.Aug 14, 1989 · N1976Q · DestroyedNTSB LAX89LA279Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and collision with the runway.Aug 14, 1989 · N2469F · Substantial damageNTSB LAX89LA278Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Butte Meadows, CAThe pilot improper in-flight planning to attain proper altitude to clear the mountainous terrain. Contributing factor(s) was: the high terrain and high density attitude.Aug 14, 1989 · N3795K · Substantial damageNTSB LAX89FA277Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Lake Tahoe, CADisablement of the stabilator flight control system. A contributing factor was: inadequate maintenance.Aug 14, 1989 · N4838P · DestroyedNTSB LAX89DVM05Accident · No injuriesFinal reportSkelton Emeraude · Watsonville, CAAn inadequate fuel line, due to improper installation by the owner/builder, fuel line failure, fuel line leak, and a subsequent fire.Aug 14, 1989 · N82D · DestroyedNTSB FTW89DRG09Incident · No injuriesFinal reportMccormick Bushby Mustang II · Spicewood, TXThe pilot's failure to maintain proper clearance from personnel on the ground.Aug 14, 1989 · N123WP · No damageNTSB DEN89LA195Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Bountiful, UTInadequate compensation for wind conditions by the pilot and his failure to maintain directional control during the landing. The pilot's inadequate preflight preparation (lack of a weather briefing) and the weather conditions were contributing factors.Aug 14, 1989 · N3128P · Substantial damageNTSB CHI89LA169Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Wadsworth, OHInadequate supervision of the flight by the pilot-in-command (CFI) which resulted in loss of directional control of the aircraft. Contributing factors were: lack of recent experience in the type of operation by the CFI, lack of total experience by the student…Aug 14, 1989 · N16LL · Substantial damageNTSB CHI89LA166Accident · No injuriesLimited investigationFinal reportCessna 172P · Ravenna, OHFailure of pilot in command to maintain directional control of the airplane while executing a touch-and-go.Aug 14, 1989 · N4770J · Substantial damageNTSB CHI89FA165Accident · Serious injuriesField investigationFinal reportBell 47G-2A-1 · Wisconsin Dells, WIAttempt by the pilot to exceed the hover performance capabilities of the helicopter, and operating outside the weight and balance limitations. The pilot's overconfidence in the helicopter's ability and his subsequent failure to adequately prepare and plan…Aug 14, 1989 · N49HB · Substantial damageNTSB ATL89FA197Accident · Serious injuriesField investigationFinal reportCessna A185E · Myrtle Grove, FLThe pilot in command inadvertently stalled the aircraft during a balked landing.Aug 14, 1989 · N95KW · DestroyedNTSB SEA89LA149Accident · Serious injuriesLimited investigationFinal reportSwanson RV-4 · Carnation, WAThe pilot entered an inadvertent stall and hit trees while performing aerobatics.Aug 13, 1989 · N9RS · Substantial damageNTSB MKC89FA179Accident · 3 fatalField investigationFinal reportMooney M20F · Mound City, KSThe pilot's continued VFR flight into an area of thunderstorms & heavy rain which resulted in a loss of control of the airplane. Factors related to the accident were thunderstorms and heavy rain.Aug 13, 1989 · N6960V · DestroyedNTSB MIA89FA220Accident · 4 fatalField investigationFinal reportCessna 172P · Pass-A-Grille, FLFailure of the pilot to recover from a stall/spin. Excessive gross weight of the aircraft and lack of available altitude for spin recovery were probable contributing factors.Aug 13, 1989 · N99901 · DestroyedNTSB LAX89LA274Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Benson, AZThe pilot's failure to maintain adequate airspeed during an emergency descent and to properly flare the aircraft during landing. Contributing to the accident was the pilot's anxiousness in over-reacting to a situation and prematurely entering a power-off…Aug 13, 1989 · N2471D · DestroyedNTSB LAX89LA273Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Seligman, AZA loss of engine power due to a failure of the number 3 cylinder exhaust valve rocker arm pivot stud, which was in turn caused by a stuck exhaust valve.Aug 13, 1989 · N5961J · Substantial damageNTSB LAX89LA272Accident · No injuriesLimited investigationFinal reportCessna 172P · Redlands, CAThe pilot's improper level-off, recovery from bounced landing, and failure to maintain directional control during the landing. The pilot's limited recent experience was a contributing factor.Aug 13, 1989 · N51920 · Substantial damageNTSB FTW89LA146Accident · No injuriesLimited investigationFinal reportHawker Siddeley DH-125-3A · Houston, TXFailure of the nose wheel steering system for undetermined reasons, and the pilot-in-command's hesitation reaching for the nose wheel steering tiller. A contributing factor was his lack of experience in a DH-125.Aug 13, 1989 · N66HA · Substantial damageNTSB DEN89LA194Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Santa Fe, NMImproper use of the mixture control by the pilot during takeoff which resulted in fuel starvation. Rough/uneven terrain contributed to the aircraft damage.Aug 13, 1989 · N3077X · Substantial damageNTSB CHI89LA170Accident · No injuriesLimited investigationFinal reportBeech A33 · Bloomington, ILA loss of engine power due to contamination (water, debris, and rust-like particles) in the fuel and the pilot's failure to detect the contamination during the pre-flight inspection.Aug 13, 1989 · N915Q · Substantial damageNTSB CHI89LA168Accident · No injuriesLimited investigationFinal reportCessna P206A · Louisville, OHThe pilot's improper flare for landing.Aug 13, 1989 · N4688F · Substantial damageNTSB CHI89DEI02Accident · Serious injuriesFinal reportAcroduster SA-750 · Painesville, OHThe pilot's improper use of the fuel selector for takeoff, which resulted in fuel starvation; and his improper use of emergency procedures after the engine lost power. The pilot's lack of familiarity with the aircraft and the trees were contributing factors.Aug 13, 1989 · N69GM · Substantial damageNTSB BFO89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Leesburg, VAImproper planning/decision by the pilot which resulted in his inadvertent flight into instrument meteorological conditions (IMC), and his failure to maintain proper alignment, while landing at night on a road. The weather conditions, dark night, and…Aug 13, 1989 · N4325V · Substantial damageNTSB ANC89LA142Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Red Lake, AKThe pilot's selection of unsuitable terrain. The rough/uneven terrain was a contributing factor.Aug 13, 1989 · N83622 · Substantial damageNTSB ANC89FA144Accident · 2 fatalField investigationFinal reportPiper PA-12 · Windy Fork, AKFailure of the pilot to maintain airspeed while operating to or from the gravel bar, which resulted in an inadvertent stall. The rising terrain was considered a contributing factor.Aug 13, 1989 · N7542H · DestroyedNTSB NYC89LA194Accident · Minor injuriesLimited investigationFinal reportMBB ME 209 · Chatham, MAThe pilot stalled the aircraft while landing. Contributing factors to the accident were haze and the pilot applied power too late to arrest the airplane's sink rate.Aug 12, 1989 · N209AA · Substantial damageNTSB MKC89LA177Accident · No injuriesLimited investigationFinal reportCessna 180 · Topeka, KSThe pilot's poorly planned approach and failure to maintain a proper glidepath. A contributing factor was the failure of the engine to supply power.Aug 12, 1989 · N24TW · Substantial damageNTSB MIA89LA218Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe failure of the pilot to position the auxiliary pump to low for takeoff, compunded by improper procuderes used during the resultant in-flight emergency.Aug 12, 1989 · N5851C · Substantial damageNTSB MIA89LA217Accident · No injuriesLimited investigationFinal reportSmith Kitfox II · Malabar, FLFailure of the pilot to maintain adequate airspeed during takeoff, which resulted in a stall.Aug 12, 1989 · N302RS · Substantial damageNTSB LAX89LA271Accident · No injuriesLimited investigationFinal reportBeech C23 · S Lake Tahoe, CAThe aircraft's encounter with a downdraft during takeoff. Contributing factors were related to the high density altitude condition which existed and the aircraft's deteriorated takeoff performance capability.Aug 12, 1989 · N60482 · Substantial damageNTSB FTW89LA147Accident · No injuriesLimited investigationFinal reportMooney M20K · Marietta, OKThe pilot's delay in aborting the landing (going around) and his improper raising of the flaps at an inadequate airspeed.Aug 12, 1989 · N252WW · DestroyedNTSB DEN89FA192Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Bullfrog, UTImproper flare by the pilot, his failure to maintain runway alignment, and the improper remedial action which resulted in a loss of control. The high density altitude and objects (runway light and smudge pot) were considered to be contributing factors.Aug 12, 1989 · N9084W · DestroyedNTSB CHI89LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Lima, OHThe pilot failed to use carburetor heat during carburetor icing conditions. Contributing to the accident was the pilot's lack of total experience and the carburetor icing conditions.Aug 12, 1989 · N7825D · Destroyed