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 IAD98LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Salem, NJThe pilot's failure to maintain adequate altitude/clearance from the reeds. A related factor was the wind gusts.NTSB DCA98WA074Incident · No injuriesForeign investigationBoeing 777 · London Heathrow, United KingdomNTSB CHI98LA283Accident · No injuriesLimited investigationFinal reportAero Commander 685 · Middleton, WIThe fuel starvation of the aircraft in addition to the improper aircraft preflight and premature gear extension by the pilot-in-command. The blocked fuel vent system is a contributing factor.NTSB LAX98TA251Accident · No injuriesFinal reportAero Commander 690 · Ely, NVThe failure and separation of the left main gear wheel halves due to overload as a result of excessive air pressure. A contributing factor was the inadequate maintenance/service of the main gear tires.NTSB LAX98LA252Accident · No injuriesLimited investigationFinal reportCessna 182 · California City, CAThe pilot's failure to assure that an adequate supply of fuel was available for the flight and his inadequate preflight planning/preparation.NTSB DCA98WA071Accident · 2 fatalForeign investigationSwearingen · Barcelona, SpainNTSB MIA98LA209Accident · No injuriesLimited investigationFinal reportCessna A-188B · Zolfo Springs, FLTotal loss of engine power due to catastrophic internal engine failure caused by migration of a counterweight retaining.NTSB FTW99LA025Accident · No injuriesLimited investigationFinal reportMooney M20C · Vernon, TXFatigue cracking of the propeller blade which originated from corrosion pitting on its camber side, resulting in the blade tip separation during cruise flight.NTSB FTW98LA353Accident · No injuriesLimited investigationFinal reportde Havilland DH-8-202 · Telluride, COThe inadequate chocks and inadequate chocking procedures by the operator. Factors were the unavailability of the parking brake and sloping terrain.NTSB FTW98LA337Accident · No injuriesLimited investigationFinal reportRockwell S2R · Brownfield, TXThe pilot's failure to maintain control of the aircraft during the landing roll. A factor was the pilot's lack of experience in the aircraft.NTSB FTW98LA336Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Cody, WYThe pilot's failure to maintain visual lookout while taxiing the aircraft.NTSB FTW98LA335Accident · No injuriesLimited investigationFinal reportCessna 172M · Franktown, COFlight at an altitude insufficient to clear terrain. Factors were the pilot's failure to reset or correct a precessing directional gyro, his becoming lost/disoriented, and dark night light conditions.NTSB CHI98LA279Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Muskegon, MIA loss of engine power due to a broken number 4 cylinder connecting rod for undetermined reasons. Contributing to this accident was the road embankment.NTSB CHI98LA278Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Bloomington, INA loss of engine power due to a fractured number 5 and number 6 cylinder connecting rods for undetermined reasons.NTSB ATL98RA099Accident · 2 fatalForeign investigationAyres S2R-T34 · San Jose Del, ColombiaNTSB SEA98LA151Accident · No injuriesLimited investigationFinal reportCurtiss-Wright 12W · Woodland, WAThe pilot in command misjudged clearance from high vegetation when he landed. Factors include inadequate mowing of high vegetation by airport personnel, providing insufficient clearance for the wingspan of landing airplanesNTSB SEA98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Columbus, MTPartial loss of power for undetermined reasons. Factors include the pilot's selection of unsuitable terrain for a precautionary landing.NTSB NYC98WA157Incident · No injuriesForeign investigationFairchild Hiller FH-227B · Keflavik, IcelandNTSB NYC98LA154Accident · No injuriesLimited investigationFinal reportJohnson Revolution MINI-500 · Shermans Dale, PAThe builder/pilot's carburetor modification that did not allow for rapid fuel demand, which resulted in a loss of engine power of final approach.NTSB NYC98LA153Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Jeanette, PAThe pilot's delay in applying the brakes during the landing rollout.NTSB MIA98LA211Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Panama City Bch, FLThe pilot's inadequate inflight planning, which resulted in fuel exhaustion and the loss of engine power.NTSB MIA98LA210Accident · Serious injuriesLimited investigationFinal reportProgressive Aerodyne Searey · Clermont, FLThe pilot's failure to maintain directional control and his failure to maintain obstacle (hangar)clearance.NTSB LAX98LA248Accident · No injuriesLimited investigationFinal reportBeech C23 · Avalon, CAThe failure of the pilot to maintain an adequate airspeed during the landing, which resulted in a stall/mush and hard landing.NTSB LAX98LA245Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Torrance, CAThe failure of the pilot to maintain an adequate airspeed margin during the go-around attempt, which resulted in a stall/mush.NTSB LAX98LA244Accident · Minor injuriesLimited investigationFinal reportBellanca BL-17 · Winnemucca, NVLoss of engine power due to a missing cotter key and jam nut, the use of an improper nonapproved part by other maintenance personnel, and failure to safety the installation which subsequently lead to a throttle/carburetor linkage disconnect.NTSB IAD98LA084Accident · Minor injuriesLimited investigationFinal reportBeech BE24 · Beckley, WVThe pilot's mismanagement of the fuel supply in that the fuel selector was selected to the improper fuel tank, which resulted in fuel starvation and the loss of engine power.NTSB FTW98FA339Accident · 2 fatalField investigationFinal reportBeech H35 · La Veta, COThe pilot's poor judgment by intentionally flying into instrument meteorological conditions without proper certification. Factors were his failure to obtain a weather briefing, and the existing weather conditions that included clouds, rain, and obscuration.NTSB CHI98LA368Accident · 2 fatalLimited investigationFinal reportGrumman American AA-5B · Deadwood, SDThe pilot's failure to maintain adequate clearance from the trees.NTSB CHI98LA281Accident · No injuriesLimited investigationFinal reportLuckey Dragonfly II · Caro, MIan improper inflight decision when he mistook the road for the runway of the nearby airport to land on. A factor in this accident was the total failure of the engine's crankshaft.NTSB CHI98FA274Accident · 1 fatalField investigationFinal reportCessna 172M · Brooklyn, MIThe proper touchdown point was not attained and the visual lookout not being maintained by the pilot-in-command. Contributing factors to the accident were the unmarked static and transmission wires.NTSB ANC98FA110Accident · 2 fatalField investigationFinal reportYakovlev YAK-54 · Anchorage, AKThe pilot's inadequate remedial action to recover from an inverted spin, while performing aerobatics. Contributing factors were the lower than recommended entry altitude for a spin and the pilot's lack of familiarity with the accident airplane.NTSB SEA98LA149Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Ashland, ORThe pilot's improper landing flare, which resulted in a hard landing.NTSB MIA98LA207Accident · No injuriesLimited investigationFinal reportMooney M-20J · Alexander City, ALThe pilot's failure to maintain directional control of the airplane during landing rollout and attempted go-around, resulting in departure from the runway and collision with adjacent brush and trees.NTSB FTW98LA334Accident · Minor injuriesLimited investigationFinal reportCessna 500 · Rawlins, WYThe captain's use of improper airplane performance data, resulting in inadequate takeoff capability. Factors were his decision to abort the takeoff above V1, the separation of the drag chute, a wet runway, a tailwind, and collision with objects that included…NTSB FTW98LA332Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Rock Springs, WYThe pilot's failure to maintain directional control, and an inadvertent ground loop/swerve.NTSB FTW98LA331Accident · No injuriesLimited investigationFinal reportCessna TU206G · Midvale, UTThe pilot's inadequate fuel management which resulted in fuel exhaustion and subsequent loss of engine power.NTSB FTW98LA330Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Lubbock, TXThe pilot's failure to perform an adequate flare, and his improper touchdown technique. Factors were the pilot's improper evaluation of the weather conditions, and the high density altitude and crosswind weather condition.NTSB FTW98LA329Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Rockwall, TXThe pilot's improper use of the fuel tank selector resulting in the loss of engine power due to fuel starvation. A factor was the pilot's failure to follow the check list.NTSB FTW98FA333Accident · 4 fatalField investigationFinal reportCessna 182P · Jal, NMThe pilot's failure to maintain adequate airspeed. Contributing factors were high density altitude and excessive airplane weight.NTSB CHI98LA280Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, MIthe student pilot's delay in performing the abort, and the instructor pilot's failure to take control of the airplane before passing the end of the runway. A factor contributing to this accident was the ditch.NTSB CHI98LA276Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Delavan, WIthe pilot's failure to maintain aircraft control during the takeoff roll. Factors contributing to this accident were the pilot's inadequate preflight, his operation of an airplane with a known deficiency, low air pressure on both main tires, the snow fence,…NTSB CHI98IA275Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Saint Louis, MOthe failure of the flight crew to maintain clearance from the sweeper truck. A factor in the incident was the sweeper truck.NTSB ANC98LA109Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Skwentna, AKA loss of engine power due to a fractured number three cylinder intake manifold flange, and the pilot's inability to maintain the proper rate of descent during the autorotation flare. A contributing factor associated with the accident was the downwind…NTSB SEA98LA147Accident · Minor injuriesLimited investigationFinal reportPilgrim Steen Skybolt · Curtis, WALoss of control for undetermined reasons.NTSB SEA98LA146Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1H · Libby, MTA failure of the external load cable, which became entangled in the tail rotor.NTSB NYC98WA196Accident · 1 fatalForeign investigationCessna 152 · Ice Cap, GreenlandNTSB NYC98LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Newport, NHThe seizure of the throttle shaft, due to the overhaul facilities' failure to insure all metal fragments had been removed from the carburetor before inserting the throttle shaft after reaming the throttle shaft bushings.NTSB MIA98LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLTotal loss of engine power due to a hydraulic valve lifter failure.NTSB LAX98LA243Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Temecula, CAA partial loss of engine power due to a disconnected throttle linkage, which was the result of an inadequate maintenance installation/inspection.NTSB LAX98LA242Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Pleasanton, CAThe flight instructor's delayed remedial action and the student pilot's failure to maintain rotor RPM. A factor was the downhill terrain.