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 NYC87DNC12Accident · Serious injuriesFinal reportCessna 150L · Heartwellville, VTThe pilot of the Cessna 150 was on a solo flight to practice several maneuvers including stalls. At about 4000 ft MSL, then aircraft was climbing with power on when it stalled and went into a spin. The pilot managed to get the nose up just prior to impact…NTSB MIA87WA225Incident · No injuriesForeign investigationGrumman G-73-T · Bimini, BahamasNTSB LAX87LA351Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Truckee, CADuring a telephone interview, the pilot stated that he 'landed hard' on runway 19. Winds were reported to be from 270 degrees at 15 knots gusting to 20 knots. There were no mechanical problems reported prior to the accident. The pilot did not report the…NTSB DEN87LA217Accident · No injuriesLimited investigationFinal reportRockwell 200D · Ogden, UTThe pilot stated that he was on a ferry flight to Ogden, UT and experienced smoke in the cockpit shortly after deprt. The pilot executed a straight in visual approach to runway 34 and before he was able to stop the aircraft a fire erupted. The aircraft was…NTSB CHI87LA213Accident · No injuriesLimited investigationFinal reportMooney 20K · Crestwood, ILUpon arrival at howell airport the pilot set up a close approach for landing on runway 36 because of deteriorating weather conditions. The pilot was unable to get current wind conditions at the airport from UNICOM but decided to continue the approach. During…NTSB ATL87LA233Accident · No injuriesLimited investigationFinal reportCessna 150H · Lumberton, NCThe eng lost power and the plt attempted an off arpt landing. The acft nosed over during the landing roll. Records indicated that the acft had been refueled two days prior to the accident. Since that time it had been flown three and one tenth hours prior to…NTSB ATL87LA231Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Knoxville, TNThe plt rprtd that drg takeoff, the acft clbd normally for about 100 to 150 ft, then the eng lost pwr w/o warning. He switched fuel tanks & tried to restart the eng, but was unable. The acft was lndd & sank in a river, short of an open fld. When the acft was…NTSB ATL87FA230Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Offerman, GADuring a local flt the acft was observed flying at a level attitude approx 10 ft above a corn field at high speed. The right wing of the acft struck tree branches approx 60 ft AGL during a pull up. A 6 ft section of the right wing separated. The acft climbed,…NTSB ATL87DEK03Accident · No injuriesFinal reportEmbree Sonerai II · Cambridge, OHWhile in the traffic pattern, the plt retarded the throttle to idle & established a glide speed. When he re-advanced the throttle, there was no response from the eng. The plt said he 'headed straight for the overrun to runway 4, but could not make it that…NTSB ANC87LA122Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Canning River, AKThe pilot stated that during the landing roll the pilot lost directional control of the aircraft causing the plane to nose over on its back.NTSB LAX87DVA11Accident · 1 fatalFinal reportRockwell S-2R · Mendota, CAThe ground flagman reported the pilot had just completed spraying the bean field. The pilot was in the process of doing a touch-up application when he flew under the power lines. The airplane right wing contacted the lowest of the 4 powerlines, rolled…NTSB LAX87DJA08Accident · No injuriesFinal reportEmair MA-1B · Pahala, HIDuring an aerial application operation, while taking off, the aircraft veered off the runway and came to rest nose down. Inspection of the landing gear revealed that the left main landing gear scissor bolt broke.NTSB DEN87FA216Accident · 1 fatalField investigationFinal reportGreat Lakes 2T-1A · Bozeman, MT74-Year-OLD plt was performing aerobatics at small arpt for local tv news station to promote weekend airshow. Plt made right & left pass, each pass consisting of shallow descent, pullup from aprx 150 to 200 ft AGL, & slow roll. Plt began third pass from…NTSB BFO87LA054Accident · No injuriesLimited investigationFinal reportMooney M20C · Baltimore, MDThe plt refueled the acft at princeton, NJ, bfr departing on a flt to linden, NJ, then continued on to laurel, MD. He believed that he had positioned the fuel selector to the rgt fuel tank & said that he had used fuel out of the same tank until he arrived at…NTSB ANC87LA121Accident · No injuriesLimited investigationFinal reportCessna 170 · Mi.70 Glenn Hwy, AKThe pilot stated the weather was deteriorating with visibility less than one mile and rainshowers. The pilot elected to make a precautionary landing on a state highway. During the landing roll the aircraft struck a road sign with the right wing of the…NTSB SEA87FA162Accident · 2 fatalField investigationFinal reportHughes 369D · Ketchikan, AKN58318 (Hughes 369, under contract with us geological survey) was inbnd fm se to lnd at Ketchikan-temsco heliport (6Z4) as N73WS (Cessna 185 amphibian) was depg se fm Ketchikan intl arpt (ktn). Ktn & 6Z4 were located in tongass narrows withmtns NE & sw. Rprtd…NTSB NYC87LA230Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Binghamton, NYWhile taking off from a touch-&-go landing, the student plt lost control of the acft at an alt of about 100 ft. subsequently, the acft spun to the left & collided with the ground, left wing first, then cartwheeled & came to rest in an upright position. No…NTSB NYC87LA229Accident · No injuriesLimited investigationFinal reportLake LA-4 · Lake George, NYWhile taking off from a Lake, the amphibious aircraft struck an object. The plane settled back into the water breaking the windshield on the passenger's side. The cockpit began filling with water and the acft sank in about 45 feet of water.NTSB LAX87LA289Accident · No injuriesLimited investigationFinal reportCessna 170A · Independence, CADuring a cross country flight, the plt stated that en route the engine suddenly lost partial power. The plt made a 180 degree turn to try an emergency landing at a nearby airport, however, the plt realized that he would be short of the rwy. The plt landed the…NTSB LAX87IA304Incident · No injuriesIncident investigationFinal reportBoeing 737 · Santa Monica, CAThe plts of a Boeing 737 reported that a near-collision occurred aprx 2.5 miles east of the Santa Monica VOR while they were descending through an altitude of about 7400 ft MSL. The coplt saw the other acft first & took immediate evasive action. He estimated…NTSB LAX87DUJ09Accident · No injuriesFinal reportPiper PA-25-235 · San Simon, AZDuring a pull up from an aerial application swath run, the aircraft struck a power line. The accident occurred during daylight in visual meteorological conditions.NTSB FTW87LA195Accident · No injuriesLimited investigationFinal reportBell 206L-1 · New Iberia, LACrew performing practice touchdown autorotations during a trng flt. On 4th autorotation, acft touched down with excess grnd speed and skidded for approx 75' on the wet, soft grass. When crew applied power back to flight RPM they heard a grinding sound and…NTSB FTW87FA198Accident · No injuriesField investigationFinal reportBell 206B · Pledger, TXWhile cruising at 900' AGL, the plt noted a hvy shudder flwd by a grinding noise, loud 'bang' & a low rotor RPM signal. He made an autorotation to a road, but drg touchdown, the main rotor blades flexed dwn & severed the tail boom. An exam revealed the main…NTSB FTW87FA197Accident · No injuriesField investigationFinal reportPiper PA-32R · Mexia, TXThe plt noticed smoke in the cockpit & started to make a precautionary lndg at Mexia, TX, which was nearby. However, drg the dscnt to lnd, the smoke dissipated, so he elected to cont to the destn. Drg the climb back to alt, smoke reappeared & was followed by…NTSB FTW87DRD14Accident · No injuriesFinal reportGrumman G-164B · Oak Grove, LAAfter completing the last pass of an agricultural operation the pilot pulled up and started a turn. At this time the engine started shaking and losing power. The pilot attempted a forced landing in a soft field. The wheels bogged four or five inches into the…NTSB NYC87LA231Accident · No injuriesLimited investigationFinal reportCessna 172 · Islip, NYAfter landing on an instructional flight, Cessna 172, N9425D, experienced brake failure due to a broken hydraulic fluid line. N9425D rolled into another Cessna. Both aircraft received sustantial damage.NTSB NYC87LA226Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Ellenville, NYThe pilot lost directional control during takeoff at Ellenville airport and the aircraft ran off the runway colliding with trees and was demolished. No mechanical or structural problems were found during investigation of acft.NTSB LAX87LA302Accident · No injuriesLimited investigationFinal reportBeech C-45H · Auburn, CAThe aircraft collided with a ditch after a loss of control during landing rollout. The pilot indicated that during the landing roll the aircraft veered left. Attempted braking action was ineffective. The aircraft had a history of brake problems. The acft had…NTSB FTW87FA196Accident · Minor injuriesField investigationFinal reportCessna P210N · Pearland, TXDrg arrival, the plt made a nr half circle ovr the arpt & entered a dwnwnd for rwy 14R. Drg the entry, he reduced pwr & noted 2 or 3 sputters fm the eng. Just bfr turning to a base leg, he advanced the throttle for adnl power, but there wasno response fm the…NTSB DEN87LA215Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Salt Lake City, UTThe pilot stated the touchdown seemed normal but the aircraft began to porpoise, the propellers struck the runway and the aircraft came to a stop. A post accident inspection revealed the nose gear steering roller had become dislodged and prevented proper…NTSB BFO87FA053Accident · 1 fatalField investigationFinal reportBoeing 747-200B · Washington, DCA flight attendant fell from the acft during opening of the L5 door. The f/a was helping a company ground person, who was outside on the boarding step. The boarding step was not against the acft but about 1 ft away from it. When the door was opened, the f/a…NTSB ANC87LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe pilot stated that during a right turn on approach the aircraft stalled and crashed into the river.NTSB NYC87FA225Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Atlantic City, NJDuring the takeoff roll witnesses observed the aircraft swerve from left to right with the engine(s) 'missing' or intermittent. The aircraft lifted off and climbed to approximately 50 feet AGL and continued across a waterway in a leftturn with the landing…NTSB FTW87LA194Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Eugene IslandThe acft experienced a main rotor blade strike during takeoff from an offshore platform. The rotor blade struck the underside of a cable raceway on a drilling rig that was situated adjacent to the platform helideck. The raceway was 9 feet laterally and 22…NTSB FTW87LA193Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Midland, TXThe right main landing gear collapsed during the landing roll resulting in the loss of directional control. The acft sustained substantial damage to the right wing assembly and the right main landing gear assembly. The acft was being moved to Midland airpark…NTSB CHI87LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Delft, MNThe acft was loaded close to its gross wt limit & the plt atmtd to takeoff on a 2160 ft strip, using short field takeoff techniques. The acft became airborne for a short time, however, it began to settle. The plt elected to abort the takeoff, but was unable…NTSB ATL87LA229Accident · Minor injuriesLimited investigationFinal reportBell 47G (TOM CAT) · Dothan, ALThe plt rprtd that while he was making a turn-around over trees after the 1st swath run, the helicopter enctrd a sudden wind change. He stated that the wind cond was from a cumulus buildup which put him in a tailwind situation. As he completed his turn with…NTSB NYC87LA224Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · York, PAThe Ercoupe model 415 experienced a loss of power in flight. The pilot made a forced landing in a field. He went under some power lines, however, he could not avoid the telephone lines and went through them. The pilot received serious injuries and the…NTSB NYC87IA227Incident · No injuriesIncident investigationFinal reportBoeing 747 · New York, NYAcft with similar call signs (twa flts 843H & 834; Boeing 747 & Boeing 727) apchd jfk intl arpt for ldg. Flt 843H was 22MIN late & flt 834 was 12 min early, causing same arr time. NY TRACON vctrd flt 834 bhnd flt 843H. While ctlg the acft, jfk final ctlr,…NTSB LAX87FA300Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Springville, CAThe pilot was flying over sharply rising terrain in a canyon in a mountainous area. There was insufficient room in the canyon to manuever the aircraft. The pilot reported that he had maintained an airspeed just above a stall while attempting to fly through…NTSB FTW87LA191Accident · No injuriesLimited investigationFinal reportCessna 150K · Mansfield, TXThe student pilot experienced fuel exhaustion and made a forced landing a few miles short of his planned destination. His preflight trip planning, which was approved by his flight instructor, if followed correctly would have been adequate for successful…NTSB CHI87FA191Accident · No injuriesField investigationFinal reportBeech B90 · Milwaukee, WIOn departure the crew identified an in flight fire. An immediate shutdown of electrical, environmental and pressurization systems was initiated and a return was made to the airport with a successful landing. The fire was discovered to have occurred in the…NTSB BFO87LA051Accident · Minor injuriesLimited investigationFinal reportMaule M-4-210C · Burnt Chimney, VAThe plt attempted to land on a 1400 ft grass airstrip. The plt later stated that during the lndg roll the passg alerted him to the fact that they would not stop on the rwy. This caused the plt to start a go-around followed by a 2nd attempt to stop. The plt…NTSB ATL87DLQ04Accident · No injuriesFinal reportPiper PA-28-140 · Falmouth, KYThe plt, with a pax, had been making touch and go landings at the LCL apt for about 40 min. The final t.o. was preceded by a full stop ldg. Shortly after lift off, the plt reptd that the acft lost pwr and he was unable to clear a tree at the top of a ridge…NTSB ANC87LA120Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Chackachatna Ri, AKThe pilot stated after he touched down on the gravel bar he lost directional control of the aircraft causing the aircraft to strike a log. The airplane then went up on its nose.NTSB ANC87FA118Accident · No injuriesField investigationFinal reportDe Havilland DHC-2 MK-1 · Elmendorf Afb, AKThe instructor (CFI) elected to demonstrate a no-flap takeoff with calm/glassy water conds. After the float plane had accelerated to about 55 to 60 KTS without becoming airborne, he elected to abort the takeoff. He stated that he attempted a left turn & the…NTSB MKC87LA160Accident · No injuriesLimited investigationFinal reportNorth American Navion · Chillicothe, MOThe PIC was ferrying the navion to a distant location to undergo an annual insp. Abt 20 min into the flt, the PIC rptd experiencing eng pblms. The PIC was able to fly to a nearby arpt for a precautionary lndg. Instead of making the lndg the PIC went around to…NTSB MKC87FA159Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Maquoketa, IAAfter departing the Maquoketa muni arpt, the acft was observed to fly at low altitude over some buildings that included a house & trailer home. As the acft flew over the property in a left banking turn, the left wing struck the top of a tree & then the acft…NTSB MKC87DCA03Accident · Serious injuriesFinal reportBurkholder Q-2 · St Charles, MODrg takeoff, the eng began to run rough at an estd alt of 50 to 100 ft AGL & would not developed enough power to maint flt. Subsequently, as the plt was lndg in a soybean field, the acft flipped over & came to rest in an upright attitude. A teardown of the…NTSB LAX87LA299Accident · No injuriesLimited investigationFinal reportBeech C23 · Mammoth Lakes, CADuring a pleasure flight, just after take-off, the engine experienced a partial loss of power when the plt positioned the carb heat control to full cold. The plt stated that in order to obtain full power, during the runup he would position the carb heat to…