NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
  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.

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.Dec 7, 1993 · N4391C · DestroyedNTSB 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.Dec 7, 1993 · N52039 · Substantial damageNTSB 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.Dec 7, 1993 · N443MW · Substantial damageNTSB ANC94LA023Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Northway, AKThe pilot-in-command did not maintain the proper glidepath.Dec 7, 1993 · N29532 · Substantial damageNTSB NYC94LA034Accident · 1 fatalLimited investigationFinal reportCessna 182Q · Nantucket, MAThe pilot's inability to control the airplane due to alcoholic impairment.Dec 6, 1993 · N96666 · DestroyedNTSB 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.Dec 6, 1993 · N9684X · Substantial damageNTSB 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.Dec 6, 1993 · N6959Q · Substantial damageNTSB MIA94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tupelo, MSThe pilot-in-commands failure to monitor fuel consumption.Dec 5, 1993 · N2382T · Substantial damageNTSB 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.Dec 5, 1993 · N2360A · Substantial damageNTSB FTW94FA044Accident · 1 fatalField investigationFinal reportUpton Mustang M-II · Guthrie, OKWas the in flight failure of the left aileron for reasons undetermined.Dec 5, 1993 · N4YP · DestroyedNTSB 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).Dec 5, 1993 · N9079M · Substantial damageNTSB 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.Dec 4, 1993 · N55719 · Substantial damageNTSB 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.Dec 4, 1993 · N5325P · Substantial damageNTSB 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…Dec 4, 1993 · N1488X · DestroyedNTSB 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.Dec 4, 1993 · N43113 · Substantial damageNTSB 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.Dec 4, 1993 · N60517 · DestroyedNTSB 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…Dec 4, 1993 · N4417Z · DestroyedNTSB ATL94LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAFuel starvation caused by foreign matter blockage of the fuel tank vent system.Dec 4, 1993 · N4092J · Substantial damageNTSB 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.Dec 3, 1993 · N39595 · Substantial damageNTSB 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…Dec 3, 1993 · N124DK · Substantial damageNTSB 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.Dec 3, 1993 · N89014 · Substantial damageNTSB 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.Dec 3, 1993 · N356EH · DestroyedNTSB CHI94LA046Accident · No injuriesLimited investigationFinal reportCessna 550 · West Chicago, ILthe collision with birds/geese shortly after takeoff. Reduced visibility in fog was a factor.Dec 3, 1993 · N550RD · Substantial damageNTSB ANC94LA022Accident · No injuriesLimited investigationFinal reportCessna 207 · Tuntutuliak, AKFailure of the pilot to maintain proper alignment during the takeoff roll. Factors related to the accident were: darkness and the snow berm along the edge of the runway.Dec 3, 1993 · N36CF · Substantial damageNTSB ANC94LA021Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Napakiak, AKThe pilot-in-command's failure to maintain proper approach airspeed.Dec 3, 1993 · N38393 · Substantial damageNTSB NYC94FA029Accident · 2 fatalField investigationFinal reportAerospatiale TB-21 · Lebanon, NHThe pilot's failure to maintain adequate terrain clearance which resulted in an inflight collision with the terrain. A factor was a dark night condition.Dec 2, 1993 · N28163 · DestroyedNTSB NYC94FA028Accident · 2 fatalField investigationFinal reportPiper PA-31T · Norwich, OHThe pilot's loss of aircraft control for an unknown reason, and subsequent flight that exceeded the design stress limits of the airplane, which resulted in an in-flight airframe breakup.Dec 2, 1993 · N515WB · DestroyedNTSB MIA94LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Punta Gorda, FLThe pilot-in-command's improper use of carburetor heat during a VFR approach for landing. This resulted in a loss of engine power due to fuel system carburetor icing.Dec 2, 1993 · N6053K · Substantial damageNTSB LAX94LA067Accident · No injuriesLimited investigationFinal reportCessna 182Q · Grand Canyon, AZthe pilot's use of an excessive approach airspeed and an improper bounced landing recovery technique.Dec 2, 1993 · N94596 · Substantial damageNTSB DCA94MA022Accident · 18 fatalClass 1 · MajorFinal reportJetstream BA-3100 · Hibbing, MNThe captain's actions that led to a breakdown in crew coordination and the loss of altitude awareness by the flightcrew during an unstabilized approach in night instrument meteorological conditions. Contributing to the accident were: the failure of the…Dec 2, 1993 · N334PX · DestroyedNTSB CHI94LA043Accident · Serious injuriesLimited investigationFinal reportCleveland Piel Emeraude CP-304 · Warrensburg, MOthe intentional entry of a stall/spin by the student pilot.Dec 2, 1993 · N7631C · Substantial damageNTSB MIA94LA038Accident · No injuriesLimited investigationFinal reportCessna 650 · Tampa, FLThe pic's improper decision to taxi the airplane off the taxiway. Contributing to the accident was the improper wiring of the anti-skid system.Dec 1, 1993 · N700RR · Substantial damageNTSB FTW94LA042Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Parkin, ARThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain available to the pilot for the forced landing.Dec 1, 1993 · N4582 · Substantial damageNTSB ATL94LA025Accident · Minor injuriesLimited investigationFinal reportSikorsky H34-G · Walterboro, SCThe seizure of the aircraft throttle to engine linkage for unknown reasons.Dec 1, 1993 · N8503J · Substantial damageNTSB MIA94FA031Accident · 1 fatalField investigationFinal reportMooney M20E · Jacksonville, FLFailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall. A factor related to the accident was: the lack of altitude for recovery from a stall.Nov 30, 1993 · N9241V · Substantial damageNTSB MIA94FA030Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Daytona Beach, FLLoss of aircraft control for an undetermined reason.Nov 30, 1993 · N43079 · DestroyedNTSB LAX94LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Fallon, NVthe pilot's intentional continued flight into known adverse weather conditions.Nov 30, 1993 · N4081W · DestroyedNTSB LAX94FA278Accident · 2 fatalField investigationFinal reportMooney M20K · June Lake, CAThe pilot allowed the airplane to exceed its design limits (airspeed and/or stress limits) after inadvertently entering a descent. Factors relating to the accident were: darkness (night or late dusk), the pilot's failure to assure adequate…Nov 30, 1993 · N5788U · DestroyedNTSB FTW94LA040Accident · No injuriesLimited investigationFinal reportCessna A185F · Maybell, COThe pilot's failure to ascertain the condition of the landing area. The snow covered condition of the runway was a factor.Nov 30, 1993 · N6613N · Substantial damageNTSB BFO94LA022Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Waynesburg, PAThe pilot's inadequate preflight and inflight preparations, planning and decisions. The lack of suitable terrain for the forced landing was a factor.Nov 30, 1993 · N1377W · Substantial damageNTSB ANC94IA020Incident · No injuriesIncident investigationFinal reportSwearingen SA227 · King Salmon, AKThe pilot-in-command did not maintain control of the airplane and did not perform the appropriate procedures for an aborted takeoff. A factor in the incident was the asymmetry in power between the plane's two engines for undetermined reasons.Nov 30, 1993 · N630PA · Minor damageNTSB SEA94FA038Accident · 1 fatalField investigationFinal reportPiper PA-24 · Ashland, ORVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the adverse weatheer conditions, and the pilot's lack of…Nov 29, 1993 · N5764P · DestroyedNTSB FTW94FA041Accident · 1 fatalField investigationFinal reportQuicksilver MX II · Newark, TXPoor judment of the pilot after use of drugs, his improper planning/decision, and his failure to remain clear of an obstruction during takeoff. Factors related to the accident were: the pilot's overconfidence with the aircraft's ability, a tailwind condition,…Nov 29, 1993 · UNREG · Substantial damageNTSB LAX94LA061Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Panoche, CAthe pilot's improper approach speed and glide path, and his delayed initiation of a go-around. A factor in the accident was the wind shear condition created by the hills immediately off the departure end of the dirt airstrip.Nov 28, 1993 · N65922 · Substantial damageNTSB LAX94LA059Accident · No injuriesLimited investigationFinal reportCessna 150H · Dardanelle, CAThe pilot misjudged the local weather. The wind conditions and the pilot's inability to compensate for the strong downdraft wind conditions were factors.Nov 28, 1993 · N22474 · Substantial damageNTSB CHI94LA040Accident · Minor injuriesLimited investigationFinal reportSteven Ulrich Challenger II · Escanaba, MIInadequate directional stability of the aircraft (due to installation of lexan cockpit enclosure doors), which precipitated a loss of directional control.Nov 28, 1993 · N4285V · Substantial damageNTSB CHI94DEP01Accident · No injuriesFinal reportKrotje Kolb Mark III · Oshkosh, WIThe lack of carburetor heat for the engine. A factor related to the accident was: the weather condition, which was favorable for formation of carburetor ice.Nov 28, 1993 · N393PK · Substantial damageNTSB BFO94FA021Accident · 1 fatalField investigationFinal reportPiper PA32R-301 · Butler, PAThe pilot's inadvertent flight into IMC conditions and his failure to maintain proper altitude. The weather conditions were a factor.Nov 28, 1993 · N707JS · DestroyedNTSB ATL94FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mount Airy, NCThe pilot's improper decision to land downwind, failure to control the aircraft on the ground, and his decision to abort the landing after loss of control and damage to the aircraft on the ground. A factor in the accident was the gusty tail wind at the time…Nov 28, 1993 · N7950W · Substantial damageNTSB FTW94LA037Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's improper flare.Nov 27, 1993 · N4759G · Substantial damage