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 FTW02LA121Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Conway, ARThe pilot's failure to land the airplane at a proper touchdown point on the runway and his delayed decision to initiate a go-around over high obstacles.NTSB ATL02LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Smithfield, NCThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB NYC02FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Gardiner, NYThe pilot-in-command's failure to maintain sufficient altitude while maneuvering in a mountainous area, which resulted in a collision with terrain. Factors in the accident were, mountainous terrain, clouds, and the pilot's decision to continue the flight in…NTSB FTW02LA124Accident · No injuriesLimited investigationFinal reportCessna 172R · Longview, TXThe in-flight collision with a bird.NTSB FTW02FA118Accident · 2 fatalField investigationFinal reportCessna T182 · Amarillo, TXThe pilot's failure to maintain clearance with the power plant while maneuvering, and his intentional flight into adverse weather conditions. Contributing factors were low clouds, fog, the power plant, and low altitude flight.NTSB DCA02WA031Accident · 2 fatalForeign investigationSwearingen Metro SW3 · PalmaDeMallorca, SpainNTSB SEA02TA067Accident · No injuriesFinal reportHughes 369D · Richland, WAFailure of the netting material securing a net weight while maneuvering. The net weight was a factor.NTSB SEA02LA068Accident · No injuriesLimited investigationFinal reportSteele Steen Skybolt · Coeur d' Alene, IDThe pilot's failure to maintain directional control during the landing rollout.NTSB LAX02FA134Accident · 2 fatalField investigationFinal reportBeech G35 · Willows, CAthe pilot's entry into an abrupt maneuver at an excessive airspeed beyond Va, which resulted in exceeding the aircraft's design stress limits.NTSB IAD02LA042Accident · No injuriesLimited investigationFinal reportWSK PZL PW-5 · New Smithville, PAThe pilot's inadequate evaluation of the weather which resulted in the loss of thermal lift and collision with trees.NTSB FTW02LA119Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cypress, TXthe total loss of engine power as a result of oil starvation due to a missing oil filler cap, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA117Accident · Minor injuriesLimited investigationFinal reportBell 206B · Walnut Hill, TXThe loss of engine power as a result of the backing off of the PC air line "B" nut due to the improper installation by the company maintenance personnel. Contributing factors were the inadequate preflight by the pilot and the lack of suitable terrain for the…NTSB ATL02LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pahokee, FLThe loss of engine power and the post-landing fire for undetermined reasons.NTSB ANC02FA029Accident · No injuriesField investigationFinal reportEurocopter AS-350-B2 · Valdez, AKThe pilot's failure to disengage the hydraulic system, and maintain forward airspeed during landing as delineated in the emergency procedures section of the helicopter's operations manual, which resulted in a loss of control while hovering. Factors…NTSB ANC02FA028Accident · 1 fatalField investigationFinal reportBeech E18S · Juneau, AKThe pilot's excessive loading of the airplane that precipitated an inadvertent stall/mush during the initial climb.NTSB LAX02LA132Accident · Serious injuriesLimited investigationFinal reportCox Aeros Ltd Skyranger · Gila Bend, AZThe failure of the engine for undetermined reasons.NTSB FTW02LA116Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Palestine, ARthe pilot's failure to maintain clearance with the power line while maneuvering during an aerial application flight.NTSB FTW02LA115Accident · No injuriesLimited investigationFinal reportCessna 172S · Angel Fire, NMThe pilots failure to maintain directional control during the crosswind landing. A contributing factor was the gusting wind condition.NTSB CHI02LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Appleton, WIThe pilots failure to maintain directional control of the airplane during the takeoff roll resulting in the subsequent impact with terrain.NTSB MIA02TA082Accident · Serious injuriesFinal reportAerospatiale SA319B Alouette III · Altoona, FLThe intentional operation of the helicopter with known deficiencies in equipment (inoperative normal brakes), and the pilot's improper use of the cyclic flight controls after the helicopter started rolling following touchdown.NTSB CHI02LA105Accident · 2 fatalLimited investigationFinal reportBozeman Pietenpol Aircamper · Rocky Comfort, MOThe pilot not maintaining aircraft control while maneuvering, and his failure to maintain airspeed resulting in a stall. Low altitude flight was a contributing factor.NTSB CHI02LA102Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Council Bluffs, IAThe student pilot's failure to maintain control of the airplane and the subsequent inadvertent stall. A factor associated with the accident was the student's lack of total experience.NTSB SEA02LA065Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Rockford, WAThe pilot's inadequate pre-flight planning/decision to continue the takeoff. Contributing to the accident was the wind gusts.NTSB NYC02LA081Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Louisa, VAThe airplane's inadvertent collision with a deer while landing at night. A factor in the accident was the night condition.NTSB MIA02TA081Accident · No injuriesFinal reportBell OH-58C · Punta Gorda, FLDynamic rollover experienced by the pilot while attempting to lift off from a trailer after experiencing skid to trailer contact. A factor in the accident was the inadequate equipment (trailer) which had a 1.1875 inch high lip extending the length of the…NTSB FTW02LA147Accident · No injuriesLimited investigationFinal reportCessna 172P · McKinney, TXthe student pilot's failure to properly recover from a bounced landing which resulted in the airplane porpoising. A contributing factor was the student pilot's improper landing flare which resulted in a bounced landing.NTSB FTW02LA114Accident · No injuriesLimited investigationFinal reportMcClung Starduster SA-1 · Sherman, TXthe pilot's inadvertent use of unsuitable taxi terrain, which resulted in an encounter with a ditch while taxing from landing.NTSB ATL02LA080Accident · No injuriesLimited investigationFinal reportCessna 170B · Ocala, FLThe pilot's failure to maintain directional control on landing roll, resulting in a loss of control/ground loop.NTSB ATL02IA079Incident · No injuriesIncident investigationFinal reportRockwell International 500-S · Jackson, ALThe pilot's inadequate preflight planning and preparation, which resulted in fuel exhaustion, loss of engine power in both engines, and subsequent forced landing in a field.NTSB ATL02FA077Accident · 1 fatalField investigationFinal reportBeech E35 · Blowing Rock, NCThe pilot's continued VFR flight in to known IMC, which resulted in an in-flight collision with trees in mountainous terrain. A factor was low ceiling.NTSB CHI02LA100Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Hastings, MNThe engine failure due to oil starvation as a result of the fatigue fracture of the number 6 piston. Additional factors were the unsuitable terrain for landing encountered by the pilot, and the inadequate piston design by the manufacturer.NTSB SEA02FA064Accident · No injuriesField investigationFinal reportCessna 182E · Red Lodge, MTLong term fatigue of the nose landing gear strut fork initiated by side loading which resulted in the separation of the fork from the strut and the consequent collapse of the nose gear. A contributing factor was the ditch the aircraft traversed during the…NTSB SEA02FA063Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Silesia, MTThe non-certificated pilot's inadvertent entry into a stall condition at low altitude.NTSB MIA02LA080Accident · 1 fatalLimited investigationFinal reportGary L. Zeigler Monnett Moni · Sevierville, TNThe failure of the pilot to maintain airspeed while turning to reverse direction resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with trees. A factor in the accident was the failure of the pilot to tighten the spark plugs…NTSB LAX02LA128Accident · No injuriesLimited investigationFinal reportWilson Magnum · Woodland, CAThe pilot's inadequate compensation for the gusty crosswind condition, and his failure to maintain airplane control.NTSB LAX02FA131Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Three Rivers, CAthe pilot's attempt to continue visual flight in instrument meteorological conditions in mountainous terrain. Contributing factors were low ceiling and mountainous terrain.NTSB FTW02FA113Accident · 2 fatalField investigationFinal reportBeech D-45 · Minden, LAThe private pilot's failure to maintain aircraft control during a go-around. Contributing factors were the private pilot's impairment due to drugs, the pilot-rated passenger's lack of experience in the airplane, and the prevailing gusty crosswind conditions.NTSB ATL02FA076Accident · No injuriesField investigationFinal reportFlugzeugbau EA-300L · Lakeland, FLThe Extra 300L pilot's failure to maintain a visual lookout resulting in a midair collision while landing. Contributing to the accident was the Extra 300L pilot's failure to follow written instructions contained in the NOTAM, and ATC instructions resulting in…NTSB LAX02LA133Accident · No injuriesLimited investigationFinal reportCessna 172S · Phoenix, AZthe pilot flaring the airplane too high above the runway causing a stall and resulting in the hard landing. Factors relating to the accident were the light conditions (dusk) and the pilot's lack of total experience in the type of airplane.NTSB LAX02LA127Accident · No injuriesLimited investigationFinal reportCessna 180J · Saline Valley, CAThe pilot's loss of directional control during landing rollout after encountering a water erosion rut in the runway's uneven surface.NTSB LAX02LA126Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Goodyear, AZThe student pilot's misjudgment of clearance and his failure to adhere to the flight school's policy/procedures for taxiing around obstructions.NTSB FTW02WA145Accident · 4 fatalForeign investigationCessna U206G · Santa Ana, BoliviaNTSB DEN02TA037Accident · No injuriesFinal reportDouglas/Basler DC-3C · Casper, WYThe copilot's inadvertent retraction of the landing gear. A contributing factor was the use of inappropriate medication by the copilot.NTSB CHI02LA101Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Kahoka, MOThe improper soft field takeoff/procedure by the pilot. Contributing factors were the night condition and the inadequate planning/decision by the pilot.NTSB ATL02LA075Accident · No injuriesLimited investigationFinal reportBoeing 767-332ER · Atlanta, GACompany maintenance personnel inadequate maintenance inspection that resulted in the in-flight separation of the APU inspection doors.NTSB ATL02FA074Accident · 1 fatalField investigationFinal reportPiper PA-16 · Lakeland, FLThe failure of the PA-16 pilot to maintain a visual lookout and to yield the right-of-way to a lower aircraft while on final approach resulting in a midair collision. Contributing to the accident was the failure of both pilot's to adhere to an ATC clearance…NTSB MIA02LA078Accident · Serious injuriesLimited investigationFinal reportUltravia Aero Int' Pelican Club PL · Crystal River, FLThe loss of engine power due to undetermined reasons. A factor in the accident was the pilot-in-command misjudging the proper glidepath resulting in the in-flight collision with a tree and subsequent uncontrolled in-flight collision with the ground.NTSB LAX02LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lake Elsinore, CAThe pilot lost awareness of his location and collided with trees. Factors in the accident were the mountainous terrain and night conditions.NTSB FTW02LA111Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wynne, ARThe inadequate supervision by the flight instructor of the pilot who was receiving instruction resulting in the excessive application of the brakes during the landing roll resulting in a nose over. A factor was the gusty crosswind conditions.NTSB FTW02FA112Accident · 1 fatalField investigationFinal reportNorth American T-28B · Uvalde, TXThe pilot's failure to maintain control of the aircraft for undetermined reasons.