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 LAX02LA289Accident · No injuriesLimited investigationFinal reportCessna 152 · El Cajon, CAThe pilot's misjudged landing flare, which resulted in a hard landing.NTSB LAX02FA288Accident · 3 fatalField investigationFinal reportMooney M-20E · Carlsbad, CAfailure of the pilots of both airplanes to maintain an adequate visual lookout and to see and avoid each other. A contributing factor was the failure of the controller to detect and resolve the conflict between the airplanes.NTSB FTW02LA263Accident · No injuriesLimited investigationFinal reportCessna 188A · Vincent, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI02LA285Accident · Minor injuriesLimited investigationFinal reportHughes 369D · O'Neill, NEA loss of engine power due to turbine blade separation as a result of hot corrosion damage to the turbine blades. Contributing to the accident was the pilot misjudging the flare at the completion of the autorotation resulting in a hard landing. The dark night…NTSB ANC02LA122Accident · No injuriesLimited investigationFinal reportCessna 206 · Circle, AKA partial separation of the nose wheel flange from the hub that resulted in a nose over during the landing roll.NTSB NYC02LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Frederick, MDThe student pilot's failure to maintain adequate rotor rpm, and the flight instructor's delayed remedial action. A factor was the manufacturer's inadequate written guidance regarding simulated engine failures during takeoff.NTSB NYC02LA188Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Canadaigua, NYThe pilot's inadequate preflight inspection of the airplane, which resulted in a loss of engine power due to fuel contamination.NTSB MIA02LA169Accident · No injuriesLimited investigationFinal reportCharles Maxted RV6 · Bay Minette, ALThe intentional operation of the airplane with known deficiencies with the right magneto resulting in the partial loss of engine power during the initial climb.NTSB LAX02LA286Accident · No injuriesLimited investigationFinal reportCessna 182A · San Diego, CAthe pilot's failure to maintain adequate clearance to avoid jet exhaust due to his improperly planned approach and inadequate in-flight decision to perform a long landing rollout, which placed the airplane in proximity to an area of observed high velocity jet…NTSB FTW02LA257Accident · No injuriesLimited investigationFinal reportSmith Aerostar 601P · Piedmont, OKA fuel leak at the left boost pump to bladder tank flange, which resulted in fuel exhaustion and the subsequent loss of power to both engines.NTSB CHI02LA286Accident · Serious injuriesLimited investigationFinal reportBailey DSA-1 · Washington, IAThe selection of unsuitable terrain and the failure of the oil pressure gage line. Factors were, the pilot/owners failure to obtain an annual condition inspection, and the corn crop.NTSB CHI02LA280Accident · No injuriesLimited investigationFinal reportCessna 172P · Sturtevant, WIThe proper touchdown point not attained and the approach speed not obtained/maintained by the pilot.NTSB SEA02LA176Accident · No injuriesLimited investigationFinal reportEells Air Command 503 · Prineville, ORThe student pilot's failure to maintain airspeed resulting in a hard landing.NTSB SEA02FA175Accident · 3 fatalField investigationFinal reportCessna TR182 · Twin Falls, IDThe pilot's failure to maintain runway alignment and his failure to execute a timely go-around maneuver resutling in the aircraft's impacting a parked fuel truck well clear of the runway safety area. Contributing factors were the strong crosswind/gusty wind…NTSB NYC02LA192Accident · Minor injuriesLimited investigationFinal reportHughes 369A · Burtonsville, MDThe failure of the tailrotor gearbox for undetermined reasons.NTSB NYC02LA190Accident · No injuriesLimited investigationFinal reportCessna 421 · Ithaca, NYThe pilot's failure to maintain directional control during the landing roll. A factor in the accident was the wet runway.NTSB MIA02LA168Accident · No injuriesLimited investigationFinal reportCessna 310L · Atlanta, GAThe pilot's misjudgment of speed/altitude and her failure to perform a go-around.NTSB DEN02FA105Accident · No injuriesField investigationFinal reportPiper PA-24-260 · Rock Springs, WYthe flight crew of the Beech and the pilot of the Piper's failure to attain proper clearance from the other during their respective landings. Factors contributing to the accident were the crew's and the pilot of the other airplane's inadequate visual lookout…NTSB CHI02LA290Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Chetek, WIThe pilot's failure to maintain directional control of the airplane, and his failure to maintain clearance from the utility pole. A factor was the utility pole.NTSB CHI02LA281Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Effingham, ILThe partial loss of engine power due to the seized exhaust valve. A factor was the soft field.NTSB ANC02LA128Accident · No injuriesLimited investigationFinal reportCessna 207 · Circle, AKThe pilot's inadequate wind evaluation during takeoff resulting in a downwind takeoff and subsequent overrun during an aborted takeoff. Factors in the accident were a tailwind and the pilot's failure to verify the selected flap setting.NTSB ANC02LA121Accident · No injuriesLimited investigationFinal reportGardner Kitfox · Fairbanks, AKA partial loss of engine power due to an engine bearing failure during the takeoff initial climb. A factor in the accident was unsuitable terrain for a forced landing.NTSB LAX02FA285Accident · 2 fatalField investigationFinal reportPiper PA-18A-150 · Tucson, AZthe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude, which resulted in a stall spin.NTSB IAD02LA094Accident · 1 fatalLimited investigationFinal reportGarlick OH-58AT · Rochester, MAThe pilot's failure to center the sling load prior to commencing forward flight. Also causal, was the pilot's improper decision to attempt a takeoff with a quartering tailwind, which resulted in an engine compressor stall.NTSB FTW02LA256Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Altus, OKthe pilot's failure to maintain clearance with electrical wires while maneuvering during an aerial application flight.NTSB DEN02LA108Accident · No injuriesLimited investigationFinal reportStinson L-5E · Spanish Fork, UTthe pilot's inadequate use of rudder and failure to maintain direcctional control following a bounced landing. A contributing factor was the pilot's improper recovery from the bounced landing.NTSB DEN02FA106Accident · 1 fatalField investigationFinal reportBeech B19 · Delta, COthe pilot's failure to properly plan and compensate for the high density altitude conditions, resulting in partial engine power during takeoff, his failure to abort the takeoff, and his failure to maintain aircraft control on initial climb. Contributing…NTSB CHI02FA284Accident · 2 fatalField investigationFinal reportPilatus PC-12/45 · Westphalia, MOThe pilot's spatial disorientation while turning in a cruise climb in instrument meteorological conditions, which resulted in the pilot's loss of aircraft control, and his failure to recover from a resultant tight descending spiral.NTSB SEA02LA174Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Index, WAThe pilot's failure to maintain clearance from terrain while hovering.NTSB MIA02IA167Incident · No injuriesIncident investigationFinal reportBoeing 737-823 · Miami, FLThe failure of the tug driver to maintain wingtip clearance with a parked airplane, and the inability of the tug driver to communicate with the brake rider during a tow operation following failure of the headset cord. Contributing factors in the incident were…NTSB LAX02LA284Accident · No injuriesLimited investigationFinal reportSiemens Rotorway Exec 162 F · Overgaard, AZThe pilot's failure to check the wind direction prior to practicing autorotations, and his misjudged flare maneuver. The tailwind was a factor.NTSB LAX02LA283Accident · 1 fatalLimited investigationFinal reportMinkler Venture M20 · Reno, NVthe overload failure of the horizontal stabilizers and elevators due to a pilot induced oscillation at a speed at or above Vne, which exceeded the design stress limits of the structure. Also causal was the intentional alteration by an unknown person or…NTSB IAD02LA093Accident · No injuriesLimited investigationFinal reportCessna 177 · Dayton, OHThe pilot's failure to maintain adequate airspeed, resulting in a stall.NTSB FTW02LA258Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-302 · Lacompte, LAThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing, and low altitude maneuvering.NTSB NYC02LA193Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28-B2 · Blairstown, NJThe second pilot's improper in-flight decision to perform a release from the towplane, which did not allow for successful completion of the flight. A factor was the downdrafts.NTSB LAX02FA281Accident · Minor injuriesField investigationFinal reportAerospatiale AS350BA · Peach Springs, AZthe pilot's failure to maintain an adequate airspeed and main rotor rpm during the landing approach as prescribed in the hydraulic pump failure emergency procedures found in the rotorcraft flight manual, thus resulting in a loss of control of the aircraft and…NTSB FTW02RA259Accident · 6 fatalForeign investigationCessna U206G · Atalaya, PeruNTSB CHI02LA283Accident · Serious injuriesLimited investigationFinal reportTerning Sky Scout · Sedan, KSThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.NTSB ATL02LA169Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Morton, MSContamination in the exhaust valve guide area which caused the binding of the exhaust valve in the open position.NTSB ANC02LA125Accident · No injuriesLimited investigationFinal reportCessna 180 · Tenakee Springs, AKThe pilot's selection of an unsuitable takeoff area, which resulted in a nose over on takeoff roll. A factor associated with the accident was soft terrain.NTSB ANC02LA119Accident · No injuriesLimited investigationFinal reportCessna 185 · Mc Grath, AKThe pilot's inadequate compensation for wind conditions during takeoff, which resulted in an in-flight collision with trees. A factor associated with the accident was a variable wind condition.NTSB SEA02LA172Accident · No injuriesLimited investigationFinal reportHughes 500 · Carnation, WAThe pilot's delayed power application during a practice power recovery autorotation.NTSB NYC02LA187Accident · No injuriesLimited investigationFinal reportBoeing 757-251 · Baltimore, MDThe captain's failure to follow existing company procedures for stabilized approach, and use of speed brakes.NTSB DCA02WA057Incident · No injuriesForeign investigationDouglas DC-8-63 · Gander, Newfndl, CanadaNTSB CHI02LA278Accident · Minor injuriesLimited investigationFinal reportFrank RV-8A · Brodhead, WIThe failure of the nose landing gear strut for undetermined reasons.NTSB CHI02LA276Accident · No injuriesLimited investigationFinal reportCessna T188C · Olivia, MNThe fouled spark plugs and the terrain condition encountered during the aborted takeoff.NTSB CHI02FA288Accident · 4 fatalField investigationFinal reportBell 206L-1 · Doland, SDPilot spatial disorientation while flying in dark night conditions, resulting in a loss of aircraft control; and the company's inadequate remedial actions after identifying the pilot's night flying deficiency over areas without lighted references. A factor to…NTSB CHI02CA296Accident · No injuriesData collectionFinal reportRobinson R-22 · Maryland Height, MODynamic rollover due to the flight instructor's improper control inputs and the flight instructor's unsuccessful remedial actions. A contributing factor is the passenger's inadvertent movement of the cyclic control.NTSB ATL02LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Mocksville, NCThe pilot's failure to maintain airspeed during the takeoff and initial climb which resulted in an inadvertent stall and the subsequent collision with trees.NTSB SEA02FA171Accident · 1 fatalField investigationFinal reportCessna 175B · Arlington, WAA partial loss of engine power for undetermined reasons during the initial climb, followed by the pilot's failure to maintain airspeed while maneuvering. Impairing drugs found in the pilot's system at the time of the accident were a factor.