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 MIA02LA153Accident · 2 fatalLimited investigationFinal reportReviere Vans RV6A · Tampa, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, while maneuvering, and subsequent impact with a concrete wall. A factor in this accident was the impairment of the pilot in command due to the use of prescription…NTSB CHI02LA258Accident · No injuriesLimited investigationFinal reportBeech A36 · Benton, KSFuel starvation due to the pilot's improper fuel management, the pilot's improper remedial actions during engine restart, and the unsuitable terrain encountered during the forced landing. Additional factors included the inadequate flare and the dark night.NTSB CHI02LA254Accident · No injuriesLimited investigationFinal reportGrumman C-1A · Roseville, ILThe failure and the resulting separation of the engine cylinder, which severed both electrical propeller control systems on the affected engine. A factor to the accident was the cornfield.NTSB ANC02LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Sparrevohn, AKThe pilot's inadequate evaluation of wind conditions while landing, which resulted in a downwind landing and an encounter with rough terrain when the airplane overran the intended landing area. Factors associated with the accident were a tailwind, and rough…NTSB SEA02LA170Accident · No injuriesLimited investigationFinal reportHiperLight SNS-8 · Auburn, WAThe pilot's failure to maintain directional control during takeoff roll resulting in a ground loop. A contributing factor was crosswind conditions.NTSB SEA02LA159Accident · Serious injuriesLimited investigationFinal reportBeech C-35 · Nampa, IDThe pilot's failure to maintain aircraft control following an inadvertent opening of the airplane's storm window.NTSB NYC02LA169Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Guilford, CTFatigue cracking of the number 3 cylinder head. A factor was the presence of protruding material on the cylinder barrel.NTSB LAX02LA254Accident · Minor injuriesLimited investigationFinal reportWaco YPF-7 · Dewey, AZThe loss of engine power due to a flooded carburetor. A contributing factor was the lack of suitable terrain for the forced landing.NTSB IAD02LA087Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman E75L300 · Fostoria, OHA missing flight control sealed bearing, which resulted in a loss of control in flight.NTSB IAD02FA086Accident · 2 fatalField investigationFinal reportCessna 172S · Plainville, CTAn in-flight engine compartment fire of unknown origin, and a loss of engine power for undetermined reasons. Also causal, was the pilot's failure to maintain airspeed during a turn back to the airfield, which resulted in an inadvertent stall and subsequent…NTSB CHI02CA253Accident · No injuriesData collectionFinal reportBellanca BL-17-30A · Ohiawa, NEThe pilot failed to verify the aircraft refueling and he did not follow emergency procedures for engine restart. Factors to the accident included fuel starvation and the fence post.NTSB ATL02LA159Accident · Serious injuriesLimited investigationFinal reportSchweizer 300C · Haleyville, ALThe failure of maintenance personnel to perform an adequate inspection of loose intake components, which resulted in a total loss of engine power and subsequent emergency descent, forced landing, and collision with terrain in dark night conditions.NTSB WAS02WA051Accident · 1 fatalForeign investigationHughes 269C · Dannevirke, New ZealandNTSB SEA02LA158Accident · No injuriesLimited investigationFinal reportCessna 120 · Missoula, MTThe pilot's failure to adequately compensate for the wind conditions during the landing roll. Delayed remedial action and a high crosswind condition were factors.NTSB NYC02LA167Accident · No injuriesLimited investigationFinal reportPiper PA32-300 · Chatham, MAThe pilot's improper in-flight decision to continue the landing after losing visual contact with the runway, which resulted in his failure to obtain the proper touchdown point, and the subsequent overrun. Factors in this accident were the clouds and low…NTSB NYC02FA168Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Sanderson, WVPhysiological impairment or incapacitation likely related to the pilot's recent exacerbation of Crohn's disease. A factor in the accident was the pilot's decision to conduct the flight in his current medical condition.NTSB LAX02LA258Accident · No injuriesLimited investigationFinal reportCessna 185A · Fillmore, CAthe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in the in-flight collision with terrain during a climb.NTSB LAX02LA253Accident · Minor injuriesLimited investigationFinal reportReed Avid Commuter · Goffs, CAThe engine loss of power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN02LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Boulder, COthe pilot's inadequate preflight preparation, which resulted in fuel exhaustion and a subsequent loss of engine power, and his failure to maintain adequate airspeed during the forced landing, which resulted in an inadvertent stall/mush. Factors included the…NTSB DEN02GA097Accident · 1 fatalFinal reportArctic S-1B2 · Meeteetse, WYthe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. A contributing factor was the intentional low pass/slow flight maneuver.NTSB MIA02FA152Accident · 1 fatalField investigationFinal reportCessna 150J · Brunswick, GAthe pilot's failure to maintain an adequate airspeed during takeoff, which resulted in an inadvertent stall. A contributing factor was the pilot's decision to takeoff in an over gross weight condition.NTSB FTW02LA237Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Hobbs, NMthe pilot's inadvertent flight into adverse weather conditions which resulted in the loss of thermal lift. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI02LA252Accident · Minor injuriesLimited investigationFinal reportLancair 320 · Iola, KSthe engine failure for undetermined reasons and the lack of a suitable landing area to execute a forced landing.NTSB ANC02LA101Accident · No injuriesLimited investigationFinal reportHelio H-295 · Igiugig, AKThe pilot's inadequate evaluation of the wind/weather conditions resulting in a collision with an embankment during the takeoff run. A factor contributing to the accident was a sudden wind shift to a tailwind.NTSB ANC02LA096Accident · No injuriesLimited investigationFinal reportCessna 170 · Soldotna, AKThe pilot's inadequate recovery from a bounced landing, and his failure to maintain directional control of the airplane. A factor contributing to the accident was the pilot's excessive braking which resulted in a nose over.NTSB SEA02LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Darrington, WALoss of engine power during takeoff due to an undersized gascolator gasket resulting in a loss of fuel flow to the engine. A ditch was a factor.NTSB SEA02LA153Accident · Serious injuriesLimited investigationFinal reportMooney M20L · Newberg, ORThe pilot's inadequate flare and his delay in executing an aborted landing. A contributing factor was the dark night conditions.NTSB NYC02WA164Accident · 3 fatalForeign investigationPiper PA-44-180 · Lake Vossemeer, NetherlandsNTSB NYC02LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Sangerville, METhe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall.NTSB DEN02TA092Accident · Minor injuriesFinal reportAir Tractor AT-802A · Broomfield, COthe airplane's left main landing gear tire separated from its wheel during takeoff roll for an undetermined reason. Contributing factors were the pilot's inability to maintain aircraft control during takeoff roll and the subsequent impact with the Visual…NTSB CHI02FA247Accident · 1 fatalField investigationFinal reportCessna 172N · Shell Lake, WIThe pilot's failure to refuel the airplane prior to departure leading to fuel exhaustion during the flight, the inadequate preflight/inflight planning, and the unsuitable terrain encountered by the pilot during the forced landing attempt. Contributing factors…NTSB CHI02CA248Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Ray, NDThe pilot inadvertently stalled the airplane during takeoff. A factor was the tailwind.NTSB ANC02LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Red Devil, AKA partial loss of engine power for an undetermined reason during the initial climb after takeoff that resulted in a collision with trees. A contributing factor in the accident was rising terrain which was unsuitable for a forced landing.NTSB ANC02FA097Accident · 2 fatalField investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's failure to maintain adequate airspeed while on approach to land, which resulted in an inadvertent stall, and subsequent collision with trees.NTSB NYC02LA163Accident · No injuriesLimited investigationFinal reportNiemann Champion II · Foxboro, MAThe pilot's failure to maintain aircraft control during the landing flare.NTSB MIA02LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · La Belle, FLThe student pilot's improper in-flight planning and failure to use carburetor heat while conditions existed that were conductive to carburetor icing.NTSB LAX02LA252Accident · No injuriesLimited investigationFinal reportCessna S550 · Big Bear City, CAThe pilot's failure to obtain the proper touchdown point which resulted in an overrun. Contributing factors were the pilot's improper in-flight planning, improper use of performance data, the tailwind condition, failure to perform a go-around, and the…NTSB DEN02LA091Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Watkins, COthe pilot's improper recovery from a bounced landing, resulting in an inadvertent ground loop. A contributing factor was the flight instructor's inadequate supervision of the pilot.NTSB SEA02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bellingham, WAThe pilot's improper decision to continue en route in cruise flight when his fuel supply became low, eventually leading to fuel exhaustion while on final approach to the destination airport. Factors include the fact that the final approach course took the…NTSB NYC02LA161Accident · No injuriesLimited investigationFinal reportCessna 172RG · Rochester, NYThe pilot's improper flare and recovery from a bounced landing. A factor in the accident was the slow response time of the airspeed indicator.NTSB FTW02WA241Accident · Serious injuriesForeign investigationCessna 172N · Tinaquillo, VenezuelaNTSB FTW02FA233Accident · 1 fatalField investigationFinal reportCessna 152 · Ithaca, NEThe pilot's intentional flight of the airplane into terrain in an act of suicide.NTSB CHI02LA244Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Hillman, MIThe pilot's failure to maintain terrain clearance.NTSB SEA02LA152Accident · No injuriesLimited investigationFinal reportBeech B35 · Halfway, ORThe pilot's delay in initiating an aborted takeoff and his failure to establish climb out of ground effect. Contributing factors were the high aircraft weight and high density altitude as well as the fence and berm, which the aircraft struck.NTSB SEA02LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Shearer, IDThe pilot's failure to maintain the proper approach speed while on final approach to the 2000 foot airstrip, and his excessive application of brakes while attempting to stop the aircraft during the resultant longer than normal landing roll. Factors include a…NTSB NYC02LA172Accident · No injuriesLimited investigationFinal reportCessna 500 · Sandusky, OHA collision with a deer during a night takeoff.NTSB NYC02FA160Accident · Serious injuriesField investigationFinal reportBoeing 747-256 · Jamaica, NYAn accessory gearbox fire of the number 2 engine, due to hot air bypassing a damaged compressor air seal stack, which resulted in an emergency evacuation.NTSB MIA02FA148Accident · 3 fatalField investigationFinal reportBeech C23 · Centerville, TNthe pilot's failure to maintain airspeed which resulted in an inadvertent stall shortly after takeoff. A contributing factor was the pilot's decision to takeoff in an over gross weight condition and his lack of familiarity with the aircraft.NTSB LAX02FA251Accident · 4 fatalField investigationFinal reportAero Commander 690A · Bishop, CAThe pilot's failure to maintain an appropriate terrain clearance altitude while maneuvering in the traffic pattern due to the sensory and visual illusions created by a lack of ground reference lights and/or terrain conspicuity, and the dark nighttime…NTSB IAD02LA084Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · West Milford, NJThe private pilot's excessive rotation and the flight instructor's delayed remedial action.