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 CHI99FA023Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-60 · Rock, KSthe pilot failed to maintain control of the aircraft and made an improper evaluation of the weather. Additional factors were flying a test flight at night with the icing conditions in the clouds.NTSB MIA99LA026Accident · 1 fatalLimited investigationFinal reportSaab-Scania 340A · Memphis, TNThe ground crewmembers inadvertent walking into the path of a rotating propeller resulting in her being struck and fatally injured.NTSB LAX99LA024Accident · 1 fatalLimited investigationFinal reportCessna T210L · Lodi, CAFuel exhaustion due to a leaking engine driven fuel pump nose seal, which increased the engine fuel consumption rate above the published performance chart values.NTSB LAX99LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Mammoth, CAThe pilot's failure to ensure that the autopilot was off prior to takeoff, and, his failure to maintain pitch control during the resultant pitch trim excursion during the takeoff ground roll.NTSB IAD99GA013Accident · 1 fatalFinal reportSchweizer 269C · Baltimore, MDinadequate assembly instructions from the engine manufacturer which resulted in improper engine assembly, and subsequent power loss over unsuitable terrain, with insufficient altitude for a successful autorotation.NTSB CHI99LA022Accident · No injuriesLimited investigationFinal reportMooney M20J · Cahokia, ILthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the quartering tailwind and the ditch that the airplane contacted.NTSB ATL99FA136Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Robbinsville, NC"This case was changed from ATL05FA014." The pilot's improper in-flight decision to continue VFR flight into IMC, which resulted in an in-flight encounter with weather and controlled flight into terrain. Factors were the pilot's inadequate preflight planning…NTSB NYC99LA022Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYThe driver's failure to maintain control of the belt loader. A factor in the accident was the precipitation which may have contributed to the driver's foot slipping off the brake and onto the accelerator, as he approached the airplane.NTSB LAX99LA022Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Pioche, NVThe loss of tail rotor effectiveness, due to the installation of incorrect pitch links by the maintenance facility. A factor in the accident was the lack of an adequate quality assurance program in the maintenance facility.NTSB IAD99LA012Accident · No injuriesLimited investigationFinal reportPitcairn RAF 2000 · Doylestown, PAThe pilot's inadequate compensation for wind conditions and his inadequate recovery from a bounced landing. Contributing to the accident were the pilot's fatigue and the crosswind conditions.NTSB FTW99LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Tomball, TXThe student pilot's failure to maintain directional control of the airplane.NTSB CHI99LA020Accident · 1 fatalLimited investigationFinal reportBecker Wag Aero Super Sport · Hamilton, NDthe fatigue failure of the lower wing strut attachment bracket.NTSB ANC99LA011Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Willow, AKA loss of engine power due to an undetermined reason. A factor associated with the accident was unsuitable terrain for a forced landing.NTSB MIA99FA027Accident · 2 fatalField investigationFinal reportCessna C-182Q · Piedmont, ALThe pilot's decision to continue the flight under visual flight rules into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.NTSB LAX99LA021Accident · No injuriesLimited investigationFinal reportCessna 185E · Tucson, AZFailure of the pilot to properly secure the seat which subsequently slid back on the takeoff roll and lead to the pilot's loss of aircraft control.NTSB FTW99FA018Accident · 1 fatalField investigationFinal reportMorrisey Rutan Long EZE · Alvin, TXLoss of engine power for undetermined reasons.NTSB CHI99LA016Accident · Minor injuriesLimited investigationFinal reportCessna 310I · Janesville, WIThe pilot's inadequate preflight inspection in which he failed to remove the tow bar from the nose gear. Also causal was his misjudgment of distance and altitude from the runway which resulted in both his premature shutdown of the engines and an undershoot of…NTSB MIA99WA023Accident · 11 fatalForeign investigationDouglas DC3C · Quetzaltenanang, GuatemalaNTSB MIA99LA022Accident · 1 fatalLimited investigationFinal reportFerguson Rans S-10 Sakota · Pisgah, MSThe pilot's failure to maintain aircraft control during a low altitude maneuver resulting in the aircraft's uncontrollable descent until impact with the terrain.NTSB DEN99LA017Accident · No injuriesLimited investigationFinal reportCessna 182A · Bedford, WYThe pilot's failure to identify a soft area on his newly constructed airstrip, which subsequently caused his airplane to nose over.NTSB DCA99MA007Accident · Minor injuriesMajor investigationFinal reportBoeing 737-200 · Atlanta, GA(1) the capping of the incorrect hydraulic line by mechanics, which led to the failure of hydraulic system A; (2) the mechanics' lack of experience working with the Boeing 737 hydraulic system; and (3) the maintenance controller's failure to ascertain more…NTSB CHI99LA019Accident · No injuriesLimited investigationFinal reportCessna 310R · Wichita, KSthe pilot's inadequate compensation for the wind conditions and the inadequate recovery from the bounced landing which resulted in a loss of control and the ground loop. Factors associated with the accident were the pilot's misjudging the winds conditions and…NTSB CHI99LA018Accident · No injuriesLimited investigationFinal reportCessna 172 · Creve Coeur, MOthe pilot misjudged his altitude and airspeed during landing. A related factor was the dark night conditions.NTSB CHI99LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-150 · Mason, MIwas the pilot not maintaining control of the airplane. A factor in this accident was the pilots lack of total experience in the airplane.NTSB MIA99WA024Accident · 6 fatalForeign investigationAerospatiale Alouette 3 · Santa Cruz, BoliviaNTSB MIA99LA025Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Hartselle, ALImproper modification of the carburetor float by maintenance personnel resulting in the float sticking in the full needle valve open position and failure of the engine due to excessive fuel flow.NTSB MIA99LA021Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLThe student pilot's improper landing flare resulting in a hard landing and ground loop.NTSB LAX99LA019Accident · 1 fatalLimited investigationFinal reportCessna 182Q · Fresno, CAThe pilot's decision to allow unescorted passengers to approach the aircraft with the engine running, and, the passenger's failure to see and avoid the rotating propeller. A factor in the accident was the low ambient lighting conditions, which would have made…NTSB CHI99LA021Accident · Minor injuriesLimited investigationFinal reportJordan Acey Deucy P70 · Ava, MOthe pilot's attempted operation of the airplane with known deficiencies, and his not obtaining control of the airplane in flight. A factor was asymmetrical ailerons.NTSB CHI99LA014Accident · No injuriesLimited investigationFinal reportCessna 182 · Weeping Water, NEthe pilot failed to maintain directional control. A factor was the uneven runway condition.NTSB NYC99LA020Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · West Chester, PAThe pilot's failure to obtain/maintain the proper airspeed during the landing, and failure to perform a go-around. A factor in the accident was the crosswind conditions.NTSB LAX99FA020Accident · 3 fatalField investigationFinal reportCessna 182Q · Nixon, NVThe noninstrument rated pilot's failure to maintain control of the airplane during an attempted flight into adverse weather which resulted in inadvertent VFR flight into instrument meteorological conditions. Factors in the accident were the pilot's failure to…NTSB FTW99LA017Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5A · Scott, ARThe disengagement of the crankshaft gear due to the maintenance personnel not installing the gear lockplate at the last engine overhaul, resulting in the loosening of the gear retaining bolt, and the subsequent fracture of the gear alignment dowel. A factor…NTSB DEN99LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA28-181 · Tooele, UTThe pilot's VFR flight into IMC and his failure to maintain adequate terrain clearance. Contributng factors were fog, low ceilings, high terrain, the pilot's lack of familiarity with the geographic environment and his misinterpretation of terrain features on…NTSB CHI99LA013Accident · 1 fatalLimited investigationFinal reportC.B. Withun T-BIRD II · New Haven, MIthe improper installation of the propeller by the owner/pilot- mechanic and the pilot not maintaining the airplane's airspeed while approaching the trees along the airplane's flight path. A factor in this accident was the stall encountered by the pilot.NTSB MIA99LA019Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Douglasville, GAFailure of the no. 1 cylinder exhaust valve guide due to erosion, which resulted in separation of the exhaust valve head, loss of engine power, and collision with a power pole during a forced landing on unsuitable terrain.NTSB DEN99FA016Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hayden, COThe pilot not following instrument procedures and subsequently descended to minimums prematurely. Factors were the mountainous terrain and the falling snow.NTSB ATL99FA011Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Roswell, GAA loss of engine power due to the failure of the number five connecting rod assembly as a result of fatigue cracks that were initiated in areas of galling. A factor was the lack of suitable terrain for a forced landing.NTSB MIA99LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Cartersville, GAFailure of the student pilot to maintain directional control during landing resulting in the aircraft running off the left side of the runway and colliding with a parked aircraft. Factors in the accident were his distraction while raising wing flaps during…NTSB MIA99LA016Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Ormond Beach, FLThe pilot's failure to maintain Vmc speed, which resulted in a loss of control, and his improper operation of the throttle given the known full rich operating condition of the left engine. A sand-contaminated fuel control was a contributing factor.NTSB LAX99LA018Accident · No injuriesLimited investigationFinal reportBeech C90 · Sedona, AZThe instructor's failure to maintain runway alignment during the takeoff roll.NTSB IAD99FA008Accident · Minor injuriesField investigationFinal reportLearjet 45 · Wallops Island, VAThe failure of the pilot to obtain/maintain alignment with the water pool, which resulted in the loss of control. Factors in the accident were the inadequate preflight planning of the flight test facility and the airplane manufacturer which resulted in…NTSB SEA99LA008Accident · No injuriesLimited investigationFinal reportCessna 172K · Dillon, MTThe student pilot-in-command's failure to maintain directional control. Contributing factors were rough terrain and crosswind conditions.NTSB NYC99LA018Accident · No injuriesLimited investigationFinal reportAero Commander AC-100 · Bridgeton, NJThe pilot's failure to properly flare the airplane at touchdown.NTSB MIA99LA017Accident · No injuriesLimited investigationFinal reportReinhold Revolution Mini 500 · Hickory, NCThe seizure of the rear piston in the cylinder barrel resulting in total loss of engine power and an autorotation which resulted in main rotor contact with the tail boom while touching down on unsuitable terrain.NTSB LAX99LA016Accident · No injuriesLimited investigationFinal reportCessna 208B · Lahaina, HIStructural failure of the main landing gear strut due to metallurgical fatigue. The fatigue cracks originated at an internal structural flaw placed in the part during manufacture.NTSB CHI99LA015Accident · No injuriesLimited investigationFinal reportCessna 195 · Rugby, NDthe pilot failed to maintain directional control.NTSB ANC99LA009Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Aniak, AKA loss of engine power due to fuel contamination. A factor in the accident was unsuitable terrain for a forced landing.NTSB ANC99LA008Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Noorvik, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were a dark night and low ceilings.NTSB NYC99LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Cumberland, MDThe pilot's decision to land, instead of performing a go-around.