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 SEA84FA102Accident · 2 fatalField investigationFinal reportCessna 140 · Lovelock, NVThe plt had originally requested a wx briefing at 0444 for a flt from cheyenne,WY to loverlock,NV. Prior to departing cheyenne at 0630, the FBO told the plt that the Lovelock arpt was flooded. The plt replied he would land at a strip in town. Fuel receipts…NTSB NYC84LA152Accident · No injuriesLimited investigationFinal reportCessna 337D · New Paltz, NYAbout 5 mins after departing the arpt, the front eng began to gradually lose power. The plt turned back toward the arpt & adjusted the fuel selector to various settings. The front eng continued to lose power and the rear eng began losing power. Subsequently,…NTSB MKC84LA138Accident · No injuriesLimited investigationFinal reportSoneria II · Kansas City, KSThe plt of the home built acft was practicing touch-&-go landings. While climbing out after the 5th landing, the plt's canopy unlatched & opened. The plt attempted to close the canopy & nosed the acft down to maintain a safe airspeed. While trying to close…NTSB MKC84LA132Accident · No injuriesLimited investigationFinal reportCessna 175 · Imperial, NEWhile en route, the plt tried to circumnavigate an area of bad wx. He was in & out of rain & finally decided to reverse course. He said he inadvertently flew into a thunderstorm & lost control of the acft due to turbulence. The acft entered a steep dive, &…NTSB MKC84FU003Accident · Serious injuriesFinal reportAmerican Aerolights Eagle XL · Millard, NEThe plt of the ultralight vehicle was flying as #2 in a flt of 2. The plt of the lead acft stated that they observed rain showers south of Millard & elected to return to the arpt ahead of the precipitation. After arriving, they landed on a 40 ft wide taxiway…NTSB MIA84FA161Accident · Serious injuriesField investigationFinal reportBeech 35 · Sanford, FLThe eng lost power when the acft was on final apch to land. The plt stated that he then switched fuel tanks, activated the electric fuel boost pump & worked the related wobble pump as fast as he could, but was unable to restore eng power. Subsequently, the…NTSB LAX84LA282Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Visalia, CAWhen the plt arrived at his destination, he was unable to fully extend the gear. He diverted to Visalia, CA. After reducing the fuel load, he made an intentional, power-off, wheels-up landing. An exam revealed that nose gear bellcrank assy had caught on the…NTSB LAX84LA281Accident · No injuriesLimited investigationFinal reportCessna 180K · San Miguel Is, CAThe plt was taking off in a 35 kt wind with the flaps extended. The acft became airborne in a 3 point attitude, & when 2 to 3 ft in the air, it began a left turn. Subsequently, the wing dragged the ground & the acft nosed over. The plt said he should have…NTSB FTW84LA229Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Seymour, TXThe 27 hour student plt aborted his landing when the acft began to balloon. The plt retracted the flaps and the acft settled hard onto the rwy and bounced back into the air. The plt reacted by pulling back on the yoke and inadvertently applied left aileron…NTSB FTW84FA220Accident · 1 fatalField investigationFinal reportPitts Special S-1 · La Marque, TXThe plt was scheduled to perform aerobatics in an air show. While maneuvering at about 300 ft AGL, the acft entered a nose high, steep left turn, stalled, then entered a 2 turn spin to the left. The plt recovered in a nose low, wings level attitude, but the…NTSB CHI84LA321Accident · No injuriesLimited investigationFinal reportCessna 177 · Hobart, INThe plt figured he was high and hot during landing so he said he just pushed the nose over and forced the acft onto the rwy. The acft hit hard on the nose gear and bounced. After recovery the plt found the nose gear tire flat and taxiied off the rwy into the…NTSB CHI84LA183Accident · No injuriesLimited investigationFinal reportCessna 182N · Minonk, ILThe acft ran off the departure end of the rwy during an aborted takeoff. After the nose gear collapsed the acft nosed over. Investigation revealed that the plt lowered 10 deg of flaps instead of the recommended 20 deg for a soft field takeoff. He used about…NTSB CHI84LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Boyd, MNThe acft was circling a field at about 400 to 500 ft AGL in at least a 40 degree bank when it stalled. The pilot added power and lowered the nose, as the acft was recovering from the stall it impacted the ground and nosed over.NTSB CHI84LA174Accident · Serious injuriesLimited investigationFinal reportGable Sonerai II · Berlin, WIThis homebuilt acft stalled during a forced landing after an engine failure. The plt reported that the engine temperature went to 650 degrees which was an overheat condition. The plt stated that he tried to return to the arpt but stalled 20 ft short of rwy 27…NTSB ATL84LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Jesup, GAThe plt reported he was spraying water and at the end of a swath run when he turned off the spray and pulled up, the engine lost power. The acft collided with trees during the forced landing. No mechanical discrepencies or malfuntions were found after the…NTSB ATL84LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student reported that he flared too high & the acft bounced about 4 times after which it left the rwy. The nose gear collapsed as it contacted mud beside the rwy.NTSB ATL84LA161Accident · No injuriesLimited investigationFinal reportWaco RNF · Thomaston, GADuring the landing roll the acft drifted to the side of the sod strip where a wheel encountered a surface deviation. The acft turned & nosed over.NTSB MKC84LA133Accident · No injuriesLimited investigationFinal reportBeech V35B · Lee'S Summit, MOThe plt reported that the acft landed hard, bounced and landed hard again breaking the nose gear off the acft. The pilot stated he encountered a strong downdraft on approach.NTSB MKC84FA131Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Sheldon, IAAt about 1015 CDT, while en route, the plt radioed a fss & requested the Kansas city wx. VMC conditions were reported at Kansas city, but the plt was informed of an AIRMET, which provide a caution of low ceilings & reduce visibilities across his route of flt.…NTSB MIA84LA159Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · New Smyrna Bch, FLWhile the plt was taxing onto the rwy, the wind picked up the right wing & the acft was blown inverted. The winds were gusting 30 KTS.NTSB MIA84IA160Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Miami, FLThe plt reported that during a descending turn at aprx 8000 ft & 200 KTS, the acft encountered turbulence & a lateral gust. He stated that this caused the acft to roll into about a 70 deg bank. He initiated a recovery, but the acft had gotten in a 20 deg nose…NTSB FTW84LA222Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Marble Falls, TXDuring arrival, the plt descended from 10,500 ft to 2300 ft, then circled a house 3 times before turning toward the arpt. As he rolled the wings level & was preparing to call the arpt, the eng lost power. He was unable to start the eng, so he elected to make…NTSB FTW84LA221Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Putnam, OKThe acft bounced during landing and the plt attempted to abort the landing. A truck was parked near the end of the field. The acft collided with the truck which it failed to clear in an attempt to fly over it. There were no reported malfunctions of equipment.NTSB FTW84LA219Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Galveston, TXThe a/c was being flown at about 300 ft over the bay and the pilot and passenger were looking for fish. When the pilot made a turn to fly in a downwind direction the aircraft started to stall. The pilot stated that he advanced the throttle but the engine did…NTSB DEN84FU004Accident · Serious injuriesFinal reportEipper Quicksilver MX · Berthoud, COThe ultralights were flying in loose formation on a short x-country. During the flt, the wind shifted to the east and created some turbulence and downdrafts near the end of the journey on final approach. The lead vehicle landed without knowledge that his…NTSB DEN84FA144Accident · 1 fatalField investigationFinal reportBeech B23 · Ruidoso, NMThe pilot stated that upon landing a gust of wind blew the aircraft off the runway center and he initiated a go-around. Witnesses stated the aircraft climbed to approximately 200 to 300 ft and started a left turn. Engine power appeared to be minimal. As the…NTSB DEN84FA143Accident · 1 fatalField investigationFinal reportCessna T210N · Farmington, NMFuel exhaustion occurred in normal cruise flt after plt determined consumption precluded reaching destination and requested emergency straight-in to nearest airport. Forced landing executed on highway, wing struck a parked, occupied vehicle. Plt accustomed to…NTSB CHI84LA176Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Ft Atkinson, WIThe acft stalled during a short field takeoff after a landing during which full up trim was used. The student plt did not use a checklist or reset the trim prior to takeoff.NTSB ATL84IA160Incident · No injuriesIncident investigationFinal reportDouglas DC-9-32 · Mount Vernon, ILKansas city ARTCC (zkc) had cleared ozark flt 709 (a DC-9, N923L) to cruise at FL270. While proceeding ese near the edgeof the zkc area, the DC-9 converged on zorro 11 (a flt of 3 F-4'S). The F-4'S had been cleared by indianaplolis ARTCC (zid) to proceed…NTSB LAX84FA280Accident · 1 fatalField investigationFinal reportGrumman American AA-5B · Placerville, CAThe plt lived near the arpt & had been commuting to sacramento, CA for about 3 weeks. Rwy 27 was the prominant rwy & the arpt was surrounded by hills. Shortly after taking off, the acft crashed about 2 mi west of the arpt while in a right wing low attitude on…NTSB FTW84FA218Accident · 2 fatalField investigationFinal reportde Havilland Tiger Moth DH 82A · San Antonio, TXThe acft crashed in an open pasture with trees on the western perimeter. The acft attitude at impact was nose down at a 30 to 50 degree angle in a right spiral. The main fuel tank mounted on the top wing over and behind the engine broke from its mount on…NTSB ATL84LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Boaz, ALThe acft collided with a traffic sign while taxiing for takeoff on a highway. The plt said he was a'path finder' for a fly-in and had the cooperation of the police. The owner of the acft said the plt was not authorized to use the acft for this flt.NTSB ATL84FA158Accident · Serious injuriesField investigationFinal reportBell 206B · Trammel, VAThe acft collided with static wires attached to an electrical transmission line while cruising at low alt, crashed and burned near hwy 63. The plt was thrown from the acft before it burned. The plt said he never saw the wire he hit. He had been employed as a…NTSB ANC84LA060Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Talkeetna, AKThe plt was repositioning the acft from a private strip near palmer, AK, to his property near Talkeetna, AK. After stopping at the Talkeetna arpt, he was hand propping the acft when the eng started & the acft began moving. The plt tried to turn off the mags,…NTSB SEA84LA099Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Sherwood, ORDuring landing the acft swerved off the rwy. The plt stated that the recommended procedure at this arpt is to land uphill. Investigation revealed that the landing was made with a 9 kt quartering tailwind.NTSB NYC84LA156Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Vultee L-13A · Dummerston, VTDuring arrival, the plt landed to the south on a turf rwy. He stated that after a normal apch & touchdown, the acft encountered a gust of wind, presumably from the northwest & the acft nosed over. Also, in an accident report, he reported the wind was from the…NTSB NYC84FA157Accident · 1 fatalField investigationFinal reportCessna A152 · Bethlehem, PAThe acft crashed while spinning from low alt. The acft was observed by witnesses doing aerobatics at low alt. At the topof loop or vertical climb the acft did a hammerhead stall under power and went into a spin. It appeared to one witness as if the plt was…NTSB LAX84LA278Accident · Minor injuriesLimited investigationFinal reportChristen Eagle Stallins 195 · Knights Landing, CAThe acft crashed during a series of aerobatic practice maneuvers. The plt reported that during the positive and negative'g' maneuvers he 'apparently passed out.'NTSB FTW84LA217Accident · No injuriesLimited investigationFinal reportHughes 500D · New Braunfels, TXDespite adverse wx which forced the plt to stop once enroute to his dest the flt was continued. Directional control was lost when the tail rotor contacted the terrain separating both tail rotor blades from the acft and torsionally shearing the tail rotor…NTSB DEN84FA142Accident · Serious injuriesField investigationFinal reportHughes 369D · Meeker, CODuring slow (35-40 KTS) cruise flt at about 50 ft AGL in mountainous terrain for wildlife survey, pwr loss occurred. Auto systems briefly restored pwr, followed by a ttl loss. Plt executed emergency autorotation into trees on sloping terrain. Investigation…NTSB CHI84LA173Accident · No injuriesLimited investigationFinal reportBeech A36 · Minneapolis, MNThe acft touched down hard during the landing. The nose gear collapsed and the acft slid to a stop. The plt said he was not able to arrest the sink rate of the acft with power during the landing flare.NTSB SEA84LA100Accident · No injuriesLimited investigationFinal reportCessna T210L · Vancouver, WAAccording to the plt's calculations, the acft should have had enough fuel on board for 8.4 hrs of flt. However, after about 5.6 hrs of flt time, the eng lost power from fuel exhaustion. The acft was damaged during a wheels-up landing. The plt said that the…NTSB MIA84LA158Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Daytona Beach, FLThe acft lost power while the plt was towing a banner over water. He was unable to restart the eng & subsequesntly ditched the acft in the ocean near Daytona Beach, FL. The plt elected to keep the banner attached to the acft to keep the plane from flipping…NTSB MIA84FA157Accident · Minor injuriesField investigationFinal reportCessna 310Q · Keystone Hgts, FLThe acft crashed while the plt was attempting to takeoff from rwy 10, which was not lighted. Tire marks showed that the acft had run off the rwy about 1200 from the threshold. After leaving the rwy, the acft collided with trees before coming to rest. Both…NTSB LAX84FA277Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Ukiah, CADuring arrival, the plt was cleared for a loc/dme rwy 15 apch to the Ukiah arpt. At 1307 PDT, he began the apch at the tucci intersection, 15.5 mi north of the rwy. At 1311:04 the last radar contact showed that the acft was about 5 mi north of the arpt. At…NTSB FTW84FA216Accident · No injuriesField investigationFinal reportSikorsky S-76A · High Isl Blk595During cruise flight at 500 ft over gulf waters, the left engine sustained a massive, uncontained, explosive failure. Sharpnel penetrated the right engine, which failed from damage. Sharpnel also penetrated the ac and DC junction boxes, causing complete…NTSB DEN84LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDuring a crosswind takeoff the right wing began to raise just as the plt was thinking about rotating. This startled him & he aborted the takeoff. The acft departed the left side of the rwy & flipped over on its back.NTSB CHI84LA172Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Winona, MNAfter landing, the plt was turning left onto the taxiway when the wind lifted the right wing and tail of the acft. The acft nosed over.NTSB ATL84LA156Accident · No injuriesLimited investigationFinal reportCessna 182 · Burlington, NCThe acft nosed over during a forced landing after the engine lost power. The plt said the fuel gauges were reading 1/4 to 1/2 full just before the engine quit. No fuel was found in the acft after the accident. The engine performed normally after refueling.NTSB SEA84LA098Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Spangle, WAAccording to FAA inspectors, the plt polished the lower leading edges of wings before departing, as they were covered with frost. The plt stated that during climb out the acft entered an inadvertent stall, followed by a three point landing onto soft field.…