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 ANC04FA056Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Cold Bay, AKA loss of engine power during the final approach to land for an undetermined reason, and the pilot's failure to maintain airspeed during the ensuing emergency descent, which resulted in an inadvertent stall. A factor associated with the accident was the stall.NTSB LAX04TA218Accident · No injuriesFinal reportEurocopter France AS350 B3 · Livermore, CAThe pilot's failure to maintain clearance from obstructions while landing.NTSB LAX04CA219Accident · No injuriesData collectionFinal reportCessna R172K · Hawthorne, CAthe pilot's misjudged flare and failure to maintain adequate airspeed, resulting in a stall and hard landing. Factors in the accident were the night conditions and the pilot's lack of familiarity in the make and model of airplane.NTSB FTW04LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Brookland, ARThe pilot's failure to maintain clearance with the power lines while maneuvering.NTSB FTW04LA132Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Donna, TXThe pilot's failure to maintain clearance from the high tension power lines.NTSB MIA04FA086Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Venice, FLFailure of the pilot to recover from an improper landing flare resulting in his failure to maintain airspeed (Vs), an inadvertant stall, loss of control, and inflight collision with terrain during an uncontrolled descent.NTSB LAX04LA216Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Palmdale, CAThe momentary loss of engine power for undetermined reasons.NTSB LAX04CA217Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Livermore, CAthe pilot's failure to maintain directional control.NTSB FTW04IA134Incident · No injuriesIncident investigationFinal reportBeech A23A · Kress, TXThe in-flight separation of the crankshaft for undetermined reasons.NTSB ANC04LA055Accident · No injuriesLimited investigationFinal reportCessna 185E · King Salmon, AKThe pilot's inadequate compensation for wind conditions during takeoff and initial climb, which resulted in a loss of control, and an in-flight collision with water. A factor contributing to the accident was gusty wind conditions.NTSB SEA04FA088Accident · 1 fatalField investigationFinal reportCessna A185F · Molalla, ORThe pilot's inadequate in-flight planning/decision which resulted in VFR flight into IMC, and his failure to maintain control. Factors include mountain obscuration, clouds and convective weather conditions.NTSB LAX04CA214Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's improper application of brakes during the landing roll, resulting in a nose over.NTSB FTW04LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · San Angelo, TXThe loss of engine power for undetermined reasons. A contributing factor was the soft terrain encountered during the aborted takeoff.NTSB ENG04RA027Incident · No injuriesForeign investigationde Havilland DHC-8-4002 · Sandefjord, NorwayNTSB DCA04WA047Incident · No injuriesForeign investigationBoeing 737 · Iquitos, PeruNTSB CHI04CA122Accident · No injuriesData collectionFinal reportCessna 180J · South St. Paul, MNThe total loss of engine power during takeoff climb due to fuel starvation as a result of the pilot's failure to follow the aircraft's checklist and leaving the fuel selector in the OFF positon.NTSB SEA04LA084Accident · No injuriesLimited investigationFinal reportPiper J4/E · Bigfork, MTA loss of engine power due to fuel exhaustion while in cruise flight as a result of inadequate preflight planning / preparation. Factors contributing to the accident were the short landing field and trees.NTSB DEN04CA076Accident · No injuriesData collectionFinal reportWilford J. Tolman Kitfox 6 · Montrose, COthe pilot's failure to maintain aircraft control during takeoff initial climb. A contributing factor was the gusting left tailwind weather condition.NTSB CHI04WA125Accident · 4 fatalForeign investigationde Havilland DHC-2 MK.1 · Fawcett Lake, CanadaNTSB ATL04IA119Incident · No injuriesIncident investigationFinal reportBeech 200 · Millington, TNThe pilots failure to follow the checklist for emergency landing gear extension resulting in the collapse of the main landing gear on touchdown.NTSB ATL04CA120Accident · No injuriesData collectionFinal reportStinson SR-8E · Peachtree City, GAThe pilot's failure to maintain directional control on landing roll out resulting in a loss of control and ground loop.NTSB SEA04FA083Accident · 1 fatalField investigationFinal reportCessna 170B · Tenino, WAThe pilot's failure to maintain an adequate visual lookout during cruise flight, which resulted in a midair collision between the two airplanes.NTSB NYC04WA126Accident · 1 fatalForeign investigationRobinson R-44 · Ulenurme, EstoniaNTSB MIA04CA085Accident · No injuriesData collectionFinal reportCessna 172N · Pembroke Pines, FLThe pilot's failure to establish a climb and his failure to maintain directional control of the airplane during an aborted landing leading to the airplane departing the runway and incurring substantial damage.NTSB IAD04LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Old Town, METhe pilot's failure to abort the takeoff. Factors were the pilot's incorrect assessment of the airplane's weight and the muddy terrain.NTSB FTW04WA129Accident · 4 fatalForeign investigationCessna T210J · Rosario, ArgentinaNTSB ATL04FA118Accident · 1 fatalField investigationFinal reportBeech A36 · Morrisville, NCThe failure of the engine for undetermined reasons resulting in the aircraft colliding with powerlines and the ground during the subsequent forced landing.NTSB SEA04LA087Accident · No injuriesLimited investigationFinal reportCessna 185A · Polson, MTThe pilot's inadequate compensation for the changing wind conditions at the time of the landing. Factors include gusty, variable, crosswinds, and a runway marker near the edge of the runway the pilot was landing on.NTSB SEA04LA085Accident · No injuriesLimited investigationFinal reportStinson SR-10E · Eliza Island, WAThe pilot's misjudgment of altitude/distance resulting in an undershoot of the runway.NTSB NYC04LA130Accident · Minor injuriesLimited investigationFinal reportHigh Craft Buccaneer · Glasco, NYThe pilot's failure to maintain airspeed during landing, which resulted in an inadvertent stall and subsequent impact with the water. A factor was the pilot's lack of experience in the airplane and his diverted attention.NTSB MIA04LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Everglades City, FLThe failure of the pilot to maintain airspeed during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and impact in a wooded area.NTSB LAX04LA213Accident · 4 fatalLimited investigationFinal reportBachman Lancair IV-P · Supai, AZthe loss of aircraft control while in cruise flight for undetermined reasons.NTSB ANC04LA054Accident · No injuriesLimited investigationFinal reportCessna 208B · Egegik, AKThe captain's improper evaluation of the weather conditions and improper decision to taxi the airplane in high gusting wind conditions which resulted in the airplane's right wing striking the ground. A contributing factor was the high gusting wind.NTSB NYC04FA123Accident · 1 fatalField investigationFinal reportCessna 310R · Willoughby, OHThe pilot's failure to maintain aircraft control during the initial climb after takeoff. Factors in this accident were clouds and the night conditions.NTSB LAX04LA211Accident · No injuriesLimited investigationFinal reportCessna T182T · Paulden, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed.NTSB LAX04CA212Accident · No injuriesData collectionFinal reportBeech A60 · Gualala, CAthe pilot's inadequate in-flight planning which resulted in a downwind landing. The tailwind was a contributing factor and an overrun of the runway.NTSB FTW04LA131Accident · No injuriesLimited investigationFinal reportCooke Rotorway Exec · Willis, TXThe partial loss of engine power due to the failure of the #1 cylinder valve retainer clip. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04IA128Incident · No injuriesIncident investigationFinal reportLockheed 1329-23E · Houston, TXThe fatigue failure of the inboard left wing actuator fitting.NTSB CHI04LA120Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Pleasant Hill, MOFuel exhaustion due to the pilot's improper fuel calculations. Contributing factors to the accident included the inaccurate fuel gage and the trees.NTSB CHI04CA121Accident · No injuriesData collectionFinal reportCessna 172C · Fort Leavenwort, KSThe inadequate flare by the pilot.NTSB SEA04LA089Accident · Serious injuriesLimited investigationFinal reportAirframes Unlimited Powered Parachute · Richland, WAThe failure of the non-certificated pilot to maintain clearance from a pole while maneuvering. Factors contributing to the accident included the loss of directional control and the pole.NTSB NYC04CA125Accident · No injuriesData collectionFinal reportCessna 150 · Sacramento, KYThe pilot's improper decision to land with a tailwind, and his inadequate compensation for the wind conditions. A factor was the tailwind.NTSB LAX04LA210Accident · Minor injuriesLimited investigationFinal reportDowner Bellanca 14-19-2 · Lancaster, CAThe pilot's fuel mismanagement by his failure to follow the recommended procedures for operation of the auxiliary fuel tank, which resulted in fuel starvation and loss of engine power during cruise flight.NTSB LAX04CA209Accident · No injuriesData collectionFinal reportCessna 180 · Kingman, AZthe pilot under instruction's excessive and improper use of the rudder control during the landing roll and the flight instructor's inadequate supervision, which resulted in an inadvertent ground loop and nose over.NTSB IAD04FA021Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Ferndale, MDThe pilot's failure to maintain airspeed during a sharp turn, which resulted in an inadvertent stall and subsequent impact with terrain. Factors included the pilot's failure to fly to the intended point of landing, and his abrupt course reversal back towards…NTSB ATL04TA116Accident · 1 fatalFinal reportHughes 269A · Louisburg, NCFatigue failure of the tailboom saddle fitting which resulted in a loss of aircraft control. Also causal was inadequate maintenance due to non-compliance to an airworthiness directive requiring inspection of the saddle fitting. A contributing factor was the…NTSB ATL04LA117Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · New Bern, NCThe pilot's inadequate pre-flight planning which resulted in a loss of engine power due to fuel exhaustion.NTSB SEA04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Shelton, WAThe pilot's failure to adequately compensate for wind conditions during landing. Factors include a crosswind, fracture/collapse of the landing gear hydrasorb and an improper weld on the landing gear assembly.NTSB NYC04LA122Accident · No injuriesLimited investigationFinal reportGarlick Helicipters OH-58A · Columbia, MEA partial loss of engine power for undetermined reasons, which resulted in a forced landing during cruise flight.NTSB NYC04CA124Accident · Minor injuriesData collectionFinal reportFraker Mustang II · Wauseon, OHThe failure of the drive coupling between the engine and the propeller speed reducer. A factor related to the accident was the pilot's inadequate preflight inspection of the drive coupling.