NTSB investigations, 1998
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 ATL99LA018Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hickory, NCThe pilot's failure to properly recover from a bounced landing.NTSB NYC99LA025Accident · 2 fatalLimited investigationFinal reportHorner-Ryan Wichawk · Pine Island, NYThe pilot-in-command's failure to maintain control while maneuvering.NTSB LAX99LA031Accident · No injuriesLimited investigationFinal reportCessna 172N · Lancaster, CAThe failure of the pilot to maintain directional control of the aircraft.NTSB DCA99WA010Accident · No injuriesForeign investigationBoeing 707-355C · Oostend, BelgiumNTSB CHI99LA030Accident · No injuriesLimited investigationFinal reportCessna 172C · Falls City, NEthe flight instructor (on the ground)'s conducting inadequate initial training of the student pilot. Factors were the student pilot's misjudging the flare and his lack of total experience in the type of operation.NTSB CHI99FA029Accident · 1 fatalField investigationFinal reportCessna 182F · Wichita, KSThe pilot's inadequate preflight inspection and contaminated fuel supply.NTSB ATL99FA016Accident · 1 fatalField investigationFinal reportCessna 152 · Daytona Beach, FLAn interior cabin fire of undetermined origin. A factor was the power lines impacted during the emergency descent.NTSB LAX99LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe failure of the flight instructor to provide adequate supervision of the student pilot during a simulated emergency landing.NTSB CHI99LA028Accident · No injuriesLimited investigationFinal reportCessna 172I · Jacksonville, ILthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the student's lack of experience and the road which the airplane contacted.NTSB CHI99LA027Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Monticello, INlow altitude stall and an ostentatious display by the pilot. Factors associated with this accident were the performance of a low altitude maneuver and an abrupt pullup by the pilot.NTSB MIA99LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Coral Springs, FLThe delay by the pilot to obtain proper assistance after becoming lost/disoriented resulting in total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's lack of total experience.NTSB MIA99LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of engine power due to a connecting rod failure for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB LAX99LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Gila Bend, AZThe crankshaft gear attach bolt loosening and backing out of its crankshaft bore, which led to the fatigue failure of the crankshaft gear dowel pin due to excessive working of the gear. The sequence of failures was the result of the engine overhaul shop's…NTSB LAX99FA027Accident · 3 fatalField investigationFinal reportCessna 150L · Yerington, NVthe failure of the pilot to see and avoid the aircraft ahead, which was already established in the traffic pattern. The failure of both pilots announce their intentions on the Common Traffic Advisory Frequency was a factor in this accident.NTSB IAD99LA015Accident · Minor injuriesLimited investigationFinal reportBell 206-B · Louisville, KYA loose 'B' nut on the aircraft's PC Air line which resulted in fuel starvation, and the pilot's abrupt application of aft cyclic to prevent a nose over. Contributing factors were soft terrain and dark night conditions.NTSB SEA99LA014Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-11 · Portland, ORThe flight crew's entry of an incorrect weight figure in the Flight Management System (FMS) computer, resulting in the approach being flown at an improper (low) Vref speed and an excessively nose-high attitude through the landing flare.NTSB MIA99WA029Accident · Serious injuriesForeign investigationBoeing 777-222B · Concepcion, BoliviaNTSB DEN99LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Erie, COThe shorting of the aluminum battery wire and the subsequent failure of the fuel line. Factors were the weak/deteriorated battery, the insufficient information in the airplane's POH about charging an airplane's battery, and the fire in the crew compartment.NTSB DCA99WA022Incident · Minor injuriesForeign investigationSaab-Scania 340 · Melbourne, AustraliaNTSB ATL99LA017Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G164B · Cuthbert, GAThe fatigue failure of the accessory gear shaft which resulted in fuel starvation and the loss of engine power. A factors was the fuel system filter restriction.NTSB ANC99LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kenai, AKThe pilot's failure to use carburetor heat. A factor associated with the accident was weather conducive to carburetor icing.NTSB ANC99FA012Accident · Minor injuriesField investigationFinal reportBoeing 747-400 · Anchorage, AKThe excessive taxi speed by the pilot of the other aircraft. A factor associated with the accident was the other pilot's inadequate maneuver to avoid the parked airplane.NTSB SEA99FA013Accident · 1 fatalField investigationFinal reportHiller UH-12E · Marshall, WAThe loss of the bolt that connects the lateral cyclic linkage push rod to the lower end of the upper firewall-mounted lateral cyclic linkage bellcrank, resulting in an uncontrolled descent into the terrain.NTSB LAX99LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Santa Barbara, CAThe pilot's inadequate compensation for the existing crosswind condition and failure to maintain proper runway alignment during landing flare.NTSB FTW99LA023Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33 · Tulsa, OKThe loss of engine power due to detonation for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99IA024Incident · 1 fatalIncident investigationFinal reportPiper PA-23-235 · Mineral Wells, TXThe pilot-in-command's incapacitation due to cardiovascular disease.NTSB IAD99LA014Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Baltimore, MDAn inadvertent collision with a deer on the runway. A contributing factor was night conditions.NTSB CHI99LA031Accident · Serious injuriesLimited investigationFinal reportCessna 337C · New Hudson, MIthe instructor pilot's not maintaining control of the airplane. A factor was the landing gear doors extended.NTSB ATL99LA014Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Statesboro, GAThe pilot's failure to use carburetor heat. Factors were conditions favorable for the formation of carburetor ice.NTSB ATL99IA015Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Atlanta, GAFailure of the Company's maintenance personnel to follow the aircraft's maintenance manual which resulted in a cargo bin fire. Contributing to the severity of the incident was the failure of the mechanic to safety the circuit breaker, and the cut/severed…NTSB SEA99LA012Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Rainier, WAThe pilot's failure to maintain clearance from objects in the approach path. Factors include the marked wires near the end of the runway.NTSB FTW99FA022Accident · 2 fatalField investigationFinal reportChallenger II · San Antonio, TXThe pilot's inadvertent stall. A factor was the pilot's lack of experience in type of vehicle.NTSB FTW99FA021Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Conroe, TXThe pilot's inadequate in-flight planning/decision which resulted in a loss of engine power due to fuel exhaustion. Factors were the dark night light conditions prevailing for the ensuing forced landing and the pilot's lack of experience in the make and model…NTSB FTW99FA020Accident · 2 fatalField investigationFinal reportBeech B19 · Hobart, OKThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain terrain clearance. Factors were the low ceiling, fog, dark night conditions, and the pilot's failure to obtain a weather briefing prior to the flight.NTSB DEN99LA019Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Belen, NMThe pilot's inadequate preflight planning, resulting in fuel supply exhaustion.NTSB ATL99LA013Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lima, SCThe flight instructor's intentional flight into Instrument Meteorological Conditions. Factors were trees and mountainous terrain.NTSB SEA99LA011Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Auburn, WAA partial loss of engine power due to carburetor ice formation. Factors included insufficient altitude/time available for remedial action, a tail wind during the forced landing attempt, and a fence at the end of the runway.NTSB MIA99LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Lauderdale, FLThe failure of the pilot-in-command to note that the flaps did not retract while the pilot-rated student performed a touch-and-go landing on a 6,001 foot-long runway. Factors in the accident were the total failure of the flap system for undetermined reasons…NTSB MIA99FA031Accident · Minor injuriesField investigationFinal reportPiper PA-28-151 · Chattanooga, TNThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion.NTSB ATL99LA012Accident · No injuriesLimited investigationFinal reportAeroSport WS-15-2 · Parkton, NCThe collapse of the carburetor heat box hose which starved the carburetor of air resulting in a partial loss of power, forced landing and nose over. Factors were the weeds and stocky stubble in the forced landing zone.NTSB SEA99TA010Accident · 2 fatalFinal reportCessna TR182 · Desert Aire, WAThe pilot's failure to maintain adequate altitude and/or clearance over a power line crossing the river, resulting in collision with a static wire at the top of the crossing structure. Factors included the static wire, and inadequate marking of the static…NTSB NYC99IA024Incident · No injuriesIncident investigationFinal reportBoeing 737-3TO · Newark, NJA loss of torque on the apex nut of the shimmy damper for undetermined reason(s), which resulted in a failure of the shimmy damper, and the subsequent failure of the lower torsion link of the right main landing gear.NTSB LAX99FA028Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Bishop, CAThe failure of the pilot-in-command, after encountering a downdraft, to maneuver and maintain clearance from mountainous terrain. Physical impairment due to hypoxia was a factor in the accident.NTSB CHI99LA026Accident · No injuriesLimited investigationFinal reportTomschin Mini 500 · Clinton, MNthe non-pilot's failure to maintain clearance from the power lines. Factors contributing to this accident were the non-pilot's lack of total experience and the power lines.NTSB CHI99LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Liberty, MOThe excessive rotation by the pilot-in-command. The climb not obtained by the pilot-in-command, the fence and the trees were contributing factors.NTSB ATL99LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · Winnsboro, SCThe pilot's improper landing flare that resulted in overload damage to the nose wheel assembly.NTSB LAX99LA025Accident · No injuriesLimited investigationFinal reportde Havilland Tiger Moth DH 82A · Petaluma, CAFailure of the pilot in the Tiger Moth to see and avoid traffic. A contributing factor was the delayed reaction of the student pilot in the Cessna to initiate a turnoff of the taxiway once it became apparent that the other airplane did not see him.NTSB IAD99LA017Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-C · Caldwell, NJThe pilot-in-command's failure to maintain directional control resulting in a ground-loop.NTSB DCA99WA009Incident · No injuriesForeign investigationBeech 1900C · Luxeuil, FranceNTSB CHI99LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Warrensburg, MOthe student pilot's inadequate flare and his failure to maintain directional control of the airplane. Factors associated with the accident were, the student's lack of total experience and the dirt bank which was contacted.