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 ATL98LA110Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Thomasville, GAThe pilot's poor in-flight decision to attempt a forced landing in a field 2 miles from an airport, leading to an on-ground collision with rough terrain. A factor was the pilot's physiological need.NTSB NYC98FA164Accident · 1 fatalField investigationFinal reportCessna 150L · Towanda, PAThe pilot's failure to obtain adequate climb and his premature retraction of the flaps. A contributing factor was his inadequate recovery from a bounced landing.NTSB LAX98LA263Accident · No injuriesLimited investigationFinal reportCessna 182 · Page, AZFailure of the pilot to verify throttle position and/or obtain qualified assistance while hand propping the aircraft engine.NTSB IAD98LA091Accident · Serious injuriesLimited investigationFinal reportCessna T337G · Windsor Twnship, PAThe pilot's mismanagement of the fuel which led to fuel exhaustion and subsequent loss of engine power.NTSB FTW98LA347Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Hayes, LAThe forced landing for undetermined reasons. A factor was no suitable terrain for the forced landing.NTSB CHI98LA320Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Lac Du Flambeau, WIthe pilot's failure to maintain adequate airspeed and the subsequent inadvertant stall.NTSB CHI98LA307Accident · No injuriesLimited investigationFinal reportCessna 150L · Philip, SDthe fuel exhaustion due to the pilot's inadequate preflight inspection. A factor was the soft field.NTSB CHI98LA305Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edgeley, NDThe pilot's failure to maintain flying airspeed resulting in a stall/mush condition during the initial climb. Contributing factors were the high density altitude, high aircraft weight, and pilot's delayed jettison of the load, as well as the roadway and crop.NTSB ANC98LA119Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Copper Center, AKThe pilot's selection of an unsuitable off-airport landing site. A factor associated with the accident is rough and uneven terrain.NTSB SEA98GA159Accident · No injuriesFinal reportBell 212 · Juntura, ORThe pilot-in-command's failure to maintain proper clearance between the long line cable and hell hole structure resulting in airframe contact and binding of the cable. This resulted in separation/disabling of the fuel control solenoid and a subsequent…NTSB MIA98LA223Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2 · Miami, FLThe pilot's failure to use a checklist and ensure that the landing gear was down and locked during approach to landing.NTSB LAX98IA261Incident · No injuriesIncident investigationFinal reportBoeing 727-2Q8 · Las Vegas, NVThe airport personnel's failure to properly mark the ditch hazard and the taxiway boundaries surrounding it, and, the captain's failure to maintain a situational awareness of his location with respect to the taxiway layout. The dark night lighting condition…NTSB LAX98FA260Accident · 3 fatalField investigationFinal reportPiper PA-31-T1 · Baker, NVthe pilot's failure to comply with a 12,500-foot altitude restriction placed on the aircraft by an FAA approved maintenance facility due to unresolved oxygen system issues. Contributing to the accident was the pilot's failure to divulge his true physical…NTSB FTW98LA355Accident · No injuriesLimited investigationFinal reportCrane Quicksilver Sport 2 · Glenn Heights, TXThe loss of engine power as the result of the owner/pilot's failure to install and adjust the proper carburetor jets. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA352Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Huntsville, UTThe flight instructor's failure to ensure adequate altitude/clearance with terrain, resulting in an encounter with a downdraft, loss of airspeed, onset of a stall/mush, and collision with high terrain.. Contributing factors were high density altitude,…NTSB FTW98LA351Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Denver, COThe failure of the flight crew to comply with braking instructions after being instructed by ground personnel.NTSB FTW98LA350Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Alamosa, COImproper major overhaul of the engine by the overhaul facility. Factors were failure of the V-band clamp, the melting of the baffle and manifold clamp, and the pilot not being able to extend the landing gear.NTSB CHI98LA306Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Kindred, NDthe pilot did not maintain clearance with obstructions along his flight path.NTSB ATL98LA108Accident · Serious injuriesLimited investigationFinal reportDean R. Fellows Vans RV-6 · Bainbridge, GAThe pilot's failure to properly modify the crankshaft per the manufacturers service instructions for installation of a fixed pitch propeller and to apply proper torque values to the propellers mounting bolts.NTSB ATL98LA107Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Dothan, ALFuel Exhaustion due to the pilot's improper fuel consumption calculations. A factor was the power line.NTSB ANC98LA118Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Dillingham, AKThe pilot's inadvertent ground loop during the landing roll. A factor associated with the accident is a crosswind.NTSB SEA98LA158Accident · No injuriesLimited investigationFinal reportCessna 182 · Yellowpine, IDRight main landing gear spring strut fatigue, improper maintenance, and subsequent separation of the strut end.NTSB SEA98LA157Accident · No injuriesLimited investigationFinal reportCessna U206F · Stanley, IDThe pilot-in-command's not lowering flaps prior to takeoff and overload of the nose landing gear. Contributing factors were high density altitude conditions and high brush.NTSB NYC98LA163Accident · Minor injuriesLimited investigationFinal reportCessna 172P · West Milford, NJThe student pilot's improper recovery from a bounced landing and the instructor's inadequate supervision of the flight.NTSB NYC98IA165Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Mcconnellsburg, PAA high altitude encounter with wake vortices.NTSB FTW98LA375Accident · No injuriesLimited investigationFinal reportBeech D95A · Albuquerque, NMThe pilot's inadvertent raising of the landing gear during landing rolloutNTSB FTW98LA357Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Belen, NMThe pilot's improper preflight in that he failed to drain the water from the fuel sumps. Factors were water contamination in the fuel tank and a sand bar.NTSB FTW98LA356Accident · No injuriesLimited investigationFinal reportHughes 269B · Uvalde, TXThe pilot's failure to maintain control during a vertical, out of ground effect takeoff which resulted in a hard emergency landing. Factors were; the exceeded hover performance of the helicopter, the high density altitude, and the lack of suitable terrain for…NTSB FTW98LA349Accident · No injuriesLimited investigationFinal reportCessna 210M · Albuquerque, NMA power loss for reasons undetermined. A factor was unsuitable terrain on which to make a forced landing.NTSB FTW98LA348Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper remedial action after making a hard landing and porpoising. A factor was his lack of total experience.NTSB ATL98LA106Accident · No injuriesLimited investigationFinal reportCessna 170 · Pell City, ALThe pilot's improper use of the flight controls during a crosswind landing and the improper recovery from a bounce resulted in the collapse of the right main landing gear. A factor was the right crosswind.NTSB ATL98LA105Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Marathon, FLThe inadequate inspection of the fuel pump during the last engine overhaul, that subsequently resulted in a worn diaphragm, fuel venting overboard, and loss of engine power from fuel exhaustion during a critical phase of flight.NTSB FTW98LA345Accident · Minor injuriesLimited investigationFinal reportFennell VP2 · Collinsville, OKThe loose throttle control cable resulting in the loss of engine power. A factor was the pilot's decision to intentionally stall the airplane close to the ground during the forced landing to an open field.NTSB FTW98FA344Accident · 4 fatalField investigationFinal reportCessna T210N · Creede, COThe pilot's failure to maintain flying airspeed and the subsequent stall/spin. A contributing factor was high density altitude.NTSB CHI98LA302Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Columbus, INthe pilot-in-commands failure to maintain airspeed and the subsequent stall/mush. Factors associated with the accident were the open baggage door and the inadequate aircraft preflight.NTSB ATL98LA104Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Ocean Isle Bch, NCThe pilot's inadequate inflight planning that resulted in excessive airspeed and altitude for a full stop landing.NTSB ATL98LA101Accident · No injuriesLimited investigationFinal reportWaco WMF · Chamblee, GAThe pilot's excessive taxi speed and excessive braking action that resulted in a nose over.NTSB ANC98FA116Accident · 1 fatalField investigationFinal reportCessna A185F · Ketchikan, AKFuel starvation and the pilot's improper fuel tank selection. Factors associated with the accident were the pilot's failure to follow the pre-takeoff checklist and trees.NTSB NYC98LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · West Liberty, KYThe pilot's inadequate planning for a downslope landing. A factor was the pilot's lack of training for downslope landing situations.NTSB LAX98LA258Accident · No injuriesLimited investigationFinal reportM. C. Thomas Stewart S-51 · Jackson, CAFailure of the propeller governor pulley drive shaft due to a modification made to the system by the owner that included welding a retaining pin to the center of the heat treated drive shaft, which compromised the shaft's design strength margin.NTSB FTW98LA374Accident · No injuriesLimited investigationFinal reportBeech B36TC · Pinedale, WYThe pilot not following his Pilot Operating checklist procedures. A factor was the aborted landing which interfered with the pilot's normal traffic pattern habit.NTSB DCA98WA079Accident · No injuriesForeign investigationBoeing 747-400 · Seoul, South KoreaNTSB CHI98LA304Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Trenton, NEthe pilot misjudged the forced landing approach and stalled the airplane while attempting to lengthen his glide on final approach and inadequate preflight planning that led to the loss of engine power due to fuel exhaustion.NTSB CHI98FA300Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Rosemount, MNThe loss of engine power due to water-contaminated fuel and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB ATL98LA102Accident · No injuriesLimited investigationFinal reportPiper PA-22 · New Bern, NCThe failure of the inner cable of the carburetor heat cable assembly that prevented the application of carburetor heat. Factors were conditions favorable for the formation of carburetor ice.NTSB ANC98LA117Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Delta Junction, AKThe pilot's selection of an unsuitable takeoff area. Factors associated with the accident were willow trees, and rising terrain.NTSB MIA98FA219Accident · 4 fatalField investigationFinal reportSocata TBM-700 · Spearfish, SDThe pilot's failure to maintain control of the airplane while turning to base leg. Contributing factors were low ceilings, clouds, and the pilot's failure to adhere to both the published approach procedures and the published minimum decent altitude.NTSB LAX98LA257Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Van Nuys, CAThe pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional control that subsequently lead to a ground loop/swerve.NTSB LAX98LA256Accident · No injuriesLimited investigationFinal reportBell 206B · Lucerne Valley, CAThe failure of the mechanic who installed the engine to follow proper procedures by insuring the proper torque to the oil output line, resulting in a loose fitting, oil loss and subsequent bearing failure.NTSB FTW98LA342Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Bryce Canyon, UTA partial loss of engine power due to an oil leak in the turbocharger system. Factors were high vegetation and high density altitude.