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 CHI90LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochester, INFailure of the student pilot to maintain directional control and/or properly compensate for the wind conditions. Factors related to the accident were: the unfavorable wind conditions and the ditch.NTSB ATL90LA049Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Talladega, ALThe pilot's improper inflight decision to attempt to continue VFR flight IMC conditions with no instrument rating, clearance or experience.NTSB ANC90FA025Accident · No injuriesField investigationFinal reportCessna 150 · Anchorage, AKFailure of the student pilot to maintain directional control, which resulted in an inadvertent ground swerve. The snowbank was a related factor.NTSB MKC90LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · St Cloud, MNInadequate visual outlook by the pilot and his failure to maintain clearance from the light pole. The location of the pole was considered to be a related factor.NTSB MKC90LA041Accident · No injuriesLimited investigationFinal reportMancini Rotorway Exec · Mountain Iron, MNFailure of the non-certificated pilot to maintain adequate altitude, while maneuvering the helicopter. The pilot's lack of experience and proper certification (qualification) were related factors.NTSB LAX90LA066Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Santa Ana, CAThe failure of bolts retaining the idler shaft allowing the cam shift timing to change and by its failure to drive the left magneto.NTSB LAX90FA068Accident · 1 fatalField investigationFinal reportCessna 182P · Napa, CAThe failure of the pilot to properly execute the published approach and missed approach which resulted in a collision with mountainious terrain.NTSB CHI90LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · Traverse City, MIImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB CHI90DEK03Accident · No injuriesFinal reportPiper PA-23-250 · Columbus, OHPilot's inadequate preflight of the airplane and the continued operation of the airplane with a nose gear steering problem.NTSB ATL90LA048Accident · No injuriesLimited investigationFinal reportCessna 172B · Killen, ALInadequate pre-flight planning by the pilot in command which resulted in fuel exhaustion during cruise flight.NTSB ATL90DMG01Accident · 1 fatalFinal reportWaldron Flybaby · Troy, NCPoor judgement of the non-rated pilot, due to impairment from consumption of alcohol, his lack of training/qualification, his improper use of the engine controls which resulted in loss of engine power from probable carburetor ice, and his failure to maintain…NTSB MIA90FA050Accident · Serious injuriesField investigationFinal reportPiper PA-30 · Tallahassee, FLPilot factor in that he failed to maintain a/c control in instrument meteorological conditions due to spatial disorientation caused by fixation of an undetermined light source.NTSB MIA90FA049Accident · 1 fatalField investigationFinal reportLockheed L1329 · Miami, FLThe pilot's improper decision to reject the takeoff after the airplane had passed V1 speed and lifted off the runway. A factor was a malfunctioning #2 engine electronic engine conttrol which caused the unit to over-schedule fuel to the engine resulting in…NTSB LAX90LA065Accident · No injuriesLimited investigationFinal reportHughes 269C · Rialto, CAThe lack of adequate supervision by the instructor pilot during a critical phase of flight when he allowed a student to perform in an unsafe manner without taking immediate corrective action.NTSB LAX90LA064Accident · No injuriesLimited investigationFinal reportCessna 185 · Agua Dulce, CAPilot's improper weather evaluation which directly led to his attempted takeoff in an excessive tailwind and subsequent loss of aircraft control during the unsuccessful abort.NTSB LAX90DUQ01Accident · Minor injuriesFinal reportDavidson Throp T-18 · Camarillo, CAPilots failure to maintain directional control while landing in a crosswind.NTSB FTW90LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Glencoe, OKThe power loss due to carburetor ice, which resulted from the pilot's failure to engage carburetor heat in a timely manner. A factor in this accident was the pilot's lack of total experience.NTSB CHI90LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Newark, ILImproper planning/decision by the pilot. The wet condition of the grass runway was a related factor.NTSB ANC90LA024Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Bettles, AKFailure of the pilot to maintain sufficient altitude. Factors related to the accident were: the high density altitude, high wind, downdraft, and mountainous terrain.NTSB MIA90LA048Accident · No injuriesLimited investigationFinal reportCessna 172RG · Astatula, FLLoss of engine power for an undetermined reason during a simulated forced landing.NTSB CHI90LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Steubenville, OHThe student pilot's improper landing flare.NTSB MIA90IA047Incident · No injuriesIncident investigationFinal reportBoeing 727-251 · Madison, FLThe failure of company service personnel to properly service the airplane forward lavatory.NTSB FTW90LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Hammond, LAPilot in command's initiation and continuation of the flight into an area of known IMC weather conditions and his subsequent inability to land prior to running out of fuel. Contributing factors to the accident were the pilot's failure to exercise good…NTSB NYC90LA045Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Slippery Rock, PALoss of airspeed and an inadvertent stall by the pilot during an attempted return to the airport, following a power loss due to carburetor ice.NTSB NYC90DFJ01Accident · No injuriesFinal reportSteele Acrosport II · Penn Yan, NYFailure of the pilot to maintain directional control during the takeoff ground run. His lack of experience & the snowbank were related factors.NTSB LAX90LA063Accident · No injuriesLimited investigationFinal reportMooney Mark 22 · Apple Valley, CAThe failure of the pilot of the Mooney to stop his aircraft in a timely manner to avoid a collision.NTSB BFO90LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Petersburg, VAFuel starvation and improper use of emergency procedures (fuel selector) by the pilot.NTSB ATL90LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Whiteville, NCThe student pilot's failure to maintain sufficient airspeed through the landing flare to avoid a loss of directional control. Contributing to the accident was his failure to anticipate control inputs required by increased thrust during the go around.NTSB NYC90LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Millis, MAThe pilot's improper use of carburetor heat which caused a power loss and a forced landing in unsuitable terrain. Factors related to the accident were carburetor icing conditions and the pilots lack of total experience.NTSB BFO90FA017Accident · Serious injuriesField investigationFinal reportDouglas DC-10 · Baltimore, MDInjuries associated with the evacuation of the aircraft.NTSB CHI90LA059Accident · No injuriesLimited investigationFinal reportCessna 150F · Elkhart, INFailure of the pilot to maintain directional control of the aircraft, which resulted in his failure to maintain proper runway alignment. Factors related to the accident were the pilot's lack of experience in winter operations, the icy runway condition, and…NTSB LAX90FA061Accident · Minor injuriesField investigationFinal reportBoeing 737-204 · Tucson, AZFailure of the operator's maintenance personnel to detect an electrical wire which had chafed against a hydraulic line and which eventually arced causing a leak in the hydraulic line and subsequent fire and hydraulic system failure. In addition, previous wear…NTSB LAX90LA059Accident · No injuriesLimited investigationFinal reportPiper PA28-181 · Santa Barbara, CAThe pilot's failure to maintain adequate terrain clearance during a night visual approach.NTSB MKC90LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Norfolk, NEInproper in-flight planning/decision by the pilot and his delay in diverting to an alternate airport, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: the adverse weather conditions, the pilot's lack…NTSB MIA90FA046Accident · 1 fatalField investigationFinal reportCessna 172N · Meridian, MSIn flight loss of control by the pilot while flying in instrument meteorological conditions. Contributing factor(s) was: the pilot's apprehension toward instrument flying and the adverse weather conditions that existed at the time.NTSB LAX90FA060Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Santa Rosa, CAThe pilot's improper preflight planning/decision which resulted in the loss of tail rotor effectiveness. Contributing to the accident was the pilot allowing the maximum gross weight of the aircraft to be exceeded, and the tailwind.NTSB DEN90LA037Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Tularosa, NMThe pilot's VFR flight into instrument meteorological conditions (IMC), and his failure to see and avoid the road sign during the precautionary landing. The adverse weather was a realted factor.NTSB CHI90LA057Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Lizton, INSelection of unsuitable terrain by the pilot and his failure to abort the takeoff. Factors related to the accident were: interpersonal relations of the pilot, terrain condition and fence on or near the airstrip, the pilot's lack of experience in the type of…NTSB CHI90LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jenison, MIThe pilot's failure to maintain adequate airspeed during the approach. A contributing factor was the icing condition that existed at the time of the accident.NTSB ATL90LA047Accident · Serious injuriesLimited investigationFinal reportMorrisey 2150A · Winston Salem, NCA blocked fuel vent line, which prevented normal fuel flow to the engine and subsequent loss of power.NTSB ANC90LA023Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Tanana, AKFailure of the right main gear axle bolt.NTSB NYC90LA043Accident · No injuriesLimited investigationFinal reportCessna 150L · Lehighton, PALoss of engine power for an undetermined reason.NTSB MIA90LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Sarasota, FLExcessive airspeed for landing and improper flare by the pilot, which resulted in an inadvertent porpoise; and the pilot's improper recovery from a bounced landing, which resulted in a hard landing. A related factor was the crosswind condition.NTSB MIA90FA044Accident · Serious injuriesField investigationFinal reportCessna 210M · Stuart, FLThe pilot's improper calculation of fuel consumption which resulted in an inadequate fuel supply to reach his destination.NTSB FTW90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Clinton, OKPilots failure to correctly maintain the proper glidepath, which caused him to impact short of the runway.NTSB FTW90DRD01Accident · No injuriesFinal reportLong E-Z-E Long E-Z-E- · Hammond, LAInadequate aircraft handling and recovery from a bounced landing. Factors were gusty wind conditions, the pilot's failure to maintain directional control, and the pilot's lack of familiarity with the airplane.NTSB DEN90LA036Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. The snowbank was a related factor.NTSB CHI90LA058Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Chillicothe, OHImproper planning/decision by the student pilot, which resulted in a landing on a slick runway, and his failure to maintain directional control during the landing, which resulted in his inability to maintain runway alignment. Contributing factors were: the…NTSB CHI90LA051Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INFailure of the student pilot to maintain directional control and his improper use of (normal) brakes. His decision to make a running takeoff, his lack of total experience, and the snowbank were contributing factors.NTSB CHI90FA056Accident · No injuriesField investigationFinal reportCessna 340 · Merrill, WIFailure of the pilot to maintain proper alignment with the runway during his landing roll and an inflight encounter with icing conditions.