NTSB investigations, 2002
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 LAX02LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Jean, NVThe pilot's failure to maintain directional control.NTSB NYC02LA058Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Fremont, OHDamage to the right tire, which resulted in a sudden loss of tire pressure and a loss of directional control.NTSB LAX02LA081Accident · No injuriesLimited investigationFinal reportConrad Pulsar 582 · Prescott, AZThe pilot failed to maintain landing reference speed and aircraft control. A factor was the gusty wind conditions.NTSB LAX02LA080Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-1 · San Diego, CAThe pilot failed to maintain directional control after encountering a gust of wind during the landing roll. Factors were the unexpected wind gusts and the soft terrain adjacent to the runway.NTSB CHI02LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Manito, ILThe pilot's improper planning and decision and his failure to maintain adequate airspeed, which resulted in a stall and hard landing. The gusting crosswind conditions were a contributing factor.NTSB NYC02LA057Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Point Pleasant, WVAn inadvertent collision with a deer while landing at dusk. A factor in the accident was the dusk light condition.NTSB LAX02FA075Accident · No injuriesField investigationFinal reportCessna 525A · Novato, CAThe pilot's failure to achieve the proper touchdown point and his failure to retract the flaps and spoilers during an attempted landing abort, which resulted in a landing overrun. Also causal was the pilot's decision to attempt a landing in wind conditions…NTSB FTW02LA079Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMthe loss of engine power as result of the failure of the dual magneto. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB DEN02LA029Accident · Serious injuriesLimited investigationFinal reportGulfstream Aerospace G-IV · Broomfield, COthe flight attendant's failure to fasten his seatbelt when warned of possible turbulence. A contributing factor was the severe turbulence.NTSB FTW02LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Houston, TXthe loss of engine power due to fuel starvation as a result of the pilot's failure to switch fuel tanks. A factor was the lack of suitable terrain for the forced landing.NTSB ANC02LA018Accident · No injuriesLimited investigationFinal reportAerospatiale AS350-B · Girdwood, AKThe pilot's failure to maintain adequate distance from a radio antenna during landing. A factor was the presence of an antenna.NTSB FTW02LA077Accident · No injuriesLimited investigationFinal reportBeech 200 · Camden, ARThe inadvertent stall as the result of the pilot's failure to maintain proper airspeed. A contributing factor was the pilot's use of the approach flaps setting for the landing.NTSB ATL02FA043Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Atlanta, GAThe pilot experienced spatial disorientation that resulted in the loss of control.NTSB WAS02RA017Accident · Serious injuriesForeign investigationBell 212 · Ishpingo, EcuadorNTSB FTW02LA076Accident · Serious injuriesLimited investigationFinal reportPiper PA-31T · Hobbs, NMthe pilot's failure to maintain the proper glidepath during the instrument approach. Contributing factors were the dark night light conditions and the pilot's diverted attention.NTSB CHI02LA076Accident · No injuriesLimited investigationFinal reportCessna 172N · Ottumwa, IAthe student pilot failed to maintain directional control during takeoff. A contributing factor was the snowbank.NTSB ANC02LA013Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Talkeetna, AKThe pilot's failure to remove sufficient ice/frost from the airplane prior to flight, and his failure to maintain adequate clearance from trees and terrain. A factor associated with the accident is the reduced climb capability of the airplane due to the…NTSB LAX02LA079Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CAThe student pilot's failure to maintain directional control during the landing sequence.NTSB ANC02FA014Accident · 1 fatalField investigationFinal reportCessna 206 · Bethel, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain adequate ground clearance, which resulted in an in flight collision with terrain. Factors associated with the accident were flat light conditions, and…NTSB LAX02LA221Accident · No injuriesLimited investigationFinal reportBeech 58P · Santa Ana, CAthe pilot's failure to remain above the landing Boeing 757's glide path resulting in an encounter with wing tip vortices, a loss of directional control after touchdown, and collision with taxiway signs.NTSB LAX02LA077Accident · No injuriesLimited investigationFinal reportBeech T-34B/D-45 · San Simeon, CAthe pilot's inadequate preflight of the airplane in which he failed to close the fuel drain resulting in a fuel leak and fuel exhaustion.NTSB LAX02LA076Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Joshua Tree, CAThe pilot's inadvertent missetting of the fuel selector position on the auxiliary fuel tanks (versus the main tanks) resulting in fuel starvation of the engines.NTSB DCA02WA022Incident · No injuriesForeign investigationBoeing MD-11 · Dublin, IrelandNTSB SEA02FA036Accident · Serious injuriesField investigationFinal reportAero Commander 520 · Puyallup, WAThe pilot's failure to maintain aircraft control during takeoff. Trees were a factor.NTSB LAX02LA078Accident · No injuriesLimited investigationFinal reportRobinette Ultra Pup · Rio Vista, CAThe loss of engine power for undetermined reasons.NTSB LAX02LA074Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Hawthorne, CAFailure of the student to maintain directional control of the airplane on the landing rollout and failure of the CFI to adequately supervise the flight. A contributing factor was the decreased tension of the right main landing gear shock cord/bungee.NTSB MIA02LA058Accident · 1 fatalLimited investigationFinal reportHarleman Tornado II · Molino, FLThe pilot's failure to maintain obstacle clearance, resulting in the in-flight collision with a static wire and an uncontrolled descent and collision with the ground. A factor in the accident was the pilot's impairment resulting from the use of unapproved…NTSB MIA02LA057Accident · Serious injuriesLimited investigationFinal reportCessna R172E · River Ranch, FLThe reported loss of engine power due to undetermined reasons. Contributing factors in the accident were an improper flap setting, excessive landing speed, and terrain consisting of berms.NTSB ANC02LA012Accident · No injuriesLimited investigationFinal reportBritten-Norman BN2A-26 · Ouzinkie, AKThe pilot's selection of unsuitable terrain for takeoff. Factors associated with the accident are a slush covered runway, and rough/uneven terrain.NTSB SEA02FA035Accident · Serious injuriesField investigationFinal reportRobinson R-22 Beta · Silver City, MTBoth the pilot/owner and the FAA inspector pilots' failure to maintain adequate rotor RPM during a practice auto rotation landing which resulted in a hard landing. A contributing factor was the pilot/owner's application of excessive anti-torque pedal during…NTSB NYC02FA055Accident · 2 fatalField investigationFinal reportBeech V35B · Chester, CTThe pilot's failure to maintain adequate airspeed during the turn to final, which resulted in an inadvertent stall/spin. Factors included low ceilings and night lighting conditions.NTSB LAX02FA073Accident · 1 fatalField investigationFinal reportPiper Aerostar 601P · Stonyford, CAthe pilot's failure to maintain terrain clearance during cruise flight, which resulted in the in-flight collision with mountainous terrain. Factors in the accident were the mountainous terrain and the dark night light conditions.NTSB CHI02LA075Accident · No injuriesLimited investigationFinal reportPiper PA-42-720 · Ames, IAThe pilot's failure to maintain the proper glide path during the final portion of the approach. Factors relating to this accident were the low altitude and the utility pole.NTSB LAX02LA072Accident · 2 fatalLimited investigationFinal reportHillyer XL-RG Velocity · San Diego, CAThe pilot's improper in-flight planning and decision making, which resulted in exhaustion of the airplane's fuel supply and loss of engine power.NTSB CHI02FA074Accident · 2 fatalField investigationFinal reportCessna 441 · Winfield, KSThe pilot's spatial disorientation resulting in a loss of control and collision with the ground. Additional factors included the pilot operating the airplane with known deficiencies and the instrument flight conditions.NTSB CHI02LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Falls City, NEThe deer striking the airplane during landing. A factor relating to this accident was the dark night.NTSB SEA02LA033Accident · No injuriesLimited investigationFinal reportBeech B-19 · Moses Lake, WAThe instructor's inadequate supervision of the student pilot. Also, the dual student's incorrect use of the fuel selector valve. A factor was the uneven terrain.NTSB FTW02LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Berryville, ARthe pilot's improper recovery from a bounced landing, which resulted in a hard landing. A contributing factor was the sunglare.NTSB DEN02LA023Accident · 1 fatalLimited investigationFinal reportBeech V35B · American Fork, UTThe pilot's poor judgment in that he intentionally initiated VFR flight into instrument meteorological conditions. Contributing factors were low ceiling and obscuration, and the pilot's lack of recent instrument time.NTSB DCA02WA019Accident · 92 fatalForeign investigationBoeing 727-134 · Ipiales, ColombiaNTSB CHI02LA072Accident · No injuriesLimited investigationFinal reportBeech 23 · Salina, KSthe student pilot's improper flare and the CFI failed to take remedial action.NTSB SEA02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle Point, ORThe pilot inadvertently failed to retract the landing gear for the water landing and the aircraft nosed over.NTSB NYC02LA053Accident · No injuriesLimited investigationFinal reportCessna 172R · Richmond, VAThe pilot's improper recovery from a bounced landing. A factor in the accident was the pilot improper flare.NTSB LAX02LA071Accident · Minor injuriesLimited investigationFinal reportRichard S. Anderson Rotorway Exec 162F · Willcox, AZThe pilot's failure to compensate for a gust condition and to maintain lateral control while hovering due to restricted cyclic control movement, which resulted from an inadequate control location/design.NTSB IAD02LA028Accident · 1 fatalLimited investigationFinal reportWilburn Jodel F-12 · Clarksville, VAThe pilot's failure to maintain airspeed after a loss of engine power, which resulted in an inadvertent stall/spin. Also causal, was the loss of engine power for undetermined reasons.NTSB CHI02LA070Accident · 2 fatalLimited investigationFinal reportBellanca 17-30A · Alexandria, MNThe pilot's disregard of the weather evaluation and his attempt to fly into known adverse weather without an instrument rating. Factors in the accident were the low ceiling, the low visibility, and the icing conditions.NTSB NYC02LA054Accident · No injuriesLimited investigationFinal reportBeech F33A · Lynchburg, VAThe pilot's failure to maintain directional control and delay in aborting the takeoff.NTSB NYC02LA052Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Marlborough, MAThe pilot's failure to achieve a proper touchdown point on the runway which resulted in an overrun. A factor was the pilot's lack of experience in short field operations.NTSB MIA02LA054Accident · 1 fatalLimited investigationFinal reportQuitzau, Carl Vortex · Immokalee, FLThe failure of the pilot to maintain directional control of the gyroplane resulting in the in-flight loss of control and subsequent in-flight collision with terrain.NTSB MIA02LA051Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Levittown, PRthe failure of maintenance personnel to comply with aircraft manufacturer's inspection procedures, resulting in corrosion and separation of the aileron control cable in flight and the subsequent forced landing in a swamp.