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 CHI98LA334Accident · No injuriesLimited investigationFinal reportCulver-Revolution Mini 500 · Eden Prairie, MNa design change to the fuel tank filler neck sealant made by the owner/builder of the helicopter. Factors associated with this accident were an improper sealant material used by the owner/builder and an autorotation was not possible by the pilot due to the…NTSB ANC98LA144Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Willow, AKThe pilot's selection of an unsuitable takeoff area from the lake. Factors were the obstruction (point of land) hidden in the glare from the rising sun.NTSB ANC98FA145Accident · 5 fatalField investigationFinal reportde Havilland DHC-2 · Port Alsworth, AKThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors associated with this accident were the pilot's unfamiliarity with the geographic area, the low clouds, his becoming disoriented, and the blind canyon into which…NTSB LAX98LA277Accident · Serious injuriesLimited investigationFinal reportSilvaire Luscombe 8E · Mojave, CAFuel exhaustion due to the pilot's inadequate preflight.NTSB FTW98LA388Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Kaufman, TXThe pilot's failure to maintain adequate altitude and clearance of obstructions during takeoff.NTSB FTW98LA387Accident · No injuriesLimited investigationFinal reportCessna 172M · Englewood, COThe pilot's failure to maintain directional control during landing. Factors were the runway light and the terrain conditions.NTSB NYC98FA180Accident · 5 fatalField investigationFinal reportBeech A23-24 · Shunk, PAThe pilot-in-command's attempted flight into known adverse weather conditions, his failure to maintain control of the aircraft, and his exceeding the airframe design limits resulting in separation of the outboard left wing. Contributing factors were clouds,…NTSB MIA98FA239Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Daytona Beach, FLThe pilot's use of the aircraft to commit suicide.NTSB LAX98LA283Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Truckee, CAThe pilot's failure to use carburetor heat in temperature conditions conducive to carburetor icing and his failure to lean the engine in a high density altitude environment, which combined, led to a partial loss of engine power and the onset of a stall during…NTSB IAD98FA106Accident · 5 fatalField investigationFinal reportPiper PA-46-350P · Centerville, NYThe pilot's inadvertent flight into adverse weather conditions. Factors related to the accident were the pilot's failure to use weather detection equipment and use of airspeeds in excess of limitations.NTSB CHI98LA336Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Eaton Rapids, MIthe pilot's improper decision to abort the takeoff while in the air and beyond the point where the pilot could execute a landing on the remaining airstrip runway area. A factor which contributed to this accident was the soybean crop.NTSB ATL98LA123Accident · Minor injuriesLimited investigationFinal reportVertical Concepts Searey · Hiawassee, GAThe delamination of the hull that resulted in a nose over during landing.NTSB ATL98LA122Accident · No injuriesLimited investigationFinal reportCessna 172B · New Port Richey, FLThe pilots disregard of the performance capabilities of the airplane, his failure to attain and maintain flying speed, and his exceeding of the airplane's maximum weight.NTSB ANC98LA143Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Homer, AKA total loss of power in the right engine for undetermined reasons.NTSB ANC98LA141Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 Husky · Selawik, AKThe pilot's inadequate compensation for the crosswind conditions. Factors in this accident were a crosswind, the pilot's lack of certification, and his inadequate fuel consumption calculations.NTSB ANC98LA140Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbanks, AKThe loss of engine power due to an in-flight fracture of an engine exhaust valve stem assembly. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB NYC98LA182Accident · Serious injuriesLimited investigationFinal reportPiper J3L-65 · Morristown, VTA loss of engine power for undetermined reasons.NTSB LAX98LA294Accident · No injuriesLimited investigationFinal reportCessna 172L · Bakersfield, CAThe pilot's misjudged landing flare that led to an improper bounced landing recovery and subsequent uncontrolled porpoise.NTSB IAD98LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Schroon Lake, NYThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the gusty wind conditions and trees.NTSB FTW98LA386Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hilltop Lakes, TXThe pilot's failure to maintain control of the aircraft during takeoff. Factors were the pilot's lack of experience in grass field operations, the unsuitable terrain for takeoff, and the pilot's failure to perform a soft field takeoff procedure more suitable…NTSB FTW98LA385Accident · Serious injuriesLimited investigationFinal reportJobe'S TE-1 · Alamogordo, NMThe improper maintenance procedures (failure to preserve the engine during numerous storage periods over 30 days) and the lack of suitable terrain for a forced landing. Factors were the pilot's lack of experience in type of aircraft and the high density…NTSB SEA98LA175Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Stanley, IDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB SEA98LA174Accident · No injuriesLimited investigationFinal reportCessna 180J · Oroville, WAThe pilot-in-command's failure to establish and maintain proper alignment.NTSB NYC98LA183Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Chatham, MAthe failure of the pilot to maintain airspeed during a go-around and which resulted in an inadvertent stall. Factors in the accident were the pilot's lack of total experience and the gusting crosswinds.NTSB NYC98LA181Accident · No injuriesLimited investigationFinal reportCessna 305A · Louisville, KYThe pilot's improper inflight decision, and his failure to maintain adequate airspeed which resulted in a stall.NTSB NYC98FA179Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar TS-600 · Marietta, PAThe failure of the pilot to maintain airspeed during a precautionary landing which resulted in a loss of control while operating with one engine shutdown. An additional cause was the improper maintenance procedures that resulted in the #5 cylinder not being…NTSB MIA98LA242Accident · No injuriesLimited investigationFinal reportCessna 177RG · Covington, GAslippage of the No. 3 connecting rod bearing resulting in blockage of the oil port, oil starvation, and subsequent connecting rod failure. A factor was the fence.NTSB MIA98LA240Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Winnsboro, SCThe loss of engine power for undetermined reasons.NTSB MIA98LA238Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · St. Augustine, FLThe failure of the flight instructor and dual student to ensure the landing gear was extended for landing and their attempted go-around after the aircraft and propellers contacted the runway. This resulted in loss of directional control during the go-around…NTSB MIA98FA237Accident · 1 fatalField investigationFinal reportGlasair SH-2R · Panama City, FLThe pilot's failure to maintain a proper descent rate during a precautionary landing following a loss of engine power for undetermined reasons.NTSB LAX98LA284Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Oroville, CAthe pilot's inaccurate preflight and in-flight fuel consumption calculations, which resulted in fuel exhaustion. The pilot's failure to obtain the proper engine power setting charts to use in fuel consumption calculations was also causal.NTSB CHI98LA333Accident · No injuriesLimited investigationFinal reportCessna 150E · Cadillac, MIthe pilot's inadequate evaluation of the wind condition which resulted in landing on the wrong runway. A factor associated with the accident was the tailwind.NTSB ANC98LA142Accident · No injuriesLimited investigationFinal reportCessna 170B · Port Alsworth, AKThe solo student pilot's excessive application of brakes during taxi from landing. Factors associated with the accident were the pilot's selection of unsuitable terrain for a precautionary landing, rough terrain, and the fuel leak from the fuel tank vent.NTSB LAX98FA282Accident · 1 fatalField investigationFinal reportSimons Lancair 235 · Llano, CAPilot's inadvertent VFR flight into instrument meteorological conditions , which resulted in spatial disorientation and a subsequent loss of aircraft control.NTSB FTW98LA389Accident · No injuriesLimited investigationFinal reportCessna 401 · Lancaster, TXThe pilot's inadvertent retraction of the landing gear while intending to retract the flaps. A factor was the pilots lack of total experience in the type of aircraft.NTSB CHI98LA348Accident · No injuriesLimited investigationFinal reportCessna A185F · Bottineau, NDThe partial loss of engine power for undetermined reasons, and the pilot's excessive use of brake pressure which resulted in the aircraft nosing over..NTSB CHI98LA332Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Decker, INThe pilot's failure to maintain obstacle clearance resulting in a collision with a fence.NTSB ANC98LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's selection of an unsuitable off airport site for landing. A factor associated with the accident was high vegetation (brush and weeds) in the landing area.NTSB LAX98LA281Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Phoenix, AZFuel starvation due to the pilot's inadequate in-flight fuel management and his failure to select a tank containing fuel prior to the loss of power.NTSB FTW98FA384Accident · 2 fatalField investigationFinal reportCessna 172 · West Jordan, UTThe pilot's failure to maintain proper airport traffic pattern altitude. Factors were night lighting conditions and the unseen static line.NTSB DCA98RA085Accident · 229 fatalForeign investigationDouglas MD-11 · Nova Scotia, CanadaNTSB SEA98LA173Accident · No injuriesLimited investigationFinal reportKoskella Long EZ · Cascade, IDThe pilot's failure to maintain airspeed on final approach. Factors include inadequate remedial action and erroneous airspeed indications.NTSB NYC98LA177Accident · No injuriesLimited investigationFinal reportDouglas DC-9-30 · Philadelphia, PAthe failure of the fuel truck driver to follow airport operating procedures, and yield the right-of-way to the airplane. Factors were the stopped airplane, which obscured the fuel truck from the approaching airplane and the approaching airplane from the fuel…NTSB LAX98LA280Accident · No injuriesLimited investigationFinal reportCessna 188B · Dixon, CAA partial loss of engine power for an undetermined reason, and the ignition of a highly combustible compound in the application hopper.NTSB FTW98LA383Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Portales, NMThe pilot's failure to maintain adequate altitude/clearance during an aerial application. Also causal was the inadvertent ground loop/swerve during the landing.NTSB FTW98LA382Accident · No injuriesLimited investigationFinal reportCessna T210M · Mcallen, TXThe pilot's inadequate compensation for the crosswind resulting in a loss of control. A factor was the crosswind.NTSB CHI98LA331Accident · No injuriesLimited investigationFinal reportCessna 172N · Detroit Lakes, MNAn inadequate preflight inspection by the pilot which resulted in fuel exhaustion and subsequent loss of engine power.NTSB ANC98LA138Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKThe pilot's failure to maintain clearance with terrain. Contributing factors were the pilot's delayed remedial action (course reversal), low ceilings, rain, fog, and mountainous terrain.NTSB NYC98LA178Accident · No injuriesLimited investigationFinal reportMaule MX-7-160 · Skaneateles, NYThe pilot's failure maintain directional control and his delayed decision to abort the takeoff. Contributing factors were trees.NTSB MIA98LA235Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Kill Devil Hill, NCFailure of the number one cylinder exhaust valve resulting in loss of engine power and a forced landing on unsuitable terrain at which time the aircraft nosed over.