NTSB investigations, 2004
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WHERE year(c.\"eventDate\") = 2004 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 WHERE year(c."eventDate") = 2004 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 LAX04CA262Accident · No injuriesData collectionFinal reportManoucher Lancair 360 Mkii · Pacoima, CAthe pilot misjudged the airplane's distance/speed which resulted in an overrun. A contributing factor was the tailwind.NTSB FTW04LA191Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Blackwell, OKThe pilot's failure to maintain directional control and the instructor's inadequate supervision by his delay in taking corrective action during the landing roll.NTSB CHI04MA182Accident · 4 fatalMajor investigationFinal reportBell 407 · Newberry, SCThe pilot's failure to maintain terrain clearance as a result of fog conditions. A contributing factor was inadequate weather and dispatch information relayed to the pilot.NTSB ATL04IA156Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-233 · Atlanta, GAThe failure of company maintenance personnel to secure the nacelle/cowl doors, which resulted in a separation of the doors during takeoff initial climb.NTSB SEA04CA132Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Waitsburg, WAThe pilot's failure to maintain aircraft control and his inadequate compensation for the wind conditions during the landing. Gusts and high vegetation were factors.NTSB LAX04LA261Accident · No injuriesLimited investigationFinal reportEurocopter France AS350 B2 · Peach Springs, AZThe pilot's selection of downwind takeoff direction and improper use of the collective control prior to reaching translational lift, which resulted in a settling with power condition and a collision with the ground. Also causal was the pilot's failure to…NTSB FTW04LA182Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eagle Lake, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ENG04IA021Incident · No injuriesIncident investigationFinal reportRaytheon Corporate Jets Beechjet 400A · Sarasota, FLHigh-altitude ice crystals that had accreted on the compressor vanes and were ingested into the high pressure compressor when the pilots retarded the power levers causing compressor surges and flameouts of both engines. Contributing factors were the lack of…NTSB CHI04TA193Accident · No injuriesFinal reportPZL-Mielec M-18T · Pine Ridge, SDThe propeller went to an overspeed condition as a result of contamination of the propeller control unit due to improper servicing by the operator and the mechanic. A factor was the hilly terrain.NTSB ATL04LA153Accident · 1 fatalLimited investigationFinal reportConvair Div. of Gen. Dynamics 440 · Beef IslandThe in-flight fire on the number two engine, for undetermined reasons.NTSB SEA04LA129Accident · No injuriesLimited investigationFinal reportLogston Starduster SA100DL · Arlington, WAThe pilot's failure to maintain clearance during taxi from another aircraft standing on the runway resulting in a collision. The aircraft standing on the runway was a factor.NTSB NYC04LA163Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Hackettstown, NJThe pilot's inadequate preflight inspection, which resulted in the total loss of engine power due to fuel contamination, during the initial climb after takeoff.NTSB NYC04FA161Accident · 2 fatalField investigationFinal reportBeech E95 · Atlantic City, NJThe pilot's failure to maintain airplane control while performing a go-around after experiencing a loss of power to the left engine for undetermined reason(s). A factor related to the accident was the loss of power to the left engine.NTSB NYC04CA166Accident · No injuriesData collectionFinal reportRobinson R-44 II · Beverly, MAThe pilot's inadequate visual lookout, which resulted in a collision with transmission wires.NTSB LAX04LA283Accident · No injuriesLimited investigationFinal reportCessna 182A · Petaluma, CAthe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a collapse of the nose landing gear.NTSB LAX04LA260Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeport, CAthe pilot's failure to attain an adequate altitude to clear mountainous terrain during a high density altitude condition.NTSB LAX04LA259Accident · No injuriesLimited investigationFinal reportNorth American T28B · Apple Valley, CAThe pilot's failure to maintain an adequate airspeed during the conclusion of a low pass, which led to a stall/mush.NTSB LAX04CA263Accident · No injuriesData collectionFinal reportCessna R182 · California City, CAthe pilot's failure to lower the landing gear. A contributing factor was the pilot's distraction while on final approach.NTSB LAX04CA258Accident · No injuriesData collectionFinal reportBoeing A 75N1 · Auburn, CAthe pilot undergoing instruction's overcontrol of the aircraft by his excessive use of the rudder control and failure to maintain directional control of the airplane during landing, which resulted in a ground loop. Contributing factors to the accident were…NTSB IAD04FA031Accident · 1 fatalField investigationFinal reportCessna 172C · Edinburgh, NYThe pilot's occluded left main coronary artery, which resulted in a massive heart attack and sudden death in flight.NTSB DEN04FA104Accident · 2 fatalField investigationFinal reportCessna 172I · Paris, ARthe pilot's inadequate preflight preparation, his attempted flight into adverse weather conditions, and his failure to maintain clearance from the trees resulting in the airplane's collision with the trees and subsequent impact with the ground. Factors…NTSB DEN04CA103Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 120A · Albuquerque, NMthe pilot's failure to maintain/obtain the proper descent rate.NTSB ATL04LA198Accident · Serious injuriesLimited investigationFinal reportThunder & Colt 210A · Huntersville, NCGusty weather conditions which resulted in an in-flight collision with terrain during touchdown.NTSB ATL04CA162Accident · No injuriesData collectionFinal reportCessna 172 · Chamblee, GAThe pilot's improper landing flare that resulted in a hard landing. A factor was a tailwind condition.NTSB ANC04LA077Accident · No injuriesLimited investigationFinal reportHughes 369D · Nome, AKThe pilot's inadequate compensation for wind conditions while the helicopter was standing, which resulted in the coasting main rotor blade contacting the tail boom. A factor associated with the accident was the gusty wind condition.NTSB ANC04LA075Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Talkeetna, AKThe pilot's inadequate compensation for the wind conditions during cruise flight, which resulted in the airplane impacting the lake. A factor associated with the accident was a downdraft, and low altitude flight.NTSB ANC04CA076Accident · No injuriesData collectionFinal reportCessna 180J · Bettles, AKThe pilot's inadequate compensation for the wind conditions during takeoff/initial climb, which resulted in a loss of control and in-flight collision with terrain. Factors contributing to the accident were the pilot's inadequate weather evaluation, and a…NTSB SEA04LA128Accident · No injuriesLimited investigationFinal reportHughes 269C · Arlington, WAA significant power loss for undetermined reasons while in cruise flight, leading to a full autorotational landing. Factors include no suitable terrain in the area, and soft swampy terrain at the point where the pilot found it necessary to perform the forced…NTSB LAX04LA257Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Castaic, CAa catastrophic engine failure due to oil exhaustion, which was caused by the failure of maintenance personnel to completely tighten the oil screen.NTSB IAD04FA030Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ticonderoga, NYReason for occurrence undetermined.NTSB FTW04LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Winnsboro, LAThe pilot's mismanagement of fuel resulting in fuel starvation. A contributing factor was the ditch.NTSB DEN04CA102Accident · Minor injuriesData collectionFinal reportMooney M20S · Farmington, NMthe pilot's failure to maintain airspeed resulting in a stall. A contributing factor was the pilot's diverted attention.NTSB DEN04CA101Accident · No injuriesData collectionFinal reportWhitlock Rotorway Exec 162F · Meeker, COaircraft control not maintained by the pilot. A contributing factor was the failure of the supercharger.NTSB ATL04LA199Accident · Minor injuriesLimited investigationFinal reportAdventura II · Naples, FLLoss of engine power for undetermined reasons and the pilot's improper landing flare which resulted in a hard landing and collapse of the main landing gear.NTSB ATL04LA152Accident · Serious injuriesLimited investigationFinal reportStein Skybolt Skybolt · Jasper, GAThe pilot's attempt to operate the airplane with known deficiencies in the equipment, and the fuel system contamination that resulted in fuel starvation to the engine. A factor was rough and uneven terrain.NTSB ATL04LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Cumming, GAThe pilot's failure to obtain takeoff performance data, and his intentional takeoff from a closed and short runway which resulted in an in-flight collision with a tree.NTSB ATL04LA148Accident · No injuriesLimited investigationFinal reportCessna 401B · Naples, FLThe fracture of the right landing gear down lock stud which resulted in the right main landing gear collapse during landing roll.NTSB ATL04CA154Accident · No injuriesData collectionFinal reportGlassic Composites SQ-2000 XL · Dayton, TNThe pilot's failure to maintain directional control during landing roll, which resulted in a ground loop and the subsequent collapse of the landing gear.NTSB ATL04CA151Accident · No injuriesData collectionFinal reportCessna 182A · Walterboro, SCThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion and the subsequent loss of engine power.NTSB ATL04CA149Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Tallassee, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. A factor was pilot fatigue and the unauthorized use of the airplane .NTSB SEA04LA130Accident · No injuriesLimited investigationFinal reportPetsche Kitfox Kitfox 7 · Arlington, WAThe pilot's inadequate compensation for a crosswind condition and failure to maintain directional control while landing. A factor contributing to the accident was a direct crosswind.NTSB SEA04FA127Accident · Serious injuriesField investigationFinal reportExtra Flugzeugrau EA 300/L · Boise, IDThe failure of the pilot to maintain clearance with terrain during descent while conducting an aerobatic maneuver. Low altitude flight was a factor.NTSB NYC04LA162Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Norfolk, VAThe pilot's failure to complete an autorotation due to the restrictive movement of the collective control.NTSB FTW04LA180Accident · No injuriesLimited investigationFinal reportCessna 150M · Sherrill, ARthe pilot's inadequate in-flight planning/decision which resulted in the loss of engine power due to fuel exhaustion.NTSB CHI04LA183Accident · No injuriesLimited investigationFinal reportCessna 340A · Mason City, IAThe proper touchdown point not obtain/maintained by the pilot following a single-engine approach to landing. Contributing factors were the vacuum pump oil leak, the low oil pressure of the propeller control system, and the unfeathered propeller.NTSB CHI04LA181Accident · No injuriesLimited investigationFinal reportBeech BE-N35 · Austin, MNThe loss of engine power due to the fatigue fracture of the piston pin plug that lead to engine oil starvation/exhaustion and the subsequent overload fracture of the piston rod and crankcase.NTSB CHI04CA180Accident · No injuriesData collectionFinal reportTexas Helicopter M-74 · Clear Lake, MNThe pilot failed to maintain a proper glidepath to the landing zone. A factor was the truck pad.NTSB SEA04CA126Accident · Minor injuriesData collectionFinal reportAmmeter RV-6 · Cascade, IDThe pilot's improper flare and his failure to maintain directional control. Factors contributing to the accident are rough/uneven terrain.NTSB LAX04LA256Accident · Minor injuriesLimited investigationFinal reportEurocopter AS350 B2 · Hilo, HIthe pilot's inadequate planning/decision by his VFR flight into IMC, and his failure to maintain obstacle clearance which resulted in an in-flight collision with a tree. A low ceiling and fog were contributing factors.NTSB FTW04CA181Accident · No injuriesData collectionFinal reportCessna 180E · Weiner, ARThe pilot's poor preflight preparation/planning which resulted in the pilot landing at a wrong airport. A contributing factor was the lack of suitable terrain for the off airport landing.