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 ATL84LA264Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Greenville, NCThe plt made a steep turn after completing a low pass and spraying a field. Plt stated that while in the turn the acft encountered wind gust that rolled the acft inverted. The acft stalled. The plt was able to roll out of inverted before ground collision.NTSB SEA84FA204Accident · 2 fatalField investigationFinal reportVaughn MA-5 Charger · Buxton, ORWitnesses reported seeing the acft engaged in aerobatic flight described as 'like a spray plane conducting spray operations.' The acft collided with relatively level terrain during one of these maneuvers. No airframe or powerplant failures/malfunctions were…NTSB NYC84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Caldwell, NJThe acft hit the surface of the water during a low pass which was described by a witness as 10-30 ft AGL & done in a series of passes with 'wings wobbling' until the pass that damaged the gear & wing causing the plt & acft to depart the area. Upon returning…NTSB MKC84LA259Accident · No injuriesLimited investigationFinal reportBeech A36 · Carlisle, ARThe acft landing gear collapsed during landing. After electrical failure the plt had cranked the gear down in flt. Inspection revealed that a nut on the alternator ground wire had come off. The landing gear manual extension system had no deficiencies.NTSB MIA84FA234Accident · Serious injuriesField investigationFinal reportPiper PA-46-310P · Vero Beach, FLOn post-production test flt, plt noted symptoms of uncommanded lean mixture and turned to return for landing. En route to airport, eng lost pwr completely. On base leg for forced landing (off airport) fire broke out in eng area and burned through hydraulic…NTSB FTW84FA354Accident · 2 fatalField investigationFinal reportCessna 180J · Lafitte, LAWitnesses observed the acft approach an oil production platform located in a marshy area near the destination airstrip. They reported that the acft made an abrupt, steep left turn at 200 to 300 ft AGL, followed by what they described as an accelerated stall.…NTSB ATL84LA263Accident · 1 fatalLimited investigationFinal reportRotorway Scorpion 133 · West Hamlin, WVAcft was observed proceeding over open field used as air strip in level flt, aprx 130 ft AGL, at 50 KTS. At end of field acft began left turn, nose dropped to steep descent attitude which continued to ground impact. Post-mortem showed triple-bypass surgery…NTSB ANC84LA142Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandalar, AKDuring flt at about 4500 ft MSL, the eng began a severe knocking, then a cylinder separated from the eng & oil completely covered the windshield. The plt tried to make an emergency landing beside the Chandalar river. However, the acft came to rest in the…NTSB SEA84LA206Accident · No injuriesLimited investigationFinal reportDonald E. Bradshaw Starduster TOO · Whidbey Island, WAWitnesses stated the acft was engaged in aerobatics before it contacted the water and was destroyed.NTSB SEA84LA205Accident · No injuriesLimited investigationFinal reportCessna 305A · Las Vegas, NVAccording to witnesses the left wing of the acft contacted the ground during the landing, followed by the nose. Acft came to rest on the nose and left wing after ground looping.NTSB NYC84LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellicottville, NYThe plt started taking off from an unimproved, grass covered fld, but the acft would not accelerate above 50 KTS. He aborted the takeoff, but the acft continued off the end of the rwy where the nose gear was torn off & the left main gear & right wing tip were…NTSB NYC84LA284Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Fishers Island, NYThe certified flt instructor (CFI) stated that he was teaching his student autorotation's to touchdown. He continued to state that his student applied too much left pedal just prior to touchdown. This caused the helicopter to yaw to the left. The CFI stated…NTSB NYC84LA283Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-E · Charlestown, RIWhile on final approach, the left main gear contacted some brush and becoming entangled in vines followed by the propeller becoming entangled. The propeller stopped and the aircraft swung around 180 degrees coming to rest about 500 ft from the grass runway.NTSB NYC84LA282Accident · No injuriesLimited investigationFinal reportCessna 150M · Claremont, NHAfter a dual instructional flt, practicing landings, the student tookoff on a solo flt. He made 2 takeoffs & landings without incident. On his 3rd takeoff, the acft began drifting to the left. The student said he applied right rudder to correct the situation,…NTSB MKC84LA257Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Flippin, ARThe acft ran off the departure end of the rwy during landing and collapsed the landing gear. The acft landed between 1/3AND 1/2 way down the rwy. The acft had been in rain showers and the rwy was wet. The plt applied brakes but braking was ineffective and the…NTSB LAX84LA445Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · San Joaquin, CAThe Air Tractor was on takeoff initial climb and was about 20 ft high when the engine began to backfire. The aircraft settled into the cotton field and rotated about 90 degrees after ground contact. The plt reported that the number one cylinder was found to…NTSB FTW84LA357Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Worth, TXDue to acft parked in close proximity to the right side of the narrow (25 ft) runway and a crosswind from the left, the plt favored the left side of the runway on landing line-up. During the landing roll, he was unable to arrest a left drift before the acft…NTSB FTW84LA352Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Mineral Wells, TXThe glider was destroyed during ground contact after stalling at aprx 250 ft AGL. The plt reported that conflicting traffic resulted in an acceleration of the tow truck and a premature release of the towed acft. After the release the ascending acft stalled…NTSB DEN84LA257Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Cheyenne, WYFollowing an uneventful solo flight the student plt began to follow a parking vehicle to a parking spot. The spot that the parking vehicle driver selected necessitated that the acft execute a 180 deg turn just priop to stopping. During this turn the right…NTSB CHI84LU009Accident · Serious injuriesFinal reportQuicksilver MX · Aurora, ILThe plt was practicing power-off, simulated forced landing patters over farm fields. During a turn at aprx 200 ft AGL, the ultralight decelerated to a very slow speed & subsequently stalled. The plt was unable to recover from the stall before the ultralight…NTSB CHI84LA353Accident · No injuriesLimited investigationFinal reportCessna 172N · Magnolia, OHThe pilot attempted to land with a 10 knot left quartering tailwind. The pilot stated that she could not get the acft to settle on the runway during the landing. The acft went into the brush at the end of the runway and nosed over. The pilot stated that a…NTSB CHI84FA352Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Put In Bay, OHThe pilot attempted a go-around when he saw an aircraft still on the runway. Witnesses saw the aircraft approach the runway and just before touchdown, make a sharp rt turn to go-around. The aircraft made a sharp right turn, describedas the wings being 90…NTSB SEA84LA203Accident · Minor injuriesLimited investigationFinal reportWhitman W - 8 · Las Vegas, NVShortly after takeoff, plt switched from front to rear fuel tank at which time a ttl loss of pwr occurred. Remedial action was attempted but no pwr was regained. Unable to return to the arpt, plt applied full flaps and stalled the acft aprx 15 ft AGL over the…NTSB SEA84LA202Accident · No injuriesLimited investigationFinal reportCessna 210N II · Elko, NVFuel exhaustion occurred on final approach to destination airport. The nose landing gear contacted the top of the chain link airport perimeter fence breaking a connector and allowing the nose gear to retract. The main gear were not damaged. On landing roll…NTSB SEA84FA201Accident · 3 fatalField investigationFinal reportCessna 182E · Prineville, ORThe acft hit a tree during a forced landing approach to a large open field after an engine failure. Post accident investigatiion revealed that a rod cap bolt had failed which started the internal destruction of the engine. This bolt was installed as a new…NTSB NYC84LA281Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · White Marsh, MDThe acft was descended for aprx 7 miles at low power & slow rate for the landing at White Marsh arpt. The descent started at 2800 ft & continued straight in to rwy 27. At about 200 yds from the rwy & at 200 ft AGL the plt decided he needed power to land…NTSB LAX84LA446Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Coalinga, CAThe acft struck power lines about 50 ft AGL while on a x-country. The plt made a successful landing after the collision at an arpt about 30 miles away. The plt said the accident could have been prevented by not flying so low.NTSB LAX84LA443Accident · No injuriesLimited investigationFinal reportCessna 150G · Palo Alto, CADuring flt, the eng began losing power, then stopped running. The plt found a dry lake bed that had been plowed & elected to land there. When he landed, the acft nosed over. An exam of the eng revealed that the #2 connecting rod had failed. Due to the severe…NTSB LAX84LA442Accident · No injuriesLimited investigationFinal reportCessna 172N · Auburn, CAThe acft made a forced landing on an abandoned airstrip after the engine quit during a x-country. The solo student plt said he encountered head winds and lower than expected ground speeds even with increased power. He said that the fuel gages indicated 1/8…NTSB LAX84LA441Accident · No injuriesLimited investigationFinal reportBell P-63C-5-BE · Madera, CAThe plts of a Bell P-63 (king cobra), N62822 & a north American P-51 (mustang), N65206, were participating in an air- show when the acft collided during landing. An investigation revealed the P-63 plt had made a 360 overhead pattern before landing. At about…NTSB LAX84LA440Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Watsonville, CAThe acft collided with a utility pole and was forced to land. The plt reported that on his last spray run in trying to do a better job than anyone else, he came to close to the pole. His rotor made contact with the pole. During the forced landing the landing…NTSB FTW84LU008Accident · Serious injuriesFinal reportMattison MAC MU-200 · Orange, TXAccording to law enforcement officers, who responded to the scene, the plt of the ultralight vehicle was attempting to land in a field when he encountered a x-wind & initiated a go-around. During the go-around, the vehicle struck a 30 ft tree while in a left…NTSB FTW84LA360Accident · No injuriesLimited investigationFinal reportCessna 310Q · Amarillo, TXDuring gear retraction on post-maintenance check flight initial climb, gear unlocked light remained on and gear extend/retract motor circuit breaker popped. Plt reset cb and heard a 'loud pop' from the nose section of the acft. Plt then extended gear but nose…NTSB FTW84LA359Accident · Serious injuriesLimited investigationFinal reportMaule M6-235 · Corpus Christi, TXOn a heading of 165 deg at 3,500 ft the plt saw another acft at the same altitude on a collision course. Evasive action was taken by pushing the nose over forcing both occupants into the cabin overhead. According to the plt, both seatbelts and shoulder…NTSB DEN84LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Durango, COThe acft collided with a rwy light during takeoff. The plt said the acft got to about 6 ft AGL for about 100 ft and whenthe plt pushed foward on the control column the acft settled back on the rwy. During the roll the horizontal stabilizer hit a rwy light.…NTSB CHI84LA357Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Rice, MNPilot stated that during the takeoff roll the acft suddenly began to pull to the left. The pilot reduced power and applied right brake and rudder to correct but the left wing struck corn stalks. Examination of the acft after the accident revealed the left…NTSB CHI84LA356Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Palmyra, WIPlt entered landing pattern after maintenance ferry flt, checked lighted wind indicator & evaluated wind as calm. Plt executed tight, close-in base due to electric billboard drag factor & noted strong wind blowing acft away from runway. Acft began to lose…NTSB ATL84LA261Accident · No injuriesLimited investigationFinal reportCessna A188B · Kingstree, SCThe acft ran into high vegatation during a precautionary landing after the plt heard a vibration which began aprx 2 hrs after the initial takeoff. The vibration was caused by a loose wing fairing. Examination of the acft revealed that a screw stripped out of…NTSB ATL84LA260Accident · No injuriesLimited investigationFinal reportBeech J35 · Chesapeake, VAThe acft had not been flown for about 5 yrs. The plt, who was a mechanic, performed an eng ground run & the eng stopped after he noted a fuel flow problem. He examined the eng & found that the fuel injectors were clogged with corrosion. They were cleaned, &…NTSB ATL84IA262Incident · No injuriesIncident investigationFinal reportCessna 150H · Gastonia, NCPlt reached charlotte, NC, and discovered he could not transmit on the acft radio. Plt diverted to gasotnia, NC, but could not locate the arpt because of lowering visibility. Plt flew around for a few minutes looking for identifiable landmarks. Precautionary…NTSB ANC84FA141Accident · 4 fatalField investigationFinal reportCessna 172P · Fortress Creek, AKFlight was conducted to locate wild game. Acft collided with mountain at 4250 ft level. Acft impacted in a near verticalattitude. Examination of acft disclosed no evidence of malfunction.NTSB ANC84FA140Accident · No injuriesField investigationFinal reportCessna 180 · Anchorage, AKThe plt stated that he was taking off to the southeast & the acft was on the step when a x-wind hit, lifting the right wing. He said the left wing then hit the water, spinning the acft to the left & the nose hit the water. The acft went over on its back &…NTSB SEA84LA207Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel AIR B9-4000 · Vancouver, WAThe pilot stated after the accident that he applied too much brake during the landing roll. The aircraft nosed over.NTSB NYC84LA286Accident · No injuriesLimited investigationFinal reportCessna 172 · Islip, NYCommunications with twr indicate plt intended to touch down as close to the end of the runway as possible. Acft touched down 20 yds short of hard surface in gravel. Rwy NOTAM stated 18 in depression at threshhold edge.NTSB NYC84LA285Accident · No injuriesLimited investigationFinal reportNavion Navion · Brodheadsville, PAShortly after takeoff pilot was advised of model aircraft in flight path, evasive action taken, however, presence of model not confirmed. Pilot reduced pwr below recommeded RPM causing aircraft to settle. Pilot then applied pwr to avoid collision with trees.…NTSB NYC84LA279Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Nantucket, MAPlt entered the pattern for landing and was advised of a cross-wind situation. Plt was unfamiliar with the airport and requested a full pattern circuit to observe conditions. On lndg flare with full flaps and left cross-wind correction input, a gust carried…NTSB MKC84FA256Accident · 2 fatalField investigationFinal reportCessna 170B · Oskaloosa, IASeveral witnesses viewed the acft circling over a bean field at an alt of 200 to 300 ft AGL. The plt and pax were reportedly looking for a radio-controlled airplane lost in the field. Witnesses continued to state an increase of power occurred and the acft…NTSB MKC84FA254Accident · 1 fatalField investigationFinal reportCessna A188B · Algona, IAN9387G was flying at an altitude of aprx 75 feet AGL when it struck power lines while maneuvering to spray a corn field. The reported weather near the accident site was: visibility 7 miles, temperature 73 degrees, light precipitation in the way of rain was…NTSB MIA84LA232Accident · No injuriesLimited investigationFinal reportBrown KR-2 · Naples, FLWhile on the first flt of the acft a hard landing was made and directional control was lost. The acft traveled off the left side of the rwy. Substantial damage was sustained during the hard landing.NTSB LAX84FA444Accident · Serious injuriesField investigationFinal reportCessna T210N · Cone, AZThe acft made a forced lndg after a loss of power during in flt cruise at 9500 ft MSL. The plt squawked 'indent' following radio contact with artc during a 'may day' call. Later, the transponder was used for 'emer 7700' squawking. The plt spotted a road he…