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 ATL87LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Liberty, NCBfr departing on a ngt flt, the acft was loaded until it was at or near its max gross wt limit. The plt stated that as he was taking off on a 3000' rwy, the eng 'coughed' after the acft had accelerated to about the rotation speed & was aprx 3/4 of the way…NTSB ATL87LA200Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Greenville, SCBalloon dtpted launch site about six miles sw of landing airport for a key grab during a Balloon ralley. Wind was about seven KTS according to PIC. Approaching field to land basket was dragged through tree tops to slow Balloon. Power line hidden by the trees…NTSB ATL87LA196Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Sebring, OHPlt and his two pax had spent most of the day at barber apt preparing for the fireman's bbq to be held later. In late afternoon, they decided to take a flt around the area. During the flt, it was decided to land at the tri-city apt. Witnesses reptd that the…NTSB LAX87LA255Accident · Serious injuriesLimited investigationFinal reportBell 206L-3 · Benson, AZA Bell helicopter 206L-3 collided with wires while maneuvering over an underground telephone cable. The plt indicated that he had just completed a 360 deg right turn at the request of the pax and was aprx 185 deg through the second turn when he struck a…NTSB FTW87DRD09Accident · No injuriesFinal reportCessna T188C · Rayville, LAThe aircraft had to take off eastbound due to obstructions at the west end of the strip. The six to eight knot wind was variable from a right crosswind to a slight tailwind. Investigation revealed the aircraft's weight exceeded that established by the…NTSB ANC87LA092Accident · No injuriesLimited investigationFinal reportPiper J-3 · Lake Creek, AKThe pilot stated he touchdowned on a gravel bar and shortly after touchdown he lost control of the aircraft causing the aircraft to nose over on its back.NTSB ANC87LA090Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Becharof Lake, AKThe pilot stated he was rolling out for takeoff when the nose wheel struck a soft area causing the aircraft to go up on its nose.NTSB ANC87LA088Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Pingo Ridge, AKThe pilot stated that after touchdown he lost control of the aircraft causing the aircraft to nose over on its back.NTSB ANC87LA087Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Chistochina, AKDuring a telephone interview the pilot stated the aircraft did not produce full power and believed the reason was the propeller setting was not set to high RPM before landing. The aircraft stalled on final approach to the airport and the aircraft impacted the…NTSB MIA87LA194Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Opa Locka, FLThe plt stated that he was on a long final apch for Opa Locka airport & he lost all power. During a forced landing in an open field he struck a pile of logs, collapsing the nose gear. Post crash run of the eng revealed no evidence that would suggest a failure…NTSB CHI87LA160Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Dyckesville, WIAircraft stalled as the pilot attempted to climb and turn back to fly along green bay shoreline. The pilot was flying approx. 100 to 150 feet above the water in order for the passenger to photograph the shoreline.NTSB CHI87LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Jenison, MIOn takeoff roll, while practicing touch and go landings, the training flight collided with a deer. The instructor reported that after landing, full power was applied for takeoff and during rotation, a deer ran onto the runway and collided with the left side…NTSB MIA87IA195Incident · No injuriesIncident investigationFinal reportDouglas DC3A · Hilliard, FLAccording to the FAA the pilot stated that just after he rotated for takeoff the acft lost power in the left eng. He then aborted the takeoff, set the acft back on the runway & it slid off the left side into some bushes. The plts did not submit an operator…NTSB LAX87LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAThe student plt rprtd that he entered the traffic pattern to practice takeoffs & landings. He said that drg his 1st apch, he relaxed pressure on the left rudder pedal & the acft began to yaw. He then pulled aft on the yoke to avoid touching down sideways &…NTSB LAX87LA251Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Tracy, CAThe aircraft collided with terrain after a total loss of power. The plt indicated that the eng failed at 3,500 ft MSL. The plt had flown for about 30 min with the fuel selector in the right tank position when the eng quit. He initially switched the fuel…NTSB LAX87LA248Accident · No injuriesLimited investigationFinal reportBeech A36 · Temecula, CAThe aircraft made a hard landing when the pilot encountered turbulent crosswinds in the final stages of the landing approach. Both U.S. Government and aopa's airport directories contain warnings in the airport remarks sections of occasional strong turbulent…NTSB FTW87LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Farris, OKThe plt rprtd that drg a x-country flt, he got lost & the acft ran low on fuel. At dusk, he elected to make a precautionary landing in a open field. Drg the landing, the acft struck a tree & was damaged.NTSB DEN87LA163Accident · No injuriesLimited investigationFinal reportCessna 182M · Livingston, MTThe plt and an observer were conducting a search and rescue flt near the face of crazy mountain. The plt reported encountering a downdraft and the acft inadvertently stalled. The acft hit trees near the ridge line.NTSB BFO87LA044Accident · No injuriesLimited investigationFinal reportCessna 150H · Hot Springs, VAOn the second leg of a cross-country flight from annapolis, MD to albuquerque, NM, the pilot became disoriented and was unable to locate ingalls airport in Hot Springs, VA. The pilot realized he was low on fuel and decided to make a precautionary landing on a…NTSB ATL87FA194Accident · Serious injuriesField investigationFinal reportPiper PA-18A-150 · No.Myrtle Beach, SCThe airplane was maneuvering at 350 ft AGL in preparation for a banner pick-up when it entered a spin and subsequently impacted trees and the terrain. The plt stated that he 'failed to fly the airplane' while attempting to deploy a banner tow line, and that…NTSB ANC87LA086Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Wood River, AKAccording to the pilot he was taking off and after initial climbout, approximately 50 feet above the water, the airplane stopped climbing. The engine sounded normal but the aircraft would not accelerate. The pilot stated that he stalled the aircraft on…NTSB ANC87LA085Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKThe pilot stated that he lost directional control of the aircraft during the takeoff causing the plane to groundloop.NTSB NYC87LA194Accident · Serious injuriesLimited investigationFinal reportChampion 7GCB · Sullivan, NHThe pilot of the float equipped citabria 7GCBC experienced a power loss when he added power and raised his nose for a cruise climb from 3500 ft. he set up for a forced landing in a pond. As he neared touchdown, the engine regained power and responded to the…NTSB NYC87LA193Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Sandy Creek, NYThe pilot of the PA-23-250 attempted a takeoff on a 2200 ft long private airstrip with a grass runway. Witnesses reported the aircraft was airborne further down the runway than normal. The aircraft did not clear the trees on the departure end of the runway.…NTSB MIA87LA193Accident · No injuriesLimited investigationFinal reportStinson 108-1 · West Palm Beach, FLWhile on an instructional flt during the landing roll the acft began to drift to the right. The student plt corrected the drift with left rudder, however he then added full power. The acft then ground looped to the left, during which the right main gear…NTSB MIA87IA192Incident · No injuriesIncident investigationFinal reportCessna 310J · Sarasota, FLDuring the landing roll the rt main landing gear collapsed after which the acft slid off the rwy, collided with a taxiway light & came to rest. Insp of the rt main landing gear revealed that the downlock spring failed which prevented the gear from fully…NTSB LAX87LA254Accident · No injuriesLimited investigationFinal reportBeech C90 · Lakeport, CAThe pilot indicated that the left main gear collapsed during landing rollout. The pilot did not respond to the following questions, when asked during a telephone interview, 'when was the gear placed down? And what did the gear safe indicator lights indicate…NTSB LAX87LA250Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Grand Canyon, AZWhile taxiing for takeoff, the underside of the left wing struck the boom of a backhoe parked adjacent to the aircraft ramp. The unattended backhoe was parked in a dirt area adjacent to the ramp with the boom in the extended position while the operator was on…NTSB DEN87LA161Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cayuga, NDThe plt was completing a swath run and struck a power line with the right wing, severing the wing. The aircraft did a snap roll to the right and impacted in a field.NTSB ATL87LA195Accident · No injuriesLimited investigationFinal reportCessna 172E · Denmark, GAThe acft struck power lines and severed the nose gear during landing. When the nose was lowered to ground on landing roll acft nosed over inverted. Acft was being delivered to mechanics new airstrip for annual inspection. The plt was unaware of power lines…NTSB SEA87LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Bend, ORShortly after takeoff a partial loss of power occurred and the pilot was not able to maintain altitude and airspeed. The pilot was not able to retract the gear due to the low airspeed because the automatic gear extension system was not in the override…NTSB SEA87IA127Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace BAE-146-100 · Las Vegas, NVDuring pushback and while starting the #4 engine the auxiliary power unit which provides electrical power to the engine starter tripped off the line. The loss of electrical power to the engine starter resulted in a hung start at approximately 25% N2 RPM.…NTSB NYC87LA191Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cape May, NJThe Piper J3C-65 made an unsuccessful attempt at a banner pickup and was maneuvering at 400 ft in a climbing left turn for another pickup when a power loss occurred. The pilot made a forced landing in a marsh. The pilot reported the fuel quanity gauge was…NTSB NYC87LA190Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Kralltown, PAThe plt attempted to takeoff from a 2130 ft grass strip on a relatively hot & humid day with an air temp of 85 deg. About 2/3 of the way down the rwy, he rotated the acft to takeoff, but it would not climb sufficiently to clear a hill beyond the arpt boundry.…NTSB NYC87LA143Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Block Island, RIThe plt rprtd that drg takeoff, the eng lost power. Subsequently, the acft crashed into an area of brush on level terrain about 1/2 mi off the departure end of the rwy. The operator rprtd that in a conversation with the plt, the plt indicated that he had…NTSB MKC87LA129Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Bull Shoals, ARThe pilot stated the winds were four to five mph from the sw as he departed and he could see thunderstorms four or five miles to the west. He overflew his destination when he saw large waves on the water. He landed in a smooth-water cove and was taxiing…NTSB MKC87LA128Accident · No injuriesLimited investigationFinal reportLowder Quickie II · Iowa City, IAThe PIC rptd normal takeoff and climb during a LCL flt. Abt 15 min into the flt, the PIC experienced a nose down pitching. Throttle was reduced and level attitude was established. The PIC rptd difficulty maintaining level flt and made a precautionary lndg on…NTSB LAX87LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Auberry, CADuring an approach into a private airstrip, the student pilot touched-down, then decided that there was not enough stopping distance and elected to go-around. On the initial climb-out the aircraft struck an object that made the aircraft yaw right then left.…NTSB LAX87DVM03Accident · No injuriesFinal reportBell 47G-5 · Salinas, CAAt the end of an aerial application operation, enroute to the airport, the engine quit. The pilot autorotated the helicopter onto a soft field, where on touchdown, the helicopter was substantially damaged. Inspection of the helicopter revealed that the fuel…NTSB LAX87DUJ08Accident · Serious injuriesFinal reportTeague Phantom · Casa Grande, AZThe plt was flying the ultralight type acft at low level. As he flew thru a pass between two foothills, the acft struck telephone lines, then collided with terrain. There were no reported mechanical failures or malfunctions.NTSB FTW87DRD06Accident · 1 fatalFinal reportAir Command 532 · St.Francisville, LAWitnesses observed the gyroplane flying at 10-15 feet AGL when it started a turn to the right. It continued the right turn and descended into the ground. Dr. Moore of the FAA sw regional flight surgeon's office stated that the plt had coronary disease and…NTSB DEN87FA162Accident · 4 fatalField investigationFinal reportCessna 421C · Cody, WYThe plt & 3 paxs were returning to dallas, TX from a retreat in Montana. The plt filed an IFR flt plan from white sulphur springs, MT, to casper, WY, but did not activate it after departure. The acft was rprtd overdue by family & a search was initiated. The…NTSB ATL87LA192Accident · No injuriesLimited investigationFinal reportNavion H · New Ellenton, SCPreviously, the acft had been involved in a gear-up lndg & was out of svc while it was being repaired. Drg that time the annual inspn expired. A special airworthiness certificate was obtained to ferry the acft to the sizemore arpt for the annual inspn. Drg…NTSB ATL87DEI07Accident · Serious injuriesFinal reportEipper MX2 · Newbury, OHThe ultralight had not been flown for 8 months. Plt rpted that after takeoff the eng quit. Fuel had not been added since prior oct. Examination of eng revealed cracks in the exhaust system, evidence of overheating and recent scoring of cylinders. Witness…NTSB ANC87FA084Accident · No injuriesField investigationFinal reportCessna 185 · Anchorage, AKThe acft was stalled on short final for landing. It touched down hard on the rwy and directional control was lost. The acft veered off the right side of the rwy and struck two parked acft.NTSB SEA87LA126Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Dallas, ORThe pilot inadvertently landed with a quartering gusting tailwind. On landing rollout the aircraft nosed over inverted.NTSB SEA87FA124Accident · 2 fatalField investigationFinal reportBeech 77 · Spokane, WAOn takeoff the aircraft climbed to 50-75 ft AGL, descended in a landing attitude, touched down on the runway near the departure end and took off again. When approaching high obstructions off the end of the runway, the aircraft entered a steep climb, rolled…NTSB LAX87LA261Accident · No injuriesLimited investigationFinal reportBell H-13 · Mojave, CADuring a pleasure cross country flight, the engine lost power at an alt of aprx 200 ft AGL. The plt entered an autorotative descent onto soft terrain. Upon touchdown, the main rotor blades severred the tail rotor from the boom. Shortly after the accident, the…NTSB LAX87LA253Accident · No injuriesLimited investigationFinal reportBeech C23 · Brownsville, CADuring a cross country flt, the plt over flew the rwy once for a visual wind speed and direction check. During the first approach the acft was too high so the plt went around. On the second approach, during the flare, the acft stayed airborne down most of the…NTSB LAX87LA252Accident · No injuriesLimited investigationFinal reportBeech A35 · Santa Rosa, CAThe plt was participating in a cafe-400 (comparative acft flt efficiency) contest over a 400 mi, round robin course. While dscndg fm 7000' at the end of the flt, the plt slowed the acft to 140 mph to observe traffic. When clear, he increased the speed to 160…