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 LAX96LA099Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Oroville, CAthe failure of the pilot to use carburetor heat, which resulted in loss of engine power due to carburetor ice. The carburetor icing (weather) condition was a related factor.Jan 28, 1996 · N992PK · Substantial damageNTSB FTW96LA109Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Grand Prairie, TXa loss of power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jan 28, 1996 · N6706C · Substantial damageNTSB FTW96LA107Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Bernal, NMthe pilot's improper planning/decision, including his failure to maintain sufficient altitude/clearance from mountainous terrain to compensate for altitude deviations that resulted from mountain wave/wind conditions. Factors relating to the accident were: the…Jan 28, 1996 · N69808 · Substantial damageNTSB FTW96FA108Accident · Serious injuriesField investigationFinal reportCessna 152 · Conway, ARloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in an inadvertent stall at low altitude. The gusty wind condition was a related factor.Jan 28, 1996 · N757UK · DestroyedNTSB BFO96LA041Accident · No injuriesLimited investigationFinal reportCessna 172D · Rineyville, KYthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jan 28, 1996 · N2315U · Substantial damageNTSB ATL96LA041Accident · No injuriesLimited investigationFinal reportBeech 23 · Mc Coll, SCthe pilot's failure to maintain aircraft control.Jan 28, 1996 · N511MC · Substantial damageNTSB ATL96LA040Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Knoxville, TNFailure of the pilot to maintain sufficient airspeed during a go-around, which resulted in a stall.Jan 28, 1996 · N50215 · Substantial damageNTSB MIA96WA069Accident · No injuriesForeign investigationPiper PA-23-250 · North Caicos, Turks & Caicos IslandsJan 27, 1996 · N5936Y · DestroyedNTSB MIA96LA073Accident · Minor injuriesLimited investigationFinal reportGilpatrick Baby Lakes · Deland, FLThe pilot's misjudgment of distance and altitude, while on final approach to land, and his failure to attain the proper touchdown point for landing. The unfavorable wind condition (crosswind) was a related factor.Jan 27, 1996 · N26BG · Substantial damageNTSB LAX96LA101Accident · No injuriesLimited investigationFinal reportBoeing A75 · Barstow, CAa loss of engine power for an undetermined reason(s).Jan 27, 1996 · N1359N · Substantial damageNTSB CHI96LA084Accident · No injuriesLimited investigationFinal reportConnell Kitfox · Omaha, NEthe pilot's inadequate preflight of the aircraft and the frozen left landing gear wheel.Jan 27, 1996 · N99SV · Substantial damageNTSB BFO96LA040Accident · Serious injuriesLimited investigationFinal reportAerostar 601 · Mount Storm, WVloss of power in the right engine for undetermined reason(s), and the accumulation of structural ice on the airplane, which resulted in an increased rate of descent and a subsequent forced landing before the pilot could reach an alternate airport. Factors…Jan 27, 1996 · N162GA · DestroyedNTSB ANC96LA025Accident · No injuriesLimited investigationFinal reportCessna 206 · Kotzebue, AKThe pilot's poor judgment in conducting the flight in the existing high gusting wind conditions. A factor associated with the accident was the operator allowing/dispatching the accident flight in the prevailing weather conditions, and the icy ramp/taxi area.Jan 27, 1996 · N5293X · Substantial damageNTSB CHI96LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Sandstone, MNthe pilot's selection of an ice-covered runway for takeoff. A factor was the icy runway.Jan 26, 1996 · N653C · Substantial damageNTSB NYC96LA055Accident · No injuriesLimited investigationFinal reportCessna 150M · Readington, NJThe student pilot's unapproved landing at a second destination during his first solo cross-country, and his inadequate compensation for a cross wind, which resulted in the airplane veering off of the runway and the subsequent nose over.Jan 25, 1996 · N9153U · Substantial damageNTSB MIA96LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Quincy, FLThe pilot's inadequate compensation for wind conditions, while beginning a flare to land, which resulted in a loss of aircraft control and collision with the ground.Jan 25, 1996 · N5912D · Substantial damageNTSB CHI96LA081Accident · No injuriesLimited investigationFinal reportBeech 58 · Yipsilanti, MIwas the pilot not maintaining visual separation with the parked airplanes. A factor in this accident was the pilot's over- confidence in his personal ability to taxi onto the parking ramp with the snowfall he was encountering.Jan 25, 1996 · N4108S · Substantial damageNTSB MIA96LA071Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Fort Pierce, FLfailure of the pilot to follow emergency procedure(s) and/or feather the respective propeller after loss of power in the left engine for an undetermined reason. The undetermined loss of power (left engine) was a related factor.Jan 24, 1996 · N5079J · Substantial damageNTSB CHI96LA082Accident · No injuriesLimited investigationFinal reportDassault DA-10 · Romulus, MIfailure of the right landing gear locking mechanism.Jan 24, 1996 · N191MC · Substantial damageNTSB MIA96FA068Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-11 · Miami, FLThe local and ground controllers' failure to adequately coordinate the movement of the two airplanes, the tower cab supervisor's failure to provide adequate supervision to the controllers, the MD-11 flightcrew's misinterpretation of the local controller's…Jan 23, 1996 · PPSPE · 2 aircraft · Substantial damageNTSB BFO96FA039Accident · 2 fatalField investigationFinal reportCessna R172K · Highland Hills, OHthe pilot's continued VFR flight into instrument meteorological conditions at a low altitude with known obstacles in the area.Jan 23, 1996 · N3107V · DestroyedNTSB ATL96LA039Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, SCthe failure of the student pilot to maintain airspeed while raising the flaps during the go-around.Jan 23, 1996 · N65465 · Substantial damageNTSB ATL96LA038Accident · No injuriesLimited investigationFinal reportCessna 172 · Sanford, FLthe pilot-in-command's excessive taxi speed and his failure to maintain adequate clearance from obstacles.Jan 23, 1996 · N53588 · Substantial damageNTSB NYC96LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Norwood, MAFailure of the student pilot to maintain directional control of the airplane after touchdown, which resulted in an inadvertent ground swerve and collision with a snowbank.Jan 22, 1996 · N89813 · Substantial damageNTSB LAX96FA098Accident · 2 fatalField investigationFinal reportCessna T-210N · Gorman, CAThe loss of control of the aircraft in cruise flight for undetermined reasons and subsequent in-flight structural failure of the aircraft.Jan 22, 1996 · N6452N · DestroyedNTSB FTW96LA103Accident · No injuriesLimited investigationFinal reportCessna A185F · Belle Chase, LAThe pilot's inadequate compensation for the wind conditions, which resulted in a loss of directional control and subsequent encounter with a ditch. The crosswind was a related factor.Jan 22, 1996 · N6034N · Substantial damageNTSB CHI96FA083Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Carlyle, ILspatial disorientation of the pilot, and his failure to maintain control of the airplane, which resulted in his exceeding the design stress limits of the airframe. A factor relating to the accident was: turbulence in clouds.Jan 22, 1996 · N800CE · DestroyedNTSB ANC96LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's selection of an unsuitable site for landing. A factor associated with the accident is the snow-covered terrain.Jan 22, 1996 · N7797B · Substantial damageNTSB FTW96LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Norman, OKthe student pilot's improper level-off during landing.Jan 21, 1996 · N76067 · Substantial damageNTSB FTW96LA102Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Spicewood, TXthe pilot's intentional evasive maneuver to avoid colliding with a deer on the runway during landing. A factor was the bush that the airplane collided with during the aborted landing.Jan 21, 1996 · N41381 · Substantial damageNTSB FTW96FA100Accident · 4 fatalField investigationFinal reportBeech 58 · Atkins, ARContinued flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude above mountainous/hilly terrain. Factors relating to the accident were: low ceiling, fog, and high terrain in the area of the…Jan 21, 1996 · N3010W · DestroyedNTSB MIA96WA070Accident · Minor injuriesForeign investigationBell 206 · Exuma, BahamasJan 20, 1996 · N87JH · Substantial damageNTSB LAX96FA097Accident · Minor injuriesField investigationFinal reportPiper PA-28-236 · Seal Beach, CAa total loss of engine power from an improperly installed magneto that separated from the engine housing due to fatigue from vibration.Jan 20, 1996 · N2476Y · Substantial damageNTSB LAX96FA096Accident · 2 fatalField investigationFinal reportBeech 55 · Cedarville, CAthe pilot's poor preflight planning by not obtaining a weather briefing and his inadvertent encounter with a mountain wave condition. The moonless dark night was a factor in this accident.Jan 20, 1996 · N4088A · DestroyedNTSB FTW96LA101Accident · No injuriesLimited investigationFinal reportCessna 180 · Buena Vista, COThe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control. A factor relating to the accident was: the crosswind.Jan 20, 1996 · N6502A · DestroyedNTSB NYC96LA053Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-6 · Allentown, PAthe pilot's failure to comply with IFR procedures in that he attempted an instrument approach with visibility below the required minimums, and his delayed execution of a missed approach. A factor was the reduced visibility due to clouds.Jan 19, 1996 · N888TP · Substantial damageNTSB MIA96LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Smithville, TNThe pilot's improper in-flight planning/decision, which resulted in a heavy load of airframe ice, an inability to maintain altitude, and a subsequent emergency landing. Factors relating to the accident were: the adverse weather (icing) condition, which was…Jan 19, 1996 · N4457X · Substantial damageNTSB MIA96FA067Accident · Serious injuriesField investigationFinal reportMitsubishi MU-2B-60 · West Columbia, SCa total loss of power on one engine for undetermined reasons, and the pilot-in-command's failure to maintain airspeed (VMC) resulting in an in-flight loss of control. Contributing to the accident was the wind gusts encountered while on final approach to land.Jan 19, 1996 · N50KW · DestroyedNTSB FTW96LA105Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falfurrias, TXfuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.Jan 19, 1996 · N598Z · Substantial damageNTSB ATL96FA037Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Fort Pierce, FLimproper re-assembly of the engine induction air filter by maintenance personnel, during an annual inspection, which resulted in a loss of engine power during takeoff; failure of the pilot to abort the takeoff before lift-off; and failure of the pilot to…Jan 19, 1996 · N114AV · Substantial damageNTSB NYC96FA052Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Harwich, MAthe pilot's improper in-flight decision to continue flight under visual flight rules, while flying into instrument meteorological conditions. Also causal was the pilot's failure to maintain control of the airplane after entering IMC, which resulted in the…Jan 18, 1996 · N5934U · DestroyedNTSB MIA96LA095Accident · No injuriesLimited investigationFinal reportRotor Flight Dynamics Dominator · Quincy, FLa partial loss of engine power due to fuel contamination, and the pilot-in-command's improper decision to land with a tailwind.Jan 18, 1996 · UNREG · Substantial damageNTSB FTW96LA098Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Las Vegas, NMfailure of the throttle cable. A factor relating to the accident was: the lack of suitable terrain for a forced landing.Jan 18, 1996 · N761KK · Substantial damageNTSB FTW96FA091Accident · 1 fatalField investigationFinal reportMooney M20K · Laredo, TXThe pilot's loss of aircraft control. A factor was the dark night conditions.Jan 18, 1996 · N231GS · DestroyedNTSB MIA96FA064Accident · Serious injuriesField investigationFinal reportAirbus Industrie A-300B4-605R · Atlantic Ocean (Atlantic Ocean)the turbulence and failure of the passengers to have their seat belts fastened. A factor relating to this accident was: the failure of the aircraft operator to advise the flight crew of forecast active intensifying thunderstorm conditions in the area of the…Jan 17, 1996 · N7076A · Minor damageNTSB CHI96FA113Accident · 1 fatalField investigationFinal reportPiper PA-32 · Milwaukee, WIInadequate maintenance and inspection in that the Airworthiness Directive which applied to the fuel pump had not been complied with. A factor was the pilot was unable to reach land.Jan 17, 1996 · N3326Q · DestroyedNTSB SEA96LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe pilot's improper flare and inadequate recovery from a bounced landing. His improper approach was a related factor.Jan 16, 1996 · N757TJ · Substantial damageNTSB NYC96LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Auburn, METhe pilot's improper planning/decision and failure to attain proper alignment with the landing area. Factors relating to the accident were: darkness, and the inoperative radio transmitter, which precluded the pilot from activating the runway lights.Jan 16, 1996 · N913A · Substantial damageNTSB FTW96LA099Accident · No injuriesLimited investigationFinal reportCessna 182K · Covington, LAthe pilot's delayed touchdown which resulted in a landing with inadequate runway remaining under the wet runway condition. A factor was the wet grass runway.Jan 16, 1996 · N3098Q · Substantial damageNTSB ATL96FA036Accident · 2 fatalField investigationFinal reportPiper PA-46-350P · Peachtree City, GAThe pilot's failure to follow the published instrument approach procedure. The fog was a factor.Jan 16, 1996 · N9210F · Destroyed