NTSB investigations, 2002
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 2002 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") = 2002 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 CHI02FA113Accident · 1 fatalField investigationFinal reportCessna 172RG · Marthasville, MOThe inadequate supervision and the stall encountered by the certified flight instructor.NTSB CHI02FA112Accident · 1 fatalField investigationFinal reportPiper 601P · Moscow, KSThe pilot's intentional operation of the airplane with a known engine boost problem resulting in the improper use of brakes to maintain directional control during takeoff, the brake system fire, and the loss of control for undetermined reasons during the…NTSB SEA02LA073Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Goshen, ORThe failure of company maintenance personnel to identify and replace/repair the degraded exhaust stack. Contributing factors were the mis-rigged carburetor heat control and the pilot's failure to maintain appropriate rotor RPM. Additional contributing factors…NTSB NYC02LA088Accident · Serious injuriesLimited investigationFinal reportBoeing 767-224 · Atlantic OceanThe airplane's inadvertent encounter which clear air turbulence during cruise flight.NTSB LAX02LA141Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Prescott, AZThe pilot's failure to maintain directional control of the aircraft during the landing roll.NTSB FTW02LA126Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Powderly, TXthe pilot's failure to maintain directional control during the takeoff roll, which resulted in an encounter with muddy terrain and a nose over. Contributing factors to the accident were the crosswind and muddy terrain.NTSB CHI02IA116Incident · No injuriesIncident investigationFinal reportBeech 200 · Hillsdale, WIThe fatigue failure of the passenger/crew door latch pin during cruise flight.NTSB SEA02LA072Accident · 1 fatalLimited investigationFinal reportGallagher Taylor "Coot" · Creswell, ORA loss of engine power due to oil starvation followed by the pilot's failure to maintain aircraft control during the initial climb shortly after takeoff. An improper engine modification was a factor.NTSB SEA02LA071Accident · No injuriesLimited investigationFinal reportBrunger Osprey II · Orofino, IDThe aircraft's inadequate carburetor heat air box system, leading to an accumulation of ice in the carburetor throat during final approach to landing. Factors include carburetor icing conditions, the pilot's failure to correctly judge the height of the…NTSB MIA02LA088Accident · No injuriesLimited investigationFinal reportCessna 180 · Canton, MSthe pilot's failure to maintain directional control after landing which resulted in the airplane departing the runway, and the subsequent impact with a ditch.NTSB MIA02LA087Accident · No injuriesLimited investigationFinal reportCessna 172H · Ehrhardt, SCthe pilot's failure to attain proper touchdown point while landing on a wet grass runway, resulting in the airplane departing the runway and impacting with trees.NTSB DEN02LA032Accident · No injuriesLimited investigationFinal reportBoeing E75 · Cheyenne, WYthe pilot's excessive use of the brakes, which resulted in a nose over.NTSB SEA02LA075Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Hot Springs, MTThe pilot's failure to adequately compensate for unfavorable wind conditions. Factors include unfavorable/shifting winds, and a tailwind gust.NTSB SEA02LA074Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Helena, MTFracture of the left main wheel assembly during the takeoff roll. Factors include the use of a wheel assembly not approved for the accident airplane, and the use of an oversized tire.NTSB NYC02LA086Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYThe flight instructors failure to maintain aircraft control during a wind gust. A factor in the accident was a sudden gust of wind.NTSB IAD02LA045Accident · No injuriesLimited investigationFinal reportCessna P210N · Linden, NJThe pilot's failure to lower the landing gear prior to landing.NTSB CHI02IA110Incident · No injuriesIncident investigationFinal reportPiper PA-34-220T · Sturgis, MIThe flightcrew not following the landing checklist, the flightcrew not lowering the landing gear, and the flight examiner's inadequate supervision of the flight.NTSB NYC02LA087Accident · No injuriesLimited investigationFinal reportCessna 150H · Smithville, OHThe pilot's failure to maintain directional control. A factor was the gusty windsNTSB MIA02LA086Accident · Serious injuriesLimited investigationFinal reportLett R/Campbell K Aircam · Troy, ALthe pilot-in-commands decision to fly at a low altitude and his improper visual lookout resulting in an in-flight collision static with wires.NTSB LAX02LA140Accident · No injuriesLimited investigationFinal reportCessna T206H · Sedona, AZThe pilot's inadequate compensation for the variable, gusty and crosswind conditions, which led to a bounced landing and a subsequent pilot induced porpoise oscillation. A factor in the accident was the pilot's decision to continue the landing in a crosswind…NTSB LAX02LA139Accident · No injuriesLimited investigationFinal reportBeech 76 · Petaluma, CAThe flight instructor's decision to execute a simulated single engine go-around at an altitude insufficient to preclude the inadvertent ground contact of the airplane and the resultant loss of directional control. The flight instructor's delayed remedial…NTSB CHI02LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Valparaiso, INThe pilot not maintaining aircraft control while encountering windshear during initial climbout, resulting in a stall at a low altitude.NTSB SEA02LA069Accident · No injuriesLimited investigationFinal reportWoodley Zodiac 601HD · Beaver, ORA partial failure of the electrical (ignition) system and a short to the master electrical switch during cruise flight resulting in a loss of engine power. A collision with an embankment during the landing roll was a factor.NTSB NYC02LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Matawan, NJThe pilot's inadequate weather evaluation, and excessive airspeed while landing. A factor was a tailwind.NTSB MIA02LA085Accident · 1 fatalLimited investigationFinal reportGrote Cruiser TR-4 · Pembroke Pines, FLthe pilot-in-command delayed initiating a go-around and failed to obtain sufficient altitude to clear obstacles at the departure end of the airport which resulted in an in-flight collision with power lines.NTSB FTW02LA125Accident · 1 fatalLimited investigationFinal reportHoward Harder Skybolt · Claremore, OKThe failure of the pilot to maintain clearance with terrain for undetermined reasons while conducting aerobatic maneuvers. A factor contributing to the accident was the physical impairment of the pilot.NTSB DCA02WA033Accident · 3 fatalForeign investigationCommander 112TC · Milan, ItalyNTSB CHI02LA111Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Springfield, MOThe flightcrew's failure to follow weather avoidance prcedures and their delay in activating the seat belt sign. Factors were the turbulent thunderstorm weather conditions, and the failure of the National Weather Service to issue an applicable in-flight…NTSB WAS02WA035Accident · 4 fatalForeign investigationCessna 172 · Pico, Duarte, Dominican RepublicNTSB NYC02LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Clifford, PAThe pilot's failure to maintain a proper visual lookout for trees. A factor was sunglare.NTSB ATL02LA087Accident · No injuriesLimited investigationFinal reportGreg Grouleff BD-5B · Bessemer, ALThe pilot's improper landing flare that resulted in a hard landing and the fracture of the left main landing gear casting.NTSB FTW02LA123Accident · No injuriesLimited investigationFinal reportHalfacre Velocity · Cleveland, TXthe pilot's failure to maintain the proper descent rate during the landing flare/touchdown.NTSB CHI02LA108Accident · Minor injuriesLimited investigationFinal reportLong FEW TF-51 · Summersville, MOThe unsuitable terrain encountered during the power off landing. The loss of engine power for unknown reasons was a contributing factor.NTSB CHI02LA107Accident · No injuriesLimited investigationFinal reportCessna 152 · Maple Lake, MNThe student pilot's inadequate flare and compensation for the crosswind condition during landing. A factor to the accident was the crosswind condition.NTSB MIA02FA084Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-35 · Carolina, PRThe failure of the pilot to maintain airspeed (Vs) while maneuvering following inadvertent encounter with clouds resulting in an inadvertent stall and uncontrolled descent and subsequent in-flight collision with trees, a wall, and a building.NTSB LAX02LA138Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A319-114 · Reno, NVThe failure of an undetermined cabin crewmember to securely close an aft galley compartment door, which necessitated the injured crewmember leaving her seat to secure the compartment door.NTSB LAX02LA136Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lake Los Angele, CAa reconditioned engine cylinder barrel failure due to previous rust damage and improper maintenance practices.NTSB FTW02LA120Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Lamesa, TXThe loss of engine power due to contamination of the fuel system. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DCA02RA032Accident · 138 fatalForeign investigationBoeing 767-200ER · Pusan, South KoreaNTSB CHI02LA104Accident · Serious injuriesLimited investigationFinal reportHoagland Varieze · Gary, INThe pilot was unable to maintain directional control of the airplane during the forced landing due to a locked brake. Factors associated with the accident were the pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion and the…NTSB ATL02LA085Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Gainesville, FLThe pilot's failure to maintain clearance from the ground during an attempted go-around.NTSB ATL02LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Conway, SCThe failure of the pilot to use proper wind correction technique, resulting in a loss of directional control of the aircraft.NTSB LAX02LA137Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Scottsdale, AZThe flight instructor's inadequate remedial action following the onset of ground resonance.NTSB ATL02TA083Accident · Serious injuriesFinal reportHughes OH-6A · Tampa, FLThe pilot's improper planning/decision to conduct an out of ground effect hover in a tailwind environment, which resulted in the loss of tail rotor effectiveness and the subsequent in-flight collision with water.NTSB ATL02LA086Accident · No injuriesLimited investigationFinal reportPiper J-3 · Carrollton, GAThe pilots failure to maintain flying speed that resulted in an inadvertent stall.NTSB ATL02LA084Accident · No injuriesLimited investigationFinal reportCessna 150D · Chatsworth, GAThe pilot's failure to apply carburetor heat that resulted in the loss of engine power. Factors were conditions favorable for the formation of carburetor icing and the selection of unsuitable terrain for a forced landing.NTSB ANC02LA030Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Sitka, AKA loss of engine power during cruise flight for an undertermined reason. A factor in the accident was rough/uneven beach terrain at the site of the forced landing.NTSB NYC02LA083Accident · No injuriesLimited investigationFinal reportBell 206-L3 · New York, NYThe pilot's improper flare while landing, which resulted in a collision with a concrete curb.NTSB IAD02FA043Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Oxford, CTThe pilot's failure to follow the published instrument approach procedure. Factors were the night and low ceiling conditions.NTSB FTW02LA122Accident · No injuriesLimited investigationFinal reportCessna 172R · McKinney, TXthe pilot's failure to maintain directional control of the airplane while taxiing from landing.