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 CHI98LA360Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Amery, WIA loss of engine power due to fatigue failure of the crankshaft from frictional heating for undetermined reasons. A related factor was the unsuitable terrain.NTSB ANC98LA156Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Heiden, AKThe pilot's inadvertent activation of the brakes during the landing roll resulting in a ground loop/swerve.NTSB SEA98LA185Accident · Serious injuriesLimited investigationFinal reportDuncan DX4 · Priest River, IDThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush. Factors include allowing his attention to be diverted by what he perceived to be a lateral control problem.NTSB NYC98LA191Accident · No injuriesLimited investigationFinal reportBoeing PT-17 Stearman · So. Charleston, WVThe pilot's failure to maintain control of the airplane during landing.NTSB LAX98LA303Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Santa Rosa, CAThe pilot's inadequate visual lookout during taxiing operations. A factor was the pilot's diverted attention while taxiing.NTSB ATL98LA128Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Goodway, ALThe pilot's continued approach into known adverse weather which resulted in the pilot's loss of control, and subsequent inflight collision with terrain. A factor was the weather conditions.NTSB ANC98LA155Accident · No injuriesLimited investigationFinal reportPiper PA-12 · New Stuyahok, AKThe pilot's selection of an unsuitable takeoff area and his intentional ground loop maneuver. A factor associated with the accident was trees.NTSB LAX98LA302Accident · No injuriesLimited investigationFinal reportBognuda Livio IV Lancair · Reno, NVThe failure of the pilot-in-command to maintain adequate visual surveillance of the taxiway in front of his aircraft to avoid the collision.NTSB LAX98LA301Accident · No injuriesLimited investigationFinal reportCessna 172F · Long Beach, CAThe pilot's misjudging the flare point and failure to maintain an adequate airspeed margin, which resulted in a stall/mush and hard landing. A contributing factor was the dark night conditions.NTSB LAX98FA296Accident · 2 fatalField investigationFinal reportCessna 310K · Saugus, CAthe pilot's in-flight loss of control which led to a subsequent structural airframe failure as the pilot exceeded the design stress limits of the airplane during an attempted recovery.NTSB CHI98LA359Accident · No injuriesLimited investigationFinal reportCessna 152 · West Lafayette, INthe student pilot's failure to maintain directional control during the touch and go takeoff.NTSB SEA98LA184Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Flying M Ranch, ORThe pilot's failure to maintain an airspeed above stalling speed (Vs), and the resultant stall/mush of the aircraft into the terrain. Factors include the pilot's improper decision to attempt a go-around into rising terrain, landing with a tailwind, and trees…NTSB NYC98LA195Accident · No injuriesLimited investigationFinal reportCessna 172D · Louisville, KYThe student pilot's failure to perform a preflight inspection of the airplane before his first solo flight, and inadequate supervision by the certified flight instructor, which resulted in fuel exhaustion.NTSB MIA98WA251Accident · No injuriesForeign investigationBoeing 757-223 · La Paz, BoliviaNTSB MIA98LA249Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Burlington, NCThe pilot's failure to abort the takeoff after recognizing that the airplane was slow to accelerate during the takeoff roll, and his not obtaining/maintaining clearance with the wire during the forced landing. Contributing factors were carburetor icing…NTSB MIA98FA250Accident · 5 fatalField investigationFinal reportPiper Aerostar 600 · N. Myrtle Beach, SCThe pilot's failure to maintain airspeed (Vs) during a single engine approach resulting in an inadvertent stall. Factors contributing to the accident were a fatigue crack in the exhaust pipe in the right engine, the aircraft weight and balance was exceeded,…NTSB LAX98LA300Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dayton, NVLoss of engine power for unknown reasons. Factors were conditions conducive to carburetor icing and the use of automotive fuel.NTSB LAX98LA299Accident · No injuriesLimited investigationFinal reportCessna 185E · Mesa, AZThe failure of the wheel assembly retention nuts and subsequent wheel separation.NTSB FTW98LA403Accident · No injuriesLimited investigationFinal reportCessna 150M · Yukon, OKThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.NTSB FTW98LA402Accident · No injuriesLimited investigationFinal reportFairchild M-62A-3 · Amarillo, TXThe inadvertent stall due to the pilot's failure to maintain proper airspeed during the takeoff.NTSB DCA98WA088Incident · No injuriesForeign investigationMcDonnell Douglas DC-10-30 · Shannon, IrelandNTSB CHI98LA357Accident · No injuriesLimited investigationFinal reportCessna 182K · Baldwin, WIThe pilot's inadequate preflight planning and preparation, and his failure to stop on the wet, grassy runway. A related factor was the wet grass.NTSB CHI98LA352Accident · No injuriesLimited investigationFinal reportFieseler Flugzeugbau F-156C-1 · Irish Hills, MIthe pilot selected to operate the airplane with a known deficiency. A factor in this accident was the vapor lock experienced by the engine's carburetor.NTSB SEA98LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Whidbey Airpark, WAThe pilot misjudged her altitude and airspeed. Factors include a wet runway surface and high vegetation off the end of the runway.NTSB NYC98LA190Accident · No injuriesLimited investigationFinal reportCessna 172 · Stow, MAThe pilot's improper recovery from a bounced landing. Contributing factors were the pilot's lack of a single engine experience/certification. Also a factor was the flying club's inadequate oversight of pilot qualifications.NTSB LAX98LA315Accident · No injuriesLimited investigationFinal reportCessna 150L · Oroville, CAFailure of the pilot to maintain proper clearance and subsequently striking a hangar door while taxiing to parking.NTSB LAX98LA298Accident · No injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39 · Mesa, AZThe pilot's improper flare and his failure to follow the proper procedures for the aircraft and to maintain control of the aircraft.NTSB LAX98FA297Accident · 2 fatalField investigationFinal reportBeech 35-B33 · San Jose, CAthe pilot's loss of aircraft control and entry into a spiral dive for undetermined reasons. The dark night lighting conditions and the pilot's probable low recent flight experience were factors in this accident.NTSB IAD98LA109Accident · No injuriesLimited investigationFinal reportRussell Rebel · Cadiz, OHThe pilot's inadequate compensation for winds.NTSB FTW98LA405Accident · Minor injuriesLimited investigationFinal reportBell UH-1L · Price, UTThe pilot's inadvertent loss of tail rotor effectiveness. Factors were the high density altitude flight conditions, the unfavorable wind condition, and the none suitable terrain for an autorotation.NTSB FTW98FA392Accident · Serious injuriesField investigationFinal reportPiper PA-20-180 · Thornton, COThe separation of a propeller blade due to corrosion initiated fatigue, followed by the separation of several of the engine's mounts, and the subsequent inability of the pilot to control the aircraft. A contributing factor was the trees.NTSB CHI98FA353Accident · 1 fatalField investigationFinal reportBarklage Revolution Mini 500 · Cahokia, ILA loss of engine power due to cold seizure of the power-takeoff cylinder. A factor contributing to the accident was the power lines.NTSB ANC98LA157Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's inadequate compensation for the gusty wind conditions, and his attempted flight into adverse weather. Factors associated with the accident are high and gusty winds.NTSB ANC98LA154Accident · No injuriesLimited investigationFinal reportCessna 182D · Fort Yukon, AKA failure of the pilot to maintain the proper glidepath to the landing touch down spot.NTSB SEA98LA182Accident · 1 fatalLimited investigationFinal reportCora Allegro · Cresent Lake, ORThe pilot's failure to maintain clearance from trees located off the departure end of the runway. Factors include strong, variable, gusty winds, terrain-induced turbulence, a high density altitude, and trees off the departure end of the runway.NTSB MIA98LA248Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Titusville, FLThe collapse of the right main landing gear for undetermined reasons. A contributing factor was the pilot's failure to execute the emergency gear extension procedure.NTSB FTW98LA407Accident · No injuriesLimited investigationFinal reportSnow S2C · Bovina, TXThe pilot's failure to maintain directional control during the landing roll.NTSB FTW98LA404Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Duck Creek, UTLoose intake valve rocker arm studs that allowed a loss of compression and a loss of oil. A factor was unsuitable terrain on which to make a forced landing and poles next to a cattle guard.NTSB CHI98LA358Accident · No injuriesLimited investigationFinal reportCessna 182K · Eldon, MOThe pilot's not correcting for a porpoise condition during landing roll.NTSB CHI98LA351Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe wake turbulence encountered by Flight 146.NTSB ATL98GA127Accident · 1 fatalFinal reportGovernment Aircraft Fact N22S · Caribbean SeaThe failure of the pilot-in-command of the other aircraft (N6305U) to maintain physical clearance from N6302W. Contributing factors were the inadequate visual lookout of all four pilots involved.NTSB ANC98LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Chalkitsik, AKThe pilot's failure to identify an unsafe/hazardous condition. A factor associated with the accident was soft terrain conditions.NTSB SEA98LA194Accident · No injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDAn animal (cow elk) that had wandered onto the airport.NTSB SEA98LA181Accident · Serious injuriesLimited investigationFinal reportKelly Kolb Mark III · Cashmere, WAFuel starvation caused by the partial blockage of the fuel pump chambers as a result of the misalignment of the fuel pump front cover by the pilot/builder. Factors include trees in the area in which the pilot attempted the forced landing.NTSB NYC98LA188Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellington, CTWas the flight instructors lack of supervision over the student pilot's preflight inspection of the airplane, and which resulted in fuel exhaustion. Factors were the night conditions and the soft terrain.NTSB LAX98WA316Accident · 3 fatalForeign investigationCessna 206 · Arusha, TanzaniaNTSB LAX98LA314Accident · No injuriesLimited investigationFinal reportMooney M20C · Reno, NVThe pilot's inadequate compensation for the existing crosswind condition, which resulted in a hard landing.NTSB LAX98LA295Accident · 1 fatalLimited investigationFinal reportHughes Cassutt 111M2 · Reno, NVthe pilot's failure to maintain an adequate airspeed margin while maneuvering in gusty wind conditions, which led to an inadvertent stall/spin at low altitude.NTSB FTW98RA401Accident · No injuriesForeign investigationBoeing 737-524 · Guadalajara, MexicoNTSB FTW98LA400Accident · No injuriesLimited investigationFinal reportBell 47-G-2 · Ardmore, OKThe pilots failure to maintain clearance with terrain and the ensuing loss of control.