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 CHI99LA084Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Lincoln, NEthe pilot's failure to perform an aircraft preflight which resulted in him selecting a fuel tank which had insufficient fuel for the flight and the subsequent fuel starvation.Feb 9, 1999 · N5540D · Substantial damageNTSB MIA99LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, NCThe student pilots failure to maintain directional control during an attempted touch and go landing. This resulted in the airplane veering off the left side of the runway, and subsequent on-ground collision with a ditch and nosed over inverted..Feb 8, 1999 · N6294M · Substantial damageNTSB FTW99LA079Accident · No injuriesLimited investigationFinal reportMiller/Bell TR-1 · Hiwasse, ARThe pilot's inadequate compensation for prevailing wind conditions. Factors were the crosswind, the lack of suitable terrain, and the separation of the adell clamp for the oil cooler inlet line.Feb 8, 1999 · N9194X · Substantial damageNTSB DCA99WA039Incident · No injuriesForeign investigationBoeing 747-200 · Amsterdam, NetherlandsFeb 8, 1999 · 4XAXK · Minor damageNTSB CHI99LA085Accident · No injuriesLimited investigationFinal reportBeech 1900D · Milwaukee, WIthe in-flight collision with a bird.Feb 8, 1999 · N148SK · Substantial damageNTSB ATL99LA049Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-80 · Raleigh, NCThe flight encountered clear air turbulence while descending through 17,000 feet mean sea level (MSL).Feb 8, 1999 · N433AA · No damageNTSB MIA99WA086Accident · 6 fatalForeign investigationCessna 210N · Trinidad, BoliviaFeb 7, 1999 · CP161 · DestroyedNTSB IAD99LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Medina, OHWas the pilot's failure to remove snow from the horizontal stabilator prior to take-off and his improper decision to depart downwind. Factors in the accident were the heavy snow squall and tailwind.Feb 7, 1999 · N31975 · DestroyedNTSB FTW99LA073Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Denton, TXThe hard landing as a result of the pilot's failure to maintain the proper descent rate during the landing flare.Feb 7, 1999 · N112WS · Substantial damageNTSB DEN99LA037Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Climax, COThe flight's encounter with turbulence.Feb 7, 1999 · N586UA · No damageNTSB DCA99WA038Accident · No injuriesForeign investigationBoeing 707 · Slovak Republic, SlovakiaFeb 7, 1999 · 9GROX · Substantial damageNTSB NYC99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Burnt Chimney, VAThe pilot's decision to land on a short runway with a strong tailwind, and his failure to obtain a proper touchdown point.Feb 6, 1999 · N19186 · DestroyedNTSB MIA99FA075Accident · 1 fatalField investigationFinal reportCessna 210J · Naples, FLIn-flight collision with water while on base turn to final at night for undetermined reasons.Feb 6, 1999 · N6174F · DestroyedNTSB LAX99FA091Accident · 1 fatalField investigationFinal reportCessna 150J · Mariposa, CAThe pilot's premature descent into terrain during a dark nighttime approach. Also causal was his physiological impairment due to alcohol. A contributing factor was his psychological condition.Feb 6, 1999 · N50878 · DestroyedNTSB FTW99LA076Accident · Minor injuriesLimited investigationFinal reportBell 206-B3 · Sabine Pass, TXThe pilot's inadvertent flight into instrument meteorological conditions and subsequent spatial disorientation. Factors were the dark night conditions, the fog, and the pilot's failure to obtain a weather briefing prior to the flight.Feb 6, 1999 · N907CA · Substantial damageNTSB FTW99FA075Accident · 5 fatalField investigationFinal reportCessna 182B · Ozona, TXthe pilot's failure to obtain/maintain clearance from terrain during initial climb after take off. A contributing factor was the dark night.Feb 6, 1999 · N54FC · DestroyedNTSB CHI99LA088Accident · No injuriesLimited investigationFinal reportCessna 150G · Hillman, MIthe pilot's misjudging crosswinds during landing roll. Factors were crosswinds and a snow and ice covered runway, and the snowbank.Feb 6, 1999 · N3332J · Substantial damageNTSB CHI99LA087Accident · No injuriesLimited investigationFinal reportSocata TB 9 Tampico · Cahokia, ILthe pilot's improper decision to initiate the takeoff with insufficient runway remaining. A factor associated with the accident was pilot's failure to obtain clarification from the controller regarding the clearance.Feb 6, 1999 · N544PC · Substantial damageNTSB CHI99LA086Accident · No injuriesLimited investigationFinal reportBeech 58 · Gaylord, MIthe pilot not obtaining proper runway centerline alignment during landing. Associated factors were the pilot's obscured view through the iced windshield, the runway lights not activating simultaneously with the approach lights, incomplete visual detection of…Feb 6, 1999 · N58AK · Substantial damageNTSB CHI99FA089Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Belle Fourche, SDinadequate preflight planning/preparation, refueling not performed, and aircraft control not maintained by the pilot. The inadvertent stall by the pilot was an additional cause. Fuel exhaustion was a contributing factor.Feb 6, 1999 · N8075D · DestroyedNTSB ATL99LA047Accident · No injuriesLimited investigationFinal reportBalloon Works AX-8 · Beech Island, SCThe pilot's failure to follow the balloon checklist that resulted in a ground fire that destroyed the balloon envelope.Feb 6, 1999 · N32877 · DestroyedNTSB NYC99IA056Incident · No injuriesIncident investigationFinal reportPiper PA42-1000 · Lexington, KYImproper assembly of the engine gearcase by the manufacturer, which resulted in an uncontained failure of the 1st bull gear.Feb 5, 1999 · N37KW · Minor damageNTSB LAX99LA089Accident · Minor injuriesLimited investigationFinal reportStern Rotorway Exec 162F · Tucson, AZThe sudden development of a wind gust which resulted in the pilot losing control, and the helicopter's dynamic rollover when a skid contacted the ground.Feb 5, 1999 · N88XS · Substantial damageNTSB ANC99IA027Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Fairbanks, AKThe restricted/delayed movement of the elevator flight control due to extremely cold weather conditions.Feb 5, 1999 · N934AS · No damageNTSB LAX99FA102Accident · 1 fatalField investigationFinal reportNorth American T-28B · Joshua Tree, CAThe pilot's decision to attempt flight into an area of known adverse weather and the subsequent inadvertent VFR flight into IFR conditions resulting in an in-flight collision with mountainous terrain.Feb 4, 1999 · N628B · DestroyedNTSB LAX99FA090Accident · 1 fatalField investigationFinal reportNorth American T-28C · Joshua Tree, CAThe pilot's decision to attempt flight into an area of known adverse weather and the subsequent inadvertent VFR flight into IFR conditions resulting in an in-flight collision with mountainous terrain.Feb 4, 1999 · N128BJ · DestroyedNTSB MIA99LA074Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Crystal River, FLThe failure of the pilot to maintain directional control during takeoff and his failure to abort the takeoff after directional control was lost.Feb 3, 1999 · N68573 · Substantial damageNTSB MIA99LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Orlando, FLA loss of engine power due to an engine assembly overload for undetermined reasons. A related factor was the pilot exceeded the airplane's maximum allowable weight.Feb 3, 1999 · N5528J · DestroyedNTSB MIA99GA072Accident · Serious injuriesFinal reportBell OH-58C · Lakeland, FLThe pilot-in command's failure to maintain clearance from the tug. A related factor was the induced pressure.Feb 3, 1999 · N151ES · Substantial damageNTSB DEN99LA036Accident · No injuriesLimited investigationFinal reportCessna 208B · Cody, WYThe pilot's inability to maintain aircraft control due to unfavorable winds conditions.Feb 3, 1999 · N980FE · Substantial damageNTSB CHI99LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Paxton, ILthe inadequate preflight planning by the pilot in command and the exhaustion of usable fuel. Factors were the tailwind landing condition and the rough terrain at the landing site.Feb 3, 1999 · N704BF · Substantial damageNTSB ANC99TA026Accident · No injuriesFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's use of excessive taxispeed. Factors associated with the accident were an icy taxi area, and the inadvertent activation of the throttle.Feb 3, 1999 · N7875D · Substantial damageNTSB FTW99LA078Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D1 · Daingerfield, TXAn undetermined airframe malfunction which rendered the aircraft uncontrollable.Feb 2, 1999 · N44174 · Substantial damageNTSB CHI99LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Odessa, MOthe total loss of engine power for reasons undetermined. Factors were total loss of engine power, the instructor pilot's encounter with unsuitable terrain, and the rough terrain.Feb 2, 1999 · N67568 · Substantial damageNTSB LAX99LA087Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-232 · Las Vegas, NVThe injured passenger's failure to follow the instructions of the cabin attendants.Feb 1, 1999 · N640AW · No damageNTSB LAX99IA085Incident · No injuriesIncident investigationFinal reportAerospatiale AS350B · Grand Canyon Pk, AZThe in-flight separation of a side window for undetermined reasons.Feb 1, 1999 · N32GA · Minor damageNTSB FTW99LA077Accident · No injuriesLimited investigationFinal reportBell 206L-3 · West Delta 105bThe pilot's failure to maintain clearance with the oil platform's windsock on final approach to landing.Feb 1, 1999 · N6603X · Substantial damageNTSB LAX99TA088Accident · No injuriesFinal reportMcDonnell Douglas 369D · Las Vegas, NVThe pilot's failure to properly judge the landing flare maneuver during a practice autorotative landing resulting in a hard landing.Jan 31, 1999 · N58431 · Substantial damageNTSB DEN99LA035Accident · No injuriesLimited investigationFinal reportMooney M20E · Albuquerque, NMThe pilot's failure to maintain aircraft control during takeoff.Jan 31, 1999 · N5658Q · Substantial damageNTSB CHI99LA080Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Alliance, NEthe unsuitable terrain for landing selected by the pilot-in-command. Factors were the tailwind landing condition and excessive braking by the pilot-in-command.Jan 31, 1999 · N9668S · Substantial damageNTSB CHI99FA079Accident · 1 fatalField investigationFinal reportCessna U-206G · Salem, MOthe spatial disorientation and loss of control by the pilot after a reported vacuum failure. Factors were instrument flight conditions and icing conditions.Jan 31, 1999 · N7586N · DestroyedNTSB MIA99LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-210T · Washington, NCLoss of engine power for undetermined reasons on initial takeoff climb resulting in a forced landing and in-flight collision with trees and terrain.Jan 30, 1999 · N28235 · DestroyedNTSB MIA99LA070Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Pompano Beach, FLThe CFI's decision not to follow procedures and directives (initiate a go-around/power recovery) during a simulated 180 autorotation resulting in a hard landing and in flight collision with terrain.Jan 30, 1999 · N4046H · DestroyedNTSB LAX99LA086Accident · No injuriesLimited investigationFinal reportCessna 150L · Madera, CAThe pilot's failure to maintain an adequate visual lookout and to see the stationary airplane on the taxiway ahead.Jan 30, 1999 · N6979G · 2 aircraft · Substantial damageNTSB LAX99LA084Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Jean, NVFuel starvation due to the pilot's failure to ensure that a tank containing an adequate fuel supply was selected for takeoff. A factor in the accident was the contamination in the engine driven fuel pump, which likely was not capable of providing full system…Jan 30, 1999 · N474W · Substantial damageNTSB LAX99GA083Accident · Serious injuriesFinal reportMcDonnell Douglas 369E · Lake Elsinore, CAThe pilot's failure to maintain main rotor rpm and her misjudged flare. Also causal was the failure of the company maintenance personnel to follow the procedures/directives in the engine manufacturer's operation and maintenance manual and their improper…Jan 30, 1999 · N992SD · DestroyedNTSB ATL99LA137Accident · No injuriesLimited investigationFinal reportGettis H. Hudson Corban Baby ACE · Pleasant View, TNThe failure of owner of sod runway to properly maintain the runway, the pilots failure to properly preflight the takeoff area before departure.Jan 30, 1999 · N24562 · Substantial damageNTSB ATL99FA046Accident · 2 fatalField investigationFinal reportAero Commander 560A · Belleview, FLThe pilot's inadequate preflight planning of the fuel required for the flight that resulted in fuel exhaustion and the subsequent total loss of engine power to both engines.Jan 30, 1999 · N919VC · DestroyedNTSB FTW99FA074Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Pearcy, ARThe pilot's failure to maintain the minimum descent altitude during the instrument approach. Contributing factors were the pilot's failure to follow the instrument approach procedure, trees, mountainous terrain, low ceilings and foggy weather conditions.Jan 29, 1999 · N260LH · DestroyedNTSB CHI99LA078Accident · No injuriesLimited investigationFinal reportGates Learjet 35 · Chicago, ILthe second pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall mush.Jan 29, 1999 · N130F · Substantial damage