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.

NTSB NYC87DHA01Accident · No injuriesFinal reportPiper PA-28-180 · Lehighton, PAStudent pilot with a certified flight instructor while on the landing roll encountered a crosswind. Directional control was lost the aircraft departed the runway causing substantial damage due coming to final rest in a ditch.Dec 21, 1986 · N54482 · Substantial damageNTSB MKC87FA033Accident · 2 fatalField investigationFinal reportChampion 7ECA · Cambridge, NEThe low time PIC had been flying his acft over the farm land in search of coyotes. Several of the grd crew had flown as psngrs with him during the time period of this search. Witnesses stated that they saw the acft turn left and right as it was spotting the…Dec 21, 1986 · N2674G · Substantial damageNTSB MIA87IA054Incident · Minor injuriesIncident investigationFinal reportBoeing 747-121 · Miami, FLDuring taxi for takeoff the captain of the air carrier became partially incapacitated. The first officer took over and the flight taxied back to the gate. The captain was evacuated to a local hospital where he was treated with glucose for hypoglycemia and…Dec 21, 1986 · N75IPA · No damageNTSB DEN87FA039Accident · 1 fatalField investigationFinal reportCessna 172E · Crossroads, NMThe student plt with no simulated or actual instrument and a total of 9 hours night flt time called the amarillo FAA fss, who briefed him on wx for a flt from borger, Texas, to big spring, Texas, located 210 NM south. He was briefed on marginal VFR wx en…Dec 21, 1986 · N7821U · DestroyedNTSB CHI87DET01Accident · No injuriesFinal reportPitts S1S · Warsaw, INAccording to the pilot after touchdown the right brake seemed to lock up with a 'skidding' noise as the aircraft left the runway. The pilot stated he was having difficulty keeping his toes off the brakes as he was attempting to maintain directional control.…Dec 21, 1986 · N39XP · Substantial damageNTSB SEA87LA038Accident · No injuriesLimited investigationFinal reportCessna 172 · Yamhill, ORThe plt was landing on a one way short narrow airstrip. He stated a gust of wind occurred just prior to touchdown. The aircraft then bounced and the plt added power. The aircraft then bounced several times and the nose gear collapsed. The aircraft then nosed…Dec 20, 1986 · N739LH · Substantial damageNTSB NYC87LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Old Bridge, NJThe plt took off fm the marlboro arpt & flew to 2 other arpts before lndg at the miller arpt at burgettstown, PA, where the eng was shut down. He had difficulty in starting the eng & remained on the gnd about 1 hr. The plt told an aviation safety inspector…Dec 20, 1986 · N6192W · DestroyedNTSB LAX87FA066Accident · 1 fatalField investigationFinal reportMooney M20K · Flagstaff, AZThe pilot encountered clouds and temperatures below freezing during a cross country flight at 17,500 feet above mean sea level. The engine failed shortly after the encounter with the weather. The pilot was unable to restart the engine during the forced…Dec 20, 1986 · N4004H · Substantial damageNTSB FTW87LA036Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Lubbock, TXThe plt stated that after a normal apch, he made a hard landing on the main gear and the acft bounced. He further stated that the second contact was hard on the main gear and that the nose gear collapsed when it touched down the 2nd time. Damage sustained by…Dec 20, 1986 · N8456X · Substantial damageNTSB FTW87LA034Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Arlington, TXA student pilot on solo flight in the local area of Arlington airport (F54) TX. Substantially damaged a Cessna 150 during a hard landing, breaking the nose gear and nosing over inverted. The pilot received minor injuries.Dec 20, 1986 · N714LL · Substantial damageNTSB FTW87LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Cresson, TXAfter about 45 min of flt time, the instructor (CFI) & student plt entered the traffic pattern to practice touch-&-go landings. As they were taking off from the 1st touch-&-go, the eng lost power. Subsequently, they made a forced landing in an open area near…Dec 20, 1986 · N714KY · Substantial damageNTSB FTW87DQA01Accident · 1 fatalFinal reportBeggs Pitts S-1 · El Paso, TXCommercial pilot practicing aerobatics in pitts S1 experimental homebuilt aircraft entered spin. Pilot failed to recover control of aircraft during descent. Aircraft impacted terrain approximately 1/2 mile south of west Texas airport near El Paso, TX.Dec 20, 1986 · N16GB · Substantial damageNTSB DEN87IA032Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Billings, MTN124AV was operating as big sky airlines flt 3857, scheduled service from helena to Billings. The flt proceeded uneventfully until the apch into Billings. The flt crew stated after the incident that when the landing gear was extended, the left main gear…Dec 20, 1986 · N124AV · Minor damageNTSB ATL87LA048Accident · No injuriesLimited investigationFinal reportBeech D-17-S · Louisville, KYFollowing a normal landing on runway 06 at bowman field, the acft nosed over while clearing the rwy. The plt reported applying brakes and recalled feeling the tailwheel lift off the ground. The plt did not report any system malfunction, and the investigation…Dec 20, 1986 · N217SD · Substantial damageNTSB ATL87FA045Accident · 2 fatalField investigationFinal reportCessna 170B · Asheville, NCDuring initial climb from a private grass airstrip, witnesses described the aircraft perform a 'wing-over' aerobatic maneuver at low altitude and impact the ground at a near vertical attitude. A ground fire consumed the wreckage. The pilot held a student…Dec 19, 1986 · N8062A · DestroyedNTSB MIA87LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Hollywood, FLThe plt stated that the acft tilted shortly after liftoff and he elected to abort the takeoff. While on roll out, when the brakes were applied, the acft veered to the left and ran off the rwy colliding with a fence. The plt reported no mechanical difficulties…Dec 18, 1986 · N2279Q · Substantial damageNTSB LAX87FA065Accident · 1 fatalField investigationFinal reportRockwell 112TC · Gardena, CAThe pilot elected to return and land at his home airport when the aircraft's landing gear failed to retract after a night takeoff. After reentering the traffic pattern the pilot changed his fuel selector to the left tank for landing. As the aircraft turned…Dec 18, 1986 · N112DM · Substantial damageNTSB FTW87FA032Accident · 1 fatalField investigationFinal reportCessna 340A · Tomball, TXThe pilot took off in fog and light rain and climbed into clouds at about 300-400 feet above the ground while both landing lights were extended and illuminated. Also the airport's rotating beacon (located aobut a mile from the accident site) was flashing on…Dec 18, 1986 · N8CD · DestroyedNTSB DEN87IA031Incident · No injuriesIncident investigationFinal reportBeech C-99 · Albuquerque, NMMesa airline flt 114 was on a scheduled flt from Albuquerque to clovis, NM. Upon touchdown at clovis, the left landing gear began to collapse and a go-around was successful. The crew elected to return to Albuquerque where emerg equipment could stand by. After…Dec 18, 1986 · N7212P · Minor damageNTSB DCA87IA015Incident · No injuriesIncident investigationFinal reportATR ATR-42 · Detroit, MIDrg arr, the flt was vectored for an ILS rwy 3R apch. At that time, ATIS info indcd mod mixed icing in clds. The capt rprtd the acft entered the cloud tops at 5500', was in the clds aprx 5 min & accumulated abt 1.5' of rime ice. He statedice accumulation was…Dec 18, 1986 · N423MQ · No damageNTSB CHI87LA052Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Middleton, WIAt the completion of a period of instrument training and while returning to the airport of origin the CFI asked the private rated dual student to demonstrate a simulated forced landing to the runway. In an attempt to lose altitude on the final approach the…Dec 18, 1986 · N12841 · Substantial damageNTSB CHI87LA051Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Bloominton, INAccording to the pilot he was cleared for the ILS approach and followed his glideslope and localizer indications in a normal manner. He eventually saw the ground prior to reaching his decision height of approx 200 feet AGL. This sighting of the ground was the…Dec 18, 1986 · N9603B · DestroyedNTSB SEA87LA037Accident · No injuriesLimited investigationFinal reportCessna T310Q · Medford, ORDuring turn off from the runway to the taxiway the left main gear collapsed. The runway and taxiway were icy and wet. Examination of the landing gear indicated an overload failure.Dec 17, 1986 · N7581Q · Substantial damageNTSB MIA87LA050Accident · No injuriesLimited investigationFinal reportCessna 336 · Vero Beach, FLPlt stated the rear engine failed while in cruise flight and while making an emergency landing he approached the runway too fast. The aircraft touched down approximately two thirds of the way down the runway and when it could not be stopped the aircraft was…Dec 17, 1986 · N1SN · Substantial damageNTSB SEA87FA036Accident · No injuriesField investigationFinal reportSwearingen SA227AC · Salt Lake City, UTThe f/o was at the controls for the ILS apch to slc. Fog seeding was in progress, producing variable visibilities. The apch commenced with RVR well above cat I mins. At decision height(dh), the capt called 'lights in site'. The f/o continued the apch descent…Dec 16, 1986 · N164SW · Substantial damageNTSB MIA87LA051Accident · No injuriesLimited investigationFinal reportCessna 150L · Homestead, FLThe plt experienced a slow deceleration of eng RPM followed by a total loss of power. The eng could not be restarted and a forced landing was made. Post accident exam of the eng, eng accessories, and airframe fuel system revealed no evidence to indicate…Dec 16, 1986 · N11842 · Substantial damageNTSB ANC87FA021Accident · Serious injuriesField investigationFinal reportBoeing 727-222 · Anchorage, AKAbout 10 min before arrival, the acft suddenly encountered turbulence which one occupant described as a single tremendous jolt. The mishap occurred while the acft was aprx 39 miles east of Anchorage intl arpt and was descending thru 10,000 ft. the seat belt…Dec 16, 1986 · N7635U · Minor damageNTSB LAX87LA064Accident · No injuriesLimited investigationFinal reportCessna P210N · Chandler, AZWhile the plt was receiving vectors for arrival at Chandler, AZ, the eng lost power. Subsequently, the plt made an emergency landing about 1 mi north of the arpt. He rprtd that he had filled the fuel tanks at Chandler & had flown to durango, co on 12/5/86. On…Dec 15, 1986 · N3605P · Substantial damageNTSB FTW87FA031Accident · 2 fatalField investigationFinal reportCessna 172K · El Reno, OKPrivate pilot of Cessna 172K attempted VFR flight in IFR flight conditions. Contacted okc approach control and requested special VFR approach during hours of darkness. Approach denied special VFR due to lack of instrument qualification of pilot. Pilot was…Dec 15, 1986 · N736XP · DestroyedNTSB DEN87LA030Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Opheim, MTThe plt elected to take off downhill because he said the hill was too steep to try a takeoff uphill even into the wind. He said that just prior to lift off, he hit a snowbank which slowed the acft down. Deeper snow was then contacted and the acft flipped over.Dec 15, 1986 · N78588 · Substantial damageNTSB CHI87LA046Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Lake Village, INThe pilot stated that he gradually lost power while on final approach. He finally stalled the aircraft and pancaked it into the trees before the runway. The pilot also stated that he suspected carburetor ice was involved.Dec 15, 1986 · N3969E · Substantial damageNTSB CHI87FA050Accident · 1 fatalField investigationFinal reportCessna 182P · Durand, ILStudent pilot collided with terrain while attempting to remain in visual contact with the ground during very low light and in very heavy ground fog during a cross country flight. The pilot rushed his departure in an attempt to get home before dark and there…Dec 15, 1986 · N21016 · DestroyedNTSB MKC87LA032Accident · No injuriesLimited investigationFinal reportCessna 172P · Pine Bluff, ARThe pilot stated he had flown over trees from the southeast and descended to 50 ft. upon seeing trees in front of the acft he turned left, away from the trees. The left wing touched the ground followed by the nose gear. The acft then flipped forward to the…Dec 14, 1986 · N75579 · Substantial damageNTSB MIA87LA049Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Gulfport, MSThe acft touched down at a high rate of speed with a left quartering tailwind at the halfway point on the 2700 ft rwy. The acft ran off of the right side of the rwy and the plt regained control getting the acft back onto the rwy. The acft then overran the end…Dec 14, 1986 · N117CL · Substantial damageNTSB DEN87LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, CODuring landing, directional control was not maintained. The acft veered left, the landing gear entered a snowbank, and the acft nosed over.Dec 14, 1986 · N4597L · Substantial damageNTSB CHI87LA049Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mcgrath, MNAfter descending to maintain VFR and accumulating clear ice on both the structure and windscreen, the plt decided to make a precautionary landing. During landing in an open area, the left wing struck two apple trees and the acft became airborne again. After…Dec 14, 1986 · N9198D · Substantial damageNTSB ATL87LA044Accident · No injuriesLimited investigationFinal reportHughes 269C · Bowling Green, KYWhile hovering in a grassy area near the hangar facility, the pilot experienced a complete loss of flight control. The helicopter struck the ground and sustained substantial damage. The helicopter component examination failed to disclose any system…Dec 14, 1986 · N7416F · DestroyedNTSB ANC87LA020Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Willow, AKThe pilot stated that he had good ground visibility but suddenly flew into whiteout conditions losing ground reference. He stated that before realizing what had happened the acft struck the top of the mountian rigde.Dec 14, 1986 · N30814 · Substantial damageNTSB LAX87LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · San Jose, CAA Piper pa 32R-300 landed short of the rwy after a loss of power. The plt reported during the climb that he turned on the heater and the windshield turned black obscuring outside vision. The plt also indicated that there was a 'pungent odor' at the same time.…Dec 13, 1986 · N2209Q · Substantial damageNTSB LAX87DUJ03Accident · Minor injuriesFinal reportSolem KR-2 · Mesa, AZThe pilot said that shortly after takeoff the control stick shuddered and he felt 'back pressure' on the stick. The nose started pitching up so he pushed forward on the stick. He continued pushing the stick forward until it reached the forward stops. Despite…Dec 13, 1986 · N3762S · Substantial damageNTSB MIA87FA048Accident · Serious injuriesField investigationFinal reportCessna 182P · St. Cloud, FLThe private pilot stated that prior to takeoff she did not check the fuel supply, and initiated an IFR flight. About 20 minutes into the flight the engine failed at 5000 ft MSL. During the subsequent forced landing attempt the aircraft struck a fence and a…Dec 12, 1986 · N182LM · Substantial damageNTSB CHI87DEX04Accident · Serious injuriesFinal reportAero Commander 500B · Hagerstown, INThe pilot was on the fourth leg of a night cargo flight cruising at approximately 500' AGL enroute to Mt. Vernon, IL, when the aircraft struck some trees and subsequently collided with the ground. The engines and propellers were both torn down and tested and…Dec 12, 1986 · N116CA · DestroyedNTSB ATL87LA043Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Morganton, NCPlt reptd doing LCL flying for about one hr after dept from pvt grass strip. Made apch and ldg at Morganton-lenoir apt. On touchdown plt reptd bouncing, and being unable to recover before lt main gear collapsed and lt wing dragged. Plt stated that he felt…Dec 12, 1986 · N71966 · Substantial damageNTSB NYC87LA012Accident · 1 fatalLimited investigationFinal reportEnstrom 280C · Newport, RIAircraft descended and collided with water when the pilot attempted to regain visual ground reference when weather deteriorated. No plt acc report was received. Plt time was not reported or available.Dec 11, 1986 · N647H · Substantial damageNTSB MKC87LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Olathe, KSDuring landing airplane ballooned due to wind gust. After touchdown. Airplane veered left and duirng pilot's correction, the left main landing gear leg broke off. Metallurgical evaluation revealed a previous fatigue failure in the fracture surface.Dec 11, 1986 · N26DL · Substantial damageNTSB MKC87FA030Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Grain Valley, MOThe pilot stated, after takeoff the engine sputtered and began losing power during initial climb. According to the pilot, he tried to land on a highway but there were numerous vehicles in transit and he decided to attempt an off-airport landing. On initial…Dec 11, 1986 · N44291 · DestroyedNTSB LAX87LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Hayward, CAA Piper PA-28-235 collided with a dirt bank after a loss of power while on a night VFR pleasure flight. The plt indicated that aprx 3 min after takeoff while cruising at 1,400 ft MSL the engine RPM abruptly decreased to idle. The fuel selector control was…Dec 11, 1986 · N1429H · Substantial damageNTSB CHI87LA044Accident · No injuriesLimited investigationFinal reportCessna T303 · Benton Harbor, MIThe plt was flying to Benton Harbor to get work done on a continuing problem with the right eng throttle. On final apch, the plt did not get a gear down indication and tried to cycle the gear. Not sure that the gear was down, the plt choose to go-around. When…Dec 11, 1986 · N9894T · Substantial damageNTSB CHI87IA047Incident · No injuriesIncident investigationFinal reportFairchild SA226TC · Paducah, KYJust after the beginning of a descent for landing a rudder cable failed completely, rendering the rudder inoperative. The aircraft landed uneventfully. Metallurgical analysis revealed that the cable wore severely until it failed. Following an examination of…Dec 11, 1986 · N323BA · Minor damageNTSB CHI87FA048Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · N. Manitou Isl., MIThe plt had recvd an unfavorable wx brief that included a SIGMET on flt icing. Enroute during flt over a large body of water he experienced power loss and was at too low a altitude to glide to shore. The plt attempted to ld on a island but crashed in a lake.Dec 11, 1986 · N32693 · Substantial damage