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 LAX02FA088Accident · No injuriesField investigationFinal reportRobinson R22 Beta · Glendora, CAThe student's failure to maintain adequate main rotor rpm, and the flight instructor's inadequate supervision. Contributing factors were the high helicopter gross weight and density altitude, and the descending mountainous terrain.NTSB FTW02LA083Accident · No injuriesLimited investigationFinal reportNorth American T28C · Fredericksburg, TXthe failure of the pilot to refuel the airplane resulting in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI02LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot not maintaining clearance from a parked van while taxiing to the parking area. The van was a factor.NTSB ATL02LA050Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Blowing Rock, NCThe pilot's in-flight decision to continue flight into an area with high winds that resulted in an in-flight encounter with a downdraft and subsequent loss of control of the airplane and collision with terrain.NTSB SEA02LA042Accident · No injuriesLimited investigationFinal reportCessna 172 · Concrete, WAThe pilot's failure to maintain adequate clearance/altitude while reversing course and turning towards rising, tree covered terrain in downdraft conditions. Contributing factors were trees, rising terrain, downdrafts and the pilot's in-flight decision to turn…NTSB NYC02LA065Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · Beaumont, TXAn inadvertent encounter with convective induced turbulence, which injured a flight attendant. Factors were the failure of the airline to supply direction to the flight crew to indicate when the flight attendants could begin cabin service, and the convective…NTSB FTW02LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Mount Selman, TXthe loss of engine power for an undetermined reason, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB DEN02LA027Accident · No injuriesLimited investigationFinal reportKnight BD-4 · Kemmerer, WYThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a snowbank. A contributing factor was the high crosswind.NTSB NYC02LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Argyle, NYThe pilot's improper in-flight decision to land on a contaminated runway. A factor was the contaminated runway.NTSB IAD02LA033Accident · No injuriesLimited investigationFinal reportHughes 269C · Lorain, OHThe pilot's failure to maintain directional control during takeoff.NTSB FTW02LA081Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Pond Creek, OKThe pilot's failure to maintain altitude due to falling asleep while performing pipeline patrol activities.NTSB ENG02WA013Incident · No injuriesForeign investigationBell 206L3 · Miri, Sarawak, MalaysiaNTSB DEN02LA026Accident · No injuriesLimited investigationFinal reportBeech B36TC · Englewood, COThe pilot flaring the airplane prematurely, which resulted in a hard landing.NTSB CHI02WA080Accident · 3 fatalForeign investigationCessna 421B · Libourne, FranceNTSB CHI02LA081Accident · No injuriesLimited investigationFinal reportCessna 172F · Lynxville, WIThe pilots delayed use of carburetor heat during carburetor icing conditions, and the unsuitable terrain encountered for the forced landing. The carburetor icing conditions, the powerline, the brush, and the nose gear collapse were contributing factors.NTSB CHI02LA079Accident · No injuriesLimited investigationFinal reportCessna 172H · Hackensack, MNThe pilot's inadequate compensation for the winds conditions which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the gusty crosswind conditions and the trees alongside the runway which the…NTSB CHI02LA078Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dowagiac, MIThe pilot's inadequate compensation for the wind conditions that resulted in directional control not being maintained during the landing roll. Factors to the accident were the pilot's inadequate in-flight decision to attempt the landing with a gusting 20 knot…NTSB NYC02LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Newbolds Corner, NJImproper maintenance which resulted in a loss of fuel and subsequent loss of engine power due to fuel exhaustion. Factors were the pilot's failure to monitor the fuel quantity gauges, and the gusty wind conditions.NTSB NYC02LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fredericksburg, VAThe private pilot's failure to verify the fuel tank selector position, which resulted in fuel starvation and a subsequent forced landing.NTSB NYC02FA060Accident · 1 fatalField investigationFinal reportRockwell 500S · Exeter, RIThe pilot's failure to maintain control after encountering icing conditions while on approach for landing. Factors in this accident were the night light conditions and pilot's failure to select the airplane's propeller de-icing switches to the "on" position.NTSB DEN02LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COthe pilot's failure to maintain directional control during the landing roll. Contributing factors were the crosswind and the pilot's fatigue from lack of sleep.NTSB DCA02WA023Accident · No injuriesForeign investigationBoeing 737-236 · San Juan, ArgentinaNTSB MIA02WA063Accident · No injuriesForeign investigationGrumman G-73T · Paradise Island, BahamasNTSB MIA02LA061Accident · Serious injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Belle Glade, FLthe pilot continued flight into known adverse weather resulting in a loss of control and subsequent impact with the ground.NTSB LAX02LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Beatty, NVThe pilot failed to maintain control of the airplane.NTSB IAD02LA032Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Harwinton, CTpilot's failure to obtain adequate airspeed during take-off, which resulted in an aerodynamic stall.NTSB ATL02FA048Accident · 2 fatalField investigationFinal reportBell 206L-1 · New Smyrna Bch., FLThe pilot continued visual flight into instrument conditions that resulted in the in-flight collision with trees. Factor were the pilot's alcohol impaired condition, and low cloud conditions.NTSB SEA02LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Pacific City, ORThe pilot's inadequate compensation for local wind conditions during the landing roll. Factors include unfavorable winds, and a swampy area adjacent to the runway.NTSB MIA02LA060Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-V · West Palm Beach, FLThe flight crew's failure to follow preflight inspection/checklist procedures, which resulted in their failure to detect wooden sticks in the landing gear weight-on-wheel switches and their failure in flight to respond to crew alert messages to disarm the…NTSB IAD02WA031Accident · 2 fatalForeign investigationBeech 300LW Super King Air · Zernez, SwitzerlandNTSB IAD02LA030Accident · Minor injuriesLimited investigationFinal reportKorsch Classic IV · East Moriches, NYThe pilot's improper recovery from a bounced landing, which resulted in a loss of directional control. A contributing factor was the pilot's lack of experience in aircraft type.NTSB ANC02LA015Accident · No injuriesLimited investigationFinal reportBoeing 727-100 · Kotzebue, AKThe pilot's decision to continue an unstabalized approach to landing. A factor associated with the accident is the pilot's failure to attain proper alignment with the runway.NTSB WAS02RA021Accident · 2 fatalForeign investigationCessna U206 · Cackchila, GuatemalaNTSB MIA02WA062Accident · Serious injuriesForeign investigationCessna TR182 · Porvenir, PanamaNTSB LAX02LA085Accident · 2 fatalLimited investigationFinal reportEllenberger/Werner Glasair I TD · Minden, NVthe pilot's failure to maintain control of the airplane resulting in the airplane entering a flat spin from which the pilot did not recover.NTSB LAX02LA084Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot of the landing airplane failed to maintain directional control resulting in the on-ground collission.NTSB WAS02WA019Accident · Minor injuriesForeign investigationCessna 182 · Santa Elena, VenezuelaNTSB SEA02LA040Accident · 1 fatalLimited investigationFinal reportPiper PA-24-180 · Scappoose, ORThe pilot's failure to tie down the aircraft prior to hand propping the engine. Factors were a fence, trees, and the pilot's inadequate preflight planning/preparation.NTSB ATL02LA047Accident · No injuriesLimited investigationFinal reportPiper PA -18 · Winter Haven, FLThe pilot's improper flare during an attempted landing on water. A factor was glassy water.NTSB ATL02LA046Accident · Serious injuriesLimited investigationFinal reportAero Commander 500U · Copperhill, TNThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent collision with trees during emergency landing on unsuitable terrainNTSB ATL02LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Panama City Bch, FLThe pilot's failure to use carburetor heat that resulted in the loss of engine power. A factor was weather conditions favorable for the formation of carburetor ice.NTSB NYC02FA059Accident · No injuriesField investigationFinal reportMitsubishi MU-300 · Cleveland, OHThe pilot's failure to obtain the proper touch down point on the runway, and the pilot-in-commands failure to initiate a go-round. Factors in the accident were the tailwind condition, the snow-covered runway.NTSB MIA02WA065Accident · Serious injuriesForeign investigationBoeing 737 · Montevideo, UruguayNTSB MIA02FA059Accident · 4 fatalField investigationFinal reportCessna TR182 · Cedar Key, FLthe failure of the pilot to maintain control of the airplane due to spatial disorientation resulting in the airplane descending and colliding with water. A factor in the accident was a dark night .NTSB FTW02LA085Accident · Minor injuriesLimited investigationFinal reportQuicksilver MXL II Sport · Gatesville, TXThe loss of engine power for undertermined reasons.NTSB FTW02LA080Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Encino, TXThe pilot's failure to maintain aircraft control during lift off from a transport trailer resulting in dynamic rollover of the helicopter.NTSB DEN02LA024Accident · No injuriesLimited investigationFinal reportAviat A-1A · Afton, WYThe pilot's failure to maintain directional control, which resulted in a collision with a snow bank. Contributing factors were the icy runway and the snow bank.NTSB ATL02LA044Accident · Minor injuriesLimited investigationFinal reportHiller UH12E · Miami, FLFatigue cracking in the main rotor hub that resulted in the separation of the main rotor system. A factor was corrosive deposits on the exposed portion of the plate set pin.NTSB SEA02LA039Accident · 1 fatalLimited investigationFinal reportBitton/Sport Flight Talon · Boring, ORLoss of control for undetermined reasons.NTSB SEA02LA038Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Creswell, ORThe pilot's failure to maintain directional control on landing resulting in the aircraft leaving the runway environment, crossing a ditch and nosing over. Contributing factors were variable winds reported by the pilot and the ditch.