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 ANC02LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe failure of the pilot to maintain directional control during takeoff. A factor associated with the accident was an inadvertent ground loop.NTSB SEA02LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · South Prairie, WAThe pilot's improper touchdown point. Factors include a wet landing surface.NTSB LAX02LA159Accident · No injuriesLimited investigationFinal reportCessna 170B · San Diego, CAThe failure of the dual student to maintain directional control of the airplane and the instructor's delayed the remedial action, which resulted in a ground loop. A factor in the accident was the gusting crosswind conditions.NTSB LAX02LA158Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Reno, NVFailure of the pilot to maintain directional control. A factor was the hump in the runway.NTSB LAX02LA156Accident · No injuriesLimited investigationFinal reportHam Pitts S-1C · Borrego Springs, CAThe failure of the pilot to maintain control of the airplane during landing rollout resulting in a ground loop/swerve and a nose over. The soft terrain was a factor.NTSB LAX02FA157Accident · Serious injuriesField investigationFinal reportErcoupe 415C · El Cajon, CAfuel starvation due to the mechanic's failure to properly tighten a fuel line fitting on the engine driven fuel pump, which led to a depletion of the fuel in the header tank. The mechanic's self induced pressure to complete the job prior to leaving on…NTSB FTW02LA146Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B-15 · Port Allen, LAThe pilot's decision to land in the sugar cane field, which resulted in the pilot's unintentional exit from the basket. A contributing factor was the high vegetation in the field.NTSB DEN02LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Monument Valley, UTthe pilot's inadvertent stall/mush to the ground during landing flare. Contributing factors were the earth berm along the side of the runway, and the wind shear weather condition on short final.NTSB CHI02LA134Accident · Serious injuriesLimited investigationFinal reportAeronca 7FC · Neenah, WIThe pilot not maintaining control of the airplane during the landing approach, and his failure to maintain clearance from terrain.NTSB CHI02LA129Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Watertown, MNThe improper fuel management by the pilot which resulted in fuel starvation and subsequent loss of engine power. Contributing to the accident was the soft terrain in which the forced landing was completed.NTSB CHI02LA128Accident · No injuriesLimited investigationFinal reportBoeing 757-33N · Chicago, ILThe ground personnel handled the aircraft improperly during pushback from the gate by failing to maintain clearance with the other parked aircraft. The light rain and the parked airplane that was contacted were factors.NTSB ATL02LA096Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Livingston, TNThe pilot failure to maintain flying speed, followed by a subsequent stall.NTSB ANC02LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairbanks, AKThe pilots improper starting procedure. Factors associated with the accident are the continued operation of the airplane with a known mechanical deficiency, and failure to use wheel chocks and/or tie-down rope/straps to restrain the airplane during the engine…NTSB IAD02LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norwood, MAThe student pilot's failure to maintain directional control during an aborted landing.NTSB IAD02LA049Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Westhampton Bch, NYLoss of engine power for undetermined reasons.NTSB CHI02LA135Accident · No injuriesLimited investigationFinal reportMooney M20F · Minneapolis, MNThe pilot did not attain a proper climb rate during the go-around and the intentional wheels up landing. Factors associated with the accident were the inability of the pilot to maintain directional control of the airplane during the landing and the parked…NTSB CHI02LA133Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Bancroft, WIThe loss of engine power due to contamination of the fuel system from an unknown source and the blocked fuel filter. The rough terrain was a factor.NTSB CHI02LA132Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Hordville, NEA loss of engine power due to a fractured rocker arm shaf. Contributing to the accident was the soft, furrowed field.NTSB CHI02LA131Accident · Serious injuriesLimited investigationFinal reportGlaser-Dirks-Flugzeubau DG-100G · Union, ILThe pilot not maintaining aircraft control during the aero-tow takeoff. Factors to the accident were the high wind velocity and the gusting wind condition.NTSB CHI02LA126Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Sandwich, ILThe driver of the automobile improperly drove his automobile on the active runway and did not maintain visual lookout for landing aircraft.NTSB ATL02LA095Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600N · Deland, FLThe pilot's failure to follow the FADEC malfunction checklist that resulted in the loss of rotor RPM, and the pilot's improper use of the flight controls during the precautionary landing that resulted in a hard landing. A factor was the malfunction of the…NTSB LAX02LA155Accident · 1 fatalLimited investigationFinal reportMueller Skyraider 1 · Elko, NVthe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall.NTSB FTW02LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXthe student pilot's improper recovery from a bounced landing, which resulted in a nose over.NTSB FTW02LA142Accident · No injuriesLimited investigationFinal reportPiper Aerostar 602P · Albuquerque, NMThe pilot's delayed extension of the main landing gear prior to the landing flare/touchdown, which resulted in a wheels-up landing. A contributing factor was the loss of engine power for an undetermined reason.NTSB CHI02LA130Accident · No injuriesLimited investigationFinal reportCessna 180 · Hyannis, NEThe pilot did not maintain directional control and executed improper use of the brakes. A factor associated with the accident was the soft terrain.NTSB NYC02LA096Accident · No injuriesLimited investigationFinal reportBeech 400 · Cleveland, OHIngestion of birds into both engines.NTSB NYC02LA095Accident · Serious injuriesLimited investigationFinal reportCessna 152M · Forest, VAThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a nose over.NTSB NYC02IA097Incident · No injuriesIncident investigationFinal reportBombardier CL600-2B19 · Covington, KYThe manufacturer's failure to provide inspection criteria for the BPSU compartment aileron control pulleys, which resulted in eventual pulley corrosion, and subsequent control stiffness when seized pulleys and water-soaked aileron cables froze together at…NTSB MIA02IA094Incident · No injuriesIncident investigationFinal reportBoeing B737-448 · Miami, FLInadequate maintenance by company maintenance personnel and failure to comply with manufacturer recommended maintence procedures (SB 737-55A1070R1), which resulted in an inflight inseparation of a section of the airplane's right hand elevator control tab. A…NTSB LAX02LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Sacramento, CAFailure of the pilot to ensure the seat was set properly prior to engine start, and not using the parking brake when adjustment of seat was necessary, which resulted in the inadvertent deactivation of the brakes and subsequent collision with the fuel trucks.NTSB LAX02LA153Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Green Valley, AZThe pilot's failure to identify the wind direction, which led to an attempted downwind landing approach that resulted in a hard landing and severe bounce. Also causal was the pilot's failure to promptly retract the flaps during the rejected landing after…NTSB LAX02LA152Accident · No injuriesLimited investigationFinal reportCessna 182P · Boulder City, NVthe pilot's failure to lean the mixture properly resulting in a partial loss of power.NTSB FTW02WA144Accident · 4 fatalForeign investigationCessna 172 · Mamayac, EcuadorNTSB DCA02RA034Accident · 14 fatalForeign investigationBoeing 737-500 · Tunis, TunisiaNTSB LAX02LA151Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Flagstaff, AZa loss of engine power for undetermined reasons.NTSB NYC02LA093Accident · No injuriesLimited investigationFinal reportD'Apuzzo D-260 · Andover, NJThe pilot's failure to obtain proper runway alignment while landing, which resulted in a gear collapse.NTSB NYC02LA092Accident · No injuriesLimited investigationFinal reportBlanik L-13 · Saratoga Spring, NYThe glider encountering an unanticipated downdraft, which resulted in insufficient altitude to reach a suitable landing area.NTSB MIA02LA093Accident · 1 fatalLimited investigationFinal reportHispano Aviacion HA-200-Saeta · Perry, GAThe pilots failure to maintain airspeed while performing a turn at a low altitude, which resulted in a inadvertent stall, an uncontrolled descent, and an impact with trees and terrain.NTSB LAX02LA149Accident · No injuriesLimited investigationFinal reportSierra RAF 2000 GTX-SE · Lompoc, CAThe pilot's failure to compensate for wind condition.NTSB IAD02LA048Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fairfield, PAThe pilot's failure to attain proper runway alignment. A factor in the accident was the pilot's delay in retracting the spoilers.NTSB CHI02LA121Accident · 2 fatalLimited investigationFinal reportYoder GP-4 · Mount Pleasant, MIThe inadvertent stall/spin by the pilot-in-command.NTSB NYC02LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Middleville, NYThe pilot's failure to maintain proper alignment with the runway after being struck by a gust of wind. Factors were the gusty winds and the berm struck by the airplane.NTSB LAX02LA145Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Reno, NVThe inadvertent activation of the parking brake and locking of the right brake. A contributing factor was the pilot's operation of the aircraft with a known malfunction of the right brake system.NTSB FTW02LA139Accident · Minor injuriesLimited investigationFinal reportBoeing A75SN1 · Georgetown, TXThe pilot's inadequate planning/decision resulting in the wake turbulence encounter during the takeoff/initial climb of the formation flight. A contributing factor was the partial loss of engine power for an undetermined reason.NTSB CHI02LA127Accident · No injuriesLimited investigationFinal reportCessna 310L · Detroit, MIThe total failure of the electrical system, the landing gear indicating system not operating, and the unsuccessful emergency landing gear extension.NTSB CHI02LA122Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hastings, MIThe failure to attain airspeed, inadequate supervision of the flight, and delayed remedial action which resulted in a stall.NTSB WAS02WA040Accident · 3 fatalForeign investigationPiper PA-28 · Edenkoben, GermanyNTSB CHI02LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Redfield, SDthe failure of the pilot to maintain directional control while taxing to takeoff in high and gusty wind conditions.NTSB CHI02FA120Accident · 1 fatalField investigationFinal reportCessna 182S · Sheboygan, WIThe pilot failed to maintain control of the airplane during the go-around for undetermined reasons.NTSB SEA02LA078Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Davenport, WAThe pilot's failure to adequately compensate for the wind conditions during takeoff. Gusting wind was a factor.