NTSB investigations, 2004
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 NYC05LA024Accident · No injuriesLimited investigationFinal reportCessna 172R · Martinsburg, WVA loss of engine power for undetermined reasons.NTSB NYC05LA020Accident · Serious injuriesLimited investigationFinal reportUnknown Sky Raider · Rappahannock Ac, VAThe uncertificated pilot's failure to maintain airspeed, which resulted in a stall, and collision with terrain. A factor in this accident was the pilot's lack of total flight experience.NTSB NYC05CA019Accident · No injuriesData collectionFinal reportVigneau RAF 2000 GTX · Chatham, MAThe pilot's failure to maintain aircraft control during a takeoff. A factor related to the accident was the pilot's lack of experience in gyroplanes.NTSB MIA05CA032Accident · Serious injuriesData collectionFinal reportCessna 172B · Zephyrhills, FLThe pilot's failure to set the parking brake and his improper starting procedure which resulted in an unattended aircraft running away after hand starting the engine and the airplane colliding with parked airplanes, incurring substantial damage.NTSB IAD05LA013Accident · No injuriesLimited investigationFinal reportCessna 172E · Rupert, WVThe pilot’s delayed application of carburetor heat, which resulted in a rough running engine. A factor was the bulldozer on the logging road where the pilot performed a precautionary landing.NTSB DEN05IA027Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Denver, COthe first officer's failure to maintain proper glide slope during the landing approach, and the captain's failure to adequately monitor the approach and landing, and his failure to challenge and/or intervene when the first officer continued to descend below…NTSB DCA05RA010Accident · 55 fatalForeign investigationBombardier CRJ-200 · Baotou, ChinaNTSB CHI05CA035Accident · No injuriesData collectionFinal reportCessna 172S · Anderson, INThe student pilot's improper flare and his inadequate recovery from a bounced landing.NTSB CHI05CA032Accident · Serious injuriesData collectionFinal reportOlson Sonex · Oconomowoc, WIThe loss of engine power due to a fatigue fracture of the crankshaft. An additional cause to the accident was the pilot/builder's failure to verify the dimensions of the shrink-fit crankshaft components prior reassembling the engine. A factor to the accident…NTSB LAX05LA038Accident · No injuriesLimited investigationFinal reportBeech 99 · Phoenix, AZthe pilot's inadequate visual lookout and failure to maintain clearance from obstacles while taxing in a nonmovement area at night.NTSB DEN05LA028Accident · No injuriesLimited investigationFinal reportFarrell Lancair LC3 · Las Cruces, NMthe pilot's failure to maintain directional control during takeoff.NTSB CHI05CA034Accident · No injuriesData collectionFinal reportCessna 172N · Lakeville, MNThe pilot misjudged his distance and speed which resulted in an overrun.. Factors were the wet runway, the grass and the berm.NTSB ATL05CA027Accident · Serious injuriesData collectionFinal reportBeech A36TC · Huntsville, ALThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation and a forced landing to an open field.NTSB IAD05CA014Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe pilot's improper decision to taxi on a closed taxiway, and his misjudgment of obstacle clearance.NTSB ANC05LA015Accident · No injuriesLimited investigationFinal reportCessna U206F · Bethel, AKThe pilot's inadequate evaluation of the weather conditions, and his inadequate compensation for the wind conditions, which resulted in a loss of control and subsequent nose over during taxi from landing. A factor contributing to the accident was a tailwind.NTSB MIA05WA031Accident · 4 fatalForeign investigationBritish Aerospace 3101 · Caracas, VenezuelaNTSB MIA05CA047Accident · No injuriesData collectionFinal reportCessna TR182 · Vicksburg, MSThe pilot's failure to extend the landing gear which resulted in a wheels up landing. A contributing factor is the pilot's failure to complete the checklist.NTSB IAD05CA015Accident · No injuriesData collectionFinal reportSocata TB 21-TC · Binghamton, NYThe pilot's improper IFR procedure by his flight below the decision altitude, and his failure to maintain obstacle clearance.NTSB ATL05LA026Accident · Serious injuriesLimited investigationFinal reportGolden Circle Air T-Bird II · Dunlap, TNThe pilot's improper flare during forced landing following a loss of engine power for undetermined reasons, which resulted in a hard landing. A factor was the separation of a fuel line, which resulted in fuel starvation to the engine.NTSB MIA05CA030Accident · Minor injuriesData collectionFinal reportEnstrom F-28C · Panama City Bch, FLThe pilot's improper refueling of the helicopter resulting in loss of engine power do to fuel exhaustion and damage to the helicopter during the subsequent hard forced landing.NTSB LAX05FA035Accident · 3 fatalField investigationFinal reportCessna 337B · Drake, AZthe pilot's failure to maintain airspeed above stall speed while maneuvering at low altitude, which resulted in an accelerated stall and spin. A factor in the accident was the pilot's performance of maneuvering flight at an altitude insufficient to allow for…NTSB DEN05LA037Accident · No injuriesLimited investigationFinal reportCessna 172P · Loveland, COthe student pilot's failure to maintain directional control during landing and the student pilot's inadequate in-flight planning and decision making. Contributing factors include the quartering tail wind, the high airspeed, and the airport sign.NTSB ATL05IA025Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Peachtree City, GAThe failure of maintenance personnel to properly torque a fuel line fitting, which resulted in a fuel leak and in-flight engine fire.NTSB IAD05WA016Accident · No injuriesForeign investigationRobinson R-22B · Biggin Hill, United KingdomNTSB SEA05LA016Accident · Minor injuriesLimited investigationFinal reportHannah Avid Amphibian · Creswell, ORCarburetor icing and the failure of the pilot to maintain airspeed which resulted in a stall. Factors contributing to the accident included the lack of a carburetor heat system and the probability of carburetor ice.NTSB NYC05LA017Accident · 1 fatalLimited investigationFinal reportLabhart Kolb Twinstar Mk III · London, KYThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination. A factor was the lack of an installed fuel strainer.NTSB NYC05CA016Accident · Serious injuriesData collectionFinal reportSyreini Hipps J3 Kitten · Delaware, OHThe pilot's failure to maintain adequate altitude, which resulted in an in-flight collision with wires.NTSB MIA05FA028Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Dubbs, MSThe pilot's inadvertent flight into instrument meteorological conditions and his in-flight loss of control, resulting in overstress of the airframe and subsequent structural failure.NTSB LAX05FA034Accident · 2 fatalField investigationFinal reportBeech A36 · Lake Havasu, CAthe pilot's continued visual flight into instrument meteorological conditions leading to spatial disorientation and an in-flight loss of control.NTSB IAD05LA031Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Galloo Island, NYA partial loss of engine power for undetermined reasons. A factor was the pilot's improper decision to operate the helicopter outside the height velocity curve.NTSB DFW05FA020Accident · 5 fatalField investigationFinal reportPiper PA-31-350 · San Antonio, TXThe pilot's failure to maintain control during an ILS approach. Contributing factors were the prevailing instrument meteorological conditions( clouds, low ceiling and drizzle/mist), and the pilot's spatial disorientation.NTSB DEN05LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Lyons, COthe pilot's inadequate in-flight planning/decision by his intentional VFR flight into IMC, and his failure to maintain obstacle clearance.NTSB CHI05LA028Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340B · Milwaukee, WIFailure of the ramp employee to maintain clearance to the rotating propeller resulting in inadvertent contact with a propeller blade.NTSB ATL05LA023Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Sewanee, TNThe pilot's improper flare during landing, which resulted in the overload and collapse of the nose landing gear and subsequent on-ground loss of control of the airplane (aircraft control not possible) and collision with a parked airplane.NTSB ATL05CA024Accident · No injuriesData collectionFinal reportCessna 172N · Wilmington, NCThe student pilot's failure to recognize the proper emergency procedure, which resulted in a precautionary landing in a field and subsequent collision with a ditch. Factors were the undetermined electrical malfunction, smoke in the cockpit, and the student…NTSB SEA05LA015Accident · No injuriesLimited investigationFinal reportLuscombe 11A · Redmond, ORThe student pilot's failure to maintain directional control during the landing roll. Also causal were the instructor's inadequate supervision and remedial action. Factors include soft terrain just off the side of the runway.NTSB MIA05LA029Accident · Serious injuriesLimited investigationFinal reportJoseph R. Sirgo Aquilla · Eustis, FLThe passenger's control interference, which resulted in a loss of control, and the airplane impacting a hangar during takeoff/initial climb.NTSB LAX05LA037Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · San Diego, CAthe flight instructor's failure to maintain directional control during the landing rollout.NTSB DEN05LA024Accident · No injuriesLimited investigationFinal reportBell 206B3 · Eureka, UTthe pilot's improper in-flight planning and decision making and failure to maintain obstacle clearance, resulting in contact with a power transmission line. Contributing factors include the intentional low-level maneuver, the power transmission line, and the…NTSB CHI05LA030Accident · 1 fatalLimited investigationFinal reportHedge Bede-4 · Omaha, NEThe pilot's failure to maintain control of the airplane resulting in a stall and spin, while on approach to land. Contributing factors were the airplane's low altitude and low airspeed at the time of loss of control.NTSB CHI05CA031Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Sikeston, MOThe pilot not maintaining his visual lookout and not maintaining clearance from the pole during his taxi to park from a landing. A factor was the pole he impacted.NTSB CHI05CA029Accident · Minor injuriesData collectionFinal reportGray Skybolt · St. Clair, MIThe pilot's improper spin recovery procedure, which resulted in a failure to maintain control of the aircraft during the intentional spin. An additional cause was the pilot's inability to maintain clearance to the trees and terrain during recovery.…NTSB MIA05LA027Accident · No injuriesLimited investigationFinal reportCessna 170A · Opa Locka, FLThe pilot's improper landing flare/touchdown, which resulted in a hard landing.NTSB LAX05LA033Accident · No injuriesLimited investigationFinal reportCessna 210 · Apple Valley, CAloss of engine power due to fuel starvation/exhaustion, which was a result of the pilot's inadequate preflight inspection and failure to ensure there was enough fuel onboard for the flight.NTSB IAD05FA012Accident · 1 fatalField investigationFinal reportCessna P210 · Paint Lick, KYImproper alignment of a turbocharger oil line, which resulted in wear damage through the hose wall and a subsequent loss of engine oil. Contributing to the accident was the low cloud ceiling.NTSB DEN05IA025Incident · No injuriesIncident investigationFinal reportBlair-American USA · Fort Collins, COthe Blair-American and the Cessna pilot's inadequate visual lookout, and student pilot's failure to give right-of-way to a landing aircraft, which resulted in a runway incursion and subsequent collision. Contributing factors include the student instructor's…NTSB NYC05WA015Accident · 1 fatalForeign investigationRobinson R-22B · Bishopton, United KingdomNTSB MIA05WA023Accident · 5 fatalForeign investigationCessna 310 · San Salvador, El SalvadorNTSB LAX05FA032Accident · 3 fatalField investigationFinal reportPiper PA-32R-301T · Santa Barbara, CAThe pilot's failure to select and maintain an adequate terrain avoidance cruise altitude. Contributing factors were the dark nighttime conditions, the rising mountainous terrain, and the Federal Aviation Administration controller's failure to issue a…NTSB LAX05CA031Accident · Minor injuriesData collectionFinal reportCessna P210N · North Las Vegas, NVthe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. Also causal was the pilot's inadequate preflight planning/preparation which failed to assure an adequate fuel supply.