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 LAX02LA271Accident · No injuriesLimited investigationFinal reportMooney M20 · Sierraville, CAthe pilot's decision to attempt takeoff in crosswind conditions that likely exceeded the capability of the airplane, and, his subsequent failure to maintain the airplane's proper alignment over the runway. Also causal was the pilot's premature liftoff and…NTSB FTW02LA248Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Deming, NMThe loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat. A contributing factor was the weather conducive to carburetor icing conditions.NTSB FTW02LA247Accident · No injuriesLimited investigationFinal reportEurocopter AS350B3 · Eagle Pass, TXThe insufficient length of the stepper motor rack inside the HMU, which caused the red "GOV" light to illuminate and the fuel metering valve to freeze causing the engine to automatically engage the manual mode.NTSB FTW02FA243Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-34 · Decatur, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. A contributing factor was lack of total experience in the make and model of the accident aircraft.NTSB ANC02LA112Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to attain the proper touchdown point on a remote airstrip, and his failure to perform a go-around that resulted in the airplane overrunning the end of the strip. Factors in the accident were the pilot's inadequate evaluation of a tailwind…NTSB NYC02LA179Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Stow, MAThe pilot's improper recover from a bounce landing, which resulted in a loss of directional control and collision with a vehicle. A factor in this accident was the crosswind condition.NTSB MIA02LA165Accident · Serious injuriesLimited investigationFinal reportCessna T337D · Fort Pierce, FLThe pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.NTSB MIA02LA164Accident · Minor injuriesLimited investigationFinal reportClarence F. Callahan Challenger II · Plymouth, FLThe pilot's failure to maintain the proper alignment which resulted in the airplane impacting trees on the south side of the approach end of the landing runway.NTSB MIA02LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe student pilot's failure to maintain control of the airplane during the takeoff roll/run which resulted in the airplane departing the runway and into a ditch where it nosed over incurring substantial damage.NTSB MIA02FA162Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Greeneville, TNA loss of engine power for undetermined reasons and the pilot's decision to continue flight with a known equipment deficiency. Also causal was the pilot's failure to maintain airspeed which resulted in a stall.NTSB ATL02FA162Accident · 2 fatalField investigationFinal reportAmerican General AA-5B · Zephyrhills, FLThe pilots continued visual flight into instrument conditions (fog), and subsequent collision with a tree and a residence.NTSB ANC02LA111Accident · No injuriesLimited investigationFinal reportCessna 185E · Sparrevohn, AKThe pilot's selection of unsuitable terrain for landing that resulted in separation of the right main gear during the landing roll. A factor in the accident was a rough/uneven gravel bar.NTSB ANC02LA110Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Port Alsworth, AKThe pilot's inadequate evaluation of the area weather conditions, and his subsequent inability to maintain terrain clearance upon encountering a downdraft, which resulted in an in-flight collision with tree-covered mountainous terrain. A factor in the…NTSB SEA02LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · W. Yellowstone, MTThe pilot's compensation for the wind conditions was inadequate during the landing roll. A quartering tailwind was a factor.NTSB SEA02LA168Accident · Serious injuriesLimited investigationFinal reportNolley BD-5 · Corvallis, ORFuel starvation resulting in a loss of engine power during the aircraft's initial climb. A disconnected fuel line was a factor.NTSB MIA02FA161Accident · Serious injuriesField investigationFinal reportSikorsky S76A+ · Miami, FLThe flight crew's diverted attention, inadequate visual lookout, and failure to ensure adequate main rotor clearance. Factors in the accident were the continued operation, with known obstructions in the area, and the failure of the FAA to initially certify…NTSB LAX02LA270Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Fresno, CAa loss of engine power for undetermined reasons.NTSB LAX02LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeside, CAThe failure of the engine to respond for undetermined reasons. Also causal was the student's decision to continue the simulated emergency maneuver to an altitude that was insufficient to allow for contingency options. The unsuitable nature of the terrain…NTSB LAX02LA268Accident · Serious injuriesLimited investigationFinal reportBreezy RLU-1A · North Las Vegas, NVthe failure of both pilots to maintain an adequate terrain clearance altitude while maneuvering in a canyon.NTSB FTW02LA246Accident · No injuriesLimited investigationFinal reportCessna 182-Q · New Roads, LAThe pilot's failure to maintain airspeed which resulted in a stall.NTSB FTW02LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Price, TXThe loss of engine power for an undetermined reason, which resulted in a forced landing.NTSB CHI02CA267Accident · No injuriesData collectionFinal reportTomash Avid Flyer · Camp Lake, WIThe total failure of the engine ignition system, and the unsuitable terrain encountered during the forced landing. The low altitude was a contributing factor.NTSB NYC02FA177Accident · 1 fatalField investigationFinal reportGates Learjet 25C · Lexington, KYThe captain's addition of forward thrust during the landing rollout, which resulted in a lack of braking effectiveness and a subsequent runway overrun. A factor was the captain's inability to deploy the thrust reversers for undetermined reasons.NTSB LAX02WA272Incident · No injuriesForeign investigationBoeing 747-419 · Auckland, New ZealandNTSB LAX02TA267Accident · No injuriesFinal reportSikorsky S-55T · Lytle Creek, CAFailure of the hydraulic system due to contamination in the hydraulic fluid, which resulted in an in-flight loss of control.NTSB FTW02LA245Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hearne, TXThe pilot's failure to maintain clearance with a pump rig while maneuvering during an aerial application flight. A factor was the object.NTSB DEN02LA101Accident · Serious injuriesLimited investigationFinal reportBell 206L-III · Canon City, COthe pilot's failure to maintain clearance of a static wire, and the subsequent loss of aircraft control due to the main rotor pitch change tubes being severed.NTSB CHI02LA273Accident · No injuriesLimited investigationFinal reportCessna 195 · Shenandoah, IAThe pilot's inadequate compensation for wind, and the locked brake. A factor associated with the accident was the crosswind.NTSB CHI02LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Elwood, INThe pilot's misjudgment of speed/distance and his failure to perform a go-around. The pilot's inaccurate evaluation of the wind, a tailwind, selection of the wrong runway, and wet grass are contributing factors.NTSB ATL02LA164Accident · No injuriesLimited investigationFinal reportBarker Experimental · Panacea, FLThe builders inadequate weld on the nose gear u-shaped bracket, that resulted in the nose wheel strut failure, and subsequent nose over during an attempted landing.NTSB ATL02LA163Accident · No injuriesLimited investigationFinal reportCessna 210L · Georgetown, SCThe failure of the landing gear to lock in the down position.NTSB SEA02WA173Accident · No injuriesForeign investigationCessna 180K · Pitt Meadows, CanadaNTSB NYC02LA180Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Louisa, VAA loss of engine power for an undetermined reason.NTSB LAX02LA265Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Ruth, CAThe pilot's inadequate compensation for the wind conditions and failure to maintain control.NTSB LAX02FA266Accident · Serious injuriesField investigationFinal reportAirbus Industrie A320-231 · Phoenix, AZThe captain's failure to maintain directional control and his inadvertent application of asymmetrical engine thrust while attempting to move the #1 thrust lever out of reverse. A factor in the accident was the crew's inadequate coordination and crew resource…NTSB ATL02IA165Incident · No injuriesIncident investigationFinal reportBeech 1900D · Tampa, FLThe improper service of the left main landing gear socket, resulting in fatigue failure of the left main landing gear socket assembly at the lower scissor attachment point.NTSB ANC02LA109Accident · No injuriesLimited investigationFinal reportCessna 206 · Aniak, AKThe pilot's selection of unsuitable terrain for landing. A contributing factor in the accident was the rough and uneven terrain (hole) in the landing area.NTSB ANC02FA108Accident · 2 fatalField investigationFinal reportRobinson R-44 · Ketchikan, AKThe pilot's failure to maintain control of the helicopter in-flight due to spatial disorientation, which resulted in an uncontrolled descent and impact with the surface of a lake. Factors contributing to the accident were the high terrain surrounding the…NTSB ANC02FA106Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 MK3 · Aleknagik, AKThe pilot's failure to use a checklist to ensure the airplane was in the proper landing configuration, which precipitated an inadvertent water landing on amphibious floats with the wheels extended. A factor contributing to the accident was the pilot's failure…NTSB SEA02LA167Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Creek, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include high density altitude, variable winds, and a ditch near the point where the aircraft departed the side of the runway.NTSB CHI02LA264Accident · No injuriesLimited investigationFinal reportCessna 182S · Fishers, INThe pilot failed to maintain clearance with the light pole while taxiing. A factor was the light pole.NTSB CHI02FA262Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Newaygo, MIThe altitude/clearance disregarded by the pilot and his ostentatious display. The wire and low altitude flight were a contributing factor.NTSB ANC02FA107Accident · 2 fatalField investigationFinal reportCessna A185F · Kodiak, AKThe pilot's failure to maintain adequate airspeed and his operation of the airplane in an over gross condition. A contributing factor was noncompliance with written company weight and balance procedures.NTSB NYC02LA176Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Athens, OHThe student pilot's improper fuel management, which resulted in fuel starvation during cruise flight. A factor was the operator's failure to perform maintenance on a fuel gauge that was noted twice in a discrepancy log.NTSB MIA02LA159Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hernando, MSThe pilot's operation of the airplane with known deficiencies ( contaminated fuel system) which resulted in fuel starvation, a forced landing to a cotton field, and damage to the airplane during the landing.NTSB MIA02IA160Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland MBB BK-117 A4 · Bradenton, FLImproper maintenance/installation of the No. 2 engine power turbine (PT) wheel assembly by company maintenance personnel, which resulted in deflection at the engine case axial midpoint and misalignment between the inlet housing and the rear bearing support…NTSB FTW02LA242Accident · No injuriesLimited investigationFinal reportWhittman Tailwind W-8 · Albuquerque, NMThe structural failure and separation of a propeller blade for undetermined reasons. A contributing factor was the lack of suitable terrain available to the pilot to execute a forced landing.NTSB FTW02LA240Accident · Serious injuriesLimited investigationFinal reportBalloon Works FireFly 7B-15 · Oklahoma City, OKthe pilot's inadvertent flight into adverse weather conditions resulting in a hard landing. A contributing factor was the high wind.NTSB CHI02LA266Accident · No injuriesLimited investigationFinal reportSchweizer SGS-126E · Ionia, MIThe pilot's failure to maintain clearance from the runway end identifier light (REIL). A factor to the accident was the REIL.NTSB ANC02LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · Fairbanks, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane exiting the runway and colliding with objects. Factors contributing to the accident were the rough and uneven runway, and the premature lift-off of the…