NTSB investigations, 2002
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 SEA02LA127Accident · No injuriesLimited investigationFinal reportBredl Fokker DR1 · Troutdale, ORThe collapse, for undetermined reasons, of the left main landing gear spoked-wheel structure.NTSB SEA02LA126Accident · Serious injuriesLimited investigationFinal reportCosmos Phase II · Deer Park, WALoss of control for undetermined reasons.NTSB NYC02LA136Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Lincoln Park, NJThe pilot's failure to abort the takeoff when diminished performance was noted. A factor was carburetor icing, accumulated before the takeoff attempt.NTSB MIA02WA178Incident · No injuriesForeign investigationPiper PA-32R-300 · Buenos Aires, ArgentinaNTSB LAX02LA222Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Mesa, AZthe pilot's inadequate compensation for the crosswind conditions, and failure to maintain an appropriate airspeed for the gusts, which resulted in a hard landing.NTSB CHI02LA190Accident · No injuriesLimited investigationFinal reportCessna 150F · Ft. Wayne, INThe corroded throttle cable resulting in a loss of engine power. Factors were the inadequate annual inspection, the unsuitable terrain encountered during the forced landing, the ditch, and the fence.NTSB CHI02LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Gregory, MIAn improper decision by the pilot due to a failure to land at an intermediate airport, and the unsuitable terrain for a forced landing encountered. Contributing factors were the pilot's disorientation (becoming lost), fuel exhaustion, soft terrain encountered…NTSB CHI02FA189Accident · 1 fatalField investigationFinal reportSikorsky S-58ET · Brookville, INThe pilot's intentional low altitude fight and his failure to maintain clearance from power transmission lines. Factors to the accident were the power transmission lines followed by the inability to control the aircraft after the collision with power…NTSB DEN02FA070Accident · No injuriesField investigationFinal reportBoone Rotorway 162-F · Englewood, COthe pilot encountering settling with power. A factor contributing to the accident was the tailwind.NTSB CHI02LA186Accident · No injuriesLimited investigationFinal reportCessna 175 · Kaiser/Lake Oza, MOThe pilot's decision to conduct the flight with a known deficiency in the aircraft, a failure by the pilot to execute a precautionary landing due to "sluggish" performance during takeoff, the loss of engine power due to the malfunction of the left magneto,…NTSB CHI02CA250Accident · No injuriesData collectionFinal reportPiper PA-J3-C65 · Sparta, ILThe CFI's failure to maintain directional control during landing roll and the unsuccessful attempt at a go around. A factor was the ditch.NTSB LAX02LA219Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Show Low, AZthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB FTW02LA203Accident · 1 fatalLimited investigationFinal reportCessna 172B · Denton, TXThe pilot's misjudgment of distance and altitude. Contributing factors were the pilot's diverted attention and the runway localizer antenna.NTSB DEN02TA069Accident · Minor injuriesFinal reportWSK PZL Mielec M-18A · Fillmore, UTthe pilot's failure to follow proper procedures/directives, and the airplane's inability to climb while maneuvering after takeoff. Factors contributing to the accident were improperly mixed aerial application materials (fire retardant slurry), the high…NTSB ANC02LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKThe pilot's selection of an unsuitable area for taxiing, which resulted in running the airplane's float aground. Factors contributing to the accident were the hidden obstructions underwater, and the excessive taxi speed.NTSB NYC02LA133Accident · Serious injuriesLimited investigationFinal reportPiper J3-C65 · Andover, NJThe flight instructor's delayed remedial action, and the private pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin.NTSB MIA02LA130Accident · No injuriesLimited investigationFinal reportBeech B50 · Clanton, ALThe pilot's failure to maintain directional control of the airplane during an aborted landing that resulted in a ground swerve and the airplane exiting the runway and collided with a fence, incurring damage.NTSB LAX02LA218Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Compton, CAthe failure and separation of a fan belt for the engine cooling system. A factor in the accident was the inadequate annual inspection 14 hours prior to the accident.NTSB LAX02LA217Accident · No injuriesLimited investigationFinal reportAerospatiale AS350 BA · Honolulu, HIthe pilot's failure to maintain adequate tail rotor clearance from the sloping terrain in unfavorable wind conditions.NTSB IAD02LA069Accident · No injuriesLimited investigationFinal reportCessna 182T · Plainville, CTThe pilot's improper recovery from a bounced landing.NTSB FTW02LA201Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Waco, TXThe partial loss of engine power due to undetermined reasons. A contributing factor was the pilot's inadequate landing flare which resulted in a hard landing.NTSB CHI02LA185Accident · Minor injuriesLimited investigationFinal reportEskildsen P · Olathe, KSThe pilot's improper planning and decision making during the emergency descent and landing. The total loss of engine power due to fuel exhaustion and the pilot's inadvertent stall were contributing factors.NTSB CHI02CA184Accident · No injuriesData collectionFinal reportPiper PA-34 · Lowell, MIThe probable cause of this accident was a failure to properly compensate for the current wind conditions. Excessive use of brakes was a contributing factor.NTSB ANC02LA073Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Karluk, AKThe pilot's inadvertent water landing on amphibious floats with the wheels extended, which resulted in the airplane nosing over. A factor associated with the accident was the pilot's diverted attention during departure.NTSB SEA02LA123Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Weiser, IDThe fracture of the number 3 cylinder exhaust pushrod resulting in the exhaust valve's inability to open during the exhaust cycle and the subsequent engine stoppage. Contributing factors were the ditch and elevated roadway which the aircraft crossed during…NTSB SEA02FA125Accident · 2 fatalField investigationFinal reportCessna 172N · Otis, ORThe pilot's failure to maintain adequate clearance with power lines while conducting low altitude flight resulting in a loss of control and subsequent collision with terrain. Contributing factors were the pilot's low altitude flight and the power lines.NTSB SEA02FA124Accident · No injuriesField investigationFinal reportUnrein Productmatch 80 P51D · Battle Ground, WAThe pilot's failure to maintain the proper airspeed (80 mph) on final approach resulting in a bounced landing and a loss of control during an attempted go-around and ultimately the on ground collision with a residence. Contributing factors were the pilot's…NTSB NYC02LA132Accident · No injuriesLimited investigationFinal reportBeech C23 · Newburyport, MAA power loss for undetermined reason(s), which resulted in a subsequent forced landing to unsuitable terrain. A factor was the unsuitable terrain.NTSB NYC02FA131Accident · 1 fatalField investigationFinal reportDiamond Aircraft Industries DA 20C-1 · Leesburg, VAA loss of engine power for undetermined reasons.NTSB MIA02LA129Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F21B · Somerville, TNThe pilot's improper landing flare resulting in a hard landing and damage to the airplane.NTSB LAX02LA216Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Sacramento, CAPropeller blade failure due to fatigue. A contributing factor was the rising embankment.NTSB LAX02LA215Accident · 1 fatalLimited investigationFinal reportRolladen-Schneider LS8-18 · Incline Village, NVthe pilot's inadequate in-flight planning and failure to maintain an adequate clearance from terrain.NTSB FTW02LA202Accident · Minor injuriesLimited investigationFinal reportJackie SNS-7-Hiperbipe 3 · Lancaster, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's failure to maintain directional control during takeoff roll.NTSB DEN02LA071Accident · No injuriesLimited investigationFinal reportCessna T206H · Jackson, WYthe engine failure for undetermined reasons and the pilot's failure to maintain aircraft control during the forced landing attempt. A factor contributing to the accident was the inadvertent stall.NTSB DCA02RA049Accident · No injuriesForeign investigationAirbus Industrie A320-212 · Paris, FranceNTSB CHI02LA181Accident · No injuriesLimited investigationFinal reportBell 206B · Three Rivers, MIA loss of tail rotor effectiveness.NTSB SEA02LA122Accident · No injuriesLimited investigationFinal reportHead Balloons AX8-88 · Victor, IDThe pilot's failure to maintain altitude/clearance from the power lines during the landing resulting in the balloon's impacting the wires. Contributing factors were the power lines and strong winds existent at the time.NTSB NYC02LA137Accident · No injuriesLimited investigationFinal reportCessna 177 · Millville, NJThe pilot's improper bounced landing recovery. A factor was the dark night conditions.NTSB LAX02LA220Accident · No injuriesLimited investigationFinal reportBushby Mustang M-11 · Pahrump, NVthe failure and separation of a propeller blade for undetermined reasons.NTSB IAD02LA071Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Unionville, PAThe pilot's evasive maneuver to avoid a collision with a departing airplane, which resulted in a landing short of the runway. A factor was the pilot's decision to land on the runway opposite the one in use.NTSB IAD02LA068Accident · No injuriesLimited investigationFinal reportCessna 150 · Griswold, CTthe pilot's improper pre-flight planning and decision to depart a field with insufficient runway. Factors were the rough/uneven terrain, high obstructions and the tailwind.NTSB SEA02LA121Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Shelley, IDA loss of engine power due to the manufacturer's improperly machined threads, which prevented the cylinder base/head halves from being properly assembled, leading to fatigue propagation and the ultimate separation of the cylinder. A contributing factor was…NTSB SEA02LA120Accident · No injuriesLimited investigationFinal reportWelborn Pulsar XP · Prineville, ORThe disconnection of the throttle cable on landing resulting in the aircraft's engine going to full throttle and the pilot's subsequent failure to maintain directional control after securing the engine during the landing event.NTSB SEA02FA119Accident · 2 fatalField investigationFinal reportCessna 335 · Tensed, IDAircraft control was not maintained during an emergency landing. A loss of power for undetermined reasons was a factor.NTSB NYC02LA130Accident · Serious injuriesLimited investigationFinal reportWheeler Volksplane VP-2 · Collins, NYThe separation of an ignition lead to the distributor cap, which resulted in a total loss of engine power. Factors in the accident were trees and power lines.NTSB MIA02LA128Accident · No injuriesLimited investigationFinal reportCessna 340A · Bunnell, FLAn improper maintenance inspection of the landing gear system by other maintenance personnel that resulted in a worn/loose over center spring for the right main landing gear being kept in service which caused the right main landing gear not to go over center…NTSB MIA02LA121Accident · Minor injuriesLimited investigationFinal reportKenneth Parmerter Loehle 5151 Mustang · Lake Placid, FLThe pilot's failure to maintain airspeed and his inflight loss of control while maneuvering to land following an engine failure. Contributing to the accident was the builder/owner's improper engine installation that resulted in engine overheating and ceasing…NTSB LAX02FA214Accident · 4 fatalField investigationFinal reportCessna 310I · San Dimas, CAthe pilot's failure to maintain control of the airplane following a loss of power in one engine during takeoff. The reason for the loss of power in the left engine could not be determined. Contributing factors to the accident were the pilot's failure to…NTSB IAD02LA070Accident · No injuriesLimited investigationFinal reportMooney M20J · Ocean City, NJThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind. A factor was a wind gust.NTSB IAD02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Fulton, NYThe pilot's improper flare, which resulted in a misaligned, hard landing.