NTSB investigations, 1998
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1998 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") = 1998 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 FTW98TA328Accident · Minor injuriesFinal reportBell 206L-3 · Reklaw, TXThe pilot's failure to maintain proper alignment in that the external load was not centered during sling operation, which resulted in entanglement of the load with the landing gear, and the loss of aircraft control.NTSB FTW98LA318Accident · No injuriesLimited investigationFinal reportCessna 172H · Commerce, TXThe pilot's inadequate compensation for the crosswind resulting in a loss of control. A factor was the crosswind.NTSB CHI98LA284Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Salina, KSthe pilot failed to flare the airplane properly and the airplane landed hard.NTSB CHI98LA277Accident · Serious injuriesLimited investigationFinal reportMarchetti Avenger Gryo Plane · Mentone, INthe pilot's lack of familiarity with the gyroplane's performance, and his improper in-flight decision to reduce engine power to idle which aggravated the gyroplane's nose down pitch and exceeded the gyroplane's back stick authority.NTSB CHI98LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · New Lenox, ILLoss of engine power for undetermined reasons.NTSB NYC98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nantucket, MAThe student pilot's failure to perform a go-around. A factor in the accident was the tailwind.NTSB MIA98LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Carthage, NCThe failure of the pilot to maintain directional control of the airport resulting in the collapse of the nose and left main landing gears.NTSB MIA98FA205Accident · 2 fatalField investigationFinal reportCessna 310Q · Port Orange, FLThe pilot's inadequate weather evaluation and his continued visual flight into instrument meteorological conditions which resulted in in-flight collision with trees. A related factor was the fog.NTSB LAX98LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Baker, CAA loss of engine power for undetermined reasons.NTSB IAD98LA083Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Newburg, METhe pilot's failure to maintain directional control. Related factors were the long, wet, unmowed grass runway.NTSB CHI98LA273Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Clearwater, MNThe inadequate visual lookout by the pilot-in-command. The unmarked transmission wire was a contributing factor.NTSB CHI98LA272Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Falls City, NEthe main landing gear leg fracturing and separating from the portion mounted to the fuselage for undetermined reasons.NTSB CHI98LA270Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Sheboygan, WIThe pilot's inadequate fuel management which led to fuel exhaustion.NTSB ANC98LA111Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Tyonek, AKThe pilot's failure to maintain directional control while landing. A factor associated with the accident were willow trees near the airstrip.NTSB ANC98LA108Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe pilot's delay in aborting the takeoff prior to reaching the end of the lake. A factor associated with the accident was a downdraft.NTSB ANC98LA107Accident · Minor injuriesLimited investigationFinal reportCessna 206G · Yakutat, AKThe pilot's inadequate compensation for wind conditions, and a premature lift-off. A factor associated with the accident is a sudden windshift.NTSB ANC98LA106Accident · No injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe pilot's failure to maintain directional control.NTSB SEA98LA169Accident · No injuriesLimited investigationFinal reportWiles S1-C · Yelm, WAFuel exhaustion due to overflying an intermediate fuel stop. Factors include high grass in the forced landing area.NTSB NYC98WA155Accident · No injuriesForeign investigationPiper PA-46-350P · Cregneash, United KingdomNTSB MIA98LA204Accident · No injuriesLimited investigationFinal reportCessna 182P · Concord, NCthe failure of the pilot to maintain directional control and his failure to maintain wingtip clearance with trees that border the right side of the runway.NTSB LAX98LA240Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Tracy, CAThe failure of the pilot to maintain an adequate clearance with the telephone wires.NTSB FTW98LA327Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Englewood, COAn encounter with unanticipated windshear or a downdraft.NTSB CHI98LA269Accident · Serious injuriesLimited investigationFinal reportBoeing 767-223 · Peotone, ILIn-flight encounter with turbulence.NTSB LAX98LA238Accident · No injuriesLimited investigationFinal reportAyres S2R · Shafter, CAThe pilot's failure to maintain an adequate clearance from the irrigation standpipe due to glare from the rising sun.NTSB FTW98LA321Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Bridgeport, TXThe flight instructor's delay in recognizing and responding to the loss of right engine power which resulted in the airplane landing short of the runway. A factor was the loss of right engine power for undetermined reasons.NTSB CHI98LA267Accident · No injuriesLimited investigationFinal reportCessna 150M · Litchfield, ILLoss of engine power due to an open exhaust valve and low cylinder compression. A related factor was the tailwind.NTSB CHI98LA265Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Ironwood, MIthe pilot's not compensating for wind conditions and his allowing an inadvertent stall. A factor was wind gusts.NTSB CHI98LA264Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Hoxie, KSthe total failure of the engine's left magneto.NTSB ANC98LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Fairbanks, AKThe pilot's failure to attain the proper touchdown point. A factor associated with this accident was the high brush at the approach end of the landing area.NTSB SEA98LA145Accident · 1 fatalLimited investigationFinal reportBaggarley Glasair II-FT · Vernonia, ORA loss of aircraft control for undetermined reasons.NTSB NYC98LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Philippi, WVWas the failure of an exhaust valve. A factor in the accident was the unsuitable landing area encountered by the pilot.NTSB NYC98LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Whitefield, NHThe instructor pilot's failure to maintain control of the aircraft during landing roll. Contributing factors were the instructor pilot's improper in-flight decision, tailwind and gusty conditions, and wet (standing water) runway conditions.NTSB IAD98LA082Accident · Minor injuriesLimited investigationFinal reportMiehl Team HI-MAX-1700R · Jamestown, NYthe pilot's failure to obtain proper airspeed and his subsequent loss of directional control.NTSB FTW98LA324Accident · No injuriesLimited investigationFinal reportCessna A188B · Erie, COThe pilot's failure to maintain directional control of the airplane. A factor was a crosswind gust.NTSB FTW98LA322Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Fairview, OKLoss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98FA316Accident · 1 fatalField investigationFinal reportNord Stampe SV4C · Ovilla, TXthe pilot's failure to maintain control of the aircraft while performing aerobatic maneuvers.NTSB DCA98WA069Incident · No injuriesForeign investigationBoeing 747 · Amsterdam, NetherlandsNTSB CHI98LA266Accident · No injuriesLimited investigationFinal reportCessna R182 · Bismarck, NDThe fatigue failure of the fuel system line fitting.NTSB SEA98LA144Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe student pilot's failure to maintain directional control of the aircraft. Related factors were the student pilot's lack of total experience, and airport signs in the accident area.NTSB NYC98LA147Accident · No injuriesLimited investigationFinal reportCessna 140 · Gansevoort, NYThe pilot's decision to continue the landing attempt too far down the runway.NTSB NYC98LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Rockland, METhe pilot's failure to attain adequate airspeed during the takeoff, which resulted in a stall.NTSB LAX98LA239Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of the pilot to maintain directional control of the aircraft during takeoff.NTSB LAX98LA237Accident · 1 fatalLimited investigationFinal reportDe Malignon Varieze · Globe, AZfuel starvation due to the pilot's failure to properly plan his flight with regard to his estimated flight time, planned descent(s), and the amount of usable fuel available and required in the fuselage tank. The pilot/builder's deviation from the aircraft…NTSB IAD98LA093Accident · No injuriesLimited investigationFinal reportCessna 182 · Edgartown, MAwas the pilot's improper flare prior to touchdown.NTSB IAD98LA080Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Somesville, METhe pilot's inadequate planning and decision, which fail to consider the effect of takeoff in the direction of the sunlight, which resulted in the pilot encountering sunglare and the loss of aircraft control.NTSB FTW98LA320Accident · Minor injuriesLimited investigationFinal reportNavion G · Telluride, COPilot operating the aircraft with an overly lean mixture. A factor was unsuitable terrain for a forced landing.NTSB FTW98FA319Accident · Minor injuriesField investigationFinal reportCessna T-310P · Colorado Sprngs, COThe separation of a portion of the right engine exhaust stack, and the ensuing fuel fire in the right engine nacelle.NTSB DCA98WA067Accident · No injuriesForeign investigationLockheed L-1011 · Kos, GreeceNTSB ANC98LA103Accident · No injuriesLimited investigationFinal reportCessna 206 · Palmer, AKThe pilot's inadequate compensation for wind conditions, and inadequate clearance from mountainous terrain. Factors were the downslope winds and downdrafts.NTSB SEA98LA143Accident · Minor injuriesLimited investigationFinal reportMcCarty Avid Magnum · Kalispell, MTThe pilot's inadequate compensation for the wind conditions. A factor was gusty wind conditions.