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 LAX84LA431Accident · Minor injuriesLimited investigationFinal reportGlasflugel H 301 B Libelle · Carefree, AZThe acft veered off the rwy during takeoff and collided with a parked unoccupied Beech 35. According to the glider plt, the aero tow began normally. After about 50 ft of ground run his wing runner let go. The wings remained level for about another 50 ft then…NTSB FTW84LA348Accident · No injuriesLimited investigationFinal reportCessna 152 · Del Rio, TXJust after liftoff from the fourth touch-and-go landing, the plt heard and felt an impact. Continuing climbout, he observed a deer carcass on the runway. A subsequent uneventful full stop lndg was made but substantial damage had been incurred in the left main…NTSB DEN84LQA02Accident · No injuriesFinal reportLighthizer, Richard E. Lighthizer Special · Gallup, NMThe pilot/builder of this ultra-light had flown from oshkosh, WI to Gallup, NM without incident. During his attempted take-off from Gallup he allowed the acft to veer off the rwy to the left. After the acft rolled into the grasshe regained directional control…NTSB DEN84LA256Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Kennebec, SDThe plt stated that shortly after takeoff when the aircraft was 25 feet in the air a downdraft was encountered near a small hill at the end of the runway. The descent caused by the downdraft could not be arrested and the aircraft collided with the ground. The…NTSB DEN84LA255Accident · No injuriesLimited investigationFinal reportCessna 188A · Jamestown, NDPlt stated, 'landing at dusk into sun. Landed into hill. Hard landing knocking feet (right) off rudder. Airplane groundlooped to left, hit ditch and flipped on its top.' Plt also stated fatigue from flying 4 hours on the day of the accident was a contributing…NTSB CHI84LA334Accident · No injuriesLimited investigationFinal reportCessna 180 · Chesapeake, OHThe acft was forced to land off arpt after the engine quit. The plt normally refueled after landing and forgot that he did not on this occasion. The fuel gages were misread during pre-flt. The acft ran out of fuel after about 1 hour flt time.NTSB BFO84FA003Accident · 2 fatalField investigationFinal reportPiper L-21-A · Selbyville, DEAt the conclusion of towing banners with no pax on board, the acft was landed and topped off with fuel. The plt then reentered the acft and an additional employee got in the rear seat with the intension of flying to a nearby airport for a plt exchange. During…NTSB ATL84LA257Accident · No injuriesLimited investigationFinal reportCessna 177RG · Shelbyville, TNThe acft collided with a parked truck on a taxiway en route to takeoff. The plt said he observed the parked truck on thetaxiway. There was another taxiway available but the plt continued on the congested one with the acft wing overlapping the truck by about 7…NTSB ATL84LA249Accident · No injuriesLimited investigationFinal reportCessna 150J · Leesville, SCThe pilot stated that while attempting to takeoff from a 1600 ft strip he was, 'unhappy with the thakeoff roll'. An aborted takeoff was initiated and when brakes were applied hard the nose gear collapsed and the aircraft nosed over.NTSB ATL84FA248Accident · 4 fatalField investigationFinal reportCessna 421C · Kennesaw, GAAccording to witnesses, the acft entered clouds at low alt during the initial climb after takeoff. They reported that the acft then turned sharply back toward the arpt & descended below the clouds. It rolled out in the direction of the crash site with the…NTSB ATL84FA247Accident · Serious injuriesField investigationFinal reportCessna 172H · Ellijay, GAThe student pilot and passenger were on unauthorized flight in the local area at 0145 when the accident occured. According to the student pilot he had returned from a local flt, picked up a pax, departed again and had flown for 30 to 45 mins before returning…NTSB MKC84LA242Accident · No injuriesLimited investigationFinal reportAyres S2R · Rohwer, ARThe plt was unable to maintain alt after the engine failed. A forced landing was made in a field covered with 4 to 6 ft tall weeds. The acft traveled sideways during the landing. After the accident, the plt observed a broken rod which had penetrated the…NTSB MIA84LA221Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Bainbridge, GAThe acft was destroyed by fire after it crashed into a wooded area just beyond the runway after taking off on a crop control flt. The plt stated that after takeoff he saw smoke and flames coming from under the cowling. The acft would not maintain alt and…NTSB MIA84LA220Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Pelham, GAThe acft landed short of the rwy during a forced landing after the engine quit on final approach. The plt reported that he had experienced trouble keeping the engine running at low power settings.NTSB MIA84IA222Incident · No injuriesIncident investigationFinal reportMooney M20F · Kissimmee, FLAccording to the plt, the acft encountered a gust of wind during the landing roll & became airborne, then touched down again. Subsequently, the acft overran the end of the rwy & was damaged. The plt reported that there was a thunderstorm approaching the…NTSB DEN84LA254Accident · No injuriesLimited investigationFinal reportCessna R172K · Los Alamos, NMThe pilot stated that he attempted a landing on rwy 27. The wind was reported to be from 090 degrees at 8 KTS. The plt stated that he touched down on the rwy and the acft skipped to the left. He applied power to go-around but determined that the airspeed was…NTSB DEN84LA252Accident · No injuriesLimited investigationFinal reportCessna 188 · Holyoke, COThe pilot lost directional control after landing with a rear right quartering crosswind reported at 5 KTS. Use of opposite rudder and braking was ineffective in regaining directional control. The pilot reported no response from the left brake and stated…NTSB CHI84LA340Accident · No injuriesLimited investigationFinal reportHiller 12E · Big Lake, MNThe acft lost power during takeoff and rolled over during a forced landing. The pilot said the engine 'sucked up accumulated water into the gas line.' He later said water was found in the refueling truck. His recommendation: 'keep water out of gas.'NTSB ANC84FA131Accident · No injuriesField investigationFinal reportPiper PA-22 · Delta Junction, AKThe acft was damaged in an off arpt landing after the engine lost power. The plt stated the acft was operating on automotive fuel without the required supplemental type certificate. The acft was operating without the required annual inspection and the tbo had…NTSB SEA84LA191Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Elk City, IDThe plt stated that while landing on the uphill curved airstrip a 30 knot tailwind gust occurred. Due to obstacled and the wind, the plt disregarded an aborted landing and continued straight ahead on the runway. The acft traveled off the departure end of the…NTSB NYC84LA266Accident · No injuriesLimited investigationFinal reportBeech B55 · Trenton, NJDuring landing roll, as the acft slowed to about 40 mph and the plt was transitioning to taxi mode, the landing gear collapsed. No mechanical fault or failure was reported. Witnesses observed the gear to be down during the approach.NTSB NYC84LA263Accident · No injuriesLimited investigationFinal reportCessna 150 · Hanover, NJApch was high but plt continued apch with power at idle and full flaps. Plt misjudged rwy length and touched down 1/2 way down the rwy. To avoid hitting trees at end of rwy, plt aborted the landing. Plt stated that with the slow airspeed and full flaps the…NTSB FTW84LA341Accident · No injuriesLimited investigationFinal reportMooney M20 · Thibodaux, LAAt 0729 CDT the plt filed a flight plan and obtained a wx brief forecasting moist unstable air with several scattered and broken cloud layers beginning at 1,500 ft. the briefer further advised the plt of thunderstorm activity at various locations along the…NTSB FTW84LA340Accident · No injuriesLimited investigationFinal reportCessna 150F · Walters, OKPlt took the acft without authorization and attempted a landing in an open field near his passenger's home. The terrain was soft and unsuitable for acft operations, acft right wing contacted the ground during lndg roll, damaging the wing attach point. Plt…NTSB DEN84FA251Accident · 2 fatalField investigationFinal reportCessna R172E · Farmington, NMAfter being airborne 1 hour and 10 minutes the traffic surviellance flt was cancelled. The plt transmitted to the policeunits on the ground that he would 'buzz' them as he left the area. During this pass the acft struck a high voltage transmission line 88.9…NTSB CHI84LA339Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Washington Is., WIThe acft stalled and crashed after the engine lost power at about 50 ft AGL during takeoff. The acft caught fire after touchdown. The fire consumed the cockpit and cabin. An examination of wreckage showed the fuel selector on the left tank. The left tank had…NTSB CHI84LA335Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lebanon, OHPlt attempted takeoff on 1100 ft of remaining rwy with a 5 kt tailwind. Acft became airborne but was unable to clear power lines located 1000 ft beyond the departure end of the rwy. Density alt at time of accident was calculated to be 3600 ft. with these…NTSB ATL84LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, NCThe instructor pilot retarted the throttle to simulate an engine failure on daownwind at 800 ft AGL after his student had completed a touch and go landing. The CFI then turned to land in the direction opposite the last takeoff, but was unable to achieve…NTSB ATL84IA246Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-30 · Nashville, TNDuring the climb-out, a 15% decrease in the right eng epr was noted by the flt crew. This was followed by a loud bang & failure of the #2 eng. The #2 eng was shut down & the acft was flown back to the departure arpt. An initial exam revealed that the right…NTSB ANC84LA129Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hope, AKThe acft collided with a ditch alongside a short strip used by hunters and fishermen. During interviews with the plt it was revealed that the acft was overloaded and out of CG. During the takeoff the plt decided to abort after passing his decision point but…NTSB SEA85FA065Accident · 2 fatalField investigationFinal reportCessna 177A · Ely, NVThe acft collided with rising terrain during a night x-country. No flt plan was filed. Radio communications were normal during the short (40 mile) flt, until the plt was asked to change transponder codes. The transponder signal ceased instead. The crash site…NTSB NYC84LA265Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Plymouth, MAThe plt stated that when he released his glider at 2500 feet, soaring conditions were good. Conditions deteriorated which resulted in no lift and altitude was insufficient to safely return to the departure airport. The pilot attempted to land off the airport…NTSB MKC84FA240Accident · Minor injuriesField investigationFinal reportCessna A188B · Stonewall, ARWhile engaged in aerial application, two acft working the same field collided in-flight. Pre-flight planning and briefing for the dual operation was not conducted. There were no inter-plane communications.NTSB MIA84LA224Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Cedar Key, FLPlt stated touchdown was beyond runway numbers. Braking was not initiated until halfway down the 2400 ft long rwy. No deceleration apparent even with max pressure applied to pedals. Plt did not rpt attempt to pump brakes or use assymetrical braking but was…NTSB MIA84LA217Accident · No injuriesLimited investigationFinal reportCessna 310 · Key Largo, FLPlt stated gear was lowered for landing but down & locked light did not illuminate. Gear was recycled and as observed through an outside mirror, plt stated gear appeared down. Following touchdown and a 75 ft ground roll the rt main gear collapsed.NTSB MIA84LA216Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Carrabelle, FLAcft swerved off the rwy after the plt heard a loud pop sound. Examination of the aircraft disclosed that the a main landing gear attach bolt had sheared.NTSB MIA84FA218Accident · Minor injuriesField investigationFinal reportCessna 150J · San Juan, PRStudent pilot carrying a passenger took off with the flaps in the full down position. The aircraft stalled shortly after takeoff and impacted the runway in a nose low, left wing low attitude.NTSB FTW84LA338Accident · Serious injuriesLimited investigationFinal reportCessna 150B · Weatherford, TXThe plt had been performing successful solo touch & go landings toward rising terrain with a high ambient temp, but after boarding a passenger the acft failed to clear the rising terrain and stalled into the trees. The density alt was about 3600 ft while the…NTSB DEN84LA260Accident · No injuriesLimited investigationFinal reportBell 47G · West Glacier, MTFollowing in-flight power loss the pilot performed an autorotation to a forced landing on a highway. On touchdown, the main rotor made contact with a passing motor home. Investigation revealed no fuel on board, although the pilot calculated 0.6 hours of fuel…NTSB DEN84LA250Accident · No injuriesLimited investigationFinal reportCessna 414 · Albuquerque, NMPlt originally planned apch to rwy 17 but changed rwy when informed by another acft that rwy 35 was the active. Two witnesses reported winds at the time were from the east, one stating 5 to 7 mph the other stating light and variable. Plt stated apch speed of…NTSB CHI84LA336Accident · No injuriesLimited investigationFinal reportCessna 180 · Springfield, OHAfter what the pilot described as a normal landing his seat dislodged from the track and tilted back against the rear seat. He held on to the yore but was unable to reach the pedals. The a/c slowed to about 20-25 mph then the right main landing gear failed at…NTSB CHI84LA332Accident · No injuriesLimited investigationFinal reportArnold Forest Quickie 2 · Grantsburg, WIThe acft made one forced landing after engine trouble. The plt cleaned the fuel filters and took off for a test flt. The engine failed during takeoff. Post accident inspection of the engine showed it would run but the oil pressure was very low.NTSB CHI84LA331Accident · No injuriesLimited investigationFinal reportAeronca 65-LA · Monon, INThe plt stated that after he had landed, he shut off the fuel valve & was going to put the acft in the hangar then decided to fly a little more. He took off, but forgot to turn on the fuel switch. After climbing aprx 150 ft, the eng lost power. Subsequently,…NTSB ATL84LA245Accident · No injuriesLimited investigationFinal reportCessna R182 · Rome, GAThe acft made a hard landing after a power loss during takeoff. The ground was soft from rain and the nose gear failed at the fork as it dug into the dirt. The plts said that before takeoff they had checked for water in the fuel from both wing sumps and…NTSB ATL84LA243Accident · No injuriesLimited investigationFinal reportCessna 152 · Franklin, NCPlt stated an encounter with a downdraft at 3800 ft MSL caused acft collision with 2300 ft elevation of rising terrain. FBO overflew area within the hour and reported calm winds and no turbulence. Witnesses heard acft maneuvering at low altitude in valley…NTSB ATL84LA242Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Prattville, ALThe pilot stated that while approaching a field in preparation for agricultural sraying, the engine failed. The aircraftwas pulled up into a climbing left turn and turned back toward the field for a forced landing. The aircrafts glide was extended to clear…NTSB NYC84LA267Accident · Minor injuriesLimited investigationFinal reportCessna C305A · Oceanport, NJAcft was involved in banner tow pick-up. On engaging tow, plt had executed full power pull-up to about 150 ft AGL when power loss occurred. Plt performed a forced landing on sandy terrain. Fire broke out on lndg roll. Plt evacuated acft successfully but acft…NTSB NYC84LA264Accident · No injuriesLimited investigationFinal reportCessna 310L · Manahawkin, NJNose wheel tire blew out on lndg. Investigation revealed structual damage to airframe. Inspection of runway showed tire rim contact with the surface and prop blade strikes. Plt did not make a statement.NTSB NYC84FNE04Accident · Serious injuriesFinal reportCessna 150H · Burlington, CTThe plt reported he 'picked up the acft after annual inspection', performed a preflt, made a standard run-up & took off in calm air conditions. After clmbing about 500 to 600 ft, the eng lost power & subsequently, the acft crash landed in a marsh. The plt was…NTSB NYC84FNC08Accident · Serious injuriesFinal reportZappia Gabriel J QUICKIE-2 · Augusta, METhe pilot stated that he noticed he was unexpectedly low on fuel. As he approached the Augusta, Maine airport. He radioed the Augusta fss and transmitted the fact. Shortly thereafter the engine quit and the pilot executed an emergency landing in a wooded…