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 MIA89WA063Incident · No injuriesForeign investigationG.D.I.E. Airbus A-310 · St. Martin, NTNTSB MIA89LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bunnell, FLMisjudgement of altitude and distance to the runway by the student pilot, and inadequate supervision by the instructor pilot (CFI). The exposed (raised) runway lip was a factor.NTSB MIA89LA062Accident · No injuriesLimited investigationFinal reportCessna 210L · Greenwood, MSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve.NTSB LAX89LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Alturas, CAThe failure of the instructor pilot to maintain directional control of the airplane on the snow-covered runway, resulting in a nose-over when the airplane continued off the runway into deeper snow.NTSB FTW89FA037Accident · 2 fatalField investigationFinal reportBeech B33 · New Braunfels, TXThe pilot's decision to continue VFR flight into IMC. Contributing factors were the adverse weather conditions and the dark night.NTSB LAX89LA079Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Calexico, CAA binding brake system torque plate. Factors related to the accident were: inadequate maintenance by other maintenance personnel, and operation of the airplane with a known efficiency by the pilot.NTSB LAX89FA091Accident · 1 fatalField investigationFinal reportCessna 172M · Oxnard, CAContinued VFR flight by the pilot into instrument meteorlogical conditions which resulted in an in-flight collsion with terrain. Related factors were: failure of the pilot to use a preflight briefing service, his decision to initiate flight into known adverse…NTSB DEN89LA058Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Craig, COUnsuitable terrain (runway condition) selected by the pilot. Factors related to the accident were: the adverse weather conditions, inadequate removal of snow from the runway by airport personnel, uneven snow covered runway, lack of visual perception by the…NTSB CHI89LA043Accident · No injuriesLimited investigationFinal reportCessna T303 · Romeo, MIThe failure of the left main landing gear assembly due to stress corrosion.NTSB MKC89DCG02Accident · 1 fatalFinal reportWells Varieze · Macon, MOContinued flight by the pilot into known adverse weather and his failure to maintain sufficient altitude/clearance above obstacles. Contributing factors were: low ceiling, fog, rain, pilot delaying flight to an alternate destination, his lack of recent flight…NTSB MIA89LA061Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Margate, FLFailure of the engine driven oil pump due to foreign object(s), which resulted in oil starvation and subsequent engine failure. Factors related to the accident were: dark night and trees in the emergency landing area.NTSB LAX89FA078Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · San Bernardino, CAThe pilot's decision to continue VFR flight after encountering instrument meteorological conditions while attempting to transit through a mountain pass. Contributing factors was: the pilot's self-induced pressure knowing that a co-worker was probably waiting…NTSB DEN89LA057Accident · No injuriesLimited investigationFinal reportBumgartner/Hirt Steen Skybolt · Quemado, NMFailure of the pilot to select a suitable landing strip/area. Factors related to the accident were: high terrain and low ceiling along the route of flight, haze, and the soft condition of the selected landing strip.NTSB DEN89FA056Accident · Serious injuriesField investigationFinal reportCessna 208B · Aspen, COPilot's improper IFR procedure. Contributing factors included moderate turbulence, low ceilings, obscuration and snow.NTSB CHI89DEX03Accident · No injuriesFinal reportGrumman American AA-1C · Richmond, INThe pilot's attempt to continue the takeoff with a partial loss of power. Contributing to the accident were the carburetor icing conditions.NTSB ATL89LA069Accident · No injuriesLimited investigationFinal reportBoeing E75 · Salisbury, NCImproper use of carburetor heat by the pilot, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions and obstruction(s)/utility pole near the departure end of the runway.NTSB NYC89FA062Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Limington, MEFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the adverse wind conditions, lack of pilot experience in the type of aircraft, and the lack of shoulder harness/upper body…NTSB MIA89TL#02Accident · 1 fatalClass 3Final reportBell 206L-3 · Orlando, FLNTSB LAX89LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Long Beach, CAThe excessive speed which the pilot was maintaining and his improper operation of the brake system. Contributing to the accident was the inexperience of the student pilot.NTSB DEN89LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Longmont, COFailure of the student pilot to maintain proper runway alignment during the landing roll. Factors related to the accident were: snow on the edges of the runway, the student's lack of total experience, and the snowbank.NTSB ATL89LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Theodore, ALPilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall, and subsequent collision with the ground.NTSB FTW89LA036Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · S.Timbalier 151A collision between the aircraft and the platform during the emergency autorotation which caused the left skid and float to separate and destabilized the autorotation. The collision was probably unadoidable due to the maneuver that was being conducted at the…NTSB ATL89FA066Accident · 1 fatalField investigationFinal reportPiper PA-31 · Springfield, OHFuel exhaustion precipatated by the inadequate fuel consumption calculations performed by the pilot, pressure from the company president to not carry excess fuel and improper in-flight planning/decisions by the pilot by not refueling enroute before fuel was…NTSB ANC89LA031Accident · No injuriesLimited investigationFinal reportCessna 207A · Russian Mission, AKThe partial engine power loss due to undetermined reasons. Contributing to the accident was the pilot's improper inflight planning by flying at a traffic pattern altitude insufficient to insure a safe emergency landing either on or off the airport and his…NTSB DEN89LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Cheyenne, WYImproper planning/decision by the pilot. Factors related to the accident were the high wind and gusts, which he was unable to compensate for.NTSB DEN89LA052Accident · No injuriesLimited investigationFinal reportBeech 19 · Santa Fe, NMThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB CHI89FA040Accident · 3 fatalField investigationFinal reportPiper PA-28-200 · Carmel, INThe pilot's poor understanding of the weather forecast, his failure to utilize the pitot heat in icing conditions and the exceeding of the stress limits of the aircraft.NTSB ATL89FA065Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B · Mansfield, OHFailure of the pilot to maintain control of the aircraft, due to spatial disorientation, at about the time he was changing radio frequencies during an IFR approach.NTSB ANC89LA030Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Cantwell, AKThe pilot's selection of unsuitable terrain for landing. Contributing factors were the pilot's lack of total experience, and the snow covered runway.NTSB NYC89LA060Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Speculator, NYInaccurate inflight planning and decisions by the pilot who inadvertently flew his aircraft from VFR into instrument meteorological conditions while making a descent at night.NTSB FTW89LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Austin, TXThe pilot did not have an adequate fuel supply to complete the flight. The plts flt planning was inadequate and the ignored opportunities to obtain fuel enroute led to fuel exhaustion, prior to reaching destination.NTSB CHI89FA039Accident · 2 fatalField investigationFinal reportCessna 210D · Alvin, ILContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude. Factors related to the accident were: darkness, adverse weather conditions, the pilot's lack of instrument…NTSB CHI89FA038Accident · 2 fatalField investigationFinal reportCessna T210N · Springfield, ILThe pilot's improper IFR procedure during an ILS approach in below minimum conditions, and the pilot's failure to proceed to an alternate destination. Contributing factors were the adverse weather conditions.NTSB NYC89LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-60 · Somerville, NJImproper inflight decisions while approaching the airport on final approach with defective magnetos. The right fuel selector was placed in the closed position, the pilot attempted a go around, raised the landing gear and flaps, failed to maintain VMC, and…NTSB MIA89LA060Accident · Serious injuriesLimited investigationFinal reportAir Command 532E · Clearwater, FLThe student pilot said he did not remember anything about the accident. Witnesses stated that at about 50 ft AGL on final approach the gyrocopter rapidly descended. It remained level and hit hard, rolling over on impact. Witnesses stated that the engine was…NTSB LAX89FA076Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Wrightwood, CAAccording to the passenger, during a cross country flight the airplane encountered instrument meteorological conditions. The pilot flew the airplane toward a mountain range and entered a valley with rising terrain. Still in IMC, just prior to the accident,…NTSB DEN89LA054Accident · No injuriesLimited investigationFinal reportCessna 172M · Erie, COThe pilot said that he made a normal preflight and engine runup prior to takeoff on runway 33 at the tri-county airport, Erie, Colorado. A normal takeoff was made but he said that as the aircraft reached 200 feet, the engine lost about 400 RPM. When he…NTSB DEN89LA051Accident · No injuriesLimited investigationFinal reportBeech B24R · Ogden, UTThe non-instrument rated plt rcvd a wx briefing & filed an IFR flt pln. He tkof on rwy 34 at 1517 MST with low ceiling &restricted vis due to fog & lgt snow. The twr ctlr saw the acft lift-off at the rwy's end, then lost sight of it. Soon thereafter, the plt…NTSB CHI89LA041Accident · No injuriesLimited investigationFinal reportCessna 152II · Grand Rapids, MIPilot's total lack of experience in this type of operation.NTSB NYC89IA063Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10 · Atlantic Ocean (Atlantic Ocean)American flt 1180 (McDonnell-douglas DC-10) was northbound ovr the Atlantic Ocean at flt lvl 350 as a british royal air force vickers VC10 was cruising east at the same alt (non-standard alt for the VC10'S drctn of flt). They were in a non-radar airspace…NTSB CHI89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Plainfield, ILNTSB ATL89LA064Accident · No injuriesLimited investigationFinal reportMooney M20F · Perdido, ALWhile descending to 6000 feet the pilot experienced a complete loss of engine oil supply. The windscreen was covered with oil and the pilot had to use the side window to gain forward visibility. After completing the emergency landing check the engine seized.…NTSB ANC89FA028Accident · No injuriesField investigationFinal reportCessna 172 · Anchorage, AKThe 103 hour private pilot was in the process of demonstrating his Cessna 172 conventional gear airplane (tail-dragger) to a prospective purchaser, when he lost directional control during landing and nosed-over. The pilot reported that he had just touched…NTSB NYC89LA061Accident · No injuriesLimited investigationFinal reportNavion NA-1 · Allentown, PAThe pilot stated that he experienced a loss of power shortly after takeoff and landed back on the runway. The landing was hard and the right wing was damaged. The FAA investigator checked the engine and fuel system for possible contaminants and water. No…NTSB MKC89IA048Incident · No injuriesIncident investigationFinal reportGulfstream Commander 690A · St. Paul, MNThe PIC had prefltd his commander turboprop and prepared for takeoff fm the St. Paul arpt. During the takeoff roll just as the acft was rotated to takeoff attitude, the rt eng failed. The PIC eased the acft back to the rwy, reduced pwr and came to a stop on…NTSB LAX89LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Avalon, CAThe pilot lost control of the airplane during landing roll at catalina airport. The airplane departed the end of runway 22, went down a steep slope and collided with the ground. The pilot reported that his first approach had been too high, so he made a…NTSB LAX89LA072Accident · No injuriesLimited investigationFinal reportBeech A24R · Grass Valley, CAAt the end of a cross country flight, during the landing roll, the airplane began to slide to the left. The pilot was unable to regain control due to the patchy snow and ice on the runway. The airplane exited the runway and collided with a snow bank. There…NTSB DEN89LA050Accident · No injuriesLimited investigationFinal reportCessna 152 II · Gilcrest, COThe plt, with his wife as a pax, departed greeley, CO, on a cross-country flt to clayton, NM. After landing, the pilot had his aircraft refueled. It took 23.5 gallons of fuel to fill the fuel tanks. The plt then took off, flew 46 miles southeast, then turned…NTSB ATL89IA063Incident · No injuriesIncident investigationFinal reportLake LA-4-200 · Silver Grove, KYDuring a takeoff run from the Ohio river, the right sponson collided with a submerged log. The a/c sustained minor damage.NTSB ANC89LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Girdwood, AKThe private pilot escaped injury when his airplane collided with snow removal vehicles while landing at the Girdwood airport, Girdwood, AK. The pilot reported that he flew over the airstrip, in his ski-equipped airplane, saw the equipment on the runway, and…