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 ATL85FA135Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Prestonburg, KYThe pax deplaned & the plt took off on a short flt to a nearby arpt to refuel. After climbing for about 30 to 40 sec & accelerating to aprx 100 KTS, the plt started to adjust the pwr for lvl flt. At about that time, the eng lost pwr. The plt attempted to…NTSB MKC85FCA02Accident · Serious injuriesFinal reportPiper PA-25-235 · Dexter, MOThe plt was making a swath run while on an aerial application training flt. During a pull-up at the end of the swath run, the rgt wing struck the tops of 3 willow trees. The acft then entered a rgt roll, struck an eletrical power line, rolled inverted &…NTSB MKC85FA084Accident · 1 fatalField investigationFinal reportBeech A-36 · Gray Summit, MOAfter departing the st. clair airport establishing a normal climb to the destination airport 24 miles to the northeast, the acft was tracked by radar for a four minute period. The short period of coverage showed a normal climb tolevel flight. The radar image…NTSB LAX85LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Moorpark, CAThe student plt became disoriented while on a solo x-country flt during wich he was on top of an overcast. Fuel exhaustion occurred while he was being radar vectored to an arpt. A forced landing was attempted on a freeway offramp and the acft's wing struck a…NTSB FTW85LA183Accident · No injuriesLimited investigationFinal reportMitsubishi MU2J · Patterson, LAOn visual final apch to the arpt at night the acft entered ground fog. Reflection of the landing lights in the fog was distracting. The acft landed in the adjacent seaplane landing area instead of on the hard surface rwy. A subsequent inspection of the aprt…NTSB FTW85FA188Accident · Serious injuriesField investigationFinal reportBell UH-1B · Boutte, LAThe plt had stabilized acft in a 125' hover, prior to picking up a load, when the eng spooled down and acft entered talltrees with low rotor RPM and pitched nose down as it descended thru the trees. Ground witnesses heard 2 loud 'bangs' prior to the acft…NTSB CHI85FA165Accident · 3 fatalField investigationFinal reportPiper PA-30 · Worthington, INThe acft stalled and crashed in a fld after the plt declared an emergency stating he was losing pwr on the right eng and he could not maintain alt. At 1405 EST, the acft was told to contact hulman apch with instructions to descend to 3000 ft MSL. The mode c…NTSB ATL85LA134Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Casville Juct, NCWhile on a personal x-country flt, the acft lost power & the plt attempted a landing on a road. During the attempted landing, the acft struck a guy wire & crashed inverted on the road. A post crash exam revealed that aprx 1.5 pints of fuel was in the acft…NTSB ANC85LA062Accident · No injuriesLimited investigationFinal reportCessna 207 · Port Graham, AKThe plt lost directional control while taking off from a rwy covered with 4 to 6 inches of snow, ice & slush. The acft then swerved sideways, collided with a snow bank & was damaged. The arpt was located on public domain & was not regularily attended or…NTSB MIA85LKG01Accident · Minor injuriesFinal reportCessna 150G · Daytona Beach, FLThe acft was ditched as a result of a loss of power. The plt stated that while banner towing 200 yds offshore at 3000 ft AGL, the acft eng skipped. The plt applied carb heat and checked the fuel controls. Then the eng quit completely. Since the Beach was…NTSB LAX85LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Concord, CAThe student was practicing touch & go takeoffs and landings. On the fifth approach to a landing the student plt reported that the acft was a little high and he applied full flaps. The acft bounced on initial touch down. While attempting to recover from the…NTSB LAX85FA202Accident · 2 fatalField investigationFinal reportCessna 172M · Camp Verde, AZBoth acft involved in the collision were part of a 4-plane formation flt en route to a group fly-in. N6439R was seen to change positions several times during the flt while the other acft remained stable. Reports from witnesses say that N6439R made 'close…NTSB FTW85FA181Accident · 4 fatalField investigationFinal reportCessna 320B · Athens, LAThe acft was on an instrument flt plan. The plt had received a pre takeoff weather briefing. He was briefed on the area of weather that was at the acft's twelve o'clock position four miles in front. The area was thirty miles southwest and twenty miles wide.…NTSB CHI85LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Stevens Point, WIDuring a low level flt over a river, the plt initiated a turn to reverse direction at 300 ft AGL. The acft contacted the water during the descending turn and nosed over.NTSB SEA85LA092Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Hampton, ORThe student plt made a precautionary landing due to being lost and low on fuel. The airstrips surface was 1000 ft of dirt and sand with a fence at the departure end. Takeoff data based on gross weight, zero wind, 4000 ft elevation at 80 degrees, on a hard…NTSB SEA85LA091Accident · No injuriesLimited investigationFinal reportCessna 185 · Paulina, ORThe plt reported that on 4/11/85, the left tire blew out during a landing at omak, WA, damaging the left wheel & braking sys. He said that repairs had been made, but the left brake felt spongy. The next flt (on 4/12/85) was to a private airstrip at Paulina,…NTSB NYC85LA105Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Utica, NYThe accident occurred during a training flt for empire airlines. A left eng failure was simulated past the faf when aprx 300 ft above mda. The student completed the emerg checklist which included retracting the landing gear. The flt then continued visually to…NTSB NYC85LA095Accident · No injuriesLimited investigationFinal reportLet L-13 · Mansfield, MAThe plt reported that he turned onto final apch at about 500 ft AGL & the pattern was normal until he was about 1/3 mi from the rwy threshold. The glider then began to sink rapidly. The plt realized that he would be unable to glide to the rwy, so he decided…NTSB MKC85LA083Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mechanicsville, IAThe plt attempted a takeoff from a short, wet, soft, alfalfa field in an acft loaded with two occurants and aprx a full load of fuel. The acft collided with a fence and a tree after using the available distance in the flt attempt. Plt recommended a more…NTSB LAX85LA204Accident · No injuriesLimited investigationFinal reportCessna 172 · Page, AZThis was the return leg of a student plt solo x-country flt. On landing the acft stalled 15 ft above the rwy and the left wing contacted the rwy. The plt stated he was perhaps over confident in his flying ability.NTSB LAX85LA201Accident · Serious injuriesLimited investigationFinal reportSederberg Bensen B-8M · Lower Lake, CAFollowing a normal takeoff with the fuel tank one-half full, the acft climbed to 1000 ft AGL at which time engine pwr was gradually lost. A grnd witness reported hearing the eng sputter or miss. The plt attempted to return to the arpt but had insufficient…NTSB FTW85FA180Accident · 1 fatalField investigationFinal reportCessna 152 · Franklin, LAAcft crashed into a crawfish pond during a forced landing at night following a power loss as a result of fuel exhaustion. After departure, the plt contacted ARTCC and stated that his alternator was out. With center help, alternator was restored and plt cont'd…NTSB DEN85FTE01Accident · 2 fatalFinal reportUltralight Flight Phantom II · Erie, COThe Ultralight descended uncontrolled to ground impact following a failure of the outboard forward wing support cable/swage. Witnesses reported the Ultralight turned from north to south and upon leveling out, the left wing snapped upward, the right wing…NTSB CHI85LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Phillipsburg, OHDuring a night VFR approach to a strange airport the acft struck power lines located one-half mile from the end of the rwy. The plt stated that she was unaware of the wires & was not aware that her acft had collided with them until her forward progress was…NTSB CHI85LA163Accident · No injuriesLimited investigationFinal reportCessna 150L · East Liverpool, OHWhile on a night/solo x-country flt, the eng had a partial loss of power. The student attempted to make an emergency landing at a nearby arpt, but the rwy lights were not illuminated. At first, the student did not remember that the lights could be controlled…NTSB CHI85LA162Accident · No injuriesLimited investigationFinal reportCessna R182 · Chicago, ILWhile in the landing flare, the acft apparently touched down on the nose gear & began to porpoise. During the subsequent bounces, the nose gear collapsed & the acft nosed over as it departed the side of the rwy. The plt stated that he felt that a gust of wind…NTSB BFO85LA039Accident · No injuriesLimited investigationFinal reportRotec Rally 3 · Alta Vista, VAEach time the pilot applied nose up pitch control after take off, the acft settled but would maintain straight and level flight when the controls were neutralized. Due to the settling effect, obstruction clearance could not be attainedand the acft settled…NTSB BFO85IA035Incident · No injuriesIncident investigationFinal reportBoeing 737-217 · Chantilly, VAApprox 25MIN aft lndg,flt 168 was cleared for tkof on rwy 30 at dulles intl arpt. Abt 1MIN later the crew called for an aborted tkof because the #2 epr appeared slow to spool up. Aft taxiing back and running up the engines, flt 168 atmptd a second tkof. Dfdr…NTSB SEA85LA090Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Okanogan, WADuring an aerial application flt, the acft collided with a power line at about 30 ft AGL. The acft then rolled to the right & struck the ground. The accident occurred about 5 min after the acft had departed the spray area.NTSB MIA85IA147Incident · No injuriesIncident investigationFinal reportHawker Siddeley HS-125 · Ft Lauderdale, FLThe plt reported that on an FAA check flt, the nose gear would not extend. Subsequently, the acft received minor damage when it was landed with the nose gear retracted. An investigation revealed that a nose landing gear door rod assembly had failed from…NTSB LAX85LA200Accident · Minor injuriesLimited investigationFinal reportBell 206B · Lake Berryessa, CAThe acft was on a low level, eagle survey mission. While cruising between 20 & 30 mph, the plt flew up a canyon & was crossing a ridge at about 150 ft AGL when he saw wires ahead. He took evasive action, but the helicopter struck the wires. The tail rotor &…NTSB LAX85FA199Accident · Serious injuriesField investigationFinal reportHiller UH12J3 · Klamath, CAThe helicopter was returning to a private landing pad after a reconaisance flight prior to sprating. At about 10FT AGL after flaring and leveling the pilot could not control a drift and roll to the left. The rotor blades struck the ground within about one…NTSB BFO85LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA 22-150 · New London, VAWhile exiting the traffic pattern after tkof the plt smelled smoke and observed flames near the left rudder pedal. After failing to put the fire out with his shoes the plt returned to the arpt and subsequently lndd using side window to look out of due to…NTSB BFO85LA034Accident · Serious injuriesLimited investigationFinal reportCirrus Standard Cirrus · Woodbine, MDDuring takeoff, the glider was observed to climb at an unusually steep attitude. Then at about 75 ft AGL (aprx 50 above the tow plane), the glider released from the tow rope. According to one witness, the acft maintained a nose high attitude, then pitched…NTSB ATL85LA133Accident · No injuriesLimited investigationFinal reportCessna 195 · Lexington, KYDuring ldg roll-out the plt applied brake press in order to turn onto the taxiway & the rt brake grabbed causing the acft to ground loop. The left landing gear spring strut separated from the fuselage attachment point.NTSB ATL85IA132Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Marion, ALCruising at 4000 ft MSL when engine vibration occurred and became severe. Reduced throtte but roughness persisted. Unable to mntn altitude with 2000 RPM and 25 inches map. Made forced ldg in corn field. Nose ldg gr collapsed. Engine checked out okay. One…NTSB LAX85FA198Accident · 1 fatalField investigationFinal reportCessna 140 · Petaluma, CAThe ATP plt initiated a short x-country flt at night in an acft with no attitude gyro instruments. Just before the acft crashed, witnesses heard the acft. They reported that the eng sounded like the plt was doing stunts or sharp turns. They said they could…NTSB CHI85FA158Accident · 1 fatalField investigationFinal reportCessna T210N · Ravenna, OHThe plt departed port columbus uneventfully, flew for aprx 40 mins then shot a VOR apch to the mda at portage county. This fld does not have a wx reporting facility. The plt then performed a missed apch upon reaching mda. During the missed apch and after…NTSB ATL85LA136Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Seale, ALWhile performing a soft fld takeoff the plt reportedly applied full pwr with the control yoke pulled full aft. The acft became airborne at aprx 35 KTS with the stall warning horn sounding. The acft drifted left of the centerline and the plt over corrected…NTSB NYC85FA104Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · East Haddam, CTDuring approach to runway 14 pilot decided to go around. Aircraft turned left about 90 degrees and collided with rising terrain .2 NM east of the runway. The rising terrain parallels runway 14.NTSB MIA85LA145Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Wabasso, FLInstructional flight practicing steep turns. Engine lost oil through crack in propeller governor oil line and seized. Instructor took over control and landed on a road in a sand pit. Pilot was unable to steer through an 's' turn on the road and collided with…NTSB MIA85FA146Accident · Serious injuriesField investigationFinal reportBell 47G-2 · Panama City Bch, FLThe pilot was carrying two paying passengers for a sightseeing ride and had taken off two minutes earlier from a helicopter pad at the beach. He stated that he felt the engine sputter, the cyclic stick shake, less than 10 seconds later the acft hit the water…NTSB LAX85FA197Accident · Serious injuriesField investigationFinal reportCessna 177 · Fallbrook, CAAlthough aware of existing IMC conditions and reduced lighting with the setting of the sun, the plt attempted a visual apch to his home arpt which did not have an approved apch. His remarks to mcclellen-palomar twr, regarding the use of the on-board loran…NTSB FTW85LA178Accident · No injuriesLimited investigationFinal reportBeech C23 · San Antonio, TXThe acft departed stutgart, AR, with full fuel tanks at 1250 CST. Five hours and eight minutes later, the plt made an emergency landing following fuel exhaustion near his intended destination, San Antonio, TX. In an interview with FAA investigators the plt…NTSB FTW85LA177Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Rosston, OKPilot stated engine lost power during takeoff climb due to a leak in the air line from the engine bleed valve. He attempted to make a forced landing but upon touchdown, due to his forward movement, the aircraft nosed over.NTSB FTW85FA176Accident · Serious injuriesField investigationFinal reportCessna 152 · Arlington, TXAcft on traffic patrol watch was observed for several minutes before crash at low altitude doing slow flt and flying erratic prior to acft stalling ans spinning into apt building no evidence of pre-impact failure or malfunction of the acft was found.NTSB DEN85LA114Accident · No injuriesLimited investigationFinal reportCessna 172 · Grant, NMThe acft crashed during takeoff from a dirt strip near Grant, NM, while on a pleasure flt. VMC conditions prevailed and no flt plan was filed. The plt & his 3 occupants were not injured. The plt reported that a dust devil caught the acft at an alt of 35-50 ft…NTSB CHI85IA160Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Dayton, OHOn short final at an airspeed bet 120 and 125 KTS full flaps were lowered for landing. When the flaps reached the full down position, the stall warning horn came on and the stick pusher on the rosemont stall avoidance system activated. The captain disengaged…NTSB ATL85LKG04Accident · No injuriesFinal reportAero Commander S2R · Leslie, GAThe acft lost power en route to spray crops & crash landed in a wooded area. The acft had flown only 2 miles when the power loss occurred. During the post accident investigation an exam of the powerplant & systems revealed that the supercharger had a loose…NTSB ATL85LA131Accident · No injuriesLimited investigationFinal reportMooney M20E · Gunthersville, ALThe plt reported that he failed to extend the landing gear in the traffic pattern. Subsequently, the acft was damaged during a gear up landing.