NTSB investigations, 2002
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WAS02WA050Accident · No injuriesForeign investigationSchweizer -269C · Augsburg Bayern, GermanyNTSB LAX02LA264Accident · No injuriesLimited investigationFinal reportHispano Aviacion HA-200 Saeta · Bakersfield, CAthe pilot's improper fuel system management, which lead to fuel starvation, and a loss of engine power. A factor in the accident was the pilot's decision to continue on the second leg of the flight with the gear in the extended position, which increased the…NTSB IAD02LA090Accident · No injuriesLimited investigationFinal reportCessna T210N · Glastonbury, CTA partial loss of engine power for undetermined reasons. A factor in the airplane's damage was the standing corn.NTSB DEN02TA100Accident · Serious injuriesFinal reportBell 206L-3 · Saguache, COthe pilot's inadequate in-flight planning and decision making, and the loss of tail rotor effectiveness. A contributing factor was the right quartering tailwind.NTSB CHI02LA260Accident · Minor injuriesLimited investigationFinal reportAnderson Kitfox Series 5 · Garden Prairie, ILThe pilot's miscalculation of fuel consumption and his operation of the fuel system beyond its limitation, which resulted in fuel exhaustion. Contributing factors were transmission wires and dark night conditions.NTSB CHI02LA257Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Kenmare, NDThe pilot's misjudgment of distance and speed. Factors associated with the accident were the sudden wind shift which resulted in a tailwind condition and the rough terrain encountered during the overrun landing.NTSB SEA02LA165Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Melstone, MTThe pilot's improper decision to continue a takeoff once it had become apparent that it was questionable whether the aircraft would clear an obstacle at the departure end of the takeoff area. Factors include the pilot's failure to perform pre-takeoff…NTSB MIA02WA176Incident · No injuriesForeign investigationBoeing 767-332ER · Buenos Aires, ArgentinaNTSB MIA02LA158Accident · No injuriesLimited investigationFinal reportCessna 172N · Tarboro, NCThe failure of the solo student to maintain directional control of the airplane during the takeoff roll/run which resulted in the airplane veering off the runway and impacting trees, incurring substantial damage.NTSB MIA02LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Pinehurst, NCThe student pilot's improper recovery from bounced landing which resulted in substantial damage to the airplane.NTSB LAX02LA263Accident · No injuriesLimited investigationFinal reportPravecek Lawrence Varieze · Rio Linda, CAthe loss of engine power caused by fuel exhaustion due to a fuel tank leak. Also causal was the inadequate maintenance performed on the repair of the fuel tank by unknown maintenance personnel.NTSB LAX02LA262Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Oasis, CAthe pilot's failure to maintain an adequate visual lookout and clearance with power lines while maneuvering during an aerial application flight.NTSB IAD02LA089Accident · 1 fatalLimited investigationFinal reportPuhl Genesis · Petersburg, WVThe pilot's failure to maintain airspeed after a loss of engine power, which resulted in an inadvertent stall/spin. Factors included the pilot's inadequate preflight planning which resulted in fuel exhaustion, and the transmission wires in the pilot's glide…NTSB CHI02LA261Accident · No injuriesLimited investigationFinal reportMooney M20C · Warroad, MNThe loss of engine power due to the failure of the muffler baffles which blocked the exhaust system. A factor to the accident was the treeline.NTSB CHI02LA259Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402A · Cherokee, IAThe pilot failed to maintain clearance with the power lines resulting in the rudder separation and the subsequent loss of aircraft control. A factor associated with the accident was the power line that was contacted.NTSB CHI02LA256Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Coopersville, MIThe pilot's failure to maintain clearance from the transmission wires. Additional factors were the transmission wires and the sunglare.NTSB SEA02TA164Accident · No injuriesFinal reportBell 206L-1 · Wisdom, MTThe pilot's failure to maintain clearance from an object while maneuvering. A tree(s) was a factor.NTSB SEA02LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-14 · Eastsound, WALoss of engine power for undetermined reasons.NTSB CHI02LA263Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Seneca, ILThe loss of engine power for undetermined reasons. Factors were the low altitude, the trees, and the unsuitable terrain encountered for the forced landing.NTSB ATL02LA161Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Peachtree City, GAThe certified flight instructors failure to feather the propeller in accordance with operating procedures that resulted in loss of altitude and the in-flight collision with terrain.NTSB ANC02LA120Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Gakona, AKThe pilot's failure to maintain directional control of the airplane, and his excessive use of the airplane's brakes during the landing roll, which resulted in the airplane nosing down. A contributing factor in the accident was wet, high grass along the runway…NTSB ANC02LA104Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nuiqsut, AKThe pilot's inadvertent wheels-up landing. Factors contributing to the accident were the pilot's failure to complete the prelanding checklist, his diverted attention, and a delayed gear warning horn alarm.NTSB ANC02LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chickaloon, AKThe pilot's failure to maintain clearance from ground obstructions while taxiing. A factor contributing to the accident was excessive taxi speed.NTSB NYC02WA175Accident · Serious injuriesForeign investigationCessna 310R · Saint Tropez, FranceNTSB NYC02LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Manassas, VAThe pilot's inadequate pre-flight planning, and his inadequate visual lookout while taxing on an off airport road. A factor related to the accident was the dark night conditions.NTSB LAX02LA261Accident · Minor injuriesLimited investigationFinal reportAB Sportine Aviacija Genesis 2 · Orland, CAthe loss of thermal lift during flight.NTSB LAX02FA259Accident · No injuriesField investigationFinal reportCessna 172N · Mesa, AZAn electrical fire of unknown origin centered near the circuit breaker/throttle area of the instrument panel.NTSB LAX02LA257Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dos Palos, CAthe failure of the propeller blade due to fatigue. Factors in the accident were the inadequate maintenance-repair of the blade, and, inadequate pilot preflight inspections.NTSB SEA02LA166Accident · No injuriesLimited investigationFinal reportAero Commander S2R Thrush · Connell, WAThe pilot's failure to adequately compensate for wind conditions and his failure to maintain directional control. Factors include rough uneven terrain.NTSB NYC02FA173Accident · 1 fatalField investigationFinal reportPiper PA-22-108 · Mayville, NYThe student pilot's failure to maintain adequate altitude during the landing approach and the private pilot's inadequate supervision, which resulted in a collision with a marked utility pole. A factor in this accident was the student pilot's lack of…NTSB NYC02FA171Accident · Serious injuriesField investigationFinal reportSchweizer 269C-1 · Andover, NJThe flight instructor's delayed remedial action to correct the low rotor condition. A factor was the student pilot's improper use of the collective, which created the low rotor condition.NTSB MIA02LA155Accident · Serious injuriesLimited investigationFinal reportBarnes Vans RV-6 · Chesnee, SCthe pilot misjudged the landing flare, resulting in a hard landing, loss of directional control, and damage to the airplane.NTSB LAX02LA260Accident · No injuriesLimited investigationFinal reportCessna 195 · Willows, CAthe pilot's inadequate compensation for crosswind conditions resulting in his failure to maintain runway alignment. Contributing factors to the accident were the pilot's lack of familiarity with the airplane.NTSB LAX02LA256Accident · Minor injuriesLimited investigationFinal reportDodd RV-4 · Tehachapi, CAthe owner/builder's improperly fabricated and installed fuel line, which cracked at the point of the flare, resulting in a fuel leak and loss of engine power during the takeoff climb. A contributing factor was the soft terrain that jammed the landing gear…NTSB FTW02LA238Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Rosenburg, TXthe failure of the pedestrian to perform a visual lookout while walking on the runway which resulted in a on-ground collision with the airplane.NTSB SEA02LA161Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Rigby, IDThe failure of one or more compressor turbine blades resulting in a shutdown of the engine during initial climb resulting in a forced landing. Contributing factors were the eroded condition of the compressor turbine guide vane nozzles and the ditch which the…NTSB MIA02LA154Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Union, SCthe pilot's failure to maintain obstacle clearance.NTSB FTW03IA073Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-60 · Memphis, TNthe loss of right engine power as a result of a fatigue failure of the propeller shaft coupling.NTSB FTW02LA239Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Simmesport, LAthe contamination of the fuel system with water and a foreign material.NTSB DEN02LA099Accident · No injuriesLimited investigationFinal reportHildebrandt Rutan/Defiant · Erie, COfailure of the normal braking system, resulting in the airplane departing the end of the runway. A contributing factor was the airplane's slow acceleration during the takeoff roll.NTSB DEN02LA098Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Broomfield, COmaintenance personnel's failure to secure the landing skid oleo strut bolt during the last 50-hour inspection, causing the left rear skid to collapse and the tail rotor to strike the ground.NTSB ATL02FA160Accident · 1 fatalField investigationFinal reportBeech BE-55 · Jacksboro, TNPilot incapacitation due to a heart attack resulting in a loss of control and the subsequent in-flight collision with a lake.NTSB SEA02LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Newberg, ORA warped right brake disc resulting in a veer to the right during the landing roll, and the aircraft's subsequent collision with a fence. A contributing factor was the fence.NTSB NYC02LA170Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · New Bedford, MAThe pilots failure to obtain the proper touchdown point, and the CFI's delay in remedial action.NTSB LAX02FA255Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Echo Summit, CAThe pilot's decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were the rising mountainous terrain, and the high density altitude,NTSB IAD02FA088Accident · 1 fatalField investigationFinal reportCessna 172N · Stanardsville, VAThe pilot's failure to maintain sufficient altitude/clearance while descending over mountainous terrain. A factor was the night lighting conditions.NTSB CHI02LA255Accident · No injuriesLimited investigationFinal reportCessna 172P · Buffalo City, WIThe malfunction of the seat positioning system for undetermined reasons, which resulted in the loss of directional control. A factor to the accident was the descending embankment.NTSB ANC02LA099Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Palmer, AKThe fracture of the right main landing gear axle during landing roll. Factors associated with the accident were corrosion of the landing gear axle, failure of company maintenance personnel to adequately inspect the axle and detect the corrosion, and rough and…NTSB ANC02LA098Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ketchikan, AKThe pilot's failure to maintain an adequate visual outlook during cruise climb, which resulted in a midair collision between the two airplanes.NTSB NYC02FA166Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Deerfield, VAThe pilot's improper preflight decision to takeoff on an up-sloping runway with a tailwind, which resulted in an inadvertent stall and collision with a tree. Factors were the pilot's lack of familiarity with the geographic area, and a tailwind.