NTSB investigations, 1993
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\") = 1993 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") = 1993 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 SEA94FA040Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Spokane, WAThe pilot's failure to maintain proper alignment with the instrument landing system approach course. The pilot's failure to perform a missed approach was a factor.NTSB NYC94LA049Accident · 3 fatalLimited investigationFinal reportMooney M20J · Jones Beach, NYwas the pilot's failure to maintain control of the airplane, resulting in the airplane impacting with the water. Also casual in this accident was the pilot's total lack of experience in this type of aircraft, and operations. A factor in this accident was the…NTSB NYC94LA039Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Wilkes-Barre, PAwas the loss of engine oil for undetermined reasons and the subsequent engine failure, resulting in a forced landing and collision with trees.NTSB FTW94LA055Accident · No injuriesLimited investigationFinal reportEbershoff Steen Skybolt · Erie, COWas flutter of the flight controls.NTSB CHI94FA050Accident · 3 fatalField investigationFinal reportMitsubishi MU-300 · Goodland, KSThe pilot-in-command's inadvertent stall of the airplane. A factor associated with the accident is the pilot-in-command's poor IFR procedures.NTSB NYC94FA038Accident · 2 fatalField investigationFinal reportBeech B36TC · Lost Creek, KYThe loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the lack of suitable terrain for a forced landing.NTSB LAX94LA071Accident · No injuriesLimited investigationFinal reportRans S-14 · Riverside, CAthe pilot incorrectly selecting the wrong fuel valve and the subsequent engine failure due to fuel starvation.NTSB CHI94LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lacon, ILThe pilot misjudged the landing flare. Factors related to the accident were: the dark night, the pilot's lack of recent night experience, and the failure of the airplane's electrical system.NTSB FTW94LA048Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · El Paso, TXThe pilot's inadvertent flight into clear air turbulence.NTSB CHI94LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, MOthe failure of the pilot to refuel prior to fuel exhaustion.NTSB ANC94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Port Lions, AKImproper inflight planning and decision-making by the pilot in command. Factors contributing to the accident were the icy runway condition and the tailwind.NTSB LAX94LA075Accident · No injuriesLimited investigationFinal reportBell 206B-III · Flagstaff, AZThe pilot's improper initiation of an emergency autorotation into unsuitable terrain and subsequent hard landing and rollover. A false annunciator indication, a failure of the N1 tach generator, the pilot's continued flight with a known aircraft defect, and…NTSB FTW94LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Worth, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI94LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · C0rnell, ILthe pilot-in-command's misjudgment of fuel supply. A factor was fuel exhaustion.NTSB ATL94FA030Accident · 3 fatalField investigationFinal reportBeech M35 · Chapel Hill, NCThe improper engine overhaul by maintenance personnel. A factor in the accident was the failure of the engine crankshaft.NTSB CHI94FA048Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Antigo, WIthe failure of the pilot in command to maintain proper altitude.NTSB ATL94FA029Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Covington, GASpatial disorientation experienced by the pilot, resulting in his failure to maintain aircraft control. Factors were the total failure of the engine driven vacuum pump, and the night, cloud conditions prevailing at the time of the accident.NTSB ATL94FA028Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Lagrange, GAWas the pilot's failure to correct a known low battery condition before departing, which resulted in a loss of electrical power during an instrument approach. Factors were the dark night and the low scattered cloud layer.NTSB NYC94LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Christianburg, VAThe pilot's improper use of carburetor heat which prevented the accumulation of carburetor ice and resulted in the loss of engine power. A factor was unsuitable terrain.NTSB LAX94LA070Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Santa Paula, CAA failure of the pilot to maintain directional control of the tailwheel airplane following touchdown. The pilot's lack of total experience in the type of airplane was a factor in the accident.NTSB CHI94LA047Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Ashley, INInadequate aircraft preflight by the pilot-in-command. A factor relating to this accident is the dark night.NTSB ANC94LA025Accident · Serious injuriesLimited investigationFinal reportAeronca BL-7AC · Circle City, AKThe pilot in commands intentional flight into known adverse weather conditions which lead to an inadvertent aerodynamic stall of the aircraft. Factors contributing to the accident were the ice fog and the icing conditions.NTSB LAX94LA069Accident · Minor injuriesLimited investigationFinal reportRotorway EXEC-90 · Chandler, AZThe flight instructor's failure to properly follow the aircraft ballasting procedures that resulted in a loss of control when the helicopter's center of gravity limits were exceeded. Inadequate supervision of the training flight was a factor in the accident.NTSB FTW94IA046Incident · No injuriesIncident investigationFinal reportBoeing 737-33A · Dfw Airport, TXA failure by the pilot-in-command to attain a stabilzed approach. Factors were the fog and failure of the copilot to monitor the approach.NTSB ANC94LA024Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Juneau, AKThe pilot in command's selection of a sight unsuitable for landing. A factor in the accident was the ditch on the beach.NTSB SEA94LA039Accident · No injuriesLimited investigationFinal reportHiller-Soloy UH-12D · Sublimity, ORFuel exhaustion due to inadequate preflight and refueling not acomplished.NTSB NYC94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lumberton, NJThe pilot's failure to maintain a proper glidepath due to improper compensation for the wind conditions. A factor was a crosswind.NTSB NYC94IA035Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300 · Newark, NJThe separation of the right outboard translating cowl on the #2 engine thrust reverser as a result of inadequate bonding material.NTSB MIA94LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-301P · Fort Myers, FLThe failure of the pilot-in-command to abort the takeoff. A contributing factor was the soft condition of the runway surface.NTSB LAX94LA068Accident · No injuriesLimited investigationFinal reportCessna 177RG · Santa Monica, CAThe pilot's failure to attain the proper touchdown point and improper recovery from a bounced landing.NTSB ATL94LA027Accident · Minor injuriesLimited investigationFinal reportWonder VAN'S Acft RV-6 · Ridgeland, SCImproper installation of the magnetos by maintenance personnel, which allowed the right magneto to come loose, oil to escape from the engine, and subsequent oil starvation.NTSB ANC94LA023Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Northway, AKThe pilot-in-command did not maintain the proper glidepath.NTSB NYC94LA034Accident · 1 fatalLimited investigationFinal reportCessna 182Q · Nantucket, MAThe pilot's inability to control the airplane due to alcoholic impairment.NTSB CHI94LA045Accident · Serious injuriesLimited investigationFinal reportCessna 210B · Dubuque, IAFlight by the pilot into known icing conditions, which resulted in airframe icing and an inability of the aircraft to maintain altitude on the ILS glidepath, once the landing gear was lowered. The weather conditions were related factors.NTSB CHI94LA044Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Denison, IAThe pilot-in-command's inadequate remedial action. A factor associated with the accident is the student pilot's inadequate aircraft handling.NTSB MIA94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tupelo, MSThe pilot-in-commands failure to monitor fuel consumption.NTSB FTW94LA045Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Denton, TXThe cause was the pilot's failure to compensate for existing wind conditions. A factor was the turbulent weather.NTSB FTW94FA044Accident · 1 fatalField investigationFinal reportUpton Mustang M-II · Guthrie, OKWas the in flight failure of the left aileron for reasons undetermined.NTSB CHI94LA042Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Pratt, KSThe pilot-in-command's failure to maintain clearance from obstacles. Factors contributing to the accident are the pilot's misjudged fuel consumption calculations and the weather (high winds).NTSB NYC94LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · North Haven, METhe pilot's use of excessive speed and altitude during the approach which resulted in a landing overrun of the runway. Factors were a precautionary landing and a ravine.NTSB NYC94LA031Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Millbrook, NYThe student pilot's failure to maintain direction control which resulted in an inflight collision with trees. Factors were the student pilot's improper recovery from a bounced landing and his inexperience.NTSB NYC94FA033Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · New Haven, CTThe pilot's failure to maintain control of the airplane during a night approach in adverse weather conditions. Factors which contributed to the accident were the weather conditions and dark night. In addition, the radar controller's vectoring of the pilot to…NTSB MIA94LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hastings, FLThe delayed reaction of the pilot-in-command to compensate for unexpected weather conditions, resulting in damage to the landing gear.NTSB MIA94FA034Accident · 1 fatalField investigationFinal reportCessna 150J · Delray Beach, FLThe pilot-in-command's failure to maintain altitude while maneuvering. This resulted in the pilot becoming spatially disoriented, and subsequent in-flight collision with the ocean. Contributing to the accident was the dark night with no visible horizon.NTSB LAX94FA065Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Payson, AZImproper in-flight planning/decision by the pilot, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. Factors related to the accident were: pilot impairment from improper use of prescription drugs (not approved for…NTSB ATL94LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAFuel starvation caused by foreign matter blockage of the fuel tank vent system.NTSB NYC94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Hopkinsville, KYthe pilot's improper IFR procedure by conducting flight below minimum descent altitude (MDA) without visual referece which resulted in an inflight collision with wires. A factor was the wire.NTSB LAX94LA064Accident · No injuriesLimited investigationFinal reportBraegger GL Nieuport 17 · Chandler, AZwas the pilot's improper handling of the airplane, and his failure to maintain control during his first attempted takeoff. Contributing factors were the pilot's inadvertent porpoising on the runway, and his lack of familiarity with the airplane's flight…NTSB LAX94LA063Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Santa Paula, CAwas the failure of the needle valve pin assembly in the airplane's carburetor. A factor which contributed to the accident was the lack of suitable terrain for the emergency landing.NTSB FTW94LA043Accident · Minor injuriesLimited investigationFinal reportBell 412 · Cameron, LAThe copilot's continued flight into adverse weather conditions, and the captain's inadequate supervision. The haze and fog were factors.