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 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.NTSB 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.NTSB ATL89DKJ09Accident · 1 fatalFinal reportCessna 188B · Prattville, ALFailure of the pilot to maintain clearance from obstructions (trees).NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB FTW89LA149Accident · No injuriesLimited investigationFinal reportMooney M20F · Davis, OKThe pilot's failure to maintian directional control and properly flare the airplane during landing.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB MIA89WA222Accident · No injuriesForeign investigationCessna 172M · Grand Turk Isl., Turks & Caicos IslandsNTSB MIA89LA221Accident · Serious injuriesLimited investigationFinal reportContinental Copters Tomcat MK6C · Quitman, MSFailure of the tail boom attachment.NTSB 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.NTSB 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.NTSB 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.NTSB LAX89FA277Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Lake Tahoe, CADisablement of the stabilator flight control system. A contributing factor was: inadequate maintenance.NTSB 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.NTSB FTW89DRG09Incident · No injuriesFinal reportMccormick Bushby Mustang II · Spicewood, TXThe pilot's failure to maintain proper clearance from personnel on the ground.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB ATL89FA197Accident · Serious injuriesField investigationFinal reportCessna A185E · Myrtle Grove, FLThe pilot in command inadvertently stalled the aircraft during a balked landing.NTSB SEA89LA149Accident · Serious injuriesLimited investigationFinal reportSwanson RV-4 · Carnation, WAThe pilot entered an inadvertent stall and hit trees while performing aerobatics.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI89LA168Accident · No injuriesLimited investigationFinal reportCessna P206A · Louisville, OHThe pilot's improper flare for landing.NTSB 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.NTSB 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…NTSB ANC89LA142Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Red Lake, AKThe pilot's selection of unsuitable terrain. The rough/uneven terrain was a contributing factor.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB MIA89LA217Accident · No injuriesLimited investigationFinal reportSmith Kitfox II · Malabar, FLFailure of the pilot to maintain adequate airspeed during takeoff, which resulted in a stall.NTSB 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.NTSB 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.NTSB 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.NTSB 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.