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.
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
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 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.NTSB CHI94LA046Accident · No injuriesLimited investigationFinal reportCessna 550 · West Chicago, ILthe collision with birds/geese shortly after takeoff. Reduced visibility in fog was a factor.NTSB 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.NTSB ANC94LA021Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Napakiak, AKThe pilot-in-command's failure to maintain proper approach airspeed.NTSB 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.NTSB 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.NTSB 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.NTSB LAX94LA067Accident · No injuriesLimited investigationFinal reportCessna 182Q · Grand Canyon, AZthe pilot's use of an excessive approach airspeed and an improper bounced landing recovery technique.NTSB 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…NTSB CHI94LA043Accident · Serious injuriesLimited investigationFinal reportCleveland Piel Emeraude CP-304 · Warrensburg, MOthe intentional entry of a stall/spin by the student pilot.NTSB 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.NTSB 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.NTSB ATL94LA025Accident · Minor injuriesLimited investigationFinal reportSikorsky H34-G · Walterboro, SCThe seizure of the aircraft throttle to engine linkage for unknown reasons.NTSB 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.NTSB MIA94FA030Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Daytona Beach, FLLoss of aircraft control for an undetermined reason.NTSB LAX94LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Fallon, NVthe pilot's intentional continued flight into known adverse weather conditions.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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,…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB FTW94LA037Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's improper flare.