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 LAX04CA309Accident · Minor injuriesData collectionFinal reportCessna 172S · Willits, CAthe pilot's inadvertent descent and controlled flight into obstacles while maneuvering to land. Contributing factors were the dark, nighttime condition, which impaired the pilot's visual perceptions, and the pilot's failure to obtain a pertinent Notice to…NTSB FTW04LA229Accident · No injuriesLimited investigationFinal reportCessna 175 · De Ridder, LAThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA226Accident · 1 fatalLimited investigationFinal reportCassutt Iiim · Pearland, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin while turning from the base leg of the traffic pattern to final. A contributing factor was the pilot's lack of experience for the make/model airplane.NTSB DEN04LA144Accident · No injuriesLimited investigationFinal reportAviat A-1 · Greeley, COthe pilot's improper in-flight decision to land on an unimproved surface and the pilot's failure to maintain aircraft control. Contributing to the accident was the soft landing surface.NTSB CHI04CA250Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Crivitz, WIThe proper touchdown point not attained by the pilot during landing. The road and tailwind were contributing factors.NTSB SEA04LA178Accident · Serious injuriesLimited investigationFinal reportHelio H800 · Fossil, ORThe pilot's failure to remove the aileron wing gust locks prior to flight, which resulted in a loss of control during the descent/emergency landing. A factor contributing to the accident was the pilot's inadequate preflight.NTSB NYC04WA203Accident · 3 fatalForeign investigationPiper PA-31P-425 · Sevilla, SpainNTSB DCA04WA081Incident · No injuriesForeign investigationBoeing 737-300 · Glasgow, United KingdomNTSB ATL04CA172Accident · No injuriesData collectionFinal reportCessna 152 · Waycross, GAThe pilot misjudged the approach speed to touchdown, and the hydroplaning of the airplane during the landing roll resulted in the overrun of the runway surface and the subsequent collision with a fence. .NTSB ANC04LA100Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Cordova, AKThe pilot's failure to maintain an adequate visual lookout during taxi, which resulted in a collision with a runway marker sign. A factor contributing to the accident was sunglare in the pilot's eyes.NTSB NYC04LA201Accident · No injuriesLimited investigationFinal reportPZL 101 · Chazy, NYThe total loss of engine power due to the fractured crankshaft.NTSB LAX04LA308Accident · Minor injuriesLimited investigationFinal reportRockwell 112TCA · San Rafael, CAA total loss of engine power during initial climb due to fuel starvation, which was caused by the pilot's failure to turn on the electric boost pump and an undetermined failure of the engine driven pump to supply sufficient fuel to the carburetor.NTSB FTW04LA227Accident · No injuriesLimited investigationFinal reportGrumman 164B · East Bernard, TXThe loss of engine power as result of the failure of the number four cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA225Accident · No injuriesLimited investigationFinal reportBoeing 727-2M7 · El Paso, TXThe first officer's failure to maintain aircraft control. Contributing factors were the captain's delayed remedial action and the crosswind.NTSB DCA04WA078Accident · Serious injuriesForeign investigationBoeing 747-400 · Hanamaki, JapanNTSB SEA04WA177Accident · 2 fatalForeign investigationCessna 421 · Station Townshi, AustraliaNTSB LAX04IA311Incident · No injuriesIncident investigationFinal reportSikorsky S-70A · Pacoima, CAthe failure of the operator's mechanics to install the turboshaft engine's forward curvic seal during a gas generator turbine (GGT) replacement. Contributing factors to the incident were the failure of the manufacturer to provide a forward curvic seal with…NTSB DCA04WA083Accident · No injuriesForeign investigationFairchild SA226-T · Sydney, AustraliaNTSB SEA04FA173Accident · 2 fatalField investigationFinal reportBeech C35 · Kalispell, MTThe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.NTSB NYC04FA197Accident · 2 fatalField investigationFinal reportRobinson R-22 · Northport, NYAn improper maneuver by the flightcrew while attempting to avoid a kite, which resulted in mast bumping, the separation of the main rotor system, and a subsequent uncontrolled descent into water.NTSB NYC04CA200Accident · No injuriesData collectionFinal reportCessna 177 · Warrenton, VAThe pilot's incorrect aborted landing procedure, which resulted in a collision with terrain.NTSB LAX04CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Williams, AZThe pilot's inadequate compensation for the wind condition and his failure to maintain directional/airplane control during landing rollout. Contributing factors were the gusty crosswind and the pilot's inadequate remedial action.NTSB LAX04CA306Accident · No injuriesData collectionFinal reportQuicksilver MXL II · Rio Vista, CAthe pilot's failure to maintain adequate clearance from high vegetation while flying at a low altitude.NTSB IAD04LA050Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-135KL · Clyde, NYAn unexpected encounter with clear air turbulence.NTSB IAD04CA042Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Ocean City, NJThe pilot's deliberate delay of rotation during the takeoff roll, and his subsequent loss of directional control.NTSB FTW04WA230Accident · 3 fatalForeign investigationPiper PA-30 · Aldama, MexicoNTSB DEN04CA137Accident · No injuriesData collectionFinal reportCessna 172S · Erie, COthe pilot's failure to maintain aircraft control resulting in a hard landing. Factors contributing to the accident were the pilot induced oscillation and the high approach airspeed.NTSB DEN04CA132Accident · Serious injuriesData collectionFinal reportCameron Balloons A-210 · Albuquerque, NMthe passenger losing her balance during the landing. Contributing to the accident was the increased wind velocity.NTSB CHI04CA244Accident · Minor injuriesData collectionFinal reportBeech BE-18 · Lakeville, MNThe pilot's inadequate flare, the improper recovery from a bounced landing, the loss of directional control, and inadequate compensation for the crosswind. A factor was the crosswind.NTSB NYC04WA208Accident · 1 fatalForeign investigationCessna 337C · Bresso, ItalyNTSB NYC04LA221Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Cynthiana, KYThe inoperative left main landing gear brake check valve, which resulted in a loss of directional control during the takeoff.NTSB NYC04CA199Accident · No injuriesData collectionFinal reportRobinson R44 · Wildwood, NJThe pilot's inadequate visual lookout while conducting a nighttime landing to a dolly, which resulted in a stuck skid, and subsequent hard landing. A factor was the nighttime conditions.NTSB NYC04CA198Accident · No injuriesData collectionFinal reportPettigrew, Richard RV-6A · Williamstown, NJThe pilot's improper flare, which resulted in a hard landing.NTSB LAX04LA305Accident · Serious injuriesLimited investigationFinal reportGibbs Kitfox IV · Payson, AZthe pilot's failure to maintain adequate airspeed, which resulted in a stall and subsequent collision with terrain. Contributing factors to the accident were the turbulence and the gusting wind conditions.NTSB LAX04FA304Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Prescott, AZThe failure of both pilots to maintain adequate clearance from each other while performing formation aerobatic maneuvers.NTSB FTW04CA224Accident · Minor injuriesData collectionFinal reportCessna 172S · Leakey, TXThe pilot's failure to maintain clearance with terrain. A contributing factor was the high density altitude.NTSB CHI04LA243Accident · 1 fatalLimited investigationFinal reportBoeing A75 · Wisconsin Rapid, WIThe pilot's improper in-flight decision when he decided to fly at a low altitude over the river and failed to maintain clearance from the power lines. A factor was the wires.NTSB ATL04CA170Accident · Minor injuriesData collectionFinal reportCessna 172R · Atlanta, GAThe intentional interuption of the flight controls in flight that resulted in a uncontrolled descent and collision with a fence.NTSB ANC04LA098Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-3 · McGrath, AKThe pilot's inadequate in-flight planning/decision making, his continued VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Factors contributing to the accident were low ceilings due to smoke, rain, and mist.NTSB SEA04IA175Incident · No injuriesIncident investigationFinal reportBoeing 757-200 · Richmond, BC, CanadaThe slat was impacted by birds after takeoff and subsequently the slat delaminated due to flight loads.NTSB SEA04CA174Accident · No injuriesData collectionFinal reportLuscombe 8A · Nampa, IDThe pilot's failure to maintain directional control during the landing roll. Factors include the pilot's very low total time in this make and model aircraft (one hour), and the soft terrain the aircraft encountered along the side of the runway.NTSB FTW04LA222Accident · No injuriesLimited investigationFinal reportLancair 320 · Houston, TXThe pilot's premature lift-off before attaining adequate airspeed resulting in a stall and collision with the ground.NTSB ATL04LA171Accident · Minor injuriesLimited investigationFinal reportHawkins William Searey · Dayton, TNThe delamination of the fiberglass hull of the airplane.NTSB WAS04WA012Accident · 2 fatalForeign investigationSikorsky S-64E · Bastia, Corsica, FranceNTSB SEA04LA176Accident · No injuriesLimited investigationFinal reportCessna 150K · Richland, WAThe pilot's failure to maintain aircraft control during landing. Wind gusts, inadequate compensation for wind conditions, and an airport marker sign were factors.NTSB MIA04WA125Accident · 3 fatalForeign investigationCessna 206 · Nirgua, VenezuelaNTSB FTW04LA223Accident · No injuriesLimited investigationFinal reportCessna 340 · Odessa, TXThe pilot's failure to extend the landing gear prior to landing and the instructor's inadequate supervision.NTSB ANC04LA097Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot's failure to abort the takeoff, which resulted in a collision with a river bank during the takeoff run.NTSB ANC04LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Paxson, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a rock and subsequent main landing gear collapse during the landing roll. A factor contributing to the accident was rough, uneven terrain.NTSB MIA04LA124Accident · No injuriesLimited investigationFinal reportCessna 550 · Venice, FLThe pilot's failure to maintain adequate airspeed which resulted in a stall and undershoot of the runway.