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 LAX97LA014Accident · 1 fatalLimited investigationFinal reportCunningham Rotorway Exec · Mather, CAexcessive maneuvering by the pilot, which allowed the main rotor blades to contact and sever the tail rotor system and allowed mast bumping to occur.Oct 13, 1996 · N18WC · DestroyedNTSB IAD97LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Germantown, KYimproper maintenance with the installation of an improper oil ring on the number four piston, which led to failure of both the ring and pistion, oil starvation, and subsequent loss of engine power.Oct 13, 1996 · N8299U · Substantial damageNTSB IAD97LA007Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Harlan, KYthe pilot's misjudged distance and speed, and his faiure to attain the proper touchdown point during the landing, which resulted in overrun of the runway and an encounter with terrain.Oct 13, 1996 · N950Z · Substantial damageNTSB IAD97LA006Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Springfield, OHfailure of the pilot to maintain obstacle clearance, while maneuvering at low altitudes. A related factor was the quartering tail wind.Oct 13, 1996 · N42719 · Substantial damageNTSB FTW97LA018Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Oil City, LAthe failure of the pilots of both aircraft to maintain an adequate visual lookout. Factors were: different traffic pattern altitudes flown by the two pilots, and the sunglare encountered by the pilot of the ultralight.Oct 13, 1996 · N3818E · 2 aircraft · Substantial damageNTSB CHI97LA010Accident · 2 fatalLimited investigationFinal reportDellicker Starduster TOO SA300 · Eaton Rapids, MIthe pilot's failure to maintain adequate airspeed and subsequent inadvertent stall of the airplane. A factor was the ostentatious display.Oct 13, 1996 · N7691 · DestroyedNTSB CHI97LA007Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Hillsdale, MIthe pilot's improper in-flight planning/decision and failure to refuel which led to fuel exhaustion.Oct 13, 1996 · N5720B · DestroyedNTSB ATL97LA006Accident · No injuriesLimited investigationFinal reportCessna 337G · Fayetteville, NCThe unapproved maintenance modification of the landing gear electrical system by maintenance personnel that prevented the extension of the landing gear.Oct 13, 1996 · N20EC · Substantial damageNTSB ATL97LA004Accident · Serious injuriesLimited investigationFinal reportAeronca 65-C · Angier, NCThe Aeronca 65's pilots selection of the wrong taxi route, and his inadequate visual lookout during back taxi.Oct 13, 1996 · N23927 · 2 aircraft · Substantial damageNTSB ATL97LA003Accident · Serious injuriesLimited investigationFinal reportHarper W-8 Tailwind · Macclenny, FLthe pilot's inadequate preflight inspection, which resulted in loss of engine power due to fuel contamination.Oct 13, 1996 · N91323 · Substantial damageNTSB ANC97FA001Accident · 3 fatalField investigationFinal reportde Havilland DHC-2 · Ketchikan, AKcontinued flight by the pilot into adverse weather condition, and his failure to maintain adequate altitude/clearance from mountainous terrain. Factors related to the accident were the high/mountainous terrain, and weather conditions that included low…Oct 13, 1996 · N64276 · DestroyedNTSB SEA97LA014Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Albany, ORfailure of the SA-750 pilot to see-and-avoid the Cessna 172, which had landed ahead of him on the same runway. The inherent visual restrictions of the SA-750 (a tandem two-place biplane) was a related factor.Oct 12, 1996 · N9579H · 2 aircraft · Substantial damageNTSB SEA97LA013Accident · 2 fatalLimited investigationFinal reportKeith Vans RV-6A · Hurricane, UTthe pilot's impairment of judgment and performance due to drugs (diphenhydramine) which led to spatial disorientation and loss of aircraft control. Contributing to the accident were: dark night lighting conditions; inoperative airport runway lights; the…Oct 12, 1996 · N16DK · DestroyedNTSB LAX97WA017Accident · Serious injuriesForeign investigationPiper PA-28-140 · Kumamoto, JapanOct 12, 1996 · N210SK · Substantial damageNTSB LAX97LA016Accident · No injuriesLimited investigationFinal reportWaco QCF · Big Bear City, CAthe pilot's improper response to a perceived in-flight emergency by abruptly retarding the throttle and failing to properly flare the airplane during the aborted takeoff. The pilot's improper perception of the source of smoke was a related factor.Oct 12, 1996 · N11481 · Substantial damageNTSB LAX97LA015Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Agua Dulce, CAinadequate compliance with the applicable airworthiness directive by other maintenance personnel, and the pilot's inadequate preflight inspection which resulted in fuel exhaustion from a deteriorated fuel cap seal.Oct 12, 1996 · N4924D · Substantial damageNTSB LAX97LA013Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAthe student pilot's impairment of judgment and performance due to alcohol, his subsequent flight into adverse weather conditions, and his failure to maintain clearance from obstructions (power lines). Factors related to the accident were: darkness, low…Oct 12, 1996 · N2501X · DestroyedNTSB FTW97LA017Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boulder, COthe pilot's failure to maintain directional control and his improper use of rudder. A factor was the pilot's lack of total experience in the make and model of airplane.Oct 12, 1996 · N9967Q · Substantial damageNTSB CHI97LA009Accident · No injuriesLimited investigationFinal reportHayes Lancair 235 · Kansas City, MOa stuck carburetor float valve which resulted in excessive fuel flow and ultimately fuel exhaustion. A factor related to the accident was the rough terrain on which the forced landing was made.Oct 12, 1996 · N90WH · Substantial damageNTSB ATL97LA002Accident · Serious injuriesLimited investigationFinal reportBell UH-IB · Bennettsville, SCthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of usable fuel. A factor relating to the accident was: an inoperative left boost pump, which increased the amount of unusable fuel…Oct 12, 1996 · N846MC · DestroyedNTSB SEA97LA011Accident · 2 fatalLimited investigationFinal reportAero Vodochody Aero. Works L-29 · Tillamook, ORfailure of the pilot to maintain control of the aircraft, while maneuvering behind an F4F aircraft. The lack of altitude for a recovery was a related factor.Oct 11, 1996 · N7150A · DestroyedNTSB MIA97WA009Accident · 3 fatalForeign investigationBeech 65-A90 · Itaguazurenda, BoliviaOct 11, 1996 · N3333D · Substantial damageNTSB LAX97LA001Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Truckee, CAa total loss of engine power for undetermined nonmechanical reasons.Oct 11, 1996 · N9403X · Substantial damageNTSB FTW97LA015Accident · No injuriesLimited investigationFinal reportBeech BE-55B · Bellville, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. Factors were the dark night conditions and the pilot's failure to lower the flaps.Oct 11, 1996 · N179DP · Substantial damageNTSB SEA97LA010Accident · 1 fatalLimited investigationFinal reportPiper PA-36-300 · Prosser, WAfailure of the pilot to maintain clearance from the terrain, while en route to an apple orchard that he intended to spray. A factor relating to the accident was: the turbulent wind condition over the hills.Oct 10, 1996 · N2331Y · Substantial damageNTSB SEA97LA009Accident · 1 fatalLimited investigationFinal reportGlobe GC-1B · Caldwell, IDthe pilot's misjudgment of distance and altitude to the runway, while on final approach to land. The sunglare was a related factor.Oct 10, 1996 · N3228K · Substantial damageNTSB SEA97GA008Accident · 2 fatalFinal reportPiper PA-18-150 · Holden, UTThe first pilot's failure to maintain adequate airspeed while maneuvering the airplane in close proximity to the ground. This subsequently led to an aerodynamic stall and uncontrolled descent into the ground. Factors contributing to the accident include the…Oct 10, 1996 · N91017 · DestroyedNTSB IAD97LA005Accident · No injuriesLimited investigationFinal reportCessna T210M · Mentor, KYthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. Factors relating to the accident were: the inaccurate fuel quantity gage, and the light condition at dusk.Oct 10, 1996 · N6163N · Substantial damageNTSB FTW97FA014Accident · 1 fatalField investigationFinal reportMbb BO-105 CBS-4 · Cameron, LAthe pilot's failure to maintain clearance with terrain for undetermined reasons. Contributing factors were the dark night and pilot fatigue.Oct 10, 1996 · N299EH · DestroyedNTSB ATL97LA001Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Morris, ALThe pilot selected the wrong runway relative to the wind, and misjudged the proper touchdowm point on the runway. The tailwind was a factor.Oct 10, 1996 · N10ZP · Substantial damageNTSB MIA97RA005Accident · Serious injuriesForeign investigationBell 407 · Andros Island, BahamasOct 9, 1996 · N1117PNTSB LAX97LA012Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Truckee, CAthe pilot's inadequate preflight planning/preparation and fuel consumption calculations resulting in fuel exhaustion. The pilot's failure to switch the fuel tanks to the auxiliary position and feather both propellers were factors.Oct 9, 1996 · N7833Q · Substantial damageNTSB FTW97LA013Accident · No injuriesLimited investigationFinal reportDickson RV-3A · Rosharon, TXThe pilot's failure to follow procedures and directives in that he did not use carburetor heat and he did not periodically clear the engine during an extended glide. Factors were the carburetor icing weather conditions and the transmission wire.Oct 9, 1996 · N3920P · DestroyedNTSB CHI97LA006Accident · Minor injuriesLimited investigationFinal reportCallair B1A · Nebraska City, NEa supercharger bearing failure. A factor was the excessive sink rate during the forced landing.Oct 9, 1996 · N6203X · Substantial damageNTSB SEA97LA007Accident · No injuriesLimited investigationFinal reportCessna 182Q · Manzanita, ORfailure of pilot to adequately compensate for wind conditions on final approach and attain a proper touchdown point for landing. A factor relating to the accident was: the unfavorable wind condition.Oct 8, 1996 · N759RE · Substantial damageNTSB SEA97FA006Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Cle Elum, WAThe pilot's physical impairment of judgment and performance, his decision to fly while impaired, and his subsequent failure to maintain control of the aircraft which led to the aircraft's design stress limits being exceeded and inflight separation of the…Oct 8, 1996 · N666HL · Substantial damageNTSB SEA97FA005Accident · 1 fatalField investigationFinal reportCessna T210M · Everett, WAThe pilot's impairment of judgment and performance due to the recent excessive use of potent prescription drugs, the pilot's descent below the published decision height, and the pilot's failure to execute a missed approach. Factors contributing to the…Oct 8, 1996 · N761TQ · DestroyedNTSB NYC97FA004Accident · 2 fatalField investigationFinal reportBeech F33A · Doylesburg, PAcontinued VFR flight by the pilot into instrument meteorological conditions, and his failure to maintain altitude and/or clearance from high terrain. Factors relating to the accident were: darkness, low ceiling, fog, and high (mountainous) terrain along the…Oct 8, 1996 · N2154L · DestroyedNTSB MIA97LA004Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Ringgold, GAThe pilot's failure to see and avoid obstructions during takeoff.Oct 8, 1996 · N2286Y · Substantial damageNTSB LAX97LA011Accident · Serious injuriesLimited investigationFinal reportRichards Lancair IVP · Camarillo, CAThe loss of engine power for undetermined reasons.Oct 8, 1996 · N477RM · DestroyedNTSB LAX97LA010Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E · Santa Rita, CAThe pilot's inadequate preflight inspection of the helicopter.Oct 8, 1996 · N51582 · Substantial damageNTSB LAX97LA009Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Jackpot, NVthe pilot's inadvertent disorientation in dark night time conditions and failure to maintain a proper climbing attitude.Oct 8, 1996 · N28172 · DestroyedNTSB FTW97LA023Accident · Serious injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMA sudden increase in wind velocity.Oct 8, 1996 · N3581D · No damageNTSB FTW97LA012Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Idalou, TXthe pilot's improper planning/decision, which resulted in an overrun during takeoff and an encounter with cotton (crop) and rough/uneven terrain. Factors relating to the accident were: the excessive loading of the airplane for the existing conditions, the…Oct 8, 1996 · N4533H · Substantial damageNTSB CHI97LA005Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Neenah, WIthe local terrain conditions around the airport. A factor was the inadequate runway safety area.Oct 8, 1996 · N2398Z · DestroyedNTSB MIA97LA003Accident · Minor injuriesLimited investigationFinal reportSocata TB-20 · Mobile, ALthe pilot's improper management of fuel, which resulted in fuel exhaustion and loss of engine power during a go-around, and subsequent collision with trees and terrain during a forced landing.Oct 7, 1996 · N59TB · Substantial damageNTSB LAX97LA007Accident · No injuriesLimited investigationFinal reportCessna 172C · Mesa, AZthe pilot's improper use (positioning) of the fuel selector, which resulted in fuel starvation and loss of engine power.Oct 7, 1996 · N1332Y · Substantial damageNTSB LAX97LA006Accident · No injuriesLimited investigationFinal reportBell 47G-5A · King City, CAthe pilot's failure to maintain adequate rotor rpm during the takeoff initial climb.Oct 7, 1996 · N8135J · Substantial damageNTSB FTW97LA010Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gulf Of Mexicofuel exhaustion due to the pilot's inadequate in-flight fuel consumption calculations.Oct 7, 1996 · N5525L · Substantial damageNTSB FTW97LA006Accident · Serious injuriesLimited investigationFinal reportCessna 175B · Mount Pleasant, TXThe total loss of engine power due to the #3 connecting rod separation resulting in engine seizure. Factors were the dark night and the lack of suitable terrain for the forced landing.Oct 7, 1996 · N8171T · Substantial damage