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 NYC84LA155Accident · No injuriesLimited investigationFinal reportBell 206 · Boston, MAAfter takeoff, the helicopter was climbing thru 200 to 300 ft AGL, at 50 to 60 KTS, when a partial loss of power occurred. This was followed immediately by a complete loss of power. The plt initiated an autorotation & landed in a railroad switching area where…NTSB LAX84LA276Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26D · Vacaville, CAThe student, glider plt stated that he encountered a loss of lift while on the downwind side of a hill. Subsequently, he selected a field for an off-arpt landing. On final apch, the plt noticed a fence in the middle of the field & was unable to avoid it. He…NTSB DEN84LA140Accident · No injuriesLimited investigationFinal reportBeech F35 · Moab, UTDuring takeoff, the eng lost power at about 100 ft AGL. The plt decided to land the acft back on the rwy to avoid rough terrain beyond the end. The acft was landed with the gear up. During an investigation, fuel was found in the main tanks & the right…NTSB SEA84LA096Accident · No injuriesLimited investigationFinal reportHughes 369D · Toutle, WAPlt was operating helicopter at 120 ft AGL with the aux fuel pump on when a ttl loss of pwr occurred. Autorotation was entered but a hard landing resulted in the main rotor blades cutting off the tail boom. Investigation revealed a fuel sample taken from the…NTSB NYC84FNE02Accident · Serious injuriesFinal reportBenson B8M · Willimantic, CTThe gyrocopter crashed after the plt lost control of the acft in a windy condition, during takeoff. A 20 degree x-wind velocity of 10 KTS gusting to 35 KTS existed at the time of the accident. The plt told his wife (who wrote the report on the 6120.1 NTSB…NTSB LAX84LA310Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Death Valley, CAAccording to the plt, the approach to rwy 33 was in a 'no-wind condition until about 30-40 ft AGL when a strong tail wind came up.' He stated that it appeared that there was sufficient rwy remaining and when he realized it was too late to stop or go around he…NTSB LAX84LA279Accident · No injuriesLimited investigationFinal reportCessna 150J · Fort Ord, CABefore taking off, the plt noted that the left fuel gage indicated a little less than 1/2 full & the right gage showed aprx 1/2 full. He stated that a 'visual inspection showed about the same, as much as I could see.' The flt was uneventful until the eng…NTSB LAX84LA274Accident · No injuriesLimited investigationFinal reportHall-Cavalier SA-102.5 · Palo Alto, CADuring a landing, the acft bounced & porpoised several times and the nose gear failed. Subsequently, the acft skidded to a stop on the rwy & a fire erupted in the eng compartment. The occupant exited the plane, but moments later, it was consumed by the fire.NTSB LAX84LA273Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Salinas, CAWhile spraying a field of artichokes, the plt had made 1 pass southbound & started another northbound. He began the swath run by descending over power lines, then tried to climb & clear rising terrain beyond the lines. However, the helicopter continued…NTSB LAX84FA275Accident · 1 fatalField investigationFinal reportRolladen-Schneider LS3 · Warner Springs, CAThe sailplane was found in a nose down attitude amoung 10 to 15 foot ribbon-wood shrubs approx 250 ft wnw of the departure end of a small airstrip. Both wings were found displaced forward with the rt one forming a straight line extension forward fm the…NTSB FTW84FPJ01Accident · 2 fatalFinal reportPiper PA-22 · Byron, OKThe acft had impacted the ground at a 60 deg angle. The 1153 wx at ponca city, OK (60 mi east of the crash site) was ceilings obscured to vision & indefinite, with thunderstorms, rain & fog. The ceiling was estimated to be 200 ft obscured.NTSB DEN84LA139Accident · No injuriesLimited investigationFinal reportAerospatiale 316B · Near Dillon, COWhen the plt took off from a mountainous ski area, light to moderate snow was falling & the winds were coming up the valley at 5 to 10 KTS. During the flt, he encountered an estimated 35 kt upslope wind as he was proceeding on the upwind side of a ridge at an…NTSB CHI84FA169Accident · 4 fatalField investigationFinal reportCessna 172RG · Woodbury, MNThe acft collided with a radio antenna support cable at aprx 171 ft AGL during low altitude maneuvering in snow showers. One witness stated that the heaviest snow showers were in the vicinity of the accident site. A policeman saw the acft over a field near…NTSB SEA84LA097Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hermiston, ORDuring a beginning swath run, the plt was making a left skidding turn to follow the edge of a circular field. He stated that the acft encountered a downdraft which raised the right wing. Subsequently, the left wing contacted the ground & the acft crashed.NTSB NYC84MA151Accident · 2 fatalMajor investigationFinal reportPiper PA-60-601P · Cockeysville, MDOn the day of departure the plt had received a 30 min familiarization flt upon completion of the superstar conversion. Emphasis was directed to eng gages, fuel flow & counter, & power settings. The flt was flown at 5,500 ft. the plt then obtained a wx…NTSB NYC84LA154Accident · Serious injuriesLimited investigationFinal reportBryan RS-15 · Colts Neck, NJDuring arrival to land, the plt circled over the arpt while gliders were being removed from the active rwy. He then made a tight downwind leg & started a 180 deg apch from 200 ft at 55 KTS. He stated that the 'roll rate (to the left) was rapid and by the time…NTSB NYC84LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Laconia, NHThe acft ballooned during landing and came down hard on the nose gear which collapsed. The plt said a gust of wind had made the acft ascend about 20-50 ft after which it fell to the rwy. He reported the prevailing wind was variable from 270 to 290 deg a 12…NTSB MKC84LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · N.Carlisle, ARThe acft nosed over after swerving off the rwy into soft sod during landing. The student plt was on his 2nd solo flt andpracticing touch and go landings. This was the plts 1st landing at carlisle arpt where the wind was of more velocity and greater angle than…NTSB MKC84FU002Accident · Serious injuriesFinal reportRally Rotec 2B · Carroll, IAThe ultralight was seen maneuvering at low alt in the vicinity of the accident. The plt circled his brother's house at low alt and then pulled up abruptly to avoid rising terrain. In the abrupt maneuver, the plt lost control of the ultralight and impacted the…NTSB MIA84LA155Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Lake Harbor, FLThe plt adjusted the mixture twice during his descent from 2500 ft MSL. The second adjustment killed the engine and a forced landing was made in a sugar cane field. Post accident examination revealed that the engine mixture control cable was broken. A…NTSB MIA84FA156Accident · Serious injuriesField investigationFinal reportMurphy-Charles PJ-1 (Adventure) · Merritt Island, FLWhile the plt was maneuvering on final approach to land on rwy 11, the eng lost power. Subsequently, the acft crash landed in the backyard of a residence. The plt received serious injuries & could not recall details of the accident. No preimpact part failure…NTSB LAX84LA272Accident · Serious injuriesLimited investigationFinal reportDouglas DC-6A · San Manuel, AZThe acft skidded off the departure end of the rwy collapsing the landing gear in a ditch as it caught on fire. This acftwas on a ferry flt and had several mechanical problems. Among these was the prop reversers which failed on landing. The anti-ice/de-ice…NTSB LAX84LA271Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Vacaville, CAThe flight was conducted for a sales demonstration. Both occupants were pilots. Two landings were performed by the acft owner. The third landing was performed by the prospective buyer and during touchdown the acft bounced. The owner applied power to recover.…NTSB LAX84LA270Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Fair Oaks, CABefore departing on a x-country flt, the plt was warned to refuel midway on his route. He recalculated his fuel while en route & thought sufficient fuel was remaining. During arrival, the plt activated the rwy lights, but did not see them until he was nearly…NTSB FTW84FA214Accident · 3 fatalField investigationFinal reportCessna 310Q · Mckinney, TXPlt entered the landing pattern behind a slower acft (stearman) and reduced speed to maintain a proper interval. The nominal approach speed differential between the two acft makes is 26 mph. A right hand traffic pattern was in use and a right crosswind…NTSB CHI84LA170Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Shelbyville, ILAfter a normal 3-point, full stall landing, the tailwheel equipped acft rolled a short distance, then veered to the left. The plt stated that he applied right rudder & both brakes, but the acft continued to the left. He reported that as the plane went off the…NTSB CHI84LA168Accident · No injuriesLimited investigationFinal reportCessna 182P · Cinncinati, OHThe acft made a forced landing after a total power loss. On the landing flare the right main gear caught the edge of a sand trap & sheared off. Approximately 8 ounces of water were drained from the sumps & carburetor. The engine was subsequently started & ran…NTSB CHI84LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Marine City, MIThe plt departed london, ontario with 14 gal of fuel on board. He became disoriented & flew over sarnia which he mistookfor detroit. He stated that he waited too long before contacting anyone for help. When he finally called selfridge approach & was being…NTSB CHI84LA166Accident · Minor injuriesLimited investigationFinal reportGrumman AA5A · Cudahy, WIThe acft struck a storage shed while attempting to reach a golf course during an emergency landing in gusty wind conditions. There were no visible signs or odor of fuel at the accident site. When the acft was inspected the carburetor and fuel sumps were…NTSB ATL84LA155Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Shaw, MSThe acft was landed gear up in a precautionary landing after a control difficulty in flt. On base leg a loud bang was heard and the acft started to roll right. Control forces were heavy so the other plt in the front seat tried to help on the controls. They…NTSB ATL84LA154Accident · No injuriesLimited investigationFinal reportCessna 182P · Louisa, VAThe plt reported that the grass & ridges on the strip held the acft's speed down more than expected during the takeoff roll, so the plt decided to abort. The plt later stated that he could have made it safely, but his 'instinct' was stronger so he decided to…NTSB ATL84LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Smyrna, TNThe CFI simulated an engine failure on the right engine during takeoff after having simulated a left engine failure during the landing approach. The left engine failure was simulated with the left throttle retarded during the approach and landing. After the…NTSB ATL84LA149Accident · No injuriesLimited investigationFinal reportMooney 21 · Centre, ALWhile in cruise flt the engine failed. The pilot executed a forced landing, and the acft sustained substantial damage during the landing sequence. Examination of the acft revealed no fuel in the tanks, lines, or pump. The acft had flown about 5 hours since…NTSB NYC84LA153Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Clinton, MDThe main rwy at the arpt was closed due to resurfacing. The plt was attempting a landing on rwy 31 knowing it would be a deliberate downwind landing. According to the operator of the arpt, plts were discouraged from using rwy 13 because the traffic directly…NTSB MIA84LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Marco, FLThe flt departed fort myers, FL at 0550 & arrived at key west, FL at 0655. The flt then departed key west at 0710 for the return flt. At 0722, the plt reported to ARTCC that he was experiencing eng failure & could get no fuel pressure. The acft was ditched 29…NTSB LAX84FA374Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Lone Pine, CAWhen the acft did not return from a x-country flt, a search was initiated. However, the acft was not found until hikers discovered the wreckage on 6/29/84. Impact occurred at about the 9000 ft level in mountainous terrain. The outer wing panels & horizontal…NTSB FTW84LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Shiro, TXThe acft collided with a fence, ditch & trees during a touch-&-go landing on a short grass strip with obstructions at both ends. This was the students 4th solo attempt and according to the owner of the aviation training center touch-&-go landings are not…NTSB FTW84LA213Accident · No injuriesLimited investigationFinal reportAerospatiale AS 315B · Hartshorn, OKThe helicopter sustained substantial damage during an autorotative landing following an explosion in the engine compartment. While in level flight at 1000 ft AGL, the plt heard a loud screech from the engine area followed by a loud bang. A wingman observed 10…NTSB CHI84LA164Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Bloomer, WIPlt failed to visually check fuel tanks after they were refueled. On the second leg of a x-country fuel exhaustion occurred. The acft nosed over during the forced landing on soft terrain.NTSB CHI84FA165Accident · No injuriesField investigationFinal reportShort Brothers SD3-30 · North Canton, OHFollowing normal lndg, plt executed 180-degree turn on runway, then taxied to gate. Normal gate arrival maneuver is a right 180-degree turn to present left side of acft to gate. As acft passed through about 135 degrees of this maneuver, hydraulic warning…NTSB ATL84FA151Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Maynardville, TNThe acft crashed in an uncontrolled state after the airframe failed in flt. Witnesses observed the acft spinning out of the clouds with parts of the airframe separating as it descended. The weather had been described to the plt in 2 wx briefings. At the time…NTSB ATL84FA150Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Suffolk, VADuring the initial takeoff climb the acft contacted power lines located 584 ft from the end of the rwy. This was an initial test flt of the acft after having the engine overhauled. The plt stated at an alt of aprx 50 ft AGL the engine began to lose power and…NTSB NYC84FA149Accident · 1 fatalField investigationFinal reportCessna 170B · Turner, MEWitnesses observed the acft approach, flaps down, for lndg. A flare was made near the approach end of the runway, then the acft ballooned to about 20 ft AGL and once more descended to the runway surface. On touchdown, the right wing tip appeared to contact…NTSB MIA84LA152Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Valdosta, GAThe instructor plt (CFI) stated that he was giving a private plt a biennial flt review & that the private plt was the plt-in-command (PIC). While in the traffic pattern for their 2nd landing, they heard another acft entering the pattern, but they were not…NTSB CHI84LA163Accident · No injuriesLimited investigationFinal reportWilliam Freeman Glasair · Lambertville, MIThe plt stated that during takeoff, the acft weather vaned into the wind and the left main landing gear went off the rwy. When the acft hit soft plowed dirt after leaving the rwy, it nosed over.NTSB CHI84LA162Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Palmyra, WIThe pilot lost control of the acft on the landing flare & collided with a tree. The acft was blown to the left of the rwy & before he could execute a go-around the propeller struck some high brush alongside the rwy. The plt pulled power off, landed in rough…NTSB CHI84LA161Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa City, WIAfter takeoff, the plt had made 2 turns & had attained an alt of about 200 ft AGL when the eng sputtered & lost power. He was unable to turn & land on the rwy, but continued straight ahead to avoid houses & trees. During an emergency landing, the acft…NTSB SEA84LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Davenport, WADuring the landing roll the brakes were applied with no effect. The acft went off the end of the rwy into a ditch and nosed over. Examination of the acft showed the brake system low on fluid and the master cylinder diaphragm ruptured.NTSB MKC84LA129Accident · Minor injuriesLimited investigationFinal reportCessna 172M · 5n 0lin, IAWhile cruising at 3,000 ft MSL the eng ran rough. The flt noticed zero oil pressure. As he turned toward a bean field the eng failed. The acft collided with a ditch & nosed over. The eng was disassembled & an estimated 3-4 qts of oil were in the eng case. The…NTSB MIA84LA151Accident · No injuriesLimited investigationFinal reportCessna 172M · Ocala, FLDuring a landing, the plt lost directional control & the acft veered off the left side of the rwy. The nose gear struck a concrete drainage conduit & was substantially damaged. The plt reported the wind was from 090 deg at 8 KTS.