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 CHI02LA089Accident · No injuriesLimited investigationFinal reportBeech D35 · Ankeny, IAthe excessive flare by the pilot. The icing conditions were a contributing factor.NTSB CHI02IA085Incident · No injuriesIncident investigationFinal reportBeech BE-55 · Springfield, MOThe inadequate visual lookout by the flightcrew of the other airplane.NTSB ATL02FA059Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Macon, GAThe pilot's failure to maintain clearance from a tree while maneuvering after takeoff.NTSB SEA02LA047Accident · No injuriesLimited investigationFinal reportCessna 172N · Longmont, COThe student pilot's failure to maintain directional control during landing. Factors included the student pilot's lack of experience, an icy runway, and a mound of snow adjacent to the runway.NTSB LAX02LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · San Diego, CAfuel starvation due to the pilot's mismanagement of the fuel system.NTSB LAX02LA100Accident · Serious injuriesLimited investigationFinal reportAeronca C-3 · Sonoma, CAthe pilot's excessive remedial control inputs in response to a passenger's control inputs, which led to a failure to maintain an adequate airspeed and an inadvertent stall/mush. The pilot's inadequate preflight decision to allow a student pilot to occupy the…NTSB LAX02LA099Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Marana, AZThe left brake failed due to a stuck piston.NTSB ATL02FA058Accident · 1 fatalField investigationFinal reportBeech BE-60 · Mexia, TXThe pilot's failure to remove the control lock before the flight and his failure to follow the checklist.NTSB SEA02LA049Accident · No injuriesLimited investigationFinal reportBoeing 757-200 · Seattle, WAThe failure of the deicing truck driver to insure that the deicing basket boom remained clear of the aircraft structure as he backed away from the position he had been in while performing deicing procedures.NTSB SEA02LA046Accident · No injuriesLimited investigationFinal reportCessna 421C · Hailey, IDWater contamination within the aircraft's landing gear hydraulic line(s) which froze and blocked the line(s) preventing extension of the right main gear. A factor was the below freezing environmental conditions which the aircraft was operating in prior to and…NTSB SEA02IA044Incident · No injuriesIncident investigationFinal reportBombardier DHC-8-401 · Boise, IDThe partial failure of one of the number two hydraulic system elevator hydraulic lines, leading to the loss of fluid and pressure in that system during cruise flight. This loss resulted in reliance upon the sole remaining activation system (number one…NTSB NYC02LA070Accident · No injuriesLimited investigationFinal reportCessna 172P · Coatesville, PAThe student pilot's loss of aircraft control which resulted in a hard landing, and the CFI's delayed remedial action. Factors related to the accident were the fatigue cracks which initiated at the attachment hole on the landing gear strut, and the crosswind…NTSB LAX02LA098Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Peoria, AZFailure of the cyclist to coordinate and communicate that he was on the active runway. A contributing factor was the sun glare encountered by the pilot on final approach.NTSB FTW02FA087Accident · 2 fatalField investigationFinal reportBeech A36 · Austin, TXThe pilot's failure to maintain airspeed, resulting in a stall. Contributing factors were the low ceiling, fog, and the unforecast weather conditions..NTSB DCA02RA024Incident · No injuriesForeign investigationBoeing 747 · Sydney, AustraliaNTSB ANC02LA019Accident · No injuriesLimited investigationFinal reportCessna 207A · Kotlik, AKThe failure of the pilot-in-command to maintain the proper glide path to the runway during the final approach for a VFR landing.NTSB MIA02LA064Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marion, SCThe loss of engine power during takeoff/initial climb due to undetermined reasons, resulting in a landing on unsuitable terrain.NTSB FTW02LA086Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Extension, LAThe pilot's failure to maintain aircraft control. A factor was the pilot's impairment due to drugs.NTSB ATL02FA057Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hamilton, GAThe loss of engine power for undetermined reasons.NTSB SEA02LA045Accident · No injuriesLimited investigationFinal reportGunderson Floatmaster · Elma, WALoss of engine power for undetermined reasons. Soft terrain was a factor.NTSB LAX02FA097Accident · 1 fatalField investigationFinal reportGrumman American AA1B · Pomona, CAa total loss of engine power due to an excessively rich mixture setting in the carburetor. The overly rich operation of the carburetor was due to the overhaul shop's failure to obtain the proper clearance between the float and chamber walls, which allowed the…NTSB CHI02IA083Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Appleton, WIThe separation of the low pressure turbine module due to coke resulting in the blockage of the oil system.NTSB ATL02LA056Accident · No injuriesLimited investigationFinal reportCessna 210L · Atlanta, GAThe pilot's failure to obtain the proper touchdown point and excessive airspeed on landing resulting in the airplane going off the end of the runway, on-ground collision with an embankment, and subsequent nose over.NTSB SEA02LA043Accident · No injuriesLimited investigationFinal reportBeech G35 · Anacortes, WAThe pilot's inadvertent failure to lower the landing gear prior to touchdown.NTSB ATL02LA055Accident · 1 fatalLimited investigationFinal reportKrejci S-51D · Port St. Lucie, FLThe pilots failure to maintain airspeed while maneuvering in an attempt to return to landing area (Emergency/ departure airport.) This resulted in an inadvertent stall and subsequent in-flight collision with terrain. Factor to the accident was a partial loss…NTSB LAX02LA096Accident · No injuriesLimited investigationFinal reportRotorway Rotorway Exec 90 · Phoenix, AZThe student's inadvertent over control of the throttle mechanism, which resulted in the bending of the throttle mechanical stop and binding the linkage in the idle position. Also causal was the CFI's inadequate supervision. A factor in the accident was the…NTSB LAX02LA095Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAThe pilot's inadequate planning and improper fuel consumption calculation, which resulted in fuel exhaustion.NTSB LAX02LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Madera, CAThe pilot's becoming lost/disoriented.NTSB IAD02LA035Accident · Serious injuriesLimited investigationFinal reportBeechcraft C23 · Wilmington, DEthe flight instructor's improper fuel management which resulted in fuel starvation. A factor in the accident was the flight instructor's failure to follow the published checklist procedures.NTSB ATL02LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe student pilot's improper flare and failure to recover from a bounced landing resulting in the subsequent collapse of the nose gear during the landing flare touchdown. A factor contributing to the accident was the student pilot's lack of total experience.NTSB ATL02LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, FLTotal loss of engine power due to oil starvation to the No. 3 connecting rod preceded by aft displacement of the center main bearing due to excessive wear. This resulted in a forced landing to none suitable terrain and subsequent on-ground collision with a…NTSB LAX02LA093Accident · No injuriesLimited investigationFinal reportSaumure Exec 162F · Ramona, CAThe pilot's failure to maintain adequate airspeed and main rotor rpm while performing a low altitude maneuver, which resulted in a loss of translational lift, a hard landing, and rollover on downhill terrain.NTSB DEN02LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Ferron, UTa loss of engine power due to the ingestion of foreign object(s) into the meshing of the gears, causing a malfunction of the magneto idler gear and failure of maintenance personnel to detect the signs of imminent failure during a mandatory oil filter…NTSB ANC02LA016Accident · No injuriesLimited investigationFinal reportCessna 208B · Tununak, AKThe pilot's selection of unsuitable terrain for landing. Factors associated with the accident are snow drifts across the runway, and excessive braking during the rearward roll.NTSB WAS02WA026Accident · 2 fatalForeign investigationCessna U206G · San Antonio, PeruNTSB NYC02LA072Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Atlantic City, NJThe pilot's failure to lower the landing gear prior to landing.NTSB NYC02LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJThe pilot's failure to obtain a proper touchdown point.NTSB LAX02LA150Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 120 A · Moreno Valley, CAThe pilot's inadequate handling of the aircraft. High winds were a contributing factor.NTSB LAX02LA091Accident · No injuriesLimited investigationFinal reportBeech V35 · San Jose, CAa loss of engine power for undetermined reasons, which resulted in a forced landing into a residential area.NTSB IAD02LA034Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Fredericksburg, VAThe unauthorized modification of the air control box by unknown persons, and the failure of subsequent mechanics to note and correct the deficiency. Factors included the carburetor icing conditions and the unsuitable terrain mandated by the forced landing.NTSB CHI02LA084Accident · No injuriesLimited investigationFinal reportCessna 172S · New Holstein, WIThe pilot's inadequate compensation for the wind conditions which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the gusty crosswind condition and the runway marker sign which the airplane…NTSB CHI02LA082Accident · No injuriesLimited investigationFinal reportCessna 182T · Franklin, INThe proper glidepath not attained, the excessive airspeed, and the pilot failed to attain clearance from the trees during the aborted landing. An additional factor was the trees.NTSB ATL02FA051Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Vero Beach, FLThe flight's encounter with isolated severe to extreme turbulence that resulted in an in-flight breakup of the airplane and subsequent impact with terrain.NTSB ANC02LA017Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Fairbanks, AKThe pilot's failure to maintain clearance from objects while maneuvering. A factor associated with the accident is an undetermined object.NTSB LAX02LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Santa Paula, CAThe pilot's selection of the wrong landing runway due to his failure to correctly interpret wind indicators, which resulted in his landing with a tailwind.NTSB LAX02LA090Accident · Minor injuriesLimited investigationFinal reportYoung Mini-500 · Paso Robles, CAthe pilot's inadequate visual lookout and his failure to maintain obstacle clearance.NTSB LAX02LA089Accident · No injuriesLimited investigationFinal reportBeech 77 · Long Beach, CAA loss of directional control due to the pilot's inadequate compensation for the existing crosswind condition.NTSB FTW02LA084Accident · No injuriesLimited investigationFinal reportCessna 172A · Albuquerque, NMthe pilot's delay in executing a go-around while conducting a simulated emergency landing, which resulted in an in flight collision with terrain.NTSB WAS02WA023Accident · Minor injuriesForeign investigationBell 430 · Indore, IndiaNTSB NYC02WA063Accident · 1 fatalForeign investigationRobinson R-44 · Verona, Italy