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 LAX85LA135Accident · No injuriesLimited investigationFinal reportBeech 65 · Camarillo, CAAn inspection of rwy 8 disclosed the acft touched down on the two main gear simultaineously, followed immediately by thecollapse of the nose gear. The acft's nose & both propellers contacted the rwy, with no indication of a yaw. The nose gear actuator ass'y…NTSB FTW85LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Hobart, OKAt 1515 CST, the plt contacted a fss & was advised that a front would be moving thru the destination (Hobart) area at about 2200. When he departed stillwater at 1840, the wind was from the south. At 2004, the plt contacted altus afb & was advised that the…NTSB CHI85FA104Accident · 2 fatalField investigationFinal reportMooney M20C · Portsmouth, OHThe acft was maneuvering at about 500 ft AGL when witnesses reported what they believed to be an eng malfunction. The acft then entered a spin and impacted in an open fld out of control. A conclusive cause of an eng malfunction could not be determined during…NTSB BFO85LA016Accident · Minor injuriesLimited investigationFinal reportCessna 152-II · Ocean City, MDWhile on a student solo x-country flight, the plt experienced vertical gusting conditions during the second landing pattern, following an initial go-around. Fearing a hard landing due to a severe gust, the plt abruptly applied full back pressure on the stick,…NTSB ATL85LA093Accident · Minor injuriesLimited investigationFinal reportBeech A36 · New Albany, MSPIC had 1/2 hour check-out in A-36 but over 3900 total flight hours. His 14 hours in this acft was cross country flying. He stated that the fuel was kept evenly didtributed by switching the fuel selector between tanks during the nearly three hour flight. The…NTSB SEA85LA055Accident · No injuriesLimited investigationFinal reportBeech 58TC · Spokane, WAThe acft touched down to the left of the runway onto snow. Visibility at the time of the accident was 1 mile with snow and a ceiling of 700 feet.NTSB SEA85FA056Accident · 4 fatalField investigationFinal reportGulfstream AC-680F · Central Point, ORThe plt reported a loss of power on both engs during descent to land. Aprx 3 mins prior, twr gave plt option of 'straight-in' to rwy 14 or reg pattern to rwy 32. The plt hesitated & said 'just a minute' & twr offered wind info as '210 at 13.' Plt replied,…NTSB NYC85LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-200 · Malone, NYThe acft collided with the terrain on the side of a hill after encountering low ceilings and snow. The plt departed massena under a special VFR clearance and after aprx 25 minutes he decided to return to massena because of deterioratingweather. After flying…NTSB MIA85LA095Accident · No injuriesLimited investigationFinal reportCessna 411A · Merritt Island, FLAccording to the CFI on board, rotation was accomplished at 110 KTS. Shortly after takeoff the nose of the acft began drifting to the right and the acft began settling to the rwy. The CFI called for gear up and the acft settled to the rwy on its belly in the…NTSB LAX85FA137Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Corona, CAAfter refueling, the acft took off & lost pwr at 150 ft to 200 ft AGL. The acft struck trees while in a steepening left bank & crashed in an open field adjacent to the arpt. No contaminants or water were found either in the acft's fuel system or in the fuel…NTSB CHI85LA105Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lawrenceville, ILThe private plt & his instructor were practicing instrument approaches. The instructor stated that the fuel gages were reading low & the VOR needle was oscillating, so they decided to make a straight-in landing. He stated that they lowered the gear & flaps,…NTSB CHI85LA103Accident · Minor injuriesLimited investigationFinal reportCessna 337G · Peoria, ILThe acft was damaged in an off arpt forced lndg after the rear eng quit at about 350 ft AGL. The plt stated that he could not feather the prop on the rear eng which had stopped. Since the acft would not climb the plt elected to land off the arpt. The post acc…NTSB ATL85LA094Accident · No injuriesLimited investigationFinal reportChampion 7FC · Louisville, KYThe student plt departed from a snow covered rwy & proceeded on a solo x-country. When he returned, the nosewheel broke thru the snow crusted surface & collapsed, then the acft nosed over. The plt said there were ruts on the rwy from other acft which caused…NTSB ATL85LA092Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Charleston, SCPlt making practice coupled ILS apch in VMC. Intercepted localizer outside the outer marker. Held the gear,intending to lower them at om. Continued inbd to dh where he resumed manual control. Observed gear warning lt and heard aural gear warning but failed to…NTSB ATL85FA090Accident · Serious injuriesField investigationFinal reportCessna 152 · Acworth, GAThe acft contacted power lines and descended uncontrolled to the terrain during the recovery phase of a simulated forced landing. The simulated forced landing was initiated by the CFI at an alt of aprx 800 ft AGL over the median strip of hwy 75. The student…NTSB MKC85LA056Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Bentonville, ARDuring the landing approach, the plt stated, he probably forgot to extend the landing gear. Inspection of the acft revealed no mechanical problem with the landing gear extension or retraction mechanism. A test of the landing gear system showed it to work…NTSB FTW85LA115Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Mccoy, TXThe plt stated that he had departed the gala ranch strip & was flying at aprx 100 ft AGL to show his passengers their ranch property. While in slow flight with the flaps deployed, the plt entered a downwind skidding left turn. The acft subsequently stalled &…NTSB DEN85LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COThe student plt lost directional control of the acft when pwr was added to takeoff during a touch and go landing. The plt stated the acft began to veer right when pwr was added and he applied 'too much right rudder' to correct. The acft veered left and…NTSB CHI85LA102Accident · No injuriesLimited investigationFinal reportCessna 421C · Bay City, MIThe acft colloded with a snowbank during lndg. The plt & passg stated that a lndg gear cught in snow piled at an intersection from plowing. The induced drag veered the acft off the rwy to the left.NTSB ATL85LA091Accident · No injuriesLimited investigationFinal reportBeech 58 · Holly Springs, MSAbout 40 to 45 min after takeoff pilot noted electrical load meters at 0. Alternator warning lights were on. Reset was attempted but unsuccessful due to low battery voltage. Plt decided to make a precautionary ldg at Holly Springs, MS,but could not lower the…NTSB ANC85LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Soldotna, AKThe plt stated a gust of wind forced the left wing up as the acft touched down. Fuul pwr was added to go around. The acft continued to veer to the right until it stalled and impacted the ground in a nose low attitude aprx 100 yards south of the rwy. Winds…NTSB MIA85LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Merritt Island, FLPlt lost directional control and the acft collided with a dirt embankment while landing. The acft was landed with a right rear crosswind.NTSB ANC85LA046Accident · 1 fatalLimited investigationFinal reportCessna 207A · Koyuk, AKThe acft landed about 630 ft short of the threshold of rwy 02. The plt said he purposely landed short to take advantage of a rwy upslope and because of the location of snow removal equipment at the other end of the rwy. In landing short however he landed on…NTSB NYC85IA063Incident · No injuriesIncident investigationFinal reportCASA SAC-212-200 · Atlantic City, NJA construcciones sac 212-200 N296CA lost control during landing flare and landed hard on the grass along side runway 11 at bader field, new jersey, after all of the landing checks were completed the copilot pushed full forward the speed levers and called out…NTSB NYC85IA062Incident · No injuriesIncident investigationFinal reportBeech BE-99 · Putnam, CTPlt stated that during tkf the acft started to yaw & roll in a manner consistent with wake turbulence encounter. He applied full opposite rudder & aileron. Normal directional was regained between 50-75 ft above the gnd. The acft was leveled for cruise at 5000…NTSB LAX85LA134Accident · Minor injuriesLimited investigationFinal reportMilentz Quickie 02 · Camarillo, CAOn a local test flt for the recently constructed experimental homebuilt acft, plt experienced an on ground loss of control during the takeoff ground roll, veered off the runway and cartwheeled after encounterimg plowed furrow. Pltstated that the takeoff roll…NTSB LAX85FA136Accident · 1 fatalField investigationFinal reportHughes 369D · Hilo, HIA search was initiated when the helicopter did not arrive. It was fnd 2 days later where it crashed drg an autorotation in a rain forest. Drg the flare/touchdown, vegetation had caught on a tundra pad on the l skid & the acft rolled over. An exam revealed the…NTSB FTW85FA112Accident · 2 fatalField investigationFinal reportCessna 402B · Altus, OKDuring an eng start, prior to the flt, the l eng backfired 2 or 3 times. A witness described the 1st backfired as 'the loudest I have ever heard.' When the acft took off, two persons living near the departure end of the rwy noted that the acft (believed to be…NTSB DEN85FA074Accident · 1 fatalField investigationFinal reportBeech BE-23-24 · Eureka, UTOn feb 6, 1985,a Beech BE-23-24 musketeer,owned and operated by the plt crashed into the side of a 7000 ft mtn at the 6700 ft level. The ac was demolished and the plt received fatal injuries. The wx conditions were reported as VMC by provo, Utah and by a…NTSB DCA85AA013Accident · Serious injuriesFinal reportMcDonnell Douglas DC-9-15 · Philadelphia, PAAfter lndg, the acft was parked on the ramp for aprx 39 min to load cargo. Drg that time, lgt freezing drizzle was falling, intermittently mixed with ice pellets & snw. The crew checked the acft surfaces from the cockpit & entry door, but observed no ice or…NTSB BFO85LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Lynchburg, VAAs the gear was retracting after takeoff, the acft began to lose power. The plt could detect no yaw to either side. When the acft was about 50 feet off the ground, the twr informed the plt that vapor or smoke was trailing from the left eng. The plt…NTSB SEA85LA054Accident · 4 fatalLimited investigationFinal reportCessna 182-F · Ashland, ORThe plt was briefed regarding weather and expected flt conditions btw medford and redding. The briefing included a forecast for improving conditions approaching the destination as well as possible icing en route. The acft departed medford carrying aprx 970…NTSB ATL85FA089Accident · No injuriesField investigationFinal reportDouglas DC-3 · Charlotte, NCThe plt attempted an insrument departure from Charlotte, NC, without deicing the acft which witnesses stated, had ice on the airframe. During climbout, the plt was not able to maintain elevator control so he returned to land at Charlotte. During the landing…NTSB SEA85LA053Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Taholah, WAThe acft had lifted off during an external load operation when the plt felt a 'vibration/shudder'. The right skid contacted the ground and the helicopter rolled over during an attempt to maneuver the helicopter away from ground personnel. Inspection revealed…NTSB LAX85LA133Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Big Bear, CAAfter spending the day skiing, the plt & passengers planned to depart on a return flt to san diego. The wind was from 210 to 220 deg at about 10 mph. The plt elected to takeoff on rwy 7 since low clouds were approaching from the west & the visibility was near…NTSB FTW85LA111Accident · No injuriesLimited investigationFinal reportAerospatiale AS 355F-1 · Sabine Pass, TXWhile en route at an alt of 500 to 700 ft, the #1 eng spooled down. The plt secured the #1 eng & turned back toward the heliport to make a single eng landing. However, he could not maintain level flt & the rotor RPM began dropping. The plt noted that the #2…NTSB DCA85AA012Accident · 9 fatalFinal reportBeech 65-A80 · Soldotna, AKDuring arrival, the crew of npa flt 1802 contacted the company wx observer at Soldotna who advised the wx was: wnd calm,ceiling 600 to 800 ft, vis 8 to 10 mi, no precip. They made an NDB apch, but missed the apch & requested another apch. Aprx 1 min later,…NTSB BFO85LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Chantilly, VAWhile retracting the landing gear after takeoff, the gear hesitated briefly at about midpoint before retracting fully. Attempts to extend the gear through normal and emergency procedures failed. The acft landed at dulles international airport with the gear in…NTSB SEA85LA052Incident · No injuriesLimited investigationFinal reportCessna 337B · Ontario, ORPilots sister approched the rt side of the acft to speak to him. When leaving the side of the acft she walked into the front turning prop. Plt stated she had been around the acft numerous times and was aware of the engine configuration.NTSB NYC85FHA02Accident · Serious injuriesFinal reportCessna 182N · Manville, NJThe plt reported that he preflighted the acft, made a normal run-up & took off on rwy 25 which had 'some ice.' Shortly after lift-off, the acft stalled & crashed. Witnesses stated that there was substantial ice on top of the wings.NTSB MIA85FA089Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Key Largo, FLThe aircraft crashed into the waters of the atlantic ocean and sank nose first into 15 feet of water. On impact the 25 bales of marijuana located in the cabin of the aircraft shifted forward and pinned the pilot and passenger in the aircraft. No usable fuel…NTSB LAX85FA132Accident · Minor injuriesField investigationFinal reportHiller UH12E · Five Points, CAWhile performing an ag flight the helicopter's engin suddenly lost power. At the time the aircraft was near its max allowable gross weight and it was between 3-5FT AGL. As the aircraft yawed left and descended. The pilot in command attempted to land on a…NTSB FTW85LA116Accident · No injuriesLimited investigationFinal reportBeech C-35 · Sheffield, TXThe plt stated the eng failed completely during cruise. The crankshaft was found separated during the eng teardown, with the rod and bearings also separated. Metallurgical testing revealed fractures to be from fatigue. Eng maintenance had been improperly…NTSB FTW85LA108Accident · No injuriesLimited investigationFinal reportCessna 182A · Covington, LADuring an apch to land, the eng lost power & the plt made an off arpt landing. While he was landing, the acft collided with a levee & was damaged. Ample fuel was still remaining in the acft & no preimpact failure or malfunction was found that would have…NTSB NYC85FA060Accident · 4 fatalField investigationFinal reportPiper PA-31-350 · Whitefield, NHThe acft crashed after executing a missed approach at Whitefield during IMC wx. The acft was seen at 300-400 ft AGL during some part of the maneuvering near the arpt. The acft seemed to be heading for the arpt when last seen by ground observers. The only…NTSB NYC85FA059Accident · 2 fatalField investigationFinal reportBeech A100 · Cedarville, NJThe two ATP rated plts were en route back to their home base arpt flying on an IFR flt plan in actual instrument wx conditions. Communications with ATC controllers was normal. During a night localizer apch into millville municipal arpt, an ATC specialist…NTSB FTW85LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Corsicana, TXThe student plt was on a x-country flt with intermediate stops at Corsicana & terrell, TX. At Corsicana, he initiated a touch & go landing on a partially ice covered rwy. After he applied power to takeoff, the acft began to swerve. The student stated that the…NTSB FTW85LA110Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Shreveport, LAThe plt landed on rwy 05 which was icy and covered with a blanket of fresh snow. He stated the wind was from 360 degs at 10 KTS. He had been informed of poor braking conditions on the rwy. The plt used main wheel brakes and reverse thrust. The acft drifted…NTSB ATL85LA088Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Hartford, TNThe plt was informed during wx briefing that VFR was not recommended because of low clouds. Plt elected to takeoff and follow I-90, however, wx conditions were poor and plt executed a climb to 10000 ft to clear the cloud layer. While en route the plt tuned to…NTSB MKC85LA053Accident · No injuriesLimited investigationFinal reportCessna A152 · Olathe, KSThe acft collided with a snow bank on the left side of the rwy following a loss of directional control during a touch and go landing. The plt stated control of the acft was lost when he attempted to reconfigure the acft for the takeoff portion of the touch…