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 CHI98LA328Accident · No injuriesLimited investigationFinal reportBeech B35 · Iowa City, IAThe fuel starvation due to improper fuel management by the pilot-in-command. Also, the aircraft procedures and directives which were not followed by the pilot-in-command is an additional cause. The rough and uneven terrain in addition to the low altitude of…NTSB CHI98LA327Accident · No injuriesLimited investigationFinal reportCessna 310B · Breezy Point, MNthe pilot's improper flare of the airplane, and his not maintaining control of the airplane.NTSB ATL98RA119Accident · 11 fatalForeign investigationCessna 402C · Melville Hall, DominicaNTSB ANC98LA129Accident · Minor injuriesLimited investigationFinal reportDrake Kitfox III · Aniak, AKThe pilot's inadequate in-flight planning/decision, and an inadvertent stall. Factors in the accident were the pilot/owner's improper installation and pitch setting of the propeller assembly, and a tailwind.NTSB IAD98LA099Accident · No injuriesLimited investigationFinal reportMooney M-20C · Kent Island, MDthe pilot's improper takeoff technique and his failure to abort the takeoff.NTSB IAD98LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Cumberland, MDThe pilot in command's improper recovery from a bounced landing.NTSB FTW98LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hurricane, UTThe pilot inadvertently inducing a porpoise oscillation, and his failure to maintain directional control. A factor was the excessive landing airspeed.NTSB FTW98LA367Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Naturita, COPartial loss of engine power resulting from heat induced deterioration of the gas generator turbine. Factors were a forced landing in hilly unsuitable terrain containing mature trees.NTSB FTW98FA372Accident · 3 fatalField investigationFinal reportCessna 175A · Erie, COThe pilot's failure to maintain flying speed (above stall speed) and the subsequent stall/spin. Contributing factors were the tailwind, high density altitude, and aircraft overweight conditions.NTSB CHI98LA329Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lapaz, INthe pilot's inadequate preflight planning which resulted in landing on unsuitable terrain (wet, grass). Factors associated with the accident were the wet grass and the fence.NTSB ATL98LA117Accident · No injuriesLimited investigationFinal reportAir Tractor 401 · Holly Bluff, MSThe malfunction of the carburetor which resulted in improper fuel flow to the engine.NTSB ANC98LA130Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Palmer, AKThe pilot's failure to maintain adequate terrain clearance.NTSB MIA98LA228Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Ruleville, MSA fire of undetermined origin.NTSB LAX98LA274Accident · No injuriesLimited investigationFinal reportRobinson R22B · Ramona, CAThe failure of the pilot to maintain rotor rpm while practicing autorotations and subsequent hard landing and roll over.NTSB LAX98LA273Accident · No injuriesLimited investigationFinal reportBell 206B · Salinas, CAThe failure of the pilot to maintain clearance with the irrigation pipes which resulted in the entanglement of the skids and the subsequent rollover.NTSB IAD98FA097Accident · 1 fatalField investigationFinal reportCessna 182N · Painesville, OHThe pilot's failure to maintain adequate airspeed, while maneuvering back toward the runway resulting in an inadvertent stall. Also causal was the pilot's inadequate preflight inspection which resulted in his failure to secure the oil filler cap. A…NTSB DCA98WA090Accident · No injuriesForeign investigationBritten-Norman BN-2A-26 · San Blas, PanamaNTSB CHI98LA326Accident · No injuriesLimited investigationFinal reportCessna 150B · Lamar, MOinadequate lubrication of the torque plate holes and torque pins by the mechanic who performed the airplane's last annual inspection.NTSB CHI98FA323Accident · 3 fatalField investigationFinal reportBell 222 · Spencer, IAThe below standard (loose) fit of the 'white' swashplate outer ring pin resulting in fatigue and subsequent separation of the pin, and ultimately the in-flight breakup of the rotorcraft. A factor was the manufacturer's dissemination of the pin which did not…NTSB ANC98TA128Accident · No injuriesFinal reportPiper PA-18 · Fairbanks, AKThe pilot's inadequate preflight planning/preparation, and his delay in aborting the takeoff. Factors in the accident were a short runway area for takeoff, trees located at the end of the runway, and the pilot's excessive application of brakes.NTSB FTW98LA368Accident · No injuriesLimited investigationFinal reportMassey Christen Eagle II · Galveston, TXThe inflight structural failure of the wing spars for the lower wings due to an undetermined reason.NTSB FTW98FA365Accident · 1 fatalField investigationFinal reportCessna 150F · Wilton, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall. Factors were the pilot's improper use of flaps during the takeoff climb and the high density altitude.NTSB CHI98LA322Accident · No injuriesLimited investigationFinal reportFairchild 24R-46A · Scribner, NEthe inadvertent ground loop caused by an unknown person who was in the process of stealing the airplane.NTSB ATL98LA118Accident · No injuriesLimited investigationFinal reportPiper PA-30-39 · Greenville, NCA loose wiring connection at the landing gear motor relay that prevented the electrical extension of the landing gear.NTSB NYC98LA170Accident · 1 fatalLimited investigationFinal reportKite Kitfox IV 1200 · Granby, NYThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB LAX98LA270Accident · Serious injuriesLimited investigationFinal reportSilvaire Luscombe 8F · Tucson, AZThe pilot's selection of the wrong runway for the wind conditions, his inadequate compensation for the existing quartering tailwind condition, and, his failure to maintain directional control.NTSB FTW98FA364Accident · Minor injuriesField investigationFinal reportBeech 1900D · Denver, CODebonding of the propeller erosion shield due to an improper overhaul and repair by other maintenance personnel.NTSB ATL98LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe pilot's inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the total loss of engine power. A factor was the pilot continued flight operation with known deficiencies in equipment.NTSB ANC98LA127Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKThe pilot's failure to maintain directional control during takeoff. Factors associated with the accident were soft airstrip conditions, and trees.NTSB ANC98LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Cordova, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was grass covered rocks.NTSB ANC98LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-14 · Chugiak, AKThe loss of engine power for an undetermined reason.NTSB LAX98LA272Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA-20-A1 · Woodland, CAThe pilot's failure during a preflight inspection to detect the damaged propeller from the previous hard landing. The damaged propeller degraded the climb performance capability of the airplane.NTSB LAX98LA271Accident · Minor injuriesLimited investigationFinal reportClark Barnett J4B2 · Marysville, CAThe pilot's inadequate rigging of the rotor blades and rudder, which led to an inability to maintain control of the gryocopter. The pilot's inadequate landing flare in soft terrain, which resulted in a nose low touchdown and subsequent nose over, and, his…NTSB FTW98LA363Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Beeville, TXThe pilot's failure to maintain aircraft control and the ensuing inadvertent stall.NTSB FTW98IA361Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Denver, COA hydraulic failure due to a ruptured hydraulic line, preventing the extension of the nose and right main landing gear.NTSB ATL98FAMS1Accident · 4 fatalMissing aircraftFinal reportPiper PA-28-181 · MissingThe aircraft is missing.NTSB LAX98LA276Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Henderson, NVThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.NTSB LAX98LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZFuel exhaustion due to the pilot's inadequate preflight planning and in-flight monitoring of the aircraft's fuel consumption.NTSB LAX98LA268Accident · No injuriesLimited investigationFinal reportCessna 185 · Susanville, CAThe pilot's failure to maintain directional control. A factor was the gusty wind conditions.NTSB LAX98FA267Accident · Serious injuriesField investigationFinal reportCessna 177 · Los Angeles, CAThe failure of the pilot to accurately determine that an adequate quantity of fuel was aboard the aircraft for the intended flight, and the failure to monitor fuel quantity remaining while en route to ensure an adequate quantity of reserve fuel prior to…NTSB IAD98WA101Accident · 2 fatalForeign investigationCessna 150J · JamaicaNTSB FTW98LA371Accident · No injuriesLimited investigationFinal reportBell 47G · Monette, ARThe pilot's failure to maintain control. A factor was his lack of total flight experience in helicopters.NTSB FTW98LA362Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Houston, TXThe pilot's failure to refuel the helicopter which resulted in the loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB CHI98LA317Accident · No injuriesLimited investigationFinal reportBeech C23 · North Platte, NEthe pilot's not compensating for wind conditions and failure to maintain control of the aircraft. A factor was the crosswind.NTSB NYC98LA169Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Jackson Twnshp, NJThe flight (check pilot) instructor's excessive pull-up maneuver and his inadvertent entry into a low altitude stall/spin.NTSB NYC98LA168Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-1A · Erial, NJCatastrophic failure of the number 2 engine cylinder, emanating from a corrosion pit on the outside cylinder wall. A factor was the pilot's diminished forward visibility due to oil on the windshield.NTSB MIA98LA227Accident · No injuriesLimited investigationFinal reportMooney M-20F · Rockhill, SCThe pilot's inadequate fuel management which led to fuel exhaustion.NTSB LAX98LA266Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Rio Vista, CAFailure of the pilot to adequately compensate for the existing wind condition and maintain directional control on rollout.NTSB IAD98FA095Accident · 3 fatalField investigationFinal reportCessna 152 · Blue Ash, OHthe pilot's inaccurate calculation of the fuel which resulted in exhaustion of fuel and subsequent loss of engine power.NTSB FTW98LA373Accident · No injuriesLimited investigationFinal reportCessna 182L · St. George, UTThe pilot's failure to maintain control of the airplane. Factors were excessive airspeed and allowing the airplane to porpoise with subsequent loss of directional control.