NTSB investigations, 2001
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2001 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") = 2001 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 IAD02LA011Accident · No injuriesLimited investigationFinal reportCessna 182 · York, PAThe pilot in command's improper recovery from a bounced landing, which resulted in a hard landing and subsequent nose gear failure.NTSB IAD02LA005Accident · Minor injuriesLimited investigationFinal reportAerostar SA-60A · Luxor, PAThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion, and his subsequent inability to avoid power lines.NTSB FTW02LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Ozona, TXThe loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel the airplane. Contributing factors were the lack of suitable terrain for the forced landing and the dark night conditions.NTSB CHI02LA010Accident · No injuriesLimited investigationFinal reportBeech 58P · Columbus, NEThe exceeded aircraft performance and inadequate preflight planning/preparation by the pilot in command. The lack of recent experience in aircraft by the pilot in command was a contributing factor.NTSB CHI02FA006Accident · 1 fatalField investigationFinal reportCessna 150L · Union, ILThe pilot not maintaining appropriate airspeed which resulted in an inadvertent stall.NTSB ATL02LA007Accident · No injuriesLimited investigationFinal reportNorth American SNJ-6 · Kissimmee, FLSee narrative for ATL02LA007A.NTSB ATL02LA002Accident · Minor injuriesLimited investigationFinal reportBeech 19 · St Clair Spring, ALThe pilot misjudged the touchdown point that resulted in the runway overrun.NTSB ATL02LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Goldsboro, NCThe student pilot's failure to maintain directional control during a touch-and-go landing.NTSB LAX02FA008Accident · 1 fatalField investigationFinal reportBrock Thorp T-18 · El Mirage, CAthe corrosion and fatigue failure of the tail wheel fork.NTSB FTW02FA017Accident · 2 fatalField investigationFinal reportAerospatiale AS350B2 · Roswell, NMThe seizing of the cyclic control for an undetermined reason. A contributing factor was the lack of altitude for the pilot to regain control of the helicopter.NTSB CHI02LA008Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Jeffersonville, INThe dual student pilot's failure to maintain control of the helicopter, his failure to maintain altitude/clearance from the terrain, and the inadequate supervision by the flight instructor. A factor was the gusty wind condition.NTSB SEA02FA008Accident · 3 fatalField investigationFinal reportBell 206L · Anchorage, AKThe pilot's failure to maintain clearance from the surface of an open body of water while intentionally attempting to maintain a very low altitude while in cruise flight. Factors include falling snow, low ceilings, whiteout/greyout conditions, and flat/glassy…NTSB NYC02LA011Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Ashland, VAThe line technician's inadvertent contact with the propeller during a hand-propped engine start.NTSB NYC02FA012Accident · 3 fatalField investigationFinal reportCessna 172 · South Hero, VTThe pilot's failure to maintain aircraft control during the takeoff. Factors in this accident were wind gusts and the airplane's high gross weight condition.NTSB FTW02LA019Accident · Serious injuriesLimited investigationFinal reportBell 206L-3 · East Cameron 78The hard landing due to the pilot's failure to maintain proper main rotor rpm. Contributing factors were the loss of engine power for undetermined reasons, and the pilot's failure to deploy the emergency floats.NTSB SEA02FA007Accident · 2 fatalField investigationFinal reportCessna TR182 · Dixie, IDThe pilot's failure to refuel en route resulting in fuel exhaustion, and his inadvertent entry into a stall condition during the emergency descent. Contributing factors were dark night conditions and mountainous/hilly terrain.NTSB NYC02LA013Accident · No injuriesLimited investigationFinal reportEmbraer 145LR · Roanoke, VAthe captain's failure to maintain airspeed which resulted in an inadvertent stall/mush, and hard landing. Factors were the failure of both pilots to follow company CRM and flight manual procedures, and the captains improper approach briefing.NTSB NYC02LA010Accident · No injuriesLimited investigationFinal reportCessna 172L · Northampton, MAThe pilots' failure to maintain airspeed, which resulted in a loss of control and a hard landing.NTSB MIA02LA010Accident · No injuriesLimited investigationFinal reportBeech 58 · Gulfport, MSThe failure of the pilot to use the checklist resulting in a gear-up landing. Contributing factors in the accident were: 1) The inoperative landing gear warning system, 2) Inadequate preflight of the airplane by the pilot for his failure to assure that the…NTSB CHI02LA011Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Ann Arbor, MIThe pilots failure to maintain directional control during the landing. Factors were the gusty crosswind and the terrain drop-off.NTSB ATL02LA015Accident · No injuriesLimited investigationFinal reportCessna 188B · Whiteville, TNThe failure of the engine driven fuel pump that contaminated the fuel system and restricted fuel flow to the engine.. A factor is rough/uneven terrain.NTSB ANC02LA002Accident · Minor injuriesLimited investigationFinal reportEmbraer 120ER · Bethel, AKThe captain's continued descent below the minimum descent altitude which resulted in impact with terrain during an instrument landing approach. Factors contributing to the accident were the flightcrew's failure to reset the altimeters to the correct altimeter…NTSB SEA02FA005Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sandy, ORThe pilot's failure to maintain clearance from the trees while attempting to land in a field after entering an area of instrument meteorological conditions. Factors include low ceilings, rain, fog, strong winds, mountainous/hilly terrain, the pilot's…NTSB MIA02LA009Accident · No injuriesLimited investigationFinal reportCessna 172P · Knoxville, TNThe pilot's inattentive preflight inspection, non-compliance with the prestart checklist, decision to leave the cockpit unattended with engine running, and his inadvertent deactivation of the parking brake as he exited to remove a wheel chock, resulting in…NTSB FTW02LA015Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Midlothian, TXthe pilot's failure to maintain control of the aircraft while taxiing from a landing. A contributing factor was the gusty wind conditions.NTSB NYC02FA009Accident · 1 fatalField investigationFinal reportCessna 152 · Middlefield, CTThe pilot's failure to maintain sufficient altitude while maneuvering, which resulted in a collision with terrain. Factors in the accident were the dark night, rising terrain, and clouds.NTSB LAX02LA006Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Rosamond, CAThe pilot's failure to attain sufficient airspeed during the attempted takeoff, which resulted in a stall/mush. The airplane's failure to accelerate was due to a disintegrated bearing on the camshaft. The pilot's failure to make a timely abort decision was a…NTSB LAX02LA005Accident · Minor injuriesLimited investigationFinal reportAero Commander 690 · Temecula, CAa misrigging of the engine controls that resulted in an asymmetric reverse thrust condition.NTSB SEA02LA006Accident · No injuriesLimited investigationFinal reportCessna 182P · Sulfur Creek, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include the pilot's excessive rotation attitude, and soft/wet terrain conditions.NTSB NYC02LA008Accident · No injuriesLimited investigationFinal reportAerospatiale ATR 42-320 · Yardley, PAan in flight collision with birds.NTSB LAX02FA004Accident · No injuriesField investigationFinal reportPiper PA-28-140 · Van Nuys, CAThe failure of the air traffic controller to provide effective separation on the runway surface as specified in FAA Order 7110.65, Paragraph 3-9-6.NTSB FTW02LA016Accident · No injuriesLimited investigationFinal reportThunder and Colt AX8-90 · Albuquerque, NMthe pilot's failure to maintain clearance with the obstacles during landing. A contributing factor was the gusty winds.NTSB FTW02LA014Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Albuquerque, NMinadvertent flight into adverse (high wind) weather conditions, which resulted in an inflight collision with objects while landing. A contributing factor was the high wind weather condition.NTSB FTW02LA012Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Albuquerque, NMthe pilot's failure to maintain clearance with a power line during landing. A contributing factor was the high wind during the landing.NTSB SEA02LA004Accident · No injuriesLimited investigationFinal reportCessna 150L · Boardman, ORThe pilot-in-command's inability to maintain control of the aircraft while taxiing from landing resulting in a nose over. Contributing factors were high winds, crosswind conditions during taxi, and gusty wind conditions.NTSB MIA02LA007Accident · No injuriesLimited investigationFinal reportCessna A150L · Buena Vista, GAThe pilot's failure to use proper bounced landing technique, resulting in a hard touchdown, propeller strike, and noseover.NTSB IAD02LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Perkasie, PAThe pilot's improper flare, which resulted in a hard landing. A factor was the sun glare.NTSB DCA02WA005Accident · 2 fatalForeign investigationFairchild Swearingen SA-226-TC · Shamattawa, Man, CanadaNTSB CHI02LA005Accident · No injuriesLimited investigationFinal reportCessna 182N · Graham, MOA loss of engine power due to the fatigue failure of the number 2 piston. Contributing to the accident was the unsuitable terrain.NTSB ATL02LA006Accident · No injuriesLimited investigationFinal reportBeech BE-55-T42A · Raleigh, NCThe pilot's improper flare, and improper recovery from a bounced landing.NTSB WAS02WA005Accident · No injuriesForeign investigationBell 407 · Copiapo, ChileNTSB MIA02WA068Accident · Serious injuriesForeign investigationPiper PA-25-150 · Marcos Juarez, ArgentinaNTSB MIA02LA008Accident · Minor injuriesLimited investigationFinal reportCessna T206H · LakeLanier Isl., GAThe fatigue failure of the crankshaft for undetermined reasons resulting in the total loss of engine power. A contributing factor in the accident was the unsuitable terrain encountered by the pilot during the forced landing.NTSB LAX02FA003Accident · 1 fatalField investigationFinal reportEdge 540 · San Juan Capist, CAthe pilot's failure to maintain an adequate terrain/object altitude clearance while intentionally performing low level aerobatics, which resulted in a loss of aircraft control.NTSB NYC02LA007Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Philadelphia, PAThe collapse of the right main landing gear for undetermined reasons.NTSB LAX02LA007Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kahoolawe Isle, HIInadequate visual surveillance by the pilot before takeoff resulting in liftoff with a deplaning passenger still partially aboard the helicopter. A factor in the accident was the operator's inadequate procedures.NTSB LAX02IA002Incident · No injuriesIncident investigationFinal reportBoeing 737-700 · Santa Ana, CAThe failure of the stabilizer electric trim motor as a result of internal mechanical seizure.NTSB FTW02LA013Accident · Serious injuriesLimited investigationFinal reportAerostar International S81A · Albuquerque, NMthe selection of an unsuitable landing area by the pilot. A contributing factor was the high wind during the landing.NTSB DCA02WA004Accident · 10 fatalForeign investigationSwearingen Metroliner · Mediterranean, SpainNTSB DCA02MA003Accident · 10 fatalMajor investigationFinal reportCessna 208 · Dillingham, AKan in-flight loss of control resulting from upper surface ice contamination that the pilot-in-command failed to detect during his preflight inspection of the airplane. Contributing to the accident was the lack of a preflight inspection requirement for CE-208…