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 CHI04LA279Accident · Serious injuriesLimited investigationFinal reportErnst Pitts S2E · Hanover, INThe pilot's failure to maintain clearance to the trees and terrain during the aerobatic maneuver. Contributing factors were the pilot's decision to perform a low-level, ostentatious aerobatic display and the trees.NTSB CHI04CA291Accident · No injuriesData collectionFinal reportJohnson Titan Tornado I · Carlton, MNThe pilot's failure to abort the takeoff. Factors to the accident included the diminished takeoff performance due to the incorrect propeller pitch setting and the tree that the airplane impacted.NTSB CHI04CA287Accident · No injuriesData collectionFinal reportCessna 182P · Washington, MOThe misjudged flare by the student pilot and the inadequate supervision by the flight instructor. A factor was the overload failure of the nose landing gear.NTSB ANC04LA120Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nenana, AKThe loss of engine power during takeoff-initial climb for an undetermined reason, which resulted in an emergency descent and hard landing.NTSB ANC04CA114Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Willow, AKThe pilot's selection of an unsuitable landing area, which resulted in an on-ground collision with trees during the landing roll. A factor associated with the accident were trees.NTSB NYC04LA219Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-22A · Richmond, VAThe pilot's inadequate preflight inspection which resulted in fuel contamination and a subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain airspeed while attempting a forced landing which resulted in an inadvertent…NTSB NYC04CA216Accident · Minor injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · New Milford, CTThe pilot's improper flair, which resulted in a nose over.NTSB CHI04LA278Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Gwinner, NDThe pilot's failure to maintain altitude during the circling maneuver. Contributing factors were the pilot's improper decision to execute the approach when weather conditions were below minimums and the low light (dark night) conditions.NTSB ATL04WA194Accident · 3 fatalForeign investigationPiper PA-28-181 · Nordhorn-Lingen, GermanyNTSB SEA04CA193Accident · No injuriesData collectionFinal reportPiper PA-28 · Deer Harbor, WAThe pilot's failure to perform remedial action during the landing sequence. A factor contributing to the accident was the wet runway surface.NTSB MIA04FA128Accident · 4 fatalField investigationFinal reportCessna R182 · Milton, FLThe pilots operation of the airplane with known deficiencies in the equipment based on witness statements describing an excessive rpm drop and rough running engine after starting, during the engine run-up, and after becoming airborne, his failure to abort the…NTSB FTW04FA243Accident · 2 fatalField investigationFinal reportCessna 421C · Bee Caves, TXThe pilot's improper positioning of the fuel selector valves, which resulted in a loss of power to the left engine due to fuel exhaustion. After the power loss, the pilot failed to follow checklist procedures and did not secure (feather) the left propeller,…NTSB FTW04CA240Accident · No injuriesData collectionFinal reportCarter-Jones Volmer Sportsman · Grand Prarie, TXThe pilot's failure to complete a pre-landing checklist, which resulted in a gear down landing on the water. A factor was the pilot's diverted attention as a result of abnormal engine indications.NTSB CHI04WA277Accident · 1 fatalForeign investigationPiper PA-28-181 · Wilhelmshausen, GermanyNTSB CHI04CA281Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jackson, MICollision with a deer when it crossed the airplane's path during landing rollout. Factors were low lighting (night) conditions and the pilot's inability to maintain directional control due to the collision.NTSB ANC04LA113Accident · Serious injuriesLimited investigationFinal reportBritten-Norman BN-2A · Kodiak, AKThe pilot's inadequate compensation for wind conditions, and his intentional flight into adverse weather conditions, which resulted in a loss of control and collision with terrain during takeoff-initial climb. Factors contributing to the accident were high…NTSB LAX04LA328Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Flagstaff, AZthe pilot's improper leaning procedures and delayed decision to abort the takeoff when it became obvious that the engine was not developing full power. A factor in the accident was the pilot's decision to use a runway with a quartering tailwind.NTSB IAD04LA048Accident · Minor injuriesLimited investigationFinal reportBoeing A75N (PT17) · Bayport, NYThe failure of a magneto, which resulted in a loss of engine power. Factors in the accident were the pilot's decision to take off downwind, which resulted in reduced airplane performance, and the tail wind.NTSB DEN04LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Provo, UTthe pilot's premature liftoff which resulted in failure to attain airspeed which resulted in a stall.NTSB ATL04CA191Accident · Serious injuriesData collectionFinal reportPinkham Challenger II · Lancaster, SCA partial loss of engine power in-flight due to water ingestion and his misjudgment of obstacle clearance resulting in a collision with trees and the ground. A factor in the accident was the pilot's failure to follow the manufactures instructions for…NTSB FTW04CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Haskell, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB DEN04LA146Accident · No injuriesLimited investigationFinal reportSmith Aerostar 601P · Lordsberg, NMaircraft control not maintained by the pilot. Contributing to the accident was the dirt devil/whirlwind.NTSB CHI04LA265Accident · Serious injuriesLimited investigationFinal reportKenny Mariner-MF Boat · Eagle River, WIThe pilot's inability to maintain control of the aircraft during flight for undetermined reasons.NTSB ATL04FA190Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Euharlee, GAThe pilot's failure to maintain adequate control of the airplane, which resulted in the pilot exceeding the design limits of the airplane and subsequent in-flight separation.NTSB SEA04LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Seattle, WAThe failure of the pilot to maintain clearance with the parked airplane while taxiing. A factor contributing to the accident was the pilot's inadequate preflight planning.NTSB SEA04GA192Accident · 3 fatalFinal reportCessna U206G · Essex, MTThe pilot's misidentification of the airplane's location, which resulted in his improper decision to fly into the wrong drainage, and his failure to maintain terrain clearance while executing a turn to reverse course after he realized his navigational error.…NTSB LAX04CA326Accident · No injuriesData collectionFinal reportIar Sa Brasov 823 · Denair, CAthe pilot's failure to verify the fuel quantity on board prior to departure, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB CHI04LA262Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Knox, INA loss of engine power for undetermined reasons. Contributing to the accident were the unsuitable terrain encountered, the dark night conditions, and the ditch.NTSB ANC04FAMS2Accident · 5 fatalMissing aircraftFinal reportde Havilland DHC-2 · Sitka, AKReason for occurrence is undetermined. The airplane is missing.NTSB SEA04FA191Accident · 1 fatalField investigationFinal reportCessna 172D · Mountain Home, IDThe pilot's failure to maintain clearance from high terrain while maneuvering. High terrain was a factor.NTSB NYC04WA215Accident · 1 fatalForeign investigationRobinson R-44 · Kentallen, Scot, United KingdomNTSB NYC04LA214Accident · Serious injuriesLimited investigationFinal reportRyan ST3KR · Bealeton, VAThe improper installation of fuel lines by maintenance personnel resulting in a total loss of engine power.NTSB LAX04LA324Accident · No injuriesLimited investigationFinal reportCirrus SR-22 · Peters, CAThe pilot's decision to continue flight into adverse weather and the subsequent encounter with the outer boundaries of a level 5 thunderstorm, which resulted in his loss of control of the airplane.NTSB IAD04WA049Accident · 4 fatalForeign investigationCessna 182R · Montreux, SwitzerlandNTSB FTW04CA241Accident · No injuriesData collectionFinal reportPiper J3C-65 · Louise, TXThe pilot's inadvertent positioning of the fuel shutoff valve resulting in the fuel starvation of the engine and the subsequent loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DCA04MA082Accident · No injuriesMajor investigationFinal reportBoeing MD-11 · Memphis, TNThe pilot's over-rotation during a go-around maneuver initiated because of a bounced landing. The go-around maneuver was initiated at a low speed and high pitch angle, and after reverse thrust was selected, contrary to Boeing and FedEx training guidance.NTSB CHI04WA294Accident · No injuriesForeign investigationLake LA-4-200 · Kolari, FinlandNTSB CHI04WA263Accident · 1 fatalForeign investigationRobinson R-44 · Appin, ScotlandNTSB MIA04CA130Accident · No injuriesData collectionFinal reportLemuel May Leza-Lockwood Aircam · Ashland, MSThe pilot's inadequate preflight planning/preparation for his failure to assure that the fuel shutoff valves located in both engine compartments were turned on and also the failure of the pilot to have a checklist to outline preflight items.NTSB LAX04LA322Accident · 2 fatalLimited investigationFinal reportWolf Glassair IIS · Mesa, AZa partial loss of power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering for a forced landing that resulted in a stall and a collision with terrain.NTSB LAX04CA323Accident · No injuriesData collectionFinal reportAero Commander S2R · Firebaugh, CAthe failure of the pilot to maintain clearance from high tension wires in dark night conditions. The reason for the loss of engine power after the wire collision was not determined.NTSB LAX04CA321Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kona, HIthe CFI's failure to maintain an adequate airspeed and main rotor rpm, and his improper flare, which resulted in a hard landing. A factor in the accident was the CFI's diverted attention.NTSB CHI04LA283Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Houstonia, MOThe fatigue failure of the piston end of the connecting rod and the pilot's failure to maintain aircraft control during the forced landing.NTSB CHI04LA264Accident · Minor injuriesLimited investigationFinal reportCessna 401 · New Century, KSA loss of engine power due to fuel starvation and the pilot's failure to maintain directional control during approach to an alternate airport. Contributing to the accident was the pilot's failure to obtain a weather briefing, his flight into adverse weather,…NTSB CHI04CA296Accident · No injuriesData collectionFinal reportPiper PA-16 · Port Huron, MIThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the overload failure of the right main landing gear.NTSB CHI04CA266Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Hurdland, MOThe pilot's failure to maintain proper airspeed and directional control during the takeoff and his failure to properly abort the takeoff after the encountered tailstrike. A factor to the accident was the stall/mush encountered during the attempted takeoff and…NTSB CHI04CA261Accident · No injuriesData collectionFinal reportAbbott RAF 2000 · Pontiac, MIThe partial loss of engine power due to the scoring and overheating of the cylinders as a result of the pilot/owner's improper servicing of the modified engine cooling system. Additional factors included the pilot/owner modifying and servicing the engine…NTSB LAX04LA320Accident · Serious injuriesLimited investigationFinal reportHebb Avid Magnum · Bridgeport, CAthe pilot's failure to adequately compensate for the crosswind condition and his failure to maintain an adequate airspeed while using crossed controls, which led to a stall.NTSB FTW04CA239Accident · No injuriesData collectionFinal reportCessna 150L · Mountain Home, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB DEN04LA145Accident · No injuriesLimited investigationFinal reportBell 214B-1 · Aspen, COthe inadvertent activation of the engine's fuel shut off valve, resulting in the reduction of engine power to 50 percent due to an improper cannon plug wire repair on the engine's wire harness assembly. Contributing factors include the improper wire repair,…