NTSB investigations, 2004
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 FTW04LA211Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Abita Springs, LAThe pilot's failure to maintain obstacle clearance. The pilot's inadequate evaluation of the weather and dark night conditions are contributing factors.NTSB FTW04LA210Accident · No injuriesLimited investigationFinal reportBellanca BL17-30 · Austin, TXThe loss of engine power due to fuel starvation as result of the pilot's improper fuel management. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN04CA120Accident · Minor injuriesData collectionFinal reportMooney M20J · Durango, COthe pilot's inadequate compensation for wind conditions and his failure to maintain adequate airspeed resulting in a stall. Factors contributing to the accident were the wind gusts, the downdraft, and the road.NTSB DCA04WA073Incident · No injuriesForeign investigationBoeing 717-200 · Melbourne, AustraliaNTSB CHI04CA221Accident · No injuriesData collectionFinal reportCessna 310Q · Nappanee, INThe delay in the pilot's performance of an aborted takeoff. A factor was the reported restricted movement of the elevator. Additional factors were the rising easement and roadway the airplane went over before coming to rest in the farmers field.NTSB NYC04CA190Accident · Serious injuriesData collectionFinal reportClassic Waco YMF · Bar Harbor, METhe pilot's inadequate compensation for wind conditions. A factor was the crosswind.NTSB FTW04LA209Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Denton, TXThe student pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight by his delay in taking remedial action.NTSB FTW04CA193Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Baton Rouge, LAThe pilot's selection of an unsuitable area for landing. A contributing factor was the high vegetation.NTSB DEN04FA119Accident · 2 fatalField investigationFinal reportCessna 172P · Monarch Crest, COthe pilot's failure to maintain airspeed which resulted in a stall, and his decision to conduct flight beyond the performance capability of the aircraft. A contributing factor was the high density altitude, and an inadvertent stall.NTSB DEN04CA122Accident · No injuriesData collectionFinal reportEurocopter France EC-130 B4 · Englewood, COthe pilot's failure to perform a preflight inspection. Contributing to the accident was the transmission cowling that disconnected during the landing.NTSB NYC04LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Pittstown, NJThe pilot's failure to obtain a proper climb rate during a go-around, which resulted in a forced landing and subsequent impact with a tree.NTSB NYC04CA189Accident · No injuriesData collectionFinal reportCessna 172P · Wilkes-Barre, PAThe student pilot's improper flare and improper recover from a bounced landing. Factors in this accident were the crosswind condition and the partial failure of the airplane's transceiver, as reported by the pilot.NTSB LAX04CA288Accident · No injuriesData collectionFinal reportCessna 172S · Chandler, AZthe student pilot's failure to abort the takeoff. A contributing factor was the pilot's failure to maintain directional control.NTSB IAD04LA035Accident · Serious injuriesLimited investigationFinal reportGiles Mustang II · Rainelle, WVThe partial loss of engine power due to a broken throttle mechanism, which resulted in a forced landing over unsuitable terrainNTSB DEN04CA117Accident · Minor injuriesData collectionFinal reportMooney M20K · Jackson Hole, WYthe pilot's failure to maintain aircraft control resulting in a stall/mush. Contributing factors include the windshear, the crosswind and the runway light.NTSB CHI04CA218Accident · No injuriesData collectionFinal reportCessna 305A · Frankfort, MIThe tow pilot failed to maintain directional control during takeoff roll and failed to abort the takeoff. Additionally, the tow pilot failed to attain adequate airspeed which resulted in a stall. The tailwind and the tall grass were contributing factors.NTSB CHI04CA216Accident · No injuriesData collectionFinal reportGlasflugel H301 · Hutchinson, KSThe pilot's improper decision to change the landing area at a low altitude and the inadequate flare that resulted in a hard landing.NTSB ATL04LA166Accident · 1 fatalLimited investigationFinal reportSidney Freebird · Lexington, TNThe pilot's failure to maintain airspeed, resulting in an inadvertent stall, and collision with the ground. A factor was the pilot's total lack of experience in type of aircraft.NTSB ANC04LA090Accident · No injuriesLimited investigationFinal reportCessna 185F · Wasilla, AKThe pilot's failure to compensate for a crosswind during landing and his failure to maintain directional control, which resulted in a loss of control and collision with a ditch. A factor contributing to the accident was a crosswind.NTSB SEA04LA157Accident · Serious injuriesLimited investigationFinal reportHeadrick Vans RV9A · Westport, WAFuel starvation as a result of the pilot's improper fuel management. Carburetor icing conditions and trees were a factor.NTSB SEA04LA156Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DC-65 · Wamic, ORThe pilot's inadequate compensation for wind conditions and his failure to maintain airspeed, resulting in a stall. The pilot's failure to use all of the available runway, and the high-gusty winds were factors.NTSB NYC04LA186Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Marlboro, MAThe loss of engine power due to a stuck cylinder exhaust valve. Factors were the tailwind and a jammed engine cylinder exhaust valve.NTSB NYC04FA185Accident · 2 fatalField investigationFinal reportCessna A150L · Kinnelon, NJBoth pilots inadequate visual lookout, which resulted in a midair collision.NTSB FTW04LA212Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28F · De Leon, TXThe pilot's failure to properly secure a fuel line, which resulted in a loss of engine power due to leakage and subsequent fuel starvation.NTSB FTW04FA208Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Burnet, TXThe pilot's continued flight into known adverse weather, VFR flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. A contributing factor was the cloudy weather.NTSB DEN04IA124Incident · No injuriesIncident investigationFinal reportBoeing 737-500 · Denver, COthe inaccurate radar information due to the failure of the Airport Movement Area Surveillance radar resulting in the tower calling for the airplane to abort the takeoff, subsequently causing tire and brake damage to the airplane.NTSB DCA04WA067Accident · No injuriesForeign investigationBoeing 767-300ER · Viru-Viru Int, BoliviaNTSB CHI04FA215Accident · 1 fatalField investigationFinal reportJorgensen Velocity XL-RG · Belvidere, KSThe non-instrument rated pilot's VFR flight into known instrument meteorological conditions and his failure to maintain aircraft control which resulted in an inverted flat spin, in-flight breakup, and explosion.NTSB CHI04FA214Accident · 2 fatalField investigationFinal reportEurocopter France EC130 B4 · Prairie du Sac, WIThe pilot's intentional low-level flight toward the lake and his failure to maintain clearance from the static wire on power transmission lines. Contributing factors were the separation of the Fenestron (tail rotor) assembly from the tail boom as a result of…NTSB ANC04LA091Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's misjudged distance/altitude during the final approach phase of landing, which resulted in an undershoot and subsequent collision with terrain.NTSB ANC04CA089Accident · No injuriesData collectionFinal reportAeronca 15AC · Big lake, AKThe pilot's inadequate evaluation of the weather conditions and subsequent collision with high vegetation during the initial climb after takeoff, which resulted in a collision with the ground. Factors contributing to the accident were the presence of a…NTSB LAX04LA287Accident · No injuriesLimited investigationFinal reportCessna TR182 · Torrance, CAA wheels up landing due to the failure of the hydraulic hose leading to the nose gear actuator, which depleted the hydraulic system of pressurized fluid.NTSB DCA04WA070Accident · 4 fatalForeign investigationSocata Rallye TB-10 · Solroed Strand, DenmarkNTSB CHI04LA238Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Eudora, KSA loss of engine power due to fuel starvation resulting from the pilot's selection of a fuel tank with an insufficient quantity remaining.NTSB CHI04LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164-B · Bradford, ILThe pilot's misjudgment of speed and distance, and his failure to perform a go-around. Additional factors were the wet runway and the ditch.NTSB ANC04WA101Accident · 4 fatalForeign investigationCessna U206G · Optand, SwedenNTSB ANC04LA087Accident · Serious injuriesLimited investigationFinal reportHughes OH-6A · Anchorage, AKA loss of tail rotor effectiveness during aerial taxi, and the pilot's delayed remedial action to counteract a rapid right yaw, which resulted in an in-flight loss of directional control, and in-flight collision with terrain. A factor contributing to the…NTSB LAX04CA286Accident · No injuriesData collectionFinal reportPiper PA-20 · Glendale, AZthe pilot's failure to maintain directional control during the takeoff roll.NTSB FTW04CA207Accident · No injuriesData collectionFinal reportBell 47G-3B-1 · Troy, TXThe flight instructor's improper flare, resulting in a hard landing. A contributing factor was the high density altitude.NTSB CHI04LA212Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Chesterfield, MOThe pilot's inadequate preflight planning due to his selection of an unsuitable takeoff area and his failure to maintain clearance from the open hangar door. A contributing factor was the open hangar door.NTSB CHI04CA241Accident · No injuriesData collectionFinal reportCessna 172R · Olathe, KSThe student pilot flared too high and failed to recover from a bounced landing.NTSB ANC04CA088Accident · No injuriesData collectionFinal reportCessna 182F · Kenai, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the ensuing aborted landing when the airplane encountered soft terrain. Factors contributing to the accident were the soft, swampy area surrounding the landing zone.NTSB ANC04CA085Accident · No injuriesData collectionFinal reportCessna 402C · Huslia, AKThe pilot's failure to extend the landing gear, which resulted in an inadvertent wheels up landing. A factor associated with the accident was the pilot's diverted attention.NTSB SEA04WA155Accident · Minor injuriesForeign investigationMooney M20J · Elkins Creek BC, CanadaNTSB SEA04FA154Accident · 1 fatalField investigationFinal reportCessna 182P · Port Angeles, WAThe pilot's VFR flight into IMC and his failure to maintain clearance from trees. Trees, mountainous terrain, dark night conditions, clouds and VFR flight into IMC were factors.NTSB MIA04GA117Accident · 1 fatalFinal reportBell 47G-5 · Bunnell, FLThe pilot's continued flights and inadequate inspections after repeated tail rotor guard ground strikes due to improper flaring, which resulted in an in-flight failure of tail rotor drive shaft components, a loss of control, and the helicopter crash.NTSB FTW04FA206Accident · 3 fatalField investigationFinal reportMooney M20J · Olney, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in the inadvertent stall/spin. A contributing factor was the prevailing tailwind.NTSB FTW04CA205Accident · No injuriesData collectionFinal reportCessna 172N · Cleveland, TXThe student pilot's improper judgment of the airplanes altitude during landing. A contributing factor was the pilot's level of anxiety/apprehension after becoming lost/disoriented.NTSB DEN04LA116Accident · No injuriesLimited investigationFinal reportMooney M20R · Aspen, COthe pilot's failure to maintain control of the airplane. Contributing factors was the pilot flaring the airplane too high, his misunderstanding of the instructor's attempt to take control of the airplane. and the instructor's inadequate supervision of the…NTSB DEN04FA115Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Mineral Wells, TXthe pilot's failure to maintain airspeed which resulted in a stall. A contributing factor was the low altitude.