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 ATL04TA137Accident · No injuriesFinal reportBell 206B · Graysville, ALThe pilot's inadequate compensation for a tailwind and his failure to maintain directional control resulting in a loss of tail rotor effectiveness. A factor was the pilot's improper in-flight decision to hover with a tailwind.NTSB SEA04LA113Accident · Serious injuriesLimited investigationFinal reportPiper J-3 · Glenoma, WAThe pilot's failure to maintain clearance from the trees while maneuvering at a very low level in hilly terrain. Factors include hilly terrain, and thickly forested slopes in the area where the pilot was maneuvering.NTSB SEA04FA111Accident · 1 fatalField investigationFinal reportTeST TST-10 M · Enumclaw, WAAircraft control not maintained while maneuvering for landing. A proper glidepath was not maintained was a factor.NTSB SEA04CA116Accident · No injuriesData collectionFinal reportChampion 7GCB · Florence, ORPilot's improper touchdown point during landing. A sand mound was a factor in the accident.NTSB NYC04CA145Accident · No injuriesData collectionFinal reportCessna 172R · Hartford, CTThe student pilot's improper flare and inadequate compensation for wind conditions. A factor was the gusty winds.NTSB MIA04WA101Accident · Serious injuriesForeign investigationDouglas DC-3 · Vichada, ColombiaNTSB MIA04FA100Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Baker, FLThe flight crew's inadvertent flight into thunderstorms resulting in the design limits of the airplane being exceeded, loss of aircraft control and subsequent in-flight breakup. A factor in the accident was the lack of required advisory by ATC about a radar…NTSB CHI04LA146Accident · 1 fatalLimited investigationFinal reportCessna A188B · Prosser, NEThe pilot's abrupt maneuver to avoid obstructions, and his failure to maintain adequate airspeed resulting in a stall. The low altitude flight operation, and the transmission tower (antenna) were contributing factors.NTSB ANC04LA066Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop/swerve, and the left wingtip and propeller striking the runway. A factor associated with the accident was the installation of oversized tires on the…NTSB WAS06WA017Accident · 6 fatalForeign investigationCessna 185 · Sukabumi, IndonesiaNTSB SEA04LA112Accident · Serious injuriesLimited investigationFinal reportCosmos Phase II · Bandera, WAThe pilot's failure to maintain clearance from an airport sign during the landing roll. Inadequate compensation for the wind gust and the sign were factors.NTSB NYC04WA149Accident · No injuriesForeign investigationBeech 24 · Baden, GermanyNTSB MIA04LA099Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Deland, FLA loss of engine power due to an engine master rod bearing failure for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.NTSB CHI04CA164Accident · No injuriesData collectionFinal reportCessna 401 · Mt. Vernon, ILThe pilot's misjudgment of the landing flare. Contributing factors were the pilot's failure to execute a stabilized approach for landing. An additional factor was the presence of the runway lights.NTSB CHI04CA160Accident · Minor injuriesData collectionFinal reportChampion 7FC · Carmi, ILThe pilot's failure to maintain directional control during the takeoff roll, his decision to continue the takeoff when the aircraft had left the runway surface, and his selection of unsuitable terrain for the continued takeoff. An additional cause was the…NTSB ATL04CA136Accident · Serious injuriesData collectionFinal reportBeech A23 · Columbia, TNThe pilot's failure to maintain clearance from trees during climb and the pilot's failure to execute a go-around before completing the approach to land.NTSB ATL04CA135Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Gulf Shores, ALThe pilot's failure to maintain airspeed that resulted in a stall and the subsequent collision with the ground.NTSB LAX04CA244Accident · No injuriesData collectionFinal reportFairchild 24R-40 · Lincoln, CAthe pilot's failure to maintain directional control and inadequate compensation for gusty wind conditions, which resulted in a ground loop and collision with the runway.NTSB CHI04LA158Accident · 2 fatalLimited investigationFinal reportMonocoupe 90AL-115 · St. Paul, MOThe pilot's failure to maintain altitude/clearance from the terrain while maneuvering.NTSB CHI04CA159Accident · Serious injuriesData collectionFinal reportBracken CB540 · Lapeer, MIThe pilot's loss of control due to an undetermined flight control system malfunction. Contributing factors to the accident were the wires and trees.NTSB ATL04CA134Accident · Minor injuriesData collectionFinal reportCessna T210N · Ellijay, GAThe pilot misjudged his airspeed, distance and intended proper touchdown point which resulted in an overrun of the runway surface and the subsequent collision with an embankment.NTSB ATL04CA133Accident · No injuriesData collectionFinal reportCessna 172 · Kennesaw, GAThe student pilot's failure to maintain directional control during landing roll that resulted in the on ground collision with the ground, and the subsequent collapse of the nose gear.NTSB SEA04LA110Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL · Mountain Home, IDThe pilot's failure to maintain aircraft control during an undetermined in-flight operational phase resulting in an uncontrolled descent into the terrain. Factors include strong gusty winds in the area of the accident.NTSB NYC04CA143Accident · No injuriesData collectionFinal reportStearman 4E · Loganton, PAThe pilot's failure to maintain aircraft control during the landing roll, which resulted in a nose over. A factor was uneven terrain.NTSB MIA04WA110Accident · No injuriesForeign investigationCessna 402B · Bonaire, NTNTSB IAD04FA025Accident · 2 fatalField investigationFinal reportRobinson R-44 · Killingly, CTThe pilot in command's intentional flight into instrument meteorological flight conditions, and his failure to maintain obstacle clearance which resulted in a controlled descent into trees. Factors included the pilot's inadequate weather evaluation, low cloud…NTSB SEA04CA109Accident · Serious injuriesData collectionFinal reportBalloon Works Fire Fly 9 · Aurora, ORPilot's failure to compensate for wind conditions. Wind was a contributing factor.NTSB LAX04GA243Accident · 1 fatalFinal reportWSK PZL Mielec M-18A · St. George, UTThe pilot's failure to maintain an adequate airspeed margin, resulting in a stall and loss of control.NTSB LAX04CA242Accident · No injuriesData collectionFinal reportVans RV-9A · The Sea Ranch, CAthe pilot's inadequate compensation for gusty crosswind conditions and failure to maintain proper runway alignment, resulting in a collision with trees.NTSB FTW04LA164Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe separation of the right main landing gear wheel and axle during take-off. Contributing factors were the fatigue of the bolts on the right main landing gear and the rough and uneven terrain.NTSB CHI04FA157Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Great Bend, KSThe pilot's inadequate preflight planning due to his failure to obtain a weather briefing prior to takeoff. Additional causes were the pilot's inadvertent flight into adverse weather and his failure to maintain clearance with the terrain during his attempt to…NTSB SEA04LA108Accident · No injuriesLimited investigationFinal reportCessna 421B · Bend, OROn ground encounter with terrain during the takeoff roll as a result of the left side brake not operating. Inadequate maintenance inspection, overload of the nose landing gear and soft terrain were factors.NTSB SEA04FA106Accident · 1 fatalField investigationFinal reportNorth American SNJ 5 · Oroville, WAThe pilot's failure to maintain adequate terrain clearance, which resulted in the in-flight collision with terrain. Rising terrain was a factor.NTSB SEA04CA107Accident · No injuriesData collectionFinal reportSteward Rocky 162F · Hood River, ORThe pilot's miscalculation of fuel consumption and his inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor was the high vegetation.NTSB SEA04CA105Accident · No injuriesData collectionFinal reportFetherolf Hatz CB-1 · Nampa, IDThe pilot's failure to maintain directional control of the tail wheel aircraft during an aborted landing. Factors include a slight tailwind, and a mound (berm) of earth in the area where the aircraft departed the side of the runway.NTSB NYC04LA141Accident · Minor injuriesLimited investigationFinal reportSchleicher ASK-21 · Warren, VTThe pilot's improper pre-flight and in-flight planning, which resulted in a forced landing after experiencing a loss of thermal lift. A factor was the loss of thermal lift.NTSB LAX04FA241Accident · 1 fatalField investigationFinal reportCessna 337 · Carson City, NVthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around that led to an inadvertent stall spin.NTSB FTW04CA163Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's improper recovery from a bounced landing.NTSB CHI04CA140Accident · No injuriesData collectionFinal reportCessna 150H · Mount Pleasant, MIThe pilot's improper decision to takeoff downwind from the rough field and his failure to maintain aircraft control. A factor to the accident was the rough/uneven alfalfa field and the tailwind experienced during the takeoff.NTSB ANC04LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · McGrath, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor contributing to the accident was the presence of soft tundra.NTSB NYC04LA142Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Norfolk, VAThe student pilot's failure to maintain control of the helicopter, which resulted ground resonance. Contributing to the accident was the improperly serviced landing gear dampers.NTSB MIA04WA098Accident · 1 fatalForeign investigationCessna 172 · Trinidad, BoliviaNTSB FTW04LA162Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Rush Springs, OKThe pilot's failure to maintain clearance with a utility pole and power lines while maneuvering during an aerial application.NTSB CHI04LA155Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · Waukegan, ILThe pilot's misjudgment of the landing flare which resulted in a hard landing. Contributing factors were the subsequent overload and collapse of the nose landing gear.NTSB NYC04WA222Accident · No injuriesForeign investigationBell 206B · Alice Springs, AustraliaNTSB MIA04LA097Accident · No injuriesLimited investigationFinal reportGulfstream American AA5B · Crystal River, FLThe failure of the number three cylinder exhaust valve which resulted in the partial loss of engine power. The pilot's misjudgment of speed and distance resulted in an overrun of the runway.NTSB DEN04LA091Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ogden, UTfracture and subsequent total failure of the nose gear strut. A contributing factor was the pilot not being able to control the airplane.NTSB DEN04LA090Accident · No injuriesLimited investigationFinal reportAircraft Mfg & Dev. Aleros CH 2000 · West Jordan, UTthe pilot's improper flare which resulted in a hard landing. Contributing factors were the low altitude and high airspeed, resulting in an unstabilized approach.NTSB ATL04LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-301 · Baxley, GAThe mechanical malfunction of the autopilot pitch servo, and the pilot's inability to maintain adequate control pressure to manually retrim the pitch attitude.NTSB ANC04FA063Accident · 1 fatalField investigationFinal reportBeech C-45H · Kodiak, AKThe pilot's failure to follow proper IFR procedures by not adhering to the published missed approach procedures, which resulted in an in-flight collision with tree-covered terrain. Factors contributing to the accident were a low ceiling, fog, rain, and the…