NTSB investigations, 1990
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\") = 1990 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") = 1990 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 LAX90LA286Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Vacaville, CAFailure of the pilot to maintain adequate altitude resulting in an inflight encounter with an unfavorable wind at a low altitude in a hilly terrain.NTSB CHI90LA229Accident · No injuriesLimited investigationFinal reportCessna U206A · Fishers, INPilot-in-command's failure to accomplish a recovery from a bounced landing which resulted in a porpoise and collapse of the nose gear.NTSB CHI90DTG04Accident · No injuriesFinal reportPiper PA-25-235 · Parshall, NDImproper use of powerplant controls.NTSB ATL90LA159Accident · No injuriesLimited investigationFinal reportCessna 172 · Ridge Spring, SCThe failure of the maintenance facility/owner to follow standard preventive maintenance procedures. A factor was the pilot's failure to extend the flaps during the forced landing.NTSB SEA90LA162Accident · 1 fatalLimited investigationFinal reportVaden SA102 Cavalier · Tumwater, WAThe pilot's failure to maintain airspeed during takeoff following an engine loss of power. The reason for the loss of power was not determined.NTSB SEA90IA161Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Belgrade, MTThe malfunction of the starter control valve.NTSB SEA90FA163Accident · 1 fatalField investigationFinal reportCessna A185F · Wrangell, AKThe pilot did not maintain an adequate airspeed. The pilot's lack of recent experience in the Cessna 185 was a contributing factor.NTSB NYC90LA190Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Burlington, CTThe CFI failed to maintain a safe sink rate resulting in an undershoot of the runway.NTSB LAX90LA285Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DC-65 · Morgan Hill, CAFuel exhaustion, due the certified flight instructors improper preflight inspection.NTSB DCA90WA045Accident · Serious injuriesForeign investigationAirbus Industrie A-310 · Paris, FranceNTSB CHI90LA227Accident · Minor injuriesLimited investigationFinal reportBeech BE 95 · Faribault, MNThe pilot's improper inflight decision and his improper execution of the chosen emergency procedure.NTSB CHI90LA226Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-150 · Minden, NEA stall encountered because of aircraft control not maintained by the PIC. Factors were a partial powerplant failure due to carburetor icing conditions, carburetor heat not used by the PIC, and load jettison not performed by the PIC.NTSB CHI90DER06Accident · 1 fatalFinal reportMooney M20C · Webster, WIThe pilot's failure to maintain control of the airplane. Factors related to the accident were: the dark night, the pilot's alcohol impairment, and his night flying restriction.NTSB ANC90LA190Accident · 2 fatalLimited investigationFinal reportPiper PA-12 · Cathedral Rapid, AKThe pilot's failure to maintain adequate altitude above the terrain which resulted in a loss of airspeed and a stall/spin while maneuvering to avoid terrain. The mountainous terrain, high winds, and high density altitude were factors which contributed to the…NTSB ANC90LA143Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Aniak, AKPilot lost control of the airplane as a result of encountering severe weather either during takeoff or landing. Contributing to the accident was the severe weather, rough water surface, and self-induced pressure to fly by the pilot.NTSB ANC90LA141Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Gustavus, AKThe pilot's failure to maintain directional control during the landing roll.NTSB ANC90FA142Accident · No injuriesField investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor ran the right tank dry. Contributing to the accident were improper in-flight planning and decisions.NTSB SEA90LA160Accident · No injuriesLimited investigationFinal reportAlfred Stevens KEN Rand KR-2 · Ellensburg, WAThe pilot did not maintain a proper altitude above the terrain or visual lookout which resulted in a collision with a transmission wire.NTSB MIA90LA169Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greenville, MSThe partial loss of engine power for an unknown reason.NTSB MIA90FA168Accident · 2 fatalField investigationFinal reportErco 415-C · Huntersville, NCFailure of the pilot in command to maintain airspeed.NTSB LAX90LA287Accident · No injuriesLimited investigationFinal reportCessna 172P · Coalinga, CAThe failure of the student pilot to accurately interpret the wind sock, and his inadvertent attempt to perform a downwind landing.NTSB LAX90LA284Accident · No injuriesLimited investigationFinal reportMooney M20C · Lodi, CAThe pilot to continue his flight with a unresolved deficiency in the aircraft powerplant resulting in total failure of the powerplant.NTSB DEN90LA169Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bingham, NMThe fuel exhaustion induced power loss. Factors were the pilot's failure to refuel and the unsuitable terrain in which the forced landing was performed.NTSB CHI90LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Greenwood, INThe pilot misjudged the landing flare and the airplane stalled and landed hard.NTSB ATL90FA158Accident · 2 fatalField investigationFinal reportNorth American T-6G · Locust Grove, GAThe pilot-in-command's failure to maintain aircraft control during maneuvering flight, allowing the airplane to stall without sufficient altitude for recovery.NTSB ANC90LA139Accident · No injuriesLimited investigationFinal reportCessna 180 · Soldotna, AKLoss of engine power due to fuel exhaustion caused by inflight siphoning of fuel.NTSB SEA90LA159Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Wenatchee, WAImproper installation of the oil filter gasket by maintenance personnel resulting in loss of engine oil and seizure of the engine.NTSB MIA90LA170Accident · 4 fatalLimited investigationFinal reportPiper PA-22-150 · Atlantic Ocean (Atlantic Ocean)Undetermined. The airplane is missing.NTSB MIA90LA167Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Fajardo, PRFailure of the pilot to maintain vso during the takeoff climb, resulting in the loss of control.NTSB LAX90LA282Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Liano, CAThe pilot's inflight decision was improper. Contributing to this accident was the pilot's self-induced pressure.NTSB FTW90LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Houston, TXFuel exhaustion due to refueling not performed.NTSB DCA90IA048Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Chicago, ILThe pilot(s) allowed the aircraft to rotate to an excessive nose high attitude, either during a takeoff or landing.NTSB CHI90LA224Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Sturgis, SDPoor planning/decision, flight into known adverse weather conditions and over confidence in personal ability by the PIC. Contributing factors were thunderstorms, turbulence and unfavorable wind.NTSB ATL90FA157Accident · 1 fatalField investigationFinal reportBeech E18S · Greenwood, SCThe pilot's improper emergency procedure by shutting down the wrong engine, which resulted in a forced landing. Factors related to the accident were: failure of the number three intake valve in the right engine due to fatigue, and trees in the emergency…NTSB SEA90LA157Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Ellensburg, WAThe pilot did not adequately level off the helicopter and collided with the terrain.NTSB LAX90LA288Accident · No injuriesLimited investigationFinal reportCessna 421 · Concord, CAThe pilot's failure to follow the electrical system failure checklist. Contributing to this accident was the total electrical failure for undetermined reasons and the landing gear being unlocked.NTSB LAX90DVD01Accident · Serious injuriesFinal reportConvair L-13A · Hayward, CAAbsence of a oil system fitting cap.NTSB LAX90DVA08Accident · Minor injuriesFinal reportHiller UH-12-E · Los Banos, CAThe pilot's failure to maintain a lookout for obstructions along his swath run.NTSB FTW90LA156Accident · Serious injuriesLimited investigationFinal reportBoeing B-737-300 · Corpus Christi, TXThe airplane's unexpected encounter with clear air turbulence.NTSB CHI90LA219Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Columbus, NEStanding water on the approach end of the runway.NTSB CHI90DTG05Accident · No injuriesFinal reportPiper PA-25-235 · Sykeston, NDThe pilot's inadequate aircraft preflight. Contributing to the accident was the lack of suitable terrain on which to perform a forced landing.NTSB ANC90LA150Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Ivishak River, AKPilot lost directional control during landing. Contributing to the accident was the pilot's delayed attempt to go-around.NTSB ANC90LA140Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Fareweel, AKThe pilot's decision to takeoff downwind.NTSB ANC90LA138Accident · No injuriesLimited investigationFinal reportHelio HE-3/H-295 · Arctic Village, AKThe pilot in commands improper flare during a forced landing resulting in a hard landing.NTSB ANC90LA137Accident · No injuriesLimited investigationFinal reportCessna T-207A · King Salmon, AKThe pilot's delay in aborting the takeoff.NTSB LAX90DVM03Accident · 1 fatalFinal reportIlli Thunder Gull · Calif Valley, CAPoor judgement of the pilot from use of a drug (cocaine), and the pilot allowing the design stress limits of the aircraft to be exceeded, while maneuvering, which resulted in overload failure of the wing spar & wing separation.NTSB FTW90LA154Accident · No injuriesLimited investigationFinal reportCessna 421B · El Paso, TXThe pilot's improper single engine emergency procedures.NTSB FTW90LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Denton, TXThe instructor pilot's failure to take control of the aircraft in a timely manner, resulting in loss of control. A factor was the instructor's failure to assume control of the throttles, and aircraft engine out capability exceeded.NTSB CHI90LA222Accident · No injuriesLimited investigationFinal reportNaaman Haren Kitfox 1 · Grundy Center, IAGo-around delayed by the pilot in command.NTSB CHI90LA217Accident · Serious injuriesLimited investigationFinal reportHarper Volksplane WE-1 · Kingman, KSFailure of the pilot in command to maintain airspeed resulting in an inadvertent stall and spin.