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 MIA98LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Leesburg, FLThe pilot's decision to leave the engine running with no one at the controls as he exited the aircraft to check for wheel chocks in place. This resulted in the aircraft moving uncontrolled and eventually colliding with a fence.NTSB CHI98FA356Accident · 2 fatalField investigationFinal reportCessna 310R · Seymour Twp., WIthe pilots of both airplanes not maintaining visual separation from the other airplane.NTSB ANC98LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's selection of an unsuitable area for takeoff. A factor associated with the accident is the pilot's premature liftoff.NTSB ANC98LA134Accident · No injuriesLimited investigationFinal reportCessna 185E · Talkeetna, AKThe pilot's failure to maintain directional control resulting in a inadvertent ground loop. A contributing factor was the induced pressure on the pilot by a sick passenger.NTSB NYC98LA175Accident · Minor injuriesLimited investigationFinal reportStubler Taylor Titch · Lock Haven, PAThe pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's decision to use his left hand to actuate the flap handle located on the right side of the cockpit, while on final and over the runway.NTSB MIA98LA232Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Daytona Beach, FLThe dual-student's attempt to perform a go-around after a reported loss of power in the left engine during landing flare and his failure to relinquish the controls to the instructor when control was lost during the go-around resulting in the aircraft rolling…NTSB FTW98LA414Accident · No injuriesLimited investigationFinal reportPitts S-2B · Sherman, TXThe failure of the pilot in command to maintain directional control of the airplane during the landing flare. A factor was the gusty, crosswind condition.NTSB DCA98MA084Accident · No injuriesMajor investigationFinal reportBoeing 727-200 · Jamaica, NYThe failure of the right main landing gear caused by fatigue cracking and stress corrosion cracking of the trunnion bearing support fitting.NTSB MIA98LA236Accident · No injuriesLimited investigationFinal reportHall Revolution Mini 500 · Hattiesburg, MSThe failure of the pilot to maintain main rotor rpm during a forward hover and the cyclic grip separating during the resultant bounced landing resulting in the pilot losing cyclic control and the main rotor contacting the tail boom. A factor in the accident…NTSB MIA98LA233Accident · No injuriesLimited investigationFinal reportCessna 172F · Spring Hill, FLThe pilot's misjudgment of distance and his delay in initiating a go around. Contributing was the pilot's improper landing flare.NTSB IAD98LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Dayton, OHthe pilot's inadequate recovery from a bounced landing.NTSB CHI98LA346Accident · No injuriesLimited investigationFinal reportNeedham Glastar · Allison, IAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB ANC98LA137Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chugiak, AKThe pilot's inadvertent ground loop of the airplane during the landing roll.NTSB ANC98LA132Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe pilot's inadvertent ground loop/swerve. A factor associated with the accident was the pilot's inadequate recovery from a bounced landing.NTSB MIA98LA231Accident · Minor injuriesLimited investigationFinal reportBibb RV-4 · Chapel Hill, NCThe failure of the pilot to ensure the aircraft contained adequate fuel to complete the flight resulting in loss of engine power due to fuel exhaustion.NTSB MIA98LA230Accident · No injuriesLimited investigationFinal reportBell 47D1 · Dawson, GAThe pilot's selection of unsuitable terrain for landing resulting in debris being blown up during landing resulting in damage to the tail rotor and loss of control.NTSB LAX98LA285Accident · No injuriesLimited investigationFinal reportMohr EAA Biplane P · Gilroy, CAFailure of the pilot to adequately compensate for the existing crosswind.NTSB LAX98LA279Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Big Bear, CAThe pilot's encounter with an unfavorable wind condition, which caused the aircraft to descend at a rate that exceeded the aircraft's climb capability.NTSB IAD98LA105Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Freehold, NJThe passenger's failure to secure himself during landing.NTSB IAD98FA103Accident · 2 fatalField investigationFinal reportBeech T-34B · Quantico, VAThe failure of the flight instructor to maintain airspeed which resulted in an inadvertent stall/spin.NTSB FTW98LA381Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Mineola, TXThe flight instructor's failure to maintain clearance from the fence post. A factor was the flight instructor's delay in taking remedial action to remedy the student's improper glidepath.NTSB FTW98FA378Accident · 2 fatalField investigationFinal reportMooney M20F · Fort Collins, COThe pilot's inadvertent stall/mush due to his excessive angle of bank during his traffic pattern turn to base. Factors were the pilot's improper downwind altitude, the pilot not properly setting his Kollsman Window in his altimeter, and the high density…NTSB FTW98FA377Accident · 2 fatalField investigationFinal reportJodel F11-3 · Beeville, TXThe failure of the pilot-in-command to maintain obstacle clearance during an intentional low altitude maneuver.NTSB NYC98LA176Accident · No injuriesLimited investigationFinal reportCessna 182Q · Bingham, METhe pilot's inattention to changing wind conditions, and lack of correction for the change. A factor in the accident was the damp grass runway.NTSB MIA98LA257Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Opa Locka, FLThe pilot's improper remedial action in recovering from a bounced landing resulting in a stall, and his incorrect recovery from a pilot induced oscillation (PIO) condition. A factor was the pilot's failure to execute a timely go-around maneuver.NTSB FTW98LA379Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lamar, COThe pilot's failure to maintain climb airspeed, and inadvertently allowing the airplane to stall/mush. A factor was the embankment.NTSB FTW98FA376Accident · Serious injuriesField investigationFinal reportDassault Falcon DA-20 · El Paso, TXThe captain's decision to abort the takeoff at an airspeed above V1, which resulted in a runway overrun. Contributing factors were: the loading of an excessive amout of cargo by the shipper which resulted in an over gross weight airplane, the high density…NTSB DCA98WA083Incident · No injuriesForeign investigationAirbus Industrie 319 · Calcutta, IndiaNTSB CHI98LA355Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · N. Ottawa Twp., MNA loss of engine power due to a worn piston ring. A related factor was the owner exceeded the manufacturer's recommended engine overhaul.NTSB CHI98LA342Accident · No injuriesLimited investigationFinal reportMBB BK-117 · Topeka, KSthe pilot's failure to assure the engine cowling was secured during the aircraft preflight which resulted in the cowling separating from the helicopter and damaging the main rotor and tail rotor system. Factors associated with the accident were the cowling…NTSB CHI98LA330Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sault Ste Marie, MIthe pilot's failure to maintain clearance between the airplane and the runway marker. A factor contributing to this accident was the runway marker.NTSB CHI98FA343Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Beaver Dam, WIThe continued flight into adverse weather conditions and aircraft control not maintained by the pilot-in-command. Contributing factors were the improper preflight planning/preparation and lack of certification by the pilot-in-command in addition to the…NTSB ANC98LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Arctic Village, AKThe pilot's delayed action to abort the landing. Factors associated with the accident were a tail wind, and rising terrain.NTSB SEA98LA172Accident · No injuriesLimited investigationFinal reportBeech V35B · Sagle, IDThe pilot's inadequate in-flight planning/decision which led to fuel starvation.NTSB LAX98TA278Accident · No injuriesFinal reportAerospatiale SA316B · Porterville, CAThe pilot's failure to maintain adequate in-flight clearance between the bucket and trees resulting in the entanglement/separation of the long line and subsequent impact with and separation of the tail rotor assembly. A factor was the trees.NTSB CHI98LA341Accident · No injuriesLimited investigationFinal reportCessna 210D · Sturgis, MIthe cracked left main landing gear saddle, resulting in the pilot's inability to get the gear into the down and locked position.NTSB SEA98LA171Accident · No injuriesLimited investigationFinal reportDornbos BD-4 · Kent, WADirectional control was not maintained by the pilot in command.NTSB SEA98FA170Accident · 1 fatalField investigationFinal reportCessna 172L · Anacortes, WATerrain clearance was not maintained. A low ceiling and the pilot's inadequate in-flight planning/decision were factors.NTSB NYC98LA173Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Duncannon, PAThe pilot's disregard of the fuel condition during the preflight which resulted in a takeoff with contaminated fuel and a loss of power. A factor was the pilot's lack of recent experience.NTSB CHI98LA345Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Grosse Ile, MIthe pilot in command (CFI)'s diverted attention and his failure to select landing gear extension.NTSB NYC98LA172Accident · No injuriesLimited investigationFinal reportEkstrom-Farrington Twinstar · Paducah, KYFailure of a through-bolt that attached the lateral control arms to the yoke assembly, due to unanticipated rotor brake forces through the flight control system.NTSB IAD98LA102Accident · No injuriesLimited investigationFinal reportCessna 185 · Westport, MAThe flight instructor's failure to maintain control of the airplane and his delayed decision to go-around. Factors related to the accident were the flight instructor's improper inflight decision to land downwind and his inadequate compensation for wind.NTSB ATL98LA121Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Colquitt, GAThe pilot's inadequate visual lookout, and his failure to maintain adequate clearance of known equipment, resulted in the collision with the field irrigation system.NTSB ATL98LA120Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Sewanee, TNThe inadequate visual lookout by the ground pedestrian. A factor was dark night conditions.NTSB NYC98LA174Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Middlesboro, KYThe pilot's misjudgment of distance and speed, which resulted in runway overrun into a grass area where the gear collapsed. The tailwind was a contributing factor.NTSB ATL98LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Athens, GAThe student pilot's failure to maintain directional control during land roll out that resulted in the on ground collision.NTSB ANC98LA136Accident · No injuriesLimited investigationFinal reportCessna 170A · North Pole, AKThe student pilot's inadvertent ground loop/swerve during the landing roll.NTSB NYC98LA171Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Marston Mills, MAThe pilot's improper landing flare and his delayed go-around.NTSB MIA98FA229Accident · No injuriesField investigationFinal reportBell 47G-4A · Carrollton, ALThe pilots failure to follow written instructions in the flight manual for an engine failure, and the improper use of flight controls (cyclic/collective) during an autorotation resulting in a hard landing, and collision of the main rotor blades with the…NTSB FTW98LA366Accident · No injuriesLimited investigationFinal reportCessna 152 · Garland, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.