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 LAX02LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Kingman, AZThe failure of the pilot to maintain directional control during landing.NTSB IAD02IA046Incident · No injuriesIncident investigationFinal reportFairchild Dornier DO-328-300 · Atlantic City, NJThe partial loss of flight display information for undetermined reasons.NTSB FTW02WA141Accident · Minor injuriesForeign investigationBell 206L3 · Coca, EcuadorNTSB FTW02LA137Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Tuckerman, ARThe pilot's operation of the airplane with a known equipment deficiency, which resulted in fuel leakage and a loss of engine power due to fuel exhaustion. A contributing factors was the lack of suitable terrain for the forced landing.NTSB FTW02LA136Accident · No injuriesLimited investigationFinal reportCessna 560 · Leakey, TXThe pilots failure to land the aircraft at the proper touchdown point on the runway to allow adequate stopping distance.NTSB FTW02LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Teresa, NMthe pilot's inadequate compensation for the gusty crosswind conditions resulting in a loss of control of the airplane during the landing. A contributing factor was the gusty crosswind.NTSB NYC02LA101Accident · No injuriesLimited investigationFinal reportCessna 182Q · Teterboro, NJThe pilot's improper flare and his improper recovery from a bounced landing, which resulted in a hard landing. A factor in this accident was the crosswind condition.NTSB NYC02LA091Accident · No injuriesLimited investigationFinal reportCessna 182A · Moneta, VAA slow leak of brake fluid from the right brake cylinder, which eventually resulted in a loss of right brake effectiveness.NTSB NYC02LA090Accident · No injuriesLimited investigationFinal reportBell 47J-2A · Blairstown, NJThe pilot's improper flare, and his failure to maintain obstacle clearance which resulted in a tail strike.NTSB LAX02LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Pacific Ocean (Pacific Ocean)An in-flight encounter with clear air turbulence and wind shear, which resulted in a serious injury to a flight attendant.NTSB IAD02FA047Accident · No injuriesField investigationFinal reportBeech 400A · Baltimore, MDThe captain's failure to go around. Factors included the captain's preoccupation with the flight management system, the crew's failure to adhere to company standard operating procedures, and the lack of proper crew coordination.NTSB FTW02LA134Accident · 1 fatalLimited investigationFinal reportRobinson Tierra II · Hooker, OKthe loss of control for an undetermined reason, which resulted in an in-flight collision with terrain.NTSB CHI04LA124Accident · No injuriesLimited investigationFinal reportBeech 58 · Lansing, ILThe flight crew's failure to follow the checklist resulting in a landing without the landing gear extended.NTSB MIA02LA092Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Headland, ALa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB MIA02LA090Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Myakka City, FLthe pilot's failure to maintain altitude while maneuvering during an aerial application, subsequently resulting in impact with the terrain.NTSB LAX02WA287Accident · No injuriesForeign investigationHughes 369D · Mt. Tarawera, New ZealandNTSB CHI02LA118Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Racine, WIThe inadequate weather evaluation and delayed application of carburetor heat by the pilot, and the unsuitable terrain encountered during the forced landing. The carburetor icing conditions and the low altitude were factors.NTSB CHI02LA117Accident · Serious injuriesLimited investigationFinal reportCessna 411 · Lee's Summit, MOThe pilot failed to maintain control of the airplane during the inital takeoff climb. Factors associated with the accident were the pilot's inadequate preflight of the airplane, the separation of the emergency exit, and the pilot's lack of a multi-engine…NTSB FTW02LA138Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Alsatia, LAThe main rotor contact to the tail boom resulting from the pilot leaving the helicopter unattended while the rotors were engaged.NTSB FTW02LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Owasso, OKThe loss of engine power as a result of the pilot's failure to remove the engine cowling plugs during the preflight inspection. A contributing factor was lack of suitable terrain for the forced landing.NTSB FTW02LA132Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Gillett, ARthe pilot's failure to maintain directional control on landing. A contributing factor was the high vegetation.NTSB CHI02LA124Accident · No injuriesLimited investigationFinal reportCessna 185F · Cumberland, WIthe failure of the pilot to maintain directional control after encountering high winds and gusty winds during taxi from landing.NTSB ATL02LA090Accident · No injuriesLimited investigationFinal reportCessna 177 · Locust Grove, GAThe pilot improper flare during an aborted takeoff, followed by an subsequent hard landing.NTSB SEA02LA077Accident · No injuriesLimited investigationFinal reportCessna 177B · New Plymouth, IDThe pilot's use of unsuitable terrain (landing surface) at his privately owned landing site. A contribtuing factor was the soft area which the aircraft's right main wheel encountered.NTSB SEA02LA076Accident · Serious injuriesLimited investigationFinal reportCook RS-15 · Richland, WAAirspeed was not maintained while maneuvering. An inadvertent stall, remedial action was not attained, and the student pilot's lack of total experience were factors.NTSB MIA02LA091Accident · No injuriesLimited investigationFinal reportCessna 172S · Daytona Beach, FLthe pilot misjudged the landing flare, resulting in a hard landing, and damage to the airplane.NTSB LAX02FA148Accident · 3 fatalField investigationFinal reportBeech C23 · Oak Shores, CAthe number 1 cylinder exhaust valve fractured and separated resulting in a loss of engine power and an off airport forced landing. A finding in the accident was the owner's failure to maintain the engine in accordance with the manufacturer's recommendations.NTSB DEN02LA041Accident · No injuriesLimited investigationFinal reportCessna A185E · Greeley, COthe inadvertent ground loop during landing roll. A contributing factor was the partial brake system failure.NTSB DEN02LA040Accident · No injuriesLimited investigationFinal reportCessna TR182 · Kersey, COThe pilot's inadequate planning decision which led to fuel exhaustion and subsequent loss of engine power.NTSB WAS02RA037Accident · No injuriesForeign investigationMcDonnell Douglas DC-10-40F · San Salvador, El SalvadorNTSB FTW02LA131Accident · No injuriesLimited investigationFinal reportCessna 210 · Albuquerque, NMthe pilot's inadequate compensation for the wind conditions resulting in a hard landing. A contributing factor was the gusty winds.NTSB FTW02FA130Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Alpine, UTThe pilot's failure to maintain clearance with terrain and continued flight into known adverse weather conditions. Contributing factors were the fog and rain weather conditions.NTSB ATL02LA092Accident · 1 fatalLimited investigationFinal reportHartman Buccaneer 2 · Estero Bay, FLThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB ATL02FA091Accident · 2 fatalField investigationFinal reportBeech BE-35 · Warsaw, NCThe pilot's physical impairment due to the use of marijuana. The pilot's diminished judgment to continue flight into known instrument flight conditions that resulted in an in-flight loss of control, failure of the right wing due to overstress separation, and…NTSB LAX02FA144Accident · Minor injuriesField investigationFinal reportCessna 177B · Fullerton, CAThe total loss of engine power during cruise flight resulting from oil exhaustion. The oil exhaustion resulted from deterioration and total failure of the oil filter converter plate gasket, which had not been replaced due to maintenance personnel's failure to…NTSB DEN02GA039Accident · 1 fatalFinal reportPiper/Cub Crafters PA-18-150 · USAF Academy, COThe loss of control for undetermined reasons.NTSB ATL02LA094Accident · No injuriesLimited investigationFinal reportBell 47G-5A · La Belle, FLThe pilot's failure to maintain clearance of a tree while maneuvering, which resulted in an in-flight collision with the tree and subsequent uncontrolled descent and collision with terrain.NTSB ATL02LA093Accident · No injuriesLimited investigationFinal reportCessna 150B · Enterprise, ALThe pilot's failure to maintain airspeed during an attempted go-around that resulted in an inadvertent stall and the subsequent collision with the ground.NTSB MIA02LA089Accident · No injuriesLimited investigationFinal reportCessna 421C · Tampa, FLthe fracture of the landing gear upper barrel due to fatigue cracking, caused by improper machining after the barrel was assembled during the manufacturing process, resulting in damage to the airplane.NTSB LAX02LA143Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164C · Olivehurst, CAFuel starvation due to the failure of an engine accessory component. A contributing factor was the rough terrain.NTSB CHI02LA123Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Viburnum, MOThe pilot's improper short field takeoff planning and procedure. The takeoff weight above the maximum gross weight and the hill were contributing factors.NTSB CHI02LA119Accident · No injuriesLimited investigationFinal reportCessna 560 · Lake In The Hil, ILThe flightcrew's delay in executing a go-around..NTSB WAS02RA036Accident · 6 fatalForeign investigationCessna TU206G · Catacamas, HondurasNTSB SEA02LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Troutdale, ORImproper compensation for wind conditions while landing. Factors include a taxiway marker.NTSB NYC02FA089Accident · 2 fatalField investigationFinal reportCirrus SR-22 · Parish, NYThe pilots' failure to maintain airspeed, which resulted in an inadvertent stall/spin. The continued spin to the ground was a result of the pilots' failure to deploy the onboard parachute recovery system, for undetermined reasons.NTSB FTW02LA128Accident · No injuriesLimited investigationFinal reportCessna 172RG · Alamogordo, NMthe loss of engine power for an undetermined reason, which resulted in a forced landing after takeoff.NTSB LAX02LA142Accident · No injuriesLimited investigationFinal reportCessna 340A · Lancaster, CAThe collapse of the right main landing gear as a result of a malfunctioning microswitch.NTSB IAD02LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Louisville, KYThe pilot's inadvertent selection of an empty fuel tank, which resulted in fuel starvation of the engine.NTSB FTW02LA127Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Bogalusa, LAa deer that ran in front of the airplane during the takeoff phase. A contributing factor was the lack of an airport perimeter fence to prevent deer from entering the runway environment.NTSB CHI02LA114Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe pilot's improper fuel management resulting in the total loss of engine power due to fuel starvation and the pilot's failure to use the checklist.