NTSB investigations, 1998
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\") = 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 IAD99FA004Accident · 1 fatalField investigationFinal reportCessna 305A · Warren, VTThe glider pilot's failure to perform the emergency tow release and abort the takeoff. A factor in the accident was the glider pilot's improper decision to make repeated attempts to close the canopy in flight.NTSB FTW99FA001Accident · 1 fatalField investigationFinal reportBell 407 · Vermilion 331the failure of both pilots to see and avoid each other's aircraft during cruise flight. Factors were the failure of both pilots to use a known safety advisory recommendation and the failure of both operators to implement the recommendation as a company…NTSB DEN99LA023Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Albuquerque, NMThe passenger not following high wind landing procedures/directives which were given to her by the pilot. A factor was the unforecasted high wind condition.NTSB DEN99FA004Accident · 1 fatalField investigationFinal reportCameron A-250 · Albuquerque, NMThe pilot not planning his approach to a landing so as to fly over the transmission wires (on the approach edge of the landing field) in level flight or ascending flight, and the pilot not pulling out the rip panel for emanate contact with transmission wires…NTSB DCA99RA001Accident · No injuriesForeign investigationBoeing 747SP · Mopzambique, MozambiqueNTSB CHI99LA009Accident · No injuriesLimited investigationFinal reportCessna 150F · Muskegon, MIpoor in-flight planning by an unqualified person which resulted in fuel exhaustion. A factor was the swamp in which the forced landing was made.NTSB CHI99LA001Accident · 2 fatalLimited investigationFinal reportPiper PA-28-140 · Bad Axe, MIThe pilot's failure to maintain adequate altitude/clearance from the wires.NTSB MIA99LA004Accident · No injuriesLimited investigationFinal reportMooney M20J · Orlando, FLThe failure of the pilot to maintain clearance while taxiing from landing resulting in the on-ground collision with the parked airplane. A factor in the accident was the intentional operation of the airplane by the pilot with known deficiencies in equipment…NTSB LAX99LA004Accident · 1 fatalLimited investigationFinal reportBurson Revolution Mini 500 · Moorpark, CAThe improper use of the cyclic flight control by the pilot, which resulted in low g flight load condition, which resulted in rotor disk divergence (mast bumping), and the main rotor blade striking and severing the tail boom.NTSB LAX99FA003Accident · Minor injuriesField investigationFinal reportBell 222 · Las Vegas, NVThe pilot's failure to ensure that both throttles were in the takeoff position. Factors were the pilot's decision to takeoff with a tailwind, and his lack of recurrent emergency procedure training in this helicopter.NTSB IAD99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Teteboro, NJthe collapse of the landing gear due to a bent gear locking mechanism for undetermined reasons.NTSB DEN99LA003Accident · Serious injuriesLimited investigationFinal reportCameron N-120 · Albuquerque, NMThe balloon's encounter with unforecasted wind shear and the subsequent inadvertent collision with terrain. A factor was the pilot's inability to control the balloon's descent.NTSB CHI99LA002Accident · No injuriesLimited investigationFinal reportCessna C-336 · Sheboygan, WIThe pilot's improper flare and improper recovery from a bounced landing.NTSB ATL99WA004Accident · Serious injuriesForeign investigationBoeing 767-332 · Sao Paulo, BrazilNTSB ANC99LA005Accident · 1 fatalLimited investigationFinal reportBeech G-35 · Neah Bay, WAUndetermined. Missing Aircraft.NTSB ANC99LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Russian Mission, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are rising terrain, and a downdraft.NTSB NYC99LA002Accident · 1 fatalLimited investigationFinal reportForeit Super CAT · Middlebury, CTThe pilot's failure to utilize his seat belt and shoulder harness.NTSB MIA99LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Punta Gorda, FLThe failure of maintenance personnel to refill the engine oil following the draining of the oil and changing of the oil filter. Also, inadequate preflight of the airplane by the pilot for his failure to noted the absence of engine oil.NTSB IAD99LA002Accident · No injuriesLimited investigationFinal reportNavion A · Jaffrey, NHThe pilot's inadequate aircraft preflight and subsequent failure to refuel the aircraft resulting in fuel exhaustion. A factor was the lack of suitable terrain to execute a forced landing.NTSB FTW99LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Horizon City, TXThe fuel exhaustion due to the pilot's failure to refuel the airplane. Factors were the unfavorable wind condition and the lack of suitable terrain for the forced landing.NTSB DEN99LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Albuquerque, NMThe premature flaring of the airplane, resulting in an inadvertent stall.NTSB DEN99LA002Accident · No injuriesLimited investigationFinal reportBell 206B · Vernal, UTLoss of tail rotor effectiveness. A factor was the quartering tailwind.NTSB NYC99LA013Accident · Serious injuriesLimited investigationFinal reportGoodyear Aerospace GZ-20-A · Bedford, MAThe separation of the pull-in-line. A factor in the accident was the gusting winds.NTSB NYC99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Toughkenamon, PAThe pilot's inadequate preflight inspections which failed to detect an open fuel strainer valve, which resulted in a loss of engine power.NTSB NYC99LA001Accident · No injuriesLimited investigationFinal reportCessna 150M · Wiley Ford, WVWas the failure of the pilot to maintain directional control during an unforecast change in wind velocity. Factors were the gusts and the lack of recent experience for the pilot.NTSB MIA99WA006Accident · No injuriesForeign investigationBoeing 727-200 · Quito, EcuadorNTSB MIA99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Pocahontas, MSThe delay by the pilot-in-command (CFI) to abort the takeoff after the student landed slightly long and his delay to add power to perform a touch-and-go landing.NTSB LAX99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Jose, CAContinued VFR flight by the pilot into instrument meteorological conditions (IMC) at night over mountainous terrain. The pilot's use of unclear language when stating his intentions to air traffic control was a factor.NTSB IAD99LA001Accident · No injuriesLimited investigationFinal reportCessna 172K · Middlefield, OHThe pilot's inadequate preflight inspection which resulted in fuel exhaustion.NTSB FTW99LA003Accident · No injuriesLimited investigationFinal reportBeech M35 · Carter, OKFuel starvation. Factors were; the pilot's self induced pressure to fly the aircraft when maintenance had not been completed, poor judgement by the pilot to commence and continue flight with known deficiencies in the aircraft, and the lack of suitable terrain…NTSB ATL99LA003Accident · No injuriesLimited investigationFinal reportAuxier Herschel A Jr. SEA REY Amphibian · Keystone Height, FLThe pilots failure to attain adequate airspeed, which resulted in a stall, and loss of control.NTSB ATL99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Tellasse, ALThe pilot's failure to maintain clearance from a utility line while conducting a swath run.NTSB MIA99LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Venice, FLThe pilot's improper flare and improper recovery from a bounced landing.NTSB LAX99FA001Accident · 1 fatalField investigationFinal reportAero Commander 680 FPL · Palm Springs, CAThe pilot's failure to properly use the manual turbocharger wastegates and to monitor the manifold pressure during takeoff.NTSB LAX98FA312Accident · 1 fatalField investigationFinal reportCessna 152 · Avalon, CAThe pilot's failure to maintain adequate altitude/clearance. Contributing to the accident were the hilly and mountainous terrain and glare from the setting sun.NTSB FTW99LA062Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Tomball, TXThe pilot's failure to follow the checklist and secure the canopy, which resulted in the canopy separating from the airplane during takeoff initial climb. A factor was the pilot's failure to detect the canopy warning light prior to takeoff.NTSB DEN99LA001Accident · No injuriesLimited investigationFinal reportCessna 140A · Belen, NMThe pilot's failure to maintain aircraft control. Factors were his inadequate compensation for the gusty crosswind conditions, and the airplane manufacturer's failure to provide adequate performance data.NTSB ATL99LA001Accident · No injuriesLimited investigationFinal reportCessna C-172F · Ball Ground, GAThe pilots failure to maintain directional control of the airplane on take-off, during gusty conditions, resulting in a collision with a tree.NTSB SEA98LA192Accident · Minor injuriesLimited investigationFinal reportMayala Dragonfly · Avon, MTFailure of the engine crankshaft aft oil seal resulting in the loss of engine oil, and rough terrain during the forced landing.NTSB SEA98LA191Accident · No injuriesLimited investigationFinal reportCessna 172L · Puyallup, WAThe pilot-in-command's failure to refuel en-route resulting in fuel exhaustion. Contributing factors were a vehicle (in the landing path) and dark night conditions.NTSB MIA98LA255Accident · No injuriesLimited investigationFinal reportCessna A185F · Elizabethton, TNThe failure of the pilot to maintain directional control during the landing roll.NTSB LAX98LA311Accident · Serious injuriesLimited investigationFinal reportRobinson R22B · Salinas, CAThe failure of the student pilot to maintain control of the aircraft while practicing autorotations.NTSB CHI98LA365Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Wheatfield, INthe pilot's failure to apply carburetor heat when the engine lost power. Factors associated with the accident were the carburetor icing conditions which prevailed, the low altitude at which the loss of power occurred, and the soybean crop in which the…NTSB ANC98LA165Accident · Serious injuriesLimited investigationFinal reportMaule ML-7 · Wasilla, AKThe pilot's inadequate compensation for the wind conditions, resulting in an inadvertent stall. Contributing factors were the gusty and turbulent weather conditions.NTSB SEA98LA190Accident · No injuriesLimited investigationFinal reportCessna 150L · Bonners Ferry, IDImproper maintenance by an outsourcing facility which resulted in a lack of identification of scoring of the interior of the #3 cylinder rocker shaft bosses. The scoring resulted in a fatigue fracture and subsequent permanent closure of both intake and…NTSB SEA98LA189Accident · No injuriesLimited investigationFinal reportCessna 172D · Ronan, MTThe pilot's failure to attain adequate airspeed during liftoff from a soft field takeoff. Factors include high density alttiude.NTSB SEA98LA188Accident · No injuriesLimited investigationFinal reportCessna 150L · Freeland, WAFailure of the number two intake valve rocker arm in fatigue, and overload of the nose landing gear assembly. Factors include a ditch encountered during the forced landing.NTSB MIA98WA259Accident · 1 fatalForeign investigationRobinson R22B · Buenos Aires, ArgentinaNTSB MIA98LA254Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Oxford, MSThe pilot's failure to maintain directional control due to vibration from the main rotor blade for undetermined reasons. A related finding was the improper repair of a crack in the laminant of the blue main rotor blade by other maintenance personnel.NTSB FTW98LA417Accident · No injuriesLimited investigationFinal reportCessna 172N · Gallup, NMThe pilot's inadequate landing flare. Factors were his misjudgement of altitude and his excessive airspeed.