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 LAX04LA206Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Carson City, NVthe pilot's failure to maintain directional control during an aborted touch-and-go landing.NTSB LAX04FA207Accident · 3 fatalField investigationFinal reportPiper PA-44-180 · Wittmann, AZThe flight instructor's failure to maintain sufficient airspeed to avoid a stall/spin while maneuvering the airplane with a dual student.NTSB LAX04CA208Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe backhoe driver's failure to maintain visual lookout while maneuvering near a taxiway, which resulted in its collision with a taxiing airplane.NTSB ATL04CA115Accident · Minor injuriesData collectionFinal reportLoehle Ent. 2/3 Earlybird Jenny · Grantham, NCThe loss of engine power for undetermined reasons.NTSB SEA04LA082Accident · 1 fatalLimited investigationFinal reportKaman K-1200 · West Fork, ORThe pilot's failure to maintain adequate clearance with trees during logging operations. Contributing factors were the trees, mountainous (steeply sloped) terrain, and the pilot's decision to conduct operations in this terrain with a 200 foot long line.NTSB NYC04CA132Accident · Minor injuriesData collectionFinal reportAviat A-1B · Halifax, MAThe pilot's inadequate flare during landing, which resulted in an in-flight collision with water. A factor was the glassy water conditions.NTSB MIA04WA083Accident · 5 fatalForeign investigationCessna 206C · Guaviare, ColombiaNTSB MIA04LA082Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Lake Worth, FLThe loss of engine power for undetermined reasons which resulted in a forced landing, collision with a berm during landing rollout, and the airplane nosing over.NTSB CHI04LA119Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Winsted, MNThe failure of the main rotor drive belts for an undetermined reason, and the pilot's misjudged flare during the autorotation.NTSB LAX04FA205Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Julian, CAThe incorrect use of an abbreviated callsign by the TRACON sector radar controller to issue a descent clearance to N434PA and the sector controllers failure to detect that the clearance had been read back with the full callsign by the pilot of N304PA. Also…NTSB FTW04IA147Incident · 1 fatalIncident investigationFinal reportBell 206L-1 · Smi-28Incapacitation of the pilot due to a heart attack.NTSB ATL04LA112Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Cortland, ALThe pilot's misjudgment of distance/altitude and his failure to maintain obstacle clearance which resulted in an undershoot and collision with trees.NTSB ATL04IA138Incident · No injuriesIncident investigationFinal reportCessna 172RG · Chamblee, GAThe fatigue fracture of the nosewheel bungee assembly, which restricted the movement of the elevator control. A factor was the inadequate equipment from an unknown source/manufacturer.NTSB ANC04LA053Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350B2 · Skagway, AKA loss of engine power during cruise flight for an undetermined reason, which resulted in a ditching and submersion of the helicopter when the emergency float system did not deploy. Factors contributing to the accident were improper rigging of the mechanical…NTSB SEA04LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Battle Ground, WAThe student pilot's misjudgment of distance and his failure to do a go-around. Also causal was the instructor's inadequate supervision of the flight. Factors include gusty crosswinds, the dual student's failure to adequately compensate for those winds, a wet…NTSB MIA04IA088Incident · No injuriesIncident investigationFinal reportBeech A36 · Daytona Beach, FLImproper maintenance/installation by the propeller overhaul/repair facility, which resulted in stress related fatigue and the eventual separation of the propeller pitch change pin.NTSB FTW04WA126Accident · 1 fatalForeign investigationCessna 172M · Curico, ChileNTSB FTW04LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Oil City, LAA loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed resulting in a stall..NTSB SEA04LA080Accident · Minor injuriesLimited investigationFinal report2003 Nash Kitfox II · Broadview, MTFuel starvation during cruise flight for undetermined reasons. Unsuitable terrain for a forced landing was a factor.NTSB NYC04LA119Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Morrisville, VTThe improper installation of an electrical wire, which resulted in arching and the initiation of a fuel vapor explosion. A factor related to the accident was the failure of maintenance personnel to detect a cracked rubber fuel vent line nipple.NTSB FTW04LA123Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA-40 · Georgetown, TXThe failure of both pilot's to maintain an adequate visual lookout, which resulted in a midair collision between the two airplanes.NTSB DCA04MA045Accident · Serious injuriesClass 1 · MajorFinal reportATR 72 · San Juan, PRthe captain's failure to execute proper techniques to recover from the bounced landings and his subsequent failure to execute a go-around.NTSB CHI04CA118Accident · No injuriesData collectionFinal reportPiper PA-12 · Hartford, WIThe loss of engine power for undetermined reasons. A factor to the accident was the soft terrain encountered during the forced landing.NTSB SEA04LA196Accident · No injuriesLimited investigationFinal reportDornier DO27A4 · Marion, MTThe pilot's improper landing flare resulting in a hard landing.NTSB NYC04LA120Accident · No injuriesLimited investigationFinal reportCessna 170B · Shirley, NYThe pilot's inadequate pre-flight inspection, which resulted in his failure to remove the engine inlet covers and subsequent loss of engine power.NTSB MIA04LA081Accident · No injuriesLimited investigationFinal reportBeech A23A · Crystal River, FLThe pilots failure to maintain directional control during the landing rollout, which resulted in the airplane departing the runway and incurring damage.NTSB LAX04LA203Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Reno, NVthe pilot's failure to maintain an adequate airspeed margin while performing a return to runway maneuver, which led to a stall and spin. Factors in the accident were: 1) the deteriorated condition of the glider towrope, which resulted in towrope failure…NTSB IAD04LA020Accident · No injuriesLimited investigationFinal reportTaylorcraft BC · Cumberland, MDThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall into transmission lines.NTSB FTW04LA127Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 · Brinkley, ARThe pilots failure to attain flying airspeed after takeoff. A factor was the overloading of agricultural chemicals that exceeded the airplane's maximum takeoff weight.NTSB FTW04LA124Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Fort Stockton, TXThe pilot's improper leaning of the fuel/air mixture in-flight, which resulted in a loss of engine power. Factor were the wind gusts and the crosswind.NTSB DEN04LA071Accident · Serious injuriesLimited investigationFinal reportCessna A185E · Englewood, COthe pilot's inadequate preflight planning which failed to verify an adequate fuel supply and his inadequate in-flight planning/decision which resulted in fuel exhaustion. The inadequate indication of his fuel quantity system is a contributing factor.NTSB CHI04CA117Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · DeKalb, ILThe failure of the pilot and his flight instructor to identify the location of the relocated threshold and proper touchdown point, which resulted in the airplane striking the construction barricade while on approach. A factor to the accident was the…NTSB CHI04CA116Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Genesee Depot, WIThe pilot's failure to maintain proper rotor RPM during the hover landing and his inadequate remedial action, which resulted in the hard landing.NTSB CHI04CA115Accident · No injuriesData collectionFinal reportVilleneuve RV-3 · Mayetta, KSThe pilot failed to maintain airspeed and aircraft control during final approach, which resulted in a stall/mush flight condition. A factor to the accident was the crosswind and the trees.NTSB ANC04LA052Accident · No injuriesLimited investigationFinal reportDouglas C-54B · McGrath, AKA fuel tank explosion in the left wing auxiliary fuel tank, and subsequent fuel fire that occurred during engine start for an undetermined reason.NTSB NYC04LA118Accident · 1 fatalLimited investigationFinal reportCessna T-50 · Sharon, MAThe loss of power in one engine for undetermined reasons. Factors were the excessive weight, and degraded climb performance.NTSB LAX04LA204Accident · No injuriesLimited investigationFinal reportRocket Flyers LLC · Tipton, CAA loss of engine power due to fuel starvation as a result of air migrating into the fuel control unit. The ultimate reason for the air entry into the fuel control unit was not determined.NTSB FTW04LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Many, LAThe pilot's improper touchdown which resulted in a hard landing.NTSB DEN04LA070Accident · No injuriesLimited investigationFinal reportCrimmins Smyth Sidewinder · Natrona, WYfuel starvation due to contamination, resulting in the fuel selector valve becoming totally blocked. Contributing factors were the inadequate conditional inspection, and the lack of nsuitable terrain on which to make a forced landing.NTSB DEN04LA069Accident · Minor injuriesLimited investigationFinal reportBranham Vans RV-6 · Paragonah, UTThe pilot's inadequate preflight and in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power. The berm and the pilot not stopping to refuel the airplane were contributing factors.NTSB SEA04LA078Accident · No injuriesLimited investigationFinal reportRobinson R-22 Mariner · Chehalis, WAA loss of engine power for undetermined reasons.NTSB NYC04CA121Accident · No injuriesData collectionFinal reportCessna 152 · Pottstown, PAThe student pilot's failure to maintain directional control during landing, and the flight instructor's delayed remedial action.NTSB MIA04CA080Accident · Minor injuriesData collectionFinal reportBeech H35 · Fort Pierce, FLThe pilots failure to maintain the proper glide path during the approach which resulted in the airplane undershooting the runway and not attaining the proper touchdown point.NTSB ATL04LA111Accident · 1 fatalLimited investigationFinal reportRiggs Skyraider 1 · Blounts Creek, NCThe pilot's failure to maintain adequate airspeed which resulted in a stall. A factor was loss of engine power and water in the fuel.NTSB ATL04LA109Accident · 1 fatalLimited investigationFinal reportBergmann Rans S-12 XL Airaile · Cummings, GAThe unqualified person's poor judgement and his failed to maintain clearance from power lines and trees while maneuvering for a landing which resulted in the in-flight collision with trees and power lines. Factors were the dark night and the unqualified…NTSB ANC04LA051Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kasilof, AKThe pilot's inadequate compensation for wind conditions while landing, which resulted in an undershoot and an in-flight collision with terrain. Factors associated with the accident were a downdraft, and an embankment.NTSB MIA04WA079Accident · 3 fatalForeign investigationSwearingen SA-227 · Carepa, ColombiaNTSB DEN04CA068Accident · Minor injuriesData collectionFinal reportErcoupe 415G · Falcon, COthe pilot's failure to maintain aircraft control. A contributing factor was the clear air turbulence encounter.NTSB CHI04CA114Accident · No injuriesData collectionFinal reportCessna 172P · Schaumburg, ILThe student pilot not maintaining directional control during the takeoff roll and his inadequate remedial action.NTSB NYC04FA117Accident · Serious injuriesField investigationFinal reportEurocopter AS-350BA · Brooklyn, NYThe pilot's failure to maintain control of the helicopter after a loss of hydraulic system pressure due to a failure of the hydraulic pump belt. Factors in this accident were the pilot's misidentification of a hydraulic failure, the pilot's subsequent failure…