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 NYC96LA080Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Old Bridge, NJfuel contamination, due to improper servicing of the aircraft, which resulted in fuel starvation, loss of engine power, a forced landing, and collision with a tree. The strong surface wind was a related factor.Apr 2, 1996 · N9625R · Substantial damageNTSB LAX96LA152Accident · 1 fatalLimited investigationFinal reportPowell Glasair · Groveland, CAthe pilot's decision to fly the aircraft with a known mechanical discrepancy in the throttle linkage, which resulted in a partial loss of engine power; and his failure to maintain an adequate airspeed while maneuvering for an emergency landing, which resulted…Apr 2, 1996 · N59LP · DestroyedNTSB ATL96LA075Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Bunnell, FLThe pilot's failure to obtain a preflight weather briefing and his failure to apply carburetor heat that resulted in a loss of engine power. A factor was weather conditions were favorable for the formation of carburetor icing at cruise flight.Apr 2, 1996 · N7355S · Substantial damageNTSB SEA96LA073Accident · No injuriesLimited investigationFinal reportCessna 500 · Salt Lake City, UTfatigue failure of the engine compressor impeller. Inadequate quality control by the manufacturer was a related factor.Apr 1, 1996 · N727TK · Substantial damageNTSB FTW96LA158Accident · Minor injuriesLimited investigationFinal reportStafford RV-4 · Longmont, COthe pilot's inadequate preflight planning and preparation in that he failed to ensure the aircraft had sufficient fuel to complete the flight. A factor was the soft terrain.Apr 1, 1996 · N84PS · Substantial damageNTSB CHI96LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Grand Haven, MIfailure of the dual student to maintain directional control of the airplane during the landing, and inadequate supervision by the flight instructor.Apr 1, 1996 · N454Q · Substantial damageNTSB CHI96LA123Accident · No injuriesLimited investigationFinal reportCessna 206 · Ulysses, KSFailure of the pilot to maintain control of the airplane, while taxiing. Factors relating to the accident were: the high, gusty, crosswind condition; and loose gravel on the roadway.Apr 1, 1996 · N6237Q · Substantial damageNTSB CHI96LA122Accident · No injuriesLimited investigationFinal reportCessna 210K · West Chicago, ILMaintenance personnel's failure to comply with an airworthiness directive on the landing gear which led to a retraction/extension assembly malfunction.Apr 1, 1996 · N9470M · Substantial damageNTSB ATL96LA073Accident · No injuriesLimited investigationFinal reportCanadair CL-600S · Raleigh, NCthe flight crew's inadequate emergency procedure in that they did not manually extend the landing gear, as specified in the airplane flight manual. A factor relating to the accident was: the intermittent operation of the extend solenoid in the nose gear…Apr 1, 1996 · N999TF · Substantial damageNTSB ATL96FA074Accident · 2 fatalField investigationFinal reportCessna P210N · Marathon, FLfailure of the pilot to maintain sufficient altitude during an over-water approach at night. Factors relating to the accident were darkness and pilot fatigue.Apr 1, 1996 · N6427W · Substantial damageNTSB ANC96LA042Accident · No injuriesLimited investigationFinal reportDouglas DC-6-B · Beluga, AKThe Pilot-in-Command's selection of an unsuitable terrain area for taxi/parking and his misjudgment of the clearance required.Apr 1, 1996 · N861TA · Substantial damageNTSB SEA96IA074Incident · No injuriesIncident investigationFinal reportDornier DO 328-100 · Eugene, ORdelamination of the wing de-icing boot, due to the boot reaching its life limit.Mar 31, 1996 · N334PH · Minor damageNTSB NYC96LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Matawan, NJthe pilot's misjudgment of altitude and distance during final approach.Mar 31, 1996 · N9101P · Substantial damageNTSB LAX96LA151Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Sacramento, CAA loss of engine power due to carburetor ice and the student's failure to use carburetor heat. The carburetor icing (weather) condition was a related factor.Mar 31, 1996 · N5266Q · Substantial damageNTSB LAX96LA150Accident · Minor injuriesLimited investigationFinal reportLampert Revolution M500 · San Carlos, CAthe pilot's failure to recognize a drive train disengagement and initiate an autorotation. The inadequate engine-to-transmission drive belt/pulley design, and the pilot's limited training and experience in rotorcraft operations were factors in this accident.Mar 31, 1996 · N750GL · Substantial damageNTSB CHI96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Thief Rvr Falls, MNA ruptured oil line, which resulted in oil exhaustion and subsequent loss of engine power.Mar 31, 1996 · N5932U · Substantial damageNTSB ATL96LA071Accident · No injuriesLimited investigationFinal reportMeeker JUNGSTER-1 · Ormond Beach, FLthe pilot's failure to maintain directional control during a landing, which resulted in a ground loop. A factor relating to the accident was: the pilot's lack of total experience in type of aircraft.Mar 31, 1996 · N8VM · Substantial damageNTSB ANC96LA040Accident · No injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKthe pilot's inadequate compensation for gusty crosswind conditions. The strong, gusty crosswind was a factor.Mar 31, 1996 · N9875X · Substantial damageNTSB LAX96LA164Accident · Minor injuriesLimited investigationFinal reportRussman Avid Flyer · Searchlight, NVan engine failure from oil exhaustion due to a leak in the oil line.Mar 30, 1996 · N5439V · Substantial damageNTSB LAX96LA148Accident · No injuriesLimited investigationFinal reportCessna 172P · Fullerton, CAthe student pilot's inadequate compensation for the encounter with wake turbulence from a preceding small aircraft, and his improper bounced landing recovery technique.Mar 30, 1996 · N9964L · Substantial damageNTSB IAD96FA055Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Wareham, MALoss of engine power due to bearing insert being destroyed by excess heat. A factor in this accident is the pilot's experience level.Mar 30, 1996 · N57012 · DestroyedNTSB ANC96LA048Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Soldotna, AKThe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.Mar 30, 1996 · N6443M · Substantial damageNTSB NYC96WA082Accident · No injuriesForeign investigationCessna C340 · Valreas, FranceMar 29, 1996 · N2675Y · Substantial damageNTSB MIA96TA112Accident · No injuriesFinal reportCessna 210 · Lakeland, FLthe pilot's improper flare on landing, and his improper use of flight controls on landing rollout.Mar 29, 1996 · N2306D · Substantial damageNTSB LAX96LA147Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Torrance, CAinadequate maintenance and inspection of the airplane; rust and water contamination in the aircraft fuel system; a worn shaft and cracked coupling in the left engine's left magneto, a malfunctioning left magneto on the right engine, and contamination (oil and…Mar 29, 1996 · N14260 · Substantial damageNTSB LAX96LA146Accident · Serious injuriesLimited investigationFinal reportLuckett Flybaby 1A · Castiac, CAThe pilot's improper in-flight planning/decision. The terrain condition and low ceiling were related factors.Mar 29, 1996 · N71658 · DestroyedNTSB CHI96LA127Accident · No injuriesLimited investigationFinal reportSocata TBM-700 · Eau Claire, WIfatigue fracture and subsequent failure of the gear door hinge bracket.Mar 29, 1996 · N292RG · Substantial damageNTSB CHI96FA120Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lincoln, KSthe pilot became spatially disoriented and failed to maintain control of the airplane. The factors involved were the pilot encountered VFR flight into IMC, pressure induced by conditions/events, low ceilings, and the dark light conditions.Mar 29, 1996 · N8214W · DestroyedNTSB ATL96LA072Accident · No injuriesLimited investigationFinal reportCessna 140 · Elkin, NCfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.Mar 29, 1996 · N89297 · Substantial damageNTSB ANC96IA039Incident · No injuriesIncident investigationFinal reportHelio H295 · Angoon, AKthe pilot's inadequate compensation for the gusty wind conditions. A factor associated with the accident was the gusty wind conditions.Mar 29, 1996 · N5462E · Minor damageNTSB SEA96LA075Accident · No injuriesLimited investigationFinal reportRyan Navion · Kent, WAthe pilot's attempted operation with known deficiencies in the equipment, and a loose fuel system fitting. The pilot's failure to maintain maintenance service on the airplane was a factor.Mar 28, 1996 · N4826K · Substantial damageNTSB MIA96IA109Incident · No injuriesIncident investigationFinal reportBeech 1900D · Jacksonville, FLFailure of a blade counterweight clamp retaining screw due to cadmium embrittlement which occurred during the manufacture process. This resulted in the counterweight clamp separating and striking the adjacent blade causing it to separate.Mar 28, 1996 · N29YV · Minor damageNTSB ATL96LA070Accident · No injuriesLimited investigationFinal reportO'Connell Christen Eagle · New Smyrna Bch, FLthe failure of the pilots of the Cessna 152, N757NP, to see and avoid the Christen Eagle, N13LD.Mar 28, 1996 · N13LD · 2 aircraft · Substantial damageNTSB NYC96LA079Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Groton, NYthe pilot's inadequate fuel management, and his improper use of the fuel selector valve, which resulted in fuel starvation and the subsequent collision with bails of hay during the forced landing.Mar 27, 1996 · N9974U · Substantial damageNTSB MIA96LA107Accident · No injuriesLimited investigationFinal reportBoeing 727-225 · Memphis, TNfailure of the flightcrew to maintain clearance from construction equipment while taxiing after landing. Factors relating to the accident were: failure of operator personnel to supply the flightcrew with current NOTAM information, failure of ATC personnel to…Mar 27, 1996 · N468FE · Substantial damageNTSB IAD96LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Taplin, WVthe pilot's improper level off and recovery from a bounced landing.Mar 27, 1996 · N61546 · Substantial damageNTSB SEA96LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Lynnwood, WAa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Mar 26, 1996 · N5638H · Substantial damageNTSB MIA96LA106Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Defuniak Spring, FLThe pilot's inadvertent flight into instrument meteorological conditions, and inadvertent descent, due to spatial disorientation, which resulted in a collision with trees. Factors relating to the accident were: the adverse weather conditions and the pilot's…Mar 26, 1996 · N56874 · DestroyedNTSB CHI96LA119Accident · No injuriesLimited investigationFinal reportAyres S2-R · Wyatt, MOthe pilot's failure to maintain control of the airplane during takeoff. A factor was the crosswind condition.Mar 26, 1996 · N3024V · Substantial damageNTSB ANC96LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Palmer, AKthe pilot's selection of an unsuitable area for landing.Mar 26, 1996 · N39966 · Substantial damageNTSB LAX96LA145Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, CAinadequate preflight by the pilot, and subsequent fuel exhaustion, due to an inadequate supply of fuel. Darkness and trees in the emergency landing area were related factors.Mar 25, 1996 · N24963 · Substantial damageNTSB FTW96FA156Accident · Serious injuriesField investigationFinal reportThunder and Colt 180A · Hartsel, COThe pilot's selection of unsuitable terrain on which to make a landing. The rocky terrain was a related factor.Mar 25, 1996 · N767TC · DestroyedNTSB NYC96FA078Accident · 1 fatalField investigationFinal reportCessna 150J · Warwick, NYthe pilot's mismanagement of the fuel supply, which resulted in fuel exhaustion. A related factor was the pilot's lack of recent experience.Mar 24, 1996 · N5587G · DestroyedNTSB MIA96LA104Accident · No injuriesLimited investigationFinal reportCessna 150F · Ocala, FLthe student pilot's inadequate compensation for the wind during the landing flare.Mar 24, 1996 · N6679F · Substantial damageNTSB FTW96LA155Accident · 1 fatalLimited investigationFinal reportDomaille Rans S-12 · Albuquerque, NMthe student pilot's failure to maintain control of the aircraft after initiating a flight into adverse weather conditions. The strong, gusting wind was a factor.Mar 24, 1996 · N4017S · Substantial damageNTSB FTW96LA154Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Slidell, LAthe pilot's failure to maintain aircraft control during the approach, and his failure to execute a go-around. A factor was the gusting wind.Mar 24, 1996 · N9385T · Substantial damageNTSB CHI96FA117Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Carrollton, OHthe pilot's inadequate compensation for the crosswind condition, his failure to maintain directional control, and his failure not raise the landing flaps during the go-around. The crosswind was a factor.Mar 24, 1996 · N7452W · DestroyedNTSB NYC96LA077Accident · No injuriesLimited investigationFinal reportRobinson R22-BETA · Fairfield, NJthe flight instructor's inadequate supervision in that he delayed corrective action in recovering the low rotor RPM resulting in a loss of control.Mar 23, 1996 · N221CW · Substantial damageNTSB LAX96LA144Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20D · Hollister, CAthe pilot's improper in-flight decision to take a longer than necessary route back to the airport during a period of marginal lift.Mar 23, 1996 · N4HT · Substantial damageNTSB LAX96LA143Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Upland, CAfuel system contamination and the pilot's intentional operation of a known unairworthy aircraft.Mar 23, 1996 · N7044T · Substantial damage