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 LAX03LA153Accident · No injuriesLimited investigationFinal reportBeech B19 · Chandler, AZthe pilot's failure to maintain directional control on the landing roll due to his inadvertent use of brakes.NTSB FTW03LA154Accident · Minor injuriesLimited investigationFinal reportBeech BE-300 · Houston, TXThe severed hydraulic brake hoses induced a loss of braking action, which resulted in the pilot's failure to control the aircraft.NTSB CHI03LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Freeport, ILThe pilot's misjudgment of distance and altitude, and his failure to maintain obstacle clearance.NTSB SEA03LA083Accident · No injuriesLimited investigationFinal reportCessna 182J · Payette, IDThe pilot-in-command's failure to maintain directional control during the landing roll resulting in the aircraft departing the runway environment, collapsing the nose gear and nosing over. Contributing factors were the pilot-in-command's failure to execute a…NTSB LAX03LA152Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Payson, AZthe pilot's inadequate recovery from a bounced landing, failure to retract the flaps during an aborted landing attempt, failure to maintain an adequate airspeed, and failure to maintain directional control. A factor in the accident was the high density…NTSB DEN03TA082Accident · No injuriesFinal reportCessna 182R · Boulder, COthe pilot's failure to maintain aircraft control during landing flare/touchdown which resulted in a hard landing. A contributing factor was the pilot's improper flair.NTSB DEN03LA081Accident · Serious injuriesLimited investigationFinal reportAerostar International S66A-3060 · Albuquerque, NMthe pilot's failure to maintain aircraft control during a high wind landing, which resulted in a hard landing. Contributing factors include the high wind and the berm.NTSB CHI03LA136Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Minocqua, WIThe pilot's failure to attain a proper climb rate during takeoff. A factor to the accident was the tree.NTSB CHI03LA128Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Lake Ozark, MOAn inability to maintain control of the helicopter during the wind gust and brief tail wind. The ravine, wind gust and tailwind were contributing factors to the accident.NTSB ATL03LA095Accident · No injuriesLimited investigationFinal reportAerospatiale AS355F2 · Bainbridge, GAThe pilot's improper flare during an attempted landing.NTSB ANC03LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Kenai, AKThe pilot's failure to compensate for gusting wind conditions during the landing flare, which resulted in the airplane encountering brush, and nosing over. Factors contributing to the accident were high brush, and gusting winds.NTSB SEA03LA087Accident · No injuriesLimited investigationFinal reportCessna 210N · Lewistown, MTThe loss of engine power for undetermined reasons. The condition of the runway overrun was a factor.NTSB SEA03LA086Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Basin City, WAThe failure of the torque sensor idler gear duplex bearing during agricultural aerial application, resulting in a total power loss and a forced landing. Factors include tall wheat and soft terrain.NTSB FTW03LA155Accident · No injuriesLimited investigationFinal reportOMF 100-160 · San Antonio, TXThe pilot's failure to land at the proper touchdown point, which resulted in the overrun of the runway.NTSB FTW03LA152Accident · No injuriesLimited investigationFinal reportCessna A188B · Fabens, TXThe pilot's failure to maintain terrain clearance. The pilot's attempt to avoid an obstacle was a contributing factor.NTSB ATL03LA094Accident · 4 fatalLimited investigationFinal reportKerner Lancair IV · Allendale, SCThe pilot's inadvertent flight into adverse weather ,thunderstorms, that resulted in the design limits of the airplane being exceeded.NTSB ANC03LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Aniak, AKThe pilot's failure to maintain clearance from terrain while maneuvering, which resulted in the airplane colliding with terrain. A factor contributing to the accident was the pilot's diverted attention.NTSB SEA03LA082Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Salem, ORLoss of power in cruise flight due to a catastrophic engine failure for undetermined reasons.NTSB SEA03LA081Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Colville, WAThe pilot's inadequate compensation for wind conditions on landing. A contributing factor was a crosswind.NTSB NYC03LA110Accident · No injuriesLimited investigationFinal reportAgusta A109E · Harbor Creek, PAThe pilot's improper preflight inspection, during which he failed to remove a flashlight from the tailboom strake. A factor was the pilot's attention be diverted by a mechanic during the preflight inspection.NTSB NYC03LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gaithersburg, MDThe pilot’s failure to maintain airspeed, resulting in an inadvertent stall.NTSB NYC03LA107Accident · Minor injuriesLimited investigationFinal reportCessna 208B · New Russia, OHThe pilot's failure to verify the position of the fuel selectors prior to takeoff, which resulted in a power loss due to fuel starvation. A factor was the failure of the fuel selector warning horn.NTSB NYC03LA106Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · New Canaan, CTThe inadequate annual inspection performed by maintenance facility personnel, which resulted in a failure of a fuel system bellcrank. Factors were the subsequent inadequate inspections by other maintenance personnel and the pilot.NTSB MIA03LA109Accident · Serious injuriesLimited investigationFinal reportBill Darling Rans S9 · Green Cove Sprg, FLA loss of engine power for undetermined reasons.NTSB LAX03WA156Accident · No injuriesForeign investigationBeech 200C · Coffs Harbour, AustraliaNTSB LAX03LA151Accident · No injuriesLimited investigationFinal reportCessna 172S · Camarillo, CAthe student pilot's failure to maintain directional control, resulting in a collision with terrain. The flight instructor's inadequate supervision of the flight and delayed remedial action were also causal.NTSB FTW03LA153Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Longview, TXThe failure of the engine ignition system for undetermined reasons resulting in a loss of engine power. A contributing factor was the lack of suitable terrain for an auto rotational landing.NTSB FTW03LA151Accident · No injuriesLimited investigationFinal reportCessna A188B · Kinta, OKThe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's failure to supervise the refueling of the aircraft and failure to use his before takeoff checklist.NTSB FTW03LA150Accident · Serious injuriesLimited investigationFinal reportCessna 320-D · EL Paso, TXthe loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control. Contributing factors were the gusty and high wind conditions, and the pilot's failure to compensate for the wind conditions.NTSB CHI03LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-135 · Prescott, WIThe pilot delaying the go-around and the maneuver to avoid the treeline. Factors to the accident were the treeline and the airplane's low altitude.NTSB CHI03LA126Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cedar Springs, MIThe pilot's inadequate glidepath and his failure to maintain obstacle clearance. A factor to the accident was the semi-trailer.NTSB ATL03LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bristol, TNThe pilot's improper use of the rudder controls during the takeoff roll resulting in a loss of directional control, and the on-ground collision with an embankment.NTSB FTW03LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Conroe, TXthe student pilot's inadequate compensation for wind. A contributing factor was the gusting wind conditions.NTSB CHI03LA135Accident · No injuriesLimited investigationFinal reportCessna R172K · Kirksville, MOThe pilot's improper in-flight decision to land with a tailwind and failure to perform an aborted landing, resulting in the pilots decision to control the aircraft off of the right edge of the runway to avoid obstructions. Contributing factors were the…NTSB CHI03LA125Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Wilmot, WIThe loss of engine power for an undetermined reason, and the unsuitable terrain encountered for the forced landing. A factor was the fence.NTSB CHI03LA124Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Benkelman, NEThe pilot's failure to maintain altitude clearance while maneuvering. Contributing factors were the wheat crop and the ground.NTSB MIA03CA108Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Baxterville, MSThe pilot's decision to continue the takeoff at a low airspeed which resulted in a stall, an uncontrolled descent, and an impact with terrain.NTSB ATL03LA096Accident · No injuriesLimited investigationFinal reportCessna 150G · Morris, ALThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a ground collision with terrain, and subsequent collapse of the nose gear.NTSB ATL03LA092Accident · No injuriesLimited investigationFinal reportCessna 172H · Somerville, TNThe pilot's misjudged approach airspeed and distance which resulted in an undershoot of the runway and collision with terrain.NTSB NYC03LA105Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Roanoke, VAThe pilot's inadequate compensation for winds, and failure to maintain directional control. A factor in this accident was the gusty wind conditions.NTSB LAX03TA150Accident · Serious injuriesFinal reportHughes OH 6A · Pan Tak, AZThe pilot in command's failure to adequately secure loose cargo (a jacket), which resulted in the jacket colliding with the tail rotor during cruise flight, and the subsequent separation of the tail rotor and loss of flight control. A factor associated with…NTSB FTW03CA146Accident · Minor injuriesData collectionFinal reportBell 47G-4 · Robinson, TXThe pilot's failure to maintain clearance with the ground while performing a quick stop maneuver which resulted in a dynamic rollover.NTSB ATL03LA087Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Beaufort, NCThe pilot's failure to follow the checklist and set the parking brake which resulted in the airplane colliding with a parked airplane.NTSB NYC03LA103Accident · Serious injuriesLimited investigationFinal reportFrancis Giroux Moni-Motorglider 032 · Glens Falls, NYThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the excessive taxi speed, and the inadvertent lift off.NTSB MIA03LA115Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Brooksville, FLThe in-flight collision with a Black Vulture resulting in substantial damage.NTSB IAD03FA053Accident · 3 fatalField investigationFinal reportBeech 24R · Wauseon, OHThe pilots failure to maintain control during the approach-to-landing. Factors were the high wind gusts and turbulence, and the pilot's decision to fly in those conditions.NTSB FTW03FA148Accident · No injuriesField investigationFinal reportBell 407 · Gulf Of MexicoThe short circuit of the C321capacitor in the Electronic Control Unit (ECU) that resulted in a single-point failure of the ECU's -15V power supply which disengaged/reverted the Hydro-mechanical Unit (HMU) from automatic to manual fuel control. Factors…NTSB SEA03LA079Accident · No injuriesLimited investigationFinal reportCessna P210N · Boise, IDThe landing gear extension was not performed by the pilot for landing. Contributing factors included the pilot's failure to perform the Before Landing checklist and his unfamiliarity with the landing gear warning horn system.NTSB MIA03CA107Accident · No injuriesData collectionFinal reportMichael Allen Brown RAF 2000 GTX · Punta Gorda, FLThe pilot's failure to maintain rotor speed during the takeoff which resulted in the gyrocopter descending and the main rotor impacting the ground, incurring damage.NTSB MIA03CA106Accident · No injuriesData collectionFinal reportEnstrom 280C · Panama City Bch, FLThe pilot's failure to maintain adequate rotor rpm and altitude during takeoff which resulted in the helicopter impacting the water during a descent in an attempt to maintain rotor rpm.