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 MIA96LA085Accident · Minor injuriesLimited investigationFinal reportPiper PA-30-160 · St. Petersburg, FLthe pilot's failure to maintain the glide slope and becoming distracted by a passenger.Feb 21, 1996 · N8740Y · Substantial damageNTSB LAX96LA124Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Tracy, CAoverheating and failure of the engine's master rod and master rod bearing due to oil starvation. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.Feb 21, 1996 · N6674Q · Substantial damageNTSB FTW96LA127Accident · No injuriesLimited investigationFinal reportCessna 175A · San Angelo, TXa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the forced landing.Feb 21, 1996 · CGROA · Substantial damageNTSB FTW96LA123Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Dallas, TXfailure of the pilot to use a more favorable runway, and his failure to go-around, when he realized the airplane would not touch down at the proper touchdown point. Factors relating to the accident were: the inoperative flap motor, failure of the pilot to…Feb 21, 1996 · N4825J · Substantial damageNTSB FTW96IA124Incident · No injuriesIncident investigationFinal reportBritish Aerospace Avro 146-RJ70A · Rifle, COThe copilot's failure to compensate for wind conditions, resulting in excessive airspeed, and his failure to attain the proper runway touch down point. Factors were inadequate dispatch procedures and the captain's improper inflight planning/decision in that…Feb 21, 1996 · N832BE · No damageNTSB SEA96LA062Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332 · Portland, ORthe passenger's unsuccessful (improper) evacuation of the aircraft. The malfunctioning APU was a related factor in that it torched and produced smoke, due to a faulty fuel control unit and/or gearbox shutoff valve, thereby prompting an emergency evacuation of…Feb 20, 1996 · N125DL · No damageNTSB NYC96LA063Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300B4-605R · Jamaica, NYunsuccessful use of the evacuation slides by passengers during an emergency evacuation of the aircraft. The hydraulic valve failure, subsequent hydraulic leak, and resultant smoke were related factors.Feb 20, 1996 · N11060 · Minor damageNTSB MIA96WA083Accident · 1 fatalForeign investigationCessna 207 · San Jose, Costa RicaFeb 20, 1996 · TIAGP · DestroyedNTSB MIA96LA080Accident · No injuriesLimited investigationFinal reportBerkshire Concept 70 · Boynton Beach, FLan engine loss of power and fire for undetermined reasons.Feb 20, 1996 · N29BW · DestroyedNTSB LAX96FA115Accident · 3 fatalField investigationFinal reportCessna 172N · Julian, CAthe pilot's delay in requesting assistance to avoid high terrain. Factors were: the downdrafts, mountainous terrain, and the pilot's improper in-flight planning.Feb 20, 1996 · N738ED · DestroyedNTSB IAD96LA045Accident · Serious injuriesLimited investigationFinal reportAdvanced Technology Ultra Sport 254 · West Point, VAthe pilot's failure to maintain control of the helicopter during low altitude flight/maneuvering, which resulted in the helicopter impacting terrain. A related factor was the pilot's lack of flight experience in the make and model of helicopter.Feb 20, 1996 · N254AS · DestroyedNTSB IAD96IA048Incident · Minor injuriesIncident investigationFinal reportBoeing 767-2B7 · Pittsburgh, PAthe in-flight encounter with unforecast turbulence.Feb 20, 1996 · N656US · No damageNTSB IAD96IA044Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Washington, DCexcessive airspeed was maintained by the captain during the approach/landing phase of the flight, which resulted in an overrun and an encounter with soft/wet terrain. Factors relating to the incident were: the pilot's failure to attain the proper touchdown…Feb 20, 1996 · N33202 · Minor damageNTSB FTW96FA120Accident · 1 fatalField investigationFinal reportBeech A36 · Katy, TXa loss of control due to pilot incapacitation for undetermined reasons. A factor related to the pilot's injuries was the lack of shoulder harness restraint.Feb 20, 1996 · N2TC · Substantial damageNTSB ATL96IA053Incident · No injuriesIncident investigationFinal reportEmbraer 120 · Raleigh, NCThe operator's inadequate progressive inspection program that did not require periodic analysis of airplane hydraulic system fluid; and the failure of the operator to comply with the airplane manufacturer's maintenance manual resulting in contamination of the…Feb 20, 1996 · N129AM · No damageNTSB ATL96FA051Accident · 1 fatalField investigationFinal reportSukhoi SU-31 · Immokalee, FLthe manufacturer's improper composite curing process, which resulted in wing spar voids and subsequent failure of the wing during aerobatic flight.Feb 20, 1996 · N31MX · DestroyedNTSB ANC96LA026Accident · No injuriesLimited investigationFinal reportBoeing 757-232 · Fairbanks, AKinadequate visual lookout by the flightcrew of the Delta Boeing 757, N622DL, and their failure to follow procedures and directives by not closely following the ramp marshals' signals.Feb 20, 1996 · N622DL · 2 aircraft · Minor damageNTSB SEA96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Vancouver, WAthe pilot's failure to use carburetor heat, and his delay in aborting the takeoff after noting sluggish acceleration. Factors were: the carburetor icing conditions, the trees off the end of the runway, and the soft ground conditions in the forced landing area.Feb 19, 1996 · N3272J · Substantial damageNTSB SEA96LA059Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Spanaway, WAfailure of the pilot to use all available runway, including the overrun area, to stop the airplane. Factors relating to the accident were: the wet runway, and the pilot's inability to see the overrun from the runway due to the sloping terrain.Feb 19, 1996 · N2237P · Substantial damageNTSB MIA96FA082Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Morganton, NCthe pilot's delay in initiating a go-around (aborted landing), which resulted in his failure to obtain/maintain sufficient altitude or clearance from trees beyond the end of the runway. Factors relating to the accident were: the pilot's failure to ensure…Feb 19, 1996 · N448P · DestroyedNTSB LAX96FA119Accident · 1 fatalField investigationFinal reportBeech C35 · Lee Vining, CAFuel starvation due to the pilot's failure to adequate monitor the aircraft's fuel system and select a tank containing fuel in a timely manner. The pilot's failure to monitor the fuel system was due to the effects of hypoxia. Factors in the accident were the…Feb 19, 1996 · N2PA · DestroyedNTSB FTW96FA118Accident · Minor injuriesClass 1 · FieldFinal reportMcDonnell Douglas DC-9-32 · Houston, TXthe captain's decision to continue the approach contrary to Continental Airlines (COA) standard operating procedures that mandate a go-around when an approach is unstabilized below 500 feet or a ground proximity warning system alert continues below 200 feet…Feb 19, 1996 · N10556 · Substantial damageNTSB CHI96FA094Accident · 2 fatalField investigationFinal reportCessna 182 · Odell, ILVFR flight by the pilot into instrument meteorological conditions (IMC), and subsequent loss of aircraft control, probably due to spatial disorientation of the pilot. Factors relating to the accident were: darkness, reduced visibility due to the weather…Feb 19, 1996 · N3243Y · DestroyedNTSB CHI96FA091Accident · 2 fatalField investigationFinal reportHughes 369D · Dweese, NEthe pilot's improper in-flight planning and decision, and his lack of total experience in the type of operation. A factor was the crosswind.Feb 19, 1996 · N5141Y · DestroyedNTSB MIA96LA081Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Miami, FLFailure of the pilot to maintain proper runway alignment during a go-around, resulting in a collision with trees beside the runway. The crosswind was a related factor.Feb 18, 1996 · N2923B · Substantial damageNTSB LAX96FA114Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · New River, AZfailure of the pilot to maintain proper altitude/clearance above the terrain, while performing an aerobatic maneuver.Feb 18, 1996 · N2596Z · DestroyedNTSB CHI96LA093Accident · No injuriesLimited investigationFinal reportCessna 172 · Worthington, MNProgressive failure of the engine, beginning with failure of the left magneto, which resulted in preignition or detonation, a burned hole in the #3 piston, subsequent oil exhaustion, and failure of the #1 and #2 connecting rods.Feb 18, 1996 · N758CQ · Substantial damageNTSB ATL96LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Jackson, MSloss of engine power during takeoff for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.Feb 18, 1996 · N166F · Substantial damageNTSB MIA96LA175Accident · 1 fatalLimited investigationFinal reportPiper PA-60-601P · Atlantic Ocean (Atlantic Ocean)pilot incapacitation.Feb 17, 1996 · N956AF · DestroyedNTSB LAX96LA190Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Tucson, AZthe interruption to the pilot's planned landing approach due to obstructions in the original touchdown spot, which led to the pilot misjudging the landing flare.Feb 17, 1996 · N6317U · No damageNTSB LAX96LA118Accident · No injuriesLimited investigationFinal reportRockwell 112B · Elk Grove, CAthe pilot's improper planning/decision and delay in aborting the takeoff. Factors relating to the accident were: the short runway, high obstructions near the departure end of the runway, and wind shear.Feb 17, 1996 · N1233J · Substantial damageNTSB LAX96LA117Accident · No injuriesLimited investigationFinal reportCessna 172P · Raymond, CAThe pilot's failure to verify the quantity of fuel onboard the aircraft prior to departure, which resulted in fuel exhaustion.Feb 17, 1996 · N53115 · Substantial damageNTSB LAX96LA112Accident · 1 fatalLimited investigationFinal reportSteeves KR2 · San Diego, CAfailure of the pilot to maintain an adequate airspeed margin above stall, while at low altitude in the traffic pattern. His decision to explore the slow speed envelope of the aircraft at low altitude was a related factor.Feb 17, 1996 · N395DS · DestroyedNTSB IAD96LA043Accident · No injuriesLimited investigationFinal reportCessna 177A · Sidney, OHfuel contamination, and the pilot's inadequate preflight inspection, which resulted in subsequent loss of engine power during cruise flight. A factor relating to the accident was: rough terrain in the emergency landing area.Feb 17, 1996 · N30422 · Substantial damageNTSB IAD96LA042Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Cynthiana, KYThe pilot's failure to obtain proper assistance to secure the airplane.Feb 17, 1996 · CFLBW · Substantial damageNTSB FTW96LA125Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Dallas, TXFailure of the unqualified helicopter pilot to maintain control of the helicopter. Factors relating to the accident were: his lack of total experience in helicopters and his improper decision to attempt to hover without appropriate training/endorsement for…Feb 17, 1996 · N8897F · Substantial damageNTSB FTW96LA122Accident · No injuriesLimited investigationFinal reportCessna 182P · New Orleans, LAThe pilot not following procedures and directives in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing weather conditions and lack of suitable terrain for landing.Feb 17, 1996 · N9901M · Substantial damageNTSB CHI96LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Larned, KSFailure of the pilot to use adequate procedures for hand priming (hand propping) the engine.Feb 17, 1996 · N9793J · DestroyedNTSB ATL96FA049Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Johns Island, SCthe pilot's inadequate evaluation of the weather conditions and the continued flight into icing conditions which resulted in the loss of engine power. A factor was conditions favorable for the formation of carburetor icing.Feb 17, 1996 · N3052T · Substantial damageNTSB SEA96LA056Accident · No injuriesLimited investigationFinal reportCessna 172P · Cashmere, WAthe pilot's selection of the wrong runway for landing, by not observing a procedure to land uphill during calm wind conditions, and his subsequent failure to retract the flaps during landing roll, as recommended by the airplane's short-field landing…Feb 16, 1996 · N52264 · Substantial damageNTSB SEA96FA061Accident · 1 fatalField investigationFinal reportCessna 402B · Estacada, ORloss of aircraft control for undetermined reason(s).Feb 16, 1996 · N5198J · DestroyedNTSB NYC96LA064Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Stratford, CTinadequate visual lookout by the pilot and the vehicle operator, resulting in their failure to see and avoid each other.Feb 16, 1996 · N8137D · Substantial damageNTSB LAX96LA113Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18-A · Blythe, CAthe pilot's premature lift-off and subsequent loss of control due to his failure to monitor the airspeed indicator during the takeoff roll.Feb 16, 1996 · N92640 · DestroyedNTSB FTW96LA139Accident · No injuriesLimited investigationFinal reportRockwell 500U · Hampton, ARImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for a forced landing.Feb 16, 1996 · N197K · Substantial damageNTSB FTW96LA121Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Carrizo Springs, TXa loss of engine power for undetermined reasons, and the pilot's improper touchdown.Feb 16, 1996 · N67065 · Substantial damageNTSB SEA96LA055Accident · No injuriesLimited investigationFinal reportCessna 172P · Salmon, IDfailure of the pilot to maintain directional control during the landing, which resulted in a ground swerve. A factor relating to the accident was: the rock pile to the left of the runway.Feb 15, 1996 · N96879 · Substantial damageNTSB NYC96WA070Accident · 5 fatalForeign investigationPiper PA-46 · ZambiaFeb 15, 1996 · N2514Q · DestroyedNTSB CHI96LA089Accident · No injuriesLimited investigationFinal reportCessna 210 · Shelbyville, ILthe pilot's misjudged flare and improper recovery from a bounced landing. Factors relating to the accident were: the pilot's improper use of procedure by wearing unapproved correcting lenses, and his resultant decreased depth perception.Feb 15, 1996 · N9614X · Substantial damageNTSB CHI96FA090Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Brookston, INthe pilot's disregard for the forecast adverse weather conditions, his inadvertent flight into adverse weather conditions, and his disorientation. Factors relating to this accident were the pilot's lack of experience in instrument conditions, the snow and fog.Feb 15, 1996 · N4612F · DestroyedNTSB ATL96LA048Accident · 2 fatalLimited investigationFinal reportMcrae Titan Acft Tornado · Pahokee, FLthe pilot's failure to maintain airspeed while maneuvering.Feb 15, 1996 · N6234X · Substantial damage