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 MIA02LA024Accident · No injuriesLimited investigationFinal reportCessna 172M · Crystal River, FLthe pilot's failure to keep a proper visual lookout and ensure proper clearance during taxi operations, which resulted in a collision with vehicles.NTSB MIA02LA023Accident · No injuriesLimited investigationFinal reportBoeing 727-233 · Memphis, TNThe inadvertent collision with birds while on final approach to land resulting in substantial damage to the airplane.NTSB DCA02WA007Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Taipei, TaiwanNTSB MIA02LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Deland, FLThe loss of engine power during takeoff/initial climb due to undetermined reasons.NTSB FTW02FA037Accident · 1 fatalField investigationFinal reportGrumman American AA-1B · Patterson, LAThe pilot's mismanagement of fuel with the positioning of the fuel selector in the off position and his failure to maintain airspeed resulting in fuel starvation, and the airplane entering into a stall.NTSB MIA02LA022Accident · 1 fatalLimited investigationFinal reportRobert N. Gilmore Rans S-10 · Oneonta, ALThe failure of the pilot to maintain airspeed following loss of engine power resulting in the airplane stalling and entering a spin from which it crashed. Factors in the accident was improper repair of the front cylinder intake manifold seal by the pilot…NTSB MIA02LA021Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Southern Pines, NCThe dislodging of the front crankshaft oil seal for undetermined reasons resulting in loss of engine oil, loss of engine power, and collision with a tree and then the ground during a forced landing.NTSB MIA02LA020Accident · No injuriesLimited investigationFinal reportMooney M20C · High Springs, FLThe pilot's improper preflight planning/preparation and failure to ensure sufficient fuel was available to complete the flight, which resulted in fuel exhaustion, a forced landing, and damage to the aircraft when it collided with a fence during the landing…NTSB CHI02LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Sedalia, MOThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident was the soft, rough/uneven terrain.NTSB CHI02LA040Accident · Minor injuriesLimited investigationFinal reportLyon Horizon 1 · Richland, MOThe pilot not attaining altitude/clearance from the tree line during the aborted landing. Factors to the accident were the pilot selecting to operate the airplane on the rough/uneven runway, the pilot's lack of total experience in the airplane, and the tree…NTSB MIA02LA018Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Belle Glade, FLThe loss of engine oil for undetermined reasons that resulted in the engine seizing, a forced landing on a dirt road, and an impact with a vehicle on the dirt road during the landing rollout.NTSB FTW02LA038Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Richmond, TXthe pilot's failure to maintain clearance from the power line while landing.NTSB CHI02LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Vandalia, MOThe student pilot's inadequate directional control on the previous landing resulting in the overload failure of the nose landing gear fork. Factors were the overload of the nose landing gear fork, and the student pilot's lack of total experience.NTSB CHI02LA035Accident · No injuriesLimited investigationFinal reportBeech 76 · Greenwood, INthe directional control not maintained by the pilot. A contributing factor was the stuck open intake valve on the left engine.NTSB CHI02FA034Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Spearville, KSthe pilot's failure to maintain aircraft control and his inadvertent flight into known adverse weather conditions. Factors relating to this accident were the pilot's limited ability to see at night, spatial disorientation, the dark night, and the fog.NTSB MIA02LA040Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-BA · Swanee, GAThe pilot's improper visual lookout while hovering the helicopter, which resulted in the helicopter's main rotor blades colliding with a light post.NTSB MIA02LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Peachtree City, GAThe pilot’s attempted operation of the aircraft with known deficiencies in the engine ignition system resulting in failure of the engine due to ignition system failure and damage to the airplane during the subsequent forced landing.NTSB MIA02FA032Accident · 1 fatalField investigationFinal reportCessna 152 · Poplarville, MSThe pilot's becoming lost and disoriented and his failure to maintain control of the airplane while flying over an unpopulated area on a dark night, which was the result of spatial disorientation. Factors in the accident was the pilot's consuming alcoholic…NTSB IAD02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Coatesville, PACollision with a deer during the takeoff roll.NTSB FTW02LA049Accident · No injuriesLimited investigationFinal reportBeech BE-50 · Altus, OKThe pilot's improper flare and his failure to maintain directional control. A contributing factor was the ditch.NTSB DEN02LA012Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Montrose, COthe loss of engine power during initial climb for undetermined reason. A factor was the lack of suitable terrain for a forced landing.NTSB CHI02FA033Accident · 2 fatalField investigationFinal reportZenair CH2000 · Wentzville, MOThe improper selection of the fuel selector which resulted in fuel starvation and subsequent engine failure. Factors were the unsuitable terrain for the forced landing encountered by the pilot and the night light condition.NTSB SEA02LA015Accident · No injuriesLimited investigationFinal reportCessna 402B · Pasco, WAthe pilot's failure to keep the aircraft from touching down short of the displaced threshold, and his failure to maintain directional control after the aircraft's left main gear tire deflated as a result of impacting the lip at the beginning of the subject…NTSB MIA02LA016Accident · No injuriesLimited investigationFinal reportCessna T310R · Madison, MSThe pilot's failure to verify that the landing gear was down and locked prior to landing resulting in the airplane being landed with the landing gear retracted.NTSB IAD02LA013Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Leesburg, VAThe pilot's improper stowage of hazardous material.NTSB FTW02LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Galveston, TXthe pilot's failure to set the parking brake before exiting the aircraft to remove the wheel chocks.NTSB SEA02LA014Accident · Serious injuriesLimited investigationFinal reportBölkow BO 105 LS · Mud Lake, IDPilot's failure to maintain adequate separation from terrain during the initial climb. Factors include spatial disorientation and a dark moonless night.NTSB NYC02TA029Accident · Minor injuriesFinal reportKaman K-1200 · Bloomfield, CTThe pilot's failure to maintain aircraft control while hovering. A factor related to the accident was the pilots lack of experience in type of aircraft.NTSB LAX02LA029Accident · No injuriesLimited investigationFinal reportAviat S-2C · Chandler, AZFailure of the flight instructor to maintain directional control resulted in a departure from the runway surface and collision with a runway sign.NTSB LAX02FA028Accident · 2 fatalField investigationFinal reportCessna 340A · Santa Monica, CAThe pilot's failure to remove the control gust lock prior to takeoff and his failure to abort the takeoff with sufficient runway remaining to stop the airplane on the runway.NTSB FTW02LA034Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Benton, LAin-flight collision with trees while on final approach to land for an undetermined reason.NTSB SEA02LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Brewster, WAThe magneto was inadvertently switched off by the pilot during the climb. A tree was a factor.NTSB LAX02LA026Accident · No injuriesLimited investigationFinal reportCessna 172M · Chandler, AZFailure of the student pilot to maintain directional control during landing.NTSB FTW02LA032Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Houston, TXthe failure of the left outboard elevator attachment, which resulted in the partial separation of the left elevator and induced an airframe vibration.NTSB FTW02FA036Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Graham, TXThe pilot's failure to discontinue the approach after encountering instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing factors were the dark night light condition, low ceiling, and reduced visibility due to fog.NTSB NYC02TA026Accident · Serious injuriesFinal reportBell 407 · Whitley City, KYThe pilots decision to operate the helicopter at an airspeed in excess of the maximum demonstrated stable airspeed for the water bucket. A factor in the accident was the pilot did not follow the published emergency procedure.NTSB NYC02FA025Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mansfield, OHthe pilot's improper use of carburetor heat, and subsequent forced landing. Factors were the carburetor icing condition, night conditions, trees, and the pilot's impairment from ingestion of an over-the-counter antihistamine.NTSB DCA02MA001Accident · 265 fatalClass 1 · MajorFinal reportAirbus Industrie A300B4-605R · Belle Harbor, NYthe in-flight separation of the vertical stabilizer as a result of the loads beyond ultimate design that were created by the first officer's unnecessary and excessive rudder pedal inputs. Contributing to these rudder pedal inputs were characteristics of the…NTSB CHI02LA029Accident · No injuriesLimited investigationFinal reportSchenfield Acro Sport II · Keosauqua, IAAircraft control not maintained by pilot during landing.NTSB CHI02FA025Accident · 2 fatalField investigationFinal reportCessna 150M · Dyer, INThe failure of the flight crew to maintain adequate airspeed, resulting in an inadvertent stall/spin and the flight instructor's inadequate supervision of the flight, his impairment due to the use of over-the-counter medication is a contributing factor.NTSB NYC02LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cattaraugus, NYA separation of the cylinder from the engine for undetermined reason(s). A factor was the hidden ground obstruction (hole) which the airplane struck during the landing roll.NTSB CHI02LA028Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Nevada, MOThe inadequate fuel consumtion calculations by the pilot resulting in fuel starvation during the aborted landing, and the overloaded steering link for undetermined reasons resulting in the lack of directional control during landing. Factors were the…NTSB ATL02LA013Accident · No injuriesLimited investigationFinal reportCessna 172S · Sarasota, FLThe operators failure to ensure adequate training had been provided to the student pilot in autopilot operations, and the student pilot's failure to comply/ follow written instructions (Federal Regulations/172 Skyhawk Information Manual) pertaining to the…NTSB SEA02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Puyallup, WAThe pilots' failure to maintain aircraft control on short final, resulting in a touchdown off of the prepared landing surface. A factor was grassy terrain encountered on the landing rollout.NTSB LAX02LA027Accident · No injuriesLimited investigationFinal reportCessna 210K · North Las Vegas, NVThe failure of maintenance personnel to properly diagnose the cause of a reported maintenance discrepancy resulting in the airplane being released from an annual inspection with a worn hydraulic pump which lacked sufficient output to operate the landing gear.…NTSB LAX02LA025Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Nogales, AZThe pilot failed to maintain directional control while landing in a cross wind. He attempted a go-around, but inadvertently stalled the airplane, which resulted in an uncontrolled descent and collision with the runway.NTSB IAD02LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Corning, NYThe CFI's delayed remedial action, which resulted in a loss of control during landing rollout and impact with a parked airplane.NTSB FTW02LA035Accident · No injuriesLimited investigationFinal reportTerry Zenith 801 · Manvel, TXloss of engine power while maneuvering for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA033Accident · No injuriesLimited investigationFinal reportBell 407 · Erath, LAThe pilot's inadvertant application of full right pedal which resulted in the baggage compartment door to open in-flight and a tie down rope to become entangled in the tail rotor drive system, and the failure of the tail rotor drive shaft resulting in the…NTSB DEN02LA009Accident · No injuriesLimited investigationFinal reportEsbenshade Starduster Too SA300 · Evans, COthe pilot's failure to maintain clearance of the wires. A contributing factor was the trees the airplane struck while the pilot was attempting to regain aircraft control.