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 WAS02WA043Accident · 1 fatalForeign investigationMcDonnell Douglas 369HS · PremierGameFarm, South AfricaNTSB SEA02IA096Incident · No injuriesIncident investigationFinal reportKaman K-600 (HH-43B) · Cocolalla, IDThe reverse installation of the RPM compensator assembly control box bolts resulting in the threaded end of the bolt impinging on a clevis and jamming the collective during climb. A contributing factor was the lack of adequate documentation provided by the…NTSB MIA02WA103Accident · No injuriesForeign investigationCessna 150L · Pinar Del Rio, CubaNTSB FTW02LA157Accident · No injuriesLimited investigationFinal reportGolden Circle Air T-Bird · Newellton, LAThe pilot's failure to maintain control of the airplane resulting in an inadvertant spin.NTSB ATL02LA102Accident · No injuriesLimited investigationFinal reportBell 47G · Marion, ALThe pilot's failure to maintain visual lookout while conducting an aerial application maneuver. A factor was the transmission line.NTSB ANC02LA037Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot's inadequate compensation for a crosswind during the landing roll. A factor was the presence of a crosswind.NTSB LAX02LA169Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28C · Stockton, CAThe pilot's failure to maintain an adequate clearance from the water tower during takeoff. Also causal was the pilot's selection of a confined area for the landing and subsequent takeoff.NTSB LAX02LA167Accident · No injuriesLimited investigationFinal reportCessna 172S · Scottsdale, AZthe student pilot's improper recovery from a bounced landing and failure to maintain directional control on the landing roll, which resulted in a collision with a runway sign.NTSB FTW02LA158Accident · No injuriesLimited investigationFinal reportAir Tractor 402 · Hughes, ARthe pilot's failure to maintain directional control during the landing roll. Contributing factors were the malfunction of the tail wheel locking mechanism and the high vegetation along the sides of the airstrip.NTSB FTW02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Bethany, OKthe anomalous elevator trim system and the pilot's failure to note its improper setting prior to takeoff.NTSB FTW02FA155Accident · 2 fatalField investigationFinal reportBeech BE-35 · Stephenville, TXThe pilot's failure to maintain control and adequate airspeed, resulting in the inadvertent stall/spin. A contributing factor was the low altitude.NTSB CHI02LA139Accident · No injuriesLimited investigationFinal reportWattier Tornado · Grant, MIThe disregarded replacement of the airplane's fuel lines, the operation of the aircraft with known deficiencies, and the turn back to the departure airport by the owner/pilot. The inadequate condition inspection by the mechanic, the cracked fuel line, the…NTSB NYC02FA098Accident · 3 fatalField investigationFinal reportBeech 23 · King George, VAThe pilot's improper in-flight decision to perform low passes; and his failure to maintain airspeed which resulted in a stall and collision with trees.NTSB LAX02LA168Accident · No injuriesLimited investigationFinal reportCessna 170B · Show Low, AZThe pilot's improper recovery from a bounced landing resulted in a loss of aircraft control. A factor was a sudden wind shift on final approach.NTSB IAD02FA052Accident · 1 fatalField investigationFinal reportAyres S-2R · Swanton, MDThe pilot's failure to maintain visual separation from a set of known, yet unmarked power lines.NTSB FTW02LA156Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Frankston, TXthe pilot's failure to adequately compensate for wind conditions while landing on the water which resulted in a water loop/swerve. A contributing factor was a wind gust.NTSB CHI02LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Kenosha, WIThe student pilot's failure to use carburetor heat, and the flight instructor's inadequate supervision of the flight.NTSB CHI02LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-236 · Angola, INThe loss of engine power for undetermined reasons. A factor to the accident was the soft terrain condition.NTSB CHI02LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Lake in Hills, ILIt was not possible for the pilot to land the airplane at a proper touchdown point during the aborted takeoff and unsuitable terrain was encountered off the end of the runway. Factors associated with the accident were a proper climb rate was not achieved…NTSB FTW02LA165Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Palestine, TXThe failure of the nose gear actuator aft attach point from the tube cluster on the engine mount assembly. A contributing factor was the owner's non-compliance with the service bulletin for inspection/replacement of the engine mount.NTSB DEN02LA044Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Salem, UTa loss of tail rotor effectiveness during takeoff. A contributing factor was the wind gusts.NTSB ANC02LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKA total engine failure during cruise flight due to the disentegration of the number five cylinder piston. A contributing factor in the accident was the lack of suitable terrain for a forced landing.NTSB LAX02LA165Accident · No injuriesLimited investigationFinal reportCessna 182Q · San Diego, CAThe pilot's failure to apply continuous brake pressure. Sun glare is a contributing factor.NTSB LAX02FA166Accident · 2 fatalField investigationFinal reportSocata TB-21 · New River, AZthe pilot's failure to maintain an adequate terrain clearance altitude during a cruise descent that resulted in controlled flight into terrain (CFIT). Factors in the accident were the rising mountainous terrain, the dark nighttime lighting condition, and the…NTSB FTW02LA153Accident · No injuriesLimited investigationFinal reportCessna 150M · Godley, TXthe loss of engine power for undetermined reasons. A contributing factor was the pilot's failure to maintain clearance with the transmission wire during the precautionary landing.NTSB FTW02LA152Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hathaway, LAthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN02FA043Accident · 1 fatalField investigationFinal reportCessna 170A · Casper, WYthe pilot's inadvertent flight into adverse weather conditions and his subsequent failure to maintain aircraft control. A factor contributing to this accident was the fog.NTSB ATL02FA101Accident · 2 fatalField investigationFinal reportLuscombe LL-8-E · Olar, SCThe in-flight separation of the elevator push-pull control tube that resulted in a loss of flight control and subsequent collision with the ground.NTSB SEA02LA082Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gaston, ORThe pilot's failure to maintain clearance from object(s) while executing a forced landing following a total loss of power for undetermined cause(s). Contributing factors where the pole impacted during the emergency landing and the pilot's diverted attention.NTSB SEA02FA083Accident · Serious injuriesField investigationFinal reportGrumman G-44 · Boise, IDA blocked fuel line that resulted in fuel starvation to the engine and the pilot's failure to follow emergency procedures. A contamination of metal flakes on the fuel filter, and an inadequate annual inspection were factors.NTSB IAD02LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Port Columbus, OHThe pilot's exhaustion of his fuel supply. A factor in the accident was the pilot's inadequate preflight planning.NTSB ATL02LA100Accident · 2 fatalLimited investigationFinal reportTaber Lancair Super ES · Hattiesburg, MSThe pilot's failure to maintain airspeed during takeoff which resulted in an inadvertent stall and subsequent collision with the ground.NTSB ANC02TA036Accident · No injuriesFinal reportPiper PA-18 · Holy Cross, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was the presence of high vegetation (willows) along the right side of the landing area.NTSB ANC02TA035Accident · No injuriesFinal reportRobinson R-44 · Cantwell, AKA failure of the pilot-in-command to maintain adequate main rotor rpm during an out-of-ground-effect hover.NTSB ANC02LA034Accident · No injuriesLimited investigationFinal reportCessna 170B · North Pole, AKThe separation of the right main landing gear from the airplane during landing. A factor associated with the accident is the unapproved hardware used to attach the main landing gear.NTSB MIA02LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Valdosta, GAThe failure of the student pilot to maintain directional control during takeoff, resulting in an on ground encounter with an adjacent ditch and a collapsed nose gear strut during the attempt to abort the takeoff.NTSB FTW02LA151Accident · 1 fatalLimited investigationFinal reportNolan RV-4 · Jonesboro, ARThe loss of engine power for an undetermined reason.NTSB ATL02LA099Accident · 1 fatalLimited investigationFinal reportAero Partners One CA 7SL · Merritt Island, FLThe pilot's inadequate in-flight planning/decision resulting in the misconfiguration of the flaps and the elevator trim setting. The misconfiguration resulted in an inadvertent pitch-up, loss of airspeed, stall and collision with the ground.NTSB MIA02WA096Accident · No injuriesForeign investigationSocata TBM 700 · Moulins, FranceNTSB LAX02LA161Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Phoenix, AZthe CFI's failure to maintain an adequate airspeed resulted in a settling with power, and the CFI's failure to take remedial action. A factor in the accident was the high density altitude.NTSB LAX02FA163Accident · 2 fatalField investigationFinal reportCessna T210M · Groveland, CAa catastrophic engine failure due to the fatigue fracture and failure of the crankshaft. A factor contributing to the accident was the unsuitable nature of the mountainous terrain for a successful forced landing. The precipitating cause of the fatigue…NTSB LAX02FA162Accident · Minor injuriesField investigationFinal reportCessna 152 · Livermore, CAA loss of engine power due to the failure of the CFI to apply carburetor heat which resulted in carburetor icing. The unsuitable landing area in mountainous terrain, and carburetor icing conditions were factors.NTSB ATL02LA098Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Tuscaloosa, ALThe pilots loss of directional control during landing roll, and subsequent inadvertent ground loop.NTSB ATL02LA097Accident · No injuriesLimited investigationFinal reportAerospatiale 350B · Gainesville, GAThe check airman’s failure to follow prescribed procedures that resulted in the lost of control and subsequent in-flight collision with the terrain. A factor was gusting wind conditions.NTSB ANC02LA033Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Yakutat, AKThe collapse of the left main landing gear during the landing roll due to a fractured main gear leg strut.NTSB SEA02LA081Accident · Minor injuriesLimited investigationFinal reportCook Coot A · Harrison, IDThe pilot's failure to detect an unsafe boat wake during the landing process, and his inadvertent initiation of a porpoise after coming in contact with the boat wake just after touchdown on a body of water. Factors include a large wake wave/swell created by…NTSB SEA02LA080Accident · No injuriesLimited investigationFinal reportAeronca 7-EC · Flying M Ranch, ORThe pilot's failure to maintain directional control while applying the brakes during the landing roll. Factors include a tailwind and trees at the far end of the airstrip.NTSB LAX02LA160Accident · No injuriesLimited investigationFinal reportMulligan RV4 · Santa Ynez, CAThe failure of the pilot to maintain sufficient airspeed during the attempted go-around resulting in a stall/mush. The gusting winds, recent purchase of airplane, and premature raising of the flaps were factors.NTSB FTW02LA150Accident · Serious injuriesLimited investigationFinal reportAubrey Challenger II · Lubbock, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA143Accident · Serious injuriesLimited investigationFinal reportBell 206B · Rosenberg, TXThe pilot's failure to maintain terrain clearance.