NTSB investigations, 2004
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 ANC04IA025Incident · No injuriesIncident investigationFinal reportBoeing 767-300 ER · Miami, FLThe inadequate quality of material in the main landing gear bogie pivot pin, which resulted in a premature fracture of the pin.NTSB LAX04LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-31 · Kahului, HIthe pilot's failure to maintain an adequate airspeed while maneuvering for landing on one engine, which resulted in an inadvertent stall. The loss of power in one engine for undetermined reasons was a factor.NTSB FTW04TA075Accident · Minor injuriesFinal reportBell 206B · Decatur, TXThe pilot's failure to maintain control of the helicopter during liftoff after encountering dynamic rollover. A contributing factor was the rough and uneven terrain.NTSB CHI04LA073Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Memphis, MODirectional control not maintained by the flight instructor during the landing roll. The snow on the edge of the runway, and the wind gusts were factors.NTSB ANC04LA024Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Daytona Beach, FLThe pilot's inadequate compensation for wind conditions while hover taxiing, which resulted in a loss of control and subsequent in-flight collision with terrain and a rollover of the helicopter. A factor associated with the accident was a gusty wind condition.NTSB LAX04LA126Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tracy, CAA loss of engine power for undetermined reasons during cruise flight.NTSB LAX04LA125Accident · 2 fatalLimited investigationFinal reportKnapple/Wray Lancair IV-P · Apache Junction, AZthe pilot/builder's failure to maintain an adequate airspeed while maneuvering that resulted in an inadvertent stall/spin.NTSB CHI04FA069Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Rich Hill, MOSpatial disorientation experienced by the non-instrument rated pilot due to a lack of visual references and his subsequent failure to maintain control of the aircraft. Contributing factors were the pilot's intentional flight into adverse weather conditions,…NTSB CHI04FA066Accident · 3 fatalField investigationFinal reportBeech B90 · Dodge City, KSThe pilot failed to maintain clearance with terrain due to pilot fatigue (lack of sleep).NTSB NYC04LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Davis, WVThe pilot's failure to maintain directional control after encountering a snow patch on the runway. A factor related to the accident was the snowdrift.NTSB NYC04FA223Accident · 1 fatalField investigationFinal reportAero Commander 112 · Vieques, PRThe pilot's inadequate preflight and in-flight planning and decision making which resulted in the airplane entering instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument experience, a vacuum pump failure, and…NTSB NYC04CA070Accident · No injuriesData collectionFinal reportCessna 172R · Batavia, OHThe student pilot's improper flare and improper recover from a bounced landing, which resulted in a hard landing.NTSB LAX04FA137Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Jean, NV!!This case was modified January 31, 2006!! the pilot's failure to maintain adequate clearance with the rising terrain, while maneuvering at low altitude in a mountainous area.NTSB LAX04CA136Accident · No injuriesData collectionFinal reportCessna 177A · Honolulu, HIthe pilot's misjudged landing flare, which resulted in a hard landing and porpoising down the runway.NTSB IAD04LA011Accident · No injuriesLimited investigationFinal reportCessna 210E · Pittsburgh, PAThe owner/pilot-mechanic's failure to comply with an airworthiness directive, which resulted in a fatigue fracture to the left main landing gear saddle.NTSB CHI04LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Carroll, IAThe pilot's misjudgment of altitude and distance, and his inadequate remedial action which resulted in the failure to attain the proper touchdown point on the runway. A factor was the snow covered terrain which was encountered by the airplane.NTSB CHI04FA071Accident · 1 fatalField investigationFinal reportCessna 182Q · Rozel, KSThe inadvertent flight into instrument meteorological conditions, the spatial disorientation, and aircraft control not maintained by the pilot during cruise flight. Contributing to the accident were the night instrument meteorological conditions due to low…NTSB NYC04CA068Accident · No injuriesData collectionFinal reportCessna 172E · Batavia, NYThe pilot's failure to maintain directional control while landing. Factors were a tailwind and icy runway.NTSB LAX04CA130Accident · No injuriesData collectionFinal reportCessna 172S · Riverside, CAthe pilot's inadequate visual lookout, which resulted in his failure to maintain proper alignment with the taxiway. Factors in the accident were the dusk lighting conditions and pilot not understanding the ground control taxi clearance.NTSB CHI04LA070Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casey, ILThe pilot not maintaining aircraft control during the loss of engine power and his improper remedial action during the encountered uncommanded roll (VMC roll). An additional cause was the pilot's failure to obtain a maintenance inspection by a qualified…NTSB NYC04CA072Accident · No injuriesData collectionFinal reportCessna 172 · West Dover, VTThe pilot's failure to maintain aircraft control, and his failure to perform a go-around. Factors were wind gusts and the pilot's lack of flight experience.NTSB CHI04LA076Accident · No injuriesLimited investigationFinal reportCessna 177 · Sturgis, MIThe pilot's inadvertent raising of flaps resulting in a loss of lift and his failure to maintain aircraft control resulting in a dragging of the wing.NTSB ANC04LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Naples, FLThe pilot's inadequate compensation for a crosswind condition during landing, which resulted in a loss of control and an on-ground encounter with terrain. Factors associated with the accident were a crosswind, and an inadvertent ground loop.NTSB ANC04LA022Accident · 1 fatalLimited investigationFinal reportBertrand/Warner Thorp T-18 · Crescent City, FLThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain terrain clearance. Factors associated with the accident were fog and low ceilings.NTSB SEA04CA041Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Rexburg, IDThe pilot's failure to maintain runway alignment, and clearance from the snow bank. A snow bank adjacent to the runway was a factor.NTSB NYC04CA074Accident · No injuriesData collectionFinal reportDanbrook Corbin Jr Ace · Pittsgrove, NJThe pilot's improper flare and his failure to maintain adequate airspeed which resulted in a stall and a hard landing.NTSB LAX04LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hollister, CAthe student pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight.NTSB LAX04LA131Accident · No injuriesLimited investigationFinal reportCessna 185F · Mesa, AZthe pilot's inadequate compensation for the crosswind and his failure to maintain directional control, which resulted in an inadvertent ground loop. A factor in this accident was the pilot's diverted attention.NTSB LAX04LA124Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Upland, CAA partial loss of engine power for undetermined reasons during takeoff.NTSB LAX04LA123Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 11 · Phoenix, AZthe failure of the deflation vent line, which resulted in the pilot not being able to control the balloon in the increased wind conditions.NTSB DEN04LA047Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Kremmling, COthe pilot's failure to attain landing flare and maintain adequate rotor rpm.NTSB DEN04LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Parowan, UTthe pilot's in-flight decision/planning which resulted in fuel exhaustion. The fence and night conditions were contributing factors.NTSB CHI04LA072Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Sunburg, MNThe pilot's improper in-flight decision to land off-airport. A factor to the accident was the snow covered ditch.NTSB NYC04CA073Accident · No injuriesData collectionFinal reportCessna 172N · Easton, MDThe student pilot's improper flare, which resulted in a hard landing.NTSB MIA04WA052Accident · Minor injuriesForeign investigationBeech A36 · Punta Brava, ParaguayNTSB LAX04CA122Accident · No injuriesData collectionFinal reportMcDonnell Douglas 369FF · Mesa, AZthe pilot's inadequate compensation for the wind gusts and subsequent failure to maintain directional control of the helicopter, which resulted in a hard landing. A contributing factor was a wind gust.NTSB DEN04LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · West Jordan, UTthe failure of the exhaust valve for the engine's number one cylinder, resulting in the exhaust valve/piston contact and the subsequent total loss of engine power. Contributing factors include the lack of suitable terrain for a forced landing and the snow…NTSB ATL04FA075Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Alma, GAThe pilot's inadequate in-flight decision, and his failure to maintain aircraft control which resulted in continued VFR flight into IMC and the subsequent collision with trees during approach.NTSB ANC04FA021Accident · 1 fatalField investigationFinal reportBeech J35 · Pensacola, FLThe pilot's improper decision to conduct flight that exceeded his demonstrated skills/ability. Also causal was his failure to properly execute the instrument approach. Contributing factors were low ceiling, fog, and the pilot's lack of the appropriate…NTSB MIA04CA053Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Sebring, FLThe pilot's failure to maintain control during the landing rollout which resulted in the airplane ground looping and incurring damage.NTSB LAX04CA121Accident · No injuriesData collectionFinal reportBell 47-G3B2 · Salome, AZthe pilot's failure to maintain an adequate clearance from trees while approaching the landing zone.NTSB IAD04CA010Accident · No injuriesData collectionFinal reportPiper PA-20 · West Ossipee, NHThe pilot's inability to maintain runway alignment during the landing rollout. Factors included the night lighting conditions and the snow banks that prevented visual reference to the runway lights.NTSB SEA04LA040Accident · No injuriesLimited investigationFinal reportLancair LC42-550FG · Redmond, ORThe pilot rated passenger's failure to maintain directional control during the landing roll. Inadequate supervision by the pilot-in-command (CFI) and a taxiway sign were factors.NTSB DCA04WA026Accident · 46 fatalForeign investigationFokker 50 · Sharjah AirportNTSB ANC04LA032Accident · No injuriesLimited investigationFinal reportCessna 208B · Toksook Bay, AKThe pilot's inadequate planning and decision to initiate a takeoff into a crosswind that exceeded the airplane's demonstrated crosswind component, which resulted in a loss of directional control during the takeoff roll, and subsequent collision with terrain…NTSB NYC04LA071Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Collegeville, PAThe pilot's failure to maintain clearance from trees during approach to the runway. Factors in the accident were the dark night and snowbank.NTSB NYC04CA066Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Grt. Barrington, MAThe pilot's misjudgment of the airplane's distance/speed and failure to obtain the proper touchdown point, which resulted in an overrun. A factor was the cross wind.NTSB LAX04WA128Accident · Serious injuriesForeign investigationRobinson R22 · Bribie Island, AustraliaNTSB CHI04LA065Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Sturgis, MIThe failure to maintain obstacle clearance during an intentional low altitude maneuver and the ostentatious display by the pilot-in-command. A factor to the accident was the tree.NTSB ANC04LA031Accident · No injuriesLimited investigationFinal reportCessna 182M · Yakutat, AKThe pilot's delayed use of carburetor heat, which resulted in an engine power loss during takeoff-initial climb, a forced landing, and subsequent collision with terrain. A factor contributing to the accident was the presence of carburetor icing conditions.