NTSB investigations, 1998
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 NYC99LA016Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Oneonta, NYThe pilot's improper flare which resulted in a hard landing. A factor in the accident was the crosswind condition.NTSB NYC99FA015Accident · 1 fatalField investigationFinal reportCessna 172N · Linden, NJThe pilot's failure to maintain clearance from the power lines. A factor was sunglare.NTSB MIA99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chamblee, GAThe pilot's excessive use of right wheel brake to correct for a left drift during landing rollout resulting in a ground loop to the right and the left wing contacting the runway.NTSB MIA99LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's failure to maintain directional control on takeoff, resulting in the airplane's excursion off the runway and collision with trees.NTSB MIA99FA012Accident · Minor injuriesField investigationFinal reportAerospatiale ATR-42-300 · San Juan, PRThe pilot's failure to verify that the parking brake was applied prior to engine start, and the resultant inadvertent movement of the aircraft and collision with the ground power cart once No. 2 was started.NTSB LAX99LA015Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Palmdale, CAThe pilot's improper management of his fuel supply which resulted in fuel starvation. Factors in the accident were the inadequate annual inspection which resulted in fuel siphoning, and a high reading fuel gage.NTSB NYC99LA017Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103-TWINA · Saratoga Spring, NYThe pilot's failure to maintain control of the glider while landing.NTSB MIA99LA015Accident · No injuriesLimited investigationFinal reportPeters Strojnik S2A · Pensacola, FLThe aircraft's uncontrolled climb after encountering a wind gust or thermal during landing flare without engine power resulting in the pilot having to force the aircraft onto the runway making a hard landing prior to the end of the runway.NTSB LAX99LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Reno, NVThe pilot's disregard for five weather briefings and his attempted flight into known adverse weather conditions.NTSB CHI99LA012Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Clinton, IAthe failure of the 90 degree gearbox for reasons undetermined. Factors were the failure of the gearbox, and it not being possible for the pilot to maintain control of the aircraft.NTSB SEA99LA009Accident · No injuriesLimited investigationFinal reportPitts S-1 · Mccall, IDThe pilot-in-command's failure to maintain directional control. Contributing factors were the uneven taxiway, inadequate airport maintenance (temporary threshold marking) by the airport management, and a ditch alongside the taxiway.NTSB SEA99LA006Accident · No injuriesLimited investigationFinal reportCessna 172G · Vancouver, WARefueling was not preformed which subsequently led to fuel exhaustion. Factors include the student pilot's inadequate preflight planing/preparation.NTSB SEA99GA007Accident · 1 fatalFinal reportCessna 182P · Deming, WATerrain clearance was not maintained for undetermined reasons. Mountainous terrain was a factor.NTSB MIA99LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Lawrenceville, GAA fire from an undetermined origin.NTSB FTW99FA016Accident · 1 fatalField investigationFinal reportKolb Twinstar TA-2 · Bryan, TXThe pilot's loss of control as result of the partial separation of the elevator trim tab resulting in the inability to maintain aircraft control. A factor was the improper design and installation of the elevator trim tab.NTSB SEA99LA005Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Scappoose, ORAircraft control was not maintained. Inadequate remedial action is a factor.NTSB CHI99LA011Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pound, WIthe pilot misjudged the proper touchdown point and subsequently landed short of the runway. Factors associated with the accident were the haze, sunglare, the lack of visual perception, and the uphill terrain on which the airplane touched down.NTSB CHI99LA010Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Duluth, MNThe inadequate airspeed by the pilot-in-command. Contributing factors were the gusts and the trees.NTSB ANC99WA010Accident · Minor injuriesForeign investigationPiper J3C-65 · Watson Lake, CanadaNTSB NYC99LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Mattituck, NYThe pilot's failure to maintain the airplane's directional control during a go-around.NTSB LAX99IA013Incident · No injuriesIncident investigationFinal reportBoeing MD-11 · Honolulu, HIA jammed spoiler control pulley system caused by a shop rag left in an area of recent maintenance. Neither the maintenance organization nor the mechanic responsible could be determined.NTSB DEN99LA015Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Englewood, COThe undertorquing of the camshaft gear retaining bolts during engine overhaul by maintenance personnel. A factor was the unsuitable terrain for a forced landing.NTSB SEA99LA004Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.NTSB IAD99LA011Accident · No injuriesLimited investigationFinal reportRyan NAVION-A · East Moriches, NYThe student pilot's failure to maintain adequate airspeed and the certified flight instructor's inadequate supervision.NTSB DEN99LA014Accident · No injuriesLimited investigationFinal reportBeech B200 · Rio Rancho, NMThe pilot's inadequate preflight of the aircraft, resulting in fuel supply exhaustion.NTSB DCA99WA008Incident · No injuriesForeign investigationBoeing 727 · Point A Pitre, FranceNTSB DCA99WA005Accident · No injuriesForeign investigationBell 407 · Salta, ArgentinaNTSB MIA99LA020Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Jackson, MSThe pilot's failure to ensure the landing gear was down resulting in a wheels up landing.NTSB FTW99LA014Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Farmerville, LAThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate preflight. Factors were the pilot's failure to verify the refueling of the airplane and the lack of suitable terrain for the forced landing.NTSB DEN99TA013Accident · No injuriesFinal reportAir Tractor AT-400 · Aztec, NMThe pilot's inadequate preflight inspection of the airplane. Factors were the unsecured oil dipstick, the loss of engine oil pressure necessitating a precautionary landing on unsuitable terrain, and the collision with the tree.NTSB DEN99FA012Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Buffalo, WYThe non-instrument rated pilot's initiated flight into adverse weather conditions and inadvertently flew into IMC weather conditions. Factors were the low ceiling weather conditions, the dark night light conditions, and a non operating VOR navigational aid.NTSB LAX99LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe pilot's failure to maintain clearance between the airplane's wing and a parked fuel truck.NTSB FTW99LA012Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Eagle Pass, TXA downdraft, which exceeded the aircraft's climb performance. A factor was the thunderstorms in the vicinity of the airport.NTSB FTW99LA010Accident · No injuriesLimited investigationFinal reportMooney M20A · Oklahoma City, OKThe loss of engine power due to fuel starvation as result of the pilot's improper placement of the fuel tank selector switch. A factor was the lack of suitable terrain for the pilot to execute the forced landing.NTSB ANC99LA007Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Chitina, AKThe pilot's inadequate preflight which failed to detect water contamination in the fuel system. A factor was the unsuitable terrain in the emergency landing area.NTSB SEA99LA003Accident · Minor injuriesLimited investigationFinal reportBeech 99 · Missoula, MTThe pilot-in-command's delayed remedial action in response to the co-pilot's improper landing flare, and the co-pilot's application of excessive (full nose-up) trim during the landing flare as taught in the operator's initial aircrew training program. Factors…NTSB LAX99LA011Accident · 3 fatalLimited investigationFinal reportPiper PA-28-181 · Shelter Cove, CAThe pilot's excessive airspeed, failure to attain the proper touchdown point, and the delayed decision to initiate a go-around.NTSB FTW99LA013Accident · Minor injuriesLimited investigationFinal reportBeech 65-A90 · Russellville, ARThe pilot's failure to maintain clearance with the ground due to the pilot's improper use of the flaps and the ensuing inadvertent descent. Factors were the dark night conditions, the pilot's diverted attention, and the foggy windshield.NTSB CHI99LA008Accident · Minor injuriesLimited investigationFinal reportBeech 65-B80 · Brainerd, MNthe pilot's failure to maintain the proper glidepath and his diversion of attention during a critical phase of flight.NTSB FTW99LA009Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Conroe, TXThe pilot's failure to maintain clearance with trees. Factors were the fogged front windshield and side windows.NTSB ANC99LA006Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2A · English Bay, AKThe pilot-in-command's inadequate compensation for the crosswind conditions, and failure to maintain adequate clearance from the parked airplane. Factors associated with this accident were the gusty crosswinds, and the congested takeoff area due to no parking…NTSB NYC99LA011Accident · No injuriesLimited investigationFinal reportZeidler Sonerai II · Kenton, OHThe pilot's premature rotation and failure to obtain/maintain airspeed during the takeoff, which resulted in a stall and impact with the ground. Factors in this accident were the pilot's lack of total experience in tail-wheeled aircraft, and the nose high…NTSB MIA99LA011Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Statesboro, GAThe pilot's decision to attempt a flight with an unairworthy condition (leaky brake) and improper use of brakes on landing rollout. This resulted in a loss of brake fluid, directional control, ground loop, and on ground collision with terrain.NTSB ANC99LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions. Factors associated with the accident were a crosswind, and loose gavel.NTSB MIA99LA010Accident · No injuriesLimited investigationFinal reportBeech C-90 · Meridian, MSThe pilot's inadvertent activation of the landing gear control handle during an attempted go-around, resulting in the retraction of the landing gear and subsequent on ground collision with terrain.NTSB MIA99LA009Accident · No injuriesLimited investigationFinal reportPiper PA-32RT · Vidalia, GAThe pilot's inadequate preflight planning by which he failed to obtain NOTAM information, and his failure to identify an hazardous/unsafe condition on the runway.NTSB MIA99LA008Accident · 1 fatalLimited investigationFinal reportRyan ST3KR · Rossville, TNThe failure of the pilot to maintain airspeed (VSO) while maneuvering in a recovery from a spin.NTSB MIA99LA007Accident · No injuriesLimited investigationFinal reportAyres S2R · Frisco City, ALThe pilot's failure to maintain airspeed on climb out resulting in an inadvertent stall, and subsequent in-flight collision with terrain.NTSB IAD99LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Dunkirk, NYThe pilot's inadequate fuel management that resulted in fuel starvation. Factors in the accident were the improperly timed magneto and an engine driven fuel pump leak.NTSB NYC99WA243Accident · No injuriesForeign investigationSchweizer 269C · Reggio Calabria, Italy