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 SEA90LA154Accident · No injuriesLimited investigationFinal reportCessna 188B · Denton, MTThe premature liftoff during takeoff ground roll by the pilot, resulting in a stall.NTSB NYC90FA181Accident · 2 fatalField investigationFinal reportCessna 150L · Palmer Township, PAThe failure of the student pilot to maintain airspeed which resulted in a stall/spin with insufficient altitude for recovery. Factors which contributed to the accident were: the student pilot's poor judgement in buzzing a residential area, and his lack of…NTSB FTW90DRD15Accident · No injuriesFinal reportCessna 188 · Archibald, LAThe power loss for undetermined reasons. A factor was the rough uneven terrain in which the forced landing was performed.NTSB FTW90DPJ10Accident · No injuriesFinal reportHomebuilt Midget Mustang M1 · Bristow, OKFuel starvation induced power loss, a compromised fuel vent system, and improper installation of the plumbing in the fuel vent system.NTSB FTW90DPG07Accident · No injuriesFinal reportSchweizer G-164B · Sherrill, ARPremature lift off and subsequent stall.NTSB DEN90LA167Accident · No injuriesLimited investigationFinal reportMooney M20C · Roswell, NMThe intentional wheels up landing in soft terrain. Contributing to the accident was the fuel starvation induced power loss, failure of the pilot to switch fuel tanks, improper positioning of the fuel selector during attempted restarts, and the soft terrain.NTSB CHI90DEV08Accident · Minor injuriesFinal reportHilvety Cwii · Moweaqua, ILThe pilot's failure to maintain flying speed and stalling the airplane while attempting to reverse course for a forced landing. Contributing to the accident was the pilot's failure to properly reinstall spark plug cables during servicing conducted prior to…NTSB ATL90IA154Incident · No injuriesIncident investigationFinal reportDassault DA20F · Chamblee, GAThe right fuel control unit malfunctioned and allowed the engine speed to decrease below idle speed (45%) which resulted in an engine fire. Factors in the incident were: the improper rigging of the fuel control unit during installation, and the flight crew's…NTSB ANC90LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Falls Creek, AKPilot-in-command's failure to maintain aircraft control.NTSB ANC90LA130Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Merrill Pass, AKThe pilot-in-command's failure to maintain flying speed.NTSB NYC90LA221Accident · Serious injuriesLimited investigationFinal reportFantasy Sky Promotions AX-7 · Binghamton, NYThe pilot's failure to maintain control of the balloon during touchdown resulting in the basket of the balloon tipping. Factors to the accident were the slope of the terrain and the wind.NTSB NYC90LA182Accident · No injuriesLimited investigationFinal reportBeech 58P · Chicopee, MADouble power loss due to improper fueling procedures. Factors relating to the accident were: improper pre-flight actions by the pilot and wrong fuel.NTSB NYC90LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mt Pocono, PAA hard landing after the pilot perceived an engine problem. Contributing to the accident was the failure of the pilot to control his airspeed and flare during the emergency landing.NTSB MIA90WA165Accident · No injuriesForeign investigationCessna 172 · Grd Bahama Isl, BahamasNTSB MIA90LA164Accident · No injuriesLimited investigationFinal reportCessna 150M · Venice, FLFailure of the student pilot to flare for landing and his loss of control after a bounced landing.NTSB LAX90LA344Accident · No injuriesLimited investigationFinal reportCessna 180 · Tucson, AZThe pilot's failure to maintain adequate distance from a MD-80'S jet exhaust.NTSB LAX90LA272Accident · Minor injuriesLimited investigationFinal reportStinson L-5B · Victorville, CAThe oil gauge line 'b' nut backed off, and the pilot failed to maintain airspeed.NTSB CHI90LA211Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mooresville, INThe pilot in commands failure to land with enough runway remaining resulting in a runway overun and on ground collision with a wall.NTSB CHI90FA212Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Oshkosh, WIThe pilot-in-command's failure to maintain airspeed sufficient to avoid a stall/spin at an altitude insufficient to effect a full recovery.NTSB CHI90DCJ01Accident · 1 fatalFinal reportCessna A188B · Amherst, NEThe pilot's failure to see and avoid power lines in his area of operation.NTSB BFO90LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Tangier Island, VAThe pilot's improper recovery from a bounced landing and premature raising of the flaps.NTSB BFO90FA067Accident · No injuriesField investigationFinal reportCessna 150K · Clinton, MDImproper planning/decision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB ATL90TL#03Accident · No injuriesClass 3Final reportCessna 185A · Americus, GANTSB ATL90FA153Accident · 2 fatalField investigationFinal reportPiper PA-18 · Southport, NCThe entry into a flat spin which precluded recovery by the pilot. The reason for the spin becoming flat could not be determined.NTSB ANC90LA129Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Naked Island, AKA left engine failure for undetermined reasons.NTSB SEA90LA153Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Burns, ORLoss of engine power due to a blocked fuel line and the operation of the aircraft in an non-airworthy condition by the PIC.NTSB SEA90LA152Accident · No injuriesLimited investigationFinal reportBoson Starduster TOO · Pinedale, WYThe loss of engine power due to failure of the ignition coil, and the lack of suitable terrain for a forced landing. Failure of the ignition coil resulting in a total loss of engine power. The lack of suitable terrain was a factor related to the accident.NTSB NYC90DNA04Accident · No injuriesFinal reportBell 47G-3B-1 · Hanson, MAThe pilot's loss of control of the helicopter due to the failure of the tail rotor drive shaft.NTSB MIA90FA163Accident · 2 fatalField investigationFinal reportCessna 150J · Baker Hill, ALAn inadvertent stall/spin. Factors were airspeed not maintained, altitude inadequate for safe recovery, and attention diverted.NTSB LAX90LA273Accident · No injuriesLimited investigationFinal reportCessna 172P · Mammoth Lakes, CAInadvertent encounter with high velocity winds.NTSB FTW90LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · New Roades, LAUnknown mechanical malfunction resulting in engine oil starvation. A contributing factor was rough terrain in which the forced landing was made.NTSB DEN90DQA02Accident · No injuriesFinal reportGrumman G-164A · Deming, NMFailure of the pilot to maintain control during landing roll due to the condition of the runway. Contributing to the accident was the poor maintenance of the runway surface.NTSB BFO90DOA01Accident · Minor injuriesFinal reportBell TH-1L · Galax, VAThe lost of engine power because of a compressor stall.NTSB BFO90DIG02Accident · Minor injuriesFinal reportCessna 182J · Frederick, MDFailure of the pilot to assure that the magneto (ignition) switch was in the proper position. A factor related to the accident was: partial failure of the magneto switch, which allowed the key to be removed, though the switch was not in the 'off' position.NTSB ANC90T#A02Accident · No injuriesClass 3Final reportPiper PA-18-150 · Kotzebue, AKNTSB LAX90LA264Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider LS3-A · Sparks, NVThe inability of the pilot to maintain control of the glider as a result of injuries sustained during an inflight encounter with turbulence. Contributing to the accident was turbulent weather condition encountered.NTSB FTW90LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Alvord, TXThe failure of the engine to develop full rated power for unknown reasons.NTSB CHI90LA220Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Plainfield, ILThe glider pilot's improper aircraft handling at low atitude.NTSB CHI90FA208Accident · Serious injuriesField investigationFinal reportLockheed 12A · Oshkosh, WIThe inadequate emergency procedure(s) by the pilot in command following a loss of engine power for undetermined reasons(s).NTSB CHI90DER04Accident · Minor injuriesFinal reportBD 4- Francisco BD-4 · Rosemount, MNFailure of the manufacturer (amateur built) to design fuel system adequately to prevent vapor lock in fuel line.NTSB CHI90DER03Accident · No injuriesFinal reportBell 47G3B1 · Coon Rapids, MNThe pilot-in-command's inaccurate fuel consumption calculations and misjudgement of his fuel supply.NTSB CHI90DEM07Accident · 1 fatalFinal reportPitts SA-1 · East Jordan, MIThe pilot-in-command's failure to maintain altitude during low altitude aerobatics.NTSB BFO90LA066Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Peebles, OHImproper use of carburetor heat.NTSB ANC90LA128Accident · No injuriesLimited investigationFinal reportCessna 337 · Kustatan River, AKPilot-in-command's failure to assure that the rear engine developed full takeoff power and to attain takeoff airspeed. Contributing factors were the terrain conditions.NTSB SEA90FA149Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Leavenworth, WAThe pilot's misjudgement in preflight planning when departing toward rising terrain. Contributing factors in this accident were his decision to attempt a climb-out with full flaps extended, and the minimal performance data available to him upon which he could…NTSB LAX90DXQ02Accident · Minor injuriesFinal reportLeffler/Mcfarlane LM-1 · Sierraville, CAPilot's failure to see and avoid a tree during his landing approach.NTSB FTW90DPG04Accident · No injuriesFinal reportAir Tractor 301A · Foreman, ARThe pilot's inadvertent stall/mush.NTSB CHI90LA209Accident · No injuriesLimited investigationFinal reportCessna 150 · Oshkosh, WILoss of engine power for an undetermined reason.NTSB CHI90LA205Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Hudson, IAImproper touchdown performed by the pilot in command.NTSB CHI90LA203Accident · Minor injuriesLimited investigationFinal reportForbing Longeze · Yutan, NEFuel exhaustion due to an inadequate supply of fuel and the pilot's lack of familiarity with this home-built aircraft. Factors related to the accident were: darkness and obstructions (vehicle & road sign) in the emergency landing area.