NTSB investigations, 2004
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 NYC04LA140Accident · No injuriesLimited investigationFinal reportAviat Pitts S2B · Hamilton, OHThe pilot's failure to maintain directional control after experiencing a brake system malfunction during landing. Factors related to the accident were the malfunction of a landing gear brake as reported by the pilot, and the crosswind conditions.NTSB NYC04FA139Accident · 2 fatalField investigationFinal reportBeech 200 · Rupert, WVThe pilot-in-command's improper decision to continue VFR flight into IMC conditions, which resulted in controlled flight into terrain. Factors were the FAA Principle Operations Inspector's inadequate surveillance of the operator, and a low ceiling.NTSB MIA04LA096Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Williston, FLThe pilot's failure to maintain airspeed (Vso) while maneuvering, which resulted in a stall/mush, an uncontrolled descent, and impact with terrain.NTSB LAX04LA240Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Peoria, AZthe pilot's failure to maintain a proper pitch attitude during tow operations and his failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.NTSB LAX04CA238Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Anza, CAThe pilot's misjudged altitude and speed, which resulted in an undershoot and a collision with a berm. Also causal was the control interference from the passenger.NTSB DEN04CA095Accident · Serious injuriesData collectionFinal reportNorthwing WS2 · Fort Collins, COA loss of engine power for undetermined reasons. Contributing factors include low altitude, and the lack of suitable terrain for a forced landing.NTSB DEN04CA092Accident · No injuriesData collectionFinal reportSchweizer 269C · Englewood, COthe settling with power situation encountered by the pilot. Contributing to the accident was the high density altitude.NTSB CHI04CA156Accident · No injuriesData collectionFinal reportYoukey Lancair 235 · Hays, KSThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the gusty crosswind, the runway marker sign, and the taxiway lights…NTSB CHI04CA150Accident · No injuriesData collectionFinal reportMaule MX7235 · Waukesha, WIThe pilot failed to maintain directional control and his inadequate compensation for wind conditions. Factors associated with the accident were the gusty crosswind and the concrete culvert that the airplane contacted.NTSB ATL04CA131Accident · No injuriesData collectionFinal reportCessna 172 · Meridianville, ALThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with the ground.NTSB ANC04LA068Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's inadequate compensation for wind conditions and his inadequate flare while landing, which resulted in a hard landing and collapse of the main landing gear. Factors associated with the accident were a downdraft, and rough and uneven terrain.NTSB ANC04LA064Accident · No injuriesLimited investigationFinal reportdeHavilland DHC-2 · Wasilla, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a collision with a log. Factors contributing to the accident were a tailwind, a lack of brake pedals at the second pilot station, and the second…NTSB LAX04LA239Accident · 1 fatalLimited investigationFinal reportChampion 7AC · La Porte, CAthe student pilot's failure to maintain clearance with trees while flying along a mountainous ravine.NTSB FTW04WA173Accident · No injuriesForeign investigationBell UH-1B · Las Bocas, MexicoNTSB FTW04CA161Accident · No injuriesData collectionFinal reportRuehle Glastar · Lancaster, TXThe pilot's improper flare resulting in a hard landing.NTSB DEN04LA089Accident · 1 fatalLimited investigationFinal reportHispano Aviacion HA-200 · Pueblo, COThe pilot's failure to maintain adequate airspeed resulting in an accelerated stall at an altitude too low for recovery. A factor was the pilot's lack of experience in the aircraft make and model.NTSB CHI04CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Joliet, ILThe pilot's selection of unsuitable terrain for takeoff and the subsequent failure to maintain aircraft control during the encounter with the standing water. Contributing factors were the standing water and the soft runway condition.NTSB ATL04FA130Accident · 2 fatalField investigationFinal reportCessna 172F · Madisonville, TNThe pilot's failure to maintain airspeed while maneuvering on a touch and go landing resulting in a stall and collision with the ground.NTSB ATL04CA129Accident · No injuriesData collectionFinal reportCessna 172N · Dover, TNThe certified flight instructor initiated flight into thunderstorm activity that resulted in a loss of control and the subsequent collision with trees.NTSB SEA04LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Jerome, IDThe pilot's failure to refuel the airplane resulting in fuel exhaustion and the loss of power during descent for landing. Factors contributing to the accident were the soft terrain and the forced landing site.NTSB NYC04WA148Accident · Serious injuriesForeign investigationPiper PA-42 · Reims, FranceNTSB FTW04LA159Accident · No injuriesLimited investigationFinal reportAyres S-2R · Eagle Lake, TXThe partial collapse of the left main landing gear as a result of a failure of the fuselage structure due to corrosion.NTSB FTW04IA160Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-135LR · Dallas, TXThe loss of pressure in Electrohydraulic Servovalve (EHSV) within the nose wheel steering manifold due to contamination in the C1 orifice of the valve, which resulted in an uncommanded turn of the nose wheel during landing rollout. A contributing factor was…NTSB IAD04LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Passaic, NJA total loss of engine power for undetermined reasons. A factor was the evasive maneuver on the ground.NTSB FTW04LA158Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Needville, TXThe loss of engine power and subsequent in-flight fire for undetermined reasons.NTSB DEN04TA088Accident · Serious injuriesFinal reportCessna C172P · Las Cruces, NMthe pilot's failure to maintain clearance from terrain and the improper go-around procedure. Contributing factors include the pilot's diverted attention, improper in-flight planning and decision making, pilot fatigue, the night conditions and the mesquite…NTSB CHI04CA154Accident · Serious injuriesData collectionFinal reportMooney M20C · Golden, MOThe pilot's failure to maintain directional control and his failure to maintain clearance from the trees. The trees were a contributing factor.NTSB CHI04CA152Accident · No injuriesData collectionFinal reportCessna 172N · Hillsboro, NDDirectional control not obtained/maintained by the pilot during landing roll.NTSB CHI04CA151Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Hope, NDThe pilot's failure to maintain clearance from the tree branches during the aerial-application flight. A factor to the accident was the trees.NTSB SEA04LA102Accident · No injuriesLimited investigationFinal reportBell 206B · Prosser, WAThe pilot's failure to maintain clearance with the power lines while maneuvering.NTSB NYC04CA138Accident · No injuriesData collectionFinal reportCessna 152 · Elyria, OHThe student pilot's inadequate recovery from a bounced landing.NTSB LAX04LA235Accident · 1 fatalLimited investigationFinal reportHarold W Bruce RV-6 · Cloverdale, CAthe pilot's inadequate in-flight planning/decision and selection of the wrong runway, and his inadequate compensation for the gusting tail wind conditions, which resulted in a stall/mush.NTSB FTW04WA165Accident · 4 fatalForeign investigationPiper Pa-28 · Yamasa, Dominican RepublicNTSB ATL04LA128Accident · 1 fatalLimited investigationFinal reportGrover J3 Kitten · Mohawk, TNThe pilot's decision to perform aerobatic flight in an airplane with known deficiencies that resulted in the in-flight separation of the airframe and the uncontrolled collision with the ground.NTSB SEA04LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Trego, MTFailure to maintain clearance from trees during the initial climb.NTSB MIA04CA095Accident · No injuriesData collectionFinal reportCessna 182H · La Belle, FLThe inadvertent deployment of the main parachute resulting in damage to the right horizontal stabilizer and elevator.NTSB FTW04LA156Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Joiner, ARThe pilot's failure to maintain clearance and altitude from terrain while maneuvering during an aerial application.NTSB MIA04CA094Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lake Wales, FLThe pilot's delay in aborting the takeoff resulting in an overrun of the runway and subsequent impact with water. A finding in the accident was the pilot's failure to extend the flaps to the second notch (25 degrees).NTSB LAX04LA267Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Richvale, CAthe loss of engine power during takeoff due to the engine's deteriorated fuel control unit's inner drive shaft bearing. The reason for the bearing's deteriorated condition could not be determined.NTSB FTW04LA153Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402 · Tucker, ARThe pilot's failure to maintain control while manuevering during aerial application which resulted in impact with terrain.NTSB DEN04LA086Accident · Minor injuriesLimited investigationFinal reportEagle DW-1 · Circleville, UTthe encounter with severe turbulence during aerial application and the pilot's inability to maintain aircraft control resulting in the in-flight collision with terrain. A contributing factor was the low altitude.NTSB DEN04FA087Accident · 2 fatalField investigationFinal reportRaytheon A36 · Gilcrest, COthe pilot's inadequate in-flight planning/decision by his failure to switch fuel tank selector position which resulted in fuel starvation. Also causal was the pilot's failure to maintain airspeed which resulted in a stall.NTSB DCA04IA052Incident · No injuriesIncident investigationFinal reportAirbus Industrie A340-311 · Washington, DCThe incorrect loading of baggage into the aft cargo compartment instead of the forward compartment, which resulted in aft CG light in-flight.NTSB CHI04LA145Accident · Minor injuriesLimited investigationFinal reportBetchan KR II · Rapid City, SDFailure of the engine rocker arm installation resulting in a loss of engine power. A contributing factor was the power lines.NTSB CHI04CA143Accident · No injuriesData collectionFinal reportCessna 150F · Forest Lake, MNThe pilot's inaccurate fuel consumption calculations which resultied in fuel exhaustion and loss of engine power. Factors associated with the accident were the dark light conditions and the water on which the forced landing was made.NTSB SEA04LA100Accident · 1 fatalLimited investigationFinal reportGann Glasair II-S RG · Baker City, ORThe pilot's inadequate in-flight planning/decision and his failure to maintain an airspeed above stall speed (Vs) after encountering airframe icing during cruise flight. Factors include the pilot's intentional continuation of his flight along the planned…NTSB CHI04CA141Accident · Minor injuriesData collectionFinal reportDoerr Raymond R RV-9A · Fort Scott, KSThe vapor lock of the airplane fuel system and the ditch encountered during the emergency landing..NTSB CHI04CA139Accident · No injuriesData collectionFinal reportCessna TR182 · Hamberg, NDThe pilot's inadequate in-flight planning/decision and his misjudgment of speed and distance.NTSB ATL04CA127Accident · Minor injuriesData collectionFinal reportCessna 150 · Decatur, ALThe pilot's failure to maintain obstacle clearance, which resulted in collision with utility wires.NTSB ANC04LA061Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing flare/touchdown. A factor contributing to the accident was soft tundra terrain.