NTSB investigations, 1990
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\") = 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 CHI91LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Portage, WIDelayed go-around and stall encountered. Contributing factors were a snow bank, proper alignment not attained, and raising the flaps not performed by the PIC.NTSB NYC91FA042Accident · 2 fatalField investigationFinal reportBeech A24R · Owls Head, NYThe pilot's continued VFR flight into instrument meteorological conditions (IMC). Factors related to the accident were: darkness, adverse weather conditions, and mountainous terrain.NTSB FTW91LA020Accident · No injuriesLimited investigationFinal reportCessna 172N · Plano, TXThe pilot's failure to follow the approved start procedures which resulted in an induction fire and the destruction of the airplane.NTSB CHI91IA041Incident · No injuriesIncident investigationFinal reportBoeing 727-257 · Detroit, MIThe inadequate deicing procedures instituted by company management.NTSB ATL91FA026Accident · Serious injuriesField investigationFinal reportBeech D-55 · Greer, SCFuel starvation. A contributing factor was the pilot's failure to follow normal fuel system operational procedures which resulted in the total loss of engine power.NTSB LAX91LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed during takeoff and his incorrect use of full flaps. Factors related to the high density altitude condition and to the pilot's abrupt airplane handling techniques.NTSB LAX91LA049Accident · No injuriesLimited investigationFinal reportCessna 150 · Tucson, AZOne or more of the F-16 pilot's improper use of throttles before being cleared for take off.NTSB BFO91LA017Accident · No injuriesLimited investigationFinal reportRockwell 690C · Summerville, WVPilot's failure to maintain adequate aircraft control during the landing flare/touchdown. The turbulent weather was a related factor.NTSB SEA91LA028Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Vernal, UTA malfunction/failure of the helicopter's main rotor lead-lag damper.NTSB DCA91MA010Accident · 8 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-9-14 · Romulus, MILack of proper crew coordn, including virtual reversal of roles by the DC-9 plts, which led to their failure to stop taxiing & alert gnd ctlr of their positional uncertainty in a timely manner bfr & after intruding onto the active rwy. Contribuing to cause of…NTSB SEA91LA029Accident · No injuriesLimited investigationFinal reportCessna 182A · Burns, ORThe formation of carburetor ice when the pilot delayed the use of carburetor heat.NTSB LAX91LA048Accident · No injuriesLimited investigationFinal reportCessna T-206 · Tonto Basin, AZThe failure of a connecting rod in the engine.NTSB CHI91LA040Accident · No injuriesLimited investigationFinal reportCessna 182 · Howell, MIFuel exhaustion due to re-fueling not performed by the PIC. Contributing factors were fuel consumption calculations misjudged by the PIC.NTSB CHI91LA038Accident · No injuriesLimited investigationFinal reportCessna 150 · Grand Haven, MIDelayed application of carburetor heat by the PIC. Contributing factors were carburetor icing conditions (weather) and none suitable terrain.NTSB CHI91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Muskegon, MIDirectional control not maintained by the PIC.NTSB BFO91LA016Accident · 1 fatalLimited investigationFinal reportCessna 172P · Axton, VAThe pilot's failure to maintain adequate clearance with an obstacle. Contributing was an unmarked powerline and the pilot's lack of familiarity with the geographical area.NTSB SEA91LA032Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Seattle, WAThe pilot's failure to maintain airspeed while on an instrument approach under instrument meteorlogical conditions, resulting in the aircraft stalling and enter a spin.NTSB SEA91FA027Accident · 5 fatalField investigationFinal reportAero Commander 690A · Ryderwood, WAThe pilot's improper inflight planning and failure to maintain proper altitude in mountainous terrain at night.NTSB NYC91LA045Accident · No injuriesLimited investigationFinal reportCessna 150J · Columbus, OHThe pilot's improper recovery from a bounced landing. Factors in the accident were: a downwind landing, and loss of engine power for undetermined reasons.NTSB MIA91WA039Accident · No injuriesForeign investigationPiper PA-28R200 · St. Mary, JamaicaNTSB CHI91LA036Accident · No injuriesLimited investigationFinal reportCessna T210M · Marshall, MIDirectional control not maintained by the PIC.NTSB ATL91IA024Incident · No injuriesIncident investigationFinal reportCessna S550 · Columbus, GAA fatigue failure of a spot weld on the gas generator case, which resulted in an engine explosion.NTSB SEA91FA026Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Salt Lake City, UTThe pilot's intentional buzzing of uninhabited island in the great Salt lake and his misjudging the timing of a pull-up maneuver to clear rising terrain of a ridgeline.NTSB SEA91FA025Accident · Serious injuriesField investigationFinal reportPiper PA31 · Enumclaw, WAFuel exhaustion due to inadequate preflight planning and preparations, and poor inflight planning and decisions. The pilot elected to fly into known adverse weather conditions, and did not calculate fuel consumption for the planned flight.NTSB MIA91LA038Accident · No injuriesLimited investigationFinal reportCessna 172N · Vero Beach, FLThe failure of the pilot to perfrom a proper landing flare and touchdown resulting in a hard landing.NTSB MIA91LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort White, FLThe downwind landing with excessive airspeed.NTSB MIA91LA036Accident · No injuriesLimited investigationFinal reportCessna 550 · Sebring, FLThe pilot's delayed go-around after encountering a fog bank on short final. The fog and the dark night were factors.NTSB MIA91FA035Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Bunnell, FLFailure of the pilot to maintain altitude, while maneuvering at night over an unlighted area, which resulted in a collision with trees. Factors related to the accident were: darkness and possible spatial disorientation of the pilot due to lack of visual ques.NTSB CHI91LA039Accident · No injuriesLimited investigationFinal reportCessna 150 · Niota, ILFuel consumption calculations misjudged by the PIC. Contributing factors were a tailwind landing and no suitable terrain.NTSB CHI91FA035Accident · 1 fatalField investigationFinal reportPiper PA-31T2 · Des Moines, IAThe pilot's improper emergency procedures by not feathering the left engine after it lost power and/or was shut down, and his failure to keep the aircraft at or above the minimum control airspeed (VMC), which resulted in a loss of aircraft control. A factor…NTSB ATL91LA023Accident · No injuriesLimited investigationFinal reportCessna 172N · Chamblee, GAPilot's failure to maintain adequate wingtip clearance during taxi.NTSB ATL91LA022Accident · No injuriesLimited investigationFinal reportBeech A23A · Franklin, NCThe pilots failure to maintain directional control during landing. The presence of gusting crosswinds was a factor in the accident.NTSB NYC91LA040Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Easton, PAAn inflight failure of the left side cabin mount bracket which resulted in a loss of lateral cyclic control. Factors related to the accident were: an incomplete inspection of the helicopter following a hard landing with a blade strike.NTSB MIA91GA034Accident · No injuriesFinal reportAsta N22S · Homestead Afb, FLThe bending overstress failure of the left main landing screwjack at an undetermined time during flight for undetermined reasons.NTSB CHI91LA034Accident · No injuriesLimited investigationFinal reportCessna 401 · Grand Island, NEFlight into known adverse weather conditions and flare misjudged. Factors related to the accident were: icing conditions resulting in reduced aircraft controllability and restricted visual outlook.NTSB SEA91LA023Accident · No injuriesLimited investigationFinal reportHughes 369D · Mulina, ORIn-flight collision with a rebounding long-line, which caused main-rotor RPM decay and tail-boom separation, compromising the pilot's ability to successfully accomplish an attempted autorotation.NTSB NYC91LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marshfield, MAThe partial loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain in which the emergency landing was made.NTSB MIA91LA033Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT401 · Belle Glade, FLThe pilot failed to maintain airspeed, and stalled the airplane, resulting in a uncontrolled descent, and collision with the terrain.NTSB MIA91IA032Incident · No injuriesIncident investigationFinal reportATR ATR-42-300 · St. ThomasThe failure of the left main landing gear side brace lower arm due to fatigue resulting from corrosion formation, which resulted from improper design to prevent corrosion formation.NTSB LAX91LA047Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Poway, CAThe pilot's failure to obtain a proper touchdown point. Contributing factors which related to the basket's tipping over were the pilot's misjudging the wind direction and the wind's relative high speed.NTSB LAX91LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · Tonopah, NVThe airplane's encounter with a wind gust while taxiing from landing. Contributing factors related to the pilot's improper weather evaluation and his lack of experience in making weather evaluations.NTSB LAX91LA042Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Livermore, CAInadvertent flight by the pilot into instrument meteorological conditions (IMC), and her failure to maintain adequate altitude and/or clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.NTSB LAX91IA039Incident · No injuriesIncident investigationFinal reportCessna 152 · Wahiawa, HIThe inadequate visual lookout of the pilots of both airplanes which resulted in the collision. Contributing to the accident was the improper VFR procedures of N88TE while transitioning through the wheeler afb airport traffic area.NTSB LAX91FA045Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Show Low, AZThe pilot's improper in-flight planning/decision, which resulted in loss of engine power, due to induction system icing. Factors related to the accident were: the adverse weather condition and lack of a suitable area for a forced landing.NTSB LAX91FA044Accident · 1 fatalField investigationFinal reportCessna T210-F · Fontana, CAThe pilot-in-command's decision to continue flight into known adverse weather conditions during the hours of darkness in mountainous terrain.NTSB FTW91LA019Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Granbury, TXTotal loss of engine power due to fuel exhaustion. Factors were the pilot's improper fuel consumption calculations, and the darkness of the night.NTSB CHI91FA033Accident · 2 fatalField investigationFinal reportCessna 150K · Valley Center, KSContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft after becoming spatially disoriented. Factors related to the accident were: darkness, adverse weather conditions, and the…NTSB CHI91FA032Accident · Minor injuriesField investigationFinal reportGates Learjet 25B · Chicago, ILThe driver's inadequate visual lookout. A factor in the accident was the company's configuring the truck with mirrors which obstruct forward visibility.NTSB NYC91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taunton, MAThe pilot attempted to land in a strong cross wind, lost control of the airplane, ran off the runway and hit the VASI system.NTSB NYC91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Indian Head, MDThe flight instructors decision to land with insufficient runway remaining to stop the airplane which resulted in an overrun.