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 DEN87LA044Accident · No injuriesLimited investigationFinal reportBeech A36 · Taos, NMThe plt was making a night VFR landing approach to rwy 22 at Taos, new Mexico, when the acft struck some high voltage power transmission lines running perpendicular to the rwy. The plt was able to maintain control of the acft and landed it successfully. The…NTSB BFO87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Pungo, VAThe student made 3 full stop landings alone before the instructor boarded the acft. Another full stop landing was made and during the landing roll the instr noticed that the last half of the grass rwy was wetter than the first half. The instr elected to…NTSB NYC87FA063Accident · 1 fatalField investigationFinal reportMooney M20C · Highgate, VTAccording to the surviving pax, a snowshower was enctrd, so the plt reversed course & diverted to another arpt. Drg a ngt apch to lnd, the pax noted a white light on the left side of the rwy. (A VASI light sys was installed for that rwy.) The plt aborted the…NTSB NYC87FA061Accident · No injuriesField investigationFinal reportPiper PA-32-260 · Westerly, RIThe Piper PA-32-260 was taking off from an uncontrolled airport and making a left downwind departure. A second aircraft, a Piper PA-28-181 was transiting the area 1 mile south of the airport an an altitude of 1500 ft AGL. The PA-28-181 saw the PA-32-260 just…NTSB MKC87LA041Accident · Minor injuriesLimited investigationFinal reportBeech BE-77 · Arkadelphia, ARThe student pilot was landing at the home airport after her solo cross-country flight when the airplane went off the left side of the runway. It rolled across a grassy area and then went into a large water/mudhole. The nose gear collapsed when it impacted the…NTSB MIA87LA077Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Key West, FLThe plt failed to calculate fuel consumption for the intended route of flt prior to takeoff. Aprx 55 minutes into the flt the eng quit due to fuel exhaustion. The acft was then ditched in the gulf of Mexico.NTSB LAX87DJA03Accident · Serious injuriesFinal reportEmroth Emair MA-1B · Naalehu, HIDuring an aerial application flight, the aircraft was observed to make a downwind run when the pilot dumped the load collided with the terrain, become airborne and eventually collided with trees. Witnesses stated that they heard the engine running and that it…NTSB DCA87MA020Accident · 6 fatalClass 1 · MajorFinal reportPiper PA-31-350 · Independence, MOThe two acft, a Beech U-21A and a Piper PA-31-350, collided nearly head on at 7000 ft MSL over Independence, MO. In daylight VMC conditions with a visibility of 20 miles. The U-21 was in level cruise and the PA-31 was climbing eastbound to an undisclosed alt…NTSB CHI87LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Evansville, INNose gear collapsed after student pilot failed to recover from a bounced landing. The student plt was on the second landing (touch and go) of a supervised solo flight. He stated that he thought that the accident could have been avoided if he had been given…NTSB MIA87LA076Accident · Minor injuriesLimited investigationFinal reportPiper J3-C65 · Pembroke Pines, FLThe plt stated that after dropping his banner, he circled back to drop the banner hook so he could land, and as he was circling, the acft stalled, started a spin to the right and struck the ground.NTSB LAX87LA092Accident · No injuriesLimited investigationFinal reportCessna 172M · Oakdale, CADuring a solo instructional flight the student pilot was practicing touch and go landings. Upon take-off on runway 28, the wind was light from 100 degrees. On the first landing the wind had changed to a right cross wind from the north. The pilot compensated…NTSB LAX87FA093Accident · 4 fatalField investigationFinal reportCessna 177RG · S Lake Tahoe, CAAfter departing at night from south lake Tahoe, CA, the plt contacted ARTCC & requested radar flt following. A short time later, he declared an emergency & said he was reversing course with a loss of eng power. Radar & radio contact with the acft were lost as…NTSB ATL87IA062Incident · No injuriesIncident investigationFinal reportDornier DO228 · Cleveland, OHA piece of ice penetrated a pax cabin window immediately forward of the rt engine prop arc and the ice strike plate. The acft mfr subsequently issued a service bulletin recommending the replacement of the standard windows installed forward of the prop arc(s)…NTSB ANC87LA024Accident · No injuriesLimited investigationFinal reportCessna 172 · Chena Hot Sprgs, AKThe pilot stated that after touchdown on the snow covered airstrip he lost directional control of the aircraft causing the plane to groundloop.NTSB LAX87LA099Accident · No injuriesLimited investigationFinal reportHughes 369D · Lemon Cove, CAThe plt rprtd that while at 100 to 150 ft AGL on an apch to land, the eng lost pwr as though it had flamed out. He entered an autorotation, but was unable to reach the helipad. Subsequently, the helicopter landed in trees & was badly dmgd. Drg the…NTSB LAX87LA091Accident · Minor injuriesLimited investigationFinal reportCessna C-152 · Bakersfield, CAA Cessna 152 collided with a dirt bank located approximately 140 ft to the left of the rwy edge while on a night apch. The rwy safety area at the aprt extends 60 ft from the rwy centerline. The PIC indicated that he was unable to activate the low intensity…NTSB LAX87LA089Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Paradise, CAWhile practicing touch and goes, the pilot stated that on his last approach a considerable amount of crabbing to the right was required on final approach to runway 35. Upon touchdown the right wing lifted, the pilot turned the control wheel to the right and…NTSB DEN87FA043Accident · 1 fatalField investigationFinal reportAmerican Aerolights Falcon C · Albuquerque, NMAfter takeoff the plt initiated a steep nose up left climbing turn to approximately 300 ft AGL where the acft stalled. It entered a spin and descended in a nose down attitude until impact with the ground. The acft was destroyed and the student plt was fatally…NTSB CHI87DEP01Accident · Minor injuriesFinal reportChampion 7ECA · La Crosse, WIAfter the third try at an engine start the eng started and ran at full throttle. The plt could not reduce RPM. To avoid striking two parked acft the plt struck a hangar. Post accident investigation revealed that the throttle cable was not operating properly.…NTSB NYC87LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Randolph, NHStudent pilot on a cross country instructional flight became disoriented, decided to return to departure airport. However seeing that he was running low on fuel looked for an airport to land to refuel and find out his location. He decided to make a…NTSB NYC87DHD04Accident · 1 fatalFinal reportMarrone VM-1 · Jobstown, NJThe plt was observed to make a low pass over the arpt, then cont beyond the departure end where the acft flew into a row of trees. Witnesses rprtd the sun was low & that the plt was flying toward the sun. Impact with the trees occurred about 1200 ft from the…NTSB MKC87LA040Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Corning, IAThe flt had progressed normally from champagne, IL. The IFR flt plan was cancelled at lamoni VOR and the flt proceeded VFR. On final approach to rwy 17, aprx 1 mile from the rwy, the altimeter suddenly unwound and the acft struck trees. The altimeter had…NTSB MIA87LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Ft.Lauderdale, FLThe plt repositioned the fuel selector from the left tip tank to the right main tank when the flt entered the traffic pattern. The eng then quit & a forced landing was made in an open field. Upon touchdown the left & right main landing gear were pushed…NTSB LAX87LA090Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Yucca Valley, CAThe pilot reported that during the takeoff roll, a wind gust caused the left wing to raise and the airplane veered to the right. He immediately applied left aileron and rudder, but to no avail. The airplane went off the runway, hit a tree and fence, and…NTSB LAX87FA088Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Oceano, CAShortly after takeoff, the surviving pax (s/p) noticed the acft began losing alt. She heard the plt comment about a 'clicking noise in the left wing' which she also heard & said sounded like metal clicking together. Ground witnesses noticed a change in eng…NTSB BFO87LA015Accident · No injuriesLimited investigationFinal reportRockwell 500S · Lynchburg, VAAfter leaving clouds about 4500 feet MSL, the PIC made a visual approach to runway 03 at Lynchburg municipal. On short final the copilot stated that he noticed what seemed to be a gradual increase in pitch attitude while the aircraft was still too high off…NTSB NYC87LA059Accident · No injuriesLimited investigationFinal reportCessna 150 · Montgomery, NYDuring an instructional flight to orange county airport, a simulated engine out was performed while on approach for landing. Directional control was lost and the flight landed west of runway 3 in snow causing substantial damage.NTSB MIA87FA074Accident · 2 fatalField investigationFinal reportCessna 150L · Naranjito, PRThe pilot and passenger were reported to be on a personal flight during their lunch hour. They departed from isla grande airport and proceeded to a dirt airstrip at Naranjito, PR. At Naranjito, witnesses saw the airplane go into a low pass over the dirt…NTSB LAX87FA096Accident · 2 fatalField investigationFinal reportMorrisey 2150A · Mt. Baldy, CADuring a local flt, the airplane was seen circling over a ridge four times. On the fifth pass, the airplane disappeared northbound into the clouds. A witness reported that at the time the mt tops were covered with fog and that blizzard conditions existed.…NTSB LAX87FA087Accident · 1 fatalField investigationFinal reportCessna 208 · Cima, CAWhile on a day/vfr flt from ontario, CA to las vegas, NV, the acft collided with mountainous terrain near the top of a 6500' peak. Radar data showed that aprx 20 min before the acdnt, the acft began a gradual dscnt from about 10,000'. No preimpact part…NTSB SEA87LA047Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Deer Park, WAThe plt reported the acft veered to the left during roll out on the snow covered runway. The acft contacted a frozen snow bank and flipped inverted.NTSB FTW87FA045Accident · No injuriesField investigationFinal reportBeech 65-80 · Brownsville, TXCommercial pilot departed Brownsville, TX (bro) on special VFR flight plan. During initial climb, at approximately 300 ft AGL both engines quit due to fuel starvation. Forced landing was made to unimproved field. Aircraft sustained substantial damage. Pilot…NTSB DCA87MA018Accident · 10 fatalClass 1 · MajorFinal reportSwearingen SA-226TC · Kearns, UTThe two acft, a Swearingen SA-226TC and a Mooney M-20, collided in flt at aprx 7000 ft MSL in the salt lake city arpt (slc) radar service area over Kearns, UT. The SA-226 was approaching slc for lndg and the M-20 was conducting a local trng flt when the…NTSB ATL87LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Albany, GAPlt deptd bowling green with a listed 5.0 hrs fuel on bd. After 3 hr 35 min he arrived over dest after exhausting fuel in the rt tank abt 30 min prior. He stated that the other tank was abt 1/2 full at the time. 15 min after rt tank exhaustion the plt req his…NTSB LAX87FA085Accident · 4 fatalField investigationFinal reportBeech F33A · Sacramento, CAThe winds at the airport had been reported as strong and gusting. After his passengers arrived, the pilot requested and received taxi instructions to the active runway which was aprx 3700 ft from his parking space. About 2-1/2 mins after receiving his taxi…NTSB ATL87LA060Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Stockbridge, GADuring an attempted landing, the pilot lost directional control and veered off the right side of runway 29 and collided with a tree. The pilot reported that a gust of wind from the left resulted in the left wing rising about 7 feet. The pilot applied power…NTSB ANC87FA023Accident · 1 fatalField investigationFinal reportCessna 207A · Kenai, AKWx conds on the day of the acdnt were rprtd to be extremely variable. Initially, when the plt obtained a wx briefing, VFR flt was not rcmdd. Later, the wx improved & the plt elected to proceed on the flt. While en route, he enctrd snow showers & dscndd to…NTSB NYC87LA058Accident · Minor injuriesLimited investigationFinal reportAgusta A109AII · So. Dartmouth, MAAgusta N300CC departed a helipad in front of claremont corp president's residence in south Dartmouth, Massachusetts. As the helicopter was hovering prior to moving forward, the tail rotor blade, s/n 124, failed. The tail rotor assembly and gearbox separated…NTSB MIA87LA073Accident · No injuriesLimited investigationFinal reportCessna 310J · Straights Of Fl, FLThe plt stated that the flt departed grand caymen, on January 12, 1987, at aprx 1600 EST. Aprx 3 hrs into the flt the c.h.t & exhaust temperatures hit red line on the left eng following a loss of oil pressure. He secured the eng & then noticed fuel being…NTSB MIA87LA072Accident · No injuriesLimited investigationFinal reportCessna 150L · Bunnell, FLThe plt stated that he was forced to land in a field due to a drop in eng RPM, & the inability to maintain alt. On touchdown, the acft collided with trees, after which the nose gear collapsed, the acft nosed over, & came to rest inverted. Investigation…NTSB MIA87LA071Accident · No injuriesLimited investigationFinal reportCessna 182 · Ft.Lauderdale, FLThe acft collided with a powerline, trees & a truck after sustaining a complete power loss right after take-off. The acft was being ferried to be sold & had not flown for about two months. During the pre-flt inspection, the plt stated that he drained a…NTSB LAX87FA084Accident · 1 fatalField investigationFinal reportCessna T210M · Pacoima, CADuring initial climb after takeoff the aircraft experienced a complete loss of power. The pilot attempted to return to the airport and collided with a large warehouse. The airframe was totally consumed in the post crash fire. Examination of the engine…NTSB CHI87IA061Incident · No injuriesIncident investigationFinal reportNihon YS-11A-500 · Remmington, INThe flight crew failed to adhere to appropriate procedures and directives when they failed to select the HP cock levers to the hswl (lock out) position while performing an approach to landing stall during a training/test flight. When stall recovery was…NTSB BFO87LA014Accident · No injuriesLimited investigationFinal reportCessna 150L · Ellicott City, MDApproximately 30 minutes after the pilot departed hayes field, columbia, Maryland, the pilot elected to return to the field. After entering downwind the engine ceased to continue producing power and the pilot was forced to make an emergency landing. During…NTSB ATL87LA059Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe student plt was unable to recall anything about the acdt. A plt/a&p observing the t.o. stated that the acft lifted off and climbed to 50-60 ft. when a flock of black birds flew up into the path of the acft. The acft pitchedup, yawed slightly, turned about…NTSB SEA87LA045Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Eatonville, WAThe student plt was on approach to home field after a x-c flight. During final, the pilot elected to go-around due to gusty winds and a downdraft. The acft stalled into trees along side the runway. Investigation revealed the flaps were set at 40 degrees and…NTSB LAX87LA083Accident · No injuriesLimited investigationFinal reportCessna 172K · Lanai, HIThe Cessna 172K nosed over in strong winds while taxiing for departure on rwy 3. The plt indicated that he was 'back taxiing' on rwy 3 when the wind 'got under wing, then under tail, and plane turned upside down.' The plt also indicated that the winds were…NTSB LAX87LA082Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Spring Valley, CAA Mooney M20C collided with an automobile during landing roll after landing on a road. The plt indicated that while cruising at 3,500 ft MSL he noticed the eng oil pressure fall to zero. The constant speed propellor simultaneously went to low pitch, followed…NTSB SEA87LA046Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Bremerton, WAPlt with less than 2 hrs as PIC in Bellanca 7KCAB acft stalled on approach to runway. Plt reported winds estimated at 10 KTS with gusts to 15 KTS. Acft stalled about 30 feet above runway and impacted on the nose at about 30 degree angle.NTSB LAX87LA081Accident · No injuriesLimited investigationFinal reportCessna T182 · Big Bear City, CAThe plt rprtd that when the nose wheel touched down during the landing, a severe vibration began & the acft veered to the left. She said she pulled the yoke aft, but this had no response. Also, she said she applied brakes, but could not stop the acft or make…