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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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..NTSB 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.NTSB DCA99WA039Incident · No injuriesForeign investigationBoeing 747-200 · Amsterdam, NetherlandsNTSB CHI99LA085Accident · No injuriesLimited investigationFinal reportBeech 1900D · Milwaukee, WIthe in-flight collision with a bird.NTSB 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).NTSB MIA99WA086Accident · 6 fatalForeign investigationCessna 210N · Trinidad, BoliviaNTSB 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.NTSB 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.NTSB DEN99LA037Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Climax, COThe flight's encounter with turbulence.NTSB DCA99WA038Accident · No injuriesForeign investigationBoeing 707 · Slovak Republic, SlovakiaNTSB 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.NTSB MIA99FA075Accident · 1 fatalField investigationFinal reportCessna 210J · Naples, FLIn-flight collision with water while on base turn to final at night for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ANC99IA027Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Fairbanks, AKThe restricted/delayed movement of the elevator flight control due to extremely cold weather conditions.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB DEN99LA036Accident · No injuriesLimited investigationFinal reportCessna 208B · Cody, WYThe pilot's inability to maintain aircraft control due to unfavorable winds conditions.NTSB 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.NTSB 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.NTSB FTW99LA078Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D1 · Daingerfield, TXAn undetermined airframe malfunction which rendered the aircraft uncontrollable.NTSB 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.NTSB LAX99LA087Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-232 · Las Vegas, NVThe injured passenger's failure to follow the instructions of the cabin attendants.NTSB LAX99IA085Incident · No injuriesIncident investigationFinal reportAerospatiale AS350B · Grand Canyon Pk, AZThe in-flight separation of a side window for undetermined reasons.NTSB 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.NTSB 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.NTSB DEN99LA035Accident · No injuriesLimited investigationFinal reportMooney M20E · Albuquerque, NMThe pilot's failure to maintain aircraft control during takeoff.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB CHI99LA078Accident · No injuriesLimited investigationFinal reportGates Learjet 35 · Chicago, ILthe second pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall mush.