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 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.Jan 8, 1990 · N6141Q · Substantial damageNTSB 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.Jan 8, 1990 · N7950F · DestroyedNTSB 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.Jan 8, 1990 · N63414 · Substantial damageNTSB 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.Jan 7, 1990 · N97984 · Substantial damageNTSB 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.Jan 7, 1990 · N4463N · Substantial damageNTSB 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.Jan 7, 1990 · N74520 · Substantial damageNTSB 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.Jan 7, 1990 · N1283S · DestroyedNTSB 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.Jan 7, 1990 · N6763G · Substantial damageNTSB 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.Jan 7, 1990 · N35ST · Substantial damageNTSB ATL90LA048Accident · No injuriesLimited investigationFinal reportCessna 172B · Killen, ALInadequate pre-flight planning by the pilot in command which resulted in fuel exhaustion during cruise flight.Jan 7, 1990 · N7401X · Substantial damageNTSB 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…Jan 7, 1990 · N91089 · DestroyedNTSB 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.Jan 6, 1990 · N7030Y · DestroyedNTSB 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…Jan 6, 1990 · N96GS · DestroyedNTSB 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.Jan 6, 1990 · N7456F · DestroyedNTSB 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.Jan 6, 1990 · N9816X · DestroyedNTSB LAX90DUQ01Accident · Minor injuriesFinal reportDavidson Throp T-18 · Camarillo, CAPilots failure to maintain directional control while landing in a crosswind.Jan 6, 1990 · N66MY · Substantial damageNTSB 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.Jan 6, 1990 · N5414P · Substantial damageNTSB CHI90LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Newark, ILImproper planning/decision by the pilot. The wet condition of the grass runway was a related factor.Jan 6, 1990 · N98923 · Substantial damageNTSB 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.Jan 6, 1990 · N2728P · Substantial damageNTSB MIA90LA048Accident · No injuriesLimited investigationFinal reportCessna 172RG · Astatula, FLLoss of engine power for an undetermined reason during a simulated forced landing.Jan 5, 1990 · N6290R · Substantial damageNTSB CHI90LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Steubenville, OHThe student pilot's improper landing flare.Jan 5, 1990 · N557PA · Substantial damageNTSB MIA90IA047Incident · No injuriesIncident investigationFinal reportBoeing 727-251 · Madison, FLThe failure of company service personnel to properly service the airplane forward lavatory.Jan 4, 1990 · N2280 · Minor damageNTSB 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…Jan 4, 1990 · N3531S · DestroyedNTSB 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.Jan 3, 1990 · N4636E · Substantial damageNTSB 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.Jan 3, 1990 · N896JC · Substantial damageNTSB 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.Jan 3, 1990 · N7716M · 2 aircraft · Substantial damageNTSB BFO90LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Petersburg, VAFuel starvation and improper use of emergency procedures (fuel selector) by the pilot.Jan 3, 1990 · N33685 · Substantial damageNTSB 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.Jan 3, 1990 · N94187 · Substantial damageNTSB 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.Jan 2, 1990 · N9241U · Substantial damageNTSB BFO90FA017Accident · Serious injuriesField investigationFinal reportDouglas DC-10 · Baltimore, MDInjuries associated with the evacuation of the aircraft.Jan 2, 1990 · N109AA · No damageNTSB 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…Jan 1, 1990 · N8575G · Substantial damageNTSB 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…Dec 31, 1989 · N198AW · Substantial damageNTSB LAX90LA059Accident · No injuriesLimited investigationFinal reportPiper PA28-181 · Santa Barbara, CAThe pilot's failure to maintain adequate terrain clearance during a night visual approach.Dec 30, 1989 · N8138E · Substantial damageNTSB 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…Dec 29, 1989 · N8157R · Substantial damageNTSB 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.Dec 29, 1989 · N733FK · DestroyedNTSB 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.Dec 29, 1989 · N1604L · DestroyedNTSB 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.Dec 29, 1989 · N9K · Substantial damageNTSB 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…Dec 29, 1989 · N3871H · Substantial damageNTSB 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.Dec 29, 1989 · N1294T · Substantial damageNTSB 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.Dec 29, 1989 · N5145V · Substantial damageNTSB ANC90LA023Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Tanana, AKFailure of the right main gear axle bolt.Dec 29, 1989 · N7615S · Substantial damageNTSB NYC90LA043Accident · No injuriesLimited investigationFinal reportCessna 150L · Lehighton, PALoss of engine power for an undetermined reason.Dec 28, 1989 · N11614 · Substantial damageNTSB 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.Dec 28, 1989 · N831SR · Substantial damageNTSB 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.Dec 28, 1989 · N456GS · Substantial damageNTSB 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.Dec 28, 1989 · N3809W · Substantial damageNTSB 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.Dec 28, 1989 · N77NW · DestroyedNTSB 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.Dec 28, 1989 · N75702 · Substantial damageNTSB 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…Dec 28, 1989 · N3647E · Substantial damageNTSB 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.Dec 28, 1989 · N2605P · Substantial damageNTSB 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.Dec 28, 1989 · N69556 · Substantial damage