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 FTW98LA360Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Boulder, COThe pilot's intentional ground loop and his inadequate compensation for the wind condition. A contributng factor was crosswinds.NTSB CHI98LA324Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Michigan City, INthe pilot departed into known adverse weather and failed to maintain directional control of the airplane. A factor was the fog.NTSB ATL98LA115Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Newton, MSThe erosion of the compressor impeller and the unsecured fuel control unit resulted in the loss of engine power during the initial climb.NTSB ANC98LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tok, AKThe pilot's inadequate compensation for wind conditions. A factor associated with the accident were gusty winds.NTSB SEA98LA167Accident · No injuriesLimited investigationFinal reportCessna 180 · Anaconda, MTA ground-loop resulting from the pilot's inadequate remedial action while attempting to correct for an inadvertent loss of directional control during the landing roll. Factors include the loss of directional control and attempting to land with a tailwind.NTSB SEA98LA166Accident · No injuriesLimited investigationFinal reportCessna 175 · Missoula, MTA complete loss of crankcase oil due to a missing oil filler tube followed by the failure of a connecting rod. Factors include encountering a small pine tree during the landing roll.NTSB SEA98LA165Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Vancouver, WAThe pilots inadequate remedial action, while attempting to recover from an inadvertent activation of the brakes, during the landing-roll. Factors include the inadvertent brake activation and the rough/uneven runway.NTSB NYC98LA199Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly AX-9 · Brookhaven, NYThe failure of the passenger to comply with the pilot briefing, and properly brace herself for landing.NTSB MIA98LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Conway, SCThe total failure of the left wing forward and aft attachment fitting due to corrosion and fatigue during a banner tow pick-up resulting in a subsequent in-flight collision with terrain.NTSB LAX98LA265Accident · No injuriesLimited investigationFinal reportRaymond C. Voegele Mini IMP RC-2 · Sonoma, CAA loss of power due to a loose magneto cap and a binding throttle control cable. The deficiencies were the result of the owner/pilot's improper installation and/or adjustments.NTSB LAX98FA264Accident · 2 fatalField investigationFinal reportNorth American Navion · Salinas, CAthe pilot's attempt to continue visual flight operations into an area of known instrument meteorological conditions resulting in controlled flight into rising terrain.NTSB IAD98LA096Accident · No injuriesLimited investigationFinal reportCessna 172G · Williamson, NYDirectional control not maintained by one of the pilot's on board the airplane.NTSB IAD98FA094Accident · 1 fatalField investigationFinal reportBeech A-36 · Amelia, OHthe pilot's loss of control in flight due to spatial disorientation. A related factor was the fog.NTSB FTW98LA390Accident · No injuriesLimited investigationFinal reportBeech E35 · Fort Worth, TXThe pilot's failure to maintain aircraft control during takeoff initial climb. A factor was the pilot lifting off the aircraft prematurely.NTSB FTW98LA359Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grand Prairie, TXFuel exhaustion due to the pilot's failure to refuel which resulted in the loss of engine power. Factors were the lack of suitable terrain for the forced landing, and the dark night light conditions.NTSB FTW98FA358Accident · 1 fatalField investigationFinal reportCessna 172N · Cord, ARThe pilot's performance of low altitude flight and his failure to maintain obstacle clearance.NTSB CHI98LA340Accident · No injuriesLimited investigationFinal reportCessna 172N · Traverse City, MIthe inadvertent stall/mush. Factors contributing to this accident were the pilot's improper compensation for the wind conditions, and his excessively high flare.NTSB CHI98LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Beecher, ILFuel exhaustion due to fuel mismanagement by the pilot-in-command. The rough terrain was a contributing factor.NTSB CHI98LA318Accident · Minor injuriesLimited investigationFinal reportWhetzel Thorpe T-18 · Rantoul, ILthe pilot not maintaining directional control. Factors were crops and encounter with unsuitable terrain.NTSB CHI98LA316Accident · Minor injuriesLimited investigationFinal reportWakely DR-107 · Stanton, MNthe pilot's misjudging recovery from a bounced landing. Factors were the partial failure of the propeller and a crop field.NTSB CHI98LA315Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Redwood Falls, MNthe pilot's not following proper short field landing procedures.NTSB CHI98LA314Accident · No injuriesLimited investigationFinal reportValentin Taifun 17E · Lake Geneva, WIthe pilot's failure to maintain directional control and obtain proper climb rate during initial climb after takeoff. A factor was trees.NTSB ATL98LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Paris, TNThe pilot's improper landing flare that resulted in an overload failure of the left main landing gear.NTSB ATL98LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305 · Lantana, FLThe pilot's inadequate preflight inspection of the fuel system that resulted in the loss of engine power due to water contamination. A factor was the rough terrain on the departure end of the runway.NTSB ANC98TA125Accident · No injuriesFinal reportBell 206B II · Chickaloon, AKA fracture of the main rotor drag pin assembly.NTSB ANC98LA131Accident · No injuriesLimited investigationFinal reportCessna 172 · Palmer, AKFatigue of the forward end of the engine crankshaft resulting in separation of the propeller assembly, and the operator's failure to comply with a required maintenance procedure. A factor was uneven terrain.NTSB SEA98FA164Accident · 2 fatalField investigationFinal reportNorth American SNJ-5C · Winlock, WAThe pilot's failure to maintain adequate altitude during attempted low-level aerobatics.NTSB CHI98LA312Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Shelton, NEThe pilot mismanaged the fuel which led to fuel starvation and subsequent loss of engine power.NTSB CHI98FA313Accident · 1 fatalField investigationFinal reportHiller FH-1100 · Dewitt, MIThe rotor failure/malfunction due to debonding of the tail rotor blade. Also causal was the inadequate maintenance inspection of the aircraft by the company and the improper maintenance procedure by other maintenance personnel.NTSB ANC98LA122Accident · No injuriesLimited investigationFinal reportBoeing 737-400 · Juneau, AKThe flight crew's inadequate recovery from a bounced landing.NTSB ANC98LA121Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Arctic Village, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were variable, and gusty wind conditions.NTSB SEA98LA162Accident · Minor injuriesLimited investigationFinal reportCessna T337E · Hillsboro, ORThe disengagement of the pilot seat forward and aft movement locking pin, followed by the pilot's seat sliding to the rear of the seat track.NTSB MIA98LA225Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Vero Beach, FLThe student's improper retraction of the landing gear and the instructor's inadequate supervision.NTSB MIA98LA224Accident · Minor injuriesLimited investigationFinal reportLesemann Pulsar XP · Fort Pierce, FLThe pilot's improper fuel management during a cross country flight which resulted in a total loss of engine power during the approach for landing and subsequent in-flight collision with wires and terrain.NTSB FTW98LA369Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Blanding, UTThe pilot's inadequate landing flare, causing components of the nose wheel landing gear to fracture.NTSB DCA98WA081Incident · No injuriesForeign investigationBoeing 737-200 · Gatwick, United KingdomNTSB CHI98LA311Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Decatur, INthe pilot's failure to maintain adequate airspeed during the takeoff and his premature raising of the flaps which resulted in the stall/mush condition.NTSB SEA98LA168Accident · No injuriesLimited investigationFinal reportCessna 140 · Battleground, WANose Over for undetermined reasons.NTSB SEA98LA163Accident · No injuriesLimited investigationFinal reportSix/Huber RV-6 · Roseburg, ORA total loss of engine power for undetermined reasons.NTSB NYC98FA166Accident · 2 fatalField investigationFinal reportChampion 7FC · Alliance, OHThe pilot's failure to maintain altitude/clearance during the approach which resulted in an in-flight collision with trees. A factor in the accident was the pilot's lack of recent experience and lack of experience in the make and model of the accident…NTSB MIA98LA222Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain airspeed resulting in a stall.NTSB MIA98LA221Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Marco Island, FLThe pilot's inadequate fuel management which led to fuel exhaustion. A related factor was the pilot's improper use of the flight controls during autorotation.NTSB FTW99LA028Accident · No injuriesLimited investigationFinal reportCessna 185F · Venice, LAThe pilot's failure to maintain control of the airplane during high speed step-taxi. A factor was the swell left by the boat.NTSB ANC98LA120Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Fort Yukon, AKThe pilot's failure to follow the pre-landing checklist. A factor associated with the accident was the pilot's diverted attention.NTSB IAD98FA092Accident · 1 fatalField investigationFinal reportAustin Revolution Mini 500 · Northampton, PAthe improper maintenance adjustment and the failure to properly torque the pitch-change link barrel by the owner/builder which resulted in main rotor to tailboom contact and main rotor separation.NTSB CHI98LA325Accident · No injuriesLimited investigationFinal reportCessna 120 · Benton, KSthe pilot's inadvertant excessive use of the toe brakes during the landing roll.NTSB SEA98LA160Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Oso, WAThe separation of the 90 degree gearbox and tail rotor assembly for undetermined reasons followed by the inability of the pilot-in-command to maintain control of the rotorcraft.NTSB MIA98LA220Accident · No injuriesLimited investigationFinal reportCessna 188 · Atlantic Ocean (Atlantic Ocean)A complete loss of engine power due to loss of oil pressure, resulting in a force landing on non suitable terrain, and the subsequent sinking of the airplane in deep water.NTSB LAX98LA262Accident · No injuriesLimited investigationFinal reportCessna 150M · Santa Paula, CAFailure of the number one cylinder due to a fatigue crack that had originated from corrosion pits at the cooling fin.NTSB CHI98FA309Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · New Hampton, IAThe pilot's inadequate preflight/planning inspection and his continued flight into known adverse weather conditions that led to spatial disorientation and loss of aircraft control. Also causal was the pilot exceeded the design limits of the airplane causing…