NTSB investigations, 2002
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 ANC02LA052Accident · No injuriesLimited investigationFinal reportGrumman G-21 · Northway, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in an inadvertent ground loop/swerve. A factor associated with the accident was a crosswind.NTSB SEA02LA103Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Heyburn, IDA blocked fuel line due to a gasket that had disintegrated and blocked the fuel line.NTSB IAD02LA059Accident · Minor injuriesLimited investigationFinal reportSchleicher ASK21 · Woodstock, VAThe pilot's failure to recognize the loss of orographic lift conditions. A factor was the loss of orographic lift.NTSB FTW02LA184Accident · No injuriesLimited investigationFinal reportCessna P210N · Shreveport, LAthe collapse of the right main landing gear for undetermined reasons.NTSB DEN02LA055Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Salt Lake City, UTtotal mechanical loss of engine power for reasons undetermined. Contributing factors were the lack of an annual inspection and the (forced landing in) salt water.NTSB CHI02LA166Accident · 1 fatalLimited investigationFinal reportJacobs Rutan Vari Viggen · Urbana, ILThe pilot's failure to abort the takeoff. Additional factors included the partial loss of engine power due to an excessively rich mixture as a result of a bad accelerator pump housing seal, and the pilot failed to maintain control of the airplane.NTSB ATL02LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, NCThe pilot's improper preflight planning and fuel management resulting in fuel exhaustion, and the total loss of engine power. The airplane nosed over during a forced landing to a cotton field.NTSB ATL02LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bethlehem, GAThe pilot's failure to follow operational procedures for the airplane, which resulted in a loss of engine power due to fuel starvation/fuel flow interruption. A factor was the lack of suitable terrain, resulting in a collision with an irrigation sprinkler…NTSB SEA02LA102Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Umpqua, ORThe pilot's failure to adequately compensate for unfavorable wind conditions and maintain clearance from the terrain during an attempted VFR go-around. Factors include an encounter with unfavorable wind conditions during the landing flare and the attempted…NTSB SEA02LA101Accident · No injuriesLimited investigationFinal reportCessna 182Q · Yellow Pine, IDCompensation for wind conditions inadequate during the approach for landing. A downdraft was a factor.NTSB MIA02FA111Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Osteen, FLthe pilot's inadequate weather evaluation and his failure to maintain control of the airplane after entering an area of thunderstorms resulting in an in-flight separation of the right wing and right horizontal stabilizer and impact with the ground during an…NTSB LAX02LA199Accident · No injuriesLimited investigationFinal reportCessna 172M · Saint Johns, AZthe pilot's inadequate compensation for wind conditions resulting in a loss of directional control and collision with terrain. Related factors were the wind gusts, crosswind and soft terrain.NTSB LAX02FA198Accident · Serious injuriesField investigationFinal reportCessna 182Q · Deer Valley, AZa loss of engine power for undetermined reasons during the takeoff initial climb, and, the pilot's failure to maintain an adequate airspeed while maneuvering to return to the runway, which resulted in a stall.NTSB FTW02LA182Accident · No injuriesLimited investigationFinal reportCessna R172K · Llano, TXthe pilot's failure to refuel the airplane, which resulted in fuel exhaustion and a forced landing.NTSB FTW02LA178Accident · No injuriesLimited investigationFinal reportCessna 172M · Kirbyville, TXthe pilot's failure to attain the proper touchdown point. A contributing factor was the loose gravel.NTSB CHI02LA178Accident · No injuriesLimited investigationFinal reportCessna 182Q · Vermillion, SDThe pilot's improper flare.NTSB CHI02LA168Accident · Minor injuriesLimited investigationFinal reportBumgarner CA65 Sky Fly · Warrensburg, MOThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor associated with the accident was the overload failure of the right main landing gear.NTSB CHI02LA165Accident · No injuriesLimited investigationFinal reportFirm Kit Fox 4-1200 · Virginia, MNAn in-flight collision with a bird that resulted in severed fuel lines and the subsequent in-flight fire and loss of engine power. A factor in the accident was the soft terrain condition.NTSB ATL02LA122Accident · No injuriesLimited investigationFinal reportCessna 172R · N Myrtle Beach, SCThe pilot's failure to maintain airspeed during a banner tow pickup resulting in an inadvertent stall and uncontrolled descent and collision with terrain.NTSB ANC02LA050Accident · No injuriesLimited investigationFinal reportCessna 185F · Talkeetna, AKA fracture failure of the lower end of the spring steel landing gear strut. Factors contributing to the accident were the manufacturer's and the FAA's insufficient standards/requirements for inspection procedures.NTSB ANC02LA049Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's inadequate compensation for wind conditions, and the excessive use of the airplane's brakes, which resulted in a nose over. A contributing factor to the accident was a wind gust.NTSB SEA02LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsboro, ORAn improper flare during the landing. Not performing a proper recovery from a bounced landing was a factor.NTSB LAX02LA197Accident · 1 fatalLimited investigationFinal reportPiper PA-22-135 · Brownsville, CAa loss of engine power for undetermined reasons. Also causal was the pilot's failure to maintain an adequate airspeed during a turn to reverse course back to the runway, resulting in a stall and collision with terrain.NTSB LAX02LA196Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · North Las Vegas, NVthe student pilot's improper liftoff into tailwind conditions, improper use of the collective, and failure to relinquish the flight controls to the CFI, resulting in the helicopter colliding with terrain. Also causal was the CFI's inadequate supervision and…NTSB FTW02WA196Accident · No injuriesForeign investigationDouglas DC-9-15 · Neiva, ColombiaNTSB FTW02LA180Accident · Serious injuriesLimited investigationFinal reportFrennance Twinstar · Bastrop, LAthe pilot's failure to maintain altitude for an undetermined reason, which resulted in an in-flight collision with trees.NTSB DEN02LA054Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Glenwood Sprngs, COthe pilot's failure to maintain clearance from a tree while conducting an aborted landing. Contributing factors were the pilot’s low approach airspeed, and his failure to maintain directional control during landing roll.NTSB CHI02LA164Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · St. Joseph, MOThe pilot's failure to attain proper alignment with the runway.NTSB SEA02LA099Accident · No injuriesLimited investigationFinal reportCessna 172K · Clarkston, WAThe pilot's failure to maintain control of the aircraft during taxi along the gravel landing site after having landed off the designated runway. A contributing factor was the embankment which the aircraft's left wing impacted during taxi.NTSB MIA02LA112Accident · No injuriesLimited investigationFinal reportCessna 172S · Kill Devil Hill, NCthe pilot's failure to maintain control of the airplane after an attempted aborted landing, and while braking during the landing roll, which resulted in the airplane departing the end of the runway and impacting with a ditch.NTSB MIA02LA110Accident · 1 fatalLimited investigationFinal reportHarrison Pietenpol Air Camper · Bainbridge, GAa loss of power due to the passenger's inadvertent deactivation and restricting the movement of the throttle, which resulted in a forced landing and subsequent impact with trees.NTSB LAX02LA206Accident · No injuriesLimited investigationFinal reportBeech BE76 · Prescott, AZThe student pilot's decision to abort the takeoff with insufficient runway remaining, resulting in a runway overrun and collision with a berm. A factor was the cabin door opening during the takeoff roll.NTSB DCA02WA044Incident · No injuriesForeign investigationBoeing 747-240B · Manchester, United KingdomNTSB CHI02LA162Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Beaumont, KSThe pilot's inadequate preflight planning and his failure to abort the takeoff when he realized the aircraft was not accelerating as expected. The wet and muddy turf runway was a contributing factor.NTSB ANC02LA051Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Talkeetna, AKThe pilot's selection of an unsuitable taxi area, which resulted in substantial damage to the left elevator when the tailwheel encountered a hole. A factor associated with the accident was rough/uneven terrain.NTSB ANC02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe student pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in the right wing striking the ground.NTSB MIA02TA109Accident · No injuriesFinal reportAgusta A119 · Okeechobee, FLthe fracture of one of the tail rotor blades as a result of fatigue cracking in the blade spar, and subsquent impact of the main rotor with the tailboom.NTSB DEN02LA053Accident · No injuriesLimited investigationFinal reportCessna 172F · Salt Lake City, UTthe pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB NYC02LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Gettysburg, PAThe pilot's failure to accurately compute takeoff performance and his failure to establish a positive climb resulting in a collision with trees.NTSB NYC02LA112Accident · No injuriesLimited investigationFinal reportCessna 182RG · Worcester, MAThe failure of the nose wheel actuator o-ring.NTSB FTW02LA198Accident · No injuriesLimited investigationFinal reportAirbus Industrie A300-600F · El Paso, TXThe flight crew's failure to obtain the Vr speed prior to rotation which resulted in insufficient lift and the subsequent tail strike.NTSB CHI02LA163Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A-1 · Jordan, MNThe loss of engine power due to improper maintenance by unknown maintenance personnel which led to a misalignment of the gearbox casing.NTSB CHI02LA159Accident · 1 fatalLimited investigationFinal reportGalbraith Piel Emeraude · Hot Springs, SDThe loss of engine power due to the connecting rod fatigue failure during takeoff climb.NTSB ANC02LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · Bethel, AKThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in the right wing striking the runway.NTSB FTW02WA209Accident · Minor injuriesForeign investigationCessna T188-C · Los Rios, EcuadorNTSB DEN02TA052Accident · No injuriesFinal reportBeech 58P · Grand Junction, COthe pilot's inadvertent flight into adverse weather conditions. A factor contributing to the accident was the terrain-induced turbulence.NTSB DEN02LA051Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28C · Medicine Bow, WYthe unsuitable terrain encountered during the emergency autorotation, following a partial loss of engine power. Factors contributing to this accident were fuel contamination (water), the low altitude, the high winds, and the tailwind.NTSB CHI02LA158Accident · No injuriesLimited investigationFinal reportBeech B35 · Lakewood, WIThe pilot's failure to maintain control of the aircraft during takeoff when he encountered a stall after failing to maintain airspeed.NTSB ANC02LA046Accident · No injuriesLimited investigationFinal reportCessna 150 · Hope, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a ditch. A contributing factor in the accident was the presence of a ditch in the landing area.NTSB SEA02LA098Accident · 1 fatalLimited investigationFinal reportUnknown Quicksilver MX II · Cook, WAFailure to maintain aircraft control. High winds were a factor.