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 LAX04LA141Accident · No injuriesLimited investigationFinal reportVogt KR2S · Lompoc, CAa failure of the fuel pump, which induced a total loss of engine power.NTSB LAX04LA140Accident · No injuriesLimited investigationFinal reportAlan Wilson Tandum Air Bike · Elko, NVA total loss of engine power during cruise flight due to the failure of an ignition system component.NTSB FTW04LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Angleton, TXThe unqualified person's failure to maintain clearance with the power lines. A contributing factor was the night light conditions.NTSB ATL04FA079Accident · 2 fatalField investigationFinal reportCessna 210 · Blountville, TNThe pilot's improper flare, and improper recovery which resulted in a bounced landing, collapse of the left main landing gear, and the pilot's failure to maintain airspeed while maneuvering resulting in a stall, uncontrolled descent, and collision with the…NTSB ANC04LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-15 · Big Lake, AKAn in-flight loss of control for an undetermined reason, which resulted in a forced landing and in-flight collision with trees.NTSB SEA04WA047Accident · No injuriesForeign investigationSikorsky SK-64 · Bintutu, MalaysiaNTSB SEA04LA046Accident · Minor injuriesLimited investigationFinal reportJerome Q-2 · Hillsboro, ORThe pilot's inadequate evaluation of deteriorating weather conditions (increasing rain) and his failure to maintain the proper rate of descent on landing (long/hard touchdown). Contributing factors were carburetor icing conditions and rain.NTSB NYC04LA078Accident · 1 fatalLimited investigationFinal reportRaven Industries Rally RX7 · Nicholasville, KYThe pilot's improper decision to continue the inadvertent flight in variable wind conditions, which resulted in an impact with power lines. Factors were the variable wind conditions and the unsuitable takeoff area.NTSB LAX04FA139Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Pine Mtn Club, CAThe pilot's continued visual flight into adverse weather conditions at night, which resulted in an in-flight collision with mountainous terrain. The pilot's failure to obtain preflight weather information for the route of flight was also causal.NTSB LAX04CA145Accident · No injuriesData collectionFinal reportCessna 120 · Red Bluff, CAthe pilot's inadequate compensation for the wind condition and failure to maintain directional control during the landing roll on a narrow runway. A contributing factor were the gusty tailwind conditions.NTSB IAD04LA013Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Media, PAA lack of previous lubrication to the tail rotor drive shaft forward fitting teeth, which resulted in their gradual wear, the eventual slippage of the shaft, and the subsequent loss of tailrotor thrust and forced landing.NTSB FTW04LA086Accident · No injuriesLimited investigationFinal reportLake LA4-270T · Crowley, LAThe pilot's inadvertant water landing with the landing gear extended. Contributing factors were the sunglare and the pilot's failure to verify the position of the flaps and landing gear.NTSB FTW04CA084Accident · Minor injuriesData collectionFinal reportCessna T210M · Grape Creek, TXThe pilot's improper in-flight planning, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain available for the forced landing.NTSB CHI04LA082Accident · No injuriesLimited investigationFinal reportAlon A2 Ercoupe · Hawley, MNThe loss of engine power for undetermined reasons. A contributing factor was the fence post.NTSB CHI04LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Bourbon, INThe inadequate annual inspection in that the worn brake disks were not replaced which resulted in diminished braking capability during the landing roll. A factor associated with the accident was the utility pole that the airplane contacted.NTSB CHI04LA079Accident · No injuriesLimited investigationFinal reportRobinson R44 · Burlington, WIThe pilot's inadequate visual lookout and his failure to obtain/maintain clearance from the transmission wire during the takeoff. Factors contributing to the accident were the transmission wire and the pole.NTSB ATL04LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Collegedale, TNThe pilot's inability to maintain directional control due to the inadequate grounding of the nose wheel steering clutches, as a result of inadequate maintenance inspection by other maintenance personnel to ensure the nose wheel steering clutches were…NTSB NYC04FA077Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Corry, PAThe loss of partial engine power for undetermined reasons, and the pilot's lost of control after performing an evasive maneuver to avoid trees during a forced landing at night. Factors related to the accident were a rough running engine and the pilot's…NTSB FTW04FA083Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Wrightsville, ARThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin on the downwind leg of the traffic pattern.NTSB CHI04LA081Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Jackson, MIThe left main tire failed which resulted in the CFI's inability to maintain directional control of the airplane during the landing. A factor associated with the accident was the snow bank which the airplane contacted.NTSB DCA04RA024Accident · 9 fatalForeign investigationBeech 200 · Bosnia, Bosnia & HerzegovinaNTSB CHI04LA078Accident · No injuriesLimited investigationFinal reportCessna R182 · Elberfeld, INThe in-flight and on-ground fires in the cabin and engine compartment for undetermined reasons during the flight's cruise and emergency landing.NTSB CHI04LA077Accident · No injuriesLimited investigationFinal reportSaab-Scania Saab 340B · Romulus, MIThe visual lookout not maintained and the procedures not followed by the Push Tug Operator during the pushback. Factors were the parked airplane, the dark night, and the inadequate surveillance of the pushback by airline management.NTSB SEA04LA044Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Laurel, MTThe student pilot's failure to maintain aircraft control during the landing roll. Inadequate remedial action was a factor.NTSB SEA04IA045Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Seattle, WAThe First Officer's misidentification of the parallel taxiway as the active runway, resulting in the need for a sidestep maneuver while on short final for a full-stop landing. Factors include sun-glare from wet paved surfaces, a visual illusion created by the…NTSB NYC04LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Spencer, MAA loss of engine power for undetermined reasons.NTSB SEA04LA043Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1H · Liberty, WAThe failure of the tail rotor slider lugs due to fatigue while the helicopter was maneuvering.NTSB NYC04CA076Accident · No injuriesData collectionFinal reportCessna 172N · Youngstown, OHAn inadvertent collision with a deer while landing.NTSB FTW04LA080Accident · 1 fatalLimited investigationFinal reportGrumman G-164C · Hazen, ARThe pilot's loss of control while maneuvering during an aerial application flight for undetermined reasons.NTSB ATL04FA077Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Arlington, ALThe pilots inadequate in-flight planning/decision and his failure to maintain aircraft control, resulting in an in-flight encounter with a thunderstorm and exceeding the design limits of the aircraft.NTSB IAD04CA012Accident · No injuriesData collectionFinal reportCessna 182P · Titusville, PAThe pilot's failure to maintain directional control during the landing roll. A factor in the accident was the snow bank.NTSB FTW04LA081Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Claremore, OKThe loss of engine power due to fuel contamination (water). A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04FA079Accident · 1 fatalField investigationFinal reportCessna 210N · Valley Spring, TXThe pilot's continued flight into known adverse weather and failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, due to spatial disorientation.NTSB ANC04LA027Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Bradenton, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. Also causal was the pilot's failure to maintain adequate rotor speed, resulting in a hard landing.NTSB LAX04LA132Accident · 1 fatalLimited investigationFinal reportGillespie Sport Copter Vortex · Yuba City, CAa loss of engine power due to the incorrect installation of the fuel line, which resulted in fuel starvation, and the pilot's failure to maintain rotor RPM, which resulted in an inflight loss of control. A factor to the accident was the pilot's lack of…NTSB CHI04LA075Accident · No injuriesLimited investigationFinal reportCessna 120 · Merrill, WIThe pilot's selection of unsuitable terrain to conduct a landing. Factors were the reported flat light conditions and the uneven terrain.NTSB ATL04LA076Accident · No injuriesLimited investigationFinal reportBell 206 · Locust Grove, GAThe pilot's failure to maintain directional control of the helicopter while lifting off a dolly to a hover. This resulted in the tail rotor blades and main rotor blades colliding with the ground and subsequent roll over.NTSB ANC04LA029Accident · No injuriesLimited investigationFinal reportCessna 172P · Lutz, FLThe student pilot's misjudged landing flare, which resulted in a hard landing and subsequent collapse of the nose landing gear.NTSB ANC04FA026Accident · Serious injuriesField investigationFinal reportGates Learjet 25B · Ft. Lauderdale, FLThe pilot in command's misjudged distance/speed while landing, and the flightcrew's failure to follow prescribed emergency procedures, which resulted in a runway overrun and subsequent collision with a building. Factors associated with the accident are the…NTSB SEA04LA042Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Longview, WAFuel exhaustion while maneuvering, as a result of the pilot's inadequate in-flight decision/planning, leading to his failure to refuel the airplane prior to running out of fuel. A ditch was a factor.NTSB LAX04WA164Accident · 1 fatalForeign investigationRobinson R22M · Kumealon Inlet, CanadaNTSB LAX04IA133Incident · No injuriesIncident investigationFinal reportEurocopter AS 350B · Las Vegas, NVthe tail rotor pitch change lever failed in fatigue due to improper installation by company maintenance personnel.NTSB DCA04WA051Accident · No injuriesForeign investigationRaytheon Corporate Jets 390 Premier I · Cannes, FranceNTSB LAX04WA129Accident · 1 fatalForeign investigationAero Commander 500 · Hobart Tasmania, AustraliaNTSB LAX04IA135Incident · No injuriesIncident investigationFinal reportBell 407 · Madera, CAthe failure of the number 6 hangar bearing due to overheating. A factor in the accident was the operator's likely inadequate compliance with service bulletins and airworthiness directives on this issue, along with an inadequate maintenance inspection program…NTSB FTW04LA082Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Ville Platte, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04IA078Incident · No injuriesIncident investigationFinal reportBeech C90 · Oklahoma City, OKThe failure of the right main landing gear to extend due to an improperly installed attachment bolt by other maintenance personnel.NTSB FTW04GA076Accident · Minor injuriesFinal reportSchweizer 269D · San Antonio, TXThe loss of engine power due to the axial movement of the compressor rotor blades contacting the compressor vanes resulting in a subsequent compressor stall. A contributing factor was the improper assembly of the compressor section during the engine overhaul…NTSB CHI04LA083Accident · No injuriesLimited investigationFinal reportCessna 195 · Manitowoc, WIThe Cessna 195 pilot's failure to maintain clearance from the Cessna 177RG while taxiing to the ramp after landing. A contributing factor was the restricted forward visibility (blind spot) of the Cessna 195 due to the engine cowling. An additional factor was…NTSB ANC04LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Clewiston, FLThe student pilot's misjudged landing flare, which resulted in a hard landing, a collapse of the nose wheel landing gear, and the airplane nosing over when it encountered a ditch.