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 FTW03LA149Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Houston, TXThe flight instructor's poor decision to initiate a simulated emergency without having a suitable area for a forced landing.NTSB DEN03TA079Accident · 1 fatalFinal reportMcDonnell Douglas A-4N · Salt Lake City, UTThe lose of engine power during descent due to the in-flight collision with a bird which FOD damaged the engine and subsequently melted the turbine section. A contributing factor was the airplane's malfunctioning ejection seat.NTSB CHI03LA123Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Point Lookout, MOFailure of the pilot to maintain control of the aircraft. Contributing factors were the sudden windshift to a tailwind, the wet runway surface, the lack of available runway overrun area and the rocky, descending embankment.NTSB SEA03LA080Accident · No injuriesLimited investigationFinal reportAllen SA-300 · Yakima, WADirectional control was not maintained during the landing roll. A steering spring disconnected as a result of a tailwheel shimmy was a factor.NTSB NYC03LA102Accident · No injuriesLimited investigationFinal reportCessna 140 · Suffolk, VAThe pilot's misjudgment of his altitude from the wheat field during the execution of a go-around.NTSB SEA03LA078Accident · No injuriesLimited investigationFinal reportBeech F-35 · Anacortes, WAThe pilot's inadvertent selection of the incorrect fuel tank selector position (OFF) while in cruise flight over open water, and his failure to activate the fuel wobble-pump. A contributing factor was the unsuitable terrain.NTSB DEN03LA078Accident · Minor injuriesLimited investigationFinal reportBell 206-L4 · Aurora, COinadequate infligt planning/decision by the flight crew and the check pilot's failure to initiate remedial action in a timely manner. Contributing factors were the pilot-in-command's inadequate supervision of the check pilot, the check pilot's lack of recency…NTSB ATL03IA090Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Chattanooga, TNExcessive wear on the bushings and the right aileron inboard and outboard power control unit output link resulting in the upward movement of the right aileron during cruise climb, uncommanded right roll. A factor in the accident was inadequate maintenance…NTSB NYC03LA104Accident · Serious injuriesLimited investigationFinal reportBoeing B767-300 · New Market, VAThe inadvertent encounter with turbulence.NTSB NYC03LA101Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Boston, MAThe operator's loss of control of the belt-loader while operating in the proximity of the airplane.NTSB FTW03LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Hurst, TXThe improper flare by the pilot receiving instruction, which resulted in the hard landing. A contributing factor was the flight instructor's inadequate supervision.NTSB FTW03FA145Accident · 2 fatalField investigationFinal reportBell Shelby Aero 47G2 · Ardmore, OKThe pilot's failure to control the rate of descent, which resulted in an improper touchdown of the helicopter. A contributing factor was the loss of throttle control for undetermined reasons.NTSB LAX03LA148Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pala, CAthe dual student's delay in executing the proper recovery procedures and improper retraction of the flaps, the CFI's inadequate supervision during the recovery to normal flight, the CFI's delayed remedial action, and the failure of both pilots to maintain an…NTSB CHI03LA122Accident · No injuriesLimited investigationFinal reportCessna 182S · Hatton, NDFailure by the flight instructor to maintain clearance to the tree. Contributing factors were the delayed remedial action by the flight instructor and the tree.NTSB NYC03LA097Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Buffalo, NYThe pilot's failure to maintain sufficient airspeed to prevent an inadvertent stall. Factors were the variable and gusty winds.NTSB NYC03LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Montgomery, NYThe inadequate 100-hour inspection by maintenance personnel, which resulted in a loose fuel line and loss of power. A factor related to the accident was the dark night conditions.NTSB NYC03FA095Accident · 1 fatalField investigationFinal reportBeech A36 · Farmingdale, NJThe pilot's delayed decision to refuel, which resulted in fuel exhaustion and the subsequent loss of engine power.NTSB MIA03LA104Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Lantana, FLThe pilot/owner's failure to maintain rotor rpm which resulted in a loss of control. Contributing factors were high gross weight and high density altitude.NTSB CHI03LA118Accident · 2 fatalLimited investigationFinal reportAir Tractor AT-503A · Pontiac, ILThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. A factor associated with the accident was the low altitude maneuver.NTSB ATL03FA089Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Calhoun, GAThe pilot's failure to obtain a preflight weather briefing, which would have indicated that MVFR to IFR conditions prevailed over the route with embedded thunderstorms and rain, and his decision to continue VFR flight into instrument meteorological…NTSB NYC03LA099Accident · No injuriesLimited investigationFinal reportCessna 182F · Washington Cour, OHFailure of the nose gear assembly. A factor was the inadequate inspection by the pilot/mechanic.NTSB NYC03LA098Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ava, NYThe pilot's inadequate preflight which did not detect the contamination in the fuel, and subsequent power loss due to contaminated fuel while operating over unsuitable terrain.NTSB NYC03GA094Accident · 1 fatalFinal reportPiper PA-18-150 · Ashland, METhe pilot's impairment due to over-the-counter medications, which resulted in a loss of aircraft control while maneuvering.NTSB LAX03FA147Accident · 1 fatalField investigationFinal reportCessna 411 · Corona, CAThe failure of the pilot to properly configure the airplane for a one engine inoperative condition (including his failure to feather the propeller of the affected engine, retract the landing gear, and maintain minimum single engine speed). Factors related to…NTSB CHI03LA121Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gordon, NEThe pilots failure to maintain adequate airspeed which resulted in a stall. Contributing factors to this accident were the rain, hail, and wind gusts.NTSB ATL03LA091Accident · Serious injuriesLimited investigationFinal reportHomebuilt Unkown · Summerville, GAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall, and subsequent collision with the ground.NTSB MIA03CA103Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Madison, MSThe pilot's failure to maintain control during the landing rollout/which resulted in the airplane veering off the runway and incurring damage.NTSB FTW03LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · Roanoke, TXThe flight instructor's inadequate in-flight planning/decision resulting in fuel starvation and the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL03LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Montgomery, ALThe in-flight collision with birds that resulted in a partial loss of engine power, and subsequent in-flight collision with trees while maneuvering for an emergency landing.NTSB ANC03LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Skwentna, AKThe pilot's failure to use carburetor heat, which resulted in the accumulation of carburetor ice, a partial loss of engine power, and a subsequent forced landing. Factors contributing to the accident are a downdraft, the pilot operating the airplane at a low…NTSB LAX03LA146Accident · No injuriesLimited investigationFinal reportCessna 170A · Twentynine Palm, CAThe pilot's inadequate compensation and his failure to maintain aircraft control. The gusty wind condition was a contributing factor.NTSB LAX03GA145Accident · No injuriesFinal reportEurocopter France AS350B3 · Napa, CAthe pilot under instruction's inadvertent activation of the collective manual fuel slide lock, which led to engine and main rotor overspeeds due to excessive fuel flow during power application. This resulted in failures of the gas generator turbine (N1)…NTSB SEA03LA075Accident · Minor injuriesLimited investigationFinal reportDeJager RV-6 · Bellingham, WAThe pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power.NTSB FTW03LA142Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Needham, ARThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL03LA088Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Milledgeville, GAThe pilot's failure to maintain airspeed during climbout which resulted in a low altitude stall and subsequent in-flight collision with the terrain.NTSB NYC03LA093Accident · No injuriesLimited investigationFinal reportCessna R182 · Monticello, NYThe pilot's premature raising of the flaps during the aborted landing. A factor in this accident was the crosswind condition.NTSB MIA03LA101Accident · No injuriesLimited investigationFinal reportCessna 177-RG · Clearwater, FLThe pilot's failure to maintain directional control during landing roll resulting in the failure and separation of the right main landing gear, partial collapse of the nose landing gear, and substantial damage to the airplane.NTSB IAD03LA052Accident · Minor injuriesLimited investigationFinal reportAeronca AR-58-058B · Brattleboro, VTThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and a subsequent descent into trees. A factor in the accident was the downdrafts.NTSB FTW03LA141Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pond Creek, OKThe pilot's failure to attain adequate airspeed during liftoff resulting in a stall.NTSB SEA03LA074Accident · Serious injuriesLimited investigationFinal reportCessna 182 · McCall, IDThe pilot's inadvertent entry into instrument meteorological conditions while maneuvering in the area of rapidly growing cumulus clouds. Factors include the pilot's improper decision to try to out-climb the rising clouds, mountainous terrain, falling snow,…NTSB SEA03LA073Accident · No injuriesLimited investigationFinal reportPilatus B4-PC11AF · Enumclaw, WAThe pilot's failure to maintain directional control. Contributing factors were the crosswind/tailwind conditions and the trees which the glider impacted.NTSB SEA03LA071Accident · No injuriesLimited investigationFinal reportCessna 180 · Pasco, WAThe pilot's inadequate remedial action when his aircraft began to veer during the landing roll, and his ultimate failure to maintain directional control which resulted in a ground loop. Factors include the pilot's momentary diversion of his attention during…NTSB SEA03LA070Accident · No injuriesLimited investigationFinal reportCessna 182C · Stanley, IDThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power during descent. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB NYC03LA092Accident · No injuriesLimited investigationFinal reportStinson 108 · Brookville, OHThe pilot's failure to maintain directional control while landing.NTSB NYC03LA091Accident · No injuriesLimited investigationFinal reportCessna 172K · Burnham, PAThe pilot's failure to maintain directional control during the takeoff roll.NTSB NYC03LA090Accident · 1 fatalLimited investigationFinal reportStarnes Quickie Q-200 · Henderson, KYThe pilot's improper recovery from a bounced landing and his failure to maintain directional control, after experiencing an in-flight loss of control for undetermined reasons.NTSB MIA03LA100Accident · No injuriesLimited investigationFinal reportCessna 172P · Lantana, FLthe pilot's use of excessive airspeed and the improper touchdown point during the landing roll, which resulted in the airplane departing the runway, and impacting with trees.NTSB MIA03LA099Accident · No injuriesLimited investigationFinal reportCessna 172D · South Ponotoc, MSthe pilot's failure to maintain altitude and aircraft control during a low pass over a grass runway, which resulted in the airplane impacting the ground.NTSB CHI03LA115Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Romeoville, ILThe pilot not maintaining directional control during the landing rollout. A factor to the accident was the gusting crosswind.NTSB ATL03LA084Accident · No injuriesLimited investigationFinal reportBeech A23 · Brunswick, GAMaintenance personnel's failure to secure the fitting on a fuel line, which resulted in a loss of engine power.