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 CHI85LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Youngstown, OHAfter returning to the arpt, the plt entered the pattern for a x-wind landing. He made 3 go-arounds while attempting to land. On the 4th apch, the acft touched down, then became airborne again. The plt decided 'to much time had passed to make another…NTSB CHI85LA007Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2B · Hampshire, ILDuring the landing flare the acft stalled at about 15 ft. both main ldg gear collapsed when the acft collided with the runway.NTSB CHI85FA004Accident · 1 fatalField investigationFinal reportKallansrud/Pitts S-1C · Overisel, MIMishap acft, in company with another acft of same make/model, made preplanned passes over locale of residence prior to departure for short cross-country. After several circles at 500 ft AGL, mishap plt broke out of loose formation into shallow dive; other plt…NTSB LAX85LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Van Nuys, CAThe student plt was on his 3rd supervised solo flt & stayed in the traffic pattern to practice landings. On the 2nd approach to land, the acft ballooned during the flare & yawed to the left. The acft touched down & immediately veered left, went off the rwy &…NTSB LAX85LA002Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Firebaugh, CAThe acft collided with terrain while on an aerial application flt. The plt stated he, 'heard a loud bang' while spraying. Then the 'nose of the helicopter dove radically down', and he crashed into the field. Examination of the site revealed that one of the…NTSB FTW85LA009Accident · No injuriesLimited investigationFinal reportCessna T210L · Rosenburg, TXPlt had altered route of flight twice to circumnavigate IFR wx, finally reversing course to land at an overflown VFR airport. Plt stated that as he headed to the the arpt the engine coughed and quit. Plt switched tanks and turned on boost pump. Engine ran…NTSB FTW85LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Crowell, TXThe plt stated that he lowered the landing gear on short final and that he received 3 green lights. During the landing roll a total gear collapse was experienced. A pilot witness on the ground stated that the nose gear did not appear to beextended when the…NTSB DEN85LA004Accident · Minor injuriesLimited investigationFinal reportAerospatiale SE316B · East Glacier, MTThe acft crashed at a remote landing site while on a seismic operation. The plt stated that he departed a ridge- top with intentions of dropping off 2 to 4 passg at another ridgetop located one-half mi south. The intended ldg point was a narrow ridgetop at…NTSB DEN85LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Silver City, NMThe plt stated after the accident that he was attempting to land on rwy 33. He continued to state that immediately prior to the landing flare, a 'terrific downdraft' forced the acft down on the rwy. The acft landed hard and the plt attempted a go-around. He…NTSB DEN85FA002Accident · 3 fatalField investigationFinal reportHamburger Flugzeugbau Hansa HFB-320 · Aberdeen, SDThe hansa jet HFB-320 acft crashed on takeoff from the Aberdeen airport after the flt crew selected the incorrect rwy for takeoff. The acft was observed running off the end of rwy 17, which is 3860 ft long, where it struck a fence, ditch, road & another ditch…NTSB CHI85LA011Accident · No injuriesLimited investigationFinal reportMooney M20A · Tecumseh, MIUpon touchdown the landing gear collapsed. Inspection revealed the landing gear actuator handle was cracked aprx 1/2 inch above the actuator torque tube. The crack was through 3/4 of the circumference and there was a 10 deg bend in the tube near the crack.…NTSB CHI85LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150F · West Branch, MIThe plt reported that when he arrived at night, he was unable to activate the rwy lights, but decided to land anyway. He touched down long on the 3700 ft rwy & was unable to stop on the remaining area. The acft continued off the end & hit a ditch where the…NTSB SEA85LA002Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hood River, ORAt about 150 ft AGL on climb out, the tow plane lost power for an unspecified reason. The glider pilot released the tow and executed a 180 degree course reversal to a downwind (15 KTS) landing. During roll out, the left wing contacted the ground, causing an…NTSB MKC85LA002Accident · No injuriesLimited investigationFinal reportBeech 35 · Nashville, ARDuring the flare the acft ballooned, decelerated and stalled. The resultant hard ldg collapsed the ldg gear.NTSB MIA85FA002Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Wauchula, FLPlt used outdated sectional chart & landed at an old (closed) airport, which was no longer maintained. On departure, using soft field procedures, acft did not accelerate properly & became airborne in ground effect at minimal speed. Plt determined acft would…NTSB LAX85LA001Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Redding, CARunway 15 was in use. Plt broadcast on UNICOM freq intention to land rwy 15. Plt landed on rwy 33 with a 10 kt tailwind. On landing roll, plt realized he would not be able to stop on remaining rwy & go-around was initiated. Acft did not attain flying speed…NTSB DEN85FA008Accident · 3 fatalField investigationFinal reportCessna 195A · Santa Fe, NMWhile en route, the transponder was inop & the plt lost radio contact with ARTCC 2 times. As he apchd the destn (Santa Fe), instructions were relayed via another acft. When asked what type apch he wanted, the plt responded, 'well if they can get me lower,…NTSB ATL85FID01Accident · Serious injuriesFinal reportCessna 172M · Norfolk, VAThe plt was making his landing apch behind a Boeing 727 and in front of a Boeing 737. Plt was requested by ATC to make a short apch but was also cautioned about wake turbulence. On final apch at aprx 50 ft AGL, N70554 rolled sharply into a 90 deg bank,…NTSB NYC85LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Waterbury, CTAfter liftoff, the plt initiated a turn into the crosswind to maintain runway heading. As he did so, a wind gust tipped the acft in the direction of the turn. Ground contact occurred before corrective control inputs by the plt could take effect.NTSB NYC85FA001Accident · No injuriesField investigationFinal reportBell 206L-1 · Reinholds, PAPlt felt vibration in anti-torque pedals followed by a series of loud bangs coming from the tail section. Plt initiated precautionary landing during which tail rotor effectiveness. During the 'power off' run on landing main rotor blades contacted the tail…NTSB MKC85LA001Accident · No injuriesLimited investigationFinal reportAyres S2R-R3S · Lepanto, ARAs the pilot set climb power the acft began to settle. Full power was applied but the descent continued. The pilot dumped the chemical load and landed in a rice field. During recovery of the wreckage the flexible induction air duct partially collapsed…NTSB FTW85LA004Accident · No injuriesLimited investigationFinal reportCessna A185E · Morgan City, LAPlt arrived at intended lndg site on remote pipeline canal where quarter boat was operating, overflew site and visually checked conditons. After 100-150 yds of landing roll, the right float struck a submerged object. Float filled with water and acft rolled…NTSB DEN85LA001Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Las Vegas, NMThe plt stated he was on a x-country flt and after aprx 1.5 hrs, the engine started to run rough. The plt attempted to correct the roughness and when he applied the carb heat, the engine quit. The plt turned off the carb heat but power could not be restored…NTSB CHI85LA002Accident · Minor injuriesLimited investigationFinal reportBrewer Corsair · Ft. Wayne, INAfter touchdown and an initial rollout of aprx 480 ft, the acft began veering to the right. The acft departed the right side of the rwy and contacted a plowed trench, 29 ft from the rwy, where it nosed over.NTSB CHI85LA001Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Greenbush, MNFollowing an uneventful approach and landing, the plt was taxiing back up the runway when the right engine quit. The right seat passenger immediately noted flames coming from the engine and notified the plt, who swung the acft into positon for wind to keep…NTSB ATL85LA002Accident · No injuriesLimited investigationFinal reportCessna 150L · So.Charleston, WVShortly after takeoff while on the base leg at 900 ft AGL, the engine quit. Plt stated attempts to restart the engine failed. During the forced landing apch the acft collided with trees and a high tension wire. The acft spun around 180 deg and came to rest on…NTSB ATL85LA001Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Milledgeville, GAThe plt departed for the intended destination, but was unable to find the arpt due to fog. After landing at another nearby arpt, he found no av-gas available. He then elected to return to his original destination, but experienced a total power loss due to…NTSB SEA85FA001Accident · 3 fatalField investigationFinal reportCessna R182 · Austin, NVDeteriorating wx was encountered as the plt followed a highway to his dest on an easterly heading. On scene evidence indicated that the acft impacted left wing tip first on a northerly heading near the east end of a box canyon. The impact flight path angle…NTSB MIA85LA001Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Miami, FLThe rated pilot and certified flt instructor stated that they were practicing agricultural dives and turns. During a dive, the pilot pulled out of the dive at about 5 feet and the aircraft contacted sawgrass and crashed. The instructor pilot initially stated…NTSB LAX85LA020Accident · No injuriesLimited investigationFinal reportCessna 180 · El Monte, CAA low time pvt plt flared the acft which touched down hard and bounced. On the second touchdown, the acft entered a ground loop to the right. Application of right brake and rudder did not correct the situation. The left wing and nose went down & the acft went…NTSB ANC85LA001Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Ohio Creek, AKThe pilot reported that during the landing roll, the right main landing gear wheel adaptor broke. The failure caused the pilot to lose directional control and the airplane subsequently overturned. Examination of the wheel adaptor disclosed evidence of…NTSB FTW85LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Luling, LAThe plt stated that on final approach a gust of wind carried the acft to the right of the runway. Acft right wing struck a tree. Acft yawed right and contacted ground in uncontrolled flight.NTSB FTW85LA002Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Progreso, TXShortly after takeoff, plt heard explosive report from engine and experienced partial pwr loss. Plt attempted to return for landing but could not maintain sufficient altitude. Load not jettisoned. During forced landing roll out in cane field acft nosed over.…NTSB FTW85LA001Accident · No injuriesLimited investigationFinal reportCessna TU206G · Chandeleur Isl, LAPlt was flying low and slow in area awaiting arrival of boat for fishing party. Plt allowed his attention to be distracted by spotting fish & inadvertently contacted water with a float. Acft came to rest inverted in 6 inches of water.NTSB NYC85LA024Accident · No injuriesLimited investigationFinal reportRaven S-66A · Little Compton, RIPlt brushed basket against tree tops and bushes to slow the balloons forward speed. Plt pulled deflation port aprx 10 ft AGL over a mown hay field with an 8-10 mph horizontal, 100 fpm vertical speed. Basket bounced and gust of wind caught deflating envelope…NTSB NYC84LA327Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Churchton, MDDuring glider tow climbout, encounter with thermal resulted in momentary tow rope slack. Tow rope separated in overload when slack was taken up. Glider plt selected nearest open fld & set up landing pattern. On downwind leg, plt noted obstructions in fld,…NTSB NYC84FNC10Accident · Serious injuriesFinal reportBell 47G-3B1 · Lincoln, NHThe acft was being used in a passenger sightseeing operation when shortly after takeoff the eng ceased to operate & the acft crashed into trees. Both passengers aboard the helicopter observed that the fuel gage indicated empty prior to the eng stopage. Exam…NTSB NYC84FA326Accident · 5 fatalField investigationFinal reportPiper PA-34-220T · Turbotville, PAWhile the acft was en route, ATC advised the plt of VFR traffic at his one o'clock position at 12 mi on a nw heading. The plt acknowledged, but reported that he had no contact & said the wx was a little hazy. A short time later, ATC advised the traffic was…NTSB MKC84LA287Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Prairie City, IAWhile the hot air balloon was airborne, the surface winds increased to 13 KTS. The plt instructed both passengers to prepare for a high wind landing. Contrary to the plt's instructions, the passenger, who became injured, crouched in the bottom of the basket…NTSB LAX84LA502Accident · No injuriesLimited investigationFinal reportCanadair T-33 · Palm Springs, CAThe plt stated that 'as I crossed over the field boundry, landing was assured so I closed the throttle. The acft then pitched nose up (slightly), left wing dropped & acft sank out of control to touchdown on the overrun just short of the threshold.' The acft…NTSB FTW84LA413Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Rosenburg, TXThe acft was subst damaged during a forced landing following a total loss of power. Investigation revealed the acft was on the return leg of a x-country when the student plt became lost & while searching for an arpt ran out of fuel.NTSB FTW84LA411Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXStudent plt departed on supervised solo cross-country flt to specific destination and return. Instead, plt landed at unimproved field without required prior operator approval and embarked his wife as a passenger for a local flight. On return from local flt, a…NTSB DEN84LA305Accident · No injuriesLimited investigationFinal reportCessna 152 · Missoula, MTPlt flared abruptly and acft floated before it touched down hard on the rwy collapsing the nose gear. Acft traveled 20 ft off the right side of the rwy before coming to rest.NTSB DEN84LA304Accident · No injuriesLimited investigationFinal reportBeech C24R · Bismarck, NDPlt calculated the flt to be 4 hours 33 minutes long and there were 5.2 hrs of fuel on board. Plt stated, en route he was requested to climb from 6,000 ft to 8,000 ft then to 9,000 which was performed at 'full power, fuel full burn.' Stronger headwinds were…NTSB DCA84IA001Incident · No injuriesIncident investigationFinal reportBoeing VC-137B-BN · Akron, OHA Boeing VC-137B-BN, USAF #58-6971, operating as air force 2 (AF-2), departed cleveland, OH, at about 1745 EDT on an IFR clearance. After departing cleveland, AF-2 was assigned an alt of 8000 ft MSL by cleveland departure control & was transfered to cleveland…NTSB CHI84LA408Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Defiance, OHDuring initial takeoff climb at alt of 300 ft AGL, 9 1/4 inches of rt engine prop blade separated. Forced landing was make in field during which time the rt wing contacted a tree. Metallurgical examination revealed progressive fatigue over 75% of the…NTSB ANC84LA195Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tikchik Lodge, AKThe plt attempted a takeoff from a 500 ft sand bar and during the takeoff roll the main landing gear struck soft spots. Realizing the acft was not going to become airborne he closed the throttle attempting to stop in the remaining distance. The acft left the…NTSB ANC84FA194Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Wasilla, AKAcft contacted pine trees while turning base to final apch to land. Plt stated all he remembers is trying to activate the plt controlled rwy lights but never seeing them illuminate. Another plt who landed just prior to N1260A'S attempt stated the airstrip was…NTSB SEA84LA235Accident · No injuriesLimited investigationFinal reportGarre Leo J Glasair · Aurora, ORPlt was attempting a no flap landing. The acft developed a high rate of sink, struck the rwy and bounced. The acft ground looped and nosed over.NTSB SEA84LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Shady Cove, ORThe pilot stated after the accident that he stalled the aircraft at an altitude of 50 ft AGL during takeoff and the acftdescended in a nose low attitude into trees and the ground.