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 SEA02LA028Accident · No injuriesLimited investigationFinal reportCessna 150M · Clinton, WAFuel exhaustion while in cruise flight resulting in a loss of engine power and the pilot's failure to refuel the aircraft. The pilot's inadequate preflight planning/preparation and a fence post were factors.NTSB SEA02FA027Accident · 1 fatalField investigationFinal reportCessna 150G · Ilwaco, WAA loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during a low altitude turn.NTSB MIA02FA049Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Micanopy, FLThe pilot's experiencing spatial disorientation while maneuvering at a low altitude at night under visual meteorological conditions which resulted in an uncontrolled descent and an in-flight collision with a tree.NTSB LAX02LA065Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oceano, CAA loss of engine power due to the separation of the mixture control cable from the mixture control arm of the carburetor. The mixture cable separation was due to maintenance personnel's failure to secure the mixture control cable away from the nose landing…NTSB DEN02LA020Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Grand Junction, COthe failure of the tail wheel left steering cable. A contributing factor was the pilot's loss of aircraft control (not possible) and the subsequent inadvertent ground loop.NTSB CHI02LA063Accident · No injuriesLimited investigationFinal reportBeech V35B · Mattoon, ILA loss of engine power for undetermined reasons. Factor to the accident was the unsuitable rough/uneven terrain encountered during the forced landing.NTSB ATL02LA039Accident · No injuriesLimited investigationFinal reportCessna 172M · Sanford, NCThe pilots failure to maintain directional control during landing roll that resulted in a collision with an airport sign. Factors were wet runway surface and wind gust.NTSB ATL02LA037Accident · Serious injuriesLimited investigationFinal reportConsolidated-Vultee 108-M · Bayou La Batre, ALThe loss of engine power for undetermined reasons.NTSB NYC02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Nantucket, MAa loss of engine power for undetermined reasons.NTSB FTW02WA234Accident · Minor injuriesForeign investigationCessna A188 · El Ranchito, Dominican RepublicNTSB FTW02LA270Accident · Serious injuriesLimited investigationFinal reportRaven S60A · La Vernia, TXThe pilot's improper planning of the approach and failure to maintain clearance with the powerlines. A factor was the power lines.NTSB FTW02LA068Accident · No injuriesLimited investigationFinal reportCessna 172S · Sugar Land, TXthe student pilot's failure to maintain directional control during landing.NTSB DCA02WA018Accident · No injuriesForeign investigationATR 42-500 · Caratagena, ColombiaNTSB CHI02LA062Accident · 1 fatalLimited investigationFinal reportWolter Avid Flyer · Rush City, MNThe unqualified pilot inadvertently stalled the airplane. A factor was the unqualified pilot's lack of total experience.NTSB ATL02LA038Accident · Minor injuriesLimited investigationFinal reportH.S. Mosley Cuby Sport · Panama City, FLThe pilot's inadequate preflight and inflight decisions that resulted the execution of and off-airport landing to rough and uneven terrain where the airplane nosed over during the landing. The pilot did not apply normal breaking during the landing roll.NTSB ANC02LA009Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor's inadequate supervision of the flight. Factors in the accident were the student's failure to maintain directional control of the airplane during the landing roll, icy runway conditions, and snow-covered terrain along the runway edges.NTSB SEA02LA026Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Renton, WAThe flight instructor's failure to ensure that adequate altitude/clearance above the ground was maintained during hovering flight, resulting in an inadvertent ground contact and subsequent loss of control of the helicopter. A factor was the flight…NTSB LAX02LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Tehachapi, CAthe pilot's failure to maintain an adequate airspeed while maneuvering in an attempt to gain altitude, which resulted in an inadvertent stall/mush. The high density altitude was a factor in the accident.NTSB DEN02LA019Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD 902 · Aurora, COthe pilot's failure to maintain aircraft control due to inadvertent settling with power resulting in a hard landing. Contributing factors include the improperly planned approach, the high density altitude, and the encounter with vortex ring state.NTSB LAX02LA067Accident · No injuriesLimited investigationFinal reportFarrand Vans RV6 · San Jose, CAFailure of the pilot to sufficiently slow the airplane prior to exiting the runway, which lead to the left main landing gear collapsing and a subsequent ground loop.NTSB FTW02LA066Accident · No injuriesLimited investigationFinal reportPiper PA-46T · Albuquerque, NMThe pilot's failure to obtain/maintain proper runway alignment. Contributing factors were the pilot's inadvertant flight into adverse weather conditions, the pilot not performing a missed approach, and the low ceiling and snow weather conditions .NTSB ATL02LA035Accident · 1 fatalLimited investigationFinal reportSpringer Longbow 150 · Oak Hill, FLThe improper modification of the exhaust muffler which resulted in fractures that enabled the contamination of the cabin heating and ventilation system. The pilot subsequently became incapacitated by carbon monoxide poisoning, and the airplane descended…NTSB SEA02LA025Accident · No injuriesLimited investigationFinal reportCessna 210L · Great Falls, MTThe pilot's intentional continuation of a visual flight rules (VFR) flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from the terrain. Factors include low ceilings, snow, mountainous/hilly terrain, and trees.NTSB FTW02LA063Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Durango, COthe pilot's failure to maintain clearance with the trees and mountainous terrain while maneuvering. A contributing factor was the pilot's delay in taking remedial action.NTSB SEA02LA024Accident · No injuriesLimited investigationFinal reportHughes 369E · Grand Coulee, WAThe net gunner's improper decision to fire the net gun at an angle that allowed the net to become entangled in the main rotor system. A factor was foreign object damage to the main rotor blades.NTSB NYC02LA047Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-227-AT · Covington, KYthe tug driver's inadequate visual lookout which resulted in his failure to see the airplane in time to prevent the collision.NTSB FTW02LA064Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Grand Isle 74The pilot's misjudged landing flare. A contributing factor was the fatigue fracture of the PC air line due to the improper installation by company maintenance personnel, which resulted in a loss of engine power.NTSB ATL02LA036Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Bellewood, MSThe pilot misjudged the proper touched down point and collided with the ground short of the runway during an attempted landing.NTSB WAS02WA015Accident · No injuriesForeign investigationPiper PA-30 · Tarapoto, PeruNTSB ATL02LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Clewiston, FLThe student pilot's inadequate compensation for wind, and failure to maintain directional control. A contributing factor was a crosswind.NTSB CHI02LA060Accident · Serious injuriesLimited investigationFinal reportCessna 414A · Sturgis, MIthe inadequate in-flight emergency planning/decision, the checklist not followed and excessive approach altitude by the pilot. Contributing factors were the loose oil return line and weather.NTSB CHI02LA051Accident · No injuriesLimited investigationFinal reportBeech S35 · Angola, INThe pilot 's failure to maintain adequate airspeed and encountered a stall on approach to land. The low altitude on final approach was a factor.NTSB LAX02LA062Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Reno, NVThe pilot failed to maintain directional control resulting in an inadvertent ground loop. A contributing factor was the tailwind.NTSB LAX02FA061Accident · 1 fatalField investigationFinal reportCessna T337H · Buena Park, CAthe pilot's failure to maintain control of the airplane during the landing approach. Factors included the pilot's distraction when informed that his landing gear was not down, and his impairment from the effects of prescription drugs.NTSB LAX02FA059Accident · 1 fatalField investigationFinal reportCessna 152 · Petaluma, CAThe pilot's intentional flight of the airplane into terrain in an act of suicide.NTSB FTW02FA062Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Oak Grove, LAthe pilot's failure to maintain control of the airplane while maneuvering resulting in an inadvertent stall/spin.NTSB DEN02FA017Accident · 1 fatalField investigationFinal reportCessna 172K · Boulder, COthe pilot's intentional suicidal flight into terrain. Contributing factors were the pilot's psychological depressive state, and his use of inappropriate medication.NTSB CHI02LA061Accident · No injuriesLimited investigationFinal reportRobinson R22 · East Troy, WIThe pilot receiving instruction failed to maintain the proper descent rate.NTSB ATL02FA032Accident · 1 fatalField investigationFinal reportCessna 172R · Tampa, FLThe pilot's unauthorized use of an aircraft for the purpose of commiting suicide.NTSB ATL02FA031Accident · 5 fatalField investigationFinal reportCessna 441 · Rio Grande, PRThe pilot continued visual flight flight into instrument flight conditions resulting in an in-flight collision with terrain. Low clouds were a factor.NTSB DCA02RA014Accident · 5 fatalForeign investigationCanadair Challenger 604 · Birmingham, United KingdomNTSB ATL02TA030Accident · Minor injuriesFinal reportHughes OH-6A · Tampa, FLThe pilot's improper flare during practice autorotation.NTSB SEA02TA022Accident · No injuriesFinal reportHughes 369D · Butte, MTLoss of engine power for undetermined reasons.NTSB FTW02IA061Incident · No injuriesIncident investigationFinal reportBoeing 747-228F · Houston, TXStress corrosion cracking (SCC) of the aft trunnion outer cylinder. A factor was the inadequate inspection criteria of the Airworthiness Directive to detect pre-existing SCC.NTSB CHI02LA057Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lake Leelanau, MIThe improper planning/decision in runway selection. The soft runway condition and wet snow were contributing factors.NTSB ATL02LA029Accident · No injuriesLimited investigationFinal reportBoeing 727-200 · Greenville, SCThe tug driver's failure to maintain control of the airplane during pushback resulting in the tug colliding with the airplane. A factor was ice on the ramp.NTSB SEA02FA023Accident · No injuriesField investigationFinal reportBeech 58P · Boise, IDImproper clearance between an alternator wire and a pneumatic line and fuel fumes. The alternator wire chafe and arcing were factors.NTSB NYC02LA046Accident · No injuriesLimited investigationFinal reportLet L-23 · Sterling, MAThe student pilots inadequate compensation for wind conditions which resulted in an off-field landing, and the CFI's improper decision to allow the student to fly solo. Factors related to the accident were the gusting wind conditions, and the students lack of…NTSB MIA02IA047Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Miami, FLThe failure of the first officer to fly a stabilized approach at the correct airspeed and his failure to execute a missed approach resulting in touchdown about 5,000 feet past the runway threshold at an excessive airspeed and over run of the runway prior to…NTSB MIA02FA048Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hollywood, FLThe pilot's inadequate planning for a Title 14 CFR Part 135 on-demand air taxi flight, and his failure to refuel the airplane, which resulted in fuel exhaustion while en route over the Atlantic Ocean, a power off glide, and ditching in the ocean.