NTSB investigations, 2004
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 ATL04CA188Accident · Serious injuriesData collectionFinal reportCessna 172L · Kill Devil Hlls, NCAn in-flight encounter with a downdraft on final approach, which resulted in a loss of control of the airplane and subsequent collision with the ground.NTSB ANC04LA117Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Telida, AKA failure of the pilot-in-command to extend the landing gear, which resulted in a gear-up landing and structural damage to the airplane.NTSB ANC04LA110Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Slana, AKThe pilot's failure to compensate for wind conditions during landing, and his failure to maintain adequate airspeed, which resulted in a loss of control, and subsequent collision with trees during an uncontrolled descent. Factors contributing to the accident…NTSB FTW04TA237Accident · 1 fatalFinal reportBell OH-58C · Beaumont, TX**This probable cause was modified on 2/22/2016. Please see the public docket for this accident for additional details.** The pilot's failure to maintain a safe altitude, resulting in collision with the water. A factor was the dark night.NTSB DEN04CA143Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta 2 · Spanish Fork, UTthe pilot's failure to maintain adequate rotor rpm during a practice autorotation, and the flight instructor's improper flare. A contributing factor was the instructor's inadequate supervision of the pilot.NTSB CHI04IA260Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Chicago, ILAn in-flight collision with a flock of birds during climb out after takeoff, which damaged the left engine fan module and ruptured a fuel line to the fuel-oil cooler causing an engine fire.NTSB ATL04LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Inverness, FLThe improper installation of the carburetor which resulted in a loss of engine power and subsequent collision with trees during an emergency landing.NTSB NYC04LA213Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Somerville, NJThe pilot's failure to maintain aircraft control while landing. A factor was the pilot's impairment due to the influence of non-prescribed pain medication.NTSB MIA04FA135Accident · 4 fatalField investigationFinal reportCessna 336 · Magee, MSThe student pilot/ airplane owner's lack of training in night operations, which resulted in spatial disorientation, a loss of control, an uncontrolled descent, and an impact with trees.NTSB ATL04CA186Accident · No injuriesData collectionFinal reportCessna 172RG · Montgomery, ALThe separation of a hydraulic line for undetermined reasons, which resulted in a hydraulic fluid leak and malfunction of the landing gear.NTSB ATL04CA185Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Belle Glade, FLThe pilot's inadequate preflight inspection and a loss of engine power due to water contamination of the fuel.NTSB ANC04LA109Accident · No injuriesLimited investigationFinal reportCessna 140 · North Pole, AKThe pilot's failure to use carburetor heat during takeoff/initial climb, which resulted in a total loss of engine power, and an in-flight collision with trees.NTSB SEA04FA190Accident · 1 fatalField investigationFinal reportCessna U206F · Stanley, IDThe pilot's inadequate in-flight planning/decision which resulted in VFR flight into IMC, and his failure to maintain aircraft control.NTSB LAX04LA318Accident · Serious injuriesLimited investigationFinal reportBoeing 737-3H4 · Los Angeles, CAthe flight's encounter with the wake turbulence from a preceding heavy airplane while on approach.NTSB LAX04CA317Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Monterey, CAthe pilot's failure to maintain proper alignment with the taxiway and adequate obstacle clearance. A factor was the bright morning sunglare.NTSB FTW04LA238Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sweeny, TXThe fracture failure of the left engine crankshaft for undetermined reasons.NTSB DEN04LA142Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Spanish Fork, UTthe instructor's premature flare, resulting in a hard landing, and his failure to align the helicopter with the direction of travel, resulting in a rollover.Contributing factors were the low rotor RPM and inadequate airspeed. The reason for the loss of engine…NTSB SEA04LA189Accident · No injuriesLimited investigationFinal reportCessna P206A · Clearwater, IDA loss of engine power due to fatigue crack propagation of the number three piston pin while in cruise flight, leading to a power off forced landing in an open field. Factors include soft uphill terrain.NTSB SEA04FA188Accident · Serious injuriesField investigationFinal reportBeech A-36 · Auburn, WAThe pilot's failure to abort the takeoff early enough to allow him to stop the aircraft before it went off the departure end of the runway. Factors include the pilot's inadequate preflight procedures, water contamination in the fuel, a partial loss of power,…NTSB CHI04FA257Accident · 4 fatalField investigationFinal reportCessna 182T · Chesterfield, MOThe pilot not maintaining airspeed and the inadvertent stall he encountered during the go-around. A factor was the tree he impacted during his uncontrolled descent.NTSB CHI04CA258Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Detroit, MIThe student pilot's failure to maintain directional control of the airplane during the landing flare and subsequent go-around. A factor was the T-hangar.NTSB SEA04CA186Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Brooks, ORThe flight instructor's failure to maintain altitude/clearance on final approach to land resulting in an in-flight collision with terrain. Contributing factors were the student pilot's failure to maintain adequate airspeed during the approach and the flight…NTSB NYC04LA210Accident · No injuriesLimited investigationFinal reportCessna 172B · Wiscasset, METhe failure of the oil filter adapter seal, which resulted in a loss of oil pressure, and subsequent catastrophic engine failure, and forced landing.NTSB NYC04LA209Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Oxford, CTThe pilot's improper recovery from a bounced landing.NTSB LAX04CA316Accident · No injuriesData collectionFinal reportSmith S-51D · Lancaster, CAthe pilot's misjudged landing flare, failure to correct the descent rate, and failure to execute a go-around during an unstablized landing approach.NTSB IAD04LA046Accident · 1 fatalLimited investigationFinal reportScott Rans S-12 · Seneca, NYThe student pilot's failure to maintain airspeed above stall speed, which resulted in an inadvertant stall/spin. A factor in the accident was the pilot's lack of pilot certification.NTSB CHI04LA256Accident · 1 fatalLimited investigationFinal reportClaxton S-12 · Oconomowoc, WIThe loss of engine power due to the seizure of the pistons and the pilot's failure to maintain airspeed which resulted in an inadvertent stall. The previous damage to the pistons due to earlier seizure occurrences was a factor.NTSB CHI04CA259Accident · No injuriesData collectionFinal reportSchroeder Wichawk · New Hudson, MIThe pilot failed to maintain directional control during takeoff roll. A factor was the VASI light.NTSB CHI04CA242Accident · No injuriesData collectionFinal reportAeronca Champion 7GCBC · Mullen, NEthe failure of the pilot to maintain direction control during gusty wind conditions on landing.NTSB ATL04LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18 · San Juan, PRThe pilot's failure to apply carburetor heat which resulted in carburetor ice and the subsequent loss of engine power. A factor was weather conditions favorable for carburetor ice.NTSB ATL04LA178Accident · 1 fatalLimited investigationFinal reportSchleicher K6-CR · LaGrange, GAThe pilot's failure to maintain control of the aircraft which resulted in a stall and subsequent impact with terrain. Factors were the pilot's impairment due to marijuana and his unreported mental conditions.NTSB ANC04LA106Accident · No injuriesLimited investigationFinal reportCessna 180A · Kasiloff, AKThe pilot's improper use of the carburetor heat control which resulted in carburetor ice and the loss of engine power. A factor associated with the accident was the carburetor icing conditions.NTSB ANC04CA108Accident · No injuriesData collectionFinal reportBailey Merlin GT · Kenai, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in an in-flight collision with terrain during the subsequent aborted landing. A factor associated with the accident was a gusty wind condition.NTSB SEA04LA187Accident · Minor injuriesLimited investigationFinal reportWSK PZL Warzawa-Okecie PZL-104 Wilga 80 · The Dalles, ORAircraft control was not maintained by the tow plane pilot and the glider pilot did not maintain a proper climb rate during the initial climb. A direct crosswind and wind gusts were factors.NTSB LAX04LA334Accident · No injuriesLimited investigationFinal reportBritish Aerospace BAE 125-1000A · San Francisco, CAAn electrical arc from an undetermined source initiated a hydraulic line rupture, which resulted in an equipment bay fire.NTSB IAD04WA047Accident · 3 fatalForeign investigationRobinson R44 · Vattlefjall, SwedenNTSB ATL04LA177Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Lake Wales, FLThe pilot's inadequate preflight planning and preparation, and his inadequate visual lookout, which resulted in a collision with a television tower.NTSB ATL04CA180Accident · No injuriesData collectionFinal reportWood/Thorpe T-18 · Olive Branch, MSThe pilot's failure to maintain directional control of the airplane during landing.NTSB ATL04CA179Accident · Minor injuriesData collectionFinal reportCessna 152 · Inverness, FLThe pilot's inadequate preflight inspection, and his failure to detect the presence of water in the fuel system, which resulted in a loss of engine power and subsequent collision with trees and terrain.NTSB NYC04LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Medina, OHThe partial loss of engine power due to inadequate maintenance and by failure to comply with service instruction for low engine compression.NTSB FTW04LA236Accident · 1 fatalLimited investigationFinal reportLancair 360 · Orange, TXThe pilot's failure to maintain adequate airspeed during takeoff resulting in an inadvertent stall and loss of aircraft control.NTSB CHI04LA254Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ancona, ILThe pilot became incapacitated (unconscious) for undetermined reasons which resulted in his inability to maintain altitude.NTSB CHI04LA253Accident · Serious injuriesLimited investigationFinal reportWilliams Glastar GS-1 · Hayward, WIThe pilot's failure to adequately compensate for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusty wind condition.NTSB CHI04FA255Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Park Falls, WIThe flightcrew's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with water during approach. The low altitude was a factor in the accident.NTSB ATL04LA181Accident · Minor injuriesLimited investigationFinal reportHughes HU-369-D · Waynesboro, GAThe tail rotor assembly failed due to a fatigue fracture of the input gearshaft in the tail rotor gearbox assembly, which resulted in a loss of tail rotor control and subsequent collision with trees.NTSB ATL04LA176Accident · 2 fatalLimited investigationFinal reportLemoine Marvin J. Jr. Christian Eagle II · Cleveland, GAThe pilot's failure to maintain clearance from trees while conducting aerobatic maneuvers.NTSB ATL04CA192Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Miami, FLThe pilot's failure to follow the after landing check list, which resulted in his inadvertent gear retraction during landing roll.NTSB ATL04CA184Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mount Pleasant, SCGround collision with an animal (deer) during an attempted takeoff.NTSB ATL04CA182Accident · No injuriesData collectionFinal reportMaule M4-210C · Gainesville, FLThe pilot-rated passenger's inadvertent interference with the flight controls during landing, which resulted in a loss of control and the airplane nosed over.NTSB WAS04WA015Accident · 6 fatalForeign investigationCessna 210 · Livingstone, Zambia