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 CHI91LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Monroe, MIDirectional control not maintained by the PIC.NTSB SEA91LA034Accident · 1 fatalLimited investigationFinal reportBeech D50C · Snohomish, WAThe obstruction (protruding door support bracket) in the doorway of the aircraft; failure of the company/operator personnel, the pilot, and the skydivers to assure that the doorway was clear of obstructions; and subsequent snagging of the d-ring, which…NTSB NYC91LA052Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Concord, NHThe improper starting procedure used by the pilot.NTSB NYC91LA049Accident · No injuriesLimited investigationFinal reportRobinson R22 · West Kingston, RIThe pilot's failure to maintain directional control. Contributing was the malfunction of the pedal assembly.NTSB MIA91LA044Accident · No injuriesLimited investigationFinal reportBeech F33A · Lakeland, FLTotal loss of engine power due to oil exhaustion for undetermined reasons. This caused the pistons to seize in the cylinders.NTSB DEN91LA025Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Roswell, NMLow cylinder compression and fouled spark plug.NTSB DEN91IA026Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200 · Denver, COThe catastrophic failure of the no.12 blade on the 4th stage turbine wheel, and failure of company maintenance personnel to identify the preexisting crack during maintenance inspection.NTSB NYC91LA048Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Nw Philadelphia, OHThe failure of the pilot to maintain airspeed during an attempted go-around which resulted in an inadvertent stall. Factors related to the accident were: improper use of the mixture control and carburetor heat.NTSB LAX91LA055Accident · 1 fatalLimited investigationFinal reportCessna 150G · Fresno, CAThe pilots intentional flight into known adverse weather conditions and his failure to maintain control of the aircraft. Factors in the accident were: the foggy weather conditions; spatial disorientation; and the pilot's over confidence in his own personal…NTSB CHI91DCQ02Accident · No injuriesFinal reportPiper PA-23-250 · Brownell, KSFuel exhaustion, due to the pilot's failure to ensure that the aircraft had been refueled.NTSB NYC91LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Easton, PAThe flight instructor allowed the airplane to get too low on final approach during the demonstration of a power off landing.NTSB LAX91FA059Accident · 1 fatalField investigationFinal reportCessna 182C · Globe, AZThe pilot's failure to conduct a weather evaluation prior to flight and his attempt to conduct his flight under visual flight rules into instrument meteorological conditions. Low ceilings along his flight route and self induced pressure to reach his…NTSB CHI91LA057Accident · No injuriesLimited investigationFinal reportCessna 172M · Austin, MNThe pilot-in-command (student)'s failure to properly evaluate and compensate for gusty wind condiitons and to maintain directional of the aircraft during initial climb. Contributing was the student pilot's lack of total experience and wind gusts.NTSB CHI91LA046Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Mundelein, ILLanding gear tire failure and directional control not maintained by the pic/cfi.NTSB MIA91LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Jupiter, FLPartial loss of engine power due to failure of an exhaust valve, due to a valve guide that was worn beyond specifications.NTSB MIA91LA042Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Jacksonville, FLFailure to maintain aircraft control after intentional flight into known adverse weather conditions.NTSB ATL91LA032Accident · No injuriesLimited investigationFinal reportCessna 150J · Willard, NCPilot's selection of unsuitable terrain for landing his airplane and his failure to raise the flaps after landing. This resulted in his inability to decelerate during the landing roll. A factor in the accident was the rough, uneven runway condition.NTSB NYC91FA046Accident · 4 fatalField investigationFinal reportAerostar S-60A · Columbus, OHImproper planning/decision by the pilot. The unfavorable wind and temperature inversion were related factors.NTSB CHI91DEM02Accident · 1 fatalFinal reportTaylorcraft BC12-D1 · North Muskegon, MIThe pilot-in-command's not maintaining sufficient airspeed and entering into an inadvertent stall. Factors related to this accident were fuel starvation and the pilot-in-command's not selecting a proper fuel tank selector position.NTSB CHI91DEE02Accident · Minor injuriesFinal reportMaule M-4-220C · Romeoville, ILThe pilot's inadequate preflight inspection resulting in power loss from fuel contamination. A factor in the accident was the owner's failure to accomplish airworthiness directive 84-9-7 which provided direct, convenient access to sample and purge the main…NTSB ATL91LA030Accident · No injuriesLimited investigationFinal reportBeech S35 · N. Myrtle Beach, SCThe pilot's failure to ensure that the engine oil filter was properly installed prior to flight, resulting in engine oil loss and eventual failure of the engine.NTSB ANC91LA015Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kongikank, AKThe pilot in command's failure to maintain airspeed during approach resulting in an inadverrtent stall annd uncontrolled descent into the ground.NTSB FTW91LA024Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gilmer, TXA power loss due to the pilot's improper use of carburetor heat.NTSB SEA91LA031Accident · No injuriesLimited investigationFinal reportBeech 3NM · Bozeman, MTThe failure of the right engine master rod.NTSB SEA90FA079Accident · No injuriesField investigationFinal reportBell 206B-3 · Coeur D'Alene, IDFailure of the pilot-in-command (PIC) to maintain rotor RPM, and a delay by the FAA inspector (flight examiner) in taking remedical action.NTSB MIA91WA053Accident · No injuriesForeign investigationAstar AS-350D · San Jose, Costa RicaNTSB MIA91LA041Accident · No injuriesLimited investigationFinal reportCessna 182RG · Orlando, FLFailure of the pilot to maintain directional control during the landing roll.NTSB LAX91LA054Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas 369D · Haleakla Nat Pk, HIFuel starvation due to the unporting of the fuel supply pick-up.NTSB LAX91LA051Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Madera, CAEngine failure due to a plugged vent line, affecting the ability of the system to transfer fuel to the main tank.NTSB LAX91FA052Accident · Minor injuriesField investigationFinal reportde Havilland DHC-6-100 · Perris Valley, CAA loss of power on the left engine due to a fatigue failure of a compressor turbine blade leading to further compressor blade damage; a worn power turbine governor throttle cam assembly which led to loss of power on the right engine; and inadequate…NTSB FTW91LA023Accident · No injuriesLimited investigationFinal reportBell 206L-1 · W.Cameron 266Failure of the helicopter's aft landing gear crosstube assembly due to fatigue.NTSB FTW91LA022Accident · No injuriesLimited investigationFinal reportTaylorcraft DC-65 · Boerne, TXThe pilot's inability to climb over obstacles due to encountering a downdraft which exceeded the climb capability of the airplane. Factors in the accident were the gusty wind conditions and the downdraft.NTSB CHI91LA045Accident · No injuriesLimited investigationFinal reportLaister LP-49 · Warrensburg, MOFailure to maintain directional control by the pilot. Factors related to the accident are lack of total experience in type aircraft, and type of operation.NTSB CHI91LA044Accident · No injuriesLimited investigationFinal reportCessna 182RG · Lansing, ILExcessive lowering of flaps resulted in aircraft control not being maintained by the pilot..inadequate airspeed resulted in a stall/mush and subsequent collision with the terrain. Factors related to the accident were: a gusty crosswind and a delayed go-around…NTSB ATL91LA029Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Senoia, GAImproper preflight planning and preparation by the pilot which resulted in fuel exhaustion. Factors to the accident were the dark night operation and the collision with utility lines.NTSB ANC91LA016Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Fairbanks, AKThe pilot-in-command's failure to properly perform the aircraft preflight resulting in a collision with a tow bar during initial taxi.NTSB SEA91LA033Accident · 1 fatalLimited investigationFinal reportErco 415-C · Ola, IDThe pilot's failure to maintain sufficient altitude for terrain clearance. Also causal was the pilot's impairment due to alcohol. Contributing factors were the night light condition and the hilly terrain.NTSB CHI91LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Joliet, ILInadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid each other's aircraft.NTSB ATL91LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hickory, NCThe pilots's inadequate visual lookout during flight. A factor in the accident was the pilot's failure to maintain a safe altitude.NTSB ATL91LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Humboldt, TNThe student pilot's failure to maintain directional control during landing. A factor was the student's lack of recent experience.NTSB ATL91LA027Accident · No injuriesLimited investigationFinal reportBeech 23C · Dunlap, TNThe pilot's failure to use the carburetor heat properly, which resulted in the formation of carburetor ice, followed by a complete loss of engine power. Factors to this accident were carburetor icing conditions and the rough and uneven terrain at the crash…NTSB ATL91FA025Accident · 1 fatalField investigationFinal reportCessna 150J · Ripley, TNPerforming a stall maneuver at an altitude below prescribed minimums, and his failure to apply correct flight control inputs to recover from the stall and spin.NTSB SEA91LA030Accident · 1 fatalLimited investigationFinal reportRobinson Wenoso · Olympia, WAThe inadvertant stall/spin and loss of aircraft control by the pilot in command while performing aerobatic maneuvers.NTSB NYC91LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJThe failure of the pilot to abort the takeoff in sufficient time to prevent an overrun. Factors related to the accident were a partial power loss due to a faulty ignition system.NTSB MIA91TF#01Accident · Serious injuriesClass 3Final reportBell 206B · Boca Grande, FLNTSB FTW91LA021Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Amarillo, TXAn underpowered takeoff attempt due to incorrectly set magnetos. Contributing was the transmission lines.NTSB DEN91LA024Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Welsh, LAThe pilot's improper compensation for wind conditions. A factor was the gusty wind.NTSB BFO91LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Mitchellville, MDFailure of the student pilot to maintain control of the aircraft, and inadequate supervision by the instructor pilot (CFI). Factors related to the accident were: inadequate preflight of the aircraft by the pilot(s) and in-flight opening of the door.NTSB NYC91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 210L · New Haven, CTThe failure of the vehicle driver to adequately monitor the radio/traffic pattern. Factors related to the accident were: darkness, the aircraft's loss of electrical power after activating the runway lights and entering the pattern, and the lack of visual…NTSB MIA91LA040Accident · No injuriesLimited investigationFinal reportBell 206B · Fort Pierce, FLThe incorrect cyclic control input by the student during the touchdown autorotation landing and failure of the CFI to correct this before the helicopter touched down.