NTSB investigations, 2003
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\") = 2003 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") = 2003 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 LAX03LA122Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Avondale, AZThe pilot failed to maintain adequate visual lookout and did not maintain clearance from power lines. The backhoe's location, which caused the pilot to alter his planned flight path, was a factor.NTSB DEN03LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Newcastle, WYthe pilot's failure to maintain clearance from the terrain. Contributing factors include inadequate in-flight planning and decision making by the pilot, and the ground.NTSB CHI03IA097Incident · No injuriesIncident investigationFinal reportBoeing 747-422 · Chicago, ILFailure of company maintenance personnel to fully comply with published maintenance/inspection procedures, as well as the resulting inoperative drain heaters and restricted movement of the aileron control cables. Contributing factors were the impeded waste…NTSB ATL03IA073Incident · No injuriesIncident investigationFinal reportCessna 182P · Eufaula, ALFatigue failure of end rib for the left canard flap.NTSB NYC03LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Shenandoah, VAThe pilot's inadvertent encounter with snow showers. Factors were the snow and the unsuitable landing area.NTSB NYC03LA075Accident · Serious injuriesLimited investigationFinal reportBeech B-60 · Bradford, PAThe pilot's improper decision to maneuver for a landing in a configuration that exceeded the capability of the airplane to maintain altitude, after he lost power on one engine for undetermined reason(s).NTSB MIA03CA083Accident · No injuriesData collectionFinal reportCessna 190 · Lakeland, FLThe pilot's inadequate compensation for wind and his failure to maintain directional control. A related factor was the crosswind.NTSB LAX03LA121Accident · Serious injuriesLimited investigationFinal reportBeech V35A · North Las Vegas, NVFuel starvation due to the pilot's mismanagement of his fuel supply and failure to verify the fuel quantity onboard prior to departure.NTSB LAX03LA120Accident · No injuriesLimited investigationFinal reportBeech 19A · Coalinga, CAThe pilot's failure to obtain/maintain an adequate airspeed, which resulted in a stall/mush.NTSB FTW03FA120Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Broken Arrow, OKFailure of the engine due to the blow-by condition in the number six cylinder for undetermined reasons, which resulted in oil starvation and eventual failure of the associated connecting rod end cap. Also causal was the pilot's failure to maintain airspeed…NTSB CHI03LA095Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Knox, INA loss of engine power due to oil starvation as a result of the failure of the master rod bearing. Contributing factors were the tree line at the edge of the field, and the unsuitable terrain.NTSB ANC03LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKA loss of engine power for an undetermined reason. A contributing factor in the accident was the lack of suitable terrain for a forced landing.NTSB ANC03LA038Accident · No injuriesLimited investigationFinal reportHughes 369D · Tyonek, AKThe pilot's inadequate visual lookout while lifting into a hover to ensure the helicopter was clear of all objects, which resulted in separation of an external mirror that then struck and damaged a main rotor blade. Factors in the accident were the presence…NTSB SEA03LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Troutdale, ORAircraft control was not maintained during the landing roll. An improper flare which resulted in a bounced landing was a factor.NTSB SEA03LA052Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Mabton, WAA partial loss of power, for undetermined reasons, during a shallow approach, that ultimately lead to a situation where the pilot found it necessary to attempt a forced landing while the helicopter was moving slightly sideways. Factors include rough/uneven…NTSB MIA03LA082Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Tavernier, FLThe control interference by the pilot-rated passenger in an attempt to avoid an obstacle, which resulted in a loss of control.NTSB CHI03LA093Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Sturtevant, WIThe student pilot's abrupt liftoff resulting in his failure to maintain adequate airspeed followed by a stall. Also causal was the instructor's inadequate supervision.NTSB ATL03LA071Accident · Minor injuriesLimited investigationFinal reportCessna 310F · Reidsville, NCThe failure of maintenance personnel to properly install the nose gear landing door link during an annual inspection that resulted in the failure of the nose gear to fully extend.NTSB NYC03WA074Accident · 1 fatalForeign investigationCessna 421C · Humberside, United KingdomNTSB MIA03LA087Accident · No injuriesLimited investigationFinal reportPool Pool Jungster I · Fernandina Beac, FLThe pilot's failure to maintain control during the landing flare/touchdown while attempting a crosswind landing resulting in the left wing impacting the ground, and a collision with runway lights during the attempted recovery.NTSB LAX03LA119Accident · No injuriesLimited investigationFinal reportEnstrom F280FX · San Carlos, CAFuel exhaustion due to the pilot's inadequate fuel consumption calculations and his inadequate in-flight planning decision. A factor was the low altitude from which the autorotation was attempted.NTSB DEN03LA060Accident · No injuriesLimited investigationFinal reportCessna 170A · Hobbs, NMthe pilot's failure to maintain aircraft directional control during takeoff roll. A factor was the runway light's cement foundation.NTSB IAD03LA051Accident · No injuriesLimited investigationFinal reportBell 47G · Lehighton, PAThe student pilot's improper flare, which resulted in a hard landing, and his continued flight operations with a known discrepancy.NTSB CHI03FA094Accident · 3 fatalField investigationFinal reportBeech A36 · New Vienna, IAThe improper planning/decision by the pilot to fly into forecast icing conditions with an airplane not equipped with a certified deice system. The continued flight in known icing conditions and the flight to an alternate destination not performed by the pilot…NTSB ATL03FA070Accident · 1 fatalField investigationFinal reportCessna 172R · Cherokee, NCThe pilot's failure to maintain adequate terrain clearance, which resulted in an in-flight collision with mountainous terrain.NTSB ANC03LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an encounter with soft snow, and subsequent nose over during the landing roll. A factor contributing to the accident was the soft, snow-covered terrain.NTSB NYC03LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Berlin, NJThe pilot's inadequate preflight inspection which led to an unsecured cowling and loss of aircraft control. Factors were the pilot's diverted attention and the unsecured cowling.NTSB NYC03FA067Accident · Serious injuriesField investigationFinal reportBoeing 717-200 · Flushing, NYA failure of the left power control distribution unit (PCDU).NTSB MIA03CA091Accident · No injuriesData collectionFinal reportMaule M-5-235C · Jay, FLThe failure of the pilot to perform a go-around after bouncing following touchdown, resulting in the airplane nosing over during the landing roll.NTSB IAD03LA042Accident · No injuriesLimited investigationFinal reportBell BHT-47-G3B2A · Lexington, KYThe pilot's failure to maintain directional control while maneuvering to land after a loss of engine power. A factor was the loss of engine power.NTSB IAD03LA041Accident · Serious injuriesLimited investigationFinal reportAeronca CH-7A · Cumberland, MDThe pilot/mechanic's failure to ensure the proper installation of the left wing's aft strut-to-spar attachment bolt, which resulted in a loss of control and a subsequent impact with terrain.NTSB IAD03CA044Accident · No injuriesData collectionFinal reportCessna 172S · Cleveland, OHThe student pilot's improper flare, which resulted in a hard landing.NTSB FTW03FA118Accident · 2 fatalField investigationFinal reportBell 407 · Broadus, TXThe partial loss of engine power due to erratic fuel flow metering to the engine resulting from the single point failure of the PLA potentiometer in the hydro-mechanical fuel control unit. A contributing factor was the lack of suitable terrain to execute a…NTSB DEN03FA059Accident · 4 fatalField investigationFinal reportCessna A185F · Grand Junction, COthe pilot's poor judgment and his failure to maintain aircraft control. Contributing factors were the high winds and downdrafts, and the pilot's self-induced pressure to go home.NTSB ATL03LA072Accident · No injuriesLimited investigationFinal reportRotorway 162F · Greensboro, NCThe pilot's inadequate preflight planning of fuel required for flight which resulted in fuel exhaustion, and a complete loss of engine power followed by a forced landing, and a dynamic rollover during the autorotative touchdown.NTSB ATL03LA069Accident · No injuriesLimited investigationFinal reportCessna 310 · Dyersburg, TNThe pilot's failure to maintain directional control during landing roll. A factor was muddy terrain conditions.NTSB ATL03FA068Accident · 2 fatalField investigationFinal reportRockwell 690B · Homerville, GAAn in-flight encounter with unforecasted severe turbulence in cruise flight resulting in the design limits of the airplane being exceeded due to an overload failure of the airframe, and collision with a swampy area.NTSB NYC03LA073Accident · No injuriesLimited investigationFinal reportCessna 150G · Medina, OHThe pilot's failure to follow published procedures while starting the engine, and his failure to maintain control of the airplane.NTSB FTW03LA116Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB DEN03LA057Accident · No injuriesLimited investigationFinal reportCessna 170A · Santa Rosa, NMthe pilot's failure to maintain directional control while taxiing for takeoff. A contributing factor was the wind gust.NTSB SEA03LA050Accident · No injuriesLimited investigationFinal reportHiperlight SNS-8 · South Prairie, WAThe failure of the pilot to maintain control of the aircraft during the crosswind turn resulting in an inadvertent spin entry, followed by his intentional stall to a landing resulting in a hard landing and subsequent nose over.NTSB MIA03LA081Accident · No injuriesLimited investigationFinal reportBeech A36 · Naples, FLThe pilot's improper preflight planning and delay in aborting the takeoff which resulted in the airplane overrunning the runway and incurring damage.NTSB SEA03WA051Accident · 2 fatalForeign investigationGulfstream Aerospace Commander 695 · Ogawa Village, JapanNTSB SEA03LA049Accident · No injuriesLimited investigationFinal reportCessna 172G · Packwood, WALoss of partial engine power for undetermined reasons during the initial climb after takeoff. Loose gravel/sandy was a factor during the landing roll.NTSB FTW03FA117Accident · No injuriesField investigationFinal reportBell 407 · Houma, LAThe loss of tail rotor drive and anti-torque control resulting from the fracture and separation of the #5 tail rotor drive segment due to the overtemperature and subsequent failure of the #5 hangar bearing.NTSB DEN03LA056Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe pilot's premature liftoff resulting in his failure to attain airspeed and achieve takeoff climb. Contributing factors were the runway light and taxiway sign.NTSB CHI03LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · South Haven, MIThe inadequate fuel consumption calculations by the pilot and the fuel exhaustion. The inadequate traffic pattern distance from the runway, which precluded his reaching the runway.NTSB NYC03LA071Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Columbus, OHThe pilot under instruction's failure to maintain directional control, and the flight instructor's delayed remedial action.NTSB NYC03LA069Accident · Minor injuriesLimited investigationFinal reportBell 47D · Princetown, NYThe student's failure to maintain control while executing a takeoff to a hover, and the flight instructor's delayed remedial action. A factor in the accident was the muddy ground.NTSB LAX03LA118Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Mammoth Lakes, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing roll. A factor was the gusty crosswind.