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 ANC90LA136Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKFailure of the right main landing gear spring upon landing.NTSB SEA90FA158Accident · Serious injuriesField investigationFinal reportAerospatiale SA315B · Cougar, WALoss of power due to contamination in the engine speed governor.NTSB NYC90LA189Accident · Serious injuriesLimited investigationFinal reportBell 206 · Athens, OHThe pilot's failure to visually acquire and maintain clearance from the powerline(s). Contributing to the accident was the adverse weather conditions.NTSB MIA90WA175Accident · No injuriesForeign investigationPiper PA-23-250T · AnguillaNTSB LAX90LA280Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 9 · Napa, CAThe flight's encounter with a probable microburst weather phenomena with down drafts and winds beyond the performance capability of the Balloon.NTSB LAX90LA279Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Napa, CAThe flight's encounter with a probable microburst weather phenomena with down drafts and winds beyond the performance capability of the Balloon.NTSB LAX90LA278Accident · Serious injuriesLimited investigationFinal reportAerostar S-66A · Napa, CAFlight's encounter with a probable microburst weather phenomena with down drafts and winds beyond the performance capability of the balloon.NTSB LAX90LA277Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX9-140 SLI · Napa, CAFlight's encounter with a probable microburst weather phenomena with down drafts and winds beyond the performance capability of the balloon.NTSB LAX90LA276Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · San Anderas, CAThe accumulation of carburetor ice resulting from the failure of the student pilot to apply carburetor heat during the power off gliding descent.NTSB FTW90FA151Accident · Minor injuriesField investigationFinal reportCessna 172M · Elmendorf, TXInadequate visual lookout by both pilots in the T-38 and by the instructor pilot (CFI) in the Cessna 172.NTSB CHI90LA218Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Brighton, MIA loss of engine power due to inadequate maintenance and inspection.NTSB CHI90LA216Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Salisbury, MOProper touchdown point not attained and go-around not performed by the PIC.NTSB CHI90DEV09Accident · 1 fatalFinal reportPietenpol AIR Camper · Minonk, ILThe pilot's inattention to visual lookout.NTSB CHI90DEP08Accident · Minor injuriesFinal reportChristen Industries Eagle II · Milwaukee, WIThe pilot-in-command's failure to maintain aircraft control, his misjudgment of proper glidepath and his not performing a timely go-around.NTSB CHI90DEM08Accident · 2 fatalFinal reportCessna 150L · Holland, MIUndetermined. Factors related to the accident were: darkness & impairment of the pilot due to carbon monoxide.NTSB ANC90LA135Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA-315B · Tok, AKImproper installation of the fuel filter element in the aircraft by company/maintenance personnel, and subsequent contamination of the fuel system by unfiltered fuel. Factors related to the accident were: inadequate design of the fuel filter assembly, which…NTSB SEA90LA155Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Chehalis, WAThe pilot's inadequate compensation for wind conditions. The gusty crosswind ws a related factor.NTSB LAX90DVG14Accident · Minor injuriesFinal reportDon G. Kaye RV-3 · Willows, CAThe pilots failure to maintain directional control on the runway after experiencing a loss of engine power.NTSB LAX90DUJ07Accident · Minor injuriesFinal reportWarkentin KR-2 · Page, AZThe pilot's inadvertent deactivation of the fuel selector when he actuated the foot operated main landing gear.NTSB FTW90FA152Accident · 2 fatalField investigationFinal reportCessna 150L · Leesville, LAThe pilot's failure to maintain vs while maneuvering and the fact that altitude was insufficient for recovery from the inadvertent stall.NTSB CHI90LA223Accident · No injuriesLimited investigationFinal reportStearman E-75 · Mt. Grove, MOThe pilot's inadequate maintenance and servicing of the aircraft. A factor was water contamination in fuel tank.NTSB CHI90DER05Accident · Serious injuriesFinal reportPiper PA-25-235 · Ulen, MNThe pilot-in-command's failure to maintain control of the aircraft to avoid the inadvertent entry into a stall/spin at low altitude which resulted in impact with the terrain.NTSB ATL90LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to properly judge the stopping distance of the airplane and his subsequent failure to perform a go around. Factors in the accident were the tailwind condition at the airport.NTSB ANC90LA133Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Tetlin, AKThe pilot's failure to mountain directional control during the landing roll.NTSB ANC90LA132Accident · No injuriesLimited investigationFinal reportCessna C-T210 · Sleeper Bay, AKImproper fuel tank selection.NTSB NYC90LA186Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Mt. Bethel, PAThe pilot failed to maintain directional control of the airplane. Factors were wet grass and poor braking action.NTSB MIA90FA166Accident · Serious injuriesField investigationFinal reportRockwell 680-E · Titusville, FLThe pilot's decision to continue the flight with a known unairworthy mechanical condition resulting in a subsequent loss of engine power and forced landing.NTSB LAX90LA274Accident · No injuriesLimited investigationFinal reportCessna 340A · Stockton, CAThe pilots failure to properly position the fuel selector prior to flight, and the failure of the check pilot to adequately supervise the conduct of the flight.NTSB CHI90LA215Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILImproper flare and improper recovery from a bounced landing.NTSB CHI90FA214Accident · 2 fatalField investigationFinal reportCessna 150L · Donnybrook, NDThe pilot's failure to maintain airspeed while maneuvering in hilly terrain. Contributing factors were the pilot's failure to maintain adequate altitude and the surrounding steeply rising terrain.NTSB CHI90DTG03Accident · Minor injuriesFinal reportEagle DW-1 · Jamestown, NDPilot's failure to maintain clearance from the powerline during an aerial application manuever.NTSB CHI90DEV07Accident · 2 fatalFinal reportPitts S2B · Springfield, ILThe pilot's failure to maintain flying speed and allowed the aircraft to stall during the break turn to downwind.NTSB CHI90DEE09Accident · No injuriesFinal reportBennert Sidewinder · Lansing, ILThe pilot's failure to compensate for winds conditions on landing approach.NTSB BFO90LA072Accident · 1 fatalLimited investigationFinal reportCessna A152 · Hyden, KYThe pilot intentionally continuing VFR flight into instrument meteorological conditions which resulted in spatial disorientation and loss of aircraft control. Factors contributing to the accident were the thunderstorms and the pilot's lack of instrument…NTSB ATL90DKG06Accident · No injuriesFinal reportProsser Mono FLY · Cartersville, GAThe pilot/builder's failure to ensure that the substituted control stick was adequately attached to the aileron bell crank.NTSB SEA90TL#07Accident · Minor injuriesClass 3Final reportBoeing Vertol 107-11 · Leavenworth, WANTSB NYC90LA188Accident · No injuriesLimited investigationFinal reportCessna 150M · Rochester, NHUndetermined.NTSB NYC90LA187Accident · No injuriesLimited investigationFinal reportBell 206B · Fitchburg, MAThe pilot's failure to assure that adequate fuel was on board for the flight.NTSB NYC90LA185Accident · No injuriesLimited investigationFinal reportCessna 140 · Middlesex, NYThe student pilot's failure to execute a go-around. Factors which contributed to the accident was his misjudgement of speed and distance which resulted in overshooting the landing.NTSB NYC90LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tunkhannock, PAThe pilot did not obtain the proper touchdown point which resulted in an overrun. The factors were altitude, wet runway, and go around not performed.NTSB NYC90DNE04Accident · Minor injuriesFinal reportRotorway RW 152 · Southwick, MAA hard landing due to improper use of the rotorcraft flight controls, and the decision to put fuel in only one side.NTSB LAX90LA275Accident · No injuriesLimited investigationFinal reportRobinson R22B · Scottsdale, AZThe pilot's improper aircraft handling at a low altitude which resulted in a rate of descent that could not be arrested prior to colliding with the ground.NTSB LAX90LA270Accident · No injuriesLimited investigationFinal reportCessna 172G · Trinity Center, CAThe pilot's excessive airspeed and his failure to touchdown at the proper location on the runway.NTSB LAX90DXQ03Accident · Minor injuriesFinal reportAir Tractor AT-401 · Tule Lake, CAAn engine failure due to mechanical failure of the distributor.NTSB CHI90DTG02Accident · No injuriesFinal reportHiller UH-12-E · Garrison, NDThe failure of the helicopter tail rotor control cable. A factor related to the accident was the chafing of the tail rotor control cable.NTSB CHI90DTG01Accident · No injuriesFinal reportCessna 188 · Dazey, NDA blockage of the fuel tank vent line. Contributing to the accident was the unsuitable terrain on which the pilot had to make the forced landing.NTSB ATL90LA155Accident · No injuriesLimited investigationFinal reportCessna 172L · Greensboro, ALThe pilot's failure to maintain proper airspeed and attain the proper touchdown point during the emergency landing.NTSB ATL90DKG05Accident · No injuriesFinal reportAyres Bull Thrush · Americus, GAFailure of the engine main oil line which allowed the engine oil to be ignited by the hot engine.NTSB ANC90FA134Accident · 3 fatalField investigationFinal reportHelio Courier H-295 · 40 Se Bettles, AKThe failure and separation of the #5 connecting rod bolt and cap which resulted in the rupture of the engine housing and subsequent engine fire due to oil spillage, and an inadequately mounted vertical fin/stabilator. A contributing factor was the inadequate…NTSB SEA90LA156Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-10-10 · Coeur D'Alene, IDPassenger spilling a hot cup of coffee in her lap while the flight was in cruise flight.