NTSB investigations
3,485 cases where the first occurrence was “In flight collision with terrain/water”.
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 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230) 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 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 CHI85LA274Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Mt. Carmel, ILThe plt stated that his acft was loaded with dry fertilizer. Following takeoff from the sod strip he failed to clear a dirt bank at the south end of the airstrip. After striking the dirt bank he impacted in a cornfield nose down. Following the accident the…NTSB MKC85LA149Accident · No injuriesLimited investigationFinal reportCessna 210 · Eldon, MOThe plt reported that during an apch to land, he forgot to extend the landing gear & landed with the gear retracted. He did not recall hearing the gear warning horn; however, a check of the landing gear sys did not reveal any malfunction.NTSB ATL85LA202Incident · No injuriesLimited investigationFinal reportBeech 95-B55 · Alma, GAThe acft was lndd with the gear retracted during, practice touch & go landings. The plt was a FAA flight test engineer. The plt stated that the gear collapsed on touchdown; however, examination of the landing gear system failed to reveal a system malfunction.NTSB ANC85LA114Accident · No injuriesLimited investigationFinal reportCessna 172M · Theodore River, AKAfter loading the acft to its max gross wt, the plt initiated a takeoff from a road on level terrain that had numerous dips & bumps. The road was only 11 ft wide & was bordered by heavy brush. The plt reported that prior to reaching the lift-off speed during…NTSB MIA85LA205Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Apalachicola, FLAn ATP plt (PIC) said he was checking out another (commercial) plt in the acft. As the commercial plt was making a takeoff from a touch-&-go landing, the acft lost altitude & collided with water. The commercial plt stated that he was looking for the flap…NTSB DEN85LA176Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Gallup, NMDuring a x-country flt from los angeles, CA to tulsa, OK, the plt made an en route stop at Gallup, NM. The fuel tanks were fully serviced & the plt took off with a passenger & aprx 50 lbs of tools & baggage on board. The plt stated that after takeoff, the…NTSB MIA85LA201Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLThe acft settled gear up onto the rwy during an attempted go around from a simulated single engine apch. The student flared too high & requested command of both throttles from the CFI. Pwr was applied & the flaps & gear were prematurely retracted. The acft…NTSB MIA85LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Opa Locka, FLThe plt was landing after a x-country flt when the right wing & the prop contacted the rwy. The plt stated that the gear had collapsed during a go-around. However, the landing gear was intact, except for impact damage on the right main gear. No gear…NTSB LAX85FA293Accident · 1 fatalField investigationFinal reportRolladen-Schneider LS3-A · Callahan, CAThe plt was participating in a x-country soaring competition. He released from the tow at 5,000 ft above sea level. About one hour later he imformed his crew by radio that he had covered 80 percent of the first leg and that he was 'doing fine.' The flt did…NTSB DEN85LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Yuma, COOn June 23, 1985, a Piper PA24 crashed immediately after takeoff from Yuma arpt while avoiding another acft. The plt made a right turn immediately after takeoff. He then saw the traffic and pushed the control wheel forward. The acft impacted the ground. The…NTSB MKC85LA138Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Manhattan, KSThe plt said he put the landing gear selector switch to the down position and thought that he observed a green, down andlocked indicator light; however, the acft landed with the gear retracted. Examination of the acft after the accident revealed that the…NTSB CHI85LA246Accident · Minor injuriesLimited investigationFinal reportAnderson Skybolt · Escanaba, MIPrior to the acdnt, the acft was observed making repeated low passes over the area where it subsequently crashed. Witnesses reported that during a turning maneuver over water, the acft collided with the surface & crashed. A police officer, who responded,…NTSB LAX85LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Filmore, CAThe plt flew into a canyon with the intention of turning around to back out. He then decided the canyon was too narrow for a 180 degree turn. He continued flying up the canyon while attempting to gain alt, however, the rising terrain exceeded the acft's climb…NTSB NYC85LA066Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Norfolk, MAThe acft was unintentionally landed with the gear retracted. A CFI and a pvt plt were on board at the time of the accident. The pvt plt in the left seat was flying the acft and on the third landing failed to extend the gear. The CFI in the right seat was…NTSB MIA85IA197Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Ft. Pierce, FLThe landing check list was not properly followed and both pilots neglected to extend the landing gear in preparation for landingNTSB LAX85FA280Accident · No injuriesField investigationFinal reportRobinson R22 · Manhattan Beach, CAThe helicopter was to fly in formation with a banner towed by an acft 'to attract attention.' Numerous witnesses along a 20-mile stretch of Beach saw the helicopter 'flying erratically' & 'buzzing the Beach' just prior to the accident. Witnesses saw the…NTSB DEN85LA166Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Leonard, NDDuring an aerial spray operation, the plt returned to a field with his 2nd chemical load. As he descended over trees to begin a swath run, he began a flare, but the acft continued descending & impacted the ground. The right landing gear was torn off & the…NTSB DEN85LA165Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Clearfield, UTThe plt/owner was receiving a cap check ride with an instructor plt & a passenger aboard the acft. The plt reported that during a simulated eng out excercise, the acft got within 200 ft of the ground when the insturctor 'gave me engine power back.' The acft…NTSB CHI85LA244Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Mcconnelsville, OHThe student plt had taken the acft without authority of the owner & reportedly was using it to elude police. While flying at low alt, he attempted to pass under wires along a state hiway. However, the acft impacted an embankment in a nose low, wings level…NTSB LAX85LA285Accident · No injuriesLimited investigationFinal reportCessna 172M · Garberville, CAThe plt took off in a right quartering x-wind of about 45 degs at 15 KTS with gusts to 20 KTS. There were four persons and 30 gals of fuel on board. The rwy was 2500 ft in length. The plt stated that immediately after liftoff a gust of wind pushed the acft…NTSB DEN85FA153Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Melstone, MTThe acft was observed in a left turn in a steep dive until it passed out of view behind a hill. The investigation revealed no evidence of airframe or engine malfunction or failure piror to the crash. Medical findings revealed the plt, sole occupant, had 90…NTSB ATL85LA195Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Wingate, NCThe plt & passenger consumed several beers shortly before boarding the helicopter for a flt in the local area. The flt lasted aprx 15 min. The passenger reported that during a landing, the skid on the right side contacted the ground causing the helicopter to…NTSB MIA85FA187Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Daytona Beach, FLAccording to witnesses, the plt was flying at a very low alt & was making 's' turns while proceeding southbound along a Beach. During the last left turn toward the east, the acft turned further left toward the north. While turning, the left wing struck water…NTSB ANC85LA088Accident · No injuriesLimited investigationFinal reportCessna A185F · Alaktak, AKThe acft collideded with a snow bank and nosed over during a landing attempt on a frozen lake. The plt stated that 'my rt ski hit a pressure ridge or broke through crust; whichever, the acft abrurtly pitched down, contacting the ice and continuing over onto…NTSB SEA85LA126Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Athena, ORThe acft settled back to the ground shortly after takeoff before achieving translatioanal lift. The plt was attempting to test a new spray unit that had been installed. He had put 80 gallons of water in the spray tanks.NTSB MIA85LA184Accident · No injuriesLimited investigationFinal reportCessna 337G · Daytona Beach, FLThe plt stated that while practicing an actual single eng landing, he forgot to lower the landing gear. He heard the gear warning horn but said that he thought it was his radar alimeter sounding. He admitted that actual single eng landings should not be…NTSB ATL85FA173Accident · 1 fatalField investigationFinal reportCessna R182 · Seneca, SCDuring flt, the plt was observed to make a low pass over lake keowee near a friend's houseboat. The owner of the houseboat stated that the acft was flying low off his right side when the acft struck the water. Another witness also saw the acft flying at…NTSB MKC85LA116Accident · No injuriesLimited investigationFinal reportEaa Biplane BI-PLANE · Jamestown, MOWhile practicing touch & go landings in a fld which was partially cleared, the main gear became entangled in wheat which bordered the edge of the cleared area. The plt stated he misjudged the distance needed to clear the obstacle.NTSB DEN85FTK01Accident · Serious injuriesFinal reportBoeing A75 · Tea, SDThe owner/plt-in-command (PIC) took off on a local flt with another occupant in the front seat. The front seat occupant was a commercial, single-eng, multi-eng plt with an instructor rating, but he had no previous experience in A75 acft. While in flt, the PIC…NTSB DEN85FA141Accident · 1 fatalField investigationFinal reportCessna 414 · Billings, MTThe plt was making a short (35 minutes) local flt to 'check N333AA over' before turning it over to its new owner. The acft collided with the ground in a steep descent, wings level, attitude during an entry into the traffic pattern at Billings, Montana. VMC…NTSB MKC85FA110Accident · 2 fatalField investigationFinal reportCessna 501 · Harrison, ARAt 2003 CDT, the flt was cleared for an ILS localizer apch to rwy 36 at the Harrison/boon county arpt. About 7 min later, the aircrew reported making a missed apch & the flt was cleared to the outer compass locator for another apch. The crew asked the…NTSB NYC85FA131Accident · 3 fatalField investigationFinal reportCessna TR-182 · Grand Island, NYThe flt had been on a local sightseeing tour over the niagara falls. The plt then stated that he was going to give his pax a demonstration of how fast the acft appears to be traveling when it is close to the water. The plt then began a left descending turn…NTSB SEA85FA121Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Blyn, WAThe acft impacted rising terrain at the 1860 ft level during an IFR flt in IMC conditions. The acft was reportedly to fly 'VFR on top' or IFR at 3000 plus ft enroute to portland. The plt was off course for destination when it impacted mt. Blyn. The acft trim…NTSB SEA85FA120Accident · 3 fatalField investigationFinal reportCessna 205 · Chewelah, WAThe acft was observed flying up a canyon at low altitude while climbing at an angle equivalent to the surrounding terrain slope. Shortly thereafter the acft encountered steeply upsloping terrain and began impacting trees in a left wing high and nose up…NTSB MKC85LA107Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Harrisburg, ARPlt reports that the lt wing of N4017N hit a dike in a ricefield while he was making a trim swath. There were no indications of equipment malfunction.NTSB FTW85LA227Accident · No injuriesLimited investigationFinal reportBeech 58P · Abilene, TXThe plt stated he made a normal landing and the gear folded during the rollout. Another plt who was waiting at the end of the rwy for takeoff observed the landing and stated the landing gear was extended too late and was still in transit (not fully down) when…NTSB LAX85FVA02Accident · Serious injuriesFinal reportCessna 172 · Santa Nella, CAWitnesses stated the acft was circling over farm land at a low altand while in a left turn, it descended to ground impact.NTSB NYC85LA126Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Potsdam, NYThe pilot received a weather breifing and filed an IFR flight plan with massena flight service station. The flight was uneventful and the aircraft was cleared for the NDB approach at Potsdam by boston center. When the airport was in sight, the pilot cnacelled…NTSB CHI85LA197Accident · No injuriesLimited investigationFinal reportHughes 269 · Stonington, ILAfter completing a swath run, the plt maneuvered the helicopter up over a power line, then made a turn-around for another swath run. He stated that as he started the next run, he 'felt the wind push the tail upward forcing the nose downward...' He applied aft…NTSB ANC85LA080Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Iliamna, AKThe pilot in command stated he was flying in whiteout conditions when he observed an island pass by the right side of the airplane. He started a right turn and the right wing struck the lake ice surface. He stated he did not realize he was that low.NTSB NYC85LA111Accident · No injuriesLimited investigationFinal reportCessna R172K · Glen Campbell, PADuring flt, the plt flew over svrl coal strip mines at low alt & at low airspeed. He had the acft trimmed for 60 KTS & had one notch of flaps extended. He reported that as he was flying in straight & level flt, the acft seemed to be drawn down into a valley.…NTSB SEA85LA108Accident · No injuriesLimited investigationFinal reportCessna 185 · Ketchikan, AKAfter departure the plt stated he selected gear up. He stated that the gear indicator lights indicated that one gear as still in the down position. He said he recylcled the gear and then checked the gear indicator blubs. The pilot said he then hand pumped the…NTSB CHI85LA195Accident · No injuriesLimited investigationFinal reportBeech 58 · Terre Haute, INThe plt was practicing touch-&-go landings on rwy 13, then elected to make another on rwy 5. He stated that the gear was extended on downwind & a safe gear indication was received. However, the acft was landed with the gear retracted. The plt stated that…NTSB CHI85FA186Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Lakeville, MNThe acft was observed to enter a spin from aprx 3000 ft AGL. The acft continued the spin to ground contact which witnesses stated occurred as the acft seemed to level off. Witnesses also reported seeing the acft perform aerobatics, which included loops, prior…NTSB LAX85LA236Accident · No injuriesLimited investigationFinal reportFairchild SA226T · Livermore, CAThe acft landed hard and short of the runway. The impact collapsed the right main landing gear and the acft was destroyed by the post crash fire. The plt reported that on short final a muffled 'pop' was heard and the acft yawed to the right. Directional…NTSB ATL85LA152Accident · No injuriesLimited investigationFinal reportCessna 305A · No.Myrtle Bch, SCAfter a banner pickup the plt was instructed by company group and crew to release the banner due to a fouled pickup. The banner was released during a steep climb out altitude. As the banner was released the plt lost directional control of the acft & crashed…NTSB SEA85FYM01Accident · Serious injuriesFinal reportAir Tractor AT301 · Weston, ORDuring this aerial application flight the aircraft clipped a tree and then impacted with the ground. The pilot was seriously injured when the stitching on the shoulder harness failed and the pilot was thrown forward.NTSB MKC85LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Kingman, KSDuring a landing attempt, the acft was high and fast and subsequently touched down long. The plt attempted a go around with 40 degrees of flaps. The acft stalled and contacted the terrain one fourth mile past the end of the rwy, right wing first.NTSB CHI85LA179Accident · No injuriesLimited investigationFinal reportPitts Pitts S2B · Indianapolis, INThe acft performed 4 aileron rolls during which some alt was lost with each roll. During the final roll a wing made ground contact and folded as the acft slid to a stop.NTSB ANC85LA076Accident · No injuriesLimited investigationFinal reportPiper 22/20 · Girdwood, AKThe acft was on a flt to transport 2 skiers to a glacier area, so they could ski downhill to a location to where they could be picked up. The plt landed the wheel/ski equipped acft on upsloping terrain. The visibility was good, except a whiteout phenomena was…