NTSB investigations, 1998
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\") = 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 CHI98LA366Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Point Lookout, MOThe pilot's continued flight with a known deficiency in equipment. Contributing to the accident was the maintenance adjustment that was not completed by the mechanic.NTSB ANC98LA166Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tyonek, AKThe aircraft's left wheel encountering a hole as the pilot taxied from landing and his inadequate compensation for wind conditions. Contributing factors were the rough terrain and gusty wind condition.NTSB ANC98FA168Accident · 1 fatalField investigationFinal reportCessna TU-206G · Ketchikan, AKThe pilot's continued VFR flight into instrument meteorological conditions. Contributing factors were low ceilings and mountainous/hilly terrain.NTSB SEA98LA178Accident · No injuriesLimited investigationFinal reportCessna 414 · Burley, IDA brake system failure for undetermined reasons. An intentional ground loop was a factor.NTSB NYC98WA194Accident · No injuriesForeign investigationCessna 152 · IcelandNTSB NYC98LA193Accident · Serious injuriesLimited investigationFinal reportBoeing DHC-8-102 · Islip, NYClear air turbulence.NTSB MIA98WA258Accident · 7 fatalForeign investigationCessna U206G · Missing, BoliviaNTSB FTW98LA416Accident · No injuriesLimited investigationFinal reportCessna 551 · Pueblo, COThe pilot's delayed flare, improper recovery from a bounced landing, and failure to maintain directional control. A factor was the rough uneven terrain.NTSB DCA98WA089Incident · No injuriesForeign investigationAirbus Industrie A300-600 · Paris, FranceNTSB CHI98LA364Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Marshall, MIthe pilot-in-command (CFI)'s inadequate supervision of the student, his not obtaining control of the airplane, and his lack of total experience in the type of operation. A factor was the dual student's not maintaining control of the airplane.NTSB ANC98LA163Accident · No injuriesLimited investigationFinal reportCessna 170B · Igiugig, AKThe pilot's failure to maintain directional control of the aircraft. Contributing factors were the crosswind condition, the pilot's lack of total experience in make/model of the aircraft, and the pilot not achieving a climb on takeoff.NTSB SEA98LA193Accident · No injuriesLimited investigationFinal reportCessna T-50 · Missoula, MTA quick drain was open due to the pilot's inadequate preflight.NTSB SEA98LA187Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Medford, ORDirectional control was not maintained.NTSB FTW98LA415Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Austin, TXThe collision with deer during the landing roll. Factors were the dark night light condition and the separation of the lower strut assembly from the right main landing gear, on the subsequent flight.NTSB FTW98LA413Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Belen, NMThe pilot inadvertently stalling the airplane.NTSB FTW98LA412Accident · No injuriesLimited investigationFinal reportCessna 152 · Durango, COImproper maintenance by an unknown person and the subsequent throttle cable disconnect due to a castellated nut separation. Factors were the none suitable soft terrain for the forced landing, and the failure of the nose wheel landing gear during the landing…NTSB CHI98LA362Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Iowa City, IAA loss of engine power for undetermined reasons.NTSB ANC98TA162Accident · Serious injuriesFinal reportHughes 369D · Homer, AKThe passenger not following the instructions given by the pilot. Contributing factors were the rising terrain and the pilot's diverted attention during the toe in landing.NTSB SEA98LA195Accident · No injuriesLimited investigationFinal reportEvarts Kitfox IV 1200 · Sula, MTAn excessive brake application by the pilot. Factors included a narrow landing area, the pilot's failure to maintain directional control during a 180-degree taxi turn, and a tailwind.NTSB NYC98LA192Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Watertown, CTWas the pilot's misjudged altitude of the airplane prior to performing a stall, and which resulted in the main landing gear contacting a rock wall.NTSB LAX98LA313Accident · No injuriesLimited investigationFinal reportGrumman HU-16C · Sedona, AZThe pilot in command's selection of the wrong runway for the prevailing wind conditions, and the second pilot's inadequate compensation for the winds. Factors in the accident were the second pilot's lack of experience in the aircraft and the…NTSB LAX98LA309Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H · Gilroy, CAThe pilot's loss of control for undetermined reasons.NTSB LAX98LA308Accident · No injuriesLimited investigationFinal reportRockwell Commander 114 · Atwater, CAAn internal capacitor failure and melting of the point cam followers, which resulted in failure of both magnetos, and subsequent total loss of engine power.NTSB LAX98LA307Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Merced, CAThe pilot's improper flare and his failure to adequately compensate for the existing crosswind conditions and maintain airplane control during landing.NTSB LAX98FA306Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Hawthorne, NVThe pilot's disregard of the weather briefing information and his decision to attempt flight into forecast adverse weather conditions, which led to an encounter with icing conditions beyond the performance capability of the aircraft. The pilot's disregard for…NTSB LAX98FA305Accident · 1 fatalField investigationFinal reportO'Neil VAN'S RV-3 · Arbuckle, CAThe pilot's attempt to continue VFR flight in instrument conditions, which led to his spatial disorientation and in-flight loss of aircraft control, and, resulted in a pilot-induced overload failure of the airframe. The pilot's use of quinine may have been a…NTSB IAD98LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Oxford, CTThe pilot's improper flare and inadequate recovery from a bounced landing. A factor was the pilot's lack of experience.NTSB FTW98LA419Accident · No injuriesLimited investigationFinal reportHundere Kitfox II · Somerset, TXThe pilot's inadvertent stall. Factors were the wind sock that was displaying inaccurate information, the gusty wind condition, and the pilot's lack of experience in the tailwheel equipped airplane.NTSB FTW98LA409Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Catoosa, OKThe pilot's failure to maintain control of the airplane resulting in an inadvertent stall.NTSB FTW98FA411Accident · 2 fatalField investigationFinal reportCessna 170B · Weatherford, TXThe pilot's failure to maintain obstacle clearance.NTSB CHI98LA367Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-220T · Schofield, WIThe inadvertent deactivation of the fuel selector and the emergency procedure not followed by the pilot-in-command. The tree was a contributing factor.NTSB CHI98LA363Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Lamar, MOthe pilot improperly positioned the fuel selector to the closed position causing fuel starvation.NTSB CHI98LA361Accident · 2 fatalLimited investigationFinal reportChampion BL-7-GCBC · Upham, NDThe pilot's steep pull and failure to maintain adequate airspeed, which resulted in a stall/spin. Contributing factors were the pilot's lack of familiarity with the airplane's handling qualities, and a lack of recent experience in the airplane.NTSB ATL98LA132Accident · No injuriesLimited investigationFinal reportCessna 172P · Farmville, NCThe pilot's failure to maintain directional control of the aircraft and his improper use of the brakes, which led to the aircraft departing the left side of the runway. Contributing factors were the wet runway and the vehicle.NTSB ATL98LA130Accident · No injuriesLimited investigationFinal reportCessna 210L · Orlando, FLA 6-8 inch crack on the right main landing gear strut, which allowed the hydraulic fluid to escape from the system, along with a power pack sequencing valve failure which allowed the main landing gear to fold on landing. A factor in the accident was the…NTSB ANC98LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe pilot's failure to maintain directional control. Contributing factors were the gusty crosswind conditions.NTSB ANC98LA159Accident · No injuriesLimited investigationFinal reportBeech A36 · New Stuyahok, AKThe pilot's failure to extend the landing gear prior to landing. Factors associated with this accident were the pilot's interference with his normal habit pattern, turbulence, and the crosswind condition during landing.NTSB MIA98LA256Accident · No injuriesLimited investigationFinal reportCessna 152 · Reidsville, NCThe pilot's delay in the initiation of a go-around, and his failure to maintain obstacle (tree) clearance.NTSB IAD98LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe pilot's improper flare and improper recovery from a bounced landing.NTSB IAD98GA110Accident · 1 fatalFinal reportHughes OH-6A · Newark, TXFailure of the Instructor Pilot to control the helicopter's rate of descent during a demonstrated autorotation. Contributing to the accident were the Operator's lack of: a. Instructor Pilot standardization procedures, and b. Specific or adequate flight…NTSB FTW98LA418Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Alpine, TXThe pilot's failure to maintain directional control of the airplane for undetermined reasons. A factor was the loose gravel composition of the runway.NTSB FTW98LA410Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mart, TXThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB ANC98LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · New Stuyahok, AKThe pilot's excessive use of brakes during the landing roll.NTSB LAX98LA304Accident · No injuriesLimited investigationFinal reportBoeing 369E · Mesa, AZA hard landing caused by the pilot's improper flare during a simulated autorotatative landing. A factor in the accident was the soft wet sod landing area.NTSB ATL98LA131Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Lancaster, SCThe loss of engine power for undetermined reasons. Factor were conditions favorable for the formation of carburetor ice..NTSB ATL98LA129Accident · No injuriesLimited investigationFinal reportConvair 240 · Loiza, PRThe loss of power in the No. 2 engine for undetermined reasons, and the inability of the pilot to establish a climb and/or maintain altitude. A factor was the incompletely feathered No. 2 propeller..NTSB ANC98LA164Accident · No injuriesLimited investigationFinal reportGrumman S2F-1 · Wasilla, AKThe failure of the recently overhauled right brake seal resulting in a total loss of brake fluid, failure of the right brake system, and subsequent inability of the pilot to utilize the brake. A contributing factor was the soft terrain.NTSB ANC98LA158Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mcgrath, AKThe failure of the pilot to maintain directional control during takeoff. Factors involved in the accident were a crosswind, and the trees adjacent to the takeoff area.NTSB SEA98LA186Accident · No injuriesLimited investigationFinal reportBeech A35 · Christmasvalley, ORA jammed nose gear. A corroded cable and the failure of the owner to have an annual inspection performed on the airplane were factors.NTSB FTW98LA406Accident · 1 fatalLimited investigationFinal reportNicks PW-5 · Waller, TXThe pilot's failure to maintain terrain clearance.