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 LAX02LA070Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Payson, AZFailure of the pilot to maintain directional control of the airplane. A contributing factor was the premature raising of the flaps.NTSB LAX02FA069Accident · 1 fatalField investigationFinal reportCameron Balloons US N-145 · North Las Vegas, NVThe pilot's misjudged approach and inadequate obstacle clearance, which resulted in his failure to attain the proper touchdown point. Contributing factors were the high gusty wind condition, and the pilot's failure to provide protective safety equipment.NTSB IAD02LA029Accident · No injuriesLimited investigationFinal reportCessna 172P · Doylestown, PApilot's failure to maintain clearance between the airplane and a parked fuel truck while taxing.NTSB FTW02LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Ardmore, OKthe instructor pilot's delayed go-around which resulted in an in-flight collision with trees. A contributing factor to the accident was the instructor pilot's fatigued condition due to lack of sleep.NTSB CHI02LA071Accident · No injuriesLimited investigationFinal reportBeech F33A · Bloomington, INThe pilot's inadequate recovery from a bounced landing which resulted in a hard contact with the runway. Factors associated with the accident were the improper flare and the crosswind condition.NTSB NYC02FA051Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Chittenden, VTThe pilot's failure to maintain aircraft control while holding.NTSB MIA02LA053Accident · No injuriesLimited investigationFinal reportCessna 182L · Boca Raton, FLThe pilot's failure to perform a proper preflight inspection and refueling of the aircraft, resulting in an in-flight loss of engine power due to fuel exhaustion and a collision with a road sign during the emergency landing.NTSB IAD02LA027Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Waterville, METhe pilot's improper decision to attempt a takeoff from a snow-covered runway with a quartering tailwind.NTSB ANC02IA011Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-340-300 · Anchorage, AKThe captain's selection of a taxiway instead of a runway for takeoff and the flightcrew's inadequate coordination of the departure, which resulted in a departure from a taxiway. A factor in the incident was inadequate airline operator's procedures that did…NTSB CHI02LA069Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-41 · Indianapolis, INThe passenger fell off the side of the slide during the emergency evacuation. Factors were the emergency evacuation and the erratic ignition exciter.NTSB FTW02WA235Accident · Minor injuriesForeign investigationCessna A188 · Hato Viejo, Dominican RepublicNTSB CHI02FA067Accident · 1 fatalField investigationFinal reportCessna 402B · Bronson, MIThe maneuver to avoid the utility wire while maneuvering resulting in an inadvertent stall and subsequent impact with the ground. Factors were the pilot's inadvertent activation of the elevator trim, resulting in a loss of control during flight in instrument…NTSB WAS02WA042Accident · 1 fatalForeign investigationSchweizer 333 · Gaborone, BotswanaNTSB NYC02LA049Accident · 1 fatalLimited investigationFinal reportStiles Choctaw · Danville, KYFailure of a connecting rod bearing, which resulted in a loss of engine power during climb.NTSB MIA02LA055Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Milton, FLThe inability of the pilot to maintain directional control of the airplane resulting in a ground loop. A finding in the investigation was a loose left rudder flight control cable.NTSB LAX02LA068Accident · No injuriesLimited investigationFinal reportCessna 206H · Mammoth Lakes, CAthe pilot's inadequate compensation for the gusty crosswind conditions, which resulted in a loss of aircraft control and nose over during landing roll.NTSB FTW04WA068Accident · 2 fatalForeign investigationCessna 182L · Trinidad, BoliviaNTSB FTW02FA072Accident · 1 fatalField investigationFinal reportCessna 177 · Farmington, NMthe pilot's inadequate in-flight planning decision which resulted in fuel exhaustion while in the traffic pattern at the destination airport.NTSB CHI02LA066Accident · No injuriesLimited investigationFinal reportCessna T210N · Chicago, ILthe pilot's failure to maintain aircraft control after takeoff. Factors relating to the accident were the pilot excessive rotation during takeoff and the crosswind.NTSB LAX02LA082Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mammoth Lakes, CAThe onset of variable, gusty, crosswind conditions at the time of departure and the pilot's inadequate and improper compensation for the crosswind conditions.NTSB FTW02WA214Accident · Minor injuriesForeign investigationBell 47G2A · Pococi, Costa RicaNTSB CHI02LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Iowa Falls, IAThe pilot's inadequate compensation for the crosswind condition and the subsequent failure to maintain control of the airplane. Factors associated with the accident were the crosswind and the rough terrain encountered.NTSB SEA02WA066Incident · No injuriesForeign investigationBoeing 737-500 · Bodo, NorwayNTSB SEA02FA030Accident · Serious injuriesField investigationFinal reportAgusta A109A II · Baring, WAThe sequential non-mechanical total loss of power in both engines 1 and 2 for undetermined reasons and the pilot's failure to maintain adequate rotor RPM to prevent a hard landing. Contributing factors were the tripped "RPM WARN" circuit breaker which…NTSB NYC02LA056Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-32 · Dulles, VAThe lack of direction from the operator on how to perform pushbacks on an icy ramp, which led to the tug driver positioning the tug at an angle to the nose of the airplane that allowed the airplane to move forward and strike the tug. Factors were the…NTSB NYC02LA050Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Manassas, VAThe pilot's improper autorotation, which resulted in a hard landing and bent airframe support tube. A factor in this accident was previous damage to the airframe support tube.NTSB MIA02LA056Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Sarasota, FLThe poor in-flight planning decision by the pilot-in-command for his failure to request the runway most aligned with the wind and his failure to maintain directional control during the landing roll.NTSB DEN02LA022Accident · No injuriesLimited investigationFinal reportCessna 175 · St. George, UTThe student pilot's failure to maintain aircraft directional control during take off roll.NTSB CHI02LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Clear Lake, MNThe loss of engine power for undetermined reasons and the unsuitable terrain for the forced landing. Factors were the low altitude and the fences.NTSB SEA02LA034Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Baker City, ORThe pilot's excessive descent rate at the time the aircraft came in contact with the runway during a night precautionary landing. Factors include extensive airframe ice accumulation, ice accumulation on the flight compartment windshield, ambient conditions…NTSB SEA02LA031Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Glasgow, MTThe pilot's failure to maintain adequate flying airspeed resulting in a stall/mush condition and loss of control at low altitude. A contributing factor was the pilot's distraction from flying the aircraft while attempting to retract the landing gear.NTSB ATL02LA042Accident · Minor injuriesLimited investigationFinal reportLouis Edmondson 162F · St. Petersburg, FLThe pilot's decision to continue flight with demonstrated inadequate takeoff performance capability, which resulted in an in-flight loss of control and subsequent hard landing.NTSB WAS02WA018Accident · 2 fatalForeign investigationGrandman Cozy · Los Barriles, MexicoNTSB IAD02FA026Accident · 2 fatalField investigationFinal reportMBB BK-117 A-3 · Cleveland, OHpilot's failure to maintain directional control of the helicopter while hovering, which resulted in its collision with a building. Factors were the confined area, tail wind, and wind gusts.NTSB FTW02FA071Accident · 1 fatalField investigationFinal reportBeech C23 · Sinton, TXThe pilot's failure to maintain clearance with trees while executing a missed approach procedure. Contributing factors were the prevailing fog and the dark night conditions.NTSB CHI02LA064Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Wahoo, NEThe student, who was a private pilot, used excessive braking during the landing roll.NTSB ATL02WA041Accident · No injuriesForeign investigationBritten-Norman BN2-A · British Virgin, British Virgin IslandsNTSB WAS02RA025Accident · 26 fatalForeign investigationFairchild FH-227 · El Tigre, ColombiaNTSB MIA02LA050Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Lake Placid, FLThe failure of the pilot to perform a proper preflight inspection and his improper fuel tank selection for takeoff, resulting in a loss of engine power on takeoff due to fuel starvation, and the pilot's failure to maintain directional control of the aircraft…NTSB FTW02FA070Accident · 3 fatalField investigationFinal reportCessna 340A · Temple, TXThe pilot's mismanagement of fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing factors were the pilot's failure to follow the checklist to feather the propellers in order to reduce drag.NTSB DEN02LA021Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Logan, UTthe pilot's failure to maintain aircraft control during landing roll. Contributing factors were the runway's patchy snow and ice conditions and a snow bank along the side of the runway.NTSB ATL02LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bessemer, ALOn ground collision with an animal during landing.NTSB FTW02LA069Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Plainview, TXthe pilot's failure to maintain the proper glidepath, which resulted in landing short of the runway.NTSB DCA02RA017Accident · 1 fatalForeign investigationBoeing 737-300 · Solo (Java Is.), IndonesiaNTSB FTW02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Iraan, TXThe pilot's failure to maintain directional control during landing roll. Contributing factors were the pilot's selection of a downwind runway for landing, the tail wind condition, and his lack of total experience in the type of aircraft.NTSB ANC02FA010Accident · 1 fatalField investigationFinal reportPiper PA-32 · Haines, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent collision with trees while in cruise flight. Factors in the accident were weather conditions consisting of freezing rain, mist, and low ceilings.NTSB LAX02LA066Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Groveland, CAthe pilot's improper preflight planning and improper weather evaluation.NTSB IAD02LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oxford, MAThe pilot's delayed aborted landing and his failure to attain obstacle clearance. The pilot's misjudgment of distance is a contributing factor.NTSB DEN02LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Pagosa Springs, COthe total power failure of the right engine due to the failure of its lubricating system. Contributing factors were the lack of suitable terrain for a forced landing, and the terrain being above the airplane's single engine performance capability.NTSB DCA02RA016Accident · Minor injuriesForeign investigationBoeing 737-200 · Pekanbaru, Indonesia